Adding some columns to gradebook for LB

In answer to the question ask by Lloyd Bumm Links to an external site. Feb 22, 2017 2:51 PM Links to an external site. in the Canvas Community discussion https://community.canvaslms.com/ideas/7736-feature-request-text-fields-in-the-gradebook Links to an external site.

I first got the list of students in my course 11 using  Download list_students_in_course.py

./list_students_in_course.py 11

This produced a file: students-in-11.xlsx

Then I augmented the spreadsheet with Lloyd's data: 10.0, 76.34, "2017-02-22"

spreadsheet-with-date-20170222-cropped.png

I saved the file as students-in-11-augmented.xlsx

Now I ran the program  Download insert-custom-columns-from-spreadsheet.py

./insert-custom-columns-from-spreadsheet.py 11 "score 1" "score 2" "date 1"

This produced:

'Wed Feb 22 16:17:46 2017'
inserted column
column number:  74
inserted column
column number:  75
inserted column
column number:  76
unknown data type in column:  date 1
'Wed Feb 22 16:17:48 2017'
'\n--DONE--\n\n'

The gradebook now contains the new data:

gradebook-with-date-20170222-cropped.png