A Tip A Day #13 – Data Load Non-English Characters into Salesforce

This post is a part of the daily blog series 

A Tip A Day, daily dosage of learning!


 Day #3 – Data Load Non-English Characters

If your csv file has Non-English characters (eg: Chinese characters) to data load into Salesforce.  Then are 2 settings you need to set for that data to load into Salesforce otherwise the data will be lost.

  • Change the CSV file format to CSV UTF-8.  Open the csv or excel file, File–> Save as –> choose CSV UTF-8 (Note this is also .csv but just the encoding is different)

csv_file_save_csv_utf-8_dataloader_salesforce_sfdcfanboy

  • Change Apex Data loader Settings: In Apex Data loader, open Settings–> and check these 2 checkboxes.  Read/Write all CSVs with UTF-8 encoding.

dataload_non_english_records_salesforce_sfdcfanboy


Read all other tips of the blog series here – A Tip A Day, daily dosage of learning!

Advertisements

One Reply to “A Tip A Day #13 – Data Load Non-English Characters into Salesforce”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s