Data Loader Guide

Data Loader
When to Use Data Loader
Install Data Loader
Configure Data Loader
Using Data Loader
Run in Batch Mode (Windows Only)
Command-Line Quick Start (Windows Only)
Data Loader Command Line Introduction
Prerequisites
Step One: Create the Encryption Key File
Step Two: Create the Encrypted Password
Step Three: Create the Field Mapping File
Step Four: Create the Configuration File
Step Five: Import the Data
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.

Step Three: Create the Field Mapping File

In this step, you create a mapping file with an .sdl file extension. In each line of the mapping file, pair a data source with its destination.

The Data Loader command-line interface is supported for Windows only.

Note

Copy the following to a text file and save it with a name of accountInsertMap.sdl. This code is a data insert, so the data source is on the left of the equals sign and the destination field is on the right. 
1#Mapping values
2              #Thu May 26 16:19:33 GMT 2011
3              Name=Name
4              NumberOfEmployees=NumberOfEmployees
5              Industry=Industry

For complex mappings, you can use the Data Loader user interface to map source and destination fields and then save those mappings to an .sdl file. It’s done on the Mapping dialog box by clicking Save Mapping.