[IanMSpencer]

Hi everyone

I recently got MobileSheets, and I like it so far, but there are a couple of things I'm confused about.  Could someone help me?


1.  How do you "separate" songs that in a single PDF with multiple songs in it?  I want to see/work with the individual songs, not the whole songbook.  I guess I could split the PDF but checking if there is an easier way.

2.  How does the database work?  When I import a PDF, I have the option to generate .png files (which would help for question #1 I guess).  I see it creates folders for each of the PDFs and then places the PDF there --- but is just the storage; I don't see the database file anywhere (I selected the db storage folder to be one that gets backed up to my NAS server, not the default).

Thanks for any help you can provide!

To expand on the CSV suggestion, knowing some simple Excel, I was quickly able to cut and paste the index page (via notepad to put some separators in to keep Excel happy) into a spreadsheet, split that into columns then use the page number in the index to come up with the from/to pages for each song along with the titles. Doesn't have to be too clever, just a hack, and you can add an offset if the book numbering doesn't start from the first PDF page. Take the opportunity to add in other columns as per the manual (so hang on until you've worked out how you want to set up collections, what you might use the custom group field for, etc.) then MS should be pretty much set up for you.

If you get the page numbering wrong, you can soon get into the song entry's file and alter the page numbers - for example, if it is the only one that goes onto two pages and you didn't tweak the CSV, and the song will display the correct bits. The songs share the PDF. Also if the songbook is revised, but with the same pagination (our ukulele group leader is often fixing things), you can just replace the PDF.