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

META: RFC-4180 CSV file compliance for greater portablility of exported data.

    Details

    • Workaround:
      Hide

      The workaround to this is to use ODS (OpenOffice) format when opening in Excel. The data for text and textarea is preserved in a sinbl cell.

      Show
      The workaround to this is to use ODS (OpenOffice) format when opening in Excel. The data for text and textarea is preserved in a sinbl cell.
    • Affected Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE

      Description

      Old title: Database Activity Export for CSV and Excel does not wrap text or textarea fields in quotes

      RFC 4180 is an effort to formalize CSV. It defines the MIME type "text/csv", and CSV files that follow its rules should be very widely portable. Among its requirements:

      • DOS-style lines that end with (CRLF) characters
      • An optional header record (there is no sure way to detect whether it is present, so care is required when importing).
      • Each record "should" contain the same number of comma-separated fields.
      • Any field may be quoted (with double quotes).
      • Fields containing a line-break, double-quote, and/or commas should be quoted. (If they are not, the file will likely be impossible to process correctly, so this should is better taken as must).
      • A (double) quote character in a field must be represented by two double quote characters.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  2 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: