St Andrew’s United Reformed Church, Cheam
About us
Contact us
What's on
For members

To know Christ
and to make
Christ known


St Andrew’s • Cheam

OpenLP: Extracting song words from the service plan

Extracting song and reading words


OpenLP doesn’t have a simple way of extracting the words which you may need for:

  • printing the large print song words for those who need them,
  • printing the Bible readings for the reader, or
  • including the words of songs which are not in Mission Praise or in the service sheet.

However, software has been created to do this. It needs to be installed on the computer which will be used. The installation instructions are shown below, but this will normally be done for you.

How to extract the words

First, create the service plan as described earlier. Save it using the default filename in the default location (the SoundDesk Dropbox).

LP Words icon

Now click or double-click (depending on how your Windows desktop has been set up) on the 'LP words' icon.

Select plan

You will see displayed a list of all the service plans in the Dropbox folder. Select the relevant one and click on OK. Note that the file names by default contain the date of the Sunday following their creation.

Extract succeeded

You should then see a dialogue box informing you that the large print words file has been created in the C:\temp folder.

Open Word, and open (File → Open and navigate to C:\temp) the file you just created. Its file name will include the same date as the service plan file name. You may need to go to View → Print layout to see it properly.

Once it is open check and if necessary correct any awkward page breaks, and otherwise the file is ready to print.

If any of the words need to be copied to the service sheet, highlight them in the large print document, click on Copy (top left); then open the service sheet, put the cursor where you want the words, click on the little down-arrow under 'Paste' and select the icon which shows a bold A - which will paste the text without the large font-size.

Installing the large print words software

This needs to be done once on each computer on which the function is needed.

  1. Download and install Strawberry Perl from this site: Choose the recommended version, selecting the 32 or 64 bit version depending on the Windows version (see below), and accept all the defaults during installation.
  2. Open a command prompt window (Window key + X and then C) and type:
    cpan Win32::GUI
    This will take a few minutes to run.
  3. Copy the script to create the large print words file as follows:
    cd \users\<your-name>\Dropbox\SoundDesk\Miscellaneous
    copy \Strawberry\perl\site\bin

    ... substituting your user name for <your-name> (look in C:\Users if unsure). Then close the command prompt box.
  4. Right-click on the desktop and select New > Shortcut. In the 'Type location of ...' box enter:
    C:\Strawberry\perl\bin\wperl.exe C:\Strawberry\perl\site\bin\
    and click on 'Next'. Then in the box 'Enter a name ...' put 'LP Words', and click on 'Finish'.

Is the computer 32 or 64 bit?

To determine whether the Windows system is 32 or 64 bit in Windows 10, go to Start menu → Settings (the cogwheel) → System → About (you'll need to scroll down). Against 'System type' it will say '32-bit operating system' or '64-bit operating system'.

In earlier versions of Windows it varies, but typically there will be a 'My computer' icon on the desktop. Right-click on that and select 'Properties' and you will see 'System type' as for Windows 10. If there is no 'My computer' icon, try right-clicking on the desktop, selecting 'Graphic properties' or 'Personalise' which will have an option to show 'My computer' on the desktop.

If all else fails you can try installing the 32-bit version and it will probably work even if you have 64-bit Windows.

OpenLP tutorial

External documentation