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

[Bryan Holladay]

Don't forget the conversion:

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

Update SAM_ASSESSMENTGRADING_T
Set HASAUTOSUBMISSIONRUN = 0
where HASAUTOSUBMISSIONRUN is null;


On Thu, Jul 11, 2013 at 9:29 AM, Bryan Holladay <holladay at longsight.com>wrote:

> 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/82f0791d/attachment.html