Backup DVDs everywhere; how to inventory as spreadsheet?
- ;ivlunsdystf
- ghost haunting audio students
- Posts: 3290
- Joined: Mon Oct 18, 2004 7:15 am
- Location: The Great Frontier of the Southern Anoka Sand Plain
- Contact:
Backup DVDs everywhere; how to inventory as spreadsheet?
I have an ever-growing pile of backup dvds, each burned as a data disc with many folders within. Is there a way to inventory everything into a single spreadsheet so I can easily find something from amongst the discs later by looking it up in the spreadsheet?
- TheForgotten
- gettin' sounds
- Posts: 109
- Joined: Thu Aug 23, 2007 11:11 am
- Location: Medford, OR
- Contact:
- ;ivlunsdystf
- ghost haunting audio students
- Posts: 3290
- Joined: Mon Oct 18, 2004 7:15 am
- Location: The Great Frontier of the Southern Anoka Sand Plain
- Contact:
I just want to make a list of each project and what disc it's on. It could be a simple two-column spreadsheet with columns for 'folder name' and 'disc #'. This should be quite simple, right?TheForgotten wrote:Are looking to catalog the structure if each disc or just a list of each project and
what disc it's on?
- JGriffin
- zen recordist
- Posts: 6739
- Joined: Thu Jul 31, 2003 1:44 pm
- Location: criticizing globally, offending locally
- Contact:
Tatertot wrote:I just want to make a list of each project and what disc it's on. It could be a simple two-column spreadsheet with columns for 'folder name' and 'disc #'. This should be quite simple, right?TheForgotten wrote:Are looking to catalog the structure if each disc or just a list of each project and
what disc it's on?
Yeah, you can do that pretty easily in Excel.
"Jeweller, you've failed. Jeweller."
"Lots of people are nostalgic for analog. I suspect they're people who never had to work with it." ? Brian Eno
All the DWLB music is at http://dwlb.bandcamp.com/
"Lots of people are nostalgic for analog. I suspect they're people who never had to work with it." ? Brian Eno
All the DWLB music is at http://dwlb.bandcamp.com/
- TheForgotten
- gettin' sounds
- Posts: 109
- Joined: Thu Aug 23, 2007 11:11 am
- Location: Medford, OR
- Contact:
- ;ivlunsdystf
- ghost haunting audio students
- Posts: 3290
- Joined: Mon Oct 18, 2004 7:15 am
- Location: The Great Frontier of the Southern Anoka Sand Plain
- Contact:
- ;ivlunsdystf
- ghost haunting audio students
- Posts: 3290
- Joined: Mon Oct 18, 2004 7:15 am
- Location: The Great Frontier of the Southern Anoka Sand Plain
- Contact:
They're just folders in windows, so no extensions (or is there a folder extension that I don't know about?) Anyway, I'll take dwlb's post as encouragement and try it using excel (or, actually, the openoffice equivalent) thanksTheForgotten wrote:What is the extension of the project file? (i.e. .doc, .txt)
I might be able to whip up something to help you along quicker.
- TheForgotten
- gettin' sounds
- Posts: 109
- Joined: Thu Aug 23, 2007 11:11 am
- Location: Medford, OR
- Contact:
So you just want a list of the folders?Tatertot wrote:They're just folders in windows, so no extensions (or is there a folder extension that I don't know about?) Anyway, I'll take dwlb's post as encouragement and try it using excel (or, actually, the openoffice equivalent) thanksTheForgotten wrote:What is the extension of the project file? (i.e. .doc, .txt)
I might be able to whip up something to help you along quicker.
I was going to give you a batch file that would just scan your DVD drive and spit the results into a spreadsheet.
Last edited by TheForgotten on Mon Apr 14, 2008 4:07 pm, edited 1 time in total.
- ;ivlunsdystf
- ghost haunting audio students
- Posts: 3290
- Joined: Mon Oct 18, 2004 7:15 am
- Location: The Great Frontier of the Southern Anoka Sand Plain
- Contact:
That's exactly right. Such a batch file would be truly ideal, if it would just list all the folders in a spreadsheet. ThanksTheForgotten wrote:So you just want a list of the folders?Tatertot wrote:They're just folders in windows, so no extensions (or is there a folder extension that I don't know about?) Anyway, I'll take dwlb's post as encouragement and try it using excel (or, actually, the openoffice equivalent) thanksTheForgotten wrote:What is the extension of the project file? (i.e. .doc, .txt)
I might be able to whip up something to help you along quicker.
I was going to give you a batch file that would just scan you're DVD drive and spit the results into a spreadsheet.
- TheForgotten
- gettin' sounds
- Posts: 109
- Joined: Thu Aug 23, 2007 11:11 am
- Location: Medford, OR
- Contact:
Okay, so create a new text file and paste the following code into it:Tatertot wrote:That's exactly right. Such a batch file would be truly ideal, if it would just list all the folders in a spreadsheet. ThanksTheForgotten wrote:So you just want a list of the folders?Tatertot wrote:They're just folders in windows, so no extensions (or is there a folder extension that I don't know about?) Anyway, I'll take dwlb's post as encouragement and try it using excel (or, actually, the openoffice equivalent) thanksTheForgotten wrote:What is the extension of the project file? (i.e. .doc, .txt)
I might be able to whip up something to help you along quicker.
I was going to give you a batch file that would just scan you're DVD drive and spit the results into a spreadsheet.
Code: Select all
dir /n /b /a:d D:\ > C:\TatersResults.xls
c:\TatersResults.xls
double click it and it will read whater cd is in your drive and give you the top-level folder names in a spreadsheet.
So just create a spreadsheet for the compiled results and you can just:
Insert CD>Dbl Click batch file>Paste results from spreadsheet that opens up (TatersResults) into compiled spreadsheet>Close TatersResults spreadsheet>REPEAT
Hope it helps!
Cheers![/code]
- ;ivlunsdystf
- ghost haunting audio students
- Posts: 3290
- Joined: Mon Oct 18, 2004 7:15 am
- Location: The Great Frontier of the Southern Anoka Sand Plain
- Contact:
- JGriffin
- zen recordist
- Posts: 6739
- Joined: Thu Jul 31, 2003 1:44 pm
- Location: criticizing globally, offending locally
- Contact:
yeah, i don't know Excel well enough to explain it, honestly.Tatertot wrote:I'll spare you the agony of explaining how - if I know it can be done I bet I'll be able to figure it out - thanksdwlb wrote:
Yeah, you can do that pretty easily in Excel.
"Jeweller, you've failed. Jeweller."
"Lots of people are nostalgic for analog. I suspect they're people who never had to work with it." ? Brian Eno
All the DWLB music is at http://dwlb.bandcamp.com/
"Lots of people are nostalgic for analog. I suspect they're people who never had to work with it." ? Brian Eno
All the DWLB music is at http://dwlb.bandcamp.com/
- ;ivlunsdystf
- ghost haunting audio students
- Posts: 3290
- Joined: Mon Oct 18, 2004 7:15 am
- Location: The Great Frontier of the Southern Anoka Sand Plain
- Contact:
-
- gimme a little kick & snare
- Posts: 83
- Joined: Fri Sep 15, 2006 2:34 pm
- Location: Los Angeles, CA
- Contact:
- TheForgotten
- gettin' sounds
- Posts: 109
- Joined: Thu Aug 23, 2007 11:11 am
- Location: Medford, OR
- Contact:
Hey, no problem!Tatertot wrote:Alright, the forgotten: you rule. That little deal you wrote just enabled me to get about fifty data dvd's all inventoried in a single hour. Thousand thanks.
You're welcome!
Glad I could help.
I think tinkering with code for 10 minutes to avoid hours of work is always worth it.
Who is online
Users browsing this forum: No registered users and 70 guests