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

#   CSV Export - comma escaped in category name

##

- **[korzo](/forum/user/34428-korzo "View korzo's Profile")**
- [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile") Topic Author
- [ Offline](/forum/user/34428-korzo)

Less More

- Posts: 193
- Thank you received: 76
-
-

11 years 10 months ago [\#184902](#184902) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  *[CSV Export - comma escaped in category name](/forum/3-bug-report/873937-csv-export-comma-escaped-in-category-name#184902 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6  When category name contains comma, in csv export file this comma is escaped with backslash in product's category column.  I attached csv file from demo site(I changed &quot;English books&quot; to &quot;English , books&quot;). Take a look at line 11(correct &quot;English , books&quot;) and line 76(incorrect &quot;English &#92;, books&quot;).")* was created by *[korzo](/forum/user/34428-korzo "View korzo's Profile")*

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6

When category name contains comma, in csv export file this comma is escaped with backslash in **product's category** column.

I attached csv file from demo site(I changed "English books" to "English , books").
Take a look at line 11(correct "English , books")
and line 76(incorrect "English \, books").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NzM5MzctY3N2LWV4cG9ydC1jb21tYS1lc2NhcGVkLWluLWNhdGVnb3J5LW5hbWU/dG1wbD1tYXJrZG93bg==) 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: 86564
- Thank you received: 14311
-
-

11 years 10 months ago -  11 years 10 months ago [\#184912](#184912) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[CSV Export - comma escaped in category name](/forum/3-bug-report/873937-csv-export-comma-escaped-in-category-name#184912 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6  When category name contains comma, in csv export file this comma is escaped with backslash in product's category column.  I attached csv file from demo site(I changed &quot;English books&quot; to &quot;English , books&quot;). Take a look at line 11(correct &quot;English , books&quot;) and line 76(incorrect &quot;English &#92;, books&quot;).")*

Hi,

That's a good catch ! Thank you for the feedback !
Here is a new version of the file administrator/components/com_hikashop/views/product/tmpl/export.php with the patch applied to avoid that:
*This attachment is hidden for guests.
Please log in or register to see it.*

We add it in next version of HikaShop.

Last edit: 11 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile").

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

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