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

Support roundtrip of mongoexport array notation in mongoimport

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed
    • Critical - P2
    • Resolution: Fixed
    • None
    • 100.0.0
    • mongoimport
    • None

    Description

      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?!"
          ]
      }
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: