CD cataloging software

[dvmorris]

At my office, a guy has set up an access database to store information about each backup cd he makes as a project is finished, or as any data is moved off the main server. He also managed to make a small addition that generates a cd cover from the access database for each entry.

 

we're trying to figure out now the best way to store info about the cd contents, so we can search through files without putting each cd in the drive, and possibly getting that to sync or integrate wtih the access database, and even automatically print a list filenames or thumbnails on the inside cover of each cd sleeve.

 

this isn't really about cg per se, but i couldn't think of where else to ask a question like this... thanks for the help,

 

dave

[mskin]

im not really sure what your asking.

 

im thinking that to achieve what you want you need to create a table for each cd and fields for each file....

 

you could then querry file names and have it tell you what table (or cd) its in.

 

forgive me, im not used to access and its been a year since i've used MySql... but i cant see why it would be difficult to do something like this...

 

also, the following command:

 

dir [path] > anynam.txt

 

will print the contents of a directory into a text file.... can be useful for quickly collecting a large number of names from a file.

 

hope this was helpfull

[dvmorris]

well, there are programs like this:

 

http://www.brothersoft.com/file_disk_management/disk_management/smart_cd_catalog_standard_48381.html

 

that let you put in a cd, and store the structure of its contents in a database, so you can search for files without putting the discs in the drive. also, nero allows you to print the folder contents on the case when you create a cd case with the wizard.

 

i would really like all these features to be integrated into one place, so we don't have to jump around to find old stuff and create new stuff.

[Jeff Mottle]

I'd take a look at AlienBrain. It's a Digital Asset Manager meant for the 3D industry. http://www.alienbrain.com/ I did some reading and it will also work with offline files as well.