Data Import Error Handling
If the Data Import Wizard prescan process returns errors, you can select the Ignore Errors check box to ignore them and continue importing only those records without errors. However, if the prescan reveals errors involving records that you need to import, you must resolve the errors in order to proceed.
You can do so by manually repairing the records in the data file and rerunning the wizard, or you can click the Back button to return to the column mapping page and either clear the mapping for columns that returned errors or map them to another field. However, if you want to import all the data as originally mapped, you need to repair the records in the data file.
To make the task of repairing the data file simpler, the prescan result page displays the erroneous data along with row numbers and error descriptions to help you find each problem record in your original data file and correct the issue that led to the error. To view the complete list of errors in a text editor or spreadsheet program, click the Open CSV File button next to the record count.
The CSV file can also be accessed locally from the staging directory defined on the initial screen of the wizard. For most Windows operating systems, the default location is C:/Documents and Settings/<username>/My Documents/My Imports/. For Windows 7, the default location is C:/users/<username>/My Documents/My Imports/.
- <data_file_name>.bad.csv contains all records that returned an error during the prescan process.
- <data_file_name>.good.csv contains all records that did not return an error.
- <data_file_name>.badaux.csv and <data_file_name>.goodaux.csv contain diagnostic information that can be provided to support for troubleshooting errors.
After the data file is repaired, you can start the import procedure again and the errors that were addressed in the previous prescreen process should no longer occur.
In rare instances, an error may occur during import that was not detected during the prescan process. If you selected the Stop Import on Error check box on the initial screen of the wizard, the import status changes to Import Error and the process stops to prevent further records from being imported. If the Stop Import on Error check box is cleared (the default setting), the import continues despite any error and only records without errors are imported.