-
Reports and Canvas Data 2.0
I have a question relating to Canvas data 2.0. Will this result in any changes/updates to the admin reports - meaning the student submissions report, grade export, user course log, etc.? Will there be additional reports available, or will there be any additional details on those current reports?
-
Can I rely on "value.real_user_id" in CD2?
We want to do some statistics on the use of "Act as ...", and try to do this by checking the CD2 web_logs (/dap/query/canvas_logs/table/web_logs/data). When we look in the column "value.real_user_id" we get hundreds of lines for users who do not have the "Users - act as" permission. How can this happen? Until a good…
-
How do you extract grade from grading_standards.data where scores.course_score = true?
Wondering if anyone can suggest how to extract the equivalent of the grade book total letter grade? In the scores table, scores.course_score is a boolean value where true "represents the overall score for the course referred to in the enrollment". But it doesn't provide the letter grade. Instead it just links to the…
-
DAP Client temp folder and running on AWS Lambda
Hi -- I'm trying to run my DAP init/sync process in AWS Lambda which does not have a writable filesystem by default. This had been working fine as of DAP Client version 0.3.15, but more recent versions (including the current 0.3.18) give me an error, presumably because the library tries to create a "instructure_dap_temp"…
-
CD2 and Course Audit information
We're trying to find the course publish date and who published over a range of courses. We know we can use the Course Audit API - https://canvas.instructure.com/doc/api/course_audit_log.html Checking if this information was also available somewhere in CD2?
-
CD2: Tables holding scores or points for each student
I am attempting to use SQL to query the tables to identify the current score or points/points possible by student for each class and for each assignment as well as any quizzes (etc...). If there is a specific table that maintains the current value for this that would be great however if it is derived on the fly can you…
-
Canvas Data 2: Substitute for web_logs available?
Good morning, we were looking at Canvas Data 2, and at the data available to us. We do not have access to web_logs. We have found out that we do not have web_logs because we subscribed to the service: Managed Teaching and Learning. We found that to have access to web_logs, we would need to switch to Managed Canvas Data…
-
DAP client SSL Error
Installed the instructure-dap-client in Python 3.10 (tried 3.11 as well). Getting an error each time we try to invoke it: [SSLCertVerificationError: (1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')] We are able to use both CURL and the Python Requests…
-
Getting New Quiz Responses from Canvas Data 2
I have an instructor that created new quizzes for an entrance survey and an exit survey that gauges students' knowledge pre & post course. I've downloaded our Canvas Data 2, and loaded it all into PowerBI. I've looked at the schema online, but I'm having a difficult time figuring out what the related tables for this should…
-
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…