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 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? 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 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. 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 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
Archived
This topic is now archived and is closed to further replies.