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 Four: Create the Configuration File

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

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

Note

The process-conf.xml file contains the information that Data Loader needs to process the data. Each <bean> in the process-conf.xml file refers to a single process such as an insert, upsert, export, and so on. Therefore, this file can contain multiple processes. In this step, you edit the file to insert accounts into Salesforce.
  1. Make a copy of the process-conf.xml file from the \samples\conf directory. Be sure to maintain a copy of the original because it contains examples of other types of Data Loader processing such as upserts and exports.
  2. Open the file in a text editor, and replace the contents with the following XML:
    1swfobject.registerObject("clippy.codeblock-0", "9");
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
18<beans>
19    <bean id="accountInsert"
20        class="com.salesforce.dataloader.process.ProcessRunner"
21        singleton="false">
22        <description>accountInsert job gets the account record from the CSV file 
23            and inserts it into Salesforce.</description>
24        <property name="name" value="accountInsert"/>
25        <property name="configOverrideMap">
26            <map>
27                <entry key="sfdc.debugMessages" value="true"/>
28                <entry key="sfdc.debugMessagesFile" 
29                    value="C:\DLTest\Log\accountInsertSoapTrace.log"/>
30                <entry key="sfdc.endpoint" value="https://servername.salesforce.com"/>
31                <entry key="sfdc.username" value="admin@Org.org"/>
32                <!--Password below has been encrypted using key file, 
33                    therefore, it will not work without the key setting: 
34                    process.encryptionKeyFile.
35                    The password is not a valid encrypted value, 
36                    please generate the real value using the encrypt.bat utility -->
37                <entry key="sfdc.password" value="e8a68b73992a7a54"/>
38                <entry key="process.encryptionKeyFile" 
39                    value="C:\DLTest\Command Line\Config\key.txt"/>
40                <entry key="sfdc.timeoutSecs" value="600"/>
41                <entry key="sfdc.loadBatchSize" value="200"/>
42                <entry key="sfdc.entity" value="Account"/>
43                <entry key="process.operation" value="insert"/>
44                <entry key="process.mappingFile" 
45                    value="C:\DLTest\Command Line\Config\accountInsertMap.sdl"/>
46                <entry key="dataAccess.name" 
47                    value="C:\DLTest\In\insertAccounts.csv"/>
48                <entry key="process.outputSuccess" 
49                    value="c:\DLTest\Log\accountInsert_success.csv"/>
50                <entry key="process.outputError" 
51                    value="c:\DLTest\Log\accountInsert_error.csv"/>
52                <entry key="dataAccess.type" value="csvRead"/>
53                <entry key="process.initialLastRunDate" 
54                    value="2005-12-01T00:00:00.000-0800"/>
55            </map>
56        </property>
57    </bean>
58</beans>
  3. Modify the following parameters in the process-conf.xml file. For more information about the process configuration parameters, see Data Loader Process Configuration Parameters.
    • sfdc.endpoint—Enter the URL of the Salesforce instance for your organization; for example, https://na1.salesforce.com.
    • sfdc.username—Enter the username Data Loader uses to log in.
    • sfdc.password—Enter the encrypted password value that you created in step 2.
    • process.mappingFile—Enter the path and file name of the mapping file.
    • dataAccess.Name—Enter the path and file name of the data file that contains the accounts that you want to import.
    • sfdc.debugMessages—Currently set to true for troubleshooting. Set this to false after your import is up and running.
    • sfdc.debugMessagesFile—Enter the path and file name of the command line log file.
    • process.outputSuccess—Enter the path and file name of the success log file.
    • process.outputError—Enter the path and file name of the error log file.

    Use caution when using different XML editors to edit the process-conf.xml file. Some editors add XML tags to the beginning and end of the file, which causes the import to fail.

    Warning