-
Can retrieve CD2 web_logs data which is older than 30 days?
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 charged service can do that? Many thanks
-
Code error for DAP library
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.…
-
Processing CD2 web_logs in AWS
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 eventually. So one option would be to just download the data as parquet files…
-
Canvas activity and web_logs retention
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, refund processing, or someone claiming to have done something--like…
-
Canvas Analytics: How to show Link/Website access in Analytics
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 websites when they click the link. Pic of a section of the page -- I circled…
-
How to find my Customer Success Manager (CSM) to get onboarded for Canvas Data 2?
Our organization would like to have access to Canvas Data 2. Going through Canvas Data 2 blogs, it says to contact the Customer Success Manager to get unboarded. I have no direct contact with CSM where can I find them?
-
Quiz Version in CD2?
I'm working with exported data from CD2. I'm trying to understand how a version of a quiz submission (QUIZ_SUBMISSIONS.QUIZ_VERSION) relates to the version of the quiz. I don't see a version assigned at the quiz level in the QUIZZES table. So how do I relate the submission to the correct version of a quiz? Or is this…
-
Narrowing Submission Data Based on Term
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 having an issue limiting the submission data as he did in the past and is…
-
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…