-
Notifications
You must be signed in to change notification settings - Fork 19
Open
Description
Exporting evaluation results to a .csv (using default settings) inserts two extra columns in some rows.
.csv file header has 13 fields, but these rows instead contain 15.
This seems to be happening in rows where an evaluation isn't completed:
example (identifying info removed)
"Course Name",Event,"Evaluation Type","Group Name",Evaluatee,"Evaluatee S#",Evaluator,"Evaluator S#","Q1 ( /5)",Q2,"Raw Score","Late Penalty","Final Score"
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"James Kirk",11111111,"Leonard McCoy",22222222,2.00,,2.00,-,2.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"James Kirk",11111111,"Spock",33333333,3.00,,3.00,-,3.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"James Kirk",11111111,"Montgomery Scott",44444444,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Leonard McCoy",22222222,"James Kirk",11111111,5.00,,5.00,-,5.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Leonard McCoy",22222222,"Spock",33333333,5.00,,5.00,-,5.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Leonard McCoy",22222222,"Montgomery Scott",44444444,5.00,,5.00,-,5.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Spock",33333333,"James Kirk",11111111,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Spock",33333333,"Leonard McCoy",22222222,5.00,,5.00,-,5.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Spock",33333333,"Montgomery Scott",44444444,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Montgomery Scott",44444444,"James Kirk",11111111,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Montgomery Scott",44444444,"Leonard McCoy",22222222,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",Original,"Montgomery Scott",44444444,"Spock",33333333,3.00,,3.00,-,3.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Jean-Luc Picard",55555555,"Worf",66666666,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Jean-Luc Picard",55555555,"Wesley Crusher",77777777,5.00,,5.00,-,5.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Jean-Luc Picard",55555555,"Data",88888888,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Worf",66666666,"Jean-Luc Picard",55555555,,,,,,,
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Worf",66666666,"Wesley Crusher",77777777,5.00,,5.00,-,5.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Worf",66666666,"Data",88888888,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Wesley Crusher",77777777,"Jean-Luc Picard",55555555,,,,,,,
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Wesley Crusher",77777777,"Worf",66666666,3.00,,3.00,-,3.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Wesley Crusher",77777777,"Data",88888888,4.00,,4.00,-,4.00
"unnamed_course","Group Project 1 evaluation","Mixed Evaluation",NextGen,"Data",88888888,"Jean-Luc Picard",55555555,,,,,,,
Export settings (default):
Metadata
Metadata
Assignees
Labels
No labels