Options for handling errors during file import

Article Number:040839

If a row with an error is detected in a file you are importing, it can be handled in either of the following ways.

  • Continue importing (Only rows with errors will be skipped)
  • Stop importing (No rows after the first error will be imported)

You can select either option on the "Import from File" screen.
The following sections give details on both of these options and how your file will be imported when each is selected.

Continue importing (Only rows with errors will be skipped)

When this option is selected, any rows in your file with errors will be skipped, and the rest of the rows in your file will be imported.
If your file contains multiple rows of data with errors, they will all be detected.

How to check the error details

The rows that were not imported are output to a CSV file that also contains the details of the errors that occurred.
If your file contains multiple rows of data with errors, they will all be listed and detailed in the CSV file.

About the records that will be created in your app

Only the data in your file that could be imported will be used to create and/or update records in your app.
For this reason, the order in which new records are added to your app may differ from the row order in your file if any rows were skipped due to errors.

Stop importing (No rows after the first error will be imported)

When this option is selected, importing will stop if an error is detected, and only the data that comes before the first error will be imported.
If your file contains multiple rows of data with errors, only the first error will be detected.

How to check the error details

The first row in which an error was detected and all of the rows that come after it are output to a CSV file.
The details of the first error are described in the file, but the rows that come after it will all be displayed with the following message.

"Data import was stopped either because an error occurred before this row in the imported file, or because the import process was canceled."

For this reason, even if your CSV file contains multiple errors, it cannot be used to check all error details.

About the records that will be created in your app

The rows in your file that come before the first error that was detected will be imported.
This means that new records will be added to your app in the same order as the rows in your file.