[Building Sakai] Autosubmit feature for Samigo
Anthony Whyte
arwhyte at umich.edu
Wed Apr 8 12:16:55 PDT 2009
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/ab472f14/attachment.bin
More information about the sakai-dev
mailing list