Printing List of Song Titles

mrkeef

Hi,

 

I've been usning Openlp for a few weeks at church and it's looking great.

 

I'm wondering if there is a simple way of generating a list of song titles to help our worship leaders see what songs are available on the system.

 

Thanks

 

Keith

gushie

It's possible with a utility script in v1.2 but no utility exists in v2.

However if you're on Linux, then you can try:

$ sqlite3 -list ~/.local/share/openlp/songs/songs.sqlite "select title from songs" > songtitles.txt

gushie

For Windows, download http://www.sqlite.org/sqlite-3_6_23_1.zip and unzip onto the desktop.

Then open a command prompt, and type:

> cd %homepath%\Desktop

> sqlite3 -list "%APPDATA%\openlp\data\songs\songs.sqlite" "select title from songs" > songtitles.txt

> notepad songtitles.txt

 

 

mrkeef

Gee thanks, that was a quick reply! 

 

Yes we're on linux, so it was a matter of downloading sqlite3 and  then entering that command.

 

Works like a charm!

 

Blessings

 

Keith