Import doesn't handle grade items that have the same name

QA PASS

Notes:

• Points based GB

• Weighted Categories (HW, LAB)

• Created two Lab 2 items in import file

• Import process detected issue and showed the following message:

"There are duplicated items in the file. If there are categories, there can be only one item per category with the same name. Names are case-insensitive. The following item has a duplicate, but there may be more items. Please inspect the file and remove all duplication, then try again: Category 'LAB' - Item 'LAB 2'"

added a check for already matched cat/item pairs and send user notification of duplicate.

This will be in B6

Per 4/24/12 T&S Meeting: Implement suggestion 1. Halt import of full grade books if duplicate items are found in a category and describe the problem; "Duplicated item names, all item names must be unique. Please change item name(s) and import again. Also show the affected category and duplicate item in a dialogue box.

We used to have a 'force overwrite' function that would ask the user if they wanted to overwrite the existing items.... this somehow disappeared...(I think the 401 errors we saw and changed the to be more user friendly were due to this error (401 was the chosen code to trigger the dialog)..... the code is all still there, for the most part... but it is just not used now. So we could re-enable that code. I estimate it would take 1/2 day to do it.

Proposed correction:

USE CASE (Worst):
1 - Instructor creates several items and grades assignments (assignment-1, assignment-2, assignment-3), in gradebook.
2 - Then adds a new assignment item to the gradebook spreadsheet, accidentally names it the same as an existing item (assignment-1)
3 - Adds grades to the new assignment-1
4 - Upload spreadsheet to the Gradebook
5 - New assignment-1 scores overwrite the existing old assignment-1 scores
6 - There is no error or warning, but the wrong scores are now in item assignment-1

SUGGESTIONS:
1 (preferred solution) - Halt import of full grade books if duplicate items are found in a category and describe the problem; "Duplicated item names, all item names must be unique. Please change item name(s) and import again.
2 (secondary solution) - Warning message, "Warning, you are importing a grade book with duplicated items names. The last duplicated item will be the only item imported."