[ARCHIVED] data won't import to gradebook

[embleton]

Instructor reported issue to be that I was able to verify. Canvas won't upload her large course (800 students) gradebook - won't even recognize changes in CSV file -  even when limit import rows to just 10 students! I am able to make it work in a different course, which happens to be an ORG account, not a credit course account.

Instructor called support and after 45 minutes the support person simply said "don't know"... not a very satisfactory answer.

Anyone else seeing gradebook import issues that seem unexplainable? Suggestions?

Our process:   export the gradebook, leave all 'record" columns and remove unneeded Assignment columns, remove all subtotal and total columns. Enter new data. save as CSV, Import. Doesn't recognize changes in csv file, says "nothing to import". Tried changing grade column name in CSV and re-importing. Same error - which is clearly wrong.

Baffled.

[Chris_Hofer]

Hello there,  @embleton ...

I am reviewing some of the older questions here in the Community, and I came across your question.  I wanted to check in with you because I noticed that we have not heard back from you since you first posted your question on September 5, 2019.  It seems as though you may have stumped the Community with your question.  Have you been able to find any workable solutions on your own since you posted your question back in September that you'd be willing to share with us here in this topic?  If so, please let us know by posting a note below.  However, if you are still looking for some help with this question, please let us know that as well.  Either way, we would like to hear back from you.  For the time being, I am going to mark your question as "Assumed Answered"...not because we've been able to help find a solution for you...but more because we've not heard back from you in over five months and because there hasn't been any new activity in this topic for the same amount of time.  However, that won't prevent you or others from posting additional questions and/or comments below that are related to this topic.  I hope that's okay with you, Karla.  Looking forward to hearing back from you soon.

[profcase]

This problem just cropped up for me as well. I exported the gradebook as a CSV. I deleted all of the columns that I wanted to leave alone but retained all of the student data (name, section, etc). I added the grades for the assignment that needed grading (the assignment already existed in Canvas so I didn't have to create a new column). I saved it as a new .csv file. When I uploaded it to Canvas gradebook I got the same message as the OP. 

Upload Gradebook: SCI 201 SYN1 2020 FALL REG

There were no changes detected in the gradebook you uploaded.

[rboerner]

I've just encountered the same problem. I created a no submission assignment to hold a final grade for a test that is computed as a sum of multiple components. The column in the grade center is empty. I exported the grade center into a Libre Calc, computed the grades for that column, saved as .csv and imported into Canvas grade center. The response every time:

There were no changes detected in the gradebook you uploaded.

I tried erasing all the other columns, no difference. I double and triple-checked that I had actually saved the csv file. I even tried exporting again, and copying the column I had computed into this otherwise untouched, fresh sheet, and saved. Again the same result.

I've done this same thing many times in other courses, I've never had this problem before.

[cdrawn]

YES! What @rboerner described just happened to me too! It even read a different column in the same file I was trying to upload -- simply won't recognize that particular "assignment". I'm going to try deleting that "assignment" and making a new one. SO frustrating. (in case relevant: fewer than 200 students.)

[rboerner · Accepted solution]

The solution that was eventually discovered by tech support at my institution: the bug was triggered by the column name containing the word "final". We eliminated that from the name, and the problem disappeared.

[AngelaBeasley1]

Ok, wow, just wow. This was exactly my issue - removing the word "Final" from the title fixed it. Thank you for posting this here and saving me from manually entering in 200 grades! 

[cdrawn]

Thank you so much for sharing that insight!! I wish I could get those hours back, but yet another absurd lesson learned.

[dkrasne]

Thank you so much, and whatever wonderful genius at your tech support figured this out. I can't BELIEVE that over a year later, Canvas still hasn't fixed this. (Wait, who am I kidding? Of course I can believe it, because it's Canvas. Ugh.)

[acctgprof13]

Same issue for me. I was posting final grades (as in their letter grade), and it didn't work with the title "Final Grade" (I had to change it to "Letter Grade"). This is something Canvas should fix since "Final" exams are a fairly common thing...

[jon_mason]

I've just had this same issue, i.e. "There were no changes detected in the gradebook you uploaded." when there clearly were new grades in the import file, but for a different reason. 

Turns out that it was because the assignment wasn't assigned to anyone. It was an assignment that was only used for delivery offline grades back to students, so that wouldn't have mattered up until the point of importing. Not sure how it became unassigned as the default for a new assignment is for it to be assigned to Everyone, but assigning it to Everyone then meant the import worked. 

[RoshiniR]

I had the same issue, and followed rboerner's suggestion about removing "final" from the column and it worked! Thank you.

[mikeg]

I wish I could bill Canvas for all the hours I waste with the POS software.  What a joke.