-
Bug
-
Resolution: Fixed
-
Minor
-
3.1
-
None
-
MOODLE_31_STABLE
-
MOODLE_31_STABLE
-
wip-
MDL-54061-master -
In current 3.1dev, saving an Offline Grading Worksheet from an assignment will download a csv file as expected. Opening this file in Excel, adding grades, and directly saving (via the save option/icon rather than 'save as') will result in the file keeping its csv extension but replacing all the commas with tabs (evident by opening in any text editor after saving).
csv file without any commas then throws error if user tries to upload the grading worksheet.
The same results in current builds of 3.0 or earlier are unaffected, so new to 3.1
Occurs across any Excel versions tried.
1. Create an assignment (with 'offline grading worksheet' enabled)
2. Download grading worksheet from top dropdown
3. Confirm it has the .csv file extension
4. Open file in Excel. Provide a grade in the Grade column.
5. Click the Save icon in top left.
6. Check file in notepad - in 3.1dev, should have become tab separated, despite csv extension
7. Download another grading worksheet
8. Open file in Excel. Provide grade.
9. From the menu, select Save As, pick 'csv'
10. Check file in notepad, should be comma separated
11. Repeat steps 1-6 in earlier Moodle versions, should retain commas as expected
- blocks
-
MDLQA-9623 CLONE - A teacher can override updated Moodle grades when uploading an offline grading worksheet
- Passed
- has a non-specific relationship to
-
MDL-54626 CSV files that have been exported out of Moodle should be able to be imported into Moodle without changing options.
- Closed
- has been marked as being related by
-
MDL-57668 Fix warnings when uploading Offline Grading Worksheet csv
- Closed
- will help resolve
-
MDL-37884 When importing assignment grades (offline marking), allow the user to specify the separator and encoding.
- Closed