[Using Sakai] external access to Sakai data to automate reports?

[Steve Swinsburg]

Ah right, those code changes…

In that case you could take a copy of the (already modified) code from here:
https://source.sakaiproject.org/svn/msub/anu.edu.au/alliance/2.8.x/quartz/

It contains a Job that does some dependency injection, so you could use that as a guide. You'd then need to look at the SiteStats API and call the relevant methods.

Sounds like you are after a UI/tool to do this though. You may be able to extend the site stats tool to run the reports regularly and have them exported, it would need to hook into the Job Scheduler to do this.

cheers,
Steve


On 07/08/2012, at 11:31 AM, Gregory Guthrie <guthrie at mum.edu> wrote:

> Thanks for the information and insight.
>  
> The coding I was referring to was not developing any custom usages I might want, but changed required to Quartz itself to make it work with current versions. The comments on the web page at sakaiproject report:
>    “ The example package requires some changes to make it work in recent versions of Sakai.”
>  
> I think what I would want to do is just extract the equivalent data for what I would get from a sitestats report, but be able to then get it programmatically so I could automate the extraction and manipulate it into a spreadsheet for reporting on attendance (site visits) per student, etc.
>  
> Are there any available examples of a SQL /jdbc/odbc style query for this type of data? If I can access things that way it is simpler for me than trying to write webservice wrappers and do local custom builds. I can write code, but my goal is to be a user of Sakai, not a developer!  J
>  
> Similarly for accessing via an external GUI database browser, and the type of queries that would correspond to a sample sitestats report and export?
>  
> I wonder if in fact if I wrote the report I ant data export from, how easy it would be to make execution of that report into a webservice to automate the running and export operations. Once I get the data I already wrote spreadsheets for summary and dashboard reporting.
>  
> For the “desired features” queue, I like the existing standard webservice interface approach that Canvas uses, and they have a nice summary of how it makes reporting easy and automatable.
>  
> I still wonder how mainstream universities satisfy this type of automatic registrar style reporting of course participation /attendance for their DE courses using Sakai.
>  
> Thanks again.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120807/0e9f040b/attachment.html