Reflections and Projections

Web control, text over video plus more - Latest v2 update

Being a rainy public holiday here in the UK, I decided it would be a good time to update you all on v2, since we've now sailed past revision 800 and there have been a number of changes since the last update.

I've been continuing to work on Song Imports and have now added the ability to import Word/Writer and Powerpoint/Impress documents via an interface with The import itself is fairly basic and makes some assumptions on the format of the file, but will hopefully save some typing in many cases. I've also worked on the remote interface and now made it possible to control OpenLP with a web browser. This will require the remote plugin to be enabled and then connecting to http://localhost:4316. It's very basic at the moment, and it doesn't have any inbuilt security so if your church computer is on the internet or public network then you will need to consider the risks.

Tim has been battling with text over video and has got it working on some systems, although not on all - but we're hoping to find a solution for all platforms soon. He has also given us line spacing adjustments, the ability to override the output resolution if preparing a service for a computer with a different setup, the show desktop and theme output buttons are now working, some nice drag and drop improvements and an improved Nursery Alert system.

Meanwhile Jon has been working on saving the application layout so everything looks the same as when you last ran it, a recent file list and a fair bit of cleaning up after the mess some of us other devs leave behind :)

Raoul has made some improvements to the song editor to allow author names to be typed in and auto-completed, which is easier than choosing from a big list. Finally, in development are also some internationalisation fixes, song import wizard improvements and one developer has also been experimenting with spell-check, but we'll have to wait and see if this makes it into the final version.

Alpha 2 is still a fair way off, but as you can see there are going to be a good number of improvements. If you want to see what we're hoping to achieve, then please check out our Milestone page

Fedora Packaging update

OpenLP alpha 1 is now available in the Stable repository of Fedora 12 and testing repository of Fedora 13.

Adding FreeBSD to the mix

Thanks to some hard work from Thomas Abthorpe (assisted by Jon Tibble) we now have OpenLP Alpha 1 in the FreeBSD ports! You can find it in the ports under "multimedia/py-openlp".

Fedora Packaging

OpenLP has now been sponsored by Fedora and the Alpha 1 release is now available in the testing repository under the tag OpenLP-

If you are use Fedora give it a go and provide feed back.

Post Alpha 1 changes - so far!

Following the success of alpha1 and comments in testing, a number of improvements have been added:

  • Images and bible verses can be added to existing service manager items (of the same type) by using the context menu within the plugin.

  • It is now possible to re-order and delete images within an Image service item.

  • In the latest release it is possible to add multiple songs, presentations, media and custom items to the service manager.  This can be achieved either by drag and drop or the context menu.

  • In single screen mode it is possible to turn off the main display. This would be useful setting up a service on a single screen machine.

Please note that services saved in alpha1 will not be able to be loaded by a post alpha1 build.  This is due to internal changes in the storage of the data.  I hoped that post alpha2 the format will be backward compatible.

Two Quick Converters

A while ago I wrote two scripts as part of the OpenLP 2.0 rewrite, to convert the 1.0 songs database and bible files to OpenLP 2.0 format. Unfortunately these scripts were Linux/Unix-only until recently, because I couldn't get the SQLite 2.8 module for Python compiled on Windows.

However, Jonathan Corwin did some digging, and found out how to do it, and so I've compiled those two scripts into two stand-alone command line executables for Windows. We'll eventually include both songs and Bible imports in OpenLP 2.0, but for the moment, you can use these two command line apps to convert your databases for you.

Songs: openlp-1to2-converter.exe

Bibles: bible-1to2-converter.exe

How to use them:

Both scripts support a "--help" parameter, which provides you with the usage of the script, and extra parameters that you can pass to the scripts.

C:\> openlp-1to2-converter.exe --helpUsage: openlp-1to2-converter.exe [options] OLDDATABASE NEWDATABASEOptions: -h, --help       show this help message and exit -o, --overwrite  Overwrite database file if it already exists. -v, --verbose    Outputs additional progress data. -d, --debug      Outputs raw SQL statements (overrides verbose).

Note that the songs database is "songs.sqlite" and is found in C:/Documents and Settings/<username>/Application Data/openlp/data/songs on Windows XP. Bibles are "Version_Name.sqlite" and found in C:/Documents and Settings/<username>/Application Data/openlp/data/bibles.

Song imports

Well 2.0alpha1 has been out in the wild for just over a week now, and we're both relieved and delighted that the response has been positive! According to the stats, just over 400 of you have been brave enough to download it and give it a try, and we've been been bumped up to 246 in the SourceForge rankings which I think is pretty good for a niche application, out of 266090 registered projects.

If you haven't tried the alpha yet, I'd urge you to please take a look. We'll be interested in your comments, both good and bad as to the progress we've made so far.

You'll be pleased to know that the developers have decided not to take a post-alpha nap, but are instead working as hard as ever towards the alpha-2 release. One of the things we're going to be focusing on is song imports. We all know how tiresome it is to type in the lyrics to the songs, and so we're trying to make your lives easier in this respect.

Raoul is working hard making the existing Song Import menu options functional and pretty, Tim continues to work hard to support the underlying infrastructure, whilst I've been looking at incorporating some of my external v1 utilities into v2. I've already managed to complete the Songs of Fellowship import, and some will be pleased to know that this now uses Writer, rather than Microsoft Word. Next I'm going to be looking at a few online options, to get the lyrics from sites such as, and If you're aware of any other sites which offer Christian lyric downloads without requiring registration, then please let me know. On the horizon is a general purpose PowerPoint/Impress/Word/Writer text import.

We've also got newer members of the team working hard to document the database formats used by other worship presentation software in the hope we can also support imports from these. We've even got a couple of guys taking the time to learn to program in Python, so they can contribute import code to the project, which is great!

CCLI import is a bit lower down the priority list, since our CCLI guru (Derek) is still working hard fixing a few things in v1.2.4. However we're hoping that you'll soon stop reporting bugs in that version, so Derek can join in the 2.0 fun with the rest of the team :)

Anyway please continue to report your feature requests, bugs and comments. Even if we don't respond or implement it all (we're busy people!) we do read everything you've got to say.

OpenLP 2.0 Alpha 1 released!

Hi folks,

It is with great pleasure that I announce the first alpha version of OpenLP 2.0! We've been working on this for a long time (since September 2008 if I have my dates correct) and decided to give everyone a taste of what we've been working on.

As we've mentioned before, OpenLP 2.0 is cross-platform. This means that it runs on Windows, Linux, Mac OS X, and even FreeBSD! However, since OpenLP 2.0 is a complete rewrite, and this particular release is an Alpha, there are a few things to be aware of...

From our FAQ: What is an alpha release?

An alpha release is a very early incomplete release. It has missing features, and bugs and is likely to crash or do unexpected things. It is intended for those who aren't scared of program crashes and want to help test the software. It is also for those who are interested in seeing the new features.

What new features will I find in 2.0?

Since 2.0 is a rewrite from the ground up, you won't find a great deal of new features since initially we want to ensure all the v1.2 features are included. However the developers have managed to sneak a few in. Take a look at the Complete list.

Is there a manual or any documentation for 2.0?

No, we don't have any documentation yet. If you need help, just ask in the forums or use the live chat feature. If you would like to help write some documentation, please let us know - we are always happy for new volunteers to join the team and contribute to the project.

I've started OpenLP, but I can't see the songs or bibles section in the Media Manager

On some systems, the media manager plugins default to a deactivated state. This is something we will address in a future release, but for now you will need to turn them on manually.

More Questions?

It is recommended that you read the rest of the Frequently Asked Questions before using OpenLP 2.0 Alpha 1, as it contains some very important information.


This is the part you've been waiting for!

Windows XP/Vista/7:

OpenLP-1.9.1-setup.exe (14.4MB)

Mac OS X (10.4 and higher):

OpenLP-1.9.1.dmg (35.2MB)

Ubuntu/Kubuntu/Xubuntu (Karmic/9.10 and higher):

We have a PPA (Personal Package Archive) which you can add to your package management software to download and keep up to date.


We are busy working on getting an OpenLP 2.0 package for Fedora.


We are busy working on getting OpenLP 2.0 into the ports system.

Source Code:

OpenLP-1.9.1.tar.gz (1.9MB)

Do you like OpenLP?

If you really like OpenLP, look at the following ways of helping promote OpenLP and also keeping track of the development of version 2.0:

  • Are you on facebook? Then become a fan and "Like" the posts.

  • Are you on twitter? Then follow openlp, and retweet the announcements.

  • Give us a thumbs up on the SourceForge project page.

  • If you have a website or blog, then link to our site with a few words saying what the software is and why you like it.

  • Add a placemark on our Worldwide Usage map, so others in your locality can see someone close by is using it.

  • If you are a member of any Christian Forums or websites, and their rules allow it, then perhaps review the software or ask others to review it.

New 2.0 Forums

As you may well have seen, the release date for the first 2.0 alpha has been set, and the developers are working hard to ensure the deadline is met!

Up until now we've been asking testers to post bug reports or feedback on the mailing list or IRC. However as the 2.0 feature set has become more complete and stable, more people are trying it out and posting their feedback in the forums. We've attempted to point them in the right direction, but have now come to the conclusion that we're not got going to be able to hold back the tide once the alpha is released.

Therefore new 2.0 specific forums have been created, to help separate v1.2 posts from v2.0 ones.

If you just want to discuss how great *cough* 2.0 is, need a bit of help getting it to do what you want or other general 2.0 chat, then you can use the General Discussion forum. Just don't ask us when the final version will be released, we don't know :)

If you have hit a problem with 2.0 that we don't already know about then you can post the problem in the Bug reports forum. Remember to tell us which operating system you are running, and offer as much information as you can regarding the steps leading up to the problem.

And finally if you have need of a specific feature in 2.0, and it hasn't already been suggested then post the request in the Feature requests forum. However remember that the developers are still busy getting the basic 1.2 feature set finished, and there is already a long list of additional things we'd like to do. So we might not get everything in 2.0, but we'll do what we can!

We look forward to hearing from you!

Upcoming ALPHA Release of OpenLP 2.0

Hi folks,

It is with great pleasure I announce the release date for the first ALPHA version of OpenLP 2.0: Sunday 28 March 2010.

What is an alpha release? Well, it's a release to say, "hey, we're not yet done, but you can look at what we've done so far!" Some features are missing, some are incomplete, and some are buggy, but you can look around and play around!

It has taken us a year and a half to get to this point, an initial release of OpenLP 2.0, but this is because we have been rewriting OpenLP from the ground up. There is not one single small piece of code from version 1.x in version 2.0. Rewriting OpenLP from scratch has given us a chance to fix design mistakes in 1.x, add more flexibility, and give you much much more in version 2.0 than we could have ever given you in 1.x.

I'd like to extend a huge thanks to my fellow developers, testers and other members of the community for their help, encouragement, and commitment to a brand new version of OpenLP!