Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
amurph24 opened this issue Oct 23, 2024 · 0 comments
Open

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

amurph24 opened this issue Oct 23, 2024 · 0 comments

Comments

@amurph24
Copy link

amurph24 commented Oct 23, 2024

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

@amurph24 amurph24 changed the title Export Evaluation results - csv formatting issue Export Evaluation results - some csv rows contain extra fields Oct 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant