search

CUAHSI / HydroDesktop

HydroDesktop is a free and open source GIS enabled desktop application that helps you search for, download, visualize, and analyze hydrologic and climate data registered with the CUAHSI Hydrologic Information System. HydroDesktop is part of the legacy CUAHSI toolkit and is not under active development. Click the "releases" link below to download the latest installer for Microsoft Windows.
73 stars 20 forks source link

Data Export exports date and time in bad format #101

Open xhqiao89 opened 6 years ago

xhqiao89 commented 6 years ago

jirikadlec2[CodePlex]
When the user's Windows regional and language settings are non-English (for example Czech), the values of the LocalDateTime and DateTimeUTC columns in the exported CSV file are in a non-standard format. This makes it difficult to work with the exported csv file in popular tools like LibreOffice or R.

As a fix I would recommend adding an drop-down with quotDate and Time formatquot option and add two date/time format options: default (same as now for example month/day/year in the english language settings) and International date time format (yyyy-mm-dd hh:mm:ss).

For description of international date and time format see: http://www.cl.cam.ac.uk/~mgk25/iso-time.html

xhqiao89 commented 6 years ago

cuylerfris[CodePlex]
marking as active