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

Wrong encoding, when downloading CSV grading worksheet with Hebrew text

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.5.1, 2.7, 3.0.4
    • 3.1.7
    • Assignment
    • MOODLE_25_STABLE, MOODLE_27_STABLE, MOODLE_30_STABLE
    • MOODLE_31_STABLE
    • 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.
    • 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).

    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
          • Closed

          Activity

            People

              Votes:
              17 Vote for this issue
              Watchers:
              18 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10/Jul/17