Skip to content

TSTool / Release Notes / Version 13


Changes in Versions 13.03.00

  • bug [13.03.00] Change so that user's .tstool/NN/system/TSTool.cfg file properties are recognized whether or not [TSTool] is at the top of the file.
  • bug [13.03.00] Change the RunProgram command Visual Diff feature to work when files use property in the name.
  • bug [13.03.00] Update the ReadStateCU and ReadStateMod commands to better handle ${Property} in the InputFile parameter.
  • bug [13.03.00] Update the RunProgram command to work on Linux. Also add the EnvVars, IfNonZeroExitCode, StderrFile, and StdoutFile parameters.
  • bug [13.03.00] Update the TableToTimeSeries command to list time series in discovery mode if an alias is specified, for use in other commands.
  • bug [13.03.00] Update the WriteStateCU and WriteStateMod commands to enable TSID to handle ${Property}, as was previously documented.
  • change [13.03.00] All command editors have been updated to implement ..., Abs, and Rel buttons to select files and folders and switch between absolute and relative paths, with default being to use relative path. The command reference documentation has been updated accordingly.
  • change [13.03.00] Lowercase command file extension tstool is now included in file selectors and is the default enforced when saving. Mixed case TSTool extension is still supported.
  • change [13.03.00] Time series graphs can now be saved as JSON format time series product file - this preliminary format is being evaluated to integrate with web applications.
  • change [13.03.00] Fix a number of issues where table arrays were not cleanly supported.
  • change [13.03.00] Update the Add command AnalysisStart and AnalysisEnd parameters to support using ${Property}.
  • change [13.03.00] Update the AppendTable command to accept property notation in the ColumnFilters parameter.
  • change [13.03.00] Update the ChangePeriod command NewStart and NewEnd parameters to support using ${Property}.
  • change [13.03.00] Update the CloseDataStore command to have IfNotFound parameter to control error handling
  • change [13.03.00] Update the CompareFiles command to check the full length of each file when computing the number of different lines.
  • change [13.03.00] Update the CompareTimeSeries command to better support comparing irregular time series, add CompareFlags to control whether data flags are also compared.
  • change [13.03.00] Update the CreateEnsembleFromOneTimeSeries command to have TransferDataHow to control how input time series are transferred to output time series traces.
  • change [13.03.00] Update the CreateDataStoreDataDictionary to handle optional metadata for database software that do not provide metadata
  • change [13.03.00] Update the CreateRegressionTestCommandFile command to support multiple patterns to match files.
  • change [13.03.00] Update the DeleteTableRows command to allow * to delete all rows, additional functionality has been added for strings, and string operations have been made case-dependent.
  • change [13.03.00] Update the FillInterpolate command to fill the ends of the fill period even if non-missing values are outside of that period
  • change [13.03.00] Update the For command List parameter to support using ${Property}.
  • change [13.03.00] Update the ManipulateTableString to handle conversion of floating point numbers (as strings) to integers and properly round. Also add ToLowerCase, ToMixedCase, and ToUpperCase conversions.
  • change [13.03.00] Update the NewTable command to support arrays.
  • change [13.03.00] Update the NewTimeSeries command SetStart and SetEnd parameters to support using ${Property}.
  • change [13.03.00] Update the ProcessTSProduct command to output the time series product file to reflect the full product definition.
  • change [13.03.00] Update the ReadStateCU command to have Alias parameter to assign an alias to time series.
  • change [13.03.00] Update the ReadStateModB command to add IncludeDataTypes and ExcludeDataTypes parameters, which limits the time series that are read
  • change [13.03.00] Update the ReadTableFromDBF command to covert column data types.
  • change [13.03.00] Update the RunningStatisticTimeSeries command to add statistics: Change, ChangeAbs, ChangeFraction, ChangeFractionAbs, ChangePercent, ChangePercentAbs, NewMax, and NewMin.
  • change [13.03.00] Update the ReadTableFromDelimitedFile command to have ColumnNames parameter to specify column names when they are not in the file
  • change [13.03.00] Update the ReadTableFromDataStore command to allow modifiers after table names in OrderBy.
  • change [13.03.00] Update the SetDataValue command TSID and EnsembleID parameters to support using ${Property}.
  • change [13.03.00] Update the SetProperty command to allow math parameters to be specified as properties.
  • change [13.03.00] Update the SetConstant command SetStart and SetEnd parameters to support using ${Property}.
  • change [13.03.00] Update the SetFromTS command SetStart and SetEnd parameters to support using ${Property}.
  • change [13.03.00] Update the SetTableValues command to add Column and Value parameters to set a single column value, useful for complex values such as arrays
  • change [13.03.00] Update the StartLog command to have MaxSize parameter to limit log file size.
  • change [13.03.00] Update the TableMath command input and output parameters to support properties.
  • change [13.03.00] Update the Wait command to allow parameters to be specified as properties.
  • change [13.03.00] Update the WriteDelimitedFile command to have HeaderComments parameter to provide comments
  • change [13.03.00] Update the WriteTableToDelimitedFile command parameters to provide more flexibility in controlling the file format and support array columns. Also enhance performance of the command.
  • change [13.03.00] Update the PostgreSQL JDBC driver to version 42.2.9.
  • new [13.03.00] Add the Break command to break out of For loop block
  • new [13.03.00] Add the ChangeIntervalIrregularToRegular command to change interval of irregular interval time series to regular interval, simpler than the ChangeInterval command
  • new [13.03.00] Add the Continue command to jump to end of For loop block
  • new [13.03.00] Add the CreateFolder command to create a folder
  • new [13.03.00] Add the FormatFile command to format a file for output, including for web
  • new [13.03.00] Add the OpenDataStore command to open a datastore from command file
  • new [13.03.00] Add the RunR command to run R scripts.
  • new [13.03.00] Add the NewSQLiteDatabase command to create a SQLite database
  • new [13.03.00] Add the TextEdit command to edit text files

Changes in Versions 13.02.00

  • change [13.02.00] Most menu items now have tooltips that provide additional information to users. The tooltips will be modified as feedback on their interpretation is received.
  • change [13.02.00] The table command menu Manipulate Table Values has been resorted to facilitate use, with commands grouped by column, row, and other manipulation functionality.
  • change [13.02.00] The AppendTable command has been updated with new ColumnData parameter to set constant data on appended rows.
  • change [13.02.00] The DeleteTableColumns command has been updated with new KeepColumns parameter to streamline indicating which columns should be deleted.
  • change [13.02.00] The DeleteTableRows command has been updated with new Condition parameter to filter which rows are deleted.
  • change [13.02.00] The ReadColoradoHydroBaseRest command now reads DivComment time series, to facilitate troubleshooting diversion records. The data value is set to zero if no water was taken in a year.
  • change [13.02.00] The ReadHydroBase and ReadColoradoHydroBaseRest commands have been updated to provide FillDivRecordsCarryForward parameter to allow control (rather than default). The behavior of both commands is consistent in terms of default parameter values. The WaterClass parameter has been added to allow matching a specific water class. A number of usability issues have also been fixed.
  • change [13.02.00] The ReadTableFromDataStore and RunSql commands have been updated to run procedures that have parameters and set the return status as a property. Procedures that have the same name with different parameters are not yet handled.
  • change [13.02.00] The StartLog command has been updated to write log messages to clarify the hand-off between closed and newly opened log file.
  • new [13.02.00] Add RenameTableColumns command.
  • new [13.02.00] Dialogs related to saving command files have been updated to provide an option to compare the in-memory (unsaved) command file with latest command file saved to disk. The View / Command File Diff tool has been implemented to show differences. This is useful when deciding whether to save or discard command file edits.

Changes in Versions 13.00.00 - 13.01.00

  • remove [13.00.00] Remove RiversideDB datastore built-in features. The features can be added later as a plugin if necessary.
  • bug [13.01.01] Fix bug where Find Command(s) popup menu was not working.
  • bug [13.01.00] Fix bug where highlighting line on graph by clicking on legend was not working.
  • bug [13.00.00] Fix bug where StateMod binary files over 2GB could not be read.
  • bug [13.00.00] Fix bug to allow StateMod time series to have up to 1500 years in *.xop time series files, to support climate change modeling.
  • change [13.01.00] Improve datastore information for HydroBase to facilitate troubleshooting.
  • change [13.01.00] Finish converting Word documentation to online format for remaining commands and datastores.
  • change [13.00.00] Enable open source licenses for software and documentation.
  • change [13.00.00] Migrate to new configuration folders:
    • Installation files now include datastores and plugins folders, consistent with user files.
    • User files are located in under .tstool/N folder with datastores, logs, plugins, and system folder, where N is the major TSTool version.
    • Also automatically copy the command-file-history.txt file to new major version folder if a new installation.
  • change [13.00.00] Ignore ColoradoWaterHBGuest and ColoradoWaterSMS web service datastores because the services are no longer available from the State of Colorado.
  • change [13.00.00] Improve the Tools / Options information to explain TSTool configuration.
  • change [13.00.00] Improve ColoradoHydroBaseRest web services features:
    • Display additional information in the time series list.
    • The query period has been enabled for all supported time series data types.
    • Time series properties are set for station, structure, and other object data.
    • The dataUrl property is set to allow accessing data on the website.
  • change [13.00.00] Enhance the ManipulateTableString command to allow $ for replace and remove actions using \$. The $ without escape alone represents end of line, as previously implemented.
  • change [13.00.00] Enhance the WriteTableToGeoJSON command to specify the GeoJSON version (default is RFC7946) via new Version parameter. Also add the CoordinatePrecision parameter to control precision on coordinates and bounding box.
  • change [13.00.00] Enhance the WriteTimeSeriesToGeoJSON command by adding the CoordinatePrecision parameter to control precision on coordinates and bounding box.
  • new [13.01.00] Add scripts to streamline creating Linux installer from Windows install.