Activity

Activity Details

The Activity definition derives from the Core definition, and includes all of the base class properties.

8 Properties	Required	Description
Comment MergeWithComment MergeWithComments Disabled - v21.4.12+	N	4 inherited Core properties.
[Time] [[Times]] [DateOnly] - v20.3+ [TimeOnly] - v20.3+	N	A list of timestamp definitions, combined into a single moment in time.

The [Time], [TimeOnly], [DateOnly], and [[Times]] definitions will be used to combine into a single moment in time.

If no time definitions are specified, the start time of the visit will be used as the activity start time.

While a single Time definition can often be enough to contain describe a time, some CSV files will store the date in one column and the time in a another column. Using multiple [[Times]] sections to combine the time and date is a solution.

Location, Date, Time, Value
LOC1, 2020-Apr-2, 12:35, 12.5

Location = '@Location'

[[Times]]
ColumnHeader = 'Date'
Type = 'DateOnly'
Format = 'yyyy-MMM-d'

[[Times]]
ColumnHeader = 'Time'
Type = 'TimeOnly'
Format = 'H:m'

[Reading]
Value = '@Value'
ParameterId = 'TA'
UnitId = 'degC'

v20.3 adds DateOnly and TimeOnly properties for simpler parsing

Version 20.3 of the Tabular CSV plugin added some extra properties to allow you to handle dates and times in separate CSV columns more simply.

• The TimeOnly property is a timestamp with a default Type of TimeOnly.
• The DateOnly property is a timestamp with a default Type of DateOnly.

The previous 16-line configuration example is still supported, but now you can just use the shorthand syntax for a simpler 8-line configuration.

Location, Date, Time, Value
LOC1, 2020-Apr-2, 12:35, 12.5

Location = '@Location'
DateOnly = '@Date'
TimeOnly = '@Time'

[Reading]
Value = '@Value'
ParameterId = 'TA'
UnitId = 'degC'