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

Wrong encoding, when downloading CSV grading worksheet with Hebrew text

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.1.7
    • 2.5.1, 2.7, 3.0.4
    • 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).

      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.

        1. clipboard-20130709-161959-939.png
          clipboard-20130709-161959-939.png
          108 kB
        2. clipboard-20130709-162327-932.png
          clipboard-20130709-162327-932.png
          23 kB
        3. New encoding list.jpg
          New encoding list.jpg
          14 kB

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

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.