Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => 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.
Text only | Text with Images