Skip to content

Export Evaluation results - some csv rows contain extra fields #675

@amurph24

Description

@amurph24

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):

image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions