CSV/TSV import split data on line breaker

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: 1.8.0
    • Component/s: Tools
    • Environment:
      window xp
    • Windows
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      when import data that contains long descritpion text, mongo import tool snap a single CSV cell and treat it as multiple line

      Sample Data

      TITLE , DESCRIPTION
      title 1 , " this is sample description, line break start here
      description continue on new line
      end of description here. "

      Excel will disaply above csv file correctly, however, because description contains line break, mongodb import tool will treat it as 3 csv records instead of a single cell.

      I think this is a bug and hope the fix can go into the latest release.

      Please also advise if here is any work around to allow successfully import the csv content and stop the record being truncated by line breaker.

      Regards,
      Charles

            Assignee:
            Mathias Stearn
            Reporter:
            Charles Ke Qiao
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: