Data Loader Guide

Data Loader
When to Use Data Loader
Using Data Loader
Running in Batch Mode (Windows Only)
Command-Line Quick Start (Windows Only)
Data Loader Introduction
Prerequisites
Step One: Create the Encryption Key
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

Newer Version Available

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

Step Three: Create the Field Mapping File

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

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

Note

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.
    1#Mapping values
2#Thu May 26 16:19:33 GMT 2011
3Name=Name
4NumberOfEmployees=NumberOfEmployees
5Industry=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. This is done on the Mapping dialog box by clicking Save Mapping.

    Tip