Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

import fails with blank grade

Description

Functional Description: Change the import process such that the gradebook will ignore " " (space(s)) in imported cells and prevents import failures and/or errors.

If you read a CSV file with " " for a grade, you get a error message.

If you're in Excel, there's no visible difference between a completely empty cell and one with " " in it, so I believe thiis should work. Leading and trailing blanks for numbers work.

See attached fix

Attachments

2
  • 08 Oct 2010, 02:42 PM
  • 08 Oct 2010, 07:48 AM

Activity

Show:

Thomas Amsler January 25, 2011 at 2:55 PM

Editing the grades in Excel is good enough.

nancy wilkison January 12, 2011 at 2:39 PM

SmartSite@UCDavis - 2.6.4.2 - Sakai 2.6.2 - Server "ucddev1"
This instance is running gradebook2 v1.4.0-a4
firefox
TEST PLAN
site AAA 123 123 su10
1 - some items graded for some students already
2 - exported as csv and edited w/Excel to add new grades and a space for others
3 - imported back
4 - grades show as expected, "space" grades are blank, no errors

QA RESULTS
pass

COMMENTS
only did it once. did not use text editor to grade. is that needed?

Thomas Amsler January 11, 2011 at 5:17 PM

QA Testing:

See attached GRBK-760.csv file for an example. In that file, Adlam Martha's score for "HW 1" is not an empty string but contains a space, " "
Using spaces should not break the file inport process.

Thomas Amsler October 12, 2010 at 10:50 PM

Merged manually trunk revision 70641 into 1.3.x-test. I had to do it manually, because the file name has changed.

Thomas Amsler October 8, 2010 at 2:42 PM

Attaching GRBK-760.csv file that I used in GWT DEV mode to verify/test this issue. All data in that file is mock user data.

Fixed

Details

Assignee

Reporter

QA Status

PASS

Components

Fix versions

Affects versions

Priority

Created October 8, 2010 at 7:48 AM
Updated February 10, 2011 at 11:52 AM
Resolved February 10, 2011 at 11:52 AM