Basically, I'm looking for efficient ways to create a tidy song database from what we already have. I know this has been addressed in many posts but I haven't found quite what I need.
This Sunday, the worship team want to have an open worship session where the congregation can request what they want to sing. I'd been planning to switch to OpenLP and gradually build up our song collection from scratch, making sure we have all the right words, the correct copyright entries etc. But this scenario ruins my plan :-/ Previously we'd been using SundayPlus in which we have a decent database of songs, making this kind of task relatively easy.
So I have a choice of:
If I was on projection duty, I might consider importing from SundayPlus on the fly. However, there is still the issue of the copyright info which needs to be deleted from the last verse (typically) and pasted into the author and copyright field. That would take a minute or so which might spoil the spontaneity of the event.
I can work with SQL but I'm not sure that there's a reliable way to extract the authors and copyright notice from the song and add them to the required place in the DB. I'll try to work some magic with the Mission Praise text files but I would welcome any input from someone who has already done this. Do some of the other importers already pick out copyright and author info? Does anyone have any advice on this dilemma (complete but messy song database vs small but perfectly formed song database)?
Sorry, I ramble a bit :-)