Importing Products with accented names

  • Posts: 13
  • Thank you received: 0
9 years 7 months ago #199020

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.0
-- PHP version -- : 5.4.38

I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 7 months ago #199142

Hi,

Please check the encoding format of your file ; the best is to use UTF-8 encoding.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 13
  • Thank you received: 0
9 years 7 months ago #199316

I have checked the encoding on the CSV file and the database, and they are both UTF-8.

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

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

Hi,

HikaShop will not remove any accent during the import of UTF8 files. HikaShop itself, and Joomla, are both fully UTF8. If you import a UTF8 file, the accents won't be removed.
So the only conclusion I can think of is that you think that the CSV you're trying to import is UTF8 when in fact it is not.

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

  • Posts: 13
  • Thank you received: 0
9 years 7 months ago #199495

I took a second look at the way the file was being created. I have to use an Excel spreadsheet to build the import file, and if you don't save the file as Unicode Text, you don't actually encode.

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

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

Unicode basically means UTF8. And if you don't use it, it means that you use your local language encoding, which indeed explains why it didn't work.

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

  • Posts: 5
  • Thank you received: 1
9 years 4 months ago #208038

I experienced the same issue when creating the CSV file directly from Excel (Mac OS version 2011). The issue can easily be solved by exporting the file as "Windows Comma Separated (.csv)". Other options do not seem to generate a proper UTF-8 file.

The following user(s) said Thank You: nicolas

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

Time to create page: 0.077 seconds
Powered by Kunena Forum