[Using Sakai] [Building Sakai] Gradebook database relations

[Sam Ottenhoff]

Find the internal Sakai site id in the browser's address bar. For example,


https://qa29.longsight.com/portal/site/8cf99d1c-343e-4bb6-9b1b-f0d0e23ac30d

The site id =  8cf99d1c-343e-4bb6-9b1b-f0d0e23ac30d

Or lookup the SITE_ID in the SAKAI_SITE table by querying the TITLE field
for your site name.  The SITE_ID is the GRADEBOOK_UID in GB_GRADEBOOK_T.

On Sun, Sep 2, 2012 at 11:15 PM, Gregory Guthrie <guthrie at mum.edu> wrote:

> Mark, thanks - is your code available to see what it does, and how?
>
> Actually I should have been clearer that I am trying to just do a direct
> database query for the data, to avoid for now having to learn all the
> innards of the Java APIs and development environment.
>
> I will post this to the Sakai-dev forum and move any follow-ups to there;
> thanks.
>
> I navigated around from GB_GRADEBOOK_T and could find gradable_objects and
> GB_Category's, but couldn't find the link from a course to the
> GRADEBOOK_UID to start the chain of graded entities.
>
> I suppose I could go from course -> Students and correlate them with
> GB_GRADING_EVENT_T's, but that seems circumspect.
>
> -------------------------------------------
> > Can anyone give me a quick hint on how to find a gradebook associated
> with a course, and then
> > the graded items in the gradebook?
> > I found many of the key relations, but could not yet connect to a course.
> >
> > I am trying to replicate the "assignments/grade report/download
> spreadsheet" data by a
> > database query.
> >
> > Is there a query in the source code somewhere I should look at for this?
> > > -------------------------------------------
> > > As it happens, I just did this very thing.
> >
> >  1. Get an instance of the GradebookService either via injection or
> >     using the ComponentManager.
> >  2. GradebookService.getViewableAssignmentsForCurrentUser(String
> >     gradebookUid) gets a list of Assignments.
> >  3. For each assignment:
> >      1. Assignment.getName();
> >      2. Assignment.getId();
> >      3. GradebookService.getAssignmentScoreString(courseId,
> >         assignmentId, userId);
> >
> _______________________________________________
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120903/dbfc2ade/attachment-0001.html