The most recent content from our members.
I am trying to migrate a cd2 / dap web_logs database from my local machine to a google cloud virtual machine. I created a postgres dump of the local database, uploaded it to the cloud, and used postgres restore. Now I am trying to syncdb and get the following error. ✗ ERROR: Operation syncdb failed. Reason: Table not…
Our organization has been asked to provide data and reporting on student activity in Canvas, essentially the number of times a student has accessed courses and resources. The activity is stored in the "web_logs" table which records granular actions, similar to api calls and http requests. There is an abundance of noise in…
Hey folks I've finally managed to wrestle all of my DAP queries into Power Bi dataflows, and it was quite an ordeal. I'm currently using dataflows with DAP as a surrogate databasing solution as we do not currently have access to a SQL server that can store our info, otherwise I would probably be fetching this data using…
Looking for any insight as to why my CD2 submissions table and API submissions are returning an 'attempt' number that is different from CD2 submissions_version and from the New Quizzes moderate page. Also, extra attempts are always NULL even after attempts are added via New Quizzes moderate (possibly related to New Quizzes…
Hi all -- The courses table in DAP has a tab_configuration column which holds a JSON array of various configurations for the course. We recently decided to try to take advantage of that information to determine which files are visible to students (one component of which is whether or not the "Files" section of a course…
Presenter * Mark Reynolds, University of Illinois Description Canvas Data 2 is a great source of information regarding your Canvas service. However, there are challenges in obtaining the data in a quick and efficient manner. We go beyond processing individual tables with yet another "easy peasy" solution using tools that…
Introduction It was great seeing everyone this past week, and thank you to all who attended our Canvas Data 2 Meetup on Thursday, July 11! As promised, @JenniferLash and I wanted to follow up so we can continue the awesome and engaging discussion we all had on Thursday, as well as invite others who may find this post to…
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…
@sgergely It seems that schema versions for a number of tables in the the canvas namespace have reverted. For example, "rubrics" had been at version 2 in mid February, but shows version 1 when downloaded today from DAP. The following tables seem to have issues: access_tokens assignment_overrides assignments attachments…
We recently did a new snapshot of our catalog tables and noticed that the enrollments table contained duplicates of most records. Other tables seemed OK. Has anyone else noticed duplicate records in snapshots? Thanks.
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.