Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-4332

Compass doesn't export all existing fields in CSV

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 1.26.0
    • Affects Version/s: 1.21.2, 1.22.0, 1.28.1, 1.31.0
    • Component/s: Import/Export
    • None
    • Iteration Uglifruit
    • Not Needed

      The user reports that Compass is not exporting all fields even when he add the fields manually.
      I've tested it doing a comparison with mongoexport and confirm that Compass is not showing all fields as you can see in the attached screenshot.
      Exported format: CSV
      Tested bot exporting all documents and with the query option.

      Tested on:

      • Version 1.21.2
      • Version 1.22.0-beta.2

      Intercom chat

      User's cluster

      User's explanation:
      For example, let's say some of my documents have about 50 variables. Others have the same 50 variables, plus 30 more. Some website users only fill out 50 of the survey questions. Others fill out all 80. I want to export all 80 fields, but when I use the export function for the entire collection of documents the tool will only find 50 fields! This is causing me to miss a lot of data.

      If I only export the documents for the website users that filled out all 80, then the tool will find all 80. However, if the export includes any of the users who only filled out 50, then the tool will only find 50. When I add the other 30, the tool still only exports those 50 even for the users who filled out all 80. It's maddening.

      Is there a way I can override this and force it to download all my data for the entire collection?

            Assignee:
            anna.henningsen@mongodb.com Anna Henningsen
            Reporter:
            alejo.gonez@mongodb.com Alejo Goñez
            Votes:
            3 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: