Hi Jaylinz,
Short answer: The import does NOT create multiple files. At least not for me. I have turned OFF MS ability to manage files - I don't know if this impacts CSV import or not.
Long answer:
I have a similar need in that one of the bands I play in is a local Salvation Army band.
As I'm sure you know, they have multiple "song books" which would be equivalent to several Hymnals.
When I looked into storing some of these books in my system I ended up doing CSV imports as it seemed the most appropriate. I am very happy with the result.
As I choose to manage files myself, I have a directory (folder) structure in place that makes sense to me, and I copy the pdf into the appropriate folder where it stays and from where it is used.
The import process I use has a unique Collection name included in the CSV file for each song book, which results in the creation of a new collection with all the songs from the song book. So effectively, this new collection is the song book (hymnal) in question, and the collection listing would equate to the table of contents you're requesting. NB these are database entries, NOT separate files.
One of these song books has almost 1000 songs, but note that this does not create 1000 pdf files. There is only ONE pdf, and almost 1000 entries in the collection which point to different pages in the pdf.
The only downside I've found is if I want to turn to the next page because the next song I need to play happens to be there, I have to go back to the collection list instead of simply turning to the next page.
If it annoys me enough I might look into MS bookmarks and see if they would be more useful, and if they can be automatically generated from the existing CSV or something, but for now I'm happy with my current solution.
Short answer: The import does NOT create multiple files. At least not for me. I have turned OFF MS ability to manage files - I don't know if this impacts CSV import or not.
Long answer:
I have a similar need in that one of the bands I play in is a local Salvation Army band.
As I'm sure you know, they have multiple "song books" which would be equivalent to several Hymnals.
When I looked into storing some of these books in my system I ended up doing CSV imports as it seemed the most appropriate. I am very happy with the result.
As I choose to manage files myself, I have a directory (folder) structure in place that makes sense to me, and I copy the pdf into the appropriate folder where it stays and from where it is used.
The import process I use has a unique Collection name included in the CSV file for each song book, which results in the creation of a new collection with all the songs from the song book. So effectively, this new collection is the song book (hymnal) in question, and the collection listing would equate to the table of contents you're requesting. NB these are database entries, NOT separate files.
One of these song books has almost 1000 songs, but note that this does not create 1000 pdf files. There is only ONE pdf, and almost 1000 entries in the collection which point to different pages in the pdf.
The only downside I've found is if I want to turn to the next page because the next song I need to play happens to be there, I have to go back to the collection list instead of simply turning to the next page.
If it annoys me enough I might look into MS bookmarks and see if they would be more useful, and if they can be automatically generated from the existing CSV or something, but for now I'm happy with my current solution.
You're only paranoid if you're wrong 
I'm using an Onyx Boox Tab X, and play low brass: mainly 'Bone and Tuba
I'm using an Onyx Boox Tab X, and play low brass: mainly 'Bone and Tuba