09-28-2021, 12:57 AM
I buy Music Minus One style books and load the songs into Mobile Sheets, so I thought I'd share my process of doing that. It may give you an idea of how to do it more easily, or you may have your method that's better than mine.
If I have the physical book, I scan the songs. My scanner has the capability of creating a PDF file, and I make one for each song. I name the files the same name as the mp3 comp track that was included with the book.
If I am able to get a PDF of the book, I use that. This will be a single PDF for the whole book. In order to have a PDF file for each song, I open the file in Windows. I "print" each song using the Microsoft Print To PDF "printer".
At this point, I can load all the songs into Mobile Sheets using the batch import. I have the option set on to include the audio files by matching the names. By the way, in order to avoid any duplicates, I use a batch file rename utility to add a suffix to each name that is something like the initials of the name of the book. This lets me select all the songs in a specific book if I want to.
The last step is to crop them all. I used to do this by selecting a song, open the edit, select "Files", then click the crop icon, then after cropping all the pages, I'd have to click OK twice, and then open the next song, if I could remember what that was. But I have come up with a way to batch crop. What I do is to load the songs into a temporary collection, using that suffix to select them. Then, I select that collection, and click Load All. Then, I click the center of the first page, and in the menus, I select crop. Now, you can crop each page and click next page to go to the next one, and that way work your way through all of the songs in the collection without having to edit and save each song separately.
The last step is to remove the temporary collection.
That's more or less the way I do it. YMMV
If I have the physical book, I scan the songs. My scanner has the capability of creating a PDF file, and I make one for each song. I name the files the same name as the mp3 comp track that was included with the book.
If I am able to get a PDF of the book, I use that. This will be a single PDF for the whole book. In order to have a PDF file for each song, I open the file in Windows. I "print" each song using the Microsoft Print To PDF "printer".
At this point, I can load all the songs into Mobile Sheets using the batch import. I have the option set on to include the audio files by matching the names. By the way, in order to avoid any duplicates, I use a batch file rename utility to add a suffix to each name that is something like the initials of the name of the book. This lets me select all the songs in a specific book if I want to.
The last step is to crop them all. I used to do this by selecting a song, open the edit, select "Files", then click the crop icon, then after cropping all the pages, I'd have to click OK twice, and then open the next song, if I could remember what that was. But I have come up with a way to batch crop. What I do is to load the songs into a temporary collection, using that suffix to select them. Then, I select that collection, and click Load All. Then, I click the center of the first page, and in the menus, I select crop. Now, you can crop each page and click next page to go to the next one, and that way work your way through all of the songs in the collection without having to edit and save each song separately.
The last step is to remove the temporary collection.
That's more or less the way I do it. YMMV