We need to send out a communications piece to all current Instructors in Canvas, that are attached to a live unit. Is there a way to extract all instructor details from Canvas?
Hello there, Mik Simons...
While I don't necessarily have an answer for you myself, I wanted to check in with you. I'm sorry to see that your question has been sitting here unanswered since you first posted this question on April 16, 2018. It appears that you may have stumped Community members with your question. Have you been able to find any solutions on your own since you first posted this question over four months ago? If so, would you be willing to share your solution back here in this topic with us? Or, if you are still looking for some assistance with this question, please let us know that as well so that someone from the Community might be able to assist you.
I am going to share your question with the Canvas Developers group here in the Community in hopes that your question will get some additional exposure. If you are not yet following this group, please use the link that I have provided, and then click on the "Follow" button at the top right corner of the page. Also near that button is an "Actions" link. Click on that, and then click on "Join group".
For now, I am going to mark your question as "Assumed Answered"...not because we've found an answer for you, but more because we've not heard back from you and because there hasn't been any new activity in this thread since April. That won't prevent you or others from posting additional questions and/or comments below that are related to this topic however. I hope that's alright with you, Mik. Looking forward to hearing back from you soon.
Hello Mik Simons. I interpret "live unit" to mean a published Canvas courses. If that's so, I would run the Provisioning report on the Reports tab of the Settings page of your account/sub-account. The report can be run for Courses for a particular term, and the CSV file it generates includes each course's published status, course names, and course ID (SIS). Where I work each course identifies its instructor, so to answer your question I would sort the CSV file by the status column and then grab all those course IDs for the published courses.
If your course ID or course names do not identify the instructor, you could run the same report for Enrollments for the same term. You could then combine both the Courses and Users CSV files into one Google Sheets workbook and use the vlookup()function to match the publish status of a course in one tab with the teacher for the course in another tab.
Retrieving data ...