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

Compass CSV import is inserting empty documents

    • Type: Icon: Bug Bug
    • Resolution: Won't Fix
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Import/Export
    • None

      Compass version 1.13.1

      Customer reported that when importing a CSV file containing 200,000 records using Compass, the resulting collection contained 200,007 documents. Local testing has confirmed that while mongoimport consistently imports exactly 200,000 documents, Compass will insert a handful of additional documents. These documents are all empty, with empty string or null values on their attributes.

      To reproduce:
      See the attached CSV file for testing.

      1. Open Compass and connect to an Atlas instance.
      2. Create a new database and collection (I used "DOB" and "permit_issuance" for this, based on the CSV used).
      3. Open the collection and click Collection->Import Data.
      4. Choose CSV option and browse to the CSV file.
      5. Initiate import.

      Once the import is complete there should be more than 200,000 documents. The empty ones can be confirmed by filtering on

      { BOROUGH: "" }

      This appears to be a bug in Compass, where it is creating additional documents for some reason.

      Please let me know if you need anything else to reproduce this behavior.

            Assignee:
            Unassigned Unassigned
            Reporter:
            jessica.sigafoos@mongodb.com Jessica Sigafoos
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: