You need to sign in to do that
Don't have an account?

Struggling with Apex Data Loader Command Line Password
I seem to be having an issue with the Encrypt or decrypt portion of the password process.
Even i added security token to it but same problem.
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="accountMasterProcess"
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="accountMasterProcess"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="true"/>
<entry key="sfdc.debugMessagesFile"
value="C:\Datalodercli\accountInsertSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
<entry key="sfdc.username" value="mvrsreddy@gmail.com"/>
<entry key="sfdc.password" value="9016019f5e18b6c75f993da5924fd33bB0aszGmt639q7ut2j7UKT3ux"/>
<entry key="process.encryptionKeyFile"
value="C:\Datalodercli\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="insert"/>
<entry key="process.mappingFile"
value="C:\Datalodercli\account.sdl"/>
<entry key="dataAccess.name"
value="C:\Datalodercli\accountInsert.csv"/>
<entry key="process.outputSuccess"
value="C:\Datalodercli\accountInsert_success.csv"/>
<entry key="process.outputError"
value="C:\Datalodercli\accountInsert_error.csv"/>
<entry key="dataAccess.type" value="csvRead"/>
<entry key="process.initialLastRunDate"
value="2005-12-01T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>
Thanks in advance.
Here is an example,
C:\ProgramFiles\Dataloader\bin> encrypt -e abz
C:\ProgramFiles\Dataloader\bin> encrypt -v 5046500bce74f14d abz
"Decryption of encrypted value MATCHES the expected value"
This verify your encrypted password is correct.
All Answers
Hey Geetha,
What command are using to encrypt?
May be you can get some help from this link.
http://abztech.wordpress.com/2011/05/24/encrypting-salesforce-password/
Hi alibzafar ,
By this way i am encrypting password.
1. Open command prompt in ur system.
2. Change the directory to bin directory of ur datalaoder(Example:C:\ProgramFiles\Dataloader\bin).
3. In the command prompt type encrypt.bat -g test(Example:C:\ProgramFiles\Dataloader\bin>encrypt.bat -g test)
4. Hit enter then key will be generated copy the key and paste it in key.txt file(create .txt file and rename it to key.txt and paste the key).
5.type encrypt.bat -e kevin123456 and location of ur key.txt file(Example:C:\ProgramFiles\Dataloader\bin>encrypt.bat -e kevin123456 "C:\ProgramFiles\Dataloader\test\key.txt" ) .
6. Hit enter then one alpha numeric number will be genarated copy that and paste it in Process-conf.xml file.
Did you already worked on this part?
If so can u share Code snippet .
Instead of generating text file, you can directly use the encrypted password . To generate encrypted password use command
C:\ProgramFiles\Dataloader\bin> encrypt -e passwordSecurityToken
This will genrate the enrypted password, which you can directly use in your process-conf file. To verify your encrypted password run command
C:\ProgramFiles\Dataloader\bin> encrypt -v encryptedPassword passwordSecurityToken
Another thing is you are using '.bat' in your command, try using without it
Hope this helps
Thanks
Hi Ali,
I am getting this error
2012-08-29 12:18:20,453 ERROR [accountMasterProcess] config.Config decryptProper
ty (Config.java:669) - Error loading parameter: sfdc.password of type: java.lang
.String
HI Geetha,
Have you verified your encrypted password?
C:\ProgramFiles\Dataloader\bin> encrypt -e passwordSecurityToken .
and finally I am checking from command promt.
file location>process.bat "process.xml location" bean id
Same Error coming:
2012-08-29 17:46:50,812 ERROR [accountMasterProcess] client.PartnerClient loginI
nternal (PartnerClient.java:534) - Error while logging in to web service at: htt
p://www.salesforce.com//services/Soap/u/25.0, error was:
[LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
Can any one help on this issue..
You need to verify your credentials before running 'process' command
How to verify credentials before running 'process' command ?
Any Process please suggest me.
Here is an example,
C:\ProgramFiles\Dataloader\bin> encrypt -e abz
C:\ProgramFiles\Dataloader\bin> encrypt -v 5046500bce74f14d abz
"Decryption of encrypted value MATCHES the expected value"
This verify your encrypted password is correct.
C:\Program Files\salesforce.com\Data Loader\bin>encrypt -v 5046500bce74f14d abz
Decryption of encrypted value MATCHES the expected value
I got like this Ali .
After that :
C:\Program Files\salesforce.com\Data Loader\bin>process.bat "C:\Program Files\salesforce.com\Data Loader\Test" accountMasterProcess
But i am getting Error:
Error loading parameter: sfdc.password of type: java.lang.String
You solved my problem. Tank's!
Unsupported option: -v