-
DAP Client v1.3.0 -> MS SQL Server
Hello, With the deployment of the 1.3.0 client, I've decided to TRY and migrate from Postgres into my native SQL Server environment. I have successfully initialized ~88 tables, but I know that's not enough. I'm seeing an issue within the Assignments table that probably exists in other tables. The script that's creating the…
-
Replicating/Automating Built In Reports using Canvas Data 2
We created python scripts using CD2, and import data locally, and would like to create SQL views that are identical to some of the built in reports. One report, for instance, is the report named Students Access Report. Is there any way to get an SQL query, or some design information, regarding how that report can be…
-
CD2 Pulling out which students have been assigned to a particular assignment
Hi all, Looking for some help on how on which table contains the details of who an assignemnet has been assigned to. I have looked under submissions but this does not seem to be a complete list. If anyone can help and share some insight on how and where I can get this info from CD2 it would be appreciated.
-
CD2 - Courses relating (joining) to a Main Program/ MainCourse
Currently looking at canvas.courses table. I want to link all the courses / modules to their respective main Programs so that different programs can be analysed separately. For instance - a computer science Y1 main program could have 6 modules/courses (database, AI, ML, QC, ANN, DS) Is there a way these "sub" courses can…
-
User Emails (or Student IDs ) CD2
Hi, Does anyone know a way to find student IDs or user emails from CD2? I have checked users and accounts tables in the canvas namespace - but they don't have "email" column. I only have the primary key of userID and accountID and only their full name. Is there some other place that I should be looking? Thanks Z
-
Course Navigation Items
With CD1 I used to be able to get a list of all the items in the navigation bar for a course. In the CD2 documentation it says that I should be able to find this information in the Courses table... * tab_configuration (Annotated[bounded_str, JsonStringToJsonObject(), SpecialConversion()] | None) – A JSON serialized list…
-
Interpreting context_module_progressions in Canvas Data 2
We're doing some reporting on student progress in modules, and the data we see in context_module_progressions doesn't entirely match our expectations. * Sometimes a student enrolled in the course doesn't have a record in context_module_progressions. What determines when they get a record? * Some progress records have…
-
Join the Stepping Stones HigherEd Community: A shared LA curriculum
The Unizin Faculty Development subcommittee is thrilled to announce the launch of the Stepping Stones Community, a public Google Group. This community will serve as a hub for our HigherEd peers worldwide to connect, collaborate, and share resources related to the Stepping Stones learning analytics curriculum adoption and…
-
Analytics, report, missing assignments
When I use new analytics, go to run a report for missing work, is there a wat to set a date range? I know I can pull the data in to excel and sort, but is there a way to do this within Canvas?
-
Submission Versions in Data Access Platform
We've been using the Data Access Platform for a couple of weeks now to manage our Canvas data in our own data warehouse and overall have been having a great experience with the tool! However, we've found that the submission_versions table doesn't expose any of the version data for a submission. Instead, it provides an ID…
-
Starting to utilize Redshift
Hi, We are looking at utilizing our Redshift data but we lost our SMEs that knew more about it. We were wondering if there's a school that would be willing to talk to us about your setup experience, usage, and how things are currently going. We're all very new so any information would be helpful. Thanks, Justin Reynolds…
-
Admin permissions to view conversations in Inbox
Aside from the Account Admin permission "Users - act as" is there any other admin permission that controls/grants access to an account admin to view conversations in the Inbox between teachers and students? In other words, if "Users - act as" is not granted, is there any other way that an account admin could access (view)…
-
CD2 Key - now can go for three years
Happened to go into https://identity.instructure.com/ and noticed that new keys can go for THREE YEARS! Yay!
-
Please update discussion_topics__discussion_type
The discussion_topics__discussion_type enumeration does not include the "not_threaded" value added as part of the Discussion Redesign feature. I believe the discussions with this value are currently showing as '__dap_unspecified__', and I would like to request that the enumeration be updated to include the new value.
-
Canvas Data Portal 2 get request object url need python example
I've used Postman and am able to get data from Canvas Data Portal 2. I'm trying to do the same thing in Python. I'm able to get all the preliminary steps (GetJWT, Dispatch query, get status of query) in python, but get a bad request format when trying to get request object url. I suspect the issue is what I'm sending as…