Community

Comments from Instructure As part of the new Ideas & Themes process, all ideas in Idea Conversations were reviewed by the Product Team. Any Idea that was associated with an identified theme was moved to the new Idea & Themes space. Any Idea that was not part of the move is being marked as Archived. This will preserve the history of the conversations while also letting Community members know that Instructure will not explore the request at this time. ... View more

Thanks @Stef_retired, I assumed that the 'edit' 'timeline' web interface was yours. Regards, Ian ... View more

Here's my contribution to the discussion. You would need to be able to code in Python and use the command line to make any use of this: #CanvasGrader.py #Ian Stevenson 17-02-2021 ############################################ #DESCRIPTION # This script reads in a CSV downloaded from the Canvas gradebook and uploads a grade and comment for the selected assignment that you have manually entered into the CSV file # add a 'comment' column for your text comment # # command line arguments: CSV filename, column header for assignment, course number from Canvas URL # # #REFERENCES# ############################################ #https://canvasapi.readthedocs.io/en/stable/getting-started.html #https://canvasapi.readthedocs.io/en/stable/submission-ref.html #https://canvas.instructure.com/doc/api/submissions.html#method.submissions_api.bulk_update #https://community.canvaslms.com/t5/Developers-Group/Canvas-APIs-Getting-started-the-practical-ins-and-outs-gotchas/ba-p/263685 # #/api/v1/courses/:course_id/assignments/:assignment_id/submissions/:user_id #comment[text_comment] string #Add a textual comment to the submission. # #see useful code snippets at the bottom of file ############################################ # Import the Canvas class from canvasapi import Canvas ## 'inspect' is used by canvasapi to inspect the class members import inspect, sys, csv #check command line arguments if len(sys.argv)<4: #only infile specified print ('Missing argument, usage: Python3 CanvasGrader.py infile AssignmentColumnTitle Course') exit() # Canvas API URL API_URL = "https://canvas.uts.edu.au" # Canvas API key API_KEY = "nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn" # Initialize a new Canvas object canvas = Canvas(API_URL, API_KEY) course = canvas.get_course(sys.argv[3]) #Obtained from Canvas Course URL in cmd line print('Course: ' + course.name) print() #Get user ids # users = course.get_users(enrollment_type=['student']) # for user in users: # print(user) # print("Canvas user id: "+ str(user.id)) # print("Student number: "+ str(user.sis_user_id)) #Display assignment ids print('List of Assignments') assignments = course.get_assignments() for assignment in assignments: print(assignment) print() #Confirm assignment selected to grade from cmd line print("Selected Assignment: "+ sys.argv[2]) print() #Extract assignment number from column header assArgList = sys.argv[2].split("(") assArgList = assArgList[1].split(")") assignmentNum = assArgList[0] print("Assignment ID: " + assignmentNum) #Get assignment object assignment = course.get_assignment(assignmentNum) #requires assignment ID #open csv and upload data with open(sys.argv[1]) as csvfile: reader=csv.DictReader(csvfile) #column headings = "Student", "ID", "SIS User ID", "SIS Login ID", "Section", etc... for row in reader: #get name and student number if row['ID']: submission = assignment.get_submission(row['ID']) #requires user ID grade = row[sys.argv[2]] #use column header from cmd line argument commentTxt = row['comment'] print(row['Student'] + " " + row['ID'] +': ' + grade + ', ' + commentTxt) submission.edit(submission={'posted_grade':grade}) submission.edit(comment={'text_comment':commentTxt}) ... View more

Hi @nhge , Could you please provide a link to James Ashby's 3-23-2020 post, I can't find it by searching. Thanks, Ian ... View more

I would like to be able to upload a CSV file with grades and text comments in the gradebook. This works well in Blackboard and is essential for small weekly formative tasks. The SpeedGrader is SLOW compared to simple CSV upload. ... View more