Data Loader Guide

Data Loader
When to Use Data Loader
Install Data Loader
Configure Data Loader
Using Data Loader
Run 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

Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

Step One: Create the Encryption Key File

When you use Data Loader from the command line, there's no user interface. Therefore, you provide the information that you enter in the user interface in a text file named process-conf.xml. For example, you add the username and password that Data Loader uses to log in to Salesforce.

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

Note

The password must be encrypted before you add it to the process-conf.xml file, and creating the key is the first step in that process.

Note

  1. Open a command prompt window by selecting Start | All Programs | Accessories | Command Prompt. Alternatively, you can click Start | Run, enter cmd in the Open field, and click OK.
  2. In the command window, enter cd\ to navigate to the root directory of the drive where Data Loader is installed.
  3. Navigate to the Data Loader \bin directory by entering this command. Replace the file path with the path from your system.

    C:\Users\{userName}\dataloader\version\bin

  4. Create an encryption key file by entering the following command. Replace [path to key file] with the key file path.

    encrypt.bat —k [path to key file]

    For example:

    1C:\Users\jjang\Dataloader\v45\bin>encrypt.bat -k
2  Keyfile "C:\Users\jjang\.dataloader\dataloader.key" was created!
3  C:\Users\jjang\Dataloader\v45\bin>

    To see a list of command-line options for encrypt.bat, enter encrypt.bat on the command line.

    Note

  5. Note the key file path. In this example, the path is C:\Users\{userName}\.dataloader\dataLoader.key.

The encryption utility encrypts passwords but not data. HTTPS with TLS 1.0 or later encrypts data transmitted by the Apex Data Loader.