-
Canvas Data 2 schema version errors
@sgergely It seems that schema versions for a number of tables in the the canvas namespace have reverted. For example, "rubrics" had been at version 2 in mid February, but shows version 1 when downloaded today from DAP. The following tables seem to have issues: access_tokens assignment_overrides assignments attachments…
-
duplicates in Catalog enrollment table snapshot
We recently did a new snapshot of our catalog tables and noticed that the enrollments table contained duplicates of most records. Other tables seemed OK. Has anyone else noticed duplicate records in snapshots? Thanks.
-
participation_level/page_views_level for course-level participation???
I'd like the details of these elements to understand what it means and how it's calculated on this API endpoint: https://canvas.instructure.com/doc/api/analytics.html#method.analytics_api.course_student_summaries
-
Canvas Data 2 syncdb not updating meta-data
Has anyone experience this issue? When we run syncdb to refresh our CD2 enrollments table to postgres, the process hangs and does not finish. All other tables sync successfully. Some enrollments data are being loaded to the database. We can confirm this from using the latest updated_at date on the enrollments table.…
-
Historical data of assessment decision when using rubric assessments for grading...
Hi everyone 🙂 Im hoping someone else out there has found a way to resolve this challenge.... Problem definition: We use assignments with rubric assessments for grading, but we want to have visibility of the movements within the rubrics so it is easy to track what assessment judgments were made, by who and when. For…
-
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 -…