[gradebook2-dev] some grades are missing when importing grades from .CSV files into GB2

[Thomas Amsler]

We will have a look at the provided CSV file. So far, we haven't been able
to reproduce this in either v1.2.0 or v1.3.0. See comments in:
http://jira.sakaiproject.org/browse/GRBK-740
<http://jira.sakaiproject.org/browse/GRBK-740>-- Thomas

On Tue, Sep 14, 2010 at 5:27 AM, Kim Huang <kimhuang at oit.rutgers.edu> wrote:

> Thomas,
> Please find it at attachment. BTW,  following the step stated in the
> previous email, you can re-create the problem easily.
>
> Thanks,
> -Kim
> Thomas Amsler wrote:
>
>> Kim,
>>
>> Could you please send us your CSV file that causes this issue?
>>
>> Best,
>> -- Thomas
>>
>> On Mon, Sep 13, 2010 at 9:36 AM, Thomas Amsler <tpamsler at ucdavis.edu<mailto:
>> tpamsler at ucdavis.edu>> wrote:
>>
>>    Thank you for reporting this. We will try to verify this as soon
>>    as possible.
>>    -- Thomas
>>
>>
>>    On Mon, Sep 13, 2010 at 9:03 AM, Kim Huang
>>    <kimhuang at oit.rutgers.edu <mailto:kimhuang at oit.rutgers.edu>> wrote:
>>
>>        Thomas,
>>        Thanks for your quick response. Here you go for the new jira -
>>        GRBK-740
>>
>>        http://jira.sakaiproject.org/browse/GRBK-740
>>
>>        I am willing help debug if you can point to me roughly where
>>        you think the problem could be.
>>
>>        Thanks,
>>        -Kim
>>        Thomas Amsler wrote:
>>
>>            Kim,
>>
>>            Please create a GRBK JIRA for this.
>>
>>            Best,
>>            -- Thomas
>>
>>            On Mon, Sep 13, 2010 at 8:26 AM, Kim Huang
>>            <kimhuang at oit.rutgers.edu
>>            <mailto:kimhuang at oit.rutgers.edu>
>>            <mailto:kimhuang at oit.rutgers.edu
>>            <mailto:kimhuang at oit.rutgers.edu>>> wrote:
>>
>>               Hi, Folks,
>>
>>               Found a serious issue of grades being truncated when
>>            importing grades
>>               from CSV file on Rutgers production server( GB2
>>            -v1.2.0). Then I
>>               reproduced it on one of the Sakai QA
>>               servers(http://qa6-us.sakaiproject.org/portal). Please
>>            help to confirm
>>               whether this problem has been recorded/solved in jira.
>>            Otherwise I
>>               will
>>               create a jira.
>>
>>               When you import a class grades from .csv file, not all
>>            the grades
>>               in CSV
>>               file are imported completed. Usually the last few (one
>>            or two) entries
>>               are missing. This problem only happens on .csv file,
>>            XLS files
>>               work just
>>               fine.
>>               It can be reproduced by the following steps:
>>
>>               1. create a new site, can be either project site or
>>            course site.
>>               2. add about 16+ participants.
>>               3. add some new items in gradebook2, i.e. HW1, HW2,
>>            HW3, etc
>>               4. first export the grades by clicking on
>>            tools->export->grades &
>>               structures->as .csv file
>>               5. edit the exported .csv file, added a grade to one
>>            column for EVERY
>>               student in the gradebook(i.e. add "88" for HW1 for 16
>>            students, if you
>>               have 16 students in this site.) save the file
>>               6. import the just saved .csv file by tools->import,
>>            you will see from
>>               preview data view, some grades are missing. usually the
>>            last few
>>               entries
>>               are missing.
>>
>>               (I investigated a little bit, the .csv file has been
>>            read in
>>               correctly,
>>               which means, readInGradeDataFromImportFile in
>>            ImportExportUtility.java
>>               reads the complete whole set of grades from .csv file.)
>>
>>               Thanks, Let me know if you have further question,
>>
>>               -Kim Huang
>>
>>
>>               _______________________________________________
>>               gradebook2-dev mailing list
>>               gradebook2-dev at collab.sakaiproject.org
>>            <mailto:gradebook2-dev at collab.sakaiproject.org>
>>               <mailto:gradebook2-dev at collab.sakaiproject.org
>>            <mailto:gradebook2-dev at collab.sakaiproject.org>>
>>
>>
>> http://collab.sakaiproject.org/mailman/listinfo/gradebook2-dev
>>
>>
>>
>>
>>
>>
>
> ,Gradebook:,Gradebook,No Categories,Points,,,,
> ,Points:,100,,100,,100,,
>
> Student Id,Student Name,HW1,Comment : HW1,HW2,Comment : HW2,HW3,Comment :
> HW3,Course Grade
> a10 at 1.com,a10 at 1.com,88,,,,,,
> a11 at 1.com,a11 at 1.com,88,,,,,,
> a12 at 1.com,a12 at 1.com,88,,,,,,
> a13 at 1.com,a13 at 1.com,88,,,,,,
> a14 at 1.com,a14 at 1.com,88,,,,,,
> a15 at 1.com,a15 at 1.com,88,,,,,,
> a1 at 1.com,a1 at 1.com,88,,,,,,
> a2 at 1.com,a2 at 1.com,88,,,,,,
> a3 at 1.com,a3 at 1.com,88,,,,,,
> a4 at 1.com,a4 at 1.com,88,,,,,,
> a5 at 1.com,a5 at 1.com,88,,,,,,
> a6 at 1.com,a6 at 1.com,88,,,,,,
> a7 at 1.com,a7 at 1.com,88
> a8 at 1.com,a8 at 1.com,88
> a9 at 1.com,a9 at 1.com,88
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/gradebook2-dev/attachments/20100914/bfa96914/attachment-0001.html