Data Loader Guide

Clouds with binary code floating aboveCloud with binary code floating above

No Results

Search Tips:

  • Please consider misspellings
  • Try different search keywords
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Reviewing Output Files

Available in: Enterprise, Performance, Unlimited, Developer, and Database.com Editions

After every import or export, Data Loader generates two CSV output files that contain the results of the operation. One file name starts with “success,” while the other starts with “error.” During every export, Data Loader saves the extracted data to a CSV file that you specify in the wizard. Data Loader has a built-in CSV file viewer with which you can open and view these files.

To view output files from a Data Loader operation:

  1. Choose View | View CSV.
  2. Specify the number of rows to view. Each row in the CSV file corresponds to one Salesforce record. The default is 1000.
  3. To view a CSV file of your choice, click Open CSV. To view the last success file, click Open Success. To view the last error file, click Open Error. The CSV file opens in a new window.
  4. Optionally, click Open in External Program to open the file in the associated external program, such as Microsoft® Office Excel.

    The “success” file contains all of the records that were successfully loaded. In this file, there's a column for the newly generated record IDs. The “error” file contains all of the records that were rejected from the load operation. In this file, there's a column that describes why the load failed.

  5. Click Close to return to the CSV Chooser window, and then click OK to exit the window.

To generate success files when exporting data, select the Generate status files for exports setting. For more information, see Configuring Data Loader.

Note