TSTool-Vol2-CommandReference - Laserfiche WebLink

simple routing. The following dialog is used to edit the command and illustrates the command syntax. ShiftTimeByInterval ShiftTimeByInterval() Command Editor The command syntax is as follows: ShiftTimeByInterval(Parameter=Value,…) Command Parameters Parameter Description Default TSList Indicates the list of time series to be processed, one of: • AllMatchingTSID – all time series that match the TSID (single TSID or TSID with wildcards) will be modified. • AllTS – all time series before the command. • EnsembleID – all time series in the ensemble will be AllTS 463 Command Reference – ShiftTimeByInterval() -1 ShiftTimeByInterval() Command TSTool Documentation Parameter Description Default modified. • LastMatchingTSID – the last time series that matches the TSID (single TSID or TSID with wildcards) will be modified. • SelectedTS – the time series are those selected with the SelectTimeSeries() command. TSID The time series identifier or alias for the time series to be modified, using the * wildcard character to match multiple time series. TSID or EnsembleID must be specified if identifiers are being matched. EnsembleID The ensemble to be modified, if processing an ensemble. TSID or EnsembleID must be specified if identifiers are being matched. ShiftData Interval,multiplier tuples to apply to the data to perform the shift. All values should be separated by commas. An interval of -1 indicates that the previous time step should be shifted to the current time step. If the interval is –1 and the multiplier is 1, the previous time step is shifted to the current and multiplied by 1, effectively shifting the time series by one interval. None – at least 1 value,multiplier tuple must be specified. A sample command file to shift data from the State of Colorado’s HydroBase is as follows: # 08213500 -RIO GRANDE RIVER AT THIRTY MILE BRIDGE NEAR CREEDE 08213500.DWR.Streamflow.Day~HydroBase ShiftTimeByInterval(TSLis t=AllMatchingTSID,TSID="08213500.DWR.Streamflow.Day", ShiftData="-1,1") 08213500.DWR.Streamflow.Day~HydroBase ShiftTimeByInterval_graph Results from ShiftTimeByInterval() Command Command Reference – ShiftTimeByInterval() -2 464 Command Reference: SortTimeSeries() Sort time series by their identifiers Version 08.15.00, 2008-05-11 The SortTimeSeries() command sorts the time series alphabetically using the time series identifier. This command is useful for ordering time series before writing output, for example to facilitate comparison with another version of the output or to be consistent with other data files. The following dialog is used to edit the command and illustrates the syntax for the command. SortTimeSeries SortTimeSeries() Command Editor The command syntax is as follows: SortTimeSeries(Parameter=Value,…) Command Parameters Parameter Description Default Currently no parameters are available for this command. 465 Command Reference – SortTimeSeries() -1 SortTimeSeries() Command TSTool Documentation A sample command file using data from the State of Colorado’s HydroBase is as follows: # 06759100 -BIJOU CREEK NEAR FT. MORGAN, CO. 06759100.USGS.Streamf low.Month~HydroBase # 06759000 -BIJOU CREEK NEAR WIGGINS, CO. 06759000.USGS.Streamflow.Month~HydroBase # BOXHUDCO -BOX ELDER CREEK NEAR HUDSON, CO BOXHUDCO.DWR.Streamflow.Month~HydroBase # 06756500 -CROW CREEK NEAR BARNSVILLE, CO. 06756500.USGS.Streamflow.Month~HydroBase # 06758300 -KIOWA CREEK AT BENNETT, CO. 06758300.USGS.Streamflow.Month~HydroBase # 06758000 -KIOWA CREEK AT ELBERT, CO. 06758000.USGS.Streamflow.Month~HydroBase # 06757600 -KIOWA CREEK AT K-79 RES, NEAR EASTONVILLE, CO. 06757600.DWR.Streamflow.Month~HydroBase # 06758200 -KIOWA CREEK AT KIOWA, CO. 06758200.USGS.Streamflow.Month~HydroBase # 06753400 -LONETREE CREEK AT CARR, CO. 06753400.USGS.Streamflow.Month~HydroBase # 06753990 -LONETREE CREEK NEAR GREELEY, CO. 06753990.USGS.Stre amflow.Month~HydroBase # 06753500 -LONETREE CREEK NEAR NUNN, CO. 06753500.USGS.Streamflow.Month~HydroBase # 06759910 -SOUTH PLATTE RIVER AT COOPER BRIDGE NEAR BALZAC 06759910.DWR.Streamflow.Month~Hyd roBase # 06759500 -SOUTH PLATTE RIVER AT FORT MORGAN 06759500.USGS.Streamflow.Month~HydroBase # 06756995 -SOUTH PLATTE RIVER AT MASTERS, CO. 06756995.USGS.Streamflow.Month~HydroBase # 06757000 -SOUTH PLATTE RIVER AT SUBLETTE, CO. 06757000.USGS.Streamflow.Month~HydroBase # 06754000 -SOUTH PLATTE RIVER NEAR KERSEY 06754000.DWR.Streamflow.Month~HydroBase # 06758500 -SOUTH PLATTE RIVER NEAR WELDONA 06758500.DWR.Streamflow.Month~HydroBase # 06758100 -WEST KIOWA CREEK AT ELBERT, CO. 06758100.USGS.Streamflow.Month~HydroBase SortTimeSeries() Command Reference – SortTimeSeries() -2 466 Command Reference: StartLog() (Re)start the log file Version 09.08.01, 2010-09-14 The StartLog() command (re)starts the log file. It is useful to insert this command as the first command in a command file, in order to persistently record the results of processing. A useful standard is to name the log file the same as the command file, with an additional .log extension, and this convention is enforced by default. A date or date/time can optionally be added to the log file name. The following dialog is used to edit the command and illustrates the syntax for the command. StartLog StartLog() Command Editor 467 Command Reference – StartLog() -1 StartLog() Command TSTool Documentation The command syntax is as follows: StartLog(Parameter=Value,…) Command Parameters Parameter Description Default LogFile The name of the log file to write surrounded by double quotes. The extension of .log will automatically be added, if not specified. If not specified, the existing file will be restarted. Suffix Indicates that a suffix will be added before the .log extension, one of: 􀂃 Date – add a date suffix of the form YYYYMMDD. 􀂃 DateTime – add a date/time suffix of the form YYYYMMDD_HHMMSS. This is useful for automatically archiving logs corresponding to commands files, to allow checking the output at a later time. However, generating date/time stamped log files can increase the amount of disk space that is used. Do not add the suffix. A sample command file to process State of Colorado HydroBase data is as follows (the Add() command will generate an error because the units of the time series are incompatible): StartLog(LogFile="Example_StartLog.log") # 06753400 -LONETREE CREEK AT CARR, CO. 06753400.USGS.Streamflow.Month~HydroBase # 1179 -BYERS 5 ENE 1179.NOAA.Precip.Month~HydroBase Add(TSID="06753400.USGS.Streamflow.Month",AddTSList=AllTS,HandleMissingHow="IgnoreMissing") Command Reference – StartLog() -2 468 Command Reference: StartRegressionTestResultsReport() Start a report file to contain regression test results Version 08.15.00, 2008-05-11 The StartRegressionTestResultsReport() command starts a report file to be written to as regression tests are run. The CreateRegressionTestCommandFile() automatically inserts this command. The CompareFiles() and CompareTimeSeries() commands will write to this file if it is available. The following dialog is used to edit the command and illustrates the syntax for the command. StartRegressionTestResultsReport StartRegressionTestR esultsReport() Command Editor 46 9Command Reference – StartRegressionTestResultsReport() -1 StartRegressionTestResultsReport() Command TSTool Documentation The command syntax is as follows: StartRegressionTestResultsReport(Parameter=Value,…) Command Parameters Parameter Description Default OutputFile The name of the report file, enclosed in double quotes if the file contains spaces or other special characters. A path relative to the command file can be specified. None – must be specified. See the RunCommands() documentation for how to set up a regression test. The following command file illustrates how to start the results report: StartRegressionTestResultsRe port( OutputFile="RunRegressionTest_commands_general.TSTool.out.txt") … RunCommands(InputFile="..\..\..\commands\general\ReadStateMod\Test_ReadStateMod_1.TSTool") … Each of the above command files should produce expected time series results, without warnings. If any command file unexpectedly produces a warning, a warning will also be visible in TSTool. The issue can then be evaluated to determine whether a software or configuration change is necessary. An example of the output file is: SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\gen eral\add\Test_Add_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\addConstant\Test_AddConstant_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regres sion\commands\general\adjustExtremes\Test_AdjustExtremes_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\analyzePattern\Test_AnalyzePattern_FromMonthDataValues. TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\ARMA\Test_ARMA_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\blend\Test_B lend_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\ChangeInterval\Test_ChangeInterval_DayMean_To_MonthMean.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool \test\regression\commands\general\ChangePeriod\Test_ChangePeriod_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\compareTimeSeries\Test_AllDifferent.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\compareTimeSeries\Test_AllSame.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\conve rtDataUnits\Test_ConvertDataUnits_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\Copy\Test_Copy_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regr ession\commands\general\CreateEnsemble\Test_CreateEnsemble_1.TSTool FAILURE C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\CreateFromList\Test_CreateFromList_1.TSTool WARNING C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\CreateTraces_Alias\Test_CreateTraces_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\gener al\cumulate\Test_Cumulate_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\DeselectTimeSeries\Test_DeselectTimeSeries_1.TSTool SUCCESS C:\Develop\TSTool_SourceBu ild\TSTool\test\regression\commands\general\Disaggregate_Alias\Test_Disaggregate_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\divide\Test_Divide_1.TSTool WARNING C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\general\fillCarryForward\Test_FillCarryForward_1.TSTool SUCCESS C:\Develop\TSTool_SourceBuild\TSTool\test\regression\commands\gen eral\fillConstant\Test_FillConstant_Day.TSTool Command Reference – StartRegressionTestResultsReport() -2 470 Command Reference: StateModMax() Compute the maximum of time series in two StateMod files Version 08.16.04, 2008-09-23 A StateModMax() command performs the following actions: 1. Read all time series from one StateMod time series file, 2. Read all time series from a second StateMod time series file, 3. Generate a list of time series that contains the maximum values comparing matching time series (using the location identifier). The first list is updated and the second list is discarded. This command is useful, for example, when creating a demand time series file that is to be the maximum of historical diversions and irrigation water requirement divided by an average efficiency. It is assumed that the specified time series have matching identifiers (the first file is used as the master list) and have consistent units and data intervals. After the time series have been processed, they can be viewed or written out as a new StateMod file (see the WriteStateMod() command). The following dialog is used to edit the command and illustrates the syntax for the command. StateModMax StateModMax() Command Editor 471 Command Reference – StateModMax() -1 StateModMax() Command TSTool Documentation The command syntax is as follows: StateModMax(Parameter=Value,…) Command Parameters Parameter Description Default InputFile1 The name of the first StateMod time series file to read, surrounded by double quotes. The path to the file can be absolute or relative to the working directory. None – must be specified. InputFile2 The name of the second StateMod time series file to read, which must have the same data interval and units as the first file. None – must be specified. A sample command file is as follows: StateModMax("rgTW.ddh","rgTWC_prelim.ddm") WriteStateMod("rgTW.ddm",*) Command Reference – StateModMax() -2 472 Command Reference: Subtract() Subtract one or more time series from another time series Version 08.15.00, 2008-05-12 The Subtract() command subtracts time series of the same interval. The receiving time series will have data values set to its original values minus the data values in the indicated time series. If an ensemble is being processed, another ensemble can be subtracted, a single time series can be subtracted from all time series in the ensemble, or a list of time series can be subtracted from the ensemble (the number in the list must match the number of time series in the ensemble). This command will generate an error if the time series do not have compatible units. If the units are compatible but are not the same (e.g., IN and FT), then the units of the part will be converted to the units of the result before subtraction. Missing data in the parts can be ignored (do not set the result to missing) or can set missing values in the result. The user should consider the implications of ignoring missing data. Time series being subtracted must have the same data interval. The following dialog is used to edit the command and illustrates the syntax of the command. Subtract Subtract() Command Editor The command syntax is as follows: Subtract(Parameter=Value,…) 473 Command Reference – Subtract() -1 Subtract() Command TSTool Documentation Command Parameters Parameter Description Default TSID The time series identifier or alias for the time series to receive the result. TSID or EnsembleID must be specified. EnsembleID The ensemble to receive the result, if processing an ensemble. TSID or EnsembleID must be specified. Subtract TSList Indicates how the list of time series is specified, one of: • AllTS – all time series before the command. • AllMatchingTSID – all time series that match the AddTSID (single TSID or TSID with wildcards) will be subtracted. • EnsembleID – the time series from ensemble will be subtracted. • LastMatchingTSID – the last time series that matches the TSID (single TSID or TSID with wildcards) will be subtracted. • SelectedTS – the time series are those selected with the SelectTimeSeries() command. • SpecifiedTSID – the specified list of time series given by the SubtractTSID parameter. If using version 8.02.00 or earlier, use SpecifiedTS. AllTS (the time series receiving the sum will not be subtracted from itself) SubtractTSID If the SubtractTSList parameter is SpecifiedTSID, provide the list of time series identifiers (or alias) to subtract, separated by commas. If the SubtractTSList parameter is AllMatchingTSID, specify a single TSID or a TSID with wildcards. Must be specified if TSList= SpecifiedTSID, ignored otherwise. Subtract EnsembleID If the EnsembleID parameter is specified, providing an ensemble ID will subtract the ensembles. Use if an ensemble is being subtracted from another ensemble. Handle MissingHow Indicates how to handle missing data in a time series, one of: • IgnoreMissing – create a result even if missing data are encountered in one or more time series – this option is not as rigorous as the others • SetMissingIfOtherMissing – set the result missing if any of the other time series values is missing • SetMissingIfAnyMissing – set the result missing if any time series value involved is missing IgnoreMissing A sample command file to subtract data from the State of Colorado’s HydroBase is as follows: # 0100501 -EMPIRE DITCH 0100501.DWR.DivTotal.Month~HydroBase # 0100503 -RIVERSIDE CANAL 0100503.DWR.DivTotal.Month~HydroBase Subtract(TSID="0100501.DWR.DivTotal.Month",Subtra ctTSList=SpecifiedTSID, SubtractTSID="0100503.DWR.DivTotal.Month", HandleMissingHow="IgnoreMissing") Command Reference – Subtract() -2 474 Command Reference: TableMath() Perform simple math operation on columns in a table Version 09.08.01, 2010-09-14 The TableMath() command performs a simple math operation on columns in a table. Although the design of the command could support more advanced cell range addressing schemes, it currently processes complete columns of data. For example, a table that is populated by the CalculateTimeSeriesStatistic() command could be manipulated to produce a new column of data. This command and related table commands are not an attempt to replace full-feature spreadsheet programs but are intended to help automate common data processing tasks. The input is specified by a table column name (Input1) and either a second input column name or a constant value (Input2), with the result being placed in the output column (Output). Output that cannot be computed is set to the NonValue value. The following dialog is used to edit the command and illustrates the syntax of the command (in this case illustrating how values in a column named ts1 are multiplied by the number 2. TableMath TableMath() Command Editor 475 Command Reference – TableMath () -1 TableMath() Command TSTool Documentation The command syntax is as follows: TableMath(Parameter=Value,…) Command Parameters Parameter Description Default TableID The identifier for the table to process. None – must be specified. Input1 First input column name. None – must be specified. Operator The operator to be applied as follows: Input1 Operator Input2 = Output For example: Input1 * Input2 = Output None – must be specified. Input2 Second input column name, or a constant value to use as input. None – must be specified. Output Output column name. If the column is not found it will be added to the table and will contain the results of processing. None – must be specified. NonValue The value to use in cases where an output result could not be computed (missing input, division by zero). Null will result in blanks in output whereas NaN may be shown in some output products, depending on the specifications for the format. Null Command Reference – TableMath() -2 476 Command Reference – TableTimeSeriesMath () -1 Command Reference: TableTimeSeriesMath() Perform simple math operation on time series using table input Version 10.04.00, 2012-01-13 The TableTimeSeriesMath() command performs a simple math operation on time series using values from a table. For example, a table that is populated by the CalculateTimeSeriesStatistic() command or ReadTableFromDelimitedFile() could be used to modify time series data. See also the TableMath() command, which performs math on a table. The table value is determined by matching the time series identifier (formatted according to the TableTSIDFormat parameter) with the TSID value in the table column specified by the TableTSIDColumn parameter. If necessary, use the ManipulateTableString() command to generate an identifier column in the table that allows that match. Missing values in the time series generally will not be updated, although the assignment (=) operator will do so. The following dialog is used to edit the command and illustrates the syntax of the command. TableTimeSeriesMath TableTimeSeriesMath() Command Editor The command syntax is as follows: TableTimeSeriesMath(Parameter=Value,…) 477 TableTimeSeriesMath() Command TSTool Documentation Command Reference – TableTimeSeriesMath() -2 Command Parameters Parameter Description Default TSList Indicates the list of time series to be processed, one of: • AllMatchingTSID – all time series that match the TSID (single TSID or TSID with wildcards). • AllTS – all time series before the command. • EnsembleID – all time series in the ensemble. • FirstMatchingTSID – the first time series that matches the TSID (single TSID or TSID with wildcards). • LastMatchingTSID – the last time series that matches the TSID (single TSID or TSID with wildcards). • SelectedTS – the time series selected with the SelectTimeSeries() command. AllTS TSID The time series identifier or alias for the time series to be processed, using the * wildcard character to match multiple time series. Required if TSList=*TSID. EnsembleID The ensemble to be processed, if processing an ensemble. Required if TSList=EnsembleID. Operator The operator to be applied to the time series and table input. None – must be specified. TableID Identifier for table that provides input. None – must be specified. TableTSIDColumn Table column name that is used to match the time series identifier for processing. None – must be specified. TableTSIDFormat The specification to format the time series identifier to match the TSID column. Use the format choices and other characters to define a unique identifier. Time series alias if available, or otherwise the time series identifier. TableInput Column Table column name to retrieve the table value. None – must be specified. IfTableInputIsBlank Action if time table input is blank during processing (no value to operate on). Warn IfTSListIsEmpty Action if time series list is empty. Fail The delimited file corresponding to that used in the above dialog example is shown below. In this example, the time series identifiers have location parts with values ts1 and ts2. # Simple test data "TSID","DataValue" ts1,2 ts2,3 478 Command Reference – TableToTimeSeries() -1 Command Reference: TableToTimeSeries() Create time series from a table Version 10.21.00, 2013-06-27 Note: This command may be split into two separate commands (one for single column data values and one for multiple column data values) if editing the command parameters becomes confusing. The TableToTimeSeries() command creates time series from a table. This command can be used when a command to read time series from a specific file format or datastore has not been implemented. The table typically is read using one of the following commands: • ReadTableFromDataStore() – for example, define an ODBC DSN connection to a database and query time series using an SQL statement. • ReadTableFromDelimitedFile() – for example, read time series from a commaseparated-value (CSV) file. • ReadTableFromExcel() – for example, read time series from a comma-separated-value (CSV) file • ReadTableFromHTML() – envisioned for the future. TSTool internally represents tables as a collection of columns, where a column contains values of a consistent data type (e.g., integer, string, double). A time series table requires at a minimum a date/time column (or separate date and time columns), at least one data value column, and optionally one or more columns for data flags. Data represented in one of two table designs are handled by this command: • Data for multiple locations/series stored in a single column (common in a database or stream of data from a data logger) – specify the LocationColumn command parameter. • Data for multiple locations/series stored in multiple columns (common in spreadsheets and CSV files) – do not specify the LocationColumn command parameter but instead specify the ValueColumn and optionally LocationID parameters. The command provides flexibility to specify time series metadata (e.g., data source, units) as command parameters, or read from the file. However, this flexibility is limited by practical considerations in supporting likely data formats. One current limitation of the command is that TSTool does not determine table column names during discovery mode (discover mode is a partial command run that allows data such as time series and table identifiers to be provided to later commands for editing). Consequently, although this command will create time series when run, it does not produce time series information in discovery mode and the time series will not be listed in later command editors. This limitation will be addressed in future TSTool updates. 479 TableToTimeSeries () Command TSTool Documentation Command Reference – TableToTimeSeries () -2 An example of a table with single data value column with flags is shown in the following figure (note that a column is used for the location identifier and that the location is different for the topmost and bottommost records). TableToTimeSeries_Single_Data Simple Table with Data Values in a Single Column In the above example, the list of unique time series is determined by examining the location column contents. Other time series metadata such as data source and units can be assigned using the DataSource, Units, and similar parameters. The following dialog is used to edit the command and illustrates the command syntax when processing single-column data from the above example. Note that time series metadata are specified with command parameters. 480 TSTool Documentation TableToTimeSeries () Command Command Reference – TableToTimeSeries () -3 TableToTimeSeries_Single TableToTimeSeries() Command Editor for Table with Data in a Single Column The following example is also treated as single-column because a single column of data values is present. However, metadata are taken from other columns. This data format is consistent with a database query where several tables have been joined together. Although not efficient because time series metadata is repeated for every row, the format is convenient for data translation. Use the DataSourceColumn, UnitsColumn and similar parameters to specify metadata. The unique list of time series will be determined from the combinations of location identifier and other metadata.. 481 TableToTimeSeries () Command TSTool Documentation Command Reference – TableToTimeSeries () -4 TableToTimeSeries_SingleMeta_Data Table with Data Values in a Single Column and Metadata Provided in Other Columns The following dialog is used to edit the command and illustrates the command syntax when processing single-column data from the above example. Note that time series metadata are specified with command parameters. 482 TSTool Documentation TableToTimeSeries () Command Command Reference – TableToTimeSeries () -5 TableToTimeSeries_SingleMeta TableToTimeSeries() Command Editor for Table with Single Data Column and Metadata Columns An example of multi-column data with flags is shown in the following figure, where each time series has its own data and flag columns: TableToTimeSeries_Multiple_Data Table with Multiple Data Columns 483 TableToTimeSeries () Command TSTool Documentation Command Reference – TableToTimeSeries () -6 The following dialog is used to edit the command and illustrates the syntax for the command when processing multi-column data from the above table. TableToTimeSeries_Multiple TableToTimeSeries() Command Editor For Table with Data in a Single Column The command syntax is as follows: TableToTimeSeries(Parameter=Value,…) Command Parameters Parameter Description Default TableID The identifier for the table to read. None – must be specified. DateTime Column The column for date/time, when date and time are in one column. If the table was read in a way that the column type is “date/time”, then the values are used directly. If the table was read in a way that the column type is “string”, then the string is parsed using default logic or the Required if DateColumn is not specified. 484 TSTool Documentation TableToTimeSeries () Command Command Reference – TableToTimeSeries () -7 Parameter Description Default DateTimeFormat parameter if specified. DateTime Format The format for date/time strings in the date/time column, if strings are being parsed. If blank, common formats such as YYYY-MM-DD hh:mm and MM/DD/YYYY will automatically be detected. However, it may be necessary to specify the format to ensure proper parsing. This format will be used to parse date/times from the DateTimeColumn or the merged string from the DateColumn and TimeColumn (if specified). The format string will depend on the formatter type. Currently, only the “C” formatter is available, which uses C programming language specifiers. The resulting format includes the formatter and specifiers (e.g., C:%m%d%y). Will automatically be determined by examining date/time strings. DateColumn The name of column that includes the date, used when date and time are in separate columns. Required if DateTimeColumn is not specified. TimeColumn The name of column that includes the time, used when date and time are in separate