mongoimport does not work with escaped double quotes in csv format

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: 3.2.1
    • Component/s: mongoimport
    • None
    • Environment:
      Mac OS
    • v3.2, v3.0

      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

            Assignee:
            Gabriel Russell (Inactive)
            Reporter:
            Ray Jennings
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: