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

mongoexport export fields of csv file without double quote

    XMLWordPrintable

    Details

    • Type: Question
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Works as Designed
    • Affects Version/s: 3.2.3
    • Fix Version/s: None
    • Component/s: mongoexport
    • Labels:
    • Environment:
      mongoexport
    • Backport Requested:
      v2.6
    • Sprint:
      Platforms 2016-08-26

      Description

      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?

        Attachments

          Activity

            People

            • Assignee:
              gabriel.russell Gabriel Russell
              Reporter:
              Gonuldas Gonuldas
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: