Uploaded image for project: 'Camunda Optimize'
  1. Camunda Optimize
  2. OPT-3640

CSV Exports use ' as escape character instead of "

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Done
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: 2.7.0, 3.0.0
    • Fix Version/s: 3.1.0-alpha2, 3.1.0
    • Component/s: backend
    • Labels:
      None

      Description

      Given:
      I have a process variable of type string that contains double quotes, e.g.

      [{"id":null,"ssn":null,"birthDate":null,"birthPlace":null}]
      

      And a raw data report that contains these values.

      When:
      I export the report as CSV

      Then:
      The column content for that variable is

      "[{'"id'":null,'"ssn'":null,'"birthDate'":null,'"birthPlace'":null}]"
      

      and contains additional single quotes in front of each contained double quote.

      Expected:
      In Optimize versions <=2.7.0 there was a another double-quote in front of each conatined double-quote. e.g.

      "[{""id"":null,""ssn"":null,""birthDate"":null,""birthPlace"":null}]"
      

      which is a commonly accepted approach to escape the default quote character used to delimitate a quoted element.

        mgm-controller-panel

        This is the controller panel for Smart Panels app

          Attachments

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              sebastian.bathke Sebastian Bathke
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Salesforce