homepage Welcome to WebmasterWorld Guest from 54.145.252.85
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
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

10+ Year Member



 
Msg#: 3540891 posted 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

10+ Year Member



 
Msg#: 3540891 posted 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

WebmasterWorld Senior Member rocknbil us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3540891 posted 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.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved