-
CD2 Ungraded Submissions
Howdy, I use CD2 CLI to download CD2 tables. I then import into a database. I am trying to set up a query to show all assignment submissions that are not yet graded. It seems to me that the submissions table that I download using the CD2 CLI is not showing separate entries for multiple submissions of the same assignment by…
-
Course Primary Instructor
Hi All, I have been looking over the ER diagram and documentation for Canvas Data 2 trying to find some sort of indicator for the primary instructor of a course. In many cases we have multiple teacher enrollments for a given course, and we'd only like to report the primary instructor. Does such a thing exist?
-
Error with 1.0: operation not permitted; cannot drop values in an enumeration: dimdim
I am still attempting to get all of our tables syncing again after the changes with 1.0, and when trying to update the web_conferences table I am receiving the following error: pysqlsync.formation.object_types.FormationError: operation not permitted; cannot drop values in an enumeration: dimdim. Full Lambda stack trace is…
-
DAP 1.0.0 syncdb error in PostgreSQL - table not initialized, use "initdb"
I used the initdb command to create a table. The table is created successfully with some data. Then when I try to use the syncdb command the following error appears: INFO:pysqlsync.postgres:PostgreSQL version 16.0.2 final 2024-03-06 15:48:52,993 - ERROR - table not initialized, use `initdb` Has anyone seen this error and…
-
Canvas Data 2 API - Incremental Query Empty Files?
Hello I was wondering if anybody else has encountered files returned by the incremental queries in the CD2 API being in empty parts? In the screenshot we ran an incremental query but seem to consistently get a part 0 that's empty, that doesn't feel intended. Thanks
-
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…