We are looking for a way to create a report showing all the settings selected for quizzes and assignments in a spreadsheet. We are finding that when we create multiple quizzes or assignments, we sometimes miss enabling certain settings every time (i....

I'm trying to see if students bother to look at the responses I give on the discussion board after their participation deadline.  As a result, I've exported the course activity via 'New Analytics'.  In the "Content Type" column of the csv file I down...

Problem I've noticed there are entries in most course content items for a migration_id. My assumption was this was a way to join with the content_migrations table, but the id in that table doesn't match the format of the migration_id.  What I'm Tryin...

A disgruntled teacher when through and deleted a bunch of stuff from a bunch of courses. I need to be able to answer this question, and seemingly cannot due to inadequate Canvas logging.    "What did a faculty person delete, from where, and when"? If...

I'm seeing a lot of students that do not have a value within the Enrollments table in their "last_activity_at" attribute.  I resync'd my data this morning into Postgres and found a case where a student showed no activity, but had completed several as...

Hello,  I am looking at the New Analytics for my course and it is showing zero participations, but I know students have submitted quizzes. This is listed as what counts as a participation so why is it not generating numbers on the graph (image attach...

Tagging @sgergely since this is mostly a question for him, but I suspect it'll be of interest to folks like @ColinMurtaugh and likely others. For a few years, we've been using a mixture of CD1 requests and Canvas Live Events. They both have their pro...

Hi all,I am getting this error SELECT cls.relnameFROM pg_catalog.pg_class AS cls INNER JOIN pg_catalog.pg_namespace AS nsp ON cls.relnamespace = nsp.oidWHERE nsp.nspname = 'instructure_dap' AND (cls.relkind = 'c');when syncing the table with dap 1.1....

Got my hands on the LTI tables in CD2 now, trying to query if I can list all LTI 1.1 and 1.3 related to a specific course. Context_External_Tools (LTI 1 and 1.3) - has two kinds of tools (context_type) - Account, Course if context_type: course, then ...

The CD1 Requests table included a significant disclaimer: "The data in the requests table is a 'best effort' attempt, and is not guaranteed to be complete or wholly accurate. This data is meant to be used for rollups and analysis in the aggregate, _n...

Mostly a question for @ sgergely and @GergelyTar - I was just wondering if there's anything on the DAP client roadmap for syncing to an S3 location and/or using Iceberg? We're going w/ PostgreSQL for convenience in making our transition from CD1 to...

I’m working with Canvas Data 2 API and am having trouble accessing S3 files programmatically. While I can manually open the provided URLs in my browser, I receive a 403 Forbidden error when trying to access them using Python. I’ve been provided with ...

We're not using DAP, so our job failed when checking the schema version the other day for the web_conferences table. (We currently do schema updates by hand for ... reasons.) Is there a change log of CD2 schema changes anywhere? I don't recall any an...

Hi all,I know anyone who uses the One to One model of Canvas with Blueprints Enabled runs into the issue where you will need to see the markbooks for multiple courses that were populated from a blueprint We are of a site where we have over 30 one to ...

DAPClientError: malformed HTTP response occurs at least twice in a month. and was unable to identify the exact issue.   DAPClientError Traceback (most recent call last) Cell In [35], line 3 1 if __name__ == '__main__'...

Apologies for not knowing where else to ask. Our institution is a bit late to the full understanding of how outcomes beyond the course level can help us make informed decisions. I'd like to start with how to replicate the Learning Mastery Grade book ...

In previous terms, by disabling New Course and User Analytics in the Features Options of the settings automatically reverted back to the old analytics. However, the same process is not working for my Fall 2024 course. Disabling New Analytics removes ...

Hello!  I'm doing some time calculations and wanted to use the time_zone from the courses but I am finding a lot of courses that don't have the time_zone property in the JSON but when I look at the course in Canvas it does have a time zone set.  Has ...

Hi!  Does anyone have experience with how Advise interprets Canvas data, particularly regarding LTI analytics from Canvas/publishers?  We have Advise and Canvas connected and better understand the data such as "Participation" and "Submission" but we'...