CSV Import Bugs

[devanshk]

Bulk importing grades has two major issues right now

1. CSV must be encoded as ASCII-8BIT and crashes for UTF-8 files

2. Fields must be wrapped in quotations to be imported properly

[TheodorJ]

This is a better description of the issues in #647, so I'll close that issue and leave this one open.

[cg2v]

The solution for this should also detect if unicode byte order markers are present and strip and/or process them. (computing services had a report today from someone whose roster would not upload because the header was misdetected because of the presence of a BOM character)

[epicseven-cup]

Hi, just want to see if this issue still exist in current autolab? I remember encountering it a few years ago though not sure if this issue is up to date.

[jhs-panda]

Hi, I just tested this by storing grades in a Google Sheet without wrapping fields in quotations and downloading it as a CSV (encoded as UTF-8). Then, I uploaded it to an assignment with "Bulk Import Grades" and it seems to work. Please let me know if you're still encountering this issue!