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

[Warwick Chapman]

Thanks Bryan.  If I upgrade to 2.9.2, will this change be included?


-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com


On Tue, Jul 9, 2013 at 5:56 PM, Bryan Holladay <holladay at longsight.com>wrote:

> 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/20130711/71727b42/attachment.html