Uploaded image for project: 'MongoDB Database Tools'
  1. MongoDB Database Tools
  2. TOOLS-1954

Support roundtrip of mongoexport array notation in mongoimport

    • Type: Icon: New Feature New Feature
    • Resolution: Fixed
    • Priority: Icon: Critical - P2 Critical - P2
    • 100.0.0
    • Affects Version/s: None
    • Component/s: mongoimport
    • None

      Enhance mongoimport to support the csv array notation that mongoexport uses.

      Example header:

      pet.types.0.auto(),pet.types.1.auto(),answers.0.auto(),questions.0.auto(),movies.0.title.auto(),answers.1.auto(),questions.1.auto(),movies.1.title.auto(),movies.1.imdbRating.auto()
      
      

      Example records:

      dog,cat
      ,,42,How many roads must a man walk down?,Hitchhiker's Guide,Huh?!,Aren't you a little short for a stormtrooper?,Star Wars,8.7/10
      
      

      Becomes these documents once imported:

      
      /* 1 */
      {
          "pet" : {
              "types" : [ 
                  "dog", 
                  "cat"
              ]
          }
      }
      
      /* 2 */
      {
          "movies" : [ 
              {
                  "title" : "Hitchhiker's Guide"
              }, 
              {
                  "title" : "Star Wars",
                  "imdbRating" : "8.7/10"
              }
          ],
          "questions" : [ 
              "How many roads must a man walk down?", 
              "Aren't you a little short for a stormtrooper?"
          ],
          "answers" : [ 
              42,
              "Huh?!"
          ]
      }
      

            Assignee:
            tim.fogarty@mongodb.com Tim Fogarty
            Reporter:
            caleb.hankins@acxiom.com Caleb Hankins
            Votes:
            4 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: