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

Enhancements for mongoexport CSV output

    XMLWordPrintableJSON

Details

    • Icon: New Feature New Feature
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • mongoexport
    • 5
    • 1,597

    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

        Activity

          People

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

            Dates

              Created:
              Updated: