How to escape comma when import from CSV?

  • Posts: 79
  • Thank you received: 3
9 years 11 months ago #182105

-- 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

File Attachment:

File Name: Tabla_Auto...ueba.csv
File Size:0 KB

Attachments:
Last edit: 9 years 11 months ago by pljuarez.

Please Log in or Create an account to join the conversation.

  • Posts: 79
  • Thank you received: 3
9 years 11 months ago #182155

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: 9 years 11 months ago by pljuarez.

Please Log in or Create an account to join the conversation.

Time to create page: 0.062 seconds
Powered by Kunena Forum