[Skip to main content](#vessel-content)

#   UTF8 import... å ä ö not working

##

- **[claesbas](/forum/user/30849-claesbas "View claesbas's Profile")**
- [![claesbas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30849-claesbas "View claesbas's Profile") Topic Author
- [ Offline](/forum/user/30849-claesbas)

Less More

- Posts: 5
- Thank you received: 0
-
-

12 years 9 months ago [\#141548](#141548) by [claesbas](/forum/user/30849-claesbas "View claesbas's Profile")  *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#141548 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")* was created by *[claesbas](/forum/user/30849-claesbas "View claesbas's Profile")*

-- url of the page with the problem -- : [ server.wnmedia.se/dahls/](http://server.wnmedia.se/dahls/)
-- HikaShop version -- : 2.2.2
-- Joomla version -- : 3.2.1
-- PHP version -- : 5.4.4
-- Browser(s) name and version -- : Firefox 26
-- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö

I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.

Is there anything that I need to do to get the correct UTF when importing?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[claesbas](/forum/user/30849-claesbas "View claesbas's Profile")**
- [![claesbas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30849-claesbas "View claesbas's Profile") Topic Author
- [ Offline](/forum/user/30849-claesbas)

Less More

- Posts: 5
- Thank you received: 0
-
-

12 years 9 months ago [\#141571](#141571) by [claesbas](/forum/user/30849-claesbas "View claesbas's Profile")  Replied by *[claesbas](/forum/user/30849-claesbas "View claesbas's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#141571 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Sorry this should be in import &amp; export forum

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86577
- Thank you received: 14321
-
-

12 years 9 months ago [\#141584](#141584) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#141584 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Please provide your CSV file.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[claesbas](/forum/user/30849-claesbas "View claesbas's Profile")**
- [![claesbas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30849-claesbas "View claesbas's Profile") Topic Author
- [ Offline](/forum/user/30849-claesbas)

Less More

- Posts: 5
- Thank you received: 0
-
-

12 years 9 months ago [\#141641](#141641) by [claesbas](/forum/user/30849-claesbas "View claesbas's Profile")  Replied by *[claesbas](/forum/user/30849-claesbas "View claesbas's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#141641 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Here it is: [ dl.dropboxusercontent.com/u/6241608/hikashopexport.csv](https://dl.dropboxusercontent.com/u/6241608/hikashopexport.csv)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86577
- Thank you received: 14321
-
-

12 years 9 months ago [\#141674](#141674) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#141674 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

The characters of the CSV display fine for the CSV and are detected as UTF8 by my CSV reader. So make sure that you select the UTF8 charset encoding in the import screen before clicking on import and it should work fine.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")**
- [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile")
- [ Offline](/forum/user/30192-myktybek)

Less More

- Posts: 39
- Thank you received: 0
-
-

12 years 8 months ago -  12 years 8 months ago [\#145511](#145511) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")  Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#145511 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi when I export data from the database to csv file in Russian words are displayed like this å äå ä can you tell me where I can change the UTF8 encoding to UTF-8 or please help how to fix this error?

Last edit: 12 years 8 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86577
- Thank you received: 14321
-
-

12 years 8 months ago [\#145618](#145618) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#145618 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

If the characters are not correct when you open your CSV that you exported via HikaShop, the problem is with your CSV reader which doesn't open the CSV file in UTF8.
If you use notepad++ to open the file, you should see the characters fine.
So I would recommend you to contact the support of your CSV reader software for help on how to open a CSV file in UTF8 with their software.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")**
- [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile")
- [ Offline](/forum/user/30192-myktybek)

Less More

- Posts: 39
- Thank you received: 0
-
-

12 years 8 months ago -  12 years 8 months ago [\#145640](#145640) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")  Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#145640 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi can you give me directory export.php or i don't know what is name this file i want change php code please or where i can change this encoding utf8 for example to windows 1251?

Last edit: 12 years 8 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 8 months ago [\#145733](#145733) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#145733 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi there,

It's not gonna be easy but here is what you are looking for:
administrator/components/com_hikashop/views/product/tmpl/export.php

Look at the end of the file.
You could use the function change of encoding.php (in the helper folder).
But it's complicate while you could use something else to read your csv.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")**
- [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile")
- [ Offline](/forum/user/30192-myktybek)

Less More

- Posts: 39
- Thank you received: 0
-
-

12 years 8 months ago -  12 years 8 months ago [\#146225](#146225) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")  Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#146225 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi yes you are right i agree with you it is really difficult and so i have question i want change csv format to xlsx it is possible?

Last edit: 12 years 8 months ago by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

12 years 8 months ago [\#146398](#146398) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#146398 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi,

The HikaShop export system can create CSV or XLS files.
We do not support the XLSX file format.

Regards,

---

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")**
- [![Мыктыбек's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30192-myktybek "View Мыктыбек's Profile")
- [ Offline](/forum/user/30192-myktybek)

Less More

- Posts: 39
- Thank you received: 0
-
-

12 years 8 months ago [\#147066](#147066) by [Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")  Replied by *[Мыктыбек](/forum/user/30192-myktybek "View Мыктыбек's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#147066 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi and where i can change this format csv to xls?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

12 years 8 months ago [\#147095](#147095) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#147095 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi,

In the view "backend &#124; your_backend_template &#124; product &#124; export" you will find this line: Code:

$format = $config-&gt;get('export_format','csv');

So you can override the view in order to change the default value from "csv" to "xls" or you can create a new entry in the table hikashop_config for the key "export_format".
I forgot that the option is an "hidden option", there is no visible interface in the HikaShop configuration for that because it is very specific feature.

Regards,

---

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[sambob](/forum/user/7887-sambob "View sambob's Profile")**
- [![sambob's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7887.png)](/forum/user/7887-sambob "View sambob's Profile")
- [ Offline](/forum/user/7887-sambob)

Less More

- Posts: 260
- Thank you received: 25
-
- [](https://viemedia.com.au)
-

10 years 4 months ago -  10 years 4 months ago [\#245192](#245192) by [sambob](/forum/user/7887-sambob "View sambob's Profile")  Replied by *[sambob](/forum/user/7887-sambob "View sambob's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#245192 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi, I am having similar issues with the export import that results in strange characters is accented letters used.

My products (photography) has English, French and Swedish characters for relevant products.

I thought the issue was with Open Calc which I use but it appears it is something within the system.

Here is my work through to test.
I have a product with the words Musée du Louvre in title, description etc:
If I export that product, save it without opening in any program see below  *This attachment is hidden for guests.
Please log in or register to see it.*

)
Then if I import that file straight away (**without opening it in any program**); the accents for that phrase becomes (MusÃ©e du Louvre) - See below
*This attachment is hidden for guests.
Please log in or register to see it.*

So while I have been pulling my hair out for a few hours thinking it was OpanCalc, it appears not to be the case. The same appears for Swedish words with accents.

Any thoughts on this greatly appreciated

Simon

---

Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

Last edit: 10 years 4 months ago by [sambob](/forum/user/7887-sambob "View sambob's Profile"). Reason: neatening up

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86577
- Thank you received: 14321
-
-

10 years 4 months ago [\#245245](#245245) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#245245 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi,

HikaShop exports the CSVs with the UTF8 encoding which supports all the characters.
But I can see that your CSV already has characters with a wrong encoding in the hikashop-export-import-test.csv file : [ take.ms/UeMzo](http://take.ms/UeMzo)
That is already like that in your database and wasn't done by the export. You can see that the other accents display fine in your CSV.

So I'm thinking that the problem might be when you import the CSV. Did you select the UTF8 encoding when you did the import ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[sambob](/forum/user/7887-sambob "View sambob's Profile")**
- [![sambob's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7887.png)](/forum/user/7887-sambob "View sambob's Profile")
- [ Offline](/forum/user/7887-sambob)

Less More

- Posts: 260
- Thank you received: 25
-
- [](https://viemedia.com.au)
-

10 years 4 months ago [\#245266](#245266) by [sambob](/forum/user/7887-sambob "View sambob's Profile")  Replied by *[sambob](/forum/user/7887-sambob "View sambob's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#245266 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi Nicholas,

Thanks for looking into this.

That erroneous character group is because I must have missed correcting that particular field (the alias) when I did the test.

Importing as utf8. - remember that file that I imported was unchanged from the export (i.e. not opened so whatever the encoding at export is the same at import.

The is something going on with the import but not sure what, why, how.

---

Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[sambob](/forum/user/7887-sambob "View sambob's Profile")**
- [![sambob's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7887.png)](/forum/user/7887-sambob "View sambob's Profile")
- [ Offline](/forum/user/7887-sambob)

Less More

- Posts: 260
- Thank you received: 25
-
- [](https://viemedia.com.au)
-

10 years 4 months ago -  10 years 4 months ago [\#245269](#245269) by [sambob](/forum/user/7887-sambob "View sambob's Profile")  Replied by *[sambob](/forum/user/7887-sambob "View sambob's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#245269 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi Nicholas, I thought I would do a retest.
First image is the file with the exported product that with the accented characters corrected in the backend. You can see that in both OpenCalc and notepad that characters are as expected.
[ ![hikashop-export-single-csv.jpg](/forum/attachment/32585) ](/forum/attachment/32585 "...single-csv.jpg")

The second image is the product after the same file above is imported (unopened, unsaved, as it was exported)
[ ![hikashop-as-import&#95;2016-07-11.jpg](/forum/attachment/32588) ](/forum/attachment/32588 "...2016-07-11.jpg")

Here is the file... there appears to be something happening on import. (Are you able to test import successfully)
*This attachment is hidden for guests.
Please log in or register to see it.*

Strange...

---

Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

- [ ![hikashop-export-single-csv.jpg](/forum/attachment/32585) ](/forum/attachment/32585 "...single-csv.jpg") [ ](/forum/attachment/32585?download=1 "...single-csv.jpg")
- [ ![hikashop-as-import&#95;2016-07-11.jpg](/forum/attachment/32588) ](/forum/attachment/32588 "...2016-07-11.jpg") [ ](/forum/attachment/32588?download=1 "...2016-07-11.jpg")

Last edit: 10 years 4 months ago by [sambob](/forum/user/7887-sambob "View sambob's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[sambob](/forum/user/7887-sambob "View sambob's Profile")**
- [![sambob's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7887.png)](/forum/user/7887-sambob "View sambob's Profile")
- [ Offline](/forum/user/7887-sambob)

Less More

- Posts: 260
- Thank you received: 25
-
- [](https://viemedia.com.au)
-

10 years 4 months ago [\#245270](#245270) by [sambob](/forum/user/7887-sambob "View sambob's Profile")  Replied by *[sambob](/forum/user/7887-sambob "View sambob's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#245270 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Ok... some progress.

If I copy the content of the csv into the 'Import products from text area', and import that way, it imports as expected (with correct accent characters)

So there appears to be a 'glitch' with the 'Import products from CSV' function - but we are getting closer to the issue.

Simon

---

Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86577
- Thank you received: 14321
-
-

10 years 4 months ago [\#245268](#245268) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#245268 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi,

So I've tried to import your CSV on a test website and the texts don't have any accent problem:
[ take.ms/aCZtC](http://take.ms/aCZtC)
And if I export again the product, the accents are still correct in the resulting CSV:
[ take.ms/nmwxy](http://take.ms/nmwxy)
So besides a wrong manipulation with the files on your end, I don't see what it could be.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[sambob](/forum/user/7887-sambob "View sambob's Profile")**
- [![sambob's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7887.png)](/forum/user/7887-sambob "View sambob's Profile")
- [ Offline](/forum/user/7887-sambob)

Less More

- Posts: 260
- Thank you received: 25
-
- [](https://viemedia.com.au)
-

10 years 4 months ago [\#245342](#245342) by [sambob](/forum/user/7887-sambob "View sambob's Profile")  Replied by *[sambob](/forum/user/7887-sambob "View sambob's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working#245342 "-- url of the page with the problem -- :   server.wnmedia.se/dahls/  -- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.4 -- Browser(s) name and version -- : Firefox 26 -- Error-message(debug-mod must be tuned on) -- : Wrong signs for swedish å ä ö  I have an exported CSV wiht lots of products ... when I open it in Notepad ++ i looks fine. Swedish å ä ö are fine. But when I import it I get strange signs.  Is there anything that I need to do to get the correct UTF when importing?")*

Hi Nicolas, thanks for looking into it.

Text import works fine; and when I export it, all accents display as expected.

It is the CVS (file) import which is causing the issue, as mentioned, that file, exported and then directly imported, **remained untouched/unopened before re-importing** it back in - and the issue appears.

I was thinking and investigating something erroneous in the mysql tables etc, but nothing comes up.

Doing the text import is no big deal, just a couple of clicks with the mouse.

Thanks again for looking into this Nicolas, appreciate it!

Simon

---

Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.125 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
