VirtueMart Forum

VirtueMart 2 + 3 => Product creation => Topic started by: Smitten on January 17, 2012, 23:17:48 pm

Title: Best options for CSV Delimiters?
Post by: Smitten on January 17, 2012, 23:17:48 pm
I'm planning on building my cart up using PhPmyAdmin and exporting/importing CSV files. I have me head around this and am able to resolve simple tables such as Manufacturers.

I have hit a snag with the Products table, due to use of punctuation in the descriptions and markup I would like advice on the best keystrokes for the export.

My version of PhpmyAdmin currently has the following defaults.

Fields terminated by - ;
Fields enclosed by - "
Fields escaped by - \
Lines terminated by - AUTO
Replace NULL by - NULL

Any advice will be welcome.
Title: Re: Best options for CSV Delimiters?
Post by: jenkinhill on January 17, 2012, 23:26:05 pm
Why not use CSVI 4 (http://www.csvimproved.com/) - it is already working in beta on J1.7 with VM2.
Title: Re: Best options for CSV Delimiters?
Post by: Smitten on January 17, 2012, 23:34:38 pm
PHP 5.3, my host is using 5.2.6 for now.

Until they update, I am at a loss.
Title: Re: Best options for CSV Delimiters?
Post by: jenkinhill on January 17, 2012, 23:41:23 pm
5.3 is recommended for Joomla 1.7 and I believe will be required for 2.5. So the host is holding you back....
Title: Re: Best options for CSV Delimiters?
Post by: franzpeter on January 18, 2012, 11:37:09 am
You can use a pipe "|“. Most csv files do not have "|" in text areas or in other areas, so there should not be a conflict.