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

mongoimport does not work with escaped double quotes in csv format

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • 3.2.1
    • mongoimport
    • None
    • Mac OS
    • v3.2, v3.0

    Description

      The following line will fail when it has the escaped double quote: \"

      "1901","2007-01-24 16:08:52","2015-12-23 06:46:01","6343","waterfall woven wood shade","Waterfall Woven Wood Shade","Material falls from the front of the headrail, creating an elegant waterfall effect. Stacks neatly when raised. Extremely functional.<br>Ships free in 10 days or less! <a href=\"#\"data-modal=\"faq-modal\"><u>View Details</u></a>","1696","1901_l.jpeg","WOLD","natural-waterfall-woven-wood-shades","1","W","1","7500","0","0","","0","20","75/20","0","12","0","0","120","12","120","12","120","30.00","54.00","0","7.22","","6.83","WOLD","0","1"

      2016-01-29T13:31:11.126-0500 Failed: read error on entry #4: line 9, column 295: extraneous " in field
      2016-01-29T13:31:11.126-0500 imported 0 documents

      Attachments

        Activity

          People

            gabriel.russell@mongodb.com Gabriel Russell (Inactive)
            raymondjii Ray Jennings
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: