sorry 'bout the delete/ re-post. i did so to change for a better subject Title
for my "clients" site, i have to list a group of individual artists. i'm opting for PHP / MySQL for obvious reasons here. whatever my ultimate choice for publishing the data, it's been left up to me to extract the existing data from a PDF version of their "catalogue".
i created my db long ago-- based on what data i'll need to list for each artist-- but then i realized, i still have the tedious work to do!
i started off by "mirroring" my MySQL fields in an Excel sheet, so i can at least do a CSV conversion, rather than enter each item separately, for example, by way of the Input Query, HTML form which will be part of this app (to allow the Program Director to add new Artists, as their program membership expands). i took this approach so far because i have experience which taught me how to do that particular method, and i have a little form made to import it w/ fgetcsv(), etc. however, i'm certainly not convinced that this is the best way to approach this task.
what about MySQL specific client apps? i played around w/ the MySQL Query Browser (thinking it had an "insert data" type feature-- similar in GUI to what i'm doing, essentially)-- but i couldn't find what i wanted there. why? isn't it the Perfect way to get raw data into a MySQL table? well-- yes, and no-- i don't want to have to write out an INSERT statement for each bit of data-- heck-- i'd like to be able to simply copy / paste a few lines of text into the tables, as i would if i were copying it into a spreadsheet-- but, i do realize this is a lot to ask-- but i just know there is something out there designed specifically for this circumstance-- i just don't know what it is, cause i've never tried it-- or if it's in the MySQL query browser, i don't know how to do it. i'm looking around over there at mysql.com in the meantime too, but i wanted to ask here in case they aren't the providers of what i'm looking for.
ideas? thanks!!
for now, i'm going to keep goign w/ this, but i am quite interested in what others might do when faced w/ this kind of project. thanks!!
