Manually creating indexes for large PDF files

Manually creating indexes for large PDF files

Indexes allow you to create a file containing a list of titles and pages for a specific document. Think of it as a table of contents that you can create for a large PDF book. At this time unrealBook doesn’t have an interface for creating this, but you can use a spreadsheet application to create this file. To create an index, type in the name of the song, the document name and the page number in a spreadsheet. 

1. Create a spreadsheet with the index information – OpenOffice or LibreOffice REQUIRED (free)

 

Type in the name of the song, the document name and the page number in a spreadsheet. 

format: name of song, myPDF.pdf, pageNumber

Repeat this for every song in the PDF.
Once you are finished, export your spreadsheet as a .csv file. This file should be comma delimited and should not have a text delimiter (no quotes).
Note: Make sure that the name of the pdf is case sensitive correct. In addition, make sure that it has .pdf at the end of the name. Do not put spaces before or after the filename. You must have a matching .pdf file in the documents folder for the index to reference.

You can also specify the number of pages of a song. This will allow set lists to turn through correctly when an index is added to a set list. To format your .csv correctly, create a .csv with the following format:

name of song, myPDF.pdf, pageNumber, numberOfPages
name of song2,myPDF.pdf,pageNumber, numberOfPages

OpenOffice.org or LibreOffice.org are REQUIRED for creating index files.

2. Export as csv

 

Make sure that there is no text delimiter and that the field delimiter is a comma. IMPORTANT!!!! The file character set should be UTF-8. 

3. Copy the .csv file into the unrealBook documents folder

Once the .csv file has been created, copy it into the unrealBook documents folder like any other PDF. You can then pull down on the All Indexes list to rebuild the list (which will read all .csv files).

Access your indexes in the Songs menu

 

Choose Indexes from the Songs menu

Access all indexes or a single index

 

All Indexes will list all songs of every index in a single list. Below All Indexes are the listings for each individual index.

Advanced – Verify your indexes

 

Use the +/verify button to check your indexes for simple mistakes.