padminisfdc

A topnotch WordPress.com 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\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”&gt;

<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″/&gt;

<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

Advertisements