Sign in to enhance your access to articles, forums, and events—and to participate by sharing insights, engaging in discussions, and connecting with your network of edtech peers.
Just checking what's the current state of getting LTI Usage information out of CD2. I see there are a few LTI-related tables, but they all seem to mention LTI 1.3. Has anyone worked on reporting of LTI usage then via CD2 tables?
Hello, I'm hoping someone has seen this and knows how to fix it. I'm trying to load the scores table in DAP and this is repeatable for me: Step 1: Drop the scores table Step 2 Initialize the scores table: ...@ubuntu-vm-karl:~/bin$ dap initdb --namespace canvas --table scores INFO:pysqlsync.postgres:connecting to…
Hello! I'm doing some time calculations and wanted to use the time_zone from the courses but I am finding a lot of courses that don't have the time_zone property in the JSON but when I look at the course in Canvas it does have a time zone set. Has anyone else encountered this?
Hi! Does anyone have experience with how Advise interprets Canvas data, particularly regarding LTI analytics from Canvas/publishers? We have Advise and Canvas connected and better understand the data such as "Participation" and "Submission" but we're not seeing the data from the LTI provided by 3rd party tools. The trouble…
Hi, Canvas Community, I have a problem. The tables are exported from Canvas via the CLI tool (Canvas Data 2). There is a table called "submissions". But this table only captures the students' most recent submission for one assignment. How can I get all the submissions for one assignment? For example, the student has made a…
Hey Community, I am currently working on a synchronisation of my own database, in which I make use of Canvas Data 2. Right now I am fetching their data, mapping their models to my models and filling my database with it. This is currently a migration of a previous implementation that runs with the old Canvas LMS Rest API.…
I am trying out Canvas Data 2 in preparation for writing an ELT pipeline, and I noticed an issue with version 1.1.0 of the instructure-dap-client library. Whether I try to get data using the command line tool or the python library, I get errors about an invalid gzip format. This only happens with parquet files. I am able…
I'm trying to calculate the average number of students who have viewed at least 1 page on the site per week. So far, not getting anywhere because I need to be able to see unique page views rather than just 'page views'. Any ideas how to get this out of New Analytics?
Wondering if anyone has any suggestions regarding some "time series-like" analytics for enrollments total_activity_time and active user counts? I'm conscious that CD2 is "eventual consistency" so time series analysis of things like weekly total_activity_time and overall active user count trends arent possible. There's no…
Hi all! I'm trying to identify a path forward for my institution to leverage the Canvas Data 2 API to obtain data around course level participation. From what I've gathered, it seems to have been possible in v1 of the API but I'm not immediately seeing anything analogous in CD2. I do see the canvas_logs.web_logs table but…
I know that you can only see and manage the keys that you generate within the Identity Services, so they must be associated to the user. But do they also inherit the Canvas User's status, roles, and permissions? Or, once generated, are they independent credentials with their own expiration and all with the same (full)…
Hi Instructure! Is there a way to access the time zone code for the user's set time zone? Example: * Right now, a user can set their time zone in the LMS to Eastern Time (US & Canada) (-06:00/-04:00)at /profile/settings. * The time zone value for this user via Canvas Data 2 looks like this: Eastern Time (US & Canada)…
I am being tasked with creating a Tableau dashboard that looks at New Analytics at a more global/course level scale. Does anyone know if there is a backend query that drives the New Analytics data that I could fork as way to improve my query?
I'm updating our init and sync code to reflect what is prescribed in the documentation's Instructions and I am receiving the following error when i run pip install × Building wheel for tsv2py (pyproject.toml) did not run successfully. │ exit code: 1 ╰─> [26 lines of output] compiling with AVX2 compiling with limited C API…
I need to find data from a course on the number of new enrollments in the course within a certain timeframe. Is there a report I can run that will give me that information? Thanks!