We've started having some real problems with importing Grades CSVs back into the Grades screen when they've been updated/saved using MS Excel (i.e. the file is not recognised).
It seems that by clicking save, the encoding of the CSV file changes from UTF-8 to ANSI. Having spent over an hour reading around this (and getting a headache), it's time to ask the admins!
Any advice or sharing of similar pains would be greatly appreciated
Thanks Brian! So at your institution, your teachers are able to use excel for updating the Grades csv and import back without any special steps required?
Hey @a_craik ,
None of them are currently using that at my institution, but we have gone through the steps in out Test environment so if an Instructor does have a need to do it that we would have at least tried it out and gone through the motion.
There were no special steps required that I can remember from when we tested it.
I did fine this thread on the community that I think may help you. #https://community.canvaslms.com/thread/15960-problem-importing-grades
Thanks again Brian - the (current) last comment from Canvas Support in that post is insightful, particularly this:
"This is behavior we've been seeing since the most recent update to Microsoft Office"
I would imagine that most institutions are using MS Office, and I think we've all got better at keeping up to date with new versions/releases (because it's got easier), so I was surprised that this wasn't already a hot topic in the community. It makes me wonder if 1. It's not been a global update rolled out to all Office versions, or 2. maybe the CSV Grade import function isn't widely used? I have also posted in Technet.microsoft.com, so maybe there'll be some clarification re no.1 there...
Thanks Daniel - we've tested the MS-DOS CSV format and that does indeed seem to work! We're nearly in a position now where we can advise all staff on a revised approach to saving and importing Grades CSVs
I'll post another update separately as I have responses from both Canvas and Microsoft that may be of value to the community
Ok, so it turns out MS-DOS CSVs will only work providing none of your students have any special characters in their names, so for us an "often... but not always" fix :smileycry:. Here's a round up of things as-is from the different stakeholders:
Microsoft (online here😞
I find if you want to save CSV as UTF-8 encoding your Office build version must equal to or later than 16.0.7466.2023.
Canvas Support (email quoted):
This behavior has been reported and escalated to our Engineering team. They are currently researching this behavior. The post from the Community is indeed a Canvas Support response [the last one from problem importing grades], and the information in the response is valid - this behavior started to occur after the update mentioned. The workarounds mentioned are also the current best options at this time.
I have attached this case to the tracker associated with the Engineering ticket, as that tracker is updated this case will be updated and an email will be sent to notify you.
Me (sharing update with colleagues):
So to recap on where we are now in this messy CSV business:
Exporting a Grades file, opening in Excel, and…
WILL RESULT IN:
1. Clicking “Save”
Special characters remain intact, Field separations are broken (all fields compacted into one)
2. Choosing “Save As” > “CSV MS-DOS”
Special characters broken, Field separations are intact
3. Choosing “Save As” > “CSV UTF-8” (only available in recent build of Excel)
Both intact – this will upload back into Canvas successfully
Will update again with more as it comes in - Happy Friday everyone!
I primarily use a Mac and Excel updated this morning. Now, I can Save As UTF-8 CSV and it works. Last week, that option still resulted in errors. I, however, can't seem to get Excel for Windows to update to a version that has this option. I seem to be stuck at 16.0.4639.1000.