[Deploying Sakai] SAMIGO Saved but not submitted answers in a survey

[Tom Hall]

Thanks

This got me in the right direction.  The survey was anonymous and closed 
so it was a little trickier.  It also turned out that of the 6 in 
progress participants only 1 had actually submitted anything.  I 
extracted the submitted response and passed them on.

These queryies gave me the PUBLISHEDASSESSMENTID's of the survey, I was 
then able to find the ASSESSMENTGRADINGID's and then the responses with 
a couple of simple queries on the SAM_ASSESSMENTGRADING_T, 
SAM_ITEMGRADING_T and SAM_PUBLISHEDITEMTEXT_T  tables to extract the 
question and response text into a text file.

I also marked the un-submitted responses as submitted to clean up the UI 
for the users.

Thanks again.

Tom

On 6/17/2011 10:57 AM, DAVID ROLDAN MARTINEZ wrote:
> First get the published assessment id:
> SELECT pa.id FROM sam_authzdata_t a, sakai_site s, sam_publishedassessment_t pa
> where a.agentid = s.site_id
> and functionid = 'GRADE_PUBLISHED_ASSESSMENT'
> and a.qualifierid = pa.id
> and s.title = :site_title
> and pa.title = :assessment_title
>
> Get the assessment grading information:
> SELECT * from sam_assessmentgrading_t ag WHERE ag.publishedassessmentid = :above_id
>
> I guess you will see the FORGRADE column has 0 (false) value. You can try to change that to 1 (true) and see if the answers show back fine.
>
> Hope this helps.
>
> David
> ________________________________________
> De: production-bounces at collab.sakaiproject.org [production-bounces at collab.sakaiproject.org] En nombre de Tom Hall [thall at brocku.ca]
> Enviado el: viernes, 17 de junio de 2011 15:49
> Para: sakai-dev Developers; production at collab.sakaiproject.org
> Asunto: [Deploying Sakai] SAMIGO Saved but not submitted answers in a survey
>
> Hi everyone
>
> We have a site where a number of survey respondents did not hit the
> 'Submit' button so their responses are still in the saved state after
> the survey has closed.
>
> Does anyone have a suggestion on how to find these saved responses and
> change them to submitted.
>
> Thanks
>
> Tom
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"