About stelpstra

stelpstra · ‎03-02-2023

Hi @phonehome, great to hear your enthusiasm! To be honest, I have no idea how many people are using it, so it's nice to hear that it is still relevant to people to use it. Nice that it is working again with the latest version 😀

stelpstra · ‎02-07-2023

Good to see that the conversation continues in another blog post: https://community.canvaslms.com/t5/The-Product-Blog/Canvas-Data-2-is-coming/ba-p/552312

stelpstra · ‎12-13-2022

Hi @Edina_Tipter, could you provide an update on the release of CD2 in Europe (the Netherlands in our case)?

stelpstra · ‎11-09-2022

I have added an updated version (1.13), these are the changes: A row "Requirement" is added below the module item names If a module item has no requirement, the completion information per student stays empty and a comment is added for explanation (note: When no requirements are configured for a module, Canvas assumes progress as "Complete", whether students interacted with the content or not at all)

stelpstra · ‎10-25-2022

Hi @DFarrarUTH, nice that you like to tool. I'm not sue what you mean by "everything is uploading correctly". The settings need to have your the Canvas hyperlink of your institution configured and your token needs to be an active token, belonging to a user account that has teacher-like access to the course you have configured at Course ID. The related course needs to have students of which the accounts are active (not invited, pending or anything else than active). If any of this is not correct, you will either see errors or get an empty report. If this doesn't help you solve your issue, please send me a private message with screenshots and a detailed description of your situation, the more details the better the root cause can be identified. Regarding adding the email addresses, this has been requested before and I'm not planning to add functionality any more, therefore it won't be possible to display email addresses.

stelpstra · ‎09-05-2022

Hi @nicolelschrock, VBA (the coding language used) may not be fully supported in the Mac version of Excel 2018. I haven't been able to find a VBA compatibility list for Mac versions, but this post indicates there are issues with how forms in Excel are used from VBA in version 2018 on Mac. Try version 2011 (see 'compatibility' section) if that is available to you on Mac. Alternatively, on Windows it works fine.

stelpstra · ‎08-29-2022

Hi @eglover1 glad to hear it has been helpful. Unfortunately, the grades are not in the objects that are used in this project and would require developing new functionality to be able to incorporate your request. I'm not working on these projects actively any more, only fixing bugs if there are any.

stelpstra · ‎07-24-2022

Hi @CarolBuehrens, glad to hear it has been helpful. Unfortunately, the email address is not in the objects that are used in this project and would require developing new functionality to be able to incorporate your request. I'm not working on these projects actively any more, only fixing bugs if there are any. Alternatively, you could add an extra sheet, adding student details and lookup formulas (e.g. using Index Match) and other formulas to complement the data from the report. Note that the ModuleProgress sheet creates new rows when pulling in new data, so instead of using direct references like this =ModuleProgress!$B$7:$B$60 (this would automatically change every time you run the report) you should use dynamic ranges instead as explained at https://exceljet.net/excel-functions/excel-index-function and https://exceljet.net/formula/dynamic-named-range-with-index I hope that helps.

stelpstra · ‎05-23-2022

Hi @RussTol, You posted a message on this page and the same on one of my other pages. Something went wrong in deleting the double message so your question was: Just saw this thread and this is great. I tried using CanvasModuleProgress1v12, but an error window is displayed: "Unable to complete the request" Canvas returned the message: Unauthorized Would you like to abort? The downloading of the report stops at 28% I'm using Excel 365, Windows 10. Help. The module progress report respects the configured roles and permissions set by your Canvas admin for you. This message could mean that you don't have enough rights to see the course, student data, or specific elements of that. Did it download progress of some of the students or no progress at all, only the names of student or not even that? What happens if you click "no" when you get the error message? Information of roles and permissions depending on your role can be found at: https://s3.amazonaws.com/tr-learncanvas/docs/Canvas_Permissions_Course.pdf https://s3.amazonaws.com/tr-learncanvas/docs/Canvas_Permissions_Account.pdf So it could be many things. If you send me more details via a private message on which details you see it stops and as much details answering the questions above, than together we may be able to find the cause of this issue and hopefully solve it. Screenshots of the data in the Excel sheet where it stops do help a lot.

stelpstra · ‎03-24-2022

Hi @CoreyMcNeill, the page appeared to be hidden without me being able to detect or change that. The page has been made available again.

stelpstra · ‎03-21-2022

Hi @CoreyMcNeill , thanks! Did you look at Download data to Excel using VBA and the API (workbook with code attached) and is that what you are looking for?

stelpstra · ‎02-22-2022

Hi @stevetuxford, I have sent you a private message.

stelpstra · ‎02-22-2022

Atomic Search is an integration that enables searching in Canvas content: www.atomicjolt.com/atomic-search

stelpstra · ‎02-21-2022

Hi @stevetuxford, the code is protected because your token is stored in a hidden sheet which can be compromised by anyone with the password. Therefore I will not share the password with anyone.

stelpstra · ‎10-26-2021

Hi @stevetuxford, the code of the file by @dju_white appears to have a different password (which I don't have) which is recommended not to be shared to protect the token from being accessible to others. The file from my contribution opens the code successfully using the password given.

stelpstra · ‎07-22-2021

Currently, users of a discussion have to refresh the discussion page manually to be able to see new replies to the discussion. More than ever there is a need for online synchronous discussions, similar to all major social media platforms facilitate. Please add functionality: When a user is typing a a reply message, other users in the course viewing the same discussion page see: "someone is typing..." or something similar Once a user is done writing a reply and has clicked the Reply button posting the reply, all other users viewing the same discussion page automatically see the reply message appear immediately So many courses are now thought completely online requiring modern synchronous communication methods, auto showing replies is a quite critical part of it.

stelpstra · ‎07-05-2021

The front image of the YouTube video shows the date and time: July 6th / 12:30pm EST The text on this page shows Tue, Jul 6, 2021 09:30 AM PDT These two times differ one hour: https://www.timeanddate.com/worldclock/converter.html?iso=20210706T173000&p1=tz_est&p2=tz_pdt Which time is correct?

stelpstra · ‎04-09-2021

@peter_tan, the token should be created in your personal account, not on a sub-account level. Please create a token as described here https://community.canvaslms.com/t5/Admin-Guide/How-do-I-manage-API-access-tokens-as-an-admin/ta-p/89 With this token you can access courses in the account(s) you are admin in and courses you have a non-user course role (having the correct permissions).

stelpstra · ‎04-09-2021

@nfenger Thanks for sharing your findings, although I would never recommend disabling Windows Defender. Instead, find the Microsoft Defender Version Installed in Windows 10 and make sure it is updated to at least Antimalware Client Version: 4.18.2102.4 Recently I worked with Microsoft Support to find this to be the root cause if the problem. Older versions of Antimalware Client will most likely cause these problems.

stelpstra · ‎01-11-2021

@twassmer, nope, not the purpose of this tool. @matthewheinlein, thanks, same to you. This blog has been updated several times. If you read it, you'll find your answers 😉 Edit: I see now that you meant not the tool described on this page but another one of my tools. There are many problems with my pages from the start they Instructure migrated the community to this new platform. I am in contact with community managers, but not much is improving. Therefore the other tools you can also download from the google drive linked on this blog. The versions you find there are the latest versions of my tools.

Post Details	Date Published	Views	Likes
Automatically show new replies without page refresh Currently, users of a discussion have to refresh the discussion page manually to be able to see new replies to the discussion. More than ever there is a need for online synchronous discussions, simil...	07-22-2021	489	0
[Gradebook] Separate permission for posting grades apart from editing grades Currently the permission for editing grades gives graders the right to also post grades. This means that different tutors (per section or group) can post grades earlier than others. It should be poss...	06-29-2020	1067	6
Why does the Assignments API not return any Turnitin data and what can be done to fix it? In our institution we use the Turnitin LTI and I am trying to get the turnitin_enabled and turnitin_settings from assignments configured to use Turnitin. On Assignments - Canvas LMS REST API Documen...	10-18-2019	942	2
How to read and change Course Post Policy of the New Gradebook with GraphQL Hi, Recently the Grade Posting Policy has been added to the New Gradebook: https://community.canvaslms.com/docs/DOC-16958-canvas-release-notes-2019-07-13#jive_content_id_Grade_Post_Policies ...	08-06-2019	6106	7
Automated report of assignments in courses Attached Excel workbook is able to download data from Canvas (exclusively using Get API calls) to create an overview of all assignments in all courses you specify using Course SIS IDs. The wor...	04-18-2019	3642	5
Create course groups from sections using Excel Attached Excel workbook is able to download details of the course sections and create a new groupset with groups of your choice. Details of the course sections will be displayed in the columns...	03-15-2019	2688	4
New Grading Scheme Type Supporting Numeric Grading Standards Worldwide This idea involves creating a new grading scheme type, the Min-Max numeric grading scheme, to support numeric grading schemes worldwide without any rounding errors. Also the GPA scale can be facilita...	01-24-2019	2475	25
Notification preferences - GUI versus API As we want to change a specific notification setting of all our 400+ admins (with only read rights) in our sub-account, I have been trying to make sense how the notification preferences in the interf...	01-16-2019	2368	4
How do I enable auto-open for inline preview for external files? Hi, I'm trying to figure out how it would be possible to enable auto-open for inline preview as described in this guide, but then for external files: How do I set the auto-open for inline preview...	08-06-2018	3987	2
Update from Canvas: Media Processing Maintenance I have been receiving Canvas update emails with the following content. Title: Update from Canvas: Media Processing Maintenance ... Message: Hi Admins — Our maintenance window specified 15-20 m...	07-31-2018	730	1
Quizzes.Next Auto-Grading does not finish Description of the Bug: After submitting a quiz (in student view or as real student) the wheel next to Auto-Grading keeps going and wont stop or finish Steps to Reproduce: Open (latest...	05-18-2018	1619	2
Automated report of group sets, groups and members in a course Attached Excel workbook is able to download data from Canvas (exclusively using Get API calls) to create an overview of all group sets, its groups and its members in a course. Group sets and g...	07-23-2017	13725	25
[Reports] Add email bounce count to the Communication Channel API Situation Frequently email addresses used in Canvas bounce emails while admin are completely unaware this is happening. Possible causes: people start using other email addresses and close the...	04-05-2017	1796	15
Download an admin report of all bouncing email addresses This idea has been developed and deployed to Canvas Admins who are allowed to view notifications can access the Bounced Emails tab in Admin Tools. The Bounced Emails tab displays bounced e...	04-05-2017	2545	25
[Peer Review] Add due date for completing peer review Situation The due date of the assignment reminds students to complete the assignment in time. When peer reviews are enabled students don't have an indication or reminder to complete the peer review...	03-02-2017	14632	25
[Peer Review] Respecting sections when automatically assigning peer reviews Situation Canvas does not respect the sections when assigning peer reviews when automatically assigning peers in an assignment is set. This means a student from section A might be assigned as peer ...	03-01-2017	6712	25
Download data to Excel using VBA and the API (workbook with code attached) Introduction There are several ways to get data from Canvas in the form of downloading csv files. In most cases you want to apply some analysis of that data, which may require importing it into exc...	05-16-2016	32578	21
Automated progress report of students in modules Attached Excel workbook is able to download data from Canvas (using Get API calls) to create a progress report of all students in a course with modules to which requirements are added (see How do I a...	11-23-2015	35614	25
Looking for use cases of Liferay integrations for Canvas Please share if you know if there are universities out there who have developed solutions in Liferay to integrate in Canvas (using API and/or LTI). A brief description of the purpose of the solution...	09-15-2015	1016	5
How can I setup a LimeSurvey questionnaire as an external assignment? We use LimeSurvey and created questionnaire to have our students evaluate our courses anonymously. Would it be possible to create an assignment in the course which will open the survey and register ...	09-07-2015	1109	0

Posts	210
Solutions	3
Likes given	324
Likes received	1211
Member Since	‎21 Apr 2015

Re: Automated progress report of students in modul...

Re: Canvas Data 2 updates

Re: Canvas Data 2 updates

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Comprehensive Course Search Tool (Searching Co...

Re: Automated progress report of students in modul...

Re: Download data to Excel using VBA and the API (...

Automatically show new replies without page refres...

Re: Customer Centricity: Livestream with Melissa L...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Re: Automated progress report of students in modul...

Data and Analytics Group

Canvas Developers Group

Higher Ed Canvas Users

New Analytics Users

Discussions/Announcements Redesign

You're signed out