[Building Sakai] Recovering a deleted exam and its gradebook entries

[Earle Nietzel]

Hi Kathy,

I have dug this SQL out of my notes it may help you at least find the 
exam:

select t2.TITLE, t1.* from SAM_ASSESSMENTGRADING_T as t1 join 
SAM_PUBLISHEDASSESSMENT_T as t2 on (t1.PUBLISHEDASSESSMENTID=t2.ID) where 
t1.AGENTID = (select USER_ID from SAKAI_USER_ID_MAP where EID = 
"xxxxxx at marist.edu");

This will display all exams and their scores for a particular user.

Hope it helps,
Earle

sakai-dev-bounces at collab.sakaiproject.org wrote on 12/02/2009 11:00:17 AM:

> From:
> 
> Katherine Faella <kmf at uri.edu>
> 
> To:
> 
> sakai-dev at collab.sakaiproject.org
> 
> Date:
> 
> 12/02/2009 11:00 AM
> 
> Subject:
> 
> [Building Sakai] Recovering a deleted exam and its gradebook entries
> 
> Sent by:
> 
> sakai-dev-bounces at collab.sakaiproject.org
> 
> (Please excuse my cross posting.  Tried this on production and got no 
> answers.)
> 
> Hi all,
> 
> We are running Sakai 2.5.4.  We have an instructor who has mistakenly 
> deleted an exam and therefor has also lost the gradebook column (and 
> grades) for the exam.
> 
> Does any one know if I can recover one or both of these, especially the 
> grades?  We have our files stored in a filesystem (not in the db).
> 
> Any help appreciated!
> 
> Kathy
> 
> -- 
> Katherine Faella                        tel: (401) 874-4469
> Sr. Technical Programmer                kmf at uri.edu
> University of Rhode Island
> University Computing Systems(UCS)
> 210 Flagg Road
> Kingston, Rhode Island  02881
> 
> _______________________________________________
> 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-dev/attachments/20091203/0ec83df4/attachment.html