Page 1 of 1

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

Posted: Mon Aug 18, 2014 1:31 pm
by 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


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

Posted: Mon Aug 18, 2014 2:03 pm
by Evgene Karachevtsev

Hello Joe,

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


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

Posted: Mon Aug 18, 2014 2:51 pm
by 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


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

Posted: Tue Aug 19, 2014 12:24 am
by 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.