feature request: include student IDs in gradebook export

[lkuper]

On MyUCSC, it's possible to enter final grades for a course by submitting a .csv file keyed on student ID (referred to as "SIS ID" in Canvas). In particular, the format MyUCSC needs is:

• File name must start with the 5-digit class number.
• The file must contain one header row and it must include one column named ID (the students' IDs as listed on the class and grade rosters) and one column named Grade. All other columns found in your file will be ignored.
• Use CSV (Comma delimited) (.csv) or Text (Tab delimited) (.txt) files.

If student IDs were included in the gradebook export, it'd be really easy to create this file.

(I realize you want to leave out all the unhelpful garbage in the gradebook, but this one additional column would be really useful!)

[eriq-augustine]

This makes sense.
We already have the SSID (see user.list), so it should be pretty straightforward.

I could see an option to gradebook.fetch that allows for multiple columns containing user information.

• name
• ssid
• email
• etc

I could also see a version of this were we just export directly to this format.
Do you know if the MyUCSC format has a name or formal-ish spec?

[lkuper]

I would be surprised if there's a name or a public spec. The system is Oracle PeopleSoft mumble mumble enterprise campus solutions something-or-other.

[eriq-augustine]

Blocked by #29.