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

Import CSV does not handle quoted dates with commas

XMLWordPrintableJSON

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

      I used the import csv functionality and it seems to trip up on the quoted fields with commas.  Using plain old mongoimport as below handles the file fine.

      mongoimport -d workouts -c workouts4 --type='csv' --headerline --file user126848_workout_history.csv

      I've attached a screenshot and the sample data.

        1. Screen Shot 2018-12-27 at 6.17.32 PM.png
          282 kB
          Daniel Pasette
        2. user126848_workout_history.csv.gz
          40 kB
          Daniel Pasette

            Assignee:
            Unassigned Unassigned
            Reporter:
            dan@mongodb.com Daniel Pasette (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: