[COMPASS-3367] Import CSV does not handle quoted dates with commas Created: 28/Dec/18  Updated: 16/Aug/19  Resolved: 16/Aug/19

Status: Closed
Project: Compass
Component/s: Import/Export
Affects Version/s: 1.16.3
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Daniel Pasette (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screen Shot 2018-12-27 at 6.17.32 PM.png     File user126848_workout_history.csv.gz    
Issue Links:
Related
is related to COMPASS-2841 Export to CSV creates date strings wi... Closed
Tested
tested by COMPASS-3824 Test behavior of new feature in relat... Closed

 Description   

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.



 Comments   
Comment by Massimiliano Marcon [ 16/Aug/19 ]

We are reimplementing the import/export feature so we won't fix existing bugs. However, we will use existing bugs as a guideline for testing the new implementation.

Generated at Wed Feb 07 22:32:58 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.