mbrown Posted February 28, 2009 Share Posted February 28, 2009 Here is my csv file ID,DistrictTag,SerialNumber,ItemName,Type,Type1,Model,month,day,year,DateofPurchase,Grant,Building,Room,Status,Specs,WorkedOn,Surplus, ,987654321,987654321,Test Item 2,Laptop,N/A,HP,1,22,2008,1/22/2008,N/A,WASHS,203,In Use,N/A,No,No, I am getting the following error Invalid field count in CSV input on line 1. I have the correct number of fields and what not. ID is auto incrementing Quote Link to comment https://forums.phpfreaks.com/topic/147309-xls-to-csv-and-import-to-database/ Share on other sites More sharing options...
fenway Posted February 28, 2009 Share Posted February 28, 2009 From what query? Quote Link to comment https://forums.phpfreaks.com/topic/147309-xls-to-csv-and-import-to-database/#findComment-773315 Share on other sites More sharing options...
mbrown Posted February 28, 2009 Author Share Posted February 28, 2009 i would just have a .csv file. I would upload it via phpmyadmin Quote Link to comment https://forums.phpfreaks.com/topic/147309-xls-to-csv-and-import-to-database/#findComment-773340 Share on other sites More sharing options...
fenway Posted March 1, 2009 Share Posted March 1, 2009 Check the counts.... not sure how much control you have of input via phpmyadmin. Quote Link to comment https://forums.phpfreaks.com/topic/147309-xls-to-csv-and-import-to-database/#findComment-773700 Share on other sites More sharing options...
e9 Posted March 1, 2009 Share Posted March 1, 2009 i had this error once, and it was becuase in phpmyadmin i had set the wrong character for the 'fields terminated by'...see pic on following url: imort csv via phpmyadmin Quote Link to comment https://forums.phpfreaks.com/topic/147309-xls-to-csv-and-import-to-database/#findComment-773785 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.