Jump to content

UTF-8 characters all messed up on import


Recommended Posts

I uploaded a CVS file saved in UTF-8 mode with Chinese characters in title and description.

All those characters are screwed up even on import preview mode, they become:


�ئ���Y����]�ɩ|�إ]

But when I enter the text manually, the shop shows up fine.

What to do now? I have over 10,000 items to import!

Link to comment
Share on other sites

The new import fixes the unicode problem. But still I need help in making a CSV in correct format.

My export has ^t as delimiter, and as shown on the following pic I have html code and comma in Description text.

http://img523.imageshack.us/img523/5710/psss6.gif

I tried to change Column separator and Field separator to both ^t, then the importer read only one empty column.

I am using MS Office 2007, which does not allow me (or I don't know how) to change my separator symbol of a CSV file.

Any suggestion?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...