Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

Hello, Using the CD2 API, what is the suggested way to get the Users from the User's List on UI?  I have tried using Users and Pseudonyms but I am receiving more results compared to my original logic on CD1.   Also, according to the documentation Use...

  • 0 Likes
  • 3 Replies

Hello!I am new to developing with Canvas data and had two questions:1.  I saw a question from January about new quizzes and the response was that New quizzzes are not in the CD2 data.  Is that still the case?  For our own analytics we are pulling thi...

  • 0 Likes
  • 13 Replies

Note: Relying on my DBA since some of this is a bit over my head. Our scheduled "dap syncdb" process keeps blowing up our CPU. Our DBA used an "explain plan" to see where our performance issue are. Below is the SQL running a loop while sorting throug...

Community Participant
Data and Analytics Group
  • 0 Likes
  • 1 Replies

Hello All, I'm hoping someone can help me understand something that I can seem to get my head around. I'm trying to see a list of a users page views past the last 100 entries. I have the following query entered through the URL /api/v1/users/xxx/page_...

  • 0 Likes
  • 2 Replies

Just this morning 5/13, we began to sporadically receive the error below when running our table syncs. We have changed nothing on our servers. Has anyone else seen this?   ERROR - malformed HTTP response:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 T...

  • 0 Likes
  • 1 Replies

I have a professor who teaches a course that runs from May to June, so not the full Summer term. When they go to New Analytics it shows that there is no new analytics. We waited the 24 hours like it said and there are submissions from students within...

  • 1 Likes
  • 3 Replies

I was wondering if anyone has found a good way to find course pages (pages that are not directly associated with a learning module) in CD2? I was hoping that content_tags would have a way to do it with content_type and tag_type. So far the best route...

  • 0 Likes
  • 2 Replies

For assignments where the points_possible value is set to zero, I see that is a way to create an extra credit assignment.  Is there any other explanation for setting up an assignment that way? The reason I ask is that almost 10% of the assignments in...

  • 0 Likes
  • 2 Replies

A quiz in a course had it's due date changed from Feb 18th to March 30th.    The teacher insists that they didn't do it, and what I can see in PageViews corroborates this.    There are no other teachers or TA or designers in this course, so I suspect...

  • 0 Likes
  • 5 Replies

I noticed as of this morning that the handy  [PUBLIC]: CD1 to CD2 schema mapping: https://docs.google.com/spreadsheets/d/1kqCXAD9K45L0QeEtbuuMAFp2fW8o0oC8EBzJf58SjrY/edit#gid=822574172 Has been moved to the owners trash (screenshot) Is there a more c...

  • 1 Likes
  • 5 Replies

Hey all, CD2 has been a big pain implementing for my organization, once we finally got the DAP tool working now we have v1.1 out with this mandatory namespace issues now and a mountain of new errors.With this new 1.1 dap tool, has anyone received and...

  • 0 Likes
  • 8 Replies

Hi All, I am trying to find where in Canvas Data2 tables can i determine the number of page views a student has on a particular course. I saw a few community page solutions that talks about utilising wiki_page_fact table > view counts seen in this li...

  • 1 Likes
  • 1 Replies

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

  • 0 Likes
  • 3 Replies

Hi I'm looking for advice about working with web_logs and in particular how we might track students' usage through remote_ips. I'm currently maintaining a small server running MariaDB which uses the dap client to retrieve CD2 tables. Firstly - how fe...

  • 0 Likes
  • 2 Replies

From the PostgreSQL DDL script for the "assignments" table, the columns EXCLUDE_BIBLIO and  EXCLUDE_QUOTED have the same comment. Here's the comment:  Selecting this option will exclude text appearing in the bibliography, works cited, or references s...

  • 0 Likes
  • 1 Replies

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

  • 0 Likes
  • 2 Replies

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?

Community Novice
Data and Analytics Group
  • 0 Likes
  • 0 Replies

We are looking to download certain table data, transform it, and then upload to our Azure DataLake storage.The solution I have been working on involves a Python Azure Function app. Since the DAP parquet files have a "key", "value", and "meta" columns...

  • 0 Likes
  • 6 Replies

In a course's People list, each user has their total activity (hh:mm:ss) listed. Is there any way a teacher in the course could export this data as a report? Or as an admin, for the entire account activity? It would be ideal if admins could report on...

  • 0 Likes
  • 1 Replies

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

  • 0 Likes
  • 6 Replies

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

  • 1 Likes
  • 3 Replies

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

Community Participant
Data and Analytics Group
  • 0 Likes
  • 7 Replies

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

  • 0 Likes
  • 1 Replies

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

Community Explorer
Data and Analytics Group
  • 2 Likes
  • 0 Replies

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

  • 1 Likes
  • 4 Replies

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

Community Explorer
Data and Analytics Group
  • 1 Likes
  • 0 Replies

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

  • 1 Likes
  • 2 Replies

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

  • 0 Likes
  • 3 Replies

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:RootAccountSubAccount1Account1Account2SubAccount2Account1Account2I want to retrieve ...

  • 1 Likes
  • 4 Replies

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

  • 2 Likes
  • 15 Replies