Updated import specs to include another column from csv file - no data gets imported

[QueeniePie]

Morning all,

I've inherited a database which I am struggling a little with. Every week I import a csv file and then work some magic on it to get results. I have been asked to include another column in the database which already exists on the original csv file. I changed the import specs for the csv in question by adding another column to the list (in both the original csv and the database the column appears at the very end). The data in the column should either be 0 or 1 so I've put all the data types as a number. I've added the exact same column name in the tables it is to be imported into.

Whenever I import the data, the column name appears, but nothing else. A nice long column of blanks all the way down.

What am I missing?

Thanks for looking

 

[BrianMH]

Is the 1 or 0 surrounded by quotes in the csv file? If so then it is stored as text.

 

[QueeniePie]

Thanks for getting back to me so quickly. I checked the csv file import and there are indeed quotes. I changed everything to a Text data type and imported again but I'm still not getting anything in the column.

 

[BrianMH]

Try importing it into a new table and creating a new spec. Then use the spec to import into your current table.

 

[QueeniePie]

Hi Brian,

I'm afraid I may have solved the problem. My colleague had created this extra column in the csv file from the server the data lives on. What we failed to notice was that the column was being created in a different csv file and thus there was no data to import >_<

Fixing it now and then it'll probably work

Thanks for all the suggestions.