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

mongoimport handling of quotes

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: mongoimport
    • Labels:
      None

      Given this file z4:

      name
paul "buzz" moschetti

      Then this:

      Buzzs-MacBook-Pro-2:guycarp buzz$ /usr/local/bin/mongodb-osx-x86_64-3.2.0-rc2/bin/mongoimport -d foo -c bar --drop --headerline --type csv z4

      produces this error:

      2016-08-03T14:33:08.845-0400	connected to: localhost
2016-08-03T14:33:08.845-0400	dropping: foo.bar
2016-08-03T14:33:08.845-0400	Failed: read error on entry #1: line 2, column 5: bare " in non-quoted-field
2016-08-03T14:33:08.845-0400	imported 0 documents

      In a CSV, it is perfectly legal to have paired quotes, no?

            Assignee:
            gabriel.russell@mongodb.com Gabriel Russell (Inactive)
            Reporter:
            buzz.moschetti Buzz Moschetti
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: