Using Canvas import rubric

Setting up a rubric using the import rubric template csv file, content looks like it conforms to the requirements, but when I upload the file no rubric appears.

Is there any way to see that has gone wrong during the import, trying to see if I have stuffed up the format of the import csv file.

Thanks

Ian

Find more posts tagged with

Admin

Accepted answers

All comments

ian10

OK after a bit of cut & pasting, I think I have found the answer.

The import process does not appear to like certain punctuation in the text, e.g. commas, quotes or brackets.

Wonder why Ummmm

James

@ian10

It's likely an error in the CSV file. Are you manually generating it or doing a File > Save As and changing the type to CSV. In Excel, the type is CSV UTF-8 (Comma delimited) (*.csv). There is also a CSV without the UTF-8 that can be used if you don't have any utf-8 characters (things outside the normal letters, numbers, and basic symbols) like emojis or some international characters.

If you're manually generating the file, here are some basics.

Commas are used to separate fields (spreadsheet cells) and each row in the spreadsheet is a row in the CSV file.
Wrapping each cell in double quote marks " is optional and typically not done. There are three exceptions -- see next item.
If you have a comma, double quote, or line terminator within a field, then you need to wrap the cell with double quotation marks ".
If you have quotation marks " within your cells, then you need to escape them by double quoting them and putting a quotation mark at the beginning and end of the cell.

For example, if you had the text: This is "awesome", then you would need "This is ""awesome""". The triple " at the end is the double "" for the " that is part of the text and then another " to end the quoted cell.

If you save your rubric as a CSV file from a spreadsheet, it should take of all that for you.

There is a potential issue with UTF-8 encoding depending on your locale. There are several export/import related feature options under your (personal) Account > Settings in Canvas.

Unanswered Questions

Verifying email in Ways to Contact does not work
We have a teacher who is not receiving email messages in Canvas because she has not previously verified her email address in Ways to Contact. We have had her verify her email address several times, but no confirmations appear in her email, neither in her inbox, nor in her spam filter. We know that she has a working email,…
Partial Credit in Alternative Format Questions
Looking for the addition of partial credit for alternative format questions in Canvas, like ordering and category/matrix. We can only do it in close drop down, matching, and multiple response.
Course Analytics not currently reporting all data ?
Has anyone found gaps in their course analytics ? I'm currently seeing missing last view date, last participation date, and participations at overall course level, even though the same data is present at individual week and student level. Am also seeing truncated asset counts ie we are seeing only the global header counts,…
Allow Observers to View Instructor Comments
It would be very beneficial for observers (parents) if they could view instructor comments. If they had access to this information, they could better understand the grading of individual assignments and better understand the errors that their student made.
Canvas integration with React + Flask webapp - initially for authenticaiton
I have a new React + Flask webapp. It has its own login for users to start using the app. I have added this as an external tool in Canvas. What I want initially is to see of canvas users can start using the webapp without having to login if they click on the external tool link in a canvas course. I have 2 methods…