Recently i was trying to import my data with a CSV file into the collection database system. But than I found that those Chinese characters in the data was garbled.
Like, [ �]�ߺ�Ҵ��Z -] .
How do I import data with Chinese characters correctly?
Thanks a lot.
Hey,
Can you please send us a sample of the csv fie you were trying to add to the collection so that we can check it on our end?
Thanks,
Tal.
Would you like to provide your contact information for me to access to you?
Hi,
Please upload the file here and reply with the file URL.
Thanks,
Tal.
https://ufile.io/dt8gk
Here is it, much thanks.
Hi,
Just want to clarify, if you open the same CSV file on your machine before the import (not in the google spreadsheet) - is it looks ok and readable? without [�]�ߺ�Ҵ��Z]
Thanks.
It looks normal. Once it import, it goes garbled in the Data.
Thank you, checking it with development team.
For your information , this situation also happen in importing contact list.
Hey,
Do you refer to importing contacts to the contacts dashboard ?
If so, please contact Wix support . If not, please clarify what is the scenario.
Tal.
the garbled scenario was both happening in importing CSV file in eighter contacts dashboard or in the wix code database.
The contacts dashboard is not related to Wix code. This forum is specialised in Wix Code product. Therefore, you should contact Wix support team to help you with this matter. As for importing the CSV file in the Wix Code database- we are checking it on our end. We’ll get back to you once it is resolved.
Tal.
Hey there, I think I have solve the problem by uploading the excel file to google drive and then download it with exporting CSV file. However I have found another problem, that you may refer to here: https://www.wix.com/code/home/forum/questions-answers/my-categories-page-con-not-display-all-of-my-item
i have same issue, can not import CSV file. when i upload the excel file, the chinese characters will be garbled. i try to upload the excel file to google drive and download again. but it still not work. please help!!!
Old post bumped up, being closed.
See other post.
https://www.wix.com/corvid/forum/community-discussion/import-csv-file-has-chinese-characters-garbled/p-1/dl-5e63b3da02d8e300173ebd60-5e63a4bfa9062c00171d34bd-1