Quelea icon indicating copy to clipboard operation
Quelea copied to clipboard

Feature Request : Song / viedo usage statistics

Open GW391 opened this issue 5 years ago • 3 comments

Would it be possible to add usage stats for each song.

My thought would be to add to the number of displays, when a song has been put on the live projection window, (possbily even within a noted timeperiod, e.g only add if it is during the service removing eronious stats from practices or building)

2 main reasons for this

  1. Trying to get the CCLI reporting is currently a fairly manual process, having stats that can be printed by year for example would be a great help.
  2. Database cleaning, it would be excellent to be able to see the usage of songs so that we can remove unused songs from the database. My database is quite messy mainly due to the original import (several years ago) which I am slowly tidying up, but knowing which songs I have not played would make this job much easier.

Even if the data was just stored with a CSV exprot so we can export to excel to manipulate would be a great help.

Thank you for all your hard work on this appication it is such a good system and getting better with every update.

GW391 avatar Sep 20 '20 15:09 GW391

Perhaps you can already use B and/or C below, as present in Quelea 2020.0

A) A request has been made for schedule statistics, including CCLI numbers.

https://github.com/quelea-projection/Quelea/issues/211

B) The menu item : Database / Export / Song list creates a csv with CCLI numbers included.

S2

C) The menu item : File / Export order of service to PDF creates a pdf with CCLI numbers included.

S1

https://github.com/quelea-projection/Quelea/issues/4

DeeTigIT avatar Sep 21 '20 03:09 DeeTigIT

Thanks for the update, I did look at the export song list, and did not see the CCLI numbers on any of my songs, probably my data, I will take another look.

Feel free to mark this as a duplicate of #211

GW391 avatar Sep 21 '20 08:09 GW391

I also took another look and you're right: no ccli yet in the export Song list.

DeeTigIT avatar Sep 21 '20 15:09 DeeTigIT