Song Library

Smokey

As a long-time OpenLP user with an extensive song library, I require a method to generate and print a comprehensive song list for my Worship leader. Could you please provide instructions on accessing and printing this song list?

PaulRowell

Do you want just the song titles/first line or the lyrics as well?

Are you comfortable using a tool like DB Browser and running an SQL command? If so I can give you the SQL that I used to produce a list of song titles.

Smokey

PaulRowell I could sure give it a try. I have several hundred songs and it would to share with the team members who are not able to view OpenLP.

PaulRowell

Here is the SQL I use to get a list of Song Titles with the song book (if applicable):

SELECT songs.title,songs.ccli_number,song_books.name,songs_songbooks.entry FROM songs LEFT JOIN songs_songbooks ON songs_songbooks.song_id=songs.id LEFT JOIN song_books ON songs_songbooks.songbook_id=song_books.id

ORDER BY title

I use DB Browser for SQLite see https://sqlitebrowser.org/

Smokey

It took me a while, but I finally figured it out. 800+ songs but many duplicates.
Thank you.

Timon

Just to add to this thread for future readers: as long as a PDF file is sufficient, one option is to add all songs to the service and then choose 'File -> Print Service'