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.

            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: