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.