mrkeef <p>Hi,</p> <p> </p> <p>I've been usning Openlp for a few weeks at church and it's looking great.</p> <p> </p> <p>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.</p> <p> </p> <p>Thanks</p> <p> </p> <p>Keith</p>
gushie <p>It's possible with a utility script in v1.2 but no utility exists in v2.</p> <p>However if you're on Linux, then you can try:</p> <p>$ sqlite3 -list ~/.local/share/openlp/songs/songs.sqlite "select title from songs" > songtitles.txt</p>
gushie <p>For Windows, download http://www.sqlite.org/sqlite-3_6_23_1.zip and unzip onto the desktop.</p> <p>Then open a command prompt, and type:</p> > cd %homepath%\Desktop > sqlite3 -list "%APPDATA%\openlp\data\songs\songs.sqlite" "select title from songs" > songtitles.txt > notepad songtitles.txt <p> </p> <p> </p>
mrkeef <p>Gee thanks, that was a quick reply! </p> <p> </p> <p>Yes we're on linux, so it was a matter of downloading sqlite3 and then entering that command.</p> <p> </p> <p>Works like a charm!</p> <p> </p> <p>Blessings</p> <p> </p> <p>Keith</p>