Scratchpad:Tips

From OpenLP
Jump to: navigation, search

Move songs to custom

To move songs to custom, where the title begins with the word "LITURGY":

 user@host:~$ sqlite3 ~/.local/share/openlp/custom/custom.sqlite
 sqlite3> attach "~/.local/share/openlp/songs/songs.sqlite" as songs;
 sqlite3> insert into custom_slide (title, text, credits,theme_name) select title, lyrics,'', '' from songs.songs where songs.title like 'LITURGY%';

Remove all trace of OpenLP v2 on Windows

This will remove all OpenLP data, including songs you have entered and settings you have changed, as well as the program itself.

  1. Ensure OpenLP is not running. Look for OpenLP.exe on the Task Manager Processes tab, or reboot if not sure.
  2. Uninstall OpenLP via the Control Panel Add/Remove programs option in the usual way.
  3. Windows Key+R, and type: "%APPDATA%" . Delete the OpenLP folder within the Explorer window that appears.
  4. Windows Key+R, and type: "%PROGRAMFILES%" . Delete the OpenLP folder within the Explorer window that appears.
  5. Windows Key+R, and type: notepad . Copy and paste the following into the Notepad window that appears.
Windows Registry Editor Version 5.00

[-HKEY_CURRENT_USER\Software\OpenLP]
  1. In notepad, go to File -> Save.
  2. Change the save location to your desktop.
  3. In the "Save as type" dropdown, change this to "All files".
  4. In the filename, type: openlp.reg. The file should not end in .txt.
  5. Double click on the openlp.reg that appears on your desktop. Click OK on the warnings.

Disable presentations on Windows from outside OpenLP

On some Windows systems with OpenOffice installed, OpenLP can hang when starting up. Sometimes this can be due to the link with OpenOffice Impress. To turn off Presentations and Impress support and allow OpenLP to start normally, open notepad and paste the following:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\OpenLP\OpenLP\presentations]
"status"=dword:00000000
"Impress"=dword:00000000
  1. In notepad, go to File -> Save.
  2. Change the save location to your desktop.
  3. In the "Save as type" dropdown, change this to "All files".
  4. In the filename, type: openlp.reg. The file should not end in .txt.
  5. Double click on the openlp.reg that appears on your desktop. Click OK on the warnings.