Invalid column (Address1) specified!

[greens85]

Hi all,

Trying to upload a CSV but have recieved the following error:

Invalid column (Address1) specified!

There are no headers in the CSV, I have also stripped all leading and trailing spaces.. I've also tried entering the column names in the Column names field in PHPmyAdmin...

Can anyone advise? (wont let me upload me the file, might be too big).

I have placed it on the server, so you can download it here:

http://www.teachingagencies.co.uk/testpages/Schools_Edited_2.txt

In its raw format.

Thanks,

Greens85

[Fumigator]

What tool are you using to upload this file? And I assume you are trying to populate a table? What command are you using to do this? Can you just copy one or two lines of the CSV file here?

[greens85]

Hi,

I'm now getting the following error instead:

Invalid field count in CSV input on line 1.

I'm just using the import option in PHPmyAdmin...

The lines read like so:

1,Sir John Cass's Foundation Primary School,City of London,Primary - Voluntary Aided,St James's Passage,Duke's Place,London,EC3A 5DE,2072831147,2076265071,
2,City of London School for Girls,City of London,Independent Primary and Secondary,St Gile's Terrace,Barbican,London,EC2Y 8BB,2078475500,2076383212,info@clsg.org.uk

[Fumigator]

Hi,

I'm now getting the following error instead:

Invalid field count in CSV input on line 1.

I'm just using the import option in PHPmyAdmin...

The lines read like so:

1,Sir John Cass's Foundation Primary School,City of London,Primary - Voluntary Aided,St James's Passage,Duke's Place,London,EC3A 5DE,2072831147,2076265071,
2,City of London School for Girls,City of London,Independent Primary and Secondary,St Gile's Terrace,Barbican,London,EC2Y 8BB,2078475500,2076383212,info@clsg.org.uk

That first line ends in a comma? That's not gonna work...

(edit) well maybe it will-- nevermind me, I was confused.

(edit) yes it should work, as long as there are 11 columns in your table.

(edit) I just remembered, when there is an auto-increment column in the table, you must list all of the column names on the import screen in that entry field labeled "Column names".

[greens85]

That first line ends in a comma? That's not gonna work...

Ah right...

What do I need it to end in & how do I make it end in that?

may be a silly question but my knowledge is limited!

It may also be worth mentioning that, every line that doesnt contain an email address ends the same!

[Fumigator]

Ah right...

What do I need it to end in & how do I make it end in that?

may be a silly question but my knowledge is limited!

It may also be worth mentioning that, every line that doesnt contain an email address ends the same!

Sorry about the confusion, see my edits above. You've got to list all of the column names on the import screen.

[greens85]

(edit) I just remembered, when there is an auto-increment column in the table, you must list all of the column names on the import screen in that entry field labeled "Column names".

I did that... thats why I couldn't understand why it was working!

[greens85]

Ive managed to get them imported now...

"The field terminated by" was set to ';' so i changed it to ','

however it hasnt imported the ids correctly, its starts on 0 then goes 2, then from 4-8 :confused:

[Fumigator]

Ive managed to get them imported now...

"The field terminated by" was set to ';' so i changed it to ','

however it hasnt imported the ids correctly, its starts on 0 then goes 2, then from 4-8 :confused:

Yeah that's weird; as long as you specify the auto-increment column name it should use the value in your file.