[COMPASS-2956] As a user with large CSV datasets to import, I need control over the selection of data types for specific fields Created: 21/Jun/18  Updated: 16/Aug/19  Resolved: 16/Aug/19

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

Type: New Feature Priority: Major - P3
Reporter: Brian Blevins Assignee: Unassigned
Resolution: Done Votes: 0
Labels: import-csv, type-conversion
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Problem/Incident
causes COMPASS-3826 Import CSV: select fields Closed

 Description   

A way is needed to configure the desired datatype for each field/column of a CSV file during import.

The standard approach used by other tools is to display a dialog after parsing the first line/lines and allow the selection of the datatype from a menu for each of the field/column names.

Another approach would be to define the second row of the CSV as a type only line, with the datatypes separated by commas. Then a simple flag in the import dialog could signal that the second line in the CSV file should select the datatypes for each field/column.

Name,Address,Birthdate,Widgets,Mobile,Spend
$string,$string,$date,$numberLong,$string,$numberDecimal


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