importing csv file in phpmyadmin

sudhakararaog

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

NogDog

sudhakararaog;10943380 wrote:
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.

Is the first line(s) of the CSV file empty by any chance?

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

Sounds correct to me, assuming that's the delimiter being used in the CSV.

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

If you put in the field name row, then when importing you need to specify to skip it in the "number of records to skip..." part of the import screen.

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'

How did you delete the existing records? You may want to do a TRUNCATE, which I believe is what the EMPTY tab does in the phpMyAdmin screen.

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

I don't think the file name matters, just which table is currently selected.

please advice how to go about for csv and sql format

I normally use the SQL method instead of CSV, including the "drop table if exists" option when saving the SQL. I've not really worked with phpMyAdmin's CSV method.

FreeGroup

Dear

you can use dbTube.org instead of phpMyAdmin.

greetings