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

Compass import inserts unexplained null values and nested arrays

    • Type: Icon: Bug Bug
    • Resolution: Gone away
    • Priority: Icon: Major - P3 Major - P3
    • No version
    • Affects Version/s: 1.32.2
    • Component/s: Import/Export
    • Labels:
      None
    • Environment:
      Compass json file import tool
    • Not Needed

      Problem Statement/Rationale

      When I used the import tool to import a json file. in some fields the import automatically adds multiple nulls as values to the fields that did not exist in the original file, and adds the actual data in another nested array. 

      Please be sure to attach relevant logs with any sensitive data redacted.

      Steps to Reproduce

      It seems that this happens when the name if the field contains a number, example:

       
      "PCIDSS v3.2": ["12.1","12.1.1"],

      Expected Results

      expected document in database:
      PCIDSS v3: Array
      0: "12.1"
      1: "12.1.1"

      Actual Results

       
      PCIDSS v3: Array
      0: null
      1: null
      2: Array
          0: "12.1"
          1: "12.1.1"

      Additional Notes

      I removed the number from the field name and the nulls / nested array went away. Another example in screenshots.

        1. Screenshot 2022-10-18 at 10.34.59.png
          23 kB
          Le Roux Bodenstein
        2. Screenshot from 2022-07-06 23-35-47.png
          28 kB
          Sam Al Shami
        3. Screenshot from 2022-07-06 23-36-30.png
          36 kB
          Sam Al Shami

            Assignee:
            Unassigned Unassigned
            Reporter:
            mosabama@gmail.com Sam Al Shami
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: