[Building Sakai] Statistics on installation basis

[John F. Hall]

Daniel-

No screenshots that would be interesting right now.  Our OpenReports 
installation won't currently let me upload report definition files, so 
I'm limited to to doing a single SQL query per report.  Because of that 
I'm just dumping two reports per day in Excel format - Site data, 
basically a list of all sites, terms, creators, etc and Section data -- 
all the course sections that are associated with sites and which sites 
they're associated with.

This goes to our user support group (who doesn't have database access) 
and they use Excel to create graphs and create further reports as needed.

In the near future, when our installation allows uploads, I hope to also 
use jxls to have open reports build more sophisticated pre-canned Excel 
reports and graphs:
http://oreports.com/blog/2006/09/24/jxls-excel-reports-from-xls-templates/

-John

Daniel Lind wrote:
> Interresting! Do you have any screenshots to show me of your solution?
>
> Regards,
> Daniel Lind
>
> ------------------------------------------
> Daniel Lind
> UMDAC, Umeå universitet
> 901 87 Umeå Telefon: +46 90 786 53 12
> Daniel.Lind at umdac.umu.se
> ------------------------------------------
>
>
>
> John F. Hall skrev:
>> I've just started using OpenReports to remotely query our Sakai 
>> database and e-mail reports off nightly:
>> http://oreports.com/
>>
>> -John
>>
>> Daniel Lind wrote:
>>> Hi!
>>>
>>> I'm investigating the possibilities to setup statistics om our Sakai 
>>> installation. What we're interrested in are trends, usage (now, per 
>>> hour), number if sites, number of course sites per term, number of 
>>> users, etc. etc.
>>>
>>> Has anyone already done this? What tools did you use?
>>>
>>> Kind regards,
>>> Daniel Lind
>>>
>>> ------------------------------------------
>>> Daniel Lind
>>> UMDAC, Umeå universitet
>>> 901 87 Umeå Telefon: +46 90 786 53 12
>>> Daniel.Lind at umdac.umu.se
>>> ------------------------------------------
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to 
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of 
>>> "unsubscribe"
>>>   
>>
>>


-- 
____________ John F. Hall ____________
Programmer/Analyst, IT-Web Development
        University of Delaware