Excel encoding breaking product descption

  • Posts: 147
  • Thank you received: 6
9 years 7 months ago #197420

-- HikaShop version -- : 2.4.0

Hi,
Some sort of excel enconding is replacing my double and single quotation marks with 2 special characters. Although this has nothing to do with Hikashop you may want to look at it as those special carachters are breaking the product description import process.

The characters are î and í.
Or you can have a go uploading the attached csv to see the problem for your self.

File Attachment:

File Name: cannon-600...4-06.csv
File Size:2 KB



Thanks

Attachments:
Last edit: 9 years 7 months ago by maujbigo.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 7 months ago #197461

Hi,

I've imported your CSV on my end and the description is imported properly and completely. And didn't see any î or í characters in your CSV.

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

  • Posts: 147
  • Thank you received: 6
9 years 7 months ago #197529

Please try importing this file.

File Attachment:

File Name: encoding-problem.csv
File Size:2 KB


Thanks

Attachments:

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

  • Posts: 13201
  • Thank you received: 2322
9 years 7 months ago #197545

Hi,

I just imported this file, and no issues, the product is correctly added on my end.
You have maybe an issue with your database collation, please check via phpMyAdmin that the collation for the tables and the columns is set on "utf8_general_ci" or something supporting utf8 characters.

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

  • Posts: 147
  • Thank you received: 6
9 years 7 months ago #197739

Thanks for that but my table has the correct collation.
It might be my excel encoding.

Thanks for trying though.

Attachments:

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

Time to create page: 0.085 seconds
Powered by Kunena Forum