error export words with accents

  • Posts: 22
  • Thank you received: 0
10 years 2 months ago #170391

-- 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!

Last edit: 10 years 2 months ago by cfi.

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
10 years 2 months ago #170394

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 following user(s) said Thank You: cfi

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum