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

[Steve Swinsburg]

Hi Gregory,

Assuming you are using SiteStats, you could create a quartz job that uses the SiteStats APIs to generate the data and then run it periodically. Alternatively, if you wanted it more remotely you could create a web service wrapper around the API and do it that way. You could also go straight to the DB and query any table you wanted, which generally is fine for reads.

See https://confluence.sakaiproject.org/display/DOC/Quartz+in+Sakai

cheers,
Steve



On 03/08/2012, at 2:07 PM, Gregory Guthrie <guthrie at mum.edu> wrote:

> I want to make some automated reports, most notably for per student attendance  in a course (as currently required for Federal Financial Aid guidelines).
>  
> I can go to the course, make a report by student for visits (or whatever), export it, and then copy and paste it into a spreadsheet shat summarizes by student by week.
>  
> But I want to automate this, first for one course, and then over a collection of courses.
>  
> With a local DIY LMS system I just wrote a python (or Java, or …) program to query the databases, and generate a report directly, or indirectly by creating a spreadsheet from the data. With the Canvas LMS I can do the same thing, accessing the data from the LMS using web service APIs.
>  
> Is there any corresponding way to
> 1)      Automate the generation of reports from Sakai sites
> 2)      Or access the data from some external known APIs or services?
>  
> Is there an existing way to create this standard federal reporting requirement for DE courses from Sakai?
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
> 
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120803/4a6d1e59/attachment.html