- Posts: 79
- Thank you received: 3
How to escape comma when import from CSV?
11 years 9 months ago - 11 years 9 months ago #182105
by pljuarez
How to escape comma when import from CSV? was created by pljuarez
-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.2.3
Hello, we have a book store and we use authors as a categories. We need import authors names into categories and we have a CSV UTF-8 file whith authors names like:
parent_category;categories
Authors;Surname, Name
Note we need to use "Surname, Name" format but when we import the file, hikashop create a category for Surname and another diferent category with Name.
We have created a category manually and we have exported to see the format used by HikaShop. We tried enclosed "Surname, Name" in double quotes like Hikashop do, but when we import problem persists. Atached to this message you can find file we are using to import categories (we use Notepad++ ASCII editor to edit it).
What can I do to escape comma in author's name?
Regards
-- Joomla version -- : 3.2.3
Hello, we have a book store and we use authors as a categories. We need import authors names into categories and we have a CSV UTF-8 file whith authors names like:
parent_category;categories
Authors;Surname, Name
Note we need to use "Surname, Name" format but when we import the file, hikashop create a category for Surname and another diferent category with Name.
We have created a category manually and we have exported to see the format used by HikaShop. We tried enclosed "Surname, Name" in double quotes like Hikashop do, but when we import problem persists. Atached to this message you can find file we are using to import categories (we use Notepad++ ASCII editor to edit it).
What can I do to escape comma in author's name?
Regards
This attachment is hidden for guests.
Please log in or register to see it.
Please log in or register to see it.
Last edit: 11 years 9 months ago by pljuarez.
Please Log in or Create an account to join the conversation.
11 years 9 months ago - 11 years 9 months ago #182155
by pljuarez
Replied by pljuarez on topic [solved]How to escape comma when import from CSV?
Hello, after hours of searching, I found a solution to my problem reading a topic called "
escaping special characters in import csv file
"
Its to simple, use a backslash before comma \,:
"parent_category";"categories"
"category";"Surname\, Name"
this solution avoid the problem.
Regards
Its to simple, use a backslash before comma \,:
"parent_category";"categories"
"category";"Surname\, Name"
this solution avoid the problem.
Regards
Last edit: 11 years 9 months ago by pljuarez.
Please Log in or Create an account to join the conversation.
Time to create page: 0.180 seconds