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 Interface
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 Five: Import the Data

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

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

Note

User Permissions Needed
To insert records: “Create” on the record
To update records: “Edit” on the record
To upsert records: “Create” or “Edit” on the record
To delete records: “Delete” on the record
To hard delete records: “Delete” on the record

Now that all the pieces are in place, you can run Data Loader from the command line and insert some new accounts.

  1. Copy the following data to a file name accountInsert.csv. This is the account data that you import into your organization.
    1swfobject.registerObject("clippy.codeblock-0", "9");
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17Name,Industry,NumberOfEmployees
18Dickenson plc,Consulting,120
19GenePoint,Biotechnology,265
20Express Logistics and Transport,Transportation,12300
21Grand Hotels & Resorts Ltd,Hospitality,5600
22
  2. In the command prompt window, enter the following command:

    process.bat "<file path to process-conf.xml>" <process name>

    • Replace <file path to process-conf.xml> with the path to the directory containing process-conf.xml.
    • Replace <process name> with the process specified in process-conf.xml.

    Your command should look something like this:

    process.bat "C:\DLTest\Command Line\Config" accountInsert

    After the process runs, the command prompt window displays success and error messages. You can also check the log files: insertAccounts_success.csv and insertAccounts_error.csv. After the process runs successfully, the insertAccounts_success.csv file contains the records that you imported, along with the ID and status of each record. For more information about the status files, see Reviewing Data Loader Output Files.