+ Start a Discussion
DaveIngramDaveIngram 

Problem getting UTF-8 to work with Command line Dataloader

Hello all,
 
I'm trying to export lead data out of Salesforce.com however it is in many differnet languages...
 
the problem i am having is i cannot get the Command line version of the dataloader to export the chinese characters....
 
I can make the WIndows version (8.0 & 9.0) pull the chinese by ticking the "Read Write UTF-8" box.
this is what i used int he bean:
 
            <entry key="dataAccess.writeUTF8" value="TRUE"/>
                 <entry key="dataAccess.readUTF8" value="TRUE"/>

However i cannot make this work in the Command line.
 
 
I called salesforce.com support and was informed that this was not supported by them.
 
Please help!!

Dave
 
 
 
    
mspohnmspohn
Hi Dave,

Have you tried it with lower case "true" instead of "TRUE"?

<entry key="dataAccess.writeUTF8" value="true"/>
<entry key="dataAccess.readUTF8" value="true"/>


Let me know if that helped.

Thanks,
Markus

Markus Spohn
Director Product Management, Integration
Salesforce.com


DaveIngramDaveIngram
Wow,
 
i feel like an idiot!
 
YES it works!!! fantastic...
 
Note to Salesforce.com all your documentation shows TURE in all caps you might want to update this!
 
thanks alot!

Dave
mspohnmspohn
Hi Dave,

Clearly a problem on our side! I've logged a bug for this. We'll fix it asap as this is extremely misleading and difficult to debug.

Thanks,
Markus

Markus Spohn
Director Product Management, Integration
Salesforce.com


DaveIngramDaveIngram

Thank for correcting this...

 

While you are there it might be useful to get a more consice documentation..

 

I have started trying to get the dataloader to pull straight to our sql server and i keep coming up against walls and none of your documentation helps very much.

 

I get errors like

"Error getting value for SQL parameter LastName. Make sure that the value exists in your configuration file or is passed in"

and i cant see any problems with the code.

 

thanks


Dave

 

 

DaveIngramDaveIngram

Just incase anyone was following htis thread i was having problems with my mapping ifle.

 

this now works.


Dave

metadata connectionmetadata connection
Hello all,
 
I'm trying to export data which contains a character like "–".
 
the problem i am having is data is not exported as expected even though my configuration is as below.

 <entry key="dataAccess.readUTF8" value="true"/>
<entry key="dataAccess.writeUTF8" value="true"/>

Need quick resolution. Please help!

Mounica