I’m sure that if you are any place besides Alaska and apparently several towns in ‘Da UP (Michigan’s Upper Peninsula for the non-locals) you have been as crazy hot as I have been these past few days. I would really like these hot days to go towards helping a few other people figure out an answer to a problem I had that frustrated me the past two days!
THE PROBLEM – If you have a collection of songs that you would like to put all into one big PDF file, so you can have it on your iPad, instead of creating separate PDF files for each song then this post is for you! Why? Because you will probably want to also be able to quickly find any given song in that PDF file without guessing where it is at.
THE SITUATION – I have known that unrealBook has had a feature in it that I have not been using. I just have not had the time to scan and organize any of my collections of music to actually need an INDEX. Well I finally pulled out a bunch of songs from my old three ring binder and those plastic sheet protectors and scanned them. Of course I put them all in alphabetical order first though. After scanning I learned that I had 220 pages of music and of course if I was to keep them all in one file I needed a way to quickly get to the correct song – or even just see what songs were in this file as it
did not come with it’s own index in the front. I could have simply followed unrealBook’s instructions and typed the song title, filename (including the extension .pdf) and the page number all into a spreadsheet. That would have given me less hassle I’m sure. I wanted something more flexible and useable in other ways too. If I was going to type in ALL those titles I mean, come on! I wasn’t about to do that more than once. What if later I decided I wanted to know who was the composer or what key these songs were in.
THE SOLUTION – So I created a FileMaker Database with Title, Filename, Page, Composer, and Key – I have since decided I might want to add even more criteria but for now I’m good. That was my point in t doing this though – now that the initial information is into a database I can add to it, manipulate it and create reports any way I’d like. Now that I had the info in the database I simply created a report with just the three pieces of information that unrealBook needed – Title, Filename, Page and then I exported a CSV file. I then excitedly imported the CSV file and the PDF into unrealBook anxious to see the fruits of my labor!
THE NEW PROBLEM – Blasted if it did not work. Several hours later after reading the unrealBook help files and user manual about 40 times I emailed Aron, the developer and asked his help. Even though he was touring in Japan I figured if he looked at my files he would know in an instant what I had done wrong. Sure enough – I got an email back the same day with the answer – unrealBook does not like the ” marks that were in my file – I had seen that noted in the manual but whenever I opened my csv file I could not see any in my file but they were there as far as unrealBook was concerned. He even sent me a fixed csv file to try. His worked! I started to dig around and did a few google searches and boy did I feel stupid! FileMaker (and apparently many other programs puts a ” mark before and after everything because that way you can have comma’s in your text – if it didn’t do the ” thing then your data would get all messed up because of the extra commas! Now it was starting to make more sense.
THE NEW SOLUTION – After several days of working through this issue I have finally figured it out! Use FileMaker to create a database of all your songs. Make sure you have at least three fields in the database – Title (for the title of each piece), File (for the filename of the final PDF that has all your music in it – bee sure to include the .PDF), and Page (The page number each title appears on in the PDF). But you will need to add one more field into your database that you would normally not use. You need to create a calculation field – call it unrealBookExport if you would like. That calculation need to look like this – Title&”,”&File&”,”&Page – That calculation will produce something like this –
The Earth Shakes,Ontonagon Praise and Worship.pdf,184
Now you can export all the information from that one field – the calculation field – into a Make sure your exported file has the extension of .csv – ONE FINAL NOTE – You will NOT be able to use ANY commas in any of the song titles REMEMBER?!?!?!?!?!
Import the exported csv file and your PDF file into your DropBox folder for iPad Music (you ARE USING DROPBOX RIGHT?) and then into your iPad.
LAST NOTE (If you use auto enter data into the file field this will be much faster! You can even use auto enter for the page numbers with a little bit of adjustment)
BUT I DON’T HAVE FILEMAKER
Well if you don’t have file maker I would still encourage you to use the index feature in unrealBook. Like the manual says….. type in the information into a spreadsheet and export a csv file. I had 192 songs in my PDF file. the only time I really want to see those songs all listed out individually is when I am looking to see what page they are on. I don’t really want 192 separate PDF files floating around that I have to keep track of.