Interface (read only) to the song database via a web page.

cyclooctane

Hi AllWe have been using openlp at church for 6 months now, and it works very well.But I have had an interesting request from the worship leaders. They would like to have access to the song database while they are at home using a webpage.This is so that they can search for songs and make notes of any changes they want before the service. This sounded like an interesting idea. RegardsCyclooctane

martbarr

Hi Does it have to be a web interface?Could you share a dropbox/Skydrive/Googledrive/etc folder, and prepare your service in there, and they would have visibility of the service using regular openlp - and possibly you could make it read only for them.Martin

mhalbrook

Not even close to starting it, but I'm planning on trying to do something like this in the not too distant future.

gribbo

I've got a little web based interface to the songs that you can check out at http://www.westbaptist.org.nz/songsIt has one or two limitations:

It only searches for words / phrases (i.e. searching for "will follow" will only find songs with that phrase, it won't find songs with the words "will" as well as "follow")

At this stage it lists all verses in the database and takes no notice of the 'verse order' if defined for a song. It is on the todo list for a day when there is time available. We don't use the Verse Order field, instead putting all verses in the song file in the correct order (allows us to copy and paste the full set of words into Word etc for printing out as required by music team).

For the links to youtube videos, we put the url at the end of the Alternate Title field and the php code extracts this. The songs.sqlite database is uploaded via ftp with a simple batch file that I run whenever the songs list is updated.If you have someone that can update it to suit your own situation, you're wlecome to a copy of the relevant files.Brent

purewhite

I'd be interested in the code for that script. Would you consider letting us put it under an Open Source license and develop it further?Soon I'm going to have the task of maintaining a cross campus database of songs, and so will probably write some syncing code, having a nice web interface to it would be good, and having some of the work already done would be nice! Tim

gribbo

Below is a link to the code. Was done quickly, so is not very sophisticated, but you're more than welcome to make it open source and develop it further. Alternatively, it may just give some ideas on where to start with a more feature rich version designed from the ground up.http://tiny.cc/openlpsongslistThere are 4 main files

uploadsongsdb.bat - batch file to upload the songs.sqlite database using Windows command line FTP.

songslist.php - allows searching for words/phrases and lists the matching songs and allows expanding the lyrics or viewing a youtube clip (youtube URL is taken from the end of the Alternate Title of each song).

songslistlyrics.php - displays the lyrics for a song.

songslist2.php - used to get all the lyrics for a set of songs (enter song numbers separated by commas). I used this to send out the songs list to musicians and singers each week.

There were several ideas for improvements that have not as yet been implemented due to time

include more detail for each song such as author, copyright etc

allow dragging required song title to a floating box which acts as list of songs to be used for a service. Clicking a "Go" button would then bring up all the lyrics etc as is currently performed by songslist2.php

updating code to follow any defined verse ordering

updating search code to allow searching on non-contiguous words

Chuckn2x

Could you please explain how to use the scripting? I'm new to OpenLP.