• Putting Data from the Requests Table into locally hosted databases

    Hi All   We are currently trying to process the data requests table (From Canvas Data) into a database that we can use and as you can imagine are having a fair amount of trouble with the sheer amount of dat...
    Luke Dellar
    last modified by Luke Dellar
  • What are people using to access the data from Canvas Data Portal?

    Hi all,   I have just gain access to the Canvas Data portal last week and have been exploring it. From what I can tell so far, it is a tab delimited file stored inside a gz file.    Excel can to a cer...
    Stefanie Sanders
    created by Stefanie Sanders
  • Canvas Data Page Views

    We're looking at some metrics of user activity, one of which is page views. The wiki_page_fact table has a measure called 'view_count'. I assume this is the number of times a page has been viewed but the numbers I'm p...
    Audra Agnelly
    last modified by Audra Agnelly
  • Tables to Recreate Catalog Analytics Dash?

    Hi - I'm just getting started trying to build out some dashboards with Canvas data for the first time. I've started digging into the schema documentation and I've got us set up with the Canvas Data CLI and am suc...
    Jamie Studwell
    last modified by Jamie Studwell
  • Canvas Data - Due dates are not showing

    Hi Canvas Team,   Using canvas CLI I'm getting data from canvas and created reports using PowerBI. Everything works fine but if assign any assignment to specific students that assignments are not showing due dat...
    Stefanie Sanders
    created by Stefanie Sanders
  • Deobfuscate user_dim.id?

    Canvas Data portal question: how do I link from somewhere (say Quiz_submission_fact.user_id) to a user? the "id" field in the user_dim table (downloaded) is described as "obfuscated" and does not match format of user_...
    Stefanie Sanders
    created by Stefanie Sanders
  • Is assignment data updated across the import tool or tracked when using external tools?

    Hi, there data geniuses,      We have two questions that you can hopefully assist our team with:   When using the course import tool, when assignments are imported into the new course shell, are t...
    Jayde Colquhoun
    last modified by Jayde Colquhoun
  • Cannot find learning_outcome_question_result_fact

    Does anyone know why the table learning_outcome_question_result_fact may be blank in the database? I can pull up the info from Settings/Reports/Outcome Results but my database seems to be missing the data fr...
    Stefanie Sanders
    created by Stefanie Sanders
  • Using Canvas Data CSVs to generate rudimentary stats?

    Hi all,   Due to the Covid-19 outbreak, our university is now fully online.  We have usage data from the Admin>Analytics section to get page views and participations, which gives some high level dat...
    Stefanie Sanders
    created by Stefanie Sanders
  • SQL query that shows all student page views in a sub-account

    I'm fairly new to Canvas Data and SQL. Our IT department recently created an SQL Server for Canvas Data and I'm now able to run queries.  I tried to create a query to display terms, the sub-account, course n...
    Glenn Saito
    last modified by Glenn Saito
  • Is there an active Early Warning System project in the Canvas community written in Java?

    Is anyone aware of an Early Warning system for assessing student engagement in courses that is written in Java?  Preferably not a commercial product.  
    Gary Sharpe
    last modified by Gary Sharpe
  • How to store canvas data directly in sharepoint or azure database

    Hi Canvas Team,   I'm planning to do power bi reports using canvas data. Using Canvas Data CLI tool data is storing in local pc, is there any way to store data in SharePoint or azure database directly.   mo...
    Stefanie Sanders
    created by Stefanie Sanders
  • Canvas data dumps: full history or delta?

    Hi,   I'm using the canvas-data-sdk package to download Canvas data via its API in Python.  I've been using the following commands:   ``` canvas-data -c config.yml list-dumps # lists the daily dumps ...
    Stefanie Sanders
    created by Stefanie Sanders
  • Is the use of a specific developer key recorded in Canvas Data anywhere? If yes, what information is recorded and how to get it?

    Developer Key is generated when integrating a third party product into canvas environment.
  • Column Headers on Canvas Data Downloads via UI?

    I recently got access to our Canvas Data Portal.  I went to do some quick ad hoc analysis in preparation for a project using Jupyter Notebook and noticed that there are no column headers on the files I downloaded...
    Gary Sharpe
    last modified by Gary Sharpe
  • Java API for creating custom ad-hoc reports

    I would like to retrieve data from Canvas at an individual assignment level to create custom reports analyzing quiz/test questions controlling for class rank, major, final class grade...etc.   1. Is there a Java...
  • Identifying Turnitin Use (both Legacy and LTI) in Canvas Data

    Hi All,   Has anyone dug in to Assignments to determine if a particular assignment was configured to use either Legacy Turnitin or the newer LTI/external_tool based Turnitin?   I've got some assignment...
    Glen Parker
    last modified by Glen Parker
  • is canvas cli the best way to export the data from canvas ?

  • Linking Learning Outcome Rubric Criterion to Learning Outcome Result

    Hello all   I'm trying to setup a relationship between the learning_outcome_rubric_criterion and the learning_outcome_result facts and dims in Canvas Data and i wondered if anybody else knows how to reliably? &#...
    Luke Dellar
    created by Luke Dellar
  • Anybody having issues with Hit Scoped Custom Dimensions in Google Analytics

    Hi All   I'm using google analytics to track pages through the custom javascript file embedded into the theme.   The hit scoped custom dimensions i'm using have suddenly decided to not show on the reportin...
    Luke Dellar
    last modified by Luke Dellar