Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-7099

The export array of objects after aggregation to CSV is separate each field of the object

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Won't Do
    • Icon: Major - P3 Major - P3
    • No version
    • 1.37.0, 1.38.0, 1.38.1, 1.38.2, 1.39.0, 1.39.1
    • None
    • None
    • OS: ubuntu 22.04
      node.js / npm versions: v14.17.1 / 6.14.13
      Additional info:
    • Not Needed
    • Up for triaging

    Description

      Problem Statement/Rationale

      When exporting data to CSV format in version 1.36.4, where an array of objects is involved, the array is recorded as a single cell with a string value. However, in subsequent versions, the array is split into individual fields for each object, occupying multiple cells in the document. This new behavior significantly reduces data readability compared to the previous version.

      Steps to Reproduce

      To replicate the issue, follow these steps:

      1. Open version 1.36.4 and 1.37.0 or the latest of the application.
      2. Export data containing an array of objects to CSV.
      3. Observe the formatting of the exported CSV file.

      Expected Results

      We expect the exported CSV file to maintain consistent formatting across versions, ensuring that arrays of objects are presented in a readable manner.

      Actual Results

      In version 1.36.4, the exported CSV file contains arrays of objects within a single cell as a string value. In later versions, the array is split into multiple cells, corresponding to the fields within each object, leading to reduced readability.

      Action Requested:

      We kindly request the Engineering team to address this issue in one of the following ways:

      1. Option to Choose Array Export: Introduce a feature that allows users to choose how arrays are exported in CSV, either as single cells or split into individual fields.
      1. Revert to Previous Behavior: Alternatively, consider reverting to the previous behavior where arrays were exported as single cells, as it provided better readability.

      Additional Notes

      Sample data for reproduce - {events: [

      {symbol: 'A', symbol: 'B'}

      ]}.

      This issue significantly impacts the usability of exported data and hampers the analysis process. We appreciate your prompt attention to this matter and any potential solutions to improve the exporting functionality while maintaining data readability.

      Attachments

        1. image-2023-08-09-15-57-49-487.png
          image-2023-08-09-15-57-49-487.png
          4 kB
        2. screenshot-1.png
          screenshot-1.png
          6 kB
        3. screenshot-3.png
          screenshot-3.png
          4 kB

        Activity

          People

            julia.oppenheim@mongodb.com Julia Oppenheim
            z.novytskyi@gmail.com Yevhen Novytskyi
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: