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

mongoexport export fields of csv file without double quote

    • Type: Icon: Question Question
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.2.3
    • Component/s: mongoexport
    • Environment:
      mongoexport
    • 5
    • Platforms 2016-08-26
    • v2.6

      I am using command prompt export mongo collection as csv file.
      my command like that:

      mongoexport --host 192.168.1.97 --port 27017 --db dvs --collection ComparisonQuality --csv --fields _id,buildSerno,testSerno,testType,status,suiteSerno,currentCount,currentRel,averageRel,createDate,createUser --out d:/dump/comparisonQuality.csv

      this export a collection as csv file but they are not in csv file

      ObjectId(56cıbc603a661a7fd3fecd21),56cebc5937661a7fd3fecd1d,56cebc483a661a7fd3fecd1b,Comparison,S,56ceba823a661a7fd3fecd0f,1,100,100,2016-02-25T08:33:36.575Z,56cb1ccd3a661e55927054d0

      but exporterd data must be like that

      ObjectID(56ceba443a661a7fd3fecd17),"56ceba353a661a7fd3fecd12","56cc85fd3a661a7fd3fecc56","Comparison","E","56ceba323a661a7fd3fecd0f",2,0.0,50.0,2016-02-25T08:24:36.168Z,"56cb1ccd3a661e55927054d0"

      Why is it like that?

            Assignee:
            gabriel.russell@mongodb.com Gabriel Russell (Inactive)
            Reporter:
            Gonuldas Gonuldas [X]
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: