<p>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.</p><p>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.</p><p>So I have a choice of:</p>
importing all our SP database in advance and letting the projectionist tweak the songs at the last minute. Result: Our song library is still as messy as before and it still takes a moment to edit each song before we use it.
using SundayPlus this week.
importing the songs one by one as needed. This will take a few moments as they will need editing before display.
importing the songs from the original Mission Praise text files in advance. Most of our songs come from there and this would give us a nice tidy song list. But I would need to work some SQL magic to get the copyright and authors into the right places.
<p>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.</p><p>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)?</p><p>Sorry, I ramble a bit :-)</p>