-
Course Audit log Published Dates from Database
Is there any way to get the "Course Audit log" Published dates from the Canvas database? Problem: It seems like currently the only way to get this information is from the Course Audit log API command. Background: A dean wants to be able to run an SQL report that contains the information that he can see from the Course…
-
Please Help: SQL Server Support error persists
We are using the new DAP 1.3.1 client. We perform a database initialization. The API runs fine for all tables until we get to the assignments table. Every single time we are receiving the same error regardless of what we do: File "C:\Users\jbrandt\Desktop\NewDap\.venv\Lib\site-packages\pysqlsync\base.py", line 1173, in…
-
More CD2 errors happening lately...
Got this little ditty today: 2025-01-22 10:05:05,294 - ERROR - malformed HTTP response: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<A href="http://www.w3.org/TR/html4/loose.dtd" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/TR/html4/loose.dtd"> ERROR: The request could not be…
-
Global Announcements
Anyone know which table contains records about Global Announcements? Thanks!
-
curiosity within Canvas Live Events - can you help explain it?
I've been using Canvas Live events (Caliper format) to find instances of files being downloaded in Canvas courses. However, recently it's come to my attention that these events may refer to files with names that do not exist as such within the course's file area. More specifically, I've seen recent live events (raw data)…
-
Date format of New Analytics lateAssignment report not interpretted by Excel correctly
Hi Everyone, One of our school admin team contacted us. She noticed that the New Analytics>LateAssignments reporting generates a time/date format that our setup of Excel does not immediately recognise. E.g. this is the result: Submitted DateGraded DatePosted Date 11:59.019:14.539:22.1 11:50.0 54:55.2 From a CSV file where…
-
DAP Canvas Data 2 replication error--invalid syntax
We've been cloning Canvas data successfully for months using DAP2, but recently noticed this sync failure, which looks to be coming from DAP code. When I run this directly in a query editor it balks at the newline separators and the quotes as well as the comma separating the two add value clauses. File…
-
Strategies for Using Canvas Data 2 to Improve Student Retention (Discussion/Ideas)
Hi everyone, I’m looking for ways to evaluate and improve student retention at our university, and I’m particularly interested in leveraging data from Canvas Data 2 as well as other sources to identify and support struggling students. At the moment, I’m exploring the best ways to analyze and apply data effectively to flag…
-
When is "learning_outcome_link_created" event fired?
I've checked "learning_outcome_link_created" check box and then added an already created outcome into a course via "Find" button, however I don't get any "learning_outcome_link_created" event fired - am I looking at the wrong event? Is there any event Canvas fires when an outcome is "linked" a course? Thanks!
-
How to get HTTP debugging info when using Python dap client library
Hello, when using the Python dap client library (not the CLI), is there a way to get access to the HTTP request / response headers and bodies for debugging? Example: I sometimes get errors like "malformed HTTP response" or "invalid_client" but no other information in the stacktrace. It would be helpful to see the HTTP…
-
DAP Client v1.3.0 -> MS SQL Server
Hello, With the deployment of the 1.3.0 client, I've decided to TRY and migrate from Postgres into my native SQL Server environment. I have successfully initialized ~88 tables, but I know that's not enough. I'm seeing an issue within the Assignments table that probably exists in other tables. The script that's creating the…
-
Replicating/Automating Built In Reports using Canvas Data 2
We created python scripts using CD2, and import data locally, and would like to create SQL views that are identical to some of the built in reports. One report, for instance, is the report named Students Access Report. Is there any way to get an SQL query, or some design information, regarding how that report can be…
-
CD2 Pulling out which students have been assigned to a particular assignment
Hi all, Looking for some help on how on which table contains the details of who an assignemnet has been assigned to. I have looked under submissions but this does not seem to be a complete list. If anyone can help and share some insight on how and where I can get this info from CD2 it would be appreciated.
-
CD2 - Courses relating (joining) to a Main Program/ MainCourse
Currently looking at canvas.courses table. I want to link all the courses / modules to their respective main Programs so that different programs can be analysed separately. For instance - a computer science Y1 main program could have 6 modules/courses (database, AI, ML, QC, ANN, DS) Is there a way these "sub" courses can…
-
User Emails (or Student IDs ) CD2
Hi, Does anyone know a way to find student IDs or user emails from CD2? I have checked users and accounts tables in the canvas namespace - but they don't have "email" column. I only have the primary key of userID and accountID and only their full name. Is there some other place that I should be looking? Thanks Z