Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-41473

Zip with exported grades should have utf8 encoding

    XMLWordPrintable

    Details

    • Test Plan:
      Hide

      This JIRA needs a non-utf8 Windows for testing. For example, an spanish Windows.

      -Create an assignment in a site with users whose names include non-ascii characters (ñ, á, é...). The name of the assignment can also be used to test this. Send some submissions.

      -Go to Assignments /View Submissions and click on Download All

      -Select "All" checkbox and Excel format radio button.

      -Download the zip file, open it as a Windows compressed folder and open the excel file inside. Non-ascii characters should be correctly displayed.

       

      Show
      This JIRA needs a non-utf8 Windows for testing. For example, an spanish Windows. -Create an assignment in a site with users whose names include non-ascii characters (ñ, á, é...). The name of the assignment can also be used to test this. Send some submissions. -Go to Assignments /View Submissions and click on Download All -Select "All" checkbox and Excel format radio button. -Download the zip file, open it as a Windows compressed folder and open the excel file inside. Non-ascii characters should be correctly displayed.  

      Description

      We have found that grades exported from Assignments in excel/csv inside a zip are not properly displayed in a Windows with spanish language.

      Spanish Windows opens them with "Windows-1250/WinLatin 2" encoding, and non-ascii characters are wrongly displayed.

      Browsing in Excel 2016 options, opening the excel as a text file with utf8 encoding manages to open it correctly, but is a pretty hidden option and it's tedious for a casual user.

      Excel and csv files have utf8 encoding, and the excel export option in "Grade Report" tab works nicely, but "Download All" option in Submissions page packages the excel inside a zip and it seems that excel file somehow inherits the zip file encoding.

      A simple encoding added to the content-type header of the zip file fixes the issue.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                daniel.merino Daniel Merino Echeverría
                Reporter:
                daniel.merino Daniel Merino Echeverría
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code