#1819 closed feature request (duplicate)
Dialog to set the separator and culture (number and date format) when importing CSV files
Reported by: | mkommend | Owned by: | mkommend |
---|---|---|---|
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 (6)
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
comment:4 Changed 12 years ago by sforsten
- Owner changed from sforsten to mkommend
- Status changed from new to assigned
comment:5 Changed 12 years ago by mkommend
- Resolution set to duplicate
- Status changed from assigned to closed
This was already implemented with #1942.
comment:6 Changed 12 years ago by mkommend
- Milestone HeuristicLab 3.3.x Backlog deleted
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.