Generate SFX Credits for freesound.org
Mar. 13th, 2023 07:42 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
godoflaundrybasketsGenerate SFX Credits Spreadsheet:
A bit ago, I made a google spreadsheet that can take a list of freesound.org filenames and then generate your SFX html credits for you! I ended up sharing it again recently but I figured I'd share here as well
Not sure of anything I could elaborate here, but let me know if you have any questions. To make this feel like an actual useful post, I'll also give a more technical shortcut for a quick way to copy all of the files in a folder (so if your effects are organized via project, you can more easily copy over all the file names).
Macs:
Sadly I don't have one so can't make screenshots. But theoretically it's very easy according to this help article but sadly I cannot help too much there.
Windows:
1. Open the command prompt from windows search bar
2. Open the folder that has the effects and copy the path
3. In the command prompt type in "cd YOUR_PATH" so in my example it would be "cd C:\Users\digiella\Desktop\effects"
4. Now type in "dir /b /s |clip" --> basically this command tells the computer for print everything in this directory then copy it to the clipboard.
5. Now you can go to google sheets (or excel or whatever) and paste in what you copied. It will look like this:
6. Then do the find and replace (Edit -> Find and Replace or CTRL-H) and take the beginning of the path and replace it with nothing. Set up like below.
7. You should be left with a list of just the filenames that you can copy into the spreadsheet that does the link generating.
A bit ago, I made a google spreadsheet that can take a list of freesound.org filenames and then generate your SFX html credits for you! I ended up sharing it again recently but I figured I'd share here as well
https://docs.google.com/spreadsheets/d/1H-KlBh_wyUO1V1AEojgio6zEqnvZEsG-EUTFeaEQUqc/edit?usp=sharing
Not sure of anything I could elaborate here, but let me know if you have any questions. To make this feel like an actual useful post, I'll also give a more technical shortcut for a quick way to copy all of the files in a folder (so if your effects are organized via project, you can more easily copy over all the file names).
Macs:
Sadly I don't have one so can't make screenshots. But theoretically it's very easy according to this help article but sadly I cannot help too much there.
if you simply select several files in finder and do command+c and then paste it into a plain text document (or in an excel file for that matter) it will paste the file names.
https://discussions.apple.com/thread/1850895
https://discussions.apple.com/thread/1850895
1. Open the command prompt from windows search bar
2. Open the folder that has the effects and copy the path
3. In the command prompt type in "cd YOUR_PATH" so in my example it would be "cd C:\Users\digiella\Desktop\effects"
4. Now type in "dir /b /s |clip" --> basically this command tells the computer for print everything in this directory then copy it to the clipboard.
5. Now you can go to google sheets (or excel or whatever) and paste in what you copied. It will look like this:
6. Then do the find and replace (Edit -> Find and Replace or CTRL-H) and take the beginning of the path and replace it with nothing. Set up like below.
7. You should be left with a list of just the filenames that you can copy into the spreadsheet that does the link generating.