Opened 13 years ago
Last modified 12 years ago
#1819 closed feature request
Dialog to set the separator and culture (number and date format) when importing CSV files — at Version 3
Reported by: | mkommend | Owned by: | sforsten |
---|---|---|---|
Priority: | medium | Milestone: | |
Component: | Problems.DataAnalysis | Version: | 3.3.6 |
Keywords: | Cc: |
Description (last modified by gkronber)
DateTimes are not always parsed correctly when importing datasets.
Currently the TableFileParser uses a heuristic to determine which format should be used for parsing numbers. This is not done when parsing dates and per default an invariant date time format is used. Therefore, files containing dates are not parsed correctly, because for example the month and day may be exchanged.
Change History (3)
comment:1 Changed 13 years ago by sforsten
comment:2 Changed 13 years ago by gkronber
Please also add the possibility to import data files with '\t'-separated values if you implement a dialog to configure the importer parameters.
comment:3 Changed 12 years ago by gkronber
- Description modified (diff)
- Summary changed from DateTimes are not always parsed correctly when importing datasets to Dialog to set the separator and culture (number and date format) when importing CSV files
- Type changed from defect to feature request
Note: See
TracTickets for help on using
tickets.
A possible solution would be to use a dialog, where the formats of number and date time can be set. The heuristic to determine the delimiter and formats can be used to give the user a recommendation. In the dialog it should be displayed how the selected formats have to look like.