Importing JSON with Arrays does not work

XMLWordPrintableJSON

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

      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
              Reporter:
              Jeffrey Cheak
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: