[Skip to main content](#vessel-content) # import promblem when field contain comma ## - **[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")** - [![8stinger8's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Topic Author - [ Offline](/forum/user/9517-8stinger8) Less More - Posts: 8 - Thank you received: 0 - - 14 years 1 month ago - 14 years 1 month ago [\#65632](#65632) by [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile") *[import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#65632 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* was created by *[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")* I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line) Last edit: 14 years 1 month ago by [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 14 years 1 month ago [\#65756](#65756) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#65756 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* Yes, that's normal. You can have several categories separated by a comma. You will have to use something else than the comma if you don't want that or you should do it differently. For example, you could create that category and then have the category id instead of the category name in the categories column of your CSV. The following user(s) said Thank You: [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")** - [![8stinger8's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Topic Author - [ Offline](/forum/user/9517-8stinger8) Less More - Posts: 8 - Thank you received: 0 - - 14 years 1 month ago [\#65872](#65872) by [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Replied by *[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#65872 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* Thank you! I understand. But I have another question: when I import products, and if product ends with quotes, then in hikashop appears without last quotes for example I have in my *.csv procuct **soap "sheep"**, in hikashop it imports as **soap "sheep** but if the last char not quotes, then everything good (**soap "sheep" small** --> **soap "sheep" small**) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 14 years 1 month ago [\#65873](#65873) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#65873 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* Then you should have the text of the column like that: "soap ""sheep""" The first " and the last will delimit the data of the column and the "" will be converted to " during the import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")** - [![8stinger8's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Topic Author - [ Offline](/forum/user/9517-8stinger8) Less More - Posts: 8 - Thank you received: 0 - - 14 years 1 month ago - 14 years 1 month ago [\#65877](#65877) by [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Replied by *[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#65877 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* I do so (see my test.csv in 6 line) and the last " lose Last edit: 14 years 1 month ago by [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 14 years 1 month ago [\#65883](#65883) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#65883 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* Please replace the line: $newProduct->$field = trim($value,'\'" '); by: $newProduct->$field = preg_replace('#^[\'" ]{1}(.*)[\'" ]{1}$#','$1',$value); in the file administrator/components/com_hikashop/helpers/import.php and try again. The following user(s) said Thank You: [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")** - [![8stinger8's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Topic Author - [ Offline](/forum/user/9517-8stinger8) Less More - Posts: 8 - Thank you received: 0 - - 14 years 1 month ago [\#65890](#65890) by [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Replied by *[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#65890 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* It's work! thanks a lot! ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")** - [![8stinger8's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Topic Author - [ Offline](/forum/user/9517-8stinger8) Less More - Posts: 8 - Thank you received: 0 - - 14 years 1 month ago [\#65976](#65976) by [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Replied by *[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#65976 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* I have another question field product_description during import lose html tags (<p>text1<br />text2 text3 text4 text5<br />text6 text7</p> --> text1text2 text3 text4 text5text6 text7) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 14 years 1 month ago [\#66123](#66123) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#66123 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* It's probably your HTML editor which strips out the tags because it's working fine on our end. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")** - [![8stinger8's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Topic Author - [ Offline](/forum/user/9517-8stinger8) Less More - Posts: 8 - Thank you received: 0 - - 14 years 1 month ago [\#66159](#66159) by [8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile") Replied by *[8stinger8](/forum/user/9517-8stinger8 "View 8stinger8's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#66159 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* no, I found that it happend after I replace $newProduct->$field = trim($value,'\'" '); by: $newProduct->$field = preg_replace('#^[\'" ]{1}(.*)[\'" ]{1}$#','$1',$value); Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 14 years 1 month ago [\#66416](#66416) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#66416 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* Then I have no idea. Can you do an import while having the debug mode of the joomla configuration activated and give the traces printed at the bottom of the page ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile")** - [![cosg2004's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9738-cosg2004 "View cosg2004's Profile") - [ Offline](/forum/user/9738-cosg2004) Less More - Posts: 6 - Thank you received: 0 - - 14 years 3 weeks ago [\#68857](#68857) by [cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile") Replied by *[cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#68857 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* How can a field name (e.g. categories) that contain comas (e.g. "books, magazines and cards") be imported as such. I thought you can change the field separator character (e.g. tab, |, etc). Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 14 years 3 weeks ago [\#68967](#68967) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#68967 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* You can use tab or comma or semi colon as field separator. Also, If you have double quotes around your fields, you can even use the same character as the separator in the value of the field. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile")** - [![cosg2004's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9738-cosg2004 "View cosg2004's Profile") - [ Offline](/forum/user/9738-cosg2004) Less More - Posts: 6 - Thank you received: 0 - - 14 years 3 weeks ago [\#69046](#69046) by [cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile") Replied by *[cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#69046 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* Thanks Nicolas. One more question: where do you select the field separator in the back panel of Hikashop? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 14 years 3 weeks ago [\#69066](#69066) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: import promblem when field contain comma](/forum/3-bug-report/65632-import-promblem-when-field-contain-comma#69066 "I found a problem: I import categories, one of them contains comma (for exapmle "fish, meat, vegetables") hikashop creates 3 categories instead one: "fish" " meat" " vegetables" file *.csv attached (19 line)")* For the import, it's detected automatically. For the export, there is an option for that in the Files/Images tab of the configuration. The following user(s) said Thank You: [cosg2004](/forum/user/9738-cosg2004 "View cosg2004's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NTYzMi1pbXBvcnQtcHJvbWJsZW0td2hlbi1maWVsZC1jb250YWluLWNvbW1hP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & 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.126 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)