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

Wrong encoding, when downloading CSV grading worksheet with Hebrew text

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.5.1, 2.7, 3.0.4
    • Fix Version/s: 3.1.7
    • Component/s: Assignment
    • Labels:
    • Testing Instructions:
      Hide
      1. Set language to any non-English language (Hebrew/French...)
      2. Navigate into an Online Assignment submissions page (Which holds submissions from several students And also make sure you enabled "Feedback Offline grading worksheet" on the assignment's settings)
      3. From the "Grading action" listbox, select "Download grading worksheet"
      4. Open the downloaded CSV file by clicking it. (Make sure MS Excel is used)
      5. Make sure it is readable in your local language - you might need to adjust the "list separator" in window's regional settings (it defaults to ";" in French).
      Show
      Set language to any non-English language (Hebrew/French...) Navigate into an Online Assignment submissions page (Which holds submissions from several students And also make sure you enabled "Feedback Offline grading worksheet" on the assignment's settings) From the "Grading action" listbox, select "Download grading worksheet" Open the downloaded CSV file by clicking it. (Make sure MS Excel is used) Make sure it is readable in your local language - you might need to adjust the "list separator" in window's regional settings (it defaults to ";" in French).
    • Workaround:
      Hide
      1. Open Excel, first.
      2. Choose Data > Import > Select the CSV file > select UTF-8 encoding.
      3. File should open successfully in any Excel version.
      4. Update the grades and feedback.
      5. Save it as CSV with UTF-8 encoding.
      6. Upload it back to Moodle.
      Show
      Open Excel, first. Choose Data > Import > Select the CSV file > select UTF-8 encoding. File should open successfully in any Excel version. Update the grades and feedback. Save it as CSV with UTF-8 encoding. Upload it back to Moodle.
    • Affected Branches:
      MOODLE_25_STABLE, MOODLE_27_STABLE, MOODLE_30_STABLE
    • Fixed Branches:
      MOODLE_31_STABLE
    • Pull from Repository:
    • Pull Master Branch:
    • Pull Master Diff URL:

      Description

      Wrong encoding, when downloading
      CSV grading worksheet with Hebrew text

      MS Excel open the UNICODE (UTF-8) CSV file as displayed on the second screen shoot

      Note that:
      Hebrew MS Windows expects WINDOWS-1255 encoding for CSV files if we wish to open them correctly.

      Also, that exporting grader report grades to Excel (XLSX) works fine.

        Attachments

          Issue Links

          will be (partly) resolved by

          Functional Test - A test of a single Moodle feature MDLQA-10179 CLONE - A teacher can download, edit and upload an offline grading worksheet

          • Trivial - Cosmetic problem like misspelt words or misaligned text
          • Passed
          will help resolve

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-54665 Offline Grading Worksheet - If the Scale field has newlines (\n), the CSV breaks in MS Excel

          • Minor - Minor loss of function where workaround is possible
          • Open

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              mikidream miki Alliel
              Peer reviewer:
              Frédéric Massart
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              17 Vote for this issue
              Watchers:
              18 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Jul/17