i would like to import a csv file into the database so that i do not have to manually make entries when using a cms


initially i selected the database and then the table into which i want to add new data and exported as csv file and then added deleted all the entries in this file and added 1 new entry following the format in the csv file that i exported

when i import this csv file i keep getting the error

Invalid field count in CSV input on line 1.

while importing the csv file i have changed Fields terminated by from ; to ,

what is the correct procedure so that i dont get this error

also when exporting as csv file should i select the Put fields names in the first row option and there are other options as well, how should i go about so that i dont get the error when importing


also if i select the sql option and then delete the entries and make a new entry and if i import this file i get the error
#1062 - Duplicate entry '1' for key 'PRIMARY'

before importing i have selected the database and selected the table into which i want to import the csv or sql file

also before importing the files i suppose i have to make sure that the file i import is the same name as the table whether i import a csv or sql file

please advice how to go about for csv and sql format

also i guess the procedure for csv format can be followed for an
Microsoft Excell 2000 and CSV for MS Excel i guess

Try this should do the trick mysqldumper.net/ its a great tool

Lemme explain to you step by step on how to export the database to CSV.

1. Select the database, then table you wanna export.
2. Click the Export tab.
3. Select CSV for Ms Excel
4. Tick Save As File
5. Go

(Leave all others as default)

Now, when you edit the CSV file with Excel, just edit, but when you save it, Excel will prompt you to save in Excel format. Click No.

Importing CSV file:

1. When you upload the CSV file, it will automatically detect it as CSV.
2. Change the comma seperated to ";"

In the problem that you face, there are some lines in your CSV file that is giving problem, such as spacing issue. Here's what I usually do:

Seperate the file as several CSV files. Then import seperately. You will later find out which row is giving you problem. Then you can fix it.

If you can't fix it, that means the syntax you have may be wrong. Either in this case you have to add it manually, because sometimes phpmyadmin just won't recognize same syntax from Windows (assuming you are hosted in Linux server).

HTH!

Invalid field count in CSV input on line 1

Based on the above it seems the amount of fields in the table in the database is not the same as the amount of fields in your csv file. What it could be is that the table has a field that it uses as the primary id for the table and usually auto increments the value. Because you're importing the .csv you'll need to add those ids. Odds are it will need to be the very first field.

Hope that makes sense.