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

[Bryan Holladay]

Yup, that patch plus copying the whole function autoSubmitAssessments


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

> Ok, but applying that patch for now will make the AutoSubmit work?
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
>
>
> On Thu, Jul 11, 2013 at 2:22 PM, Bryan Holladay <holladay at longsight.com>wrote:
>
>> Nope, it's only in trunk right now and slated for sakai 4.0
>>
>>
>> On Thu, Jul 11, 2013 at 5:35 AM, Warwick Chapman <
>> warwickchapman at gmail.com> wrote:
>>
>>> 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/645ffde8/attachment-0001.html