Page History

...

Since 2014.02 it is possible to use sampleIdColumn (normal ComplexColumnType with just name attribute) and , propertyColumn (with mandatory key attribute) and attribute column (with mandatory id attribute) which can only be used for export since attributes can not be imported but only configured. 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. 

Image Added

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.

<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>

Below configuration is shown which can export sample data, with properties, multiple qualifiers and attributes. 

The qualifier columns use the prefix again, to recognise from the external id which qualifier should be put in the column. When the qualifier is found, the prefix will be stripped from the external id.

The attribute column will check the location, parameter and qualifiers for an attribute with the configured id and export the value to the column.

<table>
	<dateTimeColumn name="DATE_SMP" pattern="dd-MM-yy HH:mm"/>
	<locationColumn name="LOC_CODE"/>
	<unitColumn name="Eenheid"/>
	<parameterColumn name="PARAMETER_ID"/>
	<qualifierColumn name="GESLACHT" prefix="GESLACHT_"/>
	<qualifierColumn name="TYPE" prefix="TYPE_"/>
	<sampleIdColumn name="SMP_CODE"/>
	<propertyColumn name="SMP_NAME" key="SMP_NAME"/>
	<propertyColumn name="COST_CODE" key="COST_CODE"/>
	<propertyColumn name="BRON" key="BRON"/>
	<attributeColumn name="Groep" id="Groep"/>
	<valueColumn name="Waarde"/>
</table>