• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Exporting PDF bookmarks for making CSVs
#1
I've noticed the Import PDF Bookmarks feature is presently not functional. I agree that using CSV files works great, and has much more versatility, but if you have, for example a large fakebook you own with maybe 400 songs, it can be an awful lot of work creating a table of contents, along with the proper page numbers.

Since many books are now published already in PDF format with all the bookmarks, I would be quite happy if one could generate a text file similar to a Song List from the PDF bookmarks which are already in the Mobile Sheets file after you have imported a  fakebook as a song.

It's great having access to all the bookmarks, but it would be really nice to be able to export them as well, as can be done with the Song Lists, and it would make creating CSV files a snap, especially if you wanted to assign audio to individual songs, or put them in a Set List.

Thanks!
“After all the investigation, all of the technique - doesn't matter! Only if the feeling is right.” ― John Coltrane
Reply
#2
With jPdfBookmarks https://sourceforge.net/projects/jpdfbookmarks/ you can export the PDF bookmarks to a text file.
From the PDF bookmarks you get the correct start page of the songs.
Transforming it into a valid CSV file still requires some tweaking.
Some search & replace first.
Multi page songs need additional tweaking to get the "pages" column correct.
LibreOffice formulas can help to do that semi-automatic. You can find an example in the XLS file that I shared with e.g. the CSV file for "Brazilian Jazz Real Book"
see https://zubersoft.com/mobilesheets/forum...p?tid=5653
and look at the columns calc.PDFLastPage and calc.PageOrder.
If you have questions just contact me.
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
#3
Thanks so much!

For the first try, I chose my girlfriends massive 700 page Hal Leonard Ukulele Book.

I adjusted the preferences in Jpdfbookmarks, dumped a text file, cleansed it up in Wordpad, and changed it to a csv. I then just borrowed the formulas from the Brazilian Jazz Real Book Excel file. It really worked great!

The only little issue I had, which didn't seem to bother Mobile Sheets, were single pages producing a hyphen, as in 67- instead of just 67. I assume this is due to some lack of knowledge on my part in Excel.

Even so, everything went perfect on the very first try!

Again, I really appreciate the assistance. This turned out to be under 30 minutes even with my learning curve, and I could have spent a day on something this big doing it the hard way.
“After all the investigation, all of the technique - doesn't matter! Only if the feeling is right.” ― John Coltrane
Reply
#4
If we ever get out from under this awful Covid-19 thing here,we'll be able to go back to doing sing alongs at the old peole's homes, and this will really help with set lists. Hopefully things will be better before we are ready to go into one ourselves!
“After all the investigation, all of the technique - doesn't matter! Only if the feeling is right.” ― John Coltrane
Reply
#5
> The only little issue I had, which didn't seem to bother Mobile Sheets, were single pages producing a hyphen, as in 67- instead of just 67.

Where did this issue show up? If it happened in the Excel file, please share it, including the formula columns.
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
#6
Here are the files.

I have not set up a good template yet, until I get all my bugs worked out.


Attached Files
.xlsx   Uke Book Test Formulas.xlsx (Size: 34.89 KB / Downloads: 5)
.csv   Uke Fake Book.csv (Size: 22.28 KB / Downloads: 2)
“After all the investigation, all of the technique - doesn't matter! Only if the feeling is right.” ― John Coltrane
Reply
#7
I can't see any formulas in the XLSX file that you shared.
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
#8
My apologies! I tried this one to be sure.


Attached Files
.xlsx   exp.xlsx (Size: 35.76 KB / Downloads: 7)
“After all the investigation, all of the technique - doesn't matter! Only if the feeling is right.” ― John Coltrane
Reply
#9
Strange. There's something invisible in column "PDFLastPage" that prevents ISBLANK to return TRUE. A simple delete of the cells in PDFLastPage doesn't help. If I enter something (any character works) and delete it again, the cell is empty and the hyphen disappears.
It might have something to do with the way you created the XLS or with the way you edited the export file. I use Notepad++ instead of Wordpad. You could try that. If that doesn't help we need to check your workflow step by step.


Attached Files Thumbnail(s)
   
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:
1 Guest(s)


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