Yes, unless you wish to use exactly the iso date format, you might want to set the column data type as string.
It is like this so it’s easier to use with mySQL NOW() etc functions - useful for filters.
In any case, it seems to work fine on our test CMS, so what I did:
Create 10 columns in my .csv file and 8 rows with some random strings in it (well one date, rest random strings),
Create a dataset in CMS, create 10 columns with correct names (ie corresponding to my .csv) in this dataset
Click Import .csv, make sure to give each column a column number that corresponds to column heading (do that before you upload your .csv)
Add CSV files -> select my csv
Upload
Done
While I can understand that the date (if it was set to date data type) can give you some problems, I’m not sure about this:[quote=“TVW, post:4, topic:8166”]
the first colomn is left empty and the data from col1 is set in col10.
[/quote]
Assuming of course that you did give correct numbers to each column before you uploaded your .csv