Troubleshooting failed imports and checking import job status
Key Takeaway
Check a Data Import Wizard job in the Recent Import Jobs chart or the status email, and check a Data Loader operation in its success and error CSV log files.
A Salesforce import job runs in the background, so you need to know where to check its progress and how to find out why some records did not load. The Data Import Wizard and Data Loader report results in different ways. Most failed records come from validation rules, field access or field mapping, and file format or file size.
Where to check a Data Import Wizard job
Data Import Wizard imports run asynchronously: the file goes into a controlled queue and loads when the system can best handle the data. How long an import takes depends on how much data you import. It can take up to several minutes, but an org import doesn't take longer than 24 hours.
You can check a Data Import Wizard job in these places:
- The Recent Import Jobs chart on the Data Import Wizard home page lists the status and metrics of the import.
- The Bulk Data Load Jobs page is in Setup: enter "Bulk Data Load Jobs" in the Quick Find box and select Bulk Data Load Jobs. Only administrators can open this page. This page isn't available in Professional Edition.
- The user who starts the import receives a status email when the import is complete. That user should then review the results and resolve any errors.
A user who isn't an administrator checks an import by reading the status email or by monitoring the relevant tabs in Salesforce.