Opened 7 years ago

Closed 6 years ago

Last modified 6 years ago

#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 7 years ago by sforsten

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.

comment:2 Changed 7 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 7 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 7 years ago by sforsten

  • Owner changed from sforsten to mkommend
  • Status changed from new to assigned

comment:5 Changed 6 years ago by mkommend

  • Resolution set to duplicate
  • Status changed from assigned to closed

This was already implemented with #1942.

comment:6 Changed 6 years ago by mkommend

  • Milestone HeuristicLab 3.3.x Backlog deleted
Note: See TracTickets for help on using tickets.