-
Add Intelligent Agents Function for Canvas LMS
I am at an institution that uses Canvas LMS, but I came from one that used a version of Desire2Learn/Brightspace. While I like a lot about what Canvas offers, I find myself missing a really valuable feature for course design and student engagement especially in the context of heavily technology-enhanced courses. D2L calls…
-
CD2 - Try to use dap initdb to get all tables but table argement is required
I am trying to populate a database with ALL the tables in the Canvas namespace. I am following the instructions on this documentation to initialize my database using the initdb command. Below is my CLI: dap initdb --connection-string my_connection_string --namespace canvas but I get an error saying the table argument is…
-
last_activity_at within the Enrollments table - CD2
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 assignments in a course. I had been hoping to use the "last_activity_at"…
-
Why does listing tables from canvas_logs namespace still return user_agents table
Why does listing tables from canvas_logs namespace still return the user_agents table? I thought this table was deprecated/sunset? Is there a plan to stop listing it? This dap command returns the following: dap --base-url $DAP_API_URL --client-id $DAP_CLIENT_ID --client-secret $DAP_CLIENT_SECRET list --namespace…
-
Zero participations
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 attached). Thank you!
-
Roadmap for Canvas Live Events
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 pros and cons, but in the last year we've found ourselves using Caliper…
-
dap client throwing QueryException on sync table
Hi all, I am getting this error SELECT cls.relname FROM pg_catalog.pg_class AS cls INNER JOIN pg_catalog.pg_namespace AS nsp ON cls.relnamespace = nsp.oid WHERE nsp.nspname = 'instructure_dap' AND (cls.relkind = 'c') ; when syncing the table with dap 1.1.0, PostgreSQL 16, Python 3.12.2, Windows 11 tasks = […
-
CD2 and LTI Usage
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 I can use the context_id -> courseid * if context_type: account, that…
-
CD1 Requests vs CD2 web_logs: completeness and correctness
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, _not_ in isolation for auditing or other high-stakes analysis involving…
-
S3 on DAP Client roadmap?
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 CD2, but we have a strong preference for a data lake approach. In the interim, we're using an…
-
Python - turn off logging
Hello, I'm using Python to automatically sync our CANVAS data into our database. However, I'd prefer to not have the results of each table's syncing printed out (e.g. "No rows to upsert", "No rows to delete"). Is there a way to add a line (or so) to the code so that those logs won't be printed out? I'm new to this Python…
-
Issues with Canvas Data 2 API Files download
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 an S3 link to a file, but I can’t retrieve the file using Python. Here is…
-
Was there a recent change to the CD2 web_conferences table schema?
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 announcement about anything changing, but maybe I missed it.
-
CD2 User Defined data types
I'm working with CD2 in PostgreSQL and I'm noticing that CD2 seems to take an opinionated stance on data types with many columns being user defined (typically enums). For example, `context_type` in `lti_resource_links` is of type `lti_resource_links__context_type` I'm just curious about the rationale? Mostly because I'm…
-
Ability to see marks from multiple courses built under one blueprint
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 one courses made from blueprints. We want this because although the core…