Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-54665

Offline Grading Worksheet - If the Scale field has newlines (\n), the CSV breaks in MS Excel

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.9.4, 3.1
    • Fix Version/s: None
    • Component/s: Assignment
    • Workaround:
      Hide

      Set Excel's default decimal separator to . instead of ,.

      Show
      Set Excel's default decimal separator to . instead of , .
    • Affected Branches:
      MOODLE_29_STABLE, MOODLE_31_STABLE

      Description

      If you download an Offline Grading Worksheet and the Scale field has newline \n, the CSV file, when imported, breaks, when using Microsoft Excel.

      I have only tested it on MS Excel 2013 and the problem seems to be, that the field is not parsed as a text field, even if you set is as such.

      A possible solution would be to convert the "\n" to " - " as in this similar bug: MDL-37834

      UPDATE:

      I just tried it on the demo site and it's also a problem there.

      Here is a step by step guide on how to recreate the problem.

      • Goto Site administration => Grades => Scales
      • Press the "Add a new scale" button
      • Create the following scale
      1. Name: 7 step scale (used in Denmark)
      2. Scale: -3, 00, 02, 4, 7, 10, 12
      • Create a new course and add an assignment
      • Under Submission types
      1. Check "Online text"
      • Under Feedback types
      1. Check "Offline grading worksheet"
      • Press the "Save and display" button
      • Enrol a user (just admin as a student)
      • Add submission to the assignment
      • Click the assignment and press View/grade all submissions
      • Choose the "Download grading worksheet" in the dropdown
      • Open the downloaded file

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              mcardle Ulrik McArdle
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: