Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-30078

Fix compatibility of CSV export with fields including carriage return characters

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.10
    • Fix Version/s: 10.10-HF42, 11.x, 2021.2
    • Component/s: CSV
    • Release Notes Summary:
      Carriage return characters are escaped in the CSV export.
    • Backlog priority:
      750
    • Team:
      PLATFORM
    • Sprint:
      nxplatform #27, nxplatform #28
    • Story Points:
      3

      Description

      When a document has a field which includes a carriage return character (e.g. dc:description can have a multi-line description), then the export CSV file is invalid.
      Namely, some lines are truncated and their truncated part is elsewhere in the file but not at the following line

      E.g.
      Expected format:
      [...]"my multi-
      line comment
      is a valid one"[...]
      which includes the field within double quotes as a common convention: https://stackoverflow.com/questions/566052/can-you-encode-cr-lf-in-into-csv-files

      Actual generated forrmat of the CSV file
      [...]"my multi-[...]
      [...]
      is a valid one"[...]
      line comment[...]

      Consequence: Excel cannot import successfullly the CSV export file

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: