function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
dp_derekdp_derek 

Unable to update records using the Data Loader command line

Hi,everone! 

I want to update records from oracle to salesforce.

Please help me !!!

Thanks a lot !!!

 

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="accountUpdate" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false">
<description>
accountInsert job gets the account record from the CSV file and inserts it into Salesforce.
</description>
<property name="name" value="accountUpdate"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="true"/>
<entry key="sfdc.debugMessagesFile" value="C:\DLTest\Log\accountInsertSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://login.salesforce.com/services/Soap/u/25.0"/>
<entry key="sfdc.username" value=***@***/>
<entry key="sfdc.password" value="*************************"/>
<entry key="process.encryptionKeyFile" value="C:\DLTest\key.txt"/>
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Account"/>
<entry key="process.operation" value="update"/>
<entry key="process.mappingFile" value="C:\DLTest\accountUpdateMap.sdl"/>
<entry key="dataAccess.name" value="updateAccounts"/>
<entry key="process.outputSuccess" value="c:\DLTest\Log\accountInsert_success.csv"/>
<entry key="process.outputError" value="c:\DLTest\Log\accountInsert_error.csv"/>
<entry key="dataAccess.type" value="databaseRead"/>
<entry key="process.initialLastRunDate"
value="2005-12-01T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>

ManoharSFManoharSF

Whats the issue that you getting?

 

for  <entry key="dataAccess.name" value="updateAccounts"/> I usually put the full path name of the file that i use as source as below

 

<entry key="dataAccess.name" value="c:\DLTest\updateAccounts.csv"/>

 

 

 

dp_derekdp_derek

you can upsert from csv to salesforce.

but cann't upsert from oracle to salesforce.