openlp.org is an Open Source application for presenting lyrics, Bible verses, movies and PowerPoint presentations. Here are some scripts I have written for version 1.0 of this program. All are licenced under the GPL.

NOTE: These are not official utilities, and it is possible that openlp.org may make changes to their database which are incompatible with these utilities. Always take your own backups and never ever run them on your live system 5 minutes before the service starts :-)

Use these utilities at your own risk.

Note, many utilities require you to download and install sqliteodbc to allow the script to access the openlp.org database. Apparently some virus scanners (incorrectly) say this is a virus. If your virus scanner refuses to let you download/run the program then there are older versions at http://www.ch-werner.de/sqliteodbc/ (e.g. version 0.70) which apparently work without triggering virus alerts.

Quick reference guide (Download pdf)

BibleGateway/CrossWalk Bible Import (Download v2.1 - 22nd January 2008)

NOTE: It appears that BibleGateway.com now have some form of 'Unusual behaviour' check in place on their website which sometimes stops the script working. Nothing I can do about this, but the script does allow you to restart at a particular book, so you can merge CSV files together later.

A VBScript to download files into openlp.org CSV format from the BibleGateway.com or Crosswalk.com website. The copyright of most Bibles have a reasonable use clause allowing you to display verses of your own Bible in your Church, and this script will help with this by allowing you to import your Bible into openlp.org. However always check the copyright information on the relevant website before downloading and consider donating if you download from BibleGateway. If you or your Church don't own a particular version of a copyrighted Bible, then please don't download it.

The Bible will be downloaded to My Documents: bibleverses_nn.csv and biblebooks_nn.csv.

Songs of Fellowship Import (Download v1.3 - 21st January 2008)

A VBScript which imports the Songs of Fellowship Word file (which comes with the music books) into the openlp.org database. Note that manual editing will be required, since some songs in the Songs of Fellowship file are not formatted in a manner that is easy to process programmatically, however the script now makes some attempt at repair. Also attempts to insert the chorus between each verse.
It is a bit slow, it can take up to an hour to load the songs for all 4 books.

Requires Microsoft Office Word and you will need to download and install sqliteodbc.

PowerPoint Import (Download v1.2 - 30th November 2007)

A VBScript which imports the text from all PowerPoint files in a directory into the openlp.org database.

Note, this is tailored around the format of the PowerPoint files for my Church, so the script may need tweaking for your own files.

Requires Microsoft Powerpoint and you will need to download and install sqliteodbc.

OpenSong Song Import (Download 1.3 - 19th February 2008)

A VBScript which imports the songs from OpenSong XML format and loads it into the openlp.org song database. Only imports the author, title, copyright and lyrics. (Chords, styles and [V1], [C] type information are lost.) However it will try and take the 'presentation' order into account.

The program will prompt for a folder, and process all files in that folder. If you have split your songs into various subfolders, you will need to run the script for each one separately.

Requires you to download and install sqliteodbc.

OpenSong Bible Import (Download 1.0 - 26th November 2007)

A VBScript which converts an OpenSong XML Bible to openlp.org CSV format. This can then be imported into openlp.org. The program will prompt for a bible, and output two files into My Documents: BibleBooks.csv and BibleVerses.csv. Note, you may want to edit BibleBooks.csv and check the Testament Id's are correct (1 for OLD and 2 for NEW) and change the book abbreviation's to something suitable.

(OpenSong Bibles can be downloaded here. )

Lyrics Download (Download 1.1 - 21st January 2008)

A VBScript which prompts for a song title, and then connects to various Worship websites, and downloads and imports song lyrics into the openlp.org database. Note results will vary, and some editing may be required. To use copyrighted songs, you must hold a valid CCLI licence.

Requires you to download and install sqliteodbc.

Usage Reporting (Download 1.1 - 18th March 2008)

A VBScript which prompts for a directory, and then processes openlp.org Order Of Service files (.oos) in that directory. Creates a CSV file listing all songs used in those order of services.

Requires you to download and install sqliteodbc.

Song Theme Updater (Download v1.0 - 9th January 2008)

A VBScript which prompts for a theme, and then updates all songs in the openlp.org database with this new theme. Additional option to only update songs with a specific theme or no theme.

Requires you to download and install sqliteodbc.

Songbook Creator/Order of Service print (Download v1.2 - 5th May 2008)

A VBScript which prompts for an order of service file (.oos) and outputs a webpage containing either the order of service headings, or the full lyrics of the songs with optional Bible verses.
If this page is opened in Firefox, then a three columned format will be produced which will page correctly when printed or print-previewed. (IE6/7 doesn't support multi columns).
Note it's a bit basic, and doesn't make any attempt at keeping a song or verse on the same column or page.

Requires you to download and install sqliteodbc.

Order of Service Song Import (Download v1.2 - 29th January 2008)

As from v1.0 final, openlp.org now automatically imports missing songs to the main database, which may render this script redundant...

A VBScript which prompts for an order of service file (.oos) and imports any songs in this file into the main openlp.org database. This may prove useful if creating the oos on one PC and transferring to another with a different song database.
If a song exists with the same title but other differences, then the two songs will be displayed side by side, allowing the user to decide whether to import it. Theme information is not included so themes need to be exported/imported and assigned separately.
Note, the .oos file does not contain the full author name, so this may only be partially imported.

Requires you to download and install sqliteodbc.

Song Title Punctuation Remover (Download v1.0 - 21st January 2008)

A VBScript which will remove punctuation from song titles, making title searches easier so the operator doesn't have to remember if a song has a comma or such like in the title. Removes all characters except letters, numbers, spaces and apostrophes. "&"'s are changed to "and".
Accented vowels are changed to unaccented equivalents (i.e. é -> e).

Not recommended for use with languages containing non-English characters (e.g. ñ, ß) since these will be blindly removed!

Requires you to download and install sqliteodbc.

1.0RC6 Bible Converter (Download v1.0 - 24th January 2008)

A VBScript which converts a Bible in openlp.org 1RC5 or earlier format, to the format introduced in 1RC6. (http://www.openlp.org/en/users/raoul/blog/2007-10-20-reworking_the_bibles.html)

Prompts for the Bible name, which is the one that appears in the dropdown list (e.g. 'kjv').
Creates a .bible file in the openlp.org data directory which will be automatically picked up by openlp.org 1RC6 and newer.

Requires you to download and install sqliteodbc.

Tailored Packages

If you have your own song library, themes and Bible databases which you wish to distribute to others in your Church, it may be more convenient to create your own setup executable, rather than having to give instructions on how to copy files to the often hidden all user application data folder. The following assumes you have openlp.org installed in the default locations.

Download openlpsetup.zip and unzip it. Inside is an Inno Setup (.iss) file.

Then download the Inno Setup quick start, selecting the ispack, rather than the isetup. Once installed, open the .iis file above in ISTool.

Change the "#define MyDir" line to point to the folder you extracted the zip file to, and edit the [Files] section to add/remove files as needed. You may notice in the .iss that the files are in there twice. Once to {commonappdata} with MinVersion:0,1 and once to {app} with MinVersion: 1, 0. This is because Windows 98 and Windows XP, for example, store application data in different places.

If you want to also include your own settings (e.g. line wrap, Bible verse settings) then this involves a bit more work. Start the registry editor by going to the Start Menu, selecting Run... and entering regedit. When this opens, down the left hand side, find My Computer -> HKEY_CURRENT_USER -> Software -> openlp.org. Right click on openlp.org and select 'Export' and save to a file. Close down regedit. Then back in ISTool select Registry down the left hand side, right click on the grid that appears on the right and select Import from File and open the registry file you saved.

Finally in ISTool select 'Compile Setup' to create the setup exe which can then be distributed.

Another iss file which only packages the songs database and nothing else.