Author Topic: Best options for CSV Delimiters?  (Read 2531 times)

Smitten

  • Beginner
  • *
  • Posts: 9
Best options for CSV Delimiters?
« 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.

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27898
  • Always on vacation
    • Jenkin Hill Internet
Re: Best options for CSV Delimiters?
« Reply #1 on: January 17, 2012, 23:26:05 pm »
Why not use CSVI 4 - it is already working in beta on J1.7 with VM2.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.8.5 10338 on Joomla 3.9.22 PHP 7.4.9

Smitten

  • Beginner
  • *
  • Posts: 9
Re: Best options for CSV Delimiters?
« Reply #2 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.

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27898
  • Always on vacation
    • Jenkin Hill Internet
Re: Best options for CSV Delimiters?
« Reply #3 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....
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.8.5 10338 on Joomla 3.9.22 PHP 7.4.9

franzpeter

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 467
    • 2in1-online | Software, Mac, PC, Netzwerk, Drucker, Pad, Display
  • VirtueMart Version: Virtuemart 3.2.6
Re: Best options for CSV Delimiters?
« Reply #4 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.