Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-1097

mongoimport / export should adhere to CSV spec

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor - P4
    • Resolution: Fixed
    • None
    • 1.9.2
    • Tools
    • None
    • Major Change

    Description

      Right now we use JSON escaping rules for strings rather than CSV rules.

      Proposal: Strings (and equivalent types like symbol) and numbers get printed directly in CSV format. Other types like objects or arrays get converted to JSON then run through the CSV escaper so they will be valid JSON strings after an import.

      Questions:
      Should Code be a String equivalent or JSON?
      Should OID's be emited as regular hex strings or csv escaped ObjectID("abcde"). The later preserves the distinction between strings and OIDs, but it will make a terrible key if trying to share data with another DB.

      Attachments

        Issue Links

          is depended on by

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-2357 mongoimport should ignore trailing commas in CSV files

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-3180 CSV/TSV import split data on line breaker

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-3936 Weird problem with mongoimport

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. TOOLS-62 mongoimport doesn't support multiline string fields

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-2379 mongoimport + csv with commas in values: extraneous data

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-2634 mongoimport fails to import CSV when field value is a full stop "."

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              sridhar Sridhar Nanjundeswaran
              mathias@mongodb.com Mathias Stearn
              Votes:
              3 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: