About

WillGHampton
Will Hampton
Rank:
Community Participant
Title:
Canvas Administrator
Joined:
Feb 22, 2021 1:44:29 PM
Posts:
19
Solutions:
0
Likes Received:
6
Bio:
CS Bachelors, working in Higher Ed technology support for nearly a decade.

Most Liked Posts

Greetings, I'm working on a Canvas Data 2 query I'd like assistance with. The goal is to identify courses where the Canvas Gradebook is not being used. Scenarios I can envision are courses that do not...
Likes: 2
This was from a course copy, the contents of the consumer key and shared secret fields are set to "fake" and "12345" as suggested. I will contact Canvas Support directly to pinpoint the source of the ...
Likes: 2
select * from users u, pseudonyms p where u.id = p.user_id   When in doubt, slim your query down to the basics. I'd run a similar query to this basic query on both CD1 and CD2 to compare the number o...
Likes: 1
Hi alunsfor, As others have noted, you do have correct information for installing the Python library. There is a bit of complexity left out of  'install with pip' answer. Adding the library Canvasapi ...
Likes: 1
In Canvas Commons, there is a setting to 'Add Users to manage approved Content' When a Canvas user is added to this list, they are able to Share content as 'Institution Approved Content' but not 'Feat...
Likes: 1

Most Recent Posts

You may want to filter on workflow_state in the users table, as without filtering the user list will include deleted students. select * from users u, pseudonyms p where u.id = p.id and u.workflow_s...
Jun 17, 2024 10:03:05 AM
select * from users u, pseudonyms p where u.id = p.user_id   When in doubt, slim your query down to the basics. I'd run a similar query to this basic query on both CD1 and CD2 to compare the number o...
Jun 5, 2024 12:19:35 PM
New Analytics has issues with large courses. See "Why is New Analytics not loading for very large courses?' header in the New Analytics FAQ webpage. How large is this course in terms of students and a...
Jun 5, 2024 12:09:13 PM
Greetings, I'm not certain there is a way to do this with an existing report. You may want to use Canvas Data 2. My institution has a specific set of Canvas Data 2 data pulled into a local Postgres d...
Jun 5, 2024 11:55:03 AM
Hi Saustin, You mentioned that you had to do a 'more refined query' and 'wonder why we had to go that route at all' I'm having a similar problem, with pulling submissions for a date range in CD2 not m...
May 30, 2024 7:00:13 AM

Latest Badges

10 Replies Posted

10 Replies Posted

Earned: 2024-06-05

Profile Completed

Profile Completed

Be real. Be you! Earn this badge by adding your first and last name, biography, and title to your Community profile.

Earned: 2024-04-24

Instructure Community: 3 Year

Instructure Community: 3 Year

3 Years with Instructure Community

Earned: 2024-02-23

50 Logins Completed

50 Logins Completed

Earned: 2024-01-25