Issue 18 in datasoul: Suggestion: Record Statistics

[data...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 18 by machad...@gmail.com: Suggestion: Record Statistics
http://code.google.com/p/datasoul/issues/detail?id=18

Worship team has been asking me to create a way to record statistics of
songs sung in our church.

I'm not a Java developer, so the suggested was to use a simple spreadsheet,
however it is not working very well because they forget to update it;

I'm not sure how Datasoul works with the XML files, but maybe you could add
two columns in the file:
1- (integer) Number of times the song was "used"/sung;
2- (date) Last time the song was sung;

OR you could use SQLite <http://www.sqlite.org> to record better statistics;

Thanks in advanced for your help and have a blessed 2013,

Douglas

[data...@googlecode.com]

Comment #1 on issue 18 by samuelme...@gmail.com: Suggestion: Record
Statistics
http://code.google.com/p/datasoul/issues/detail?id=18

There are a few issues with this approach, specially when you edit services
in multiple computers.
Maybe a better approach would be create an external tool that read a bunch
of files from a directory and then generate the desired statistics. So, you
can save in a directory all files you have actually used and then use the
tool on it.

[Douglas Machado -Focalizar.com.br]

Dear Samuel,

Well, the idea is to reduce the number of steps/softwares to generate these statistics.  I believe the most common set up is to use Datasoul in only one computer for projection (even though you can edit the service in multiple computers), so if there was a solution implemented using SQL Lite (instead of XML files) you could store all statistics data into the the database and use Datasoul to retrieve that data. 

The data can be retrieved using another tool, however, in order to make this easier for the end user, Datasoul is the one that needs to store this data in the SQL database;

Let me know your thoughts. Is this doable? 

All the best,

Doug

[Samuel Lucas Vaz de Mello]

Hi,

I'm really not convinced that using a single computer is the  most common setup to an extent we can ignore the others. In my church we use one (or more) computer to write the files, in the worship pastor's office, and another to display the songs and eventually do any last minute change, in the temple (in another building).

If we are going to do it inside datasoul, we can do it either using xml or other database, but I'm afraid it may confuse users, give wrong results or generate a good amount of enhancement requests (merge/sync databases, retrieve additional data, etc). My feeling is that an external tool that export to csv/excel would produce more accurate and flexible results, and should be easier to mantain too, even being not so user-friendly.

What the others in the list think? If most of you prefer to have it inside datasoul we can discuss ways to handle the limitations and implement it.

By the way, I'm going out for vacation today and will have limited email access up to the last week of January.

Samuel

[Bastian Germann]

I do not need that function.

[data...@googlecode.com]

Updates:
Labels: -Type-Defect Type-Enhancement

Comment #2 on issue 18 by samuelme...@gmail.com: Suggestion: Record
Statistics
http://code.google.com/p/datasoul/issues/detail?id=18

(No comment was entered for this change.)