You need to sign in to do that
Don't have an account?
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>
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"/>
you can upsert from csv to salesforce.
but cann't upsert from oracle to salesforce.