Escaping Characters

-- HikaShop version -- : 2.Latest
-- Joomla version -- : 2.5.Latest
-- PHP version -- : 5.4.Latest

Simple question, how do we escape a semicolon in the CSV? We've tried exporting a sample category and product with semicolons in their names and/or description but HikaShop doesn't escape the character during the export. When we try importing with the semicolon still there, the category or product is broken.

We can escape quotes, but haven't found a way to escape semicolons. Any help would be appreciated.

Thanks.

Hi,
Note that characters inside your product name for example won't need to be escaped, here is an example :

"my;product;name";"my;product;description";

Your issue is probably coming from the fact that the structure of your exported CSV was modified when you opened it with one of your program.
You can attach your CSV file if you want me to check it for you .

As our catalog grew, Hikashop will no longer export. Here's a sample we did on a fresh, test install.

All we did was create a new category under Store Categories called Sample; Test Cat With Semi ... we put the ';' after Sample to demonstrate what happens.

Next, we did an export in Hikashop and we got the attached file. Now, import the file with no changes and you will have 3 categories under Store Categories instead of 1.

Store Categories
-- Sample; Test Cat With Semi
-- Sample
-- Test Cat With Semi

We thought we could use the ; or hex code, but each of those ends with a semicolon. LOL!

I guess we can switch to the comma and replace all the commas in our titles and descriptions with their hex equivalent.

Well, it's indeed a bit tricky to use the semicolons.
If you can use something different such as coma it will be easier. If you want to keep with this, we'll try to find a solution.