[SalesForce] Issue extracting special character with Apex Data Loader 28.0.2

I am getting issue's with the extracted .csv files from Apex Data-Loader:

While extracting data that contains special characters, the exported .csv file doesn't show the special character as they were seen in Salesforce UI, but they can changed to something different special character. [ so how to extract them as they were seen in salesforce UI ]

The another thing is one of my client getting this problem, when they are extracting the data(containing Korean language) from dataloader in .csv file the data got broken with many rows when we open it with correct procedure as mentioned below:

a. Opening a new excel sheet, then going to "Data" tab and then clicking on 'From Text' option
b. Then selecting the file(,csv extracted by dataloader) and using these settings:-
c. Step 1: Delimited & File Origin- 65001: Unicode(UTF-8)
d. Step 2: Delimeter - Tab and Comma
e. Step 3: Column data format - Text for text type data and Data for date type data

Please help me with these issue's.

Best Answer

It looks like you are not writing the CSV file using the correct encoding.

From the online help

https://success.salesforce.com/ideaView?id=08730000000jRNIAA2

Make sure the 2 UTF-8 encoding setting in Data Loader are checked.

Read all CSVs with encoding Write all CSVs with encoding

Perform Export.and save the file on local file folder

3 Open Excel and import the file, on the MS Excel Import Wizard step 3, choose the File Origin Unicode (UTF-8).

Once the CSV is exported and displays symbols when opening in Excel. You may try these steps.

Right click on the csv file and click "Open With" Choose Notepad On Notepad click File then Save As Set the file name - (Filename here).csv Select UTF-8 on Encoding and click Save Open the new CSV file on Excel.

Related Solutions

[SalesForce] Unable to use dataloader to load file with Asian characters

You're doing several file manipulations with various utilities and while it seems like that should work to convert an excel spreadsheet to CSV there are probably a lot of pitfalls to avoid.

You might check out this question on Stackoverflow about exporting Excel spreadsheets as unicode csv files.

Personally I think this answer has the best approach (but there are several options):

Save as a CSV from excel
Run CSV unicode converter

You can use iconv command under Unix (also available on Windows as libiconv).

After saving as CSV under Excel in the command line put:
iconv -f cp1250 -t utf-8 file-encoded-cp1250.csv > file-encoded-utf8.csv
(remember to replace cp1250 with your encoding).

Works fast and great for big files like post codes database, which cannot be imported to GoogleDocs (400.000 cells limit).

[SalesForce] Salesforce Custom Object lookup to Contact (or another custom object) and Data Loader import on email rather than id

I found Salesforce's own documentation pretty useful on Data Loader and relationships. Good enough to just copy verbatim (aside from minor formatting).

Description of Steps

Add a Text field to your parent object. Make sure you set the length to 18 and mark it as an External Id.
Export your parent records with the Id field included.
When inserting parent records, make sure you map the Id to your newly created External Id field from Step 1.
Upsert the child records based on Id. You can then set what External Id field to use as a lookup for each parent object. Select the field you created in Step 1.
Optionally delete the field you created in Step 1.

Pros

Can be implemented via Data Loader (free)

Cons

Requires creation of a new Custom Field

Documentation referenced above:

In the destination Organization, on the Parent Object (in this case, Account), create a new field of type Text and mark it as an ‘External Id’ field. Be sure to make the length of the field at least 18 characters (the size of the Salesforce ID field). Let’s call this new field on Account – ‘Source Acct ID’.

Export the Parent Object (in this case, Account) data from the source Organization into a csv file using Data Loader. Be sure to include the ‘Id’ field when exporting this data.

Insert the data from Step 2 into the destination Organization using Data Loader. In the mapping screen of Data Loader, map the ‘ID’ field from the csv file to the new field created in Step 1 (in this case, ‘Source Acct ID’).

Export the Child Object (in this case, Opportunity) data from the source Organization into a csv file using Data Loader. Be sure to include the relationship field (in this case ‘AccountID’) when exporting this data.

Upsert the data from Step 4 into the destination Organization using Data Loader. In Step 2a of the Data Loader, select ‘ID’ as the field to use for matching Opportunities. In Step 2b of the Data Loader, select the field created in Step 1 (in this case, ‘Source Acct ID’) as the field to match the parent object. In the next mapping step of the Data Loader, map the ‘AccountId’ column of the csv file to the ‘Account:Source Acct ID’ field. This will allow the Data Loader to associate each Opportunity record with its respective parent Account record. Note that the ‘AccountId’ column of the CSV file should NOT be mapped to the standard ‘AccountId’ field (which is what the Data Loader does by default with the ‘Auto-Match Fields to Columns’ option). Instead, it has to be mapped to the ‘Account:Source Acct ID’ field.

After finishing the data import, the new field created in Step 1 (‘Source Acct ID’) may be deleted as it was only necessary for the data import process.

Best Answer

Related Solutions

[SalesForce] Unable to use dataloader to load file with Asian characters

[SalesForce] Salesforce Custom Object lookup to Contact (or another custom object) and Data Loader import on email rather than id

Related Topic