ricepudd software

My openlp.org v1 Utilities

Home | OpenSong utilities

OpenLP is an free worship program for projecting lyrics, Bible verses, movies and PowerPoint presentations. openlp.org is a great program for presenting worship songs in churches. Here are some scripts I have written for version 1.0 of this program. All are licenced under the GPL.

THESE UTILITIES ARE FOR VERSIONS 1.0/1.2 OF OPENLP. Much of their functionality is now included within versions 1.9/2.0. Therefore they are NO LONGER SUPPORTED. I recommend you instead upgrade to the latest versions of OpenLP.

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.

Patrick also has some openlp.org utilities on his site.

cowjam has an online converter for OpenSong songs and Bibles here.

IMPORTANT - PROBLEMS WITH INTERNET EXPLORER 8.

My scripts use Internet Explorer to handle the user interface (even if you have a better browser set as your default, unfortunately). It seems that in version 8, they've made a change which breaks any scripts which prompt for a file, and you end up with a can't find "C:\fakepath\..." type of error. The only workaround I've found so far is for you to do the following:

Go into Internet Explorer and find the Tools->Internet Option menu. Go to the Security tab and chose Custom level... About two thirds down is a "Include local directory path when uploading files to a server" option.  Select Enable and then OK the window.  For your own security you may want to set it back to Disable once you've finished using my scripts.


IMPORTANT - PROBLEMS WITH 64BIT WINDOWS.

openlp.org 1.x uses sqlite v2. Unfortunately it seems that there isn't a Windows 64bit compatable version of the sqliteodbc driver for this. There is a workaround for this, by converting the database from v2 to v3, and I will post details at a later date.

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.
Those with IE8 installed may get a c:\fakepath error. See the note at the top of the page.

PowerPoint Import (Download v1.3 - 10th October 2008)

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.

SongPro Song Import (Download 1.1 - 4th April 2009)

A VBScript which imports the songs from SongPro 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 SongPro database (e.g. SongsV4.sdb in the SongPro Program Files folder)

Requires you to download and install sqliteodbc.
Those with IE8 installed may get a c:\fakepath error. See the note at the top of the page.

OpenSong Bible Import (Download 1.1 - 6th November 2009)

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. )
Those with IE8 installed may get a c:\fakepath error. See the note at the top of the page.
I can't upload .vbs files, so right-click on the download link to save target as, and rename from .txt to .vbs

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.2 - 9th August 2009)

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.

Song Listing (Download v1.0 - 20th October 2009)

A VBScript which processes the openlp.org and produces a CSV file containing all the songs.

I'm not able to upload VBS files anymore, so you'll need to right-click the above link, choose "Save link as" or "Save target as" and then rename the file so it ends in .vbs before running it.

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.
Those with IE8 installed may get a c:\fakepath error. See the note at the top of the page.

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.

Export Bible to OSIS format (Download v1.0 - 15th December 2008)

A VBScript which exports an openlp.org Bible to a basic OSIS format. I wrote this so I could install one of the Bibles on my phone using the Go Bible tool.

Requires you to download and install sqliteodbc.