[Building Sakai] Samigo resubmit

[Kusnetz, Jeremy]

Thank you VERY much.  Updating forgrade in the sam_assessmentgrading_t
table did the trick!

 

For some reason the gradebook didn't update, I had to manually adjust
the score back and forth to make it show up there, but I'm good now.

 

Thanks again, I'll add this to my bag of tricks for the next time. J

 

Jeremy Kusnetz | Sr. Systems Engineer

American Public University System

American Military University | American Public University

661 S. George St, Charles Town, WV 25414 

O: 304-885-5333 | M: 703-967-5212 | jkusnetz at apus.edu

 

From: ktsao at hungs.org [mailto:ktsao at hungs.org] On Behalf Of Karen Tsao
Sent: Monday, November 29, 2010 8:08 PM
To: Kusnetz, Jeremy
Cc: Sakai-Dev
Subject: Re: [Building Sakai] Samigo resubmit

 

Hi Jeremy,

To recover the data, please run the following query:

UPDATE sam_assessmentgrading_t ag, sam_publishedassessment_t pa,
sam_authzdata_t a, sakai_site s 
SET forgrade = 1 
WHERE ag.publishedassessmentid = pa.id 
AND a.agentid = s.site_id
AND a.qualifierid = pa.id
AND a.functionid = 'GRADE_PUBLISHED_ASSESSMENT'
AND s.title = :site_title
AND pa.title = :assessment_title

Please let me know if your issue cannot get resolved by the above query.

Thanks,
Karen



On Mon, Nov 29, 2010 at 4:19 PM, Kusnetz, Jeremy <JKusnetz at apus.edu>
wrote:

We had a similar issue to the following Jira:

http://jira.sakaiproject.org/browse/SAM-892

The instructor accidentally edited an exam that all the student's
completed, which retracted the exam.  They went to republish the exam,
and now Sakai doesn't show the link to "Scores", and all the scores in
gradebook are gone.

I've looked at the SAM tables and I can see the student scores and even
answer submissions, but I can't figure out what I need to change in the
database so that their scores come back to the interface.
This message is private and confidential. If you have received it in
error, please notify the sender and remove it from your system.

_______________________________________________
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"

 

This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101129/ee6bd2f0/attachment.html