Free cookie consent management tool by TermsFeed Policy Generator

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

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 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.