import null fields behavior ?

import null fields behavior ?

by steve miley -
Number of replies: 0

I'm interested in others thoughts on what SHOULD be the behavior on a null score in an import for a student.    We are about to put in a change which would not record any changes to grades if there was no value in the import file, but I'm not 100% confident this is a no-brainer. 

Running 2.5.3,  the behavior we see on importing a csv file with a null field is that it will set the field in gradebook to null (even if it had a value).   For example -

 

lets say the spreadsheet is - 

id, midtermscore, finalscore

4, 60, 58

5, 40, 47

6, ,  30 

 

Here is a scenario

Student 6 has a grade score of 50 in the gradebook for midtermscore.

But, once the instructor imports this file, it will clear the 50 and set it to null. 

 

What we want change in the import program is to ignore any changes on the grades if there is a null value.

 

The specific case that we have issues with is, we have a course with multiple sections where the instructor has empowered 2 tas up import grades.  Both TAs have access to all sections.  TA 1 upload scores for his students.  TA 2 uploads scores for his students (plus he has empty values for TA1 students).  All of TA1 students scores now get cleared.

 

Thoughts on this change? 

 

Thanks, Steve