All CSV data not being uploaded

Jef_Leeson

Being a newbie, I have run into a wall regarding uploading a csv file into a table. It seems only the first row of each section is successful. Any ideas why???

gardnc

One jumps to mind. You're not reading the entire CSV file!!!

Jef_Leeson

...that's SO correct... but why skip rows like this?

thorpe

Should we have another guess or do you want to show us some code?

Jef_Leeson

The attached GIF shows the upload settings used thru phpMyAdmin 2.6.4-pl2 gui on a MySQL 4.0.25 db. Only rows with the first unique primary field are adding.

...and what's the link for patience towards newbies?...

gardnc

Alright, once the data gets to the server where the update will take place, what actually runs the update - and more specifically - what is the code that runs the update - meaing please post the PHP code that reads the CSV file.

Jef_Leeson

Unfortunately, the posting code is behind the form which is the GIF, above. I wish I could get it. Is there some limitation, i.e. unique data, which is part of SQL table usage? I suspect the PRIMARY KEY... and if so, can PHP work around this?

gardnc

If the code is not examinable by you, what kind of PHP work around do you mean. Do you mean is there a way to write your own PHP code to read the CSV and insert it into the SQL database?

Jef_Leeson

I've attempted to write code to no avail, but even when this is together, can PHP work around some limitation with unique fields/primary key, if there are such limitations?

A SQL forum would help me, as well...

gardnc

No, PHP is not going to help if the data you want to put in the SQL data base conflicts with the table as established. If we had a better understanding of what you were doing we might be able to help more.

But it sounds like the data is not compatible with the table. Do you know what the table definitions are fror the rows, and which columns in the CSV are to be placed in which of the SQL columns? Perhaps a tweak of the CSV data would do what you need, i.e. add a unique key to the data.

Jef_Leeson

Yes! That is worth a try... the data is quite simple... if a unique ID number, for example, is added as a column with it set as primary... I'll give it a go...