text file import with empty cells

User e05b1833aa

10-10-2012 09:05:45

Hi,


When importing a CSV file, where one of the first cells in a column is empty, this column is completely ignored despite column headers being present. If I substitute the top empty cell with 1, everything including empty cells are imported.This is IJC 5.11.1 on Ubuntu, with mySQL-based database.


Is this a mySQL limitation?

ChemAxon 2bdd02d1e5

10-10-2012 12:39:10

Hi, could you please send me a sample of your badly imported data(via e-mail if you prefer)? I tried to import csv file where the values in the first row of several columns were empty. The import proceeded correctly for me. MySQL should not have such a limitation.


Thanks for your help.