Scantron Import not functioning as designed

Description

Right now in 1.4.1, when you import a scantron file you get the filename as the item name. However, in 1.5.0-rc2, this doesn't happen. What does happen is the item is called "score' which is what is in the column.

This is happening because the import code is not recognizing a scantron file as a scantron. Here's the problem code:

private boolean isScantronSheetForJExcelApi(Sheet s) {
Cell studentIdHeader = s.findCell(scantronStudentIdHeader);
Cell scoreHeader = s.findCell(scantronScoreHeader);
Cell reScoreHeader = s.findCell(scantronRescoreHeader);

return (studentIdHeader != null && scoreHeader != null && reScoreHeader != null);
}

The problem is a scantron file will have either a score header, or a reScoreHeader, but not both.

Activity

Show:

Steve Faith June 10, 2011 at 2:53 PM

Tested EVE 150 WQ 2011. Importing both a Scantron file and a Scantron rescore file produce results that are acceptable and are consistent with current behavior on production.

Michael Wenk June 9, 2011 at 4:02 PM

r74905

Michael Wenk June 9, 2011 at 4:00 PM

Fixed so that if we have either a score, or a rescore (or both) we'll be counted as a scantron

Fixed

Details

Assignee

Reporter

QA Status

PASS

Components

Fix versions

Affects versions

Priority

Created June 9, 2011 at 3:44 PM
Updated June 10, 2011 at 4:44 PM
Resolved June 9, 2011 at 4:01 PM