How do I monitor import activities?

You can monitor imports that were scheduled to run, have completed successfully, or have failed with errors. For each import, you can view the details and make the necessary updates for any failed records that you want to import again.

You can view the list of imports from the Manage Imports page of the Import Queue tab. To view the status of an import job click the link in the import's Name column. The Import Status page shows the status of the most recently executed instance of the import. The Import Status page contains the following sections:

Status Bar
Details
Import Attachments

Status Bar

The status bar shows the progress of the import in a graphical format. It shows the following stages during the import process:

Import activity queued: The import request is queued for processing, and is waiting to begin execution.
Preparing data for import: The data from the source file are being loaded in the temporary staging table for further processing.
Importing data: The data from the source file are being validated and loaded in the target tables.
Completing import activity: The import data have been loaded in the target tables, and cleanup tasks, such as the generation of log files, are in progress.
Completed with errors: The import has completed with errors.
Successful: The import has completed successfully.
Completed with warnings: The import has completed with warnings.
Canceled: The import was canceled by the user.
Unsuccessful: The import was unsuccessful.

Hovering your mouse over the progress bar shows the status on the number of records imported.

Note: If the job is in the same status for a long time, then generate a diagnostic log as described in the topic Generate the Diagnostics Log for Import in Related Topics section. When you raise a service request, attach the diagnostic log files to help technical support to resolve the issue.

Activity and Record Details

The Activity Details section shows the name of the import, import activity identifier, object name, and the name of the user who submitted the import. The section on date and time displays the start and end times, estimated completion time, and the time taken to complete the import.

The Record Details section displays the number of import records in each stage of processing. The various status details are summarized in the following table:

File Processing Summary Information	Description
Records Read From File	The number of records read from the source file. Clicking the link for the number of records lets you download the spreadsheet file with the records.
Records Loaded Successfully	The number of import object records that were imported to the application destination tables.
Records With Errors Reported	The number of records that failed with errors when importing data from the interface tables to the destination tables. You can view the error details in the Exception and Error files attached to the process. Clicking the link for the number of records lets you download the spreadsheet file with the error records.
Records With Warnings	The number of records that were uploaded with warnings when importing data from the interface tables to the destination application tables. Clicking the link for the number of records lets you download the spreadsheet file with the warning records.
Unprocessed	The number of records that weren't processed.

Clicking on the Advanced Options section shows the advanced configuration options that you had selected when creating the import activity.

The rejected file records don't contain the error message when import job ends in unsuccessful status.

Note: In the files that are generated after the completion of an import activity, all error message values are enclosed within double quotation marks. The use of double quotation marks improves the format of the log files by ensuring that the error messages containing commas aren't treated as multiple values.

Detailed Import Status

The Detailed Import Status page shows the status of the different steps in the import activity. You can navigate to this page by selecting View Detailed Import Status from the Actions menu on the Status page. For each step, this page shows the individual sub tasks of the import process. This information helps the technical support team to fix any issues during the import.

Purge Import Data

Import Management periodically runs an automatic process that purges all data associated with import jobs. This process purges data older than 7 days by default. You can extend this time to 30 days by setting the value in the profile option ZCA_IMPORT_PURGING_DURATION.

If you wish for the data to be purged instantaneously on job completion, you can do the same using the ZCA_IMPORT_PURGE_ON_JOBCOMPLETION profile option. The default value for this profile option is Y and impacts data for all objects except the ones registered as 'ObjectPostProcess'

Alternately, if you want to control purging through the UI from the Import Object Details Page, you can set the ZCA_IMPORT_PURGE_FROM_UI profile option to Y to display the purge option on the Import Object Details page.

Import Attachments

The Import Attachments section lists the files associated with this import in a table. The Actions column lets you either download the file or view more details. Success log file isn't generated after the import job is completed successfully. To generate success logs for even successfully completed jobs, set the profile option ZCA_IMPORT_SUPPRESS_SUCCESSLOG_GENERATION to 'No'. You can download the following files from this section:

Process Log: Click Action > Generate Log.
Diagnostics Log file: Click Action > Generate Diagnostics.
Map file: Click the Download link to download the import activity map file in CSV format.
Source CSV file used for the import.
Exception files that 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 file that includes all the errors for each record that failed validation.