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

#   UTF8 import... å ä ö not working

##

- **[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 [\#245381](#245381) 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?start=20#245381 "-- 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,

Unfortunately, I'm not able to reproduce the problem.
Did you select the UTF8 charset for the CSV import ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) 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 [\#245443](#245443) 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?start=20#245443 "-- 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... that might be it.

I have never used that option, just had it at default. :oops:

I will let you know on the next import.

Sorry for the bother (most likely) and thanks for the great support as always.

Simon

---

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

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

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

Less More

- Posts: 101
- Thank you received: 2
-
-

9 years 11 months ago [\#258056](#258056) by [permsk](/forum/user/28179-permsk "View permsk's Profile")  Replied by *[permsk](/forum/user/28179-permsk "View permsk's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working?start=20#258056 "-- 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?")*

Hello Nicolas !
If the user or visitor wants to download the price at cvs or xls , you need to force it to encode in notepad++ or to put additional applications to utf8 encoding properly displayed ?
It is not professional for such a component such as hikashop!
Most of our users have Excel and have a problem with encoding.
You can't fix this little thing or don't want?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) 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)
-

9 years 11 months ago [\#258091](#258091) 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?start=20#258091 "-- 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?")*

You could use Open Office (Calc) to seamlessly import/export with the utf8 - works pretty-much the same of Excel.

If you really need/prefer excel, copy and paste over (and back to calc)

Hikashop is a great product, and the utf-8 issue is not unique to Hikashop and is experienced in other web components and cross other CMS.

I have used Hikashop for many years and found the component, and those people behind it VERY professional; so the assertion they are otherwise is not accurate.

PS... my import issue has been resolved Nicolas... it was operator error in that I had not selected the UTF-8 at the import stage ![;)](/media/kunena/emoticons/24.png ";)")

---

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

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

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

Less More

- Posts: 101
- Thank you received: 2
-
-

9 years 11 months ago [\#258094](#258094) by [permsk](/forum/user/28179-permsk "View permsk's Profile")  Replied by *[permsk](/forum/user/28179-permsk "View permsk's Profile")* on topic *[UTF8 import... å ä ö not working](/forum/25-install-update/865394-utf8-import-a-ae-oe-not-working?start=20#258094 "-- 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?")*

Why would someone put an extra app, when for example my competitor normally the file with the price list open in Excel. Minus the potential buyers - the third part! This is not serious.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) 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
-
-

9 years 11 months ago [\#258058](#258058) 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?start=20#258058 "-- 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,

You don't need to use notepad++ or any additional application.
HikaShop provides CSV files by default in UTF8 which can be opened properly with any excel-like application and display properly there. UTF8 is the only encoding which supports all the existing characters of all the languages. So that's the encoding that most software use to export/import data so that it can be displayed properly everywhere. It would actually be impossible to export orders with both arabic and japanese names with any other encoding for example.
It's the same with web pages, most of them use UTF8 for the same reasons.
If you have a problem when you try to display the CSV from HikaShop in Excel, the problem is not with HikaShop. It's because you're trying to open the CSV file with another encoding than UTF8.
Here is a tutorial to open a CSV in UTF8 with Excel if you have issues with encoding:
[ www.itg.ias.edu/content/how-import-csv-f...character-encoding-0](https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTM5NC11dGY4LWltcG9ydC1hLWFlLW9lLW5vdC13b3JraW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) 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.070 seconds

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