[george.ralston]

Hi All,

PDF bookmarks and CSV works great of course, particulalry for full pages.
But --- is there anyway to format 3 songs over 3 pages?

Here's what i am looking at:
Song 1 - starts on page 1 and finished on page 1
Song 2 - starts on page 1 and finished on page 2
Song 3 - startes on page 2 and finishes on page 2.

Any chance Song1 is extracted (from the start of bookmark 1 and ending at bookmark 2).
ISong 1 is printed at the top of page 1 (as original)

Song 2, that crosses page 1 and 2, is also extracted, and printed to start at the top of the page.
Song 3, that originally started somewhere towards the top of page 2, is now printed at the top of page.

So originally, we had 3 songs over two pages, and now we have 3 songes over three pages, each starting at the top of each page.

[mdavej]

There are 2 fields in the CSV to specify starting page and length - page and pages. So in your case,
Song1;1;1
Song2;1;2
Song3;2;1

But since the songs are already created, just edit each to have the correct starting page and number of pages.

[george.ralston]

There are 2 fields in the CSV to specify starting page and length - page and pages. So in your case,
Song1;1;1
Song2;1;2
Song3;2;1

But since the songs are already created, just edit each to have the correct starting page and number of pages.

Hi, thanks for the fast response!
But in case of Song 2, i dont want to see the tail end of Song 1, and also not the begnning of Song 3.
I am curious if its possible to have Adobe write (through a script or an add-on), the 3 songs over two pages, as 3 songs over 3 pages.
This keeps everything very clean.

Its a stretch to ask, but then again, if the bookmarks act as the page break, then in *might* just be possible.    

[itsme]

It's not complicated, but needs some manual actions.
PDFBookmarks contain just the starting page:
Song 1 - 1
Song 2 - 1
Song 3 - 2

A minimal CSV file contains the title and the page range:
title;pages
Song 1;1
Song 2;1-2
Song 3;2

If you import that into MobileSheets you get three songs. 
Song 1 and Song 2 are easy to handle: just crop them to show only that part of the page that is required.
Song 2: crop the pages that only the parts are shown that belong to Song 2
Then set "Page Scaling Mode = Fit Width" and "Display Mode = Vertical Scrolling" to get the two parts on the same screen.
Note that "Page Scaling Mode" and "Display Mode" have separate settings for portrait and landscape (both default and per song).

[mdavej]

There are 2 fields in the CSV to specify starting page and length - page and pages. So in your case,
Song1;1;1
Song2;1;2
Song3;2;1

But since the songs are already created, just edit each to have the correct starting page and number of pages.

Hi, thanks for the fast response!
But in case of Song 2, i dont want to see the tail end of Song 1, and also not the begnning of Song 3.
I am curious if its possible to have Adobe write (through a script or an add-on), the 3 songs over two pages, as 3 songs over 3 pages.
This keeps everything very clean.

Its a stretch to ask, but then again, if the bookmarks act as the page break, then in *might* just be possible.

If you don't want to see full pages, you're going to have to crop them yourself. In a big book like yours, that will take a lot of time and effort. I recommend you live with it.

[itsme]

I usually go the pragmatic way: I prepare a CSV with the correct page range so that two full pages are shown and do the additional steps that I explained above only for songs that I really want to play.

[george.ralston]

Hi All,
Thanks for the responses.

Im happy the way the CSV works, and cropping the pages jyst does not seem worth the effort.

While it might be possible to extract and re-write one song per page, is far above my skill level, but i might just ask this question in GitHub.

Thanks again for the help.

[Geoff Bacon]

Glad you have got something that works for you.

To reqrite the pdf into separate pages, transfer the combined pdf to your desktop and used Adobe Reader (it is free). Select each page in turn and "Print To PDF". You then have 3 pdf files that you can load into MS.

This method also works if you only want a few songs out of a large "book" (if you want lots of songs then use  a csv)

Geoff

[mdavej]

Hi All,
Thanks for the responses.

Im happy the way the CSV works, and cropping the pages jyst does not seem worth the effort.

While it might be possible to extract and re-write one song per page, is far above my skill level, but i might just ask this question in GitHub.

Thanks again for the help.

Since this pdf comes from a scan, there are no text elements you can programmatically look for in order to identify the gaps between songs. There are only images. So that code is going to be far more complex, almost certainly beyond anything you'll find on GitHub.

Just use your brain to see where the song starts and ends and keep it simple.

[george.ralston]

Hi Guys,
I made some good progress here...
1. Using ChatGPT to parse 'difficult' page of conetents from an image into a text file
2. Using Evermap plugin, use the text file to make the bookmarks. Here I chose to do author, song;page with semicolun as separator
3. Then write a python script using ChatGPT to break the book into individual songs
4. Then, once im happy,  again using ChatGPT to make an executable
5. Launch the exe file, select the songbook, and output directory, and there we have it.

Now the prototype works, im looking to parse 1,000 songbook into individual songs