...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<table name="StageList"> <dateTimeColumn name="InDate"/> <valueColumn name="Shemen" locationId="HS03" unit="m" parameterId="H.obs"/> <valueColumn name="Clouds" locationId="HS02" unit="m" parameterId="H.obs"/> <valueColumn name="High" locationId="1140H043" unit="m" parameterId="H.obs"/> <valueColumn name="Angle" locationId="1140H002" unit="m" parameterId="H.obs"/> <valueColumn name="Jade" locationId="HS01" unit="m" parameterId="H.obs"/> <valueColumn name="Show" locationId="1140H041" unit="m" parameterId="H.obs"/> <valueColumn name="Kide" locationId="HS04" unit="m" parameterId="H.obs"/> </table> |
...
Sample, properties and qualifiers example
Since 2014.02 it is possible to use sampleIdColumn (normal ComplexColumnType with just name attribute) and propertyColumn (with mandatory key attribute). qualifierColumn is extended with the optional prefix attribute which will be added in front of the external qualifier id, this can be useful for id mapping.
Below configuration is shown which can import sample data, with properties and multiple qualifiers. In case sample data is imported the properties will be automatically used for the sample instead of the time step.
| Code Block | ||||
|---|---|---|---|---|
| ||||
<table> <dateTimeColumn name="DATE_SMP" pattern="dd-MM-yy HH:mm"/> <locationColumn name="LOC_CODE"/> <unitColumn name="Eenheid"/> <parameterColumn name="PARAMETER_ID"/> <qualifierColumn name="TYPE" prefix="TYPE_"/> <qualifierColumn name="GESLACHT" prefix="GESLACHT_"/> <sampleIdColumn name="SMP_CODE"/> <propertyColumn name="EXT_REF" key="EXT_REF"/> <propertyColumn name="SMP_NAME" key="SMP_NAME"/> <propertyColumn name="BRON" key="BRON"/> <valueColumn name="Waarde"/> </table> |