johnuk — 2010-12-30T09:36:34-05:00 — #1
I am trying to upload a csv file (sample attached), to a simple two column table in mysql. Im getting the "Invalid field count in CSV input on line 1." error.
The two fields are layed out as follows: -
Field Type Collation Attributes Null Default Extra Action
location_code varchar(50) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
location_name varchar(50) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Does anyone have any idea where Im going wrong? thanks!
r937 — 2010-12-30T10:10:40-05:00 — #2
what were you using to import the file?
johnuk — 2010-12-30T12:17:53-05:00 — #3
Hiya there, thanks for your reply. I found the problem in the end, only I cant remember now what I did to fix it (thats not good!)