- Posts: 22
- Thank you received: 0
error export words with accents
12 years 3 weeks ago - 12 years 3 weeks ago #170391
by cfi
error export words with accents was created by cfi
-- HikaShop version -- : 2.3.0
-- PHP version -- : 5.3.3-7+squeeze18
Hello, I would like to resolve the issue of export orders with customers that have name or address with accented characters such as "ò" "à" "ì" "è". In the hikashop user registration are entered correctly eg "Via Riccardo Arnò 18" but when I export the order in csv "Via Riccardo Arnò 18" appears. How can I risovere? There is to change the character set in the database or there is to modify the php file export?
Thank you!
-- PHP version -- : 5.3.3-7+squeeze18
Hello, I would like to resolve the issue of export orders with customers that have name or address with accented characters such as "ò" "à" "ì" "è". In the hikashop user registration are entered correctly eg "Via Riccardo Arnò 18" but when I export the order in csv "Via Riccardo Arnò 18" appears. How can I risovere? There is to change the character set in the database or there is to modify the php file export?
Thank you!
Last edit: 12 years 3 weeks ago by cfi.
Please Log in or Create an account to join the conversation.
12 years 2 weeks ago #170394
by Xavier
Replied by Xavier on topic error export words with accents
Hi,
The problem come from the software you are using to open the csv file.
With HikaShop we are exporting in UTF-8 so accent are managed, but if you open the file not in UTF-8 so you have strange characters.
So fore example if you are using Excel, you must open excel, then click on "import" and select the file, it will ask the desired option to import the file, here select UTF-8. Or you can use Open office, which propose the settings when openning a file directly.
The problem come from the software you are using to open the csv file.
With HikaShop we are exporting in UTF-8 so accent are managed, but if you open the file not in UTF-8 so you have strange characters.
So fore example if you are using Excel, you must open excel, then click on "import" and select the file, it will ask the desired option to import the file, here select UTF-8. Or you can use Open office, which propose the settings when openning a file directly.
The following user(s) said Thank You: cfi
Please Log in or Create an account to join the conversation.
Time to create page: 0.151 seconds