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

Support roundtrip of mongoexport array notation in mongoimport

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Critical - P2
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 100.0.0
    • Component/s: mongoimport
    • Labels:
      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

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

                Dates

                Created:
                Updated:
                Resolved: