I'll state up front that I may not understand the purpose of the OVERRIDDEN columns found in the assignment_overrides table.  However, given the documentation associated with the columns, then one or more of the values in the columns appear to be inc...

Hi Folks!After running into the issue of no data being inserted after syncdb, I reinstalled everything, including python, DAP client, PostgreSQL and upgraded to tsv2py 0.6.2. That seemed to solve the issue of *no* data being inserted into my PostgreS...

Has anybody that was using the Harvard Data 1 extract successfully converted it to use Data 2 and was it just changing the API data?

Good morning folks!After updating to the new stable release of the DAP CLI tool, I was able to smooth out some existing issues which some of you have already experienced:TCI_KEEPIDLE issue was an OS/Python issue "Please use initdb" when trying to use...

I'm trying to extract all clicks to a specific URL from web logs, with user ID-level detail. However, when filtering the logs to that URL, I noticed some users have multiple records (5-10) with timestamps only a few seconds apart. This suggests repea...

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. Confirme...

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

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 (whi...

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...

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 th...

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 someon...

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 tr...

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...

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...

We devised a simple workaround to utilize dap 0.3.18 to load our production MySQL 5.7.15 tables. All of our CD2 SQL queries have been tested and deployed into production using the non-prefixed table names, e.g. assignments rather than canvas__assignm...

Hi , In the CD1 to CD2 schema mapping document below,[PUBLIC]: CD1 to CD2 schema mapping - Google Sheetsenrollment_dim&fact sheet user_id field is obfuscated using the command "obfuscate_global(cast(enr.user_id AS bigint), g_shard_id)".  But it's com...

Can somebody please answer this question for me.  I am experiencing very confusing anomalies between data obtained via API calls and corresponding data obtained via the New Analytics UI.Specifically, I ran the following API call to extract details of...

I was working on switching over a process I had previously been using CD1 Requests for to show the break down of the types of Operating Systems and Browsers are used by our faculty and students. When I was comparing the data I noticed there was subst...

Howdy, I am trying to gather information on the number of assessment submissions are being marked by each of our marking staff. I use CD2 CLI to download CD2 tables. I then import into a database and then run SQL queries on the data. In the submissio...