[Using Sakai] External statistics reports

[Gregory Guthrie]

Thanks for the clarifications and info.

I am using an mySQL browser to create queries, and have one now for Roster, and will make ones for the other report data.

I do understand the fragility of this approach, but think that while I can do this is a few days, understanding the internal infrastructure and APIs of Sakai, and setting up and learning the development environment would take significantly longer.

At the same time I'll keep hoping for Canvas like external services for statistics!  :-)

Although I do understand that the URLs were not intended for external use, I don't see why curl'ing to them would not work, seems like they should be source agnostic to any valid request (unless they are from local AJAX context on the page, which they did not look like to me).

Also, I did not understand how John's approach of asking for a service to run a SQL query was any different functionally than just running it myself from an external tool.

Thanks again for your patience with a new user!
-------------------------------------------
> -----Original Message-----
> From: Steve Swinsburg [mailto:steve.swinsburg at gmail.com]
> Sent: Tuesday, August 21, 2012 6:50 PM
> To: Gregory Guthrie
> Cc: John Bush; sakai-user at collab.sakaiproject.org
> Subject: Re: [Using Sakai] External statistics reports
> 
> Hi Greg,
> 
> The URLs you listed are internal tool page URLs, they are not designed for being requested
> externally. Entity broker is a way to request data like the web services, and perhaps John's
> script might be better suited there, but it news to be specifically coded.
> 
> If you want to run arbitrary SQL queries against the DB, you should understand the risks
> before opening that up as a web service. My recommendation is that you use a tool to create
> these reports. You could just use an SQL query browser to do this. An admin tool to run SQL
> within Sakai would be neat though.
> 
> Cheers,
> Steve
>