Checking CSV Import Status

You can check the status of an import job on the Job Status page. For details, see Viewing the CSV Import Job Status Page.

After your import job finishes, you’ll get an email at the address you used to log in. The email tells you the status, how many records were imported, and how many weren’t. For details, see CSV Import Email Notifications.

Viewing the CSV Import Job Status Page

To see the Job Status page, go to Setup > Import/Export > View CSV Import Status.

For each import, the Job Status page shows:

• The date the import was started.

• The import job name, by default: <import type> -<CSV file name> -<your email address>. Scripted imports can use a different name.

• The current status: Pending, Processing, Completed, or Canceled.

  There’s also a less common Retry status, which occurs if the import stops because of an infrastructure issue. When that’s fixed, the import usually starts again from where it stopped.

• Percentage of the import that is complete.

• A message showing how many records were imported out of the total (For example, “200 records of 205 imported”).

• (If your account uses multiple queues:) The queue number (1-5) for the job. The default is 1, but you can change it in Step Two Import Options of the Import Assistant. See also Queue Number.

• For pending and processing jobs, there’s a Cancel link. Administrators can cancel any job, but other users can only cancel their own.

• For completed and canceled jobs, a link to a results.csv file that includes any records not processed due to errors or cancellation.

  • The results.csv file lets you fix errors and rerun the import for any records that didn’t go through. See Post Processing Errors.

  • Anyone with access to the Job Status page can see all import jobs, but most users can only download results.csv files for their own jobs. Only administrators can get results.csv files for other users’ jobs.

  • The CSV response also tells you if an afterSubmit script fails after the import. If that happens, the records are still created or updated. You only need to retry the user event script, not the whole import. For more information, see AfterSubmit Script failed, record created with internalId xxx.

CSV import job statuses are stored for 30 days and for up to a maximum of 1,000,000 jobs. Import jobs that occurred more than 30 days ago, or which exceed this number of jobs, are eventually purged. Note that this purging can be delayed for technical reasons, so it is possible to see jobs older than 30 days on the status page.

You can’t manually delete jobs from the status page.

CSV Import Email Notifications

For every CSV import job, you’ll get an email at the address you used to log in. Each email has text like the following:

The number of records not imported includes any records with errors for which import failed. If the import job was canceled during processing, this number also includes any records that had not yet been processed at the time of cancellation.

General Notices