-
Incremental query with missing pseudonym entries
Hi - I'm using DAPClient 1,1 and postgres 16 With an incremental query I've discovered we seem to have started losing pseudonym "id"'s. e.g. users.id 2720 has pseudonym.id 2689, but in the pseudonymn table 2689 has been skipped, so has 2693. Confirmed that this relationship does exist in live API. No errors in DAP output…
-
SCORM Usage in Data 2
Hi, Does anyone have any idea how to track the usage of SCORM packages across the entire instance. I need the number of packages deployed and the number of courses that have at least one package deployed
-
Obtaining Roster emails: Allow New Analytics to run before publishing the course
To follow standard best practices in online courses, we require our facilitators to send welcome messages (sometimes more than one) to participants before the course is published. The roster in grades and people shows student logins or SIS ID's (which are basically useless to facilitators), and it does not show accurate…
-
Error running initdb with DAP 1.1
On several table downloads using initdb I'm getting dozens of the error below. This has only been on a few tables so far. I have tried dropping the table and re-running, that worked once but not on the conversation_messages table. We're using Python 3.12, DAP 1.1, Postgresql 15.6 File "C:\Program…
-
Give System Admins ability to see progress on Course New Analytics
It would be immensely helpful if the Canvas Sys Admin (or course teacher if that was possible) was able to see the progress New Analytics was making. If it goes over 24 hours, usually teachers will contact support thinking something is wrong, and there's no way for Canvas Sys Admins to see whether it's stuck or if it's…
-
Setting up DAP Synchronization in AWS, Fargate or Labmda?
Hello all, our team is new to developing solutions to pull data from Canvas. I have been lurking in the forums for a bit, trying to gather as much information I can to set up the correct tools that we would need to be successful. However the one part I am wondering about is where to run the Python functions to handle the…
-
Canvas Data 2 Schema Out of Sync?
Hi All, Our group recently rebuilt our entire Canvas database with the release of DAP 1.1.0 (we were behind and using a deprecated version until that point). After dropping and initdb'ing all our tables again, everything was working again, with the exception of: 1. canvas.comment_bank_items, upon initializing, reports an…
-
(Canvas Data 2) Is it possible to scope on SubAccounts?
Hey Community, I’m currently trying to migrate my application to use Canvas Data 2 and I’ve been running against a problem and was wondering if you could help. Example: RootAccount * SubAccount1 * Account1 * Account2 * SubAccount2 * Account1 * Account2 I want to retrieve all data from SubAccount1, now I thought this could…
-
Canvas Data 2 Query Review
Confession: I am not a developer or an SQL expert, but I can view certain kinds of code, sort of learn it, and make adjustments as needed. Otherwise, I rely heavily on ChatGPT, particularly when it comes to SQL. 😁 That said, I was wondering if someone more experienced with SQL than I might be able to please look over the…
-
DAP Client syncing tables returning "pysqlsync base QueryException": column resource_link_lookup_uui
When we are running our DAP synchronizer python script, we are running into issues going back to Feb 27. This was the last time it ran successfully and we noticed it 2 days ago. When diving into the issue we are finding that several tables now are trying to cast automatically to type uuid. How do we fix this? Should we…
-
DAP CLI Tool Imports Structure but No Data into Tables
Hello Community, I'm currently working with the DAP CLI tool to import Canvas Data 2 into a database, but I'm running into an issue where the tables and column headers are created successfully but the table rows remain empty. This is after running the “initdb” command (dap initdb --namespace canvas --table TABLENAME). I am…
-
Canvas Data 2 public table submissions column submitted_at returns inaccurate dates
Good afternoon, PostGres SQL queries using Canvas Data 2 for the public table, submissions column, submitted_at field returns inaccurate dates. Below is an example of the results of a submitted_at field for a student in a class. The top is null because the row was for a teacher and would not have submitted the assignment,…
-
Decompress parameter in the dap client v.1.1
In v1.1 of the newly released dap client, there is now a decompress parameter in the API. Is there a plan to include this parameter in the CLI version of the dap client? I love this feature and have a workaround in place to change the default to True. Works great for my needs at present but would love to see it as a…
-
Canvas Data 2 403 Forbidden Error on the job endpoint
I am getting a 403 error on the job endpoint specifically. Please see the message below ********************** Got response: HTTP/1.1 403 Forbidden [Server: CloudFront, Date: Fri, 22 Mar 2024 13:53:34 GMT, Content-Type: text/html, Content-Length: 915, Connection: close, X-Cache: Error from cloudfront, Via: 1.1…
-
Canvas Data 2 authentication Error
I believe that I have followed the install directions for placing the Canvas Data 2 Command Line tool on my machine. I've created my Canvas Data 2 API key. I thought I would try out the simple command below, which is supposed to return a list of table names: dap list --namespace canvas But I get an error message:…