Excel csv collection import error 'One of the column names in header descriptions is absent'

[Joe Sharples]

When i try to import an csv file i keep receiving the error 'One of the column names in header descriptions is absent'.

I'm new to appery and databases in general, but my interpretation of the error is that one of my header names doesnt contain any data. I've checked my excel spreadsheet and all columns have data in row 1.

I created a new spreadsheet ensuring that all cells are containing data.
I saved the file as a csv file and tried the import again.

I recieved the same error. I searched for a solution I couldn't find one.

Please can you help me

[Evgene Karachevtsev]

Hello Joe,

Could you pleae send us the first 2-3 lines from your csv file?

[Joe Sharples]

Originally it was:
Day, Night, Club, Address, Times, Price.

But I created a collection inside appery and exported and opened it in excel.

The new headings are:
Day:string, Night:string, Club:string, Address:string, Times:string, Price:string.

I acknowledge now that I was missing the data type.

I feel this has resolved my problem.
Do you feel there is anything else i should be aware of going forward?

Cheers

[Yurii Orishchuk]

Hi Joe,

Please take a look about file csv format here: http://devcenter.appery.io/documentat...

Also if you will have this problem please provide us link to your problem file.

Regards.