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.
We're having issues with the SQL generated by the DAP. I was on the 1.3.1, and now using 1.4.0, to see if that might resolve the issue. I'm using the python dap module to sync/init and using the MS SQL Dialect for our canvas data 2 tables and I noticed its having issues executing ALTERS and CREATES. This is keeping sync or…
This API is working great for students: https://xxx.test.instructure.com/api/v1/courses/:courseid/analytics/users/:userid/activity But it is limited to student data. How are folks using the API to get high level activity data by course?
I'm working on an archiving scheme for our past courses. As part of this, I'm interested in finding a way to generate a report featuring all the courses that have had no user access in five or more years. How might one find this out using Canvas data?
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian
Hi, When I try to export a table through dap intidb command for a table from canvas space: context_module_progress. I use the following command: dap --loglevel debug initdb --connection-string "mssql://username:password@prodsqlserver.database.windows.net/canvas-prod?driver=ODBC+Driver+18+for+SQL+Server" --namespace canvas…
Hello, I'm posting here for our developer. I hope someone can help steer us in the right direction. We have been running the CD2 API for almost a year. We have run a full reload of the tables once with a column addition, and process delta runs daily. I happened to notice that our courses table is not receiving updates when…
Hi, I am trying to load two tables from canvas namespace into SSMS through the use of DAP command line interface: This is the command that I am using: dap initdb --connection-string "mssql://username:password@princedev.database.windows.net:1433/princedb_qa?driver=ODBC+Driver+18+for+SQL+Server" --namespace canvas --table…
I've read carefully two threads that discuss the contents of the quizzes and assignment tables in CD2: https://community.canvaslms.com/t5/Data-and-Analytics-Group/Assignments-vs-Quizzes/m-p/576490#M1836 https://community.canvaslms.com/t5/Data-and-Analytics-Group/New-Quizzes-CD2/m-p/604408#M2791I I was able to aggregate a…
I don't think this is the intended behavior. But please correct me if I am wrong. Table: pseudonym Column: value_unique_id Data: `NORMALIZATION-COLLISION-d5863032-ag94-4593-6g6d-adf9371f2eb9-xxxxx@gmail.com` spit-balling: So I'm beginning to think that the issue is related to them making login_id unique. (thanks @daniel)…
I am currently assuming that a web_logs record is never updated inside of Canvas Data 2. Is this assumption true? Background: I am currently importing Canvas Data 2 web_logs records via the dap sync command regularly. I have a process that regularly consumes the web_logs records and deletes them from our database after…
Hi there, We're new to the DAP CLI (for MSSQL) and we managed to get the initdb and syncdb working with MSSQL using SQL Authentication. However does anyone managed to connect to the MSSQL with Windows Authentication and if so, how should the connection string be looked like? Many thanks in advance! WL
In case it's helpful for anyone, here's my working-and-also-work-in-progress DAG ("Directed Acyclic Graph" -- it's a fancy word for "workflow" or "batch job") for Apache Airflow. It will probably work as far back as 2.4, and I currently have it running on Airflow 2.10. If you're familiar with python, it's probably pretty…
We want to setup automation for replication of data from DAP to our internal SQL environment. A secret issued to an account admin was used for testing, but we want to scope to a user with only read permissions to data in Canvas and DAP and no other permission within canvas. I have reviewed the information…
Canvas has this definition (see below) for page views vs participation. I'm trying to figure out how to determine this within the Canvas Data 2 data set? What tables and filters are needed to determine this? ==================================================== from Canvas…
In an attempt to generate internal queries and reporting that mimic the Interactions Over Time report (in addition to the other reports on the overview dashboard) from Canvas Admin Analytics. We have: Identified student enrollments for enrollment types = “StudentEnrollment” where WORKFLOW_STATE IN ('active',…