Renaming Audio Excerpt File

If you are uploading Audio Excerpt files via ftp, they must be named to match the existing ISBN on NetGalley (not necessarily the audiobook ISBN). This allows our system to correctly match your file to the existing title record. The file name must follow this format: ISBN-excerpt.mp3

To rename many files at once, follow these steps. 

First, download and install Advanced Autorenamer (https://www.advancedrenamer.com/download). Please note that Advanced Autorenamer will only work when using a PC.

Using Advanced Autorenamer

  1. Create a spreadsheet with two columns. Name Column A Audio and Column B NetGalley. Save the file in .csv format.
  2. Add your current mp3 file names in Column A. Be sure to add .mp3 as part of the file name in both columns.
  3. Sort the sheet in ascending order by the Audio column (A).
  4. Put all of your MP3 files into a single folder on your computer.
  5. Open Advanced Autorenamer.
  6. Click the Import button at the top and choose Files from CSV...zd1.png
  7. Click the three dots to the right of the Filename box to select the spreadsheet you created in Step 1.
  8. Click the three dots to the right of the Base folder for original files box to select the directory where your MP3 files reside.
  9. Type a comma into the Column Separator box and check the box next to First line is a header.
  10. Column for original filename should be 1Column for new filename should be 2. The bottom half of the window shows the data that will be imported. If a filename in the spreadsheet does not correspond to a file in the directory, it displays in red and will not be imported.zd2.png
  11. Click Import. The data imports with the original filenames listed under the Rename Files tab and the new filenames listed under the List method on the left.zd3.png
  12. Click the Add method button on the upper left and choose Add.
  13. In the Add: box of the Add window, type -excerpt.
  14. In the At index: box, type 0.
  15. Click the box next to Backwards and choose Name in the Apply to: dropdown menu. Note that the list under New Filename shows the new ISBNs followed by -excerpt.zd4.png
  16. Click Start Batch in the upper-right corner, then Start. Click OK. The files in your directory should have the correct new filenames.

Once your files are named correctly, you may upload them to the ftp. Follow the instructions found here.

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful