CSV Import - Multiple Fields

Thanks, Chris - I can't tell you how much time that would save, as we're haveing to import data a column at a time.

PHP Version 5.4.26

I don't have a proper solution for you as of yet, but here's something you can try in the meantime that might help:

Open the CSV file in a text editor and do a search-and-replace of

,,

with

,"",

Thus, you'll change

0001,Title,Description,,Item,,,Item

into

0001,Title,Description,"",Item,"","",Item

...which should work.

You may need to repeat the search-and-replace to catch all the double commas.

Note that if you have any double commas in legitimate strings, such as

0001,Title,"My favourite punctuation characters are the comma,, doublecomma,, and the semi-colon.",,Item,,,Item

...you'll need to manually fix that line because after you do the search-and-replace, you'll have a line that isn't valid CSV:

0001,Title,"My favourite punctuation characters are the comma,"", doublecomma,"", and the semi-colon.","",Item,"","",Item

Hope this helps!

Another workaround you might try is opening the CSV file in a spreadsheet program (such as Excel or Calc) and then exporting it as a CSV — it's possible that the program will (a) properly import the CSV file and (b) export the CSV in a format that CSV Import can read.

Thanks for the tips. We tried both single anddouble quotation marks and just "null", ie:

,'', or ,"", or ,null,

And unfortunately, CSV used the various text as entries in the fields rather than leave them null. Maybe CSV Import needs a tweak where if it detects an empty field, it uses "null" for the MySQL insert/update?