Is there a way to see end dates of ALL courses?

[xxie34]

When the courses in my account were created, the end dates were set to be May 3rd, before the final exams even start. So we manually changed all of the end dates of the courses that came our way in Course Details. Now we are concerned that we may not have caught them all. Is there a way that I can somehow get a report on the end dates of all courses (preferably published courses but I will take what I can get) rather than clicking on the courses one by one?

[MattHanes · Accepted solution]

You can generate a Provisioning Report (information on generating account-level reports is here: How do I view reports for an account?).  If you generate a provisioning report for courses, one of the columns in the report is "End Date". You can filter or sort the end dates using Excel or Google Sheets to see if you missed any.

[xxie34]

Wow thank you so much! You are a lifesaver. 

[tdelillo]

You can also update course end dates using SIS Import, if you have too many to fix manually. We had to do this for a couple of semesters until we figured out how to make Canvas stop changing our SIS-generated dates to the day before the term ended. I can dig through my archives for the details if you need them. If I recall, I took the results from the provisioning report and changed some of the fields and labels (and, of course, updated the end date) and brought it back in.

[xxie34]

That makes a lot of sense! I can't find how to bring it back in. Do you upload the csv file somehow?

[tdelillo]

So here are the steps I used.

1. Download the Courses provisioning report using the steps above.
2. Then I had to take the data from the provisioning report and put it into the correct format for a courses.csv (this guide tells you what fields are necessary: SIS Import Format Documentation - Canvas LMS REST API Documentation ). I think it's just a field or two that needs to be deleted or relabeled.
3. Change the end dates (making sure to use the existing formatting, ours looks like "2017-12-28T22:59:31-06:00" for example)
4. Upload this new file using the SIS Import instructions: How do I import SIS data to a Canvas account?  

The only tricky part is the optional settings in SIS Imports. If I recall, we used the "Override UI changes" and "Process as UI changes" options. But definitely test it out in your beta or test systems before doing anything to production!

[MattHanes]

Just to add to  @tdelillo 's post, creating an SIS CSV upload will only work if your courses have SIS IDs. If they were manually created courses, you'll either have to use the API to set a new end date or you'll have to go and add an SIS ID to each course.

[xxie34]

Will do. Thanks for your detailed directions.