Skip to content

Instantly share code, notes, and snippets.

@Sunil02kumar
Created June 14, 2016 08:51
Show Gist options
  • Save Sunil02kumar/11d4c925a74aaebe6efeebfaab13067e to your computer and use it in GitHub Desktop.
Save Sunil02kumar/11d4c925a74aaebe6efeebfaab13067e to your computer and use it in GitHub Desktop.
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<!-- inserting accounts command: process "E:\Data Loader Demo" accountInsert -->
<bean id="accountInsert"
class="com.salesforce.dataloader.process.ProcessRunner"
singleton="false">
<description>inserting Account from csv files</description>
<property name="name" value="accountInsert"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
<entry key="sfdc.username" value="sunil02kumar@gmail.com"/>
<!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
<entry key="sfdc.password" value="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx6c75bb5c73f60175181c7aa5d1441aee65c"/>
<entry key="process.encryptionKeyFile" value="E:\Data Loader Demo\keyToEncrypt.txt"/>
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Account"/>
<entry key="process.operation" value="insert"/>
<entry key="process.mappingFile" value="E:\Data Loader Demo\Mapping files\accountInsertMap.sdl"/>
<entry key="dataAccess.name" value="E:\Data Loader Demo\Account data\insertAccounts.csv"/>
<entry key="process.outputSuccess" value="E:\Data Loader Demo\Log files\accountInsert_success.csv"/>
<entry key="process.outputError" value="E:\Data Loader Demo\Log files\accountInsert_error.csv"/>
<entry key="dataAccess.type" value="csvRead"/>
<entry key="process.initialLastRunDate" value="2006-12-01T00:00:00.000-0800"/>
</map>
</property>
</bean>
<!--if we specify mapping file while exporting then it will extract only those fields mention in mapping file -->
<!--if we do not specify mapping file then it will extract all fields specified in query -->
<!-- command: process "E:\Data Loader Demo" csvAccountExtractProcess -->
<bean id="csvAccountExtractProcess"
class="com.salesforce.dataloader.process.ProcessRunner"
singleton="false">
<description>csvAccountExtract job gets account info from salesforce and saves info into a CSV file."</description>
<property name="name" value="csvAccountExtractProcess"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="false"/>
<entry key="sfdc.debugMessagesFile" value="c:\dataloader\samples\status\sfdcSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
<entry key="sfdc.username" value="sunil02kumar@gmail.com"/>
<!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
<entry key="sfdc.password" value="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx6c75bb5c73f60175181c7aa5d1441aee65c"/>
<entry key="process.encryptionKeyFile" value="E:\Data Loader Demo\keyToEncrypt.txt"/>
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Account"/>
<entry key="sfdc.extractionRequestSize" value="500"/>
<entry key="sfdc.extractionSOQL" value="Select Id, Name, ParentId, Phone,Industry FROM Account where Phone='9790750361' AND Industry='Textile'"/>
<entry key="process.operation" value="extract"/>
<!-- <entry key="process.mappingFile" value="c:\dataloader\samples\conf\accountExtractMap.sdl"/> -->
<entry key="dataAccess.type" value="csvWrite"/>
<entry key="dataAccess.name" value="E:\Data Loader Demo\extracted Accounts\extractAccounts.csv"/>
<!--<entry key="process.outputSuccess" value="E:\Data Loader Demo\Log files\accountexport_success.csv"/>
<entry key="process.outputError" value="E:\Data Loader Demo\Log files\accountexport_error.csv"/> -->
</map>
</property>
</bean>
<!--deleting extracted records command: process "E:\Data Loader Demo" AccountDeleteProcess -->
<bean id="AccountDeleteProcess"
class="com.salesforce.dataloader.process.ProcessRunner"
singleton="false">
<description>Delete account with exported file"</description>
<property name="name" value="AccountDeleteProcess"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="false"/>
<entry key="sfdc.debugMessagesFile" value="c:\dataloader\samples\status\sfdcSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
<entry key="sfdc.username" value="sunil02kumar@gmail.com"/>
<!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
<entry key="sfdc.password" value="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx6c75bb5c73f60175181c7aa5d1441aee65c"/>
<entry key="process.encryptionKeyFile" value="E:\Data Loader Demo\keyToEncrypt.txt"/>
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Account"/>
<entry key="process.operation" value="delete"/>
<entry key="process.mappingFile" value="E:\Data Loader Demo\Mapping files\accountDeleteMap.sdl"/>
<entry key="dataAccess.type" value="csvRead"/>
<entry key="dataAccess.name" value="E:\Data Loader Demo\extracted Accounts\extractAccounts.csv"/>
<entry key="process.outputSuccess" value="E:\Data Loader Demo\Log files\accountdelete_success.csv"/>
<entry key="process.outputError" value="E:\Data Loader Demo\Log files\accountdelete_error.csv"/>
</map>
</property>
</bean>
</beans>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment