...
With the use of id mapping, this prefix helps mapping to the correct qualifiers ssing using a qualifier id function <qualifierIdFunction externalQualifierFunction="@ExternalQualifierId@"/> and qualifiers configured in a csv file:
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<csvFile> <file>analyse_code.csv</file> <id>%qualifierId%</id> <name>%qualifierName%</name> <attribute id="ExternalQualifierId"> <text>ANAL_CODE_%qualifierId%</text> </attribute> </csvFile> |
With the use of the above configuration it will be possible to export the qualifiers to the same columns again using the same qualifier if function <qualifierIdFunction externalQualifierFunction="@ExternalQualifierId@"/> and "prefix" attributes in the qualifier columns in the export xml:
| Code Block | ||||
|---|---|---|---|---|
| ||||
<general>
<exportType>generalCsv</exportType>
<folder>$EXPORT_FOLDER$/HydroBiologie</folder>
<exportFileName>
<name>ExportGeneralCsv.csv</name>
</exportFileName>
<table>
<dateTimeColumn name="DATE_SMP" pattern="dd-MM-yyyy HH:mm"/>
<locationColumn name="LOC_CODE"/>
<unitColumn name="Eenheid"/>
<parameterColumn name="PARAMETER_ID"/>
<qualifierColumn name="PAR_REF" prefix="PAR_REF_"/>
<qualifierColumn name="PROD_CODE" prefix="PROD_CODE_"/>
<qualifierColumn name="ANAL_CODE" prefix="ANAL_CODE_"/>
<qualifierColumn name="METH_ANAL" prefix="METH_ANAL_"/>
<qualifierColumn name="METH_SAMP" prefix="METH_SAMP_"/>
<qualifierColumn name="TYPE" prefix="TYPE_"/>
<sampleIdColumn name="SMP_CODE"/>
<propertyColumn name="SMP_NAME" key="SMP_NAME"/>
<propertyColumn name="COORD_X_S" key="COORD_X_S"/>
<propertyColumn name="COORD_Y_S" key="COORD_Y_S"/>
<propertyColumn name="EMP_NR_S" key="EMP_NR_S"/>
<propertyColumn name="EMP_NR_A" key="EMP_NR_A"/>
<propertyColumn name="BRON" key="BRON"/>
<valueColumn name="Waarde"/>
</table>
<idMapId>IdExport_HydroBiologie</idMapId>
</general> |
Details of the import format
...