Japanese names in USERS_GEN

[Former Member]

Hello All,

We would like to upload around 1000+ Japanese users in PPOMA using USERS_GEN (upload from file option). The first and last name for these users are to be in Kanji Characters. The problem with the CSV file is that it does not recognise the KANJI characters and the first and last names get replaced with ?? in the CSV file after saving it.

So when we upload the first and last names in PPOMA would appear as ??

Has anyone encountered this problem? Can you propose a possible solution ?

Regards,

Subbu

[masa_139 · Accepted solution]

Hi,

Please check file encoding of the CSV file. Please test with UTF-8 encoding.

Regards,

Masa

[Former Member · Accepted solution]

Hello Masa,

Thanks, Please can you give more details?

Regards,

Subbu

[masa_139 · Accepted solution]

Hi,

It depends on what kind of editor do you use.

Please open the CSV with microsoft notepad. Do you see any Charactor Encoding when you select File -> Save As... ?

I usually edit the CSV in Excel (Encoding is Shift_JIS) then convert the CSV(Shift_JIS) to CSV(UTF-8) in Unicode Editor.

I use free Unicode editor called "Sakura".

Regards,

Masa

[masa_139 · Accepted solution]

Hi,

The issue is the CSV file is "Shift_JIS" encoding. You have to save the CSV as UTF-8 encoding.

Please ask the person who edited Japanese text to save the CSV file as UTF-8.

Open the Japanese Microsoft Notepad editor. Select File -> Save As.., Select characterset UTF-8.

or

You can find free Unicode text editor and save the CSV as UTF-8.

Regards,

Masa

[Former Member · Accepted solution]

Hello Masa,

Thanks for the excellent inputs. I followed the porcedure below as per your inputs:

- I installed an notepad unicode editor application

- I saved my excel file as a .Unicode txt file

- I opened this file with my Unicode editor

- I replaced the tab seperators with semicolons ;

- I saved the file as a .csv file of type all types

And it worked !!!!!!!!

Thanks a lot.

Regards,

Subbu