You need to sign in to do that
Don't have an account?
Vidya 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?
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?
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