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

Japanese/Chinese characters do not export to Excel correctly

XMLWordPrintable

    • MOODLE_23_STABLE

      Files exported from Moodle in .csv format to do not handle UTF8 characters properly. Do this:

      1) Create a new database activity.
      2) Create two fields, "name" and "address"
      3) Copy and paste the following data into two successive records:
      name: 佐藤 宏 address: 〒603　京都市北区上賀茂本山999
      name: 黒田 泰史 address: 〒603　京都市北区上賀茂本山123
      4) Export the data as .csv (I used the tab delimiter)
      5) View the resulting spreadsheet

      This appears to be a problem not only with the database component, but rather with excel export from any Moodle module. See the attached composite screenshot.

        1. CharacterCorruptionOnExport.jpg
          CharacterCorruptionOnExport.jpg
          45 kB
        2. ExcelExportProblems-Japanese.jpg
          ExcelExportProblems-Japanese.jpg
          504 kB

            abgreeve Adrian Greeve
            trobb Thomas Robb
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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