Data and Analytics Group

jasonunf · 2025-03-04

Hello, Does anybody know how to set up a custom location for the files downloaded by the dap? Basically need to setup the temporary folder in a much larger drive, instead of the dap using the windows default temp folder for each user. I'd like to cha...

mclark19 · 2025-03-03

@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 h...

mclark19 · 2025-02-28

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.

reynlds · 2025-02-28

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

kdoherty2 · 2025-02-27

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 confi...

nicki_alori · 2025-02-26

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 ...

jasonunf · 2025-02-20

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...

RachelR1 · 2025-02-18

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

Adamleighton · 2025-02-13

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 s...

AndreDhondt · 2025-02-12

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-...

morgan_j · 2025-02-11

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 assignm...

RachelR1 · 2025-02-06

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...

DanL · 2025-02-06

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 replacem...

RachelR1 · 2025-02-04

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 w...

gwwitte · 2025-02-03

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 n...

cdellapietra · 2025-01-31

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...

CBCDeveloper · 2025-01-28

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 r...

JasonBrandt · 2025-01-24

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\...

reynlds · 2025-01-22

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" "http://www.w3.org/TR/html4/loose.dtd"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/htm...

marco_divittori · 2025-01-15

Anyone know which table contains records about Global Announcements? Thanks!

pgo586 · 2025-01-13

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 cours...

willmoin · 2025-01-13

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...

AndreDhondt · 2025-01-09

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...

ChrisWolf93 · 2025-01-07

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, ...

RuslanDauhiala · 2025-01-03

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 even...

msarnold · 2024-12-17

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 oth...

JamesSorenson · 2024-12-13

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...

dhenry636 · 2024-12-03

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 SQ...

MattLaidler · 2024-11-22

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 wh...

ZaidGandhi · 2024-11-21

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/course...

Data and Analytics Group

Data and Analytics Documentation

Data and Analytics Group Discussions

Canvas Python DAP, custom TEMP FOLDER location

Canvas Data 2 schema version errors

duplicates in Catalog enrollment table snapshot

participation_level/page_views_level for course-level participation???

Canvas Data 2 syncdb not updating meta-data

Historical data of assessment decision when using rubric assessments for grading...

basic MSSQL database configuration

CD2 - Assignment Override 'Noop' Set Type?

Roll Call Attendance / Grades Alert

DAP initdb error: expected UUID

Forwarding Canvas Activity Logs Externally

CD2 - how to identify which users / sections have access to page or discussion

dap_meta - where did it go? Canvas Data 2

CD2 Identify if a assignment grade is visible to student

Student user accesses

Canvas Data 2 Postgres Error with Enum Types

Course Audit log Published Dates from Database

Please Help: SQL Server Support error persists

More CD2 errors happening lately...

Global Announcements

curiosity within Canvas Live Events - can you help explain it?

Date format of New Analytics lateAssignment report not interpretted by Excel correctly

DAP Canvas Data 2 replication error--invalid syntax

Strategies for Using Canvas Data 2 to Improve Student Retention (Discussion/Ideas)

When is "learning_outcome_link_created" event fired?

How to get HTTP debugging info when using Python dap client library

DAP Client v1.3.0 -> MS SQL Server

Replicating/Automating Built In Reports using Canvas Data 2

CD2 Pulling out which students have been assigned to a particular assignment

CD2 - Courses relating (joining) to a Main Program/ MainCourse

You're signed out

Data and Analytics Group

Data and Analytics Documentation

Data and Analytics Group Discussions

Community Help

View our top guides and resources: