(Import Processes in the case of multi CSV files)
• Import Activity Progress
• Process Log
Files Processed
The Files Processed section displays a row for each source file that is processed, in the case of single CSV files. The import processing details are summarized and displayed for each source file and include the following:
File Processing Summary Information Description
Records Read From File
The number of rows in the CSV file.
Records Uploaded with Format Errors
The number of records that were uploaded with formaterrors when processing data to insert into the interface tables from the source file. View the error details in the Exception and Error files attached to the process.
Records Failed with Errors
The number of records that failed with errors whenimporting data from the interface tables to the destination application tables. View the error details in the Exception and Error files attached to the process.
File Processing Summary Information Description
Records Uploaded Successfully
The number of import object records that were importedto the application destination tables. If the import object is made up of multiple components, each component is counted as successfully loaded. Consequently the Successfully Loaded count may be larger than the Records Read From File count. View the successful record details in the Log file attached to the process.
Records Uploaded With Warnings
The number of records that were uploaded withwarnings when importing data from the interface tables to the destination application tables.
Attachments
Once an Import Activity process has completed,processing reports are included in the Attachments
column. This column will display the log file in case of successful import, and error and exception file in case of failure. The Log file includes the records that were successfully imported plus the unique destination application table identifiers for the objects. The Exception file includes a row for each record that failed. All the errors for that row are concatenated and displayed in the Error Message column of the file. The Error file includes all the errors for each record that failed validation. In the event that log generation was not completed for an import activity, you can click the
Generate Log link to generate the import log files. Once the request is submitted, you will get a confirmation message. The Generate Log link is displayed in the
Attachments column.
The following are the contents of each file:
• Log files contain records that were successfully imported plus the unique destination application table identifiers for the objects.
• Exception files include a row for each record that failed. All the errors for that row are concatenated and displayed in the Error Message column of the file.
• Error files include all the errors for each record that failed validation.
In the case of multi CSV files, the Import Processes section displays a row for each source file that is processed.
File Processing Summary Information Description
Records Read From File
File Processing Summary Information Description
Records Uploaded with Format Errors
The number of records that were uploaded with formaterrors when processing data to insert into the interface tables from the source file. View the error details in the Exception and Error files attached to the process.
Records Failed with Errors
The number of records that failed with errors whenimporting data from the interface tables to the destination application tables. View the error details in the Exception and Error files attached to the process.
Records Uploaded Successfully
The number of import object records that were importedto the application destination tables. If the import object is made up of multiple components, each component is counted as successfully loaded. Consequently the Successfully Loaded count may be larger than the Records Read From File count. View the successful record details in the Log file attached to the process.
Rejected Data File
The data files that were rejected due to format errors.
Error File
Once an Import Activity process has completed, errorfiles are included in the Error File column. This column will display error and exception files in case of failure, and will be blank in case of successful import. The Exception file includes a row for each record that failed. All the errors for that row are concatenated and displayed in the Error Message column of the file. The Error file includes all the errors for each record that failed validation.
In the event that log generation was not completed for an import activity, you can click the Generate Log link to generate the import log files. Once the request is submitted, you will get a confirmation message. The
Generate Log link is displayed in the Error File column. The following are the contents of each file:
• Exception files include a row for each record that failed. All the errors for that row are concatenated and displayed in the Error Message column of the file.
• Error files include all the errors for each record that failed validation.
Records Uploaded With Warnings
The number of records that were uploaded withwarnings when importing data from the interface tables to the destination application tables.
Note
In the files that are generated after the completion of an import activity, all error message values are enclosed within double quotes. The use of double quotes improves the format of the log files by ensuring that the error messages containing commas are not treated as multiple values.