This batch process is used for uploading a list from a flat file. Allows user to specify that only the Nth record should be loaded into the list which will be created by this process. It is possible that the flat file contains 5000 records, but the user wants only a sampling of these records. As of 7.4.2, this process looks at the CUSTOMER_ID_LENGTH application parameter and supports Master Customer IDs with the number of characters defined for the parameter.
As of 7.4.2, if the creation method is CUS_IMPORT, then MKT500 will expect a CSV file containing Master Customer ID and Sub Customer ID. Additionally, the CSV file should not have any header or any enclosure characters in it. MKT500 won't be looking at the file mapping defined at List category, although List source is still a required field on the Marketing and Communication List Maintenance (MKT002) screen.
This batch process is also launched when the user clicks Load List from the Marketing and Communication List Maintenance (MKT002) screen. For more information, please see Creating and Maintaining Marketing Lists.
If
the MKT500 process fails, please make sure that the <TRSInputPath>\\PATH\HERE</TRSInputPath>
setting in the TimssInterfaceConfig.xml file for the Interface Service
is correct and the <UploadRoot Name="TRSInputFile"
Path="\\PATH\HERE"/> in the ServerConfig column of
the T_##_AppInstance table of the PIDB database for the environment is
correct.
As
of 7.4.1SP1, the MKT500 batch process only considers the first 80 characters
and excludes the remaining characters, as the MKT_Prospect and Customer
table stores only 80 characters in the Search_Name Column.
|
