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

Importing JSON with Arrays does not work

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • No version
    • Affects Version/s: 1.26.1
    • Component/s: Compass, Import/Export
    • None
    • Not Needed

      Problem Description

      As a user, I can NOT upload JSON files with nested arrays that are of different types.  

       This seems to be a repeat issue from here:

      https://github.com/mongo-express/mongo-express/issues/433

       

      I CAN import the same file correctly via the command line.

      Steps to Reproduce

      1) Take sample JSON attached...try to import via Compass

       

      Expected Results

      1) File imports successfully.

      Actual Results

      1) Error on import.

       

      Found work around on unix command shell:

      mongoimport --uri mongodb+srv://{MYUSERNAME:MYSECRETPASSWORD}@cluster0.g8fm0.mongodb.net/foo --collection bar --type json --file Conformer3D_CID_2244.json 

       

       

       

       

      Additional Notes

        1. 7237E5BE-9F80-4CD4-8BA5-5E32165308C7.jpeg
          158 kB
          Jeffrey Cheak
        2. Conformer3D_CID_2244.json
          12 kB
          Jeffrey Cheak
        3. E7EF68BC-82BC-459C-9486-EA25E9EF07C8.jpeg
          76 kB
          Jeffrey Cheak

            Assignee:
            Unassigned Unassigned
            Reporter:
            jeffrey.cheak@mongodb.com Jeffrey Cheak
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: