Has anyone any suggestions about the best way to approach the following problem?
I have imported songs from the Songs of Fellowship files for books 1, 2 and 3.
As time goes by we will doubtless add further new songs and Kingsway will probably publish yearly books of new songs (with files that I may or may not import) and then eventually SoF book 4, etc.
The questions is, "What is the best way to maintain the database?"
I will almost certainly want to import the whole book 4 file when it arrives but I don't want to end up with lots of duplicated songs. I know the import process has a title de-duplicating facility (for which I'm very grateful) but I have already tweaked many titles to make it more obvious which song it is so this function will probably not pick them up.
Also, I need to maintain the list on a number of unconnected computers, most of which are owned and operated by non-technical people. These include our worship leaders who will want to add new songs. I need to make sure everyone has the same list.
I can't believe this is a new problem. What do all you experts do at the moment?
Thanks,
Steve