• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to Bulk Import PDFs, and use the file name to populate different fields
#1
Hi Everybody,

I have a large collection of music pdfs, and I was hoping to be able to use the name of each file, to save sorting information.

Here's an example of what I mean. This is the file name of a couple of my PDF files. The format is the same for all my music PDFs.


Alice Cooper - Steven - Keys                               So it's "Artist" - "Title" - "Collection"
David Bowie - Life On Mars - Chords

So I'm hoping the info on the file names can automatically populate these fields

As it is, I can only add a bulk load of to the collection area, but then I have to manually, pick files and enter in the other info.

Does anyone know if/how this is possible to do?

Thank you!
Reply
#2
When I import many PDFs at once, I import all those that will have the same fields and allocate those fields when asked during the import. Then I import the next batch which will have their own, shared fields.
Reply
#3
I do not currently support populating metadata from information in the song titles. That's something I may support in the future, but then it would be required to specify a mapping between the expected song title formatting and the metadata fields along with the UI I would have to create for that.

Mike
Reply
#4
(01-18-2025, 07:09 PM)Zubersoft Wrote: I do not currently support populating metadata from information in the song titles. That's something I may support in the future, but then it would be required to specify a mapping between the expected song title formatting and the metadata fields along with the UI I would have to create for that.

Mike

Hi Mike, I think it would be a worthwhile upgrade, even if it would support just the 2 Fields, "Artist" and "Title", song title being the most important, because that's the one that's going to be different on almost every piece of sheet music. As it is, it takes a lot of time to add songs to the program. And it would make recreating your database of music much easier, if you feel the need for a fresh restart.
Please consider it.
Thanks for you response,
Rick
Reply
#5
I believe that you can put your files into a tree structure where each subfolder represents a different metafield.
The metafields will then be set when the files are imported.
You might have to have "don't let MS manage the files" (or whatever it is called)

You would need to get your files into the correct tree structure and use some tool to remove the common meta data from the filenames prior to the import.

Suggest you set up a small tree to see if you can establish the method before spending time organising your files (search the forum for clues; I've never used this)

Sciurius may have some tools (not sure how he spells his username)

Geoff
Samsung Galaxy Tab A6
Reply
#6
(01-18-2025, 07:00 AM)Retro Rick Wrote: Hi Everybody,

I have a large collection of music pdfs, and I was hoping to be able to use the name of each file, to save sorting information.

Here's an example of what I mean. This is the file name of a couple of my PDF files. The format is the same for all my music PDFs.


Alice Cooper - Steven - Keys                               So it's "Artist" - "Title" - "Collection"
David Bowie - Life On Mars - Chords

So I'm hoping the info on the file names can automatically populate these fields

If you have a friend with some basic programming skills with a language like Python or Perl, they could help you generate a CSV file using the file names. It would just be a matter of splitting the file name into the three parts and writing them as comma-separated values into a text file. Are you using Mac or Windows?
Mark
Reply
#7
In today's world you don't even need a buddy.

ChatGPT & Co. can write a routine or app for you doing that from simple text prompts. It should be possible in Powerscript, AutoIt or even Batch if you don't want to compile something or install an interpreter.
Reply
#8
After importing your files you could filter by parts of the filename, multi-select the filtered songs and edit many songs in one step
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply




Users browsing this thread:
2 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2025 MyBB Group.