homepage Welcome to WebmasterWorld Guest from 54.237.95.6
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
CSV files won't upload
Invalid field count in CSV input on line 1
Lovejoy




msg:3540893
 4:03 am on Jan 5, 2008 (gmt 0)

Hi All,

I've been trying to upload a csv file to my database set up on godaddy via Phpmyadmin, but I keep getting the same error message, "Invalid field count in CSV input on line 1"

I've only got five columns in the database table and my csv file reads as follows eg.

HNnumber,Name,Description,Issued,Value
HN4793,Lady Sarah Jane,NA,New release,375.00,

I've uploaded this same csv to another database without any problem, anyone have any idea what's wrong?

Lovejoy

 

Lovejoy




msg:3541062
 2:50 pm on Jan 5, 2008 (gmt 0)

I figured it out, the phpmyadmin didn't like the comma at the end of the row. I removed the comma at the end of each line (all 485 0f them)and up it went. Strange, the other uploader would accept csv's without a comma on the end.

Lovejoy

rocknbil




msg:3541213
 7:25 pm on Jan 5, 2008 (gmt 0)

Well, you got it - but the extra comma at the end told the program there was another field there with a blank value. The end of a line is determined by the newline character between the lines.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved