[Building Sakai] Autosubmit feature for Samigo

Wed Apr 8 12:21:12 PDT 2009

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 --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090408/c262f5e9/attachment.html 