CSV to MySQL

planetsim · 12-02-2003, 11:34 PM

Just a little thing i made that allows you to select a database, a table within the database, upload a .csv File and add it to that table.

Its not pretty but give me your comments on what should be added.

f8ball · 02-03-2004, 10:34 PM

Says there's too many fields, but they are the same. Also curious if you have the option of changing the delimiter and if it erases the current info or just adds to it. Pretty smooth otherwise.

planetsim · 02-04-2004, 05:24 PM

Hey thanks for your feedback. it was a quick thing i made when i needed to get a CSV file from a client with over 10000records so its messy and was only meant for that situation.

On the other hand where is this too many fields error coming into it, its been a while since ive been required to use this..

f8ball · 02-04-2004, 07:13 PM

I'll have to check it again tonight. I think what's going on is my CSV has a tiny blob w/a comma in it and the script thinks that means a new field has formed .. so it moves everything over and then I get the error that the fields don't match up.

planetsim · 02-04-2004, 10:15 PM

Ill probably make it a class if i get time to update it will probably fix that error, and yes i see what you mean as well.

ceo4u · 02-08-2006, 06:07 PM

Here's a great site to help with converting from CSV to MySQL >>>

www.ceo4u.com/data

***bpat1434*** · 02-13-2006, 11:39 PM

nothing like dredging up an old topic.... two years old.....
but otherwise pretty nice....