-
basic MSSQL database configuration
HI, I'm looking to migrate our CD2 setup from postgres to MSSQL and I'm running into an issue. Does anybody have information on properly setting the DAP for MSSQL server? I'm not finding any information beyond the basic connection string used and i'm getting this error when doing a basic dap init command 2025-02-20…
-
CD2 - Assignment Override 'Noop' Set Type?
Hi all, Can someone please help me understand what the Assignment_Overrides.Set_Type = 'Noop' means? I can't seem to find any documentation on it. Thanks all 🙂 Rachel
-
Roll Call Attendance / Grades Alert
I need to implement an attendance monitoring system that triggers alerts when a student's attendance rate falls below 85%. However, to avoid false alarms at the start of a course when the sample size is small (e.g., missing 1 out of 2 classes would show as 50% attendance), I'd like to set a minimum threshold of 5 lessons…
-
DAP initdb error: expected UUID
When running the following from the command-line, I get an error that prevents me from synchronizing the collaborations table: >dap initdb --namespace canvas --table collaborations 2025-02-12 14:16:09,376 - INFO - Query started with job ID: 5bb1d1c0-595b-4bfb-8bdb-feb74c21f521 2025-02-12 14:16:09,516 - INFO - Data has been…
-
Forwarding Canvas Activity Logs Externally
Wondering if anyone would be willing to share how they might be forwarding Canvas activity logs to an external logging system (Splunk or syslog)? More specifically, how you are getting analytics out externally to see student activity logs of assignment submissions, authentication, etc. Thanks!
-
CD2 - how to identify which users / sections have access to page or discussion
Hi all, I am needing to identify the students who have access to a discussion, page/wiki or module via CD2 when access has been limited to certain sections and or students via the 'Assign Access' feature. Is someone able to help point me in the right direction? Thanks in advance! 🙂
-
dap_meta - where did it go? Canvas Data 2
After updating to the latest and greatest Canvas Data 2 dap client cli version, I notice the dap_meta table (which stored the timestamps of when all the tables were last updated) seems to have been renamed to dap_meta_backup, and there is no replacement dap_meta table being populated. Anyone else noticed this? Did this…
-
CD2 Identify if a assignment grade is visible to student
Hi all, I am trying to figure out how to identify if an assignment grade is visible to a student (posted) using CD2 data. The submissions table workflow state only has a 'graded' state but that doesn't identify if it is available to students. Any help will be much appreciated! Thanks 🙂
-
Student user accesses
Hello, My institution is trying to identify students who have not accessed their online courses through Canvas in the first two weeks of class. Looking at the data tables on the DAP ERD it seems like canvas.asset_user_accesses likely has the data I need, however when I query the canvas namespace I'm not finding that…
-
Canvas Data 2 Postgres Error with Enum Types
Hi All, Our group noticed a few tables producing error messages with the updates to the enumeration types recently. Upgrading the DAP client to the 1.3.1 didn't seem to fix the problem with the enum type update, but I did notice a change in the syntax of the ALTER TYPE statement: 1.3.0: 2025-01-31 10:28:14,932 - ERROR -…
-
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)…