[Building Sakai] Autosubmit feature for Samigo

Wed Apr 8 12:46:11 PDT 2009

I came across this property on the Sakai Properties reference page.
http://bugs.sakaiproject.org/confluence/display/DOC/Sakai+Properties+Reference+-+Full

Perhaps some mention of sql scripts should be there as well?

Sean Keesler
130 Academy Street
Manlius, NY 13104
315-663-7756

On Wed, Apr 8, 2009 at 3:21 PM, Karen Tsao <ktsao at stanford.edu> 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"
>>
>
>