I realise that this is not an issue with Zionworx, so this is probably the wrong place for this post, but was unsure of where I should be asking this question. I was wondering how other UK churches fill in their annual CCLI report of songs projected etc?
I have just had to do this for our church and created an excel macro to extract the song information from all the service XML files created during the year. This macro processes each playlist item in the files and if it's a "song", retrieves the Title, Writer and copyright information before adding it to the excel file. As the number of times a song is used does not matter, the details are only added once.
Unfortunately, this does not help with the process of adding the information to the CCLI CopyReport system, but it does spead up the collection process.
How do other members perform this required reporting? If anyone is interested, I am willing to supply the spreadsheet for your use.