Data Loader Guide

Data Loader
When to Use Data Loader
Installing Data Loader
Configure Data Loader
Using Data Loader
Running 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

Newer Version Available

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

Step Three: Create the Field Mapping File

Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience
Available in: Enterprise, Performance, Unlimited, and Developer editions

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

Note

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.

  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