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

Support headerless .csv imports

    • Type: Icon: Investigation Investigation
    • Resolution: Won't Do
    • Priority: Icon: Major - P3 Major - P3
    • No version
    • Affects Version/s: None
    • Component/s: Import/Export
    • None

      From COMPASS-4163

      You can see this problem manifest immediately via the preview table:

      And while we are able to insert all 4+Gb the resulting collection is not usable unless we create a view or use aggregation pipeline to $project the correct field names. (see this comment for detailed working example: https://jira.mongodb.org/browse/COMPASS-4163?focusedCommentId=2954991&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-2954991)

      A smaller sample of the dataset: (12Mb) part 1 of the yearly data as a CSV file (part 1) (CSV, 12.6MB)

      We can control supplying headers/field names for the parser. If we add a checkbox like "[x] Includes Headers" we could name the fields like field_1, field_2 etc. automatically. Field names could also be renamable via the preview header rows.

            Assignee:
            Unassigned Unassigned
            Reporter:
            lucas.hrabovsky Lucas Hrabovsky (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: