asked on

Script to list contents of CD/DVD in OS X 10.2.8?

Ultimately what I am trying to do is inventory our CD/DVD archive in a mySQL database. I'm pretty sure I can handle the DB part if someone can help me with generating a text file containg the names of files and directories on the CD/DVD.

For instance, we archive our work sort of like this:

Archive Date, #? - DVD
|_12345 company 'description'
| |_Directory_01
| | |_file_01.txt
| | |_file_02.txt
| |_Directory_02
| | |_file_01.txt
| |_Directory_03
| | |_file_01.txt
| |_Directory_04
| |_file_01.txt
|_12346 company 'description'
| |_Directory_01
| | |_file_01.txt
| | |_file_02.txt
| |_Directory_02
| | |_file_01.txt
| |_Directory_03
| | |_file_01.txt
| |_Directory_04
| |_file_01.txt
|_12347 company 'description'

...etc...

So, after a staff member burns an archive, they can just drag the CD/DVD icon onto another icon on the desktop and launch the utility. The utility will log the disc's contents and either INSERT the data into the mySQL database or somehow POST the data to a web-based form.

Any ideas?

ASKER CERTIFIED SOLUTION

brettmjohnson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TunaMaxx

ASKER

Thanks for the response!

I did what you said, but when I drag a DVD image onto the application, all that happens is a quick launch in the dock and that's it. Then no matter where I search, I can't find a file called "odlist.out"

I am logged in using an admin account, so I don't think it would be a permissions thing. Any idea?

Oh! One more thing... the machine I am trying this on is 10.3.9, but the ones the script will run on are 10.2.8. Does that make a difference?

TunaMaxx

ASKER

Oh! I'm an idiot.

Hidden 'tmp' folder doesn't show up in search...

OK... so that part seems to work!

TunaMaxx

ASKER

Now... for maybe another 500 point question: Is there a way to have applescript INSERT into a mySQL database?