[Using Sakai] Assessments: some users permanently "In Progress"

[Bryan Holladay]

The AutoSubmit job has been updated since 2.9.  I suggest copying trunk's
function and replacing it in 2.9.x

samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentGradingFacadeQueries.java

Copy & past/replace the whol function: autoSubmitAssessments()

Also, make sure you add the following changes for the new DB column:

Index:
samigo-hibernate/src/java/org/sakaiproject/tool/assessment/data/dao/grading/GradingData.hbm.xml
===================================================================
---
samigo-hibernate/src/java/org/sakaiproject/tool/assessment/data/dao/grading/GradingData.hbm.xml
(revision
126730)
+++
samigo-hibernate/src/java/org/sakaiproject/tool/assessment/data/dao/grading/GradingData.hbm.xml
(revision
126731)
@@ -58,6 +58,8 @@
     <property name="isAutoSubmitted" type="boolean"
column="ISAUTOSUBMITTED" not-null="false" />
     <property name="lastVisitedPart" type="integer"
column="LASTVISITEDPART" not-null="false"/>
     <property name="lastVisitedQuestion" type="integer"
column="LASTVISITEDQUESTION" not-null="false"/>
+    <property name="hasAutoSubmissionRun" type="boolean"
column="HASAUTOSUBMISSIONRUN" not-null="true" />
+
     <set name="itemGradingSet" table="SAM_ITEMGRADING_T" cascade="all"
order-by="itemGradingId asc"
       inverse="true" lazy="true">
       <cache usage="read-write"/>
Index:
samigo-hibernate/src/java/org/sakaiproject/tool/assessment/data/dao/grading/AssessmentGradingData.java
===================================================================
---
samigo-hibernate/src/java/org/sakaiproject/tool/assessment/data/dao/grading/AssessmentGradingData.java
(revision
126730)
+++
samigo-hibernate/src/java/org/sakaiproject/tool/assessment/data/dao/grading/AssessmentGradingData.java
(revision
126731)
@@ -67,6 +67,7 @@
   private Boolean isAutoSubmitted;
   private Integer lastVisitedPart = 0;
   private Integer lastVisitedQuestion = 0;
+  private Boolean hasAutoSubmissionRun = false;

   public AssessmentGradingData() {
   }
@@ -186,7 +187,15 @@
   public Float getTotalAutoScore() {
     return this.totalAutoScore;
   }
-
+
+  public Boolean getHasAutoSubmissionRun() {
+ return hasAutoSubmissionRun;
+  }
+
+  public void setHasAutoSubmissionRun(Boolean hasAutoSubmissionRun) {
+ this.hasAutoSubmissionRun = hasAutoSubmissionRun;
+  }
+
   public void setTotalAutoScore(Float totalAutoScore) {
   if (totalAutoScore != null){
   if (totalAutoScore.floatValue()< 0){






Then run the DDL:

(MySQL):
ALTER TABLE sam_assessmentgrading_t
ADD COLUMN HASAUTOSUBMISSIONRUN bit(1) NOT NULL;



I just did this at r126731 on
https://source.sakaiproject.org/svn/msub/longsight.com/samigo/samigo-2.9.x_features-backport


Thanks,
Bryan


On Tue, Jul 9, 2013 at 11:43 AM, Warwick Chapman
<warwickchapman at gmail.com>wrote:

> Howdy
>
> On our 2.9.1 installation, after the due date of an assessment (Tests and
> Quizzes) is up, we find that some of our Assessments have a number of users
> who are indicated as being "In Progress" and this does not seem to tally
> with what is actually going on.
>
> I have tried to create enable the AutoSubmit in sakai.properties and have
> created the Quartz task but nothing seems to happen when the task is run.
>  All Assessments which have submissions "In Progress" remain as such.
>
> One our our administrators did a check through one such course by logging
> in as each user and the number indicated as being "In Progress" did not
> tally with what was actually happening with the users.  I can get the
> specific details if required.
>
> Any idea what's going on here?
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20130709/09e11fef/attachment.html