i did manage to write my own app to add these shows to the database. however, i did not use the special version of sqlite that you mentioned.
i opened the db file in a text editir and found he header saying sqlite format 3
so i just downloaded version 3_2_7 and was able query the tables so all looked good. do you think i will have a problem using this version of sqlite
i wrote a program in borland c++ builder that allows me scan in a directory full of dvds.
it actualy only scans for directory names and then uses that name as the title for the dvd when adding it to the database. i can add genres and then select which genres to include to the scanned dvds.
i also allow entry of a name to pre-pend to the directory name. i also allow the entry of a name for the imdb xml file
this works for me as if you look at my structure above, if i scan in season 1 the follwoing occurs. the directory names are the names of the individual episode. the program scans these names, adds my prepended text (stargate sg1: season1-) and adds it to sci-fi, action, and series genres. i then create one imdb file for each season and use the same one for every directory scanned.
i could make it more flexible but it worked perfect for what i needed.
i think i will keep working on it to allow browing and editing of the db from a pc. would anyone else be interested in such a tool?
shawn