A topnotch site

Leave a comment

Data is importing in salesforce by using commandline dataloader

  1. Create the Encryption Key:

Open a command prompt window by clicking Start > All Programs > Accessories > Command Prompt. Alternatively, you can click Start > Run, enter cmd in the Open field, and click OK.

C:\cd Program Files\\Data Loader\bin

Create an encryption key by entering the following command. Replace <seedtext> with any string.

C:\Program Files\\Data Loader\bin>encrypt.bat –g seedtext

Copy the generated key from the command window to a text file named key.txt and make a note of the file path. In this example, the generated key is 54813d82a954b1b8.

2.Create the Encrypted Password:

In the same command prompt window, enter the following command. Replace <password> with the password that Data Loader uses to log in to Salesforce. Replace <filepath> with the file path to the key.txt file that you created in the previous step.

encrypt.bat –e <password> “<filepath>\key.txt”

C:\Program Files\\Data Loader\bin>encrypt.bat –e tulasi12289gFkRnCZcgcGEfwlYxIWX1Dd  “C:\DLTest\Command Line\Config\key.txt

3.Create the Field Mapping File:

Copy the following to a text file and save it with a name of accountInsertMap.sdl. This is a data insert so the datasource is on the left of the equals sign and the destination field is on the right.

4.Create the Configuration File:

                       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 inserting.




<bean id=”accountInsert” class=”com.salesforce.dataloader.process.ProcessRunner” singleton=”false”>

<property name=”name” value=”accountInsert”/>

<property name=”configOverrideMap”>


<entry key=”sfdc.debugMessages” value=”true”/>

<entry key=”sfdc.endpoint” value=”″/&gt;

<entry key=”sfdc.username” value=””/>

<entry    key=”sfdc.password” value=”aace3fe2aea691559a525e45120a655d2b66165248cacd618e1f361ebd496132bad85b8a140359ac”/>

<entry     key=”process.encryptionKeyFile” value=”C:\DLTest\Command Line\Config\key.txt”/>

<entry key=”sfdc.timeoutSecs” value=”600″/>

<entry key=”sfdc.loadBatchSize” value=”200″/>

<entry key=”sfdc.entity” value=”Account”/>

<entry key=”sfdc.proxyHost” value=”″/>

<entry key=”sfdc.proxyPort” value=”8002″/>

<entry key=”process.operation” value=”insert”/>

<entry key=”process.mappingFile”           value=”C:\DLTest\Command Line\Config\accountInsertMap.sdl”/>

<entry            key=””     value=”C:\DLTest\Command Line\Config\accountInsert.csv”/>

<entry key=”dataAccess.type” value=”csvRead”/>

<entry key=”process.initialLastRunDate” value=”2005-12-01T00:00:00.000-0800″/>





 5. Execute the File

C:\Program Files\\Data Loader\bin>process.bat “C:\DLTest\Command L

ine\Config” accountInsert