mayers2007 Posted January 9, 2009 Share Posted January 9, 2009 I am really tired but just don't understand where I went wrong. Exported "Table: Configuration" via phpmyadmin panel. Exported as CSV for MS Excel , checked the box "Put fields names in the first row" Then without editing the file at all , saving it without renaming it in CSV (comma delimited), and Importing it back into the database I receive the following error: Invalid field count in CSV input on line 1. Doesn't make any sense because what was exported was untouched and imported just the same with all fields matching within the table. Any help would be appreciated. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 10, 2009 Share Posted January 10, 2009 How many columns are in the csv file and how many in the table? Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
mayers2007 Posted January 10, 2009 Author Share Posted January 10, 2009 How many columns are in the csv file and how many in the table? 11 columns in both. What phpmyadmin exported is exactly the same file I imported. Untouched. Doesn't make sense does it? Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 11, 2009 Share Posted January 11, 2009 Actually, now I think about it, makes a lot of sense. If you want to import it, you need to export it in sql format rather than csv. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.