Jump to content



Photo
- - - - -

Using easy populate with unicode characters (chinese) problems importing


  • Please log in to reply
4 replies to this topic

#1   chronometre

chronometre
  • Members
  • 2 posts
  • Real Name:hing

Posted 06 December 2010 - 19:34

Hi All,
wondering if anyone has experience with using easy populate with a unicode language pack (japan, chinese, korean etc..) saving and uploading unicode is generating all these weird looking wingdings. i have installed the chinese language pack in zencart as well as in the zencart admin. still cant get easy populate to import the characters properly. i have a windows xp machine with language packs and ime installed. i have tried various ways (saving txt file as unicode first, and other permutations of similar style) as described on different threads and i still cant get the characters to hold or easy populate to import without error. any help the community could provide would be greatly appreciated.

/biggrin.gif' class='bbc_emoticon' alt=':D' />

#2   web-project

web-project
  • Members
  • 4,320 posts
  • Real Name:Alex
  • Gender:Male
  • Location:Hertfordshire, UK

Posted 07 December 2010 - 09:24

with other encoding languages, the admin, front end and import file should be in the same encoding.

You can use the UTF or language own encoding, very easy to use UTF, as you can set the mysql to use the same encoding.
Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!
8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.
Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.
Any issues with oscommerce, I am here to help you.

#3   chronometre

chronometre
  • Members
  • 2 posts
  • Real Name:hing

Posted 08 December 2010 - 00:41

web-project!
Thank you for your response!! i am using utf chinese language on admin and front end, however the assembly of the CSV is via excel. save to a unicode. the unicode is not holding through the import using easy populate =( ive tired almost every solution available on a thread out there. from using open office .org to every permutation of saves in excel

#4   web-project

web-project
  • Members
  • 4,320 posts
  • Real Name:Alex
  • Gender:Male
  • Location:Hertfordshire, UK

Posted 08 December 2010 - 07:14

web-project!
Thank you for your response!! i am using utf chinese language on admin and front end, however the assembly of the CSV is via excel. save to a unicode. the unicode is not holding through the import using easy populate =( ive tired almost every solution available on a thread out there. from using open office .org to every permutation of saves in excel


is your mysql tables in UTF encoding?
Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!
8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.
Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.
Any issues with oscommerce, I am here to help you.

#5   xvoyance

xvoyance
  • Members
  • 87 posts
  • Real Name:xi voyance
  • Gender:Male

Posted 23 March 2012 - 16:24

in the manuel of EP, they suggest using open office which offer other encoding methods, such as UTF-8.
However, even with open office I cannot display the downloaded Chinese character properly.

I am using OSC 2.3.1