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.
- Ensure OpenLP is not running. Look for
OpenLP.exe
on the Task Manager Processes tab, or reboot if not sure. - Uninstall OpenLP via the Control Panel Add/Remove programs option in the usual way.
- Windows Key+R, and type:
"%APPDATA%"
. Delete the OpenLP folder within the Explorer window that appears. - Windows Key+R, and type:
"%PROGRAMFILES%"
. Delete the OpenLP folder within the Explorer window that appears. - 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]
- In notepad, go to File -> Save.
- Change the save location to your desktop.
- In the "Save as type" dropdown, change this to "All files".
- In the filename, type:
openlp.reg
. The file should '''not''' end in .txt. - 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
- In notepad, go to File -> Save.
- Change the save location to your desktop.
- In the "Save as type" dropdown, change this to "All files".
- In the filename, type:
openlp.reg
. The file should '''not''' end in .txt. - Double click on the
openlp.reg
that appears on your desktop. Click OK on the warnings.