Invalid format of CSV input on line 415.

lightninglarry

,Wymon Henderson,ATL,DB,ATLDB2,44,38,56,56,0,0,0,0,6,6,56,6,0,0,0,0,250000,1,81
,Eric Moten,ATL,PS,ATLOL7,25,69,31,44,0,0,0,0,0,0,0,0,0,0,0,0,250000,2,D4
,John Davis,ATL,OL,ATLOL3,25,69,31,56,0,0,0,0,0,0,0,0,0,0,0,0,1500000,1,D4
,Will Woolford,ATL,PS,ATLOL6,25,69,31,56,0,0,0,0,0,0,0,0,0,0,0,0,1000000,1,1C
,Robert Harris,ATL,DL,ATLDL1,31,31,38,44,0,0,0,0,6,6,6,6,0,0,0,0,250000,3,D4
,Harold Green,ATL,RB,ATLRB1,44,69,50,38,0,0,0,0,75,38,0,0,0,0,0,0,1000000,1,D1
,Howard Ballard,ATL,OL,ATLOL1,25,69,31,56,0,0,0,0,0,0,0,0,0,0,0,0,1100000,1,C7
,Bill Brooks,ATL,WR,ATLWR1,31,69,38,13,0,0,0,0,81,50,0,0,0,0,0,0,1300000,1,BE
,Simon Fletcher,ATL,LB,ATLLB2,38,56,44,56,0,0,0,0,6,6,25,6,0,0,0,0,2000000,2,B4
,Pat Swilling,ATL,LB,ATLLB4,31,50,38,63,0,0,0,0,6,6,25,6,0,0,0,0,2000000,2,AB
,Tony Bennett,ATL,LB,ATLLB3,38,56,38,56,0,0,0,0,6,6,25,6,0,0,0,0,1000000,1,A5
,Jeff Blake,ATL,QB,ATLQB2,25,69,6,13,38,38,6,44,0,0,0,0,0,0,0,0,2800000,5,9E
,Mike Pritchard,ATL,WR,ATLWR3,38,69,50,13,0,0,0,0,63,63,0,0,0,0,0,0,3300000,4,9C
,Ricky Proehl,ATL,WR,ATLWR2,38,69,44,13,0,0,0,0,50,56,0,0,0,0,0,0,2000000,2,2B
,Vaughn Dunbar,ATL,RB,ATLRB4,38,69,31,38,0,0,0,0,63,25,0,0,0,0,0,0,1100000,3,96
,Wes Hopkins,ATL,DB,ATLDB4,44,56,56,56,0,0,0,0,6,6,50,6,0,0,0,0,1000000,1,96
,Ronnie Lott,ATL,DB,ATLDB3,50,50,63,69,0,0,0,0,6,6,38,6,0,0,0,0,2000000,2,93
,Jim Ritcher,ATL,OL,ATLOL3,25,69,31,56,0,0,0,0,0,0,0,0,0,0,0,0,1500000,1,31
,John Flannery,ATL,PS,ATLOL6,25,69,44,63,0,0,0,0,0,0,0,0,0,0,0,0,1475000,2,12

the error i get is the title, line 415 is in bold

the txt file i put on here starts with line 414

i have no clue what the issue is here, any help would be appreicated

I even completely removed the eric moten record and tried to reupload the text file into mysql server and still comes to line 415

NogDog

What application or script are you running? Is it possible the line number in the error message is referring to the line number in that script, not the line in the CSV file?

lightninglarry

im sorry im a total newb to this, im just uploading a text file into my mysql server, how could i find the info out that ur asking for?

NogDog

Well, the file is not uploading itself, so I was wondering what application you were using to do so. For instance, you might be using phpMyAdmin, selecting "Import" option tab after selecting the database and table to be uploaded. So I was wondering what you were using to do the upload, and it also would help to see the exact error message you are getting (just copy and paste it here).

lightninglarry

yes i was using the method u were talking bout
phpmyadmin

strangely enough heres what i do
i have an excel sheet comma delimted
but then i open with notepad

resave as a new file

but now its loading correctly, i sorted by a column within excel and resaved it, it was sorting from z-a by team name, i reversed it and not uploads correctly

im just happy its working but why would it cause the hickup?

and the exact error message is what i titled this post
strange php 🙂 and mysql

lightninglarry

well its back

i added like 30 more records and get the same error message.

lightninglarry

every once in awhile it will load all my records, and thats if i just sort by a certain column within my excel sheet, still gets hung on line 415/416 every other time however.