What’s this for??
I have some Digital Juice SFX library DVD files from circa 2006 or some such. The DVDs contained tons of small WAV and MP3 files of sound effects, foley and music. They’re meant to be accessed with Digital Juice’s Juicer app, which contains all the metadata. I lost the DVDs a while ago, but had already copied them to my file server.
The problem is that I don’t want to use the Juicer app. I have a bunch of other sound libraries, and want to be able to search them all at once. Unfortunately the sound files on the DVDs are all named generically, such as
00293_SFX.wav, which is pretty useless.
I did a quick search for a solution, and came up with this StackExchange post wherein LiquidBlasted posted a series of Excel files that he’d generated by screen scraping the Juicer app.
Even though he somewhat automated that process, it sounds like a heck of a lot of work. So he gets all the credit here for the hard part being done.
I coded up a utility in C# that will read CSV files generated from LiquidBlasted’s Excel files and then iterate through all of the Digital Juice SFX library directories on my computer, renaming the files to include the track names from the CSV.
The net result is that it turns a file name like
01984_SFX.wav (useless) to a file named
Caulk Gun Tension Rod Pulled Back_01984_SFX.wav (useful)! Without further ado, here are a couple of download links:
|DigitalJuiceRenamer_src.zip||64 KB||Source code and executable.|
|DigitalJuiceRenamer_bin.zip||30 KB||Executable and LumenWorks CSV library.|
How do I use it?
- Download the zip file containing the executable.
- Unzip the files into a new directory. ( e.g. C:\temp\DigitalJuiceRenamer\ )
- Read the README.txt file. (If you’re using the source files, then the readme contents are at the top of
Program.cs.) It has important info of which you should be aware, lest you hose your whole library!
- When ready, run the program from the command line using this syntax:
DigitalJuiceRenamer.exe [CSV File] [Top Level Directory of SFX Library]
- IT WILL NOT ASK YOU TO CONFIRM OR ANYTHING. IT WILL IMMEDIATELY START RENAMING FILES! Please read the readme.
Note: If there are spaces in either of your file paths, enclose the paths in double quotes (like in the sample below).
If it runs successfully, you should have something like this:
DigitalJuiceRenamer.exe e:\temp\DigitalJuiceTracks.csv “\\fsrv01\Audio\Sound Effects\Digital Juice Sound FX Library DVD – Part 01-10″
Reading CSV File… DONE! (Stored 11593 out of 11593 records.)
Getting files… DONE! (Got 23201 files.)
Renaming files… DONE! (Success: 23201, Failed: 0).
FINISHED with 23201 files renamed out of 23201 files total, and 11593 CSV records total.
If it fails to rename any files (e.g. if they’re in use) you’ll get an error message and the program will continue.
So long as the number of files it “got” is equal to the number of files renamed, you’re good to go!
The actual renaming part may take a while. It took about 3 minutes for my library, but that was on a network share. On a local disk it should be much faster.
"I use a Mac"
Sorry, I coded this up in Visual Studio and the executable will only run on Windows.