Data Loader Guide

Data Loader
When to Use Data Loader
Install Data Loader
Configure Data Loader
Using Data Loader
Data Types Supported by Data Loader
Export Data from Salesforce
Define Data Loader Field Mappings
Insert, Update, or Delete Data Using Data Loader
Upload Attachments
Upload Files and Links with Data Loader
Review Data Loader Output Files
Data Import Dates
View the Data Loader Log File
Configure the Data Loader Log File
Run in Batch Mode (Windows Only)
Command-Line Quick Start (Windows Only)
Data Loader Third-Party Licenses
PDF

Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

Review Data Loader Output Files

After an import or export, Data Loader generates two CSV output files that contain the results of the operation. One file name begins with success, and the other starts with error. Both files have the extension .csv. Use the Data Loader CSV file viewer to open the files. Specify the folder containing success and error CSV files in the Finish step of an operation.

Export operations don’t generate a success file by default. To generate a success file when exporting data, check Generate status files for exports in the Advanced Settings dialog.

Note

  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 1,000.
  3. To view a specific CSV file, click Open CSV. To view the last success file, click Open Success. To view the last error file, click Open Error.
  4. To open the file in an external program, such as Excel, click Open in External Program.

    The success file contains the successfully loaded records, including a column with the newly generated record IDs. The error file contains the rejected records, with a column that describes why the load failed. If the object you’re exporting has a column named “success” or “error”, your output file columns could display incorrect information. To avoid this problem, rename the columns.

  5. To return to the CSV Chooser window, click Close. To exit the window, click OK. To generate success files when exporting data, select Generate status files for exports.