-
Canvas Data 2 - User's Feature Usage, PageViews and Device Usage
Hi all, Is it possible to extract a user Feature Usage data, PageView Data and Device Usage/used from Canvas Data 2? I'm fairly new to data analytics and have been scouring the tables from CD2 but unfortunatly thus far I've not really found and tables which would relate to this sort of data. I see in the Canvas Live API…
-
Discrepancy between internal Canvas reports and Canvas Data 2
Hi Everyone, Our organisation recently got access to Canvas Data 2 and I have been comparing data pulled from CD2 to Canvas' internal reports and have noticed some large discrepancies. For example when looking at the enrollments table from CD2, I get around 10% of the rows expected. The same is true for users, quizzes,…
-
Benefits and successes of CD2?
What are the new capabilities that came with the transition to Canvas Data 2? What new reports or benefits have been realized? For example: * late_policies: We can now see if assignments have a missing submission policy set and how many points are deducted when an assignment is missing. That helped us see where a person…
-
Online attendance
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 happening here and how to rectify?
-
dap-client v1.0.0 failing when attempting execute mysql_0_to_1.sql
Hi, After updating the dap-client to v1.0.0 we appear to be experiencing an issue when attempting a syncdb on tables against the pre 1.0.0 syncs that were successful against our on site MySQL database. When we attempt a syncdb on the accounts table i.e. dap --loglevel debug --logfile dap.log syncdb --namespace canvas…
-
Is there a way to translate bash script to Azure with dapclient
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 using a simple script on localhost dev! Have noted 1.0.0.0 is now out; I've…
-
Problem with dap 1.0.0 schema synchronization
Hi -- I'm having trouble getting dap syncdb to work in a reliable/predictable manner w/r/t the application of upstream table schema changes to my local database. For some reason it seems to be trying to execute ALTER TABLE statements every time, even though the table schemas are up to date as far as I can tell. This is…
-
"Visible course nav tools" question
A higher-up asked my boss and me whether it's possible to track which faculty members are using the Attendance (Roll Call) tool in their courses. Since we have it disabled by default in all of our credit-bearing courses, we thought we might be able to answer this by finding out in which active courses it appears as an…
-
"DLL load failed while importing _rust" error (dap-client v1.0.0)
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 resolved or got any suggestions to try? Regards, Mark
-
DAP Client 1.0.0 change in processing???
After upgrading to the 1.0.0 DAP client yesterday, I'm now getting a very specific error: ERROR - [Errno 28] No space left on device It appears that the DAP client is now loading up my /tmp location (which is very limited) for holding and assembly of the various file parts prior to assembly and shipment to Postgres. If I'm…
-
Canvas Data 2 - Get Row Count in a Table without fetching all the data
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 quality metrics like row count. Since the incremental snapshots only provide…
-
Canvas Data 2 Gradebook activity
Greetings, I'm working on a Canvas Data 2 query I'd like assistance with. The goal is to identify courses where the Canvas Gradebook is not being used. Scenarios I can envision are courses that do not have assignments with gradebook entries or assignments are past their due date with no grade. Checking the Canvas Data 2…
-
Canvas Data 2 - Successful initdb but discrepancy in rows imported to PostgreSQL using Python DAP Cl
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 web app, but there are only 166 rows in the local database. Command used:…
-
Tracking LTI usage data in era of CD2
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 data files such as assignment_dim, course_dim, etc., or their CD2…
-
Gathering Data on Assigments that don't have a submission type?
We are working on some data models to be displayed in PowerBI. I have a question regarding assignments when there is not a submission type, the assignment table will have a value of None. So, I can calculate the number of assignments submitted by student from the submissions table if the assignment has a submission type.…