[Building Sakai] Autosubmit feature for Samigo

Wed Apr 8 12:54:46 PDT 2009

Cool.  When you've got the instructions, *.sql, etc. in place in / 
sam, let me know and I'll update /config/default.sakai.properties.   
Also, while I am at it I would like to remove the sample reference/ 
sakai.properties file (it's redundant given the existence of the  
config project) and replace it with a README.sakai_properties.txt  
that points folks to the config project, where the *.properties files  
are now stored.

Cheers,

Anth

On Apr 8, 2009, at 3:21 PM, Karen Tsao wrote:

> Sure. That sounds good to me. Let me correct this.
>
> Thanks,
> Karen
>
> On Wed, Apr 8, 2009 at 12:16 PM, Anthony Whyte <arwhyte at umich.edu>  
> wrote:
> I'd really like to remove the SQL statement comment that is  
> currently in default.sakai.properties as I don't think it is the  
> right place to embed instructions of this nature.  Could you create  
> a README.autoSubmission.txt in, say, samigo/docs where you could  
> provide a set of instructions and also put the SQL into samigo-pack/ 
> sql (with appropriate dialects).  Then we could shorten the comment  
> in default.sakai.properties to something like:
>
> # --- Samigo Automatic Submission feature ---
> # Set samigo.autoSubmisson.enabled = true to enable Automatic  
> Submission feature.
> # Default=false.
> # WARN. To enable the auto submission feature you must run  
> sakai_autosubmission.sql.  See samigo/docs/ 
> README.autoSubmission.txt for instructions.
> samigo.autoSubmit.enabled=false
>
> vs
>
> CURRENT
>
> # --- Samigo Automatic Submission feature ---
> # Set samigo.autoSubmisson.enabled = true to enable Automatic  
> Submission feature.
> # Default=false.
> samigo.autoSubmit.enabled=false
>
> # After this feature enabled, please run the following sql to make  
> it show up in the pre-populated assessment types
>
> # For mysql
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES (NULL, 1,  
> 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES (NULL, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Quiz' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES (NULL, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Problem Set' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES (NULL, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Test' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # For oracle
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES  
> (sam_assessMetaData_id_s.nextVal, 1,  
> 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES  
> (sam_assessMetaData_id_s.nextVal, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Quiz' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES  
> (sam_assessMetaData_id_s.nextVal, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Problem Set' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES  
> (sam_assessMetaData_id_s.nextVal, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Test' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # --- end of Samigo Automatic Submission feature ---
>
> Cheers,
>
> Anthony
>
>
>
> On Apr 8, 2009, at 2:56 PM, Karen Tsao wrote:
>
> Hi Sean,
>
> Have you run the sql command listed in the sakai.properties?
>
> # For mysql
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES (NULL, 1,  
> 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES (NULL, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Quiz' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES (NULL, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Problem Set' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES (NULL, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Test' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # For oracle
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES  
> (sam_assessMetaData_id_s.nextVal, 1,  
> 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES  
> (sam_assessMetaData_id_s.nextVal, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Quiz' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES  
> (sam_assessMetaData_id_s.nextVal, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Problem Set' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
> # INSERT INTO SAM_ASSESSMETADATA_T (ASSESSMENTMETADATAID,  
> ASSESSMENTID, LABEL, ENTRY) VALUES  
> (sam_assessMetaData_id_s.nextVal, (SELECT ID FROM  
> SAM_ASSESSMENTBASE_T WHERE TITLE='Test' AND TYPEID='142' AND  
> ISTEMPLATE=1), 'automaticSubmission_isInstructorEditable', 'true');
>
> After the script is done, you should see this option in assessment  
> type: Default Assessment Type, Quiz, Problem Set, or Test. Now if  
> you create an assessment using these types, you should see this  
> option in settings page. Please let me know if you have further  
> questions.
>
> Thanks,
> Karen
>
>
> On Wed, Apr 8, 2009 at 11:32 AM, Sean Keesler <sean at keesler.org>  
> wrote:
> I am checking out the sakai.property:
>
> samigo.autoSubmit.enabled=true
>
> I set it in local.properties and have the quartz job firing every
> minute. However, nothing seems to get "auto submitted".
> I read in SAK-14474 that "there will be a configurable option in the
> Submissions portion of Settings".
>
> All I see in Settings are:
>
> Number of Submissions Allowed
>  - Unlimited
>  - Only ____ submissions allowed
>
> Late Handling
>  - Late Submissions (After Due Date) will NOT be accepted
>  - Late Submissions will be accepted and will be tagged late during  
> grading
>
> Nothing screams of "auto submit" to me. How do you make an assessment
> auto submit?
>
>
> --Sean
> _______________________________________________
> 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"
>
> _______________________________________________
> 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 --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2417 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090408/4edfbba2/attachment.bin 