Bulk publish courses with start date listed?

[Justin_Reynolds]

Hello, 

I found a couple of community posts on bulk publishing courses. 

• This one: https://community.canvaslms.com/t5/Canvas-LMS-Blog/How-to-list-teachers-who-have-published-unpublish...

Worked until my access to Google Drive was blocked by IT.  I've had recent trouble with the script anyway, so I'm hoping for another solution. 

• This post: https://community.canvaslms.com/t5/Canvas-Developers-Group/User-Script-to-Bulk-Publish-Courses/ba-p/...

Another great solution, but we have sessions within a term.  We'd prefer to publish based on start date rather than by term alone. 

Ideally, does anyone know of a Google Sheets replacement that would allow us to publish courses by start date?  I don't know JS and new to python.  I'm better with the API but would love something automated. 

Thanks!

And shout out to @Code-with-Ski and @James for their excellent work!

[Jeff_F]

GM @Justin_Reynolds - we recently began transitioning our preterm course checks to make use of Excel powered with VBA and the Canvas API. For example, one of our sheets initiates the link checker button, we review assignment due dates, ensure the instructor's name is on the home page, etc. The same tools can be used to change the course state. After pulling the list of future unpublished courses, filter by start date and then set the course[event] parameter to offer, which publishes the courses.

Courses - Canvas LMS REST API Documentation - Update a course

A very good overview of using Excel, VBA, API by @stelpstra - Download data to Excel using VBA and the API (work... - Instructure Community - 269951

[Code-with-Ski · Accepted solution]

@Justin_Reynolds 

I added suggestions for how the current version of my code could be modified in my reply to you on my post: Reply to - User Script to Bulk Publish Courses