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

Names with accent marks corrupted in CSV export from gradebook

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.1
    • Fix Version/s: None
    • Component/s: Gradebook
    • Affected Branches:
      MOODLE_31_STABLE

      Description

      When I export the gradebook in 'plain text file' format and leave the default separator as 'comma' in the export options, accented names don't appear properly in the exported CSV sheet. For example, the name Kécia appears as Kécia and Hernán as Hernán. There's no such problem when I export the gradebook as an Excel spreadsheet.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            marina Marina Glancy added a comment - - edited

            Thanks for the report
            is it a problem with your export or the problem with the application that you use to view csv files?

            text files (such as csv) do not have any headers that advise the application about the charset

            Show
            marina Marina Glancy added a comment - - edited Thanks for the report is it a problem with your export or the problem with the application that you use to view csv files? text files (such as csv) do not have any headers that advise the application about the charset
            Hide
            ravim Ravi Murugesan added a comment - - edited

            Hi Marina, I use MS Excel as my spreadsheet application. I haven't tried opening the CSV file with any other application.

            Show
            ravim Ravi Murugesan added a comment - - edited Hi Marina, I use MS Excel as my spreadsheet application. I haven't tried opening the CSV file with any other application.
            Hide
            nadavkav Nadav Kavalerchik added a comment -

            Have you tried opening the CSV file using MS Word's "open data file", and then choosing the proper encoding?

            Show
            nadavkav Nadav Kavalerchik added a comment - Have you tried opening the CSV file using MS Word's "open data file", and then choosing the proper encoding?
            Hide
            ravim Ravi Murugesan added a comment -

            I've just tried this approach and it worked: http://stackoverflow.com/a/28179977

            Show
            ravim Ravi Murugesan added a comment - I've just tried this approach and it worked: http://stackoverflow.com/a/28179977
            Hide
            nadavkav Nadav Kavalerchik added a comment -

            Please have a look at "How to import CSV to Excel" as can be seen on this page:
            https://www.ablebits.com/office-addins-blog/2014/05/01/convert-csv-excel/#convert-csv-2-excel

            Show
            nadavkav Nadav Kavalerchik added a comment - Please have a look at "How to import CSV to Excel" as can be seen on this page: https://www.ablebits.com/office-addins-blog/2014/05/01/convert-csv-excel/#convert-csv-2-excel

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: