sorry 'bout the title-- i tried my best to have it make sense for the project i'm facing...
hope you "heard" me correctly...
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 needed there. maybe i wasn't looking in the right place / maybe that's not right at all.
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!!
