CSV Import - Multiple Fields

Thu, 17 Apr 2014 07:51:55 -0700

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?

CSV Import - Multiple Fields

Wed, 16 Apr 2014 15:19:41 -0700

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

CSV Import - Multiple Fields

Tue, 15 Apr 2014 10:10:17 -0700

How can we import a CSV file with empty fields?

What's currently happening is the import software takes the below sample row:

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

...and shifts the data to remove the empty fields, which places fields into the wrong column, ie:

0001,Title,Description,Item,Item

Thanks for any help