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 an import job has been processed, an email notification is sent to the email address used to log in when the import was initiated. This email provides the status of the import, the number of CSV file records imported successfully, and the number of records not imported. For details, see CSV Import Email Notifications.

Viewing the CSV Import Job Status Page

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

For each import, the Job Status page includes the following details:

• Date the import was initiated.

• Job name for the import: defaults to <import type> -<CSV file name> -<email address of logged in user>. (Scripted imports can optionally set another name.)

• Current status of the import: Pending, Processing, Completed, or Canceled.

  There is also a less common Retry status. This status occurs when CSV import processing is stopped due to an infrastructure issue. Typically when the issue is resolved, the import should automatically start again from the point of stoppage.

• Percentage of the import that is complete.

• A message indicating the number of records imported of the total number of records in the CSV files (For example, “200 records of 205 imported”).

• (In accounts that support the use of multiple queues for imports:) A queue number indicating the queue (1-5) to which the job has been assigned. (Default is 1; this default can be changed on the Step Two Import Options page of the Import Assistant. See Queue Number.)

• For pending and processing jobs, a Cancel link. (For administrators, this link is available for all pending and processing imports. For other users, this link is available only for their own pending and processing imports.)

• 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 provides an opportunity to correct errors and rerun the import for the outstanding records. See Post Processing Errors.

  • Note that users with access to the Job Status page can view the status of all import jobs in the company queue, but most users can only access results.csv files for their own import jobs. Only account administrators can access results.csv files for other users' jobs.

  • The CSV response also indicates if an afterSubmit script fails after a CSV import is finished. If an afterSubmit script runs after a CSV import and the script fails, the records are still created or updated in NetSuite. In this case, you only need to retry the user event script, but should not run the CSV import again. 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.

It is not possible to manually delete jobs listed on the status page.

CSV Import Email Notifications

For every CSV import job that is processed, an email is sent to the email address used to log in to NetSuite when the import was initiated. 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