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 upgraded to the new DAP CLI 2.0.0 and are trying to use the new logging feature but we're getting "Error: No such option: --loglevel" This is our command: dap initdb --table attachments --namespace canvas --loglevel debug
Hello all, I am sitting in a session at instructurecon right now and a lot of people are asking questions about getting started with their reporting and analytics goals. I thought I would make this post so that people could connect.
The context_modules_progressions table is said to show which items a student has completed, started and not started in a module. https://developerdocs.instructure.com/services/dap/dataset/dataset-namespaces/dataset-canvas#dap_schemas.canvas.context_module_progressions However, the data in the table is at the user/module…
Hello friends! I am reaching out to better understand what the wider community, or those willing to have a quick email chat, is doing with regards to understanding their Outcomes. Previously, we had a person from our Data & Research Team who would create a PowerBI App reflecting how our students performed on our outcomes,…
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
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…