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

Enhancements for mongoexport CSV output

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Accepted
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: mongoexport
    • Labels:

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                backlog-server-tools Backlog - Server Tools Team
                Reporter:
                nomadjourney Nizam Sayeed
              • Votes:
                9 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated: