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
Vidya DVidya D 

Data Loader version 33 with UTF-8 format

I am trying to load data that consists of Asian characters as well as , between the text.
I followed instruction to create UTF-8 file as per below link
https://help.salesforce.com/apex/HTViewHelpDoc?id=faq_import_dataloader_specialchars.htm&language=en_US
With this approach excel save as unicode surrounds text with comma in Quotes.  Then Dataloader fails to load this with error "Found unescaped quote" 

I created work around by changing , with ; in excel, save as unicode and in text editor replace ; with ,. Then follow the steps to save as UTF-8.
 This file fails with number of data columns (3)  exceeds the number of columns in the header.

 Has anyone able to load the data with , within text and special characters? 





 
Gaurav KheterpalGaurav Kheterpal
You may want to try with an older version of data loader - based on my experience, that handles Asian characters better. Also, double check your encoding settings as shown here.

User-added image

There's a simliar issue reported here (http://salesforce.stackexchange.com/questions/24765/unable-to-use-dataloader-to-load-file-with-asian-characters) as well.

If my answer helps resolve your query, please mark it as the 'Best Answer' to benefit others and improve the overall quality of Discussion Forums.

Gaurav Kheterpal
Certified Force.com Developer| Developer Forums Moderator| Dreamforce Speaker