How to Import Data › How to Import Data › Review the Import Log File - Best Practices

Review the Import Log File - Best Practices

The Data Importer log file contains information and error messages regarding the processing of import jobs. To help you understand the results of your import and to troubleshoot any errors, use the information in this log file. This section contains some recommended best practices for working with the Data Importer log file.

Match the row number in the data file with the error message in the log file.

A log file error message identifies the corresponding row number from your data file. You can also find the data file row number in the row above or below the error message in the log file.

Sometimes the error message in the log file does not show the data file row number. In this situation, the actual data file values are shown immediately after the error message in the log file.

Count the number of error messages in your log file.

1. Search for the following phrases in your log file to find the error messages in the file. These phrases are included with the error messages.

   Web Service threw exception
   

   Error at record
   

2. After you find a type of error message, search for that error in the log file and count the number of occurrences.
3. Identify and search for more error types that appear in your log file and count the number of occurrences.
4. Compare the count of all errors in your log file with the statistics that the Data Importer generated for the associated import. To view these statistics, click Status Message on the Associated Jobs list or Import Jobs list. This comparison helps you account for all relevant errors and identify error messages that are not valid and can be ignored.