Apex Code Development You need to sign in to do that
Don't have an account?
Sunny G How to take The Data Backup in .csv or any other format of different languages
Hi,
I have some users from Japan using single Salesforce application. Means that i have lots of data in Japanees Language also. But when i try to take the backup of the data using data loader. My Japanees data gets distorted & appears something like "?????" . please suggest the way should i take the backup sucessfully with no data lost.And if required i should be able to get it restored.
When records containing Japanese characters are exported using the DataLoader, they can sometimes display incorrectly in Excel. This is partly due to limitations within Excel itself, but the file can be set up to make it usable for import.
Steps
-----
1) Open up the DataLoader and go to settings.
Make sure there are ticks in the boxes marked:
'Read all CSVs with UTF-8 encoding'
'Write all CSVs with UTF-8 encoding'
This will ensure support for the Japanese characters.
2) Make sure you have support for East Asian Languages.
To do this in windows XP, go to start, control panel, regional and language options.
Here you will see an option, about half way down the page, that says 'install files for East Asian languages'. This will need to be ticked, and the files installed. Your IT department may be needed to help do this.
3) Once the files are installed, it then appears that Excel has some difficulty reading Japanese characters in UTF 8 format.
However, you can be sure that the file is correct if you You open the .csv file in notepad.
When you do this, you should see the correct Japanese characters. However, it's much harder to work with.
You can then go to file, save as, 'Choose save type as 'all files', put the encoding as 'UTF 8', and then put in the file name with .csv at the end. E.g. Accounts.csv
Now you can try to open this up again in excel. The characters may still seem garbled, but in fact they are correct. If you were to import again, they should display correctly within Salesforce.
Please Note:
------------
Because the file is saved in UTF 8, it's important that if you're using the DataLoader, you have the UTF8 boxes checked in the settings, if you're using the import wizards, you must use UTF 8 in the encoding selection.
Hope this helps.
All Answers
I use the Encoding 'Unicode (UTF-8) for backup and data loader and it works.
Hello Sir,
It works gr8...
Please help me.. how to upload that file.. using data loader. Because while uploading that file.. the Japanees char become somthig like "????????".
I tried it in our Sandbox. I downloaded an Account with the Data Loader added some Japanese Char to the Name and updated this field with the Data Loader --> everything worked fine. Do you change the data between the download and the upload (Excel, Access). You have to be carefull to select the right encoding there.
Sir,
If i simply download the data by making "Read/Write .CSV file with UTF-8 Unicode enable".it become unreadable..i simply do not understand why??
So, after downloading the data i use to change the encoding to UTF-8 only then it become readable. Now when i tried importing it, its get distorted something like "??????".
When records containing Japanese characters are exported using the DataLoader, they can sometimes display incorrectly in Excel. This is partly due to limitations within Excel itself, but the file can be set up to make it usable for import.
Steps
-----
1) Open up the DataLoader and go to settings.
Make sure there are ticks in the boxes marked:
'Read all CSVs with UTF-8 encoding'
'Write all CSVs with UTF-8 encoding'
This will ensure support for the Japanese characters.
2) Make sure you have support for East Asian Languages.
To do this in windows XP, go to start, control panel, regional and language options.
Here you will see an option, about half way down the page, that says 'install files for East Asian languages'. This will need to be ticked, and the files installed. Your IT department may be needed to help do this.
3) Once the files are installed, it then appears that Excel has some difficulty reading Japanese characters in UTF 8 format.
However, you can be sure that the file is correct if you You open the .csv file in notepad.
When you do this, you should see the correct Japanese characters. However, it's much harder to work with.
You can then go to file, save as, 'Choose save type as 'all files', put the encoding as 'UTF 8', and then put in the file name with .csv at the end. E.g. Accounts.csv
Now you can try to open this up again in excel. The characters may still seem garbled, but in fact they are correct. If you were to import again, they should display correctly within Salesforce.
Please Note:
------------
Because the file is saved in UTF 8, it's important that if you're using the DataLoader, you have the UTF8 boxes checked in the settings, if you're using the import wizards, you must use UTF 8 in the encoding selection.
Hope this helps.