Adding a list of appointments to an appointment group

The earlier make_appointment.py Download make_appointment.py

 program required that the instructor already knows the calendar_event_id for the time slot and the student's Canvas id. This seems like too much more, hence a new insert_appointment.py Download insert_appointment.py

 program  that makes life simpler. This new program is called with a spreadsheet (in CSV formar):

local_start_time,login_id
2017-01-10 14:30,xxx@kth.se
2017-01-12 16:30,yyy@kth.se
...

The program can be called as follows:

./insert_appointment.py course_id appointment_group appointment_spreadsheet.csv

For example:

./insert_appointment.py 190 169 appointments_to_make-20170104.csv

There is also a "-f" flag to force the appointments, removing any earlier appointments in this appointment group for each student.

Additionally, there is a "-v" flag that generates both verbose output and a spreadsheet of the form:

appointments_to_add-course_id.xlsx

that contains the various stages of the processing as separate pages.

You can use this in conjunction with the list_my_appointments.py Download list_my_appointments.py

program to make a list of your appointments ofr a given day or period.