-
Identify Courses with Classic Quizzes
I'm part of the support team at a small private college (around 1500 students) and we're working towards migrating all our courses' classic quizzes to new quizzes. I was curious if there was a way to quickly identify the specific course sections that are utilizing classic quizzes, so that we don't have to open each course…
-
What table has the Rubric Criterion scores?
We are trying to pull rubric scores into our data lake. We have been able to locate and pull the outcome scores, but we have not been able to find the regular rubric criterion scores anywhere. Is it possible to pull the regular criterion scores similarly to the outcome scores?
-
ERROR - Cannot connect to host api-gateway.instructure.com:443 ssl
Hello, I am trying to configure DAP client on a new Windows server, followed all the instructions as per the documentation. When trying to fetch the list of tables using "dap list --namespace canvas", I got the below errors. Any help in resolving this error is really appreciated. Thank you. C:\Users\attilisatish>dap list…
-
Assistance with SQL Query Extracting Student Scores For Assignments and Courses in Canvas Data 2
The goal is to create a SQL query to extract the student (prefer the student ID), the course, the assignment, and the associated grade. I have the following query but it is not what I want or need. I am purposefully limiting it to a particular term but need all of the courses, assignments, scores by student. SELECT…
-
Is Canvas Data 2 available on the self-hosted Canvas Community version?
Hi Community, I am inquiring whether Canvas Data 2 is available on the self-hosted Canvas Community version. If so, how can we generate the client secret/key? It appears that the identity services for generating the secrets are only available for the Instructure-hosted instance. Best regards, Jasmine
-
DAP initdb on submissions table throws a date error
When I run initdb on the submissions table I get a "year 0 is out of range" error. It seems like I'm dealing with a bad row of data. What are the best options for resolving this? I assume I could ask our canvas admin to clean up that row of data, but that doesn't guarantee there won't be other/future rows with the same…
-
Canvas Data 2 Missing Some Learning Outcomes
Hello Everyone, We use learning outcomes quite a bit in our work. Faculty add Learning outcomes to their traditional rubrics and use them for grading in speedgrader. I don't know if it matters or not, but for the sake of completeness I'll add that faculty are instructed to do the following when adding an outcome to a…
-
Canvas Data 2 Header Files & Folder/File Names
I am working on a Python script that will download all of the files in the tables available to us in the Canvas namespace. I noticed when I unzip the .gz files, some have 1 file, the others have 2 files. The ones with 2 files in them appear to be a header file and an actual data file, but the data file also includes the…
-
Could Instructure report on CD2 status on a table by table basis?
I have an alert in place that warns me when our CD2 data retrieval process has been unable to retrieve any given table for at least a couple of days (BTW each day we retrieve snapshot data once, and incremental data every 4 hours after that, with 3 attempts each time around on each table). I received one such alert early…
-
2023-12-18 DAP Querying service is overloaded or under maintenance
Just got the following 503 { "error": { "uuid": "8a31f148-167e-4e83-981a-1982caf43480", "message": "DAP Querying service is overloaded or under maintenance.", "type": "Overloaded" }}
-
Cloud Access to CD2
Our data team asked the following: Does CD2 keep the actual tables in s3 containers as parquet or other file types ? And could they provide a url to the s3 container? Our fabric allows for linking directly to s3 containers. That's above my knowledge, but I kind of doubt Instructure will give us any other access than the…
-
How to automate data sync
Hello, We are new to Canvas LMS at the University of San Diego. I have successfully configured the CLI/DAP and created and updated the tables in Postgres using dap initdb and dap syncdb commands manually. Now, I would like to schedule a batch file to refresh the tables nightly on a daily basis. Can you please guide me on…
-
Guide - Using Canvas Data v2 to download exports of tables using Powershell
We, at California Northstate University, are implementing canvas data v2, but we are finding that unless you use the python client library (which is not an option for us, we have no python developers or anyone to maintain a python environment) the documentation is extremely inadequate. We are attempting to communicate with…
-
Migrating to Canvas Data 2 - Rework old code or use a new approach
Hello everyone, We are working to update to Canvas Data 2, but our current method of using canvas-data-sdk is no longer compatible following the canvas data 2 changes. Our current method does the following with 3 commands total using canvas-data-sdk on canvas data 1: * Gets the schema for ALL tables * Generates a Postgres…
-
dap initdb error with Redshift: "ERROR - database connection error: unknown type: pg_catalog.json"
I'm using this command: dap initdb --connection-string postgresql://USER:PASSWORD@HOST:PORT/DB --namespace NS --table access_tokens But I get this error (it's the same for any table): 2023-12-14 04:55:37,658 - ERROR - database connection error: unknown type: pg_catalog.json I think this is looking for a data type called…