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

Enhancements for mongoexport CSV output

    • Type: Icon: New Feature New Feature
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: mongoexport
    • Labels:
    • 5
    • 1,669

      The mongoexport tool's CSV output feature is great but it generates data that is hard for external tools (e.g., Excel, etc.) to parse. The following enhancements to CSV output would make mongoexport an extremely powerful data export tool:

      1. Allow string formatting of date fields by allowing a date format parameter to be passed in. The current

      { $date: <number> }

      format is not understood by external tools like Excel.

      2. Allow list fields to be formatted to a string using a specific delimiter. E.g, a pipe character delimiter would convert the following values:

      [ 1, 2, 3 ]

      To:

      "1|2|3"

      The converted list field's data would be wrapped in double quotes to make parsing easy.

            Assignee:
            Unassigned Unassigned
            Reporter:
            nomadjourney Nizam Sayeed
            Votes:
            12 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated: