Required Fields and Sparse Rows

Each item parsed by the Tabular plugin has a certain number of required fields, for which some source must be set (as a ColumnHeader, FixedValue, ColumnIndex, or PrefaceRegex) in order for the Tabular plugin to import the item into an AQUARIUS Time-Series field visit.

One common pattern is that both a ParameterId and a UnitId must be specified for any measured value. Your configuration can't just say "I am measuring air temperature". It must say "I am measuring air temperature in Celcius" or "I am measuring air temperature in Fahrenheit".

# This is an invalid reading configuration, since we don't know the unit of temperature
[Reading]
Value = '@Value'
ParameterId = 'TA'

You must fix or disable any invalid configurations.

The Tabular plugin will detect invalid configurations like the above example and log an error. It will not be able to parse any CSV data until either:

• You correct the TOML configuration error and create a sane configuration.
• Or you disable the configuration by setting its Priority = 0.

One of the required fields will also be used to determine "Sparse Rows" for that item

The Tabular plugin supports sparse data rows, which allows for very flexible form result importing.

Was this reading from columns 3 throuh 7 actually collected? No? OK, then I won't import anything from those columns.

Most field data items use one of its required fields to decide "should I parse this item from this data row?"

Item	Item parsing is skipped row when this field's value is blank/empty
Readings	Value (or Parameter when readings with empty values is enabled.)
Calibrations	Value
Inspections	InspectionType
LevelSurveys	OriginReferencePointName
LevelSurveyMeasurements	MeasuredElevation
GageHeightMeasurements	Value
AdcpDischarges	TotalDischarge
PanelDischargeSummaries	TotalDischarge
OtherDischarges	TotalDischarge
VolumetricDischarges	TotalDischarge
EngineeredStructureDischarges	TotalDischarge
MeterCalibrationEquations	Slope
GageAtZeroFlow	UnitId plus either GageHeight or both Stage and WaterDepth