5Import Queues

This chapter contains the following:

The Manage Imports page of the Import Queue tab shows the following four types of import queues as infotiles:

  • All Imports: This infotile displays the count of active, completed, and unsuccessful imports submitted by all users. Click on this infotile to see a list of all import jobs.

  • Active Imports: This infotile displays the count of all import jobs submitted that are either in progress or in queued status. Click on this infotile to see a list of active import jobs.

  • My Completed Imports: This infotile displays the count of imports submitted by the current user that are completed (either successful or failed with warnings or errors). Click on this infotile to see a list of completed import jobs created by the current user.

  • Unsuccessful Imports: This infotile displays the count of unsuccessful imports submitted by all users. Click on this infotile to see a list of unsuccessful import jobs.

By default, you can see the imports submitted in the last 7 days. However, you can configure the number of days of imports to show, by setting the value of the profile option ZCA_IMPORT_PURGING_DURATION.

Import Activities Details

Click on the infotiles to see the following details about the import job:

Column Description

Name

The name of the import job.

File Name

The name of the source file.

Object

The object imported.

Status

The status of the import job. For more information about the statuses, see the topic How You Monitor Your Import Activities in the related topics section.

Cancel Job

Click the close icon to cancel an active import, if it's running for a long time. Canceling the import job commits the data processed till that point and leaves the application in a clean state.

Start Time

The start date and time of the import.

End Time

The end date and time of the import.

Submitted By

The user who submitted the import.

You can filter the list by clicking on any of these columns.

This topic explains how to monitor all 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 Generating the Diagnostics Log for Import: Procedure 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.

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.

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. You can download these 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.