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

Wrong encoding, when downloading CSV grading worksheet with Hebrew text

          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.

              Gliffy Diagrams

                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

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

                        Dates

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