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 Command Line 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 and Lightning Experience
Available in: Enterprise, Performance, Unlimited, Developer, and Database.com 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.

    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