Step Three: Create the Field Mapping File

The field mapping file associates data sources with destinations. This is a text file, typically with an .sdl file extension.

1. Copy the following to a text file and save it with a name of accountInsertMap.sdl. This is a data insert, so the data source is on the left of the equals sign and the destination field is on the right.
   1swfobject.registerObject("clippy.codeblock-0", "9");
   2
   3
   4
   5
   6
   7
   8
   9
   10
   11
   12
   13
   14
   15
   16
   17#Mapping values
   18#Thu May 26 16:19:33 GMT 2011
   19Name=Name
   20NumberOfEmployees=NumberOfEmployees
   21Industry=Industry
   22

   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. This is done on the Mapping dialog box by clicking Save Mapping.

   Tip