Data and Analytics Group

rob_callicotte · 2016-01-12

What does this file do and how can I manipulate it with impunity? The reason I'm asking about this is I noticed if I delete the dataFiles directory, after having processed the Canvas Data, the CanvasDataCli command does not recognize the fact I need ...

rob_callicotte · 2016-01-12

canvasDataCli -- How to create a LOG file? I've used the -l command, but do not see a log in any of the directories.

agschmid · 2016-01-11

The enrollment_term_dim table already has the date_start and date_end fields, but they are not populated yet. Any idea when these fields will be populated?

f000f2p · 2016-01-08

Does your institution have a clearly defined understanding or procedure concerning the governance of Canvas data. We had been using Canvas data extensively to address various questions ranging from student, course to departmental level. Now Instructu...

slonn · 2016-01-07

We currently leverage the Canvas Analytics API to query page views as a measure for engagement.The page views are, typically, less than the counts per user from the requests table - which makes logical sense. However, the magnitude of this differenc...

auerbach · 2016-01-06

I can't find anything in the documentation discussing encryption for Canvas Data. When the data is instantiated in Redshift, is encryption enabled to protect data at rest? Is there any encryption on the flat file repository?Glenn AuerbachUniversity o...

bohinsk1 · 2015-12-25

Hey all,I posted to feature suggestions a while ago asking for implementation of scoring details for the total grade so students can see how their overall grade aligns with the class average. While procrastinating from studying for my finals I create...

slonn · 2015-12-22

This is a user action from the Grades tool that allows students to see course average & range for each graded assignment. It's a click on the button on the right-hand menubar marked "show all details"I think it might be '/api/v1/courses/<###>/ping' ...

millerjm · 2015-12-17

I'm having some issues installing on ubuntu linux. I have the latest nodejs available for ubuntu - v0.10.37Can anyone help with this? I get the following results when I install canvas-data-cli: root@canvasb:/home/millerjm# npm install -g canvas-da...

msanders · 2015-12-15

I am using MS Access to join my tables and look at the resultant data. When I bring in the quiz_submission_fact date field as type "date/time", MS Access errors out. It does not recognize it as a date/timestamp (2015-11-05 15:10:18.738301). Any sug...

JACOBSEN_C · 2015-12-14

-

ndragisic · 2015-12-14

Greetings, I am using the new canvasDataCli and I have successfully synced my data but was wondering if someone could provide sample syntax for unpacking the files and adding headers?

s_moles · 2015-12-14

Hi there,Following the terrific advice provided by James Jones and using some tools available on the Web, I built a signature file, generated an HMAC-SHA-256 digest and had it base64 encoded. I then tried testing the access using Postman. Here's a s...

joseph_allen · 2015-12-07

How will grading periods be used in Canvas Data? For example, Current and Final grades which are available in Canvas Data, are likely aggregate grades over the duration of the term. If the term is full year and the institution is using grading peri...

rubyn · 2015-12-02

Didn't see anything similar to an e/r diagram - or anything that depicts the relationships between the tables in the documentation portal. Did I miss it?

rubyn · 2015-12-02

web_applicaiton_action isn't spelled correctly. hopefully this will save some of you some time banging your head against a wall trying to figure out why your sql isn't working...!

James · 2015-12-01

SynopsisCalls to the Canvas Data API need to be authenticated. The Canvas Data API documentation provides example code that isn't explained very well. This post will explain what's going on so that people can prepare the signature needed to use the ...

rubyn · 2015-11-24

Hi, I'm looking for a "data extract date" or "data as of date" so that we know when the data was pulled into Redshift. I didn't see a status date or table anywhere in the documentation, but maybe I missed it? We could retrieve the max(timestamp) fr...

awilliams · 2015-11-19

Still getting my feet wet here, but, I'm curious why there is sometimes more than one fact file. Here's an example:

awilliams · 2015-11-19

I have been working with one of our Analyst in Institutional Research to try and get our data into database software we can work with to start evaluating what all is there and what we can do with it. For background, we are on the free tier. With that...

Chris_Munzo · 2015-11-17

Is there a document that specifies individual data elements that are:Available in Canvas Data but not via the API; andAvailable via the API but not in Canvas Data?Maybe Deactivated user can answer?

kmeeusen · 2015-11-16

Contrary to what appears to be a common belief, not all Canvas admins are computer geeks. Most of us did not need those skills in the prior LMSs we migrated from - everything was done through the UI. Many of us, myself included, are becoming more gee...

kmeeusen · 2015-11-16

I know this is a total newby question, but when I review the BI tools to access the data files, they all seem to require Amazon Redshift Credentials, which are only available in the paid version of Canvas Data. Some of us (most of us) need informatio...

leward · 2015-11-13

Hello. We are building a report with grades for students who dropped the course. The report grades earned on any assignments before the student dropped as well as current and final scores and grades. We have discovered that the enrollment_fact tab...

millsw · 2015-11-12

Hi, I am new to the Python requests library and I am trying to figure out how to make an api call to dump the data files from Canvas. I keep getting a 404 error, so I just want to make sure I'm forming the request correctly. I looked at the API guide...

learym1 · 2015-11-12

We are looking to extract and report on Outcome data. Is there a time frame when this would be included in the data ?

willissr · 2015-11-11

We have configured an ODBC connection per the information we found elsewhere. Testing it while configuring indicates it was successful. We can use it with no problems to retrieve information into Excel. However, when trying to link to the same tab...

willissr · 2015-11-11

We have configured the ODBC connection and can connect to tables and retrieve data using Excel, but when trying to link to tables using Access we receive the message: "Reserved error (-7733); there is no message for this error." Has anyone else expe...

bmerkel · 2015-11-11

In the data portal it says "Please note that the date specified does not reflect the actual dates of the data, but instead when the data was finished exporting. The most recent data in a given export is generally 24-36 hours older than the date given...

glparker · 2015-10-29

I noticed today when working in one of my sub accounts, that I can access the Canvas Data menu item from the SubAccounts. Is there anything special about accessing the Canvas Data panel from a SubAccount? Thanks< Glen

Data and Analytics Group

Data and Analytics Documentation

Data and Analytics Group Discussions

state.json

canvasDataCli Log Creation

enrollment term dates

approaches to the governance of Canvas data

Canvas Data Requests count vs. Canvas Analytics Page Views

Is Canvas Data encrypted at rest?

Chrome Extension for "Scoring Details" of "Total" grade.

Is there a URL in the requests table for "show all details" clicks?

canvas-data-cli on linux?

How to query for quizzes submitted during a specific date range?

In the documentation describing the data dictionary for the Canvas Data warehouse I don't see the sy...

canvasDataCli unpacking & adding headers

What am I doing wrong with authetication?

How will grading periods be used in Canvas Data?

Will there be a data model diagram provided for Canvas Data?

Warning to all: Spelling error in requests table (web_applicaiton_action)

Canvas Data API Authentication

Is there a "data as of" date in Canvas Data?

Why is there more than one fact file sometimes?

Questions about getting up and running with Canvas Data

Canvas Data vs data in API?

Robust User Interface

BI Tools

Can current and final grades be added to the enrollment_fact table

Passing API Key for file dump (python)

Is there a time frame to include Outcomes into the data feed?

ODBC issue using Microsoft Access

Why could our ODBC connection work in Excel, but generate error -7733 in Access?

What is the refresh schedule for the hosted option?

SubAccount access to Canvas Data

You're signed out

Data and Analytics Group

Data and Analytics Documentation

Data and Analytics Group Discussions

Community Help

View our top guides and resources: