Skip to main content

How to escape comma when import from CSV?

More
11 years 9 months ago - 11 years 9 months ago #182105 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
This attachment is hidden for guests.
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.

More
11 years 9 months ago - 11 years 9 months ago #182155 by pljuarez
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
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
Powered by Kunena Forum