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

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

XMLWordPrintable

    • MOODLE_22_STABLE, MOODLE_23_STABLE
    • 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.

      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.

        There are no Sub-Tasks for this issue.

            abgreeve Adrian Greeve
            dmercer@moodlerooms.com David Mercer
            Votes:
            2 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.