- 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\salesforce.com\Data Loader\bin
Create an encryption key by entering the following command. Replace <seedtext> with any string.
C:\Program Files\salesforce.com\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\salesforce.com\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.
<!DOCTYPE beans PUBLIC “-//SPRING//DTD BEAN//EN” “http://www.springframework.org/dtd/spring-beans.dtd”>
<beans>
<bean id=”accountInsert” class=”com.salesforce.dataloader.process.ProcessRunner” singleton=”false”>
<property name=”name” value=”accountInsert”/>
<property name=”configOverrideMap”>
<map>
<entry key=”sfdc.debugMessages” value=”true”/>
<entry key=”sfdc.endpoint” value=”https://login.salesforce.com/services/Soap/u/26.0″/>
<entry key=”sfdc.username” value=”padmini.sidigonde@gmail.com”/>
<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=”172.28.0.12″/>
<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=”dataAccess.name” 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″/>
</map>
</property>
</bean>
</beans>
5. Execute the File
C:\Program Files\salesforce.com\Data Loader\bin>process.bat “C:\DLTest\Command L
ine\Config” accountInsert