Hi all! We use new analytics for online attendance. It seems it isn't capturing records for several students across multiple grade levels and classes. It is turned on in all courses, everything seems to look good on our end. Any thoughts on what is h...

So, not super familiar with Azure but we've managed to set up a pipeline (but getting occasional fails) and debating finisihing incremental approach. I do ultimately want to get this into a postgres db. At the moment I get far more reliable data usin...

Hi, I've just updated to the latest v1.0.0 version of the dap-client plus updated the cryptography to v42.0.5 & even when I now attempt to run just 'dap --version' I get the aforementioned DLL load error. Anyone else experiencing this? Anyone resolve...

When using CD2, is there a way to retrieve the total rows in a specific CD2 table? I am using CD2 to load data in a visualization tool. After pulling data using a full snapshot, i periodically pull incremental snapshot for changes I also collect qual...

Hi all, I was able to populate local PostgreSQL using the Python dap client, but there seems to be a discrepancy in the number of rows imported compared to what I see in the Canvas web app.For example, I can see more than 900 courses in the Canvas we...

A couple of years ago, I submitted this question to the community: https://community.canvaslms.com/t5/Data-and-Analytics-Group/How-to-Track-External-App-Usage/m-p/529110#M1466 Now that Canvas Data Portal has gone away, I don't know how to retrieve da...

Hi all, According the datasets from CD2, https://data-access-platform-api.s3.eu-central-1.amazonaws.com/tables/catalog.html#schemas.canvas_logs.web_logs.It states that web_logs defines as follow:Stores the Canvas web application server access/request...

Hi all,My institution starts to use Canvas since 2014, and now we focus on CD2 web_logs. As I know that the DAP API can only retrieve the latest 30 days data. May I ask is it possible way to get back the web_logs data from 2014? If no, is there any c...

Hi all,   I refer the section 'Getting latest changes with an incremental query' from the link https://data-access-platform-api.s3.amazonaws.com/client/README.html#command-line-usage and program the code to retrieve the web_logs with datetime range. ...

Hi everyone,does anyone have any experience or lessons learned in regards to processing the CD2 web_logs table in AWS (Glue / Athena / etc)?We don't have any immediate specific use cases, but we know that researchers will want to query data eventuall...

Greetings, I'm curious how others are using and managing the Canvas web_logs data and activity reporting. There's a lot of, often vague but genuine, interest in this data for things like, Querying course activity for things like administrative drops,...

I have an instructor that uses both PDFs and links to websites for students to access and read.  The analytics will show if they downloaded the PDFs but not if they accessed the links.  Is there a way to get analytics to document student access to we...

Good Morning, I'm an LMS Admin trying to assist my BI Systems Director with our transition to Canvas Data 2.0 and Managed Teaching & Learning. We pull submission data to share with our campuses and programs to track student progress. However, he's ha...

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

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

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

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

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

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

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

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