About
JimEgan
Jim Egan
Rank:
Community Explorer
Title:
Joined:
Feb 1, 2022 12:26:53 PM
Posts:
16
Solutions:
0
Likes Received:
5
Bio:
An amazing Instructure Community member
Most Liked Posts
Adding to what Ed said above, a previous release provided a spreadsheet version of the schema. This is critical to our development effort as it brings all the columns and tables into a single documen...
If the grading standard row is no longer "assigned" then it would seem logical to me that the Context_ID column would be set to NULL. Except that it's a NOT NULL column, so it's left "hanging" there....
Enrollments are a free-for-all in our instance of Canvas. I threw up my hands/keyboard and decided that going back to the SIS for the primary instructor was the path of least resistance. We maintain...
sis_batches may be one of those tables that they include in the DDL script but is not available in the export. That table is in the latest DDL script I'm using but I explicitly don't import any of th...
I didn't try the JSON version of the SQL script. I used the PostgreSQL version. I did not load the script directly into Oracle because the two database vendors structures are different (enumerated d...
Most Recent Posts
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...
Thanks for the reply. I wanted to make sure I wasn't missing something.
If the grading standard row is no longer "assigned" then it would seem logical to me that the Context_ID column would be set to NULL. Except that it's a NOT NULL column, so it's left "hanging" there....
In the CD2 data I'm working with I have noticed that a course in the Courses table has a NULL value for the Grading_Standard_ID column. However, in the Grading_Standards table there is a row where th...
Enrollments are a free-for-all in our instance of Canvas. I threw up my hands/keyboard and decided that going back to the SIS for the primary instructor was the path of least resistance. We maintain...
Latest Badges
10 Replies Posted
2024-03-15
15 Logins Completed
2024-02-21
10 Logins Completed
2024-02-13
Instructure Community: 2 Year
2 Years with Instructure Community
2024-02-09