...
Exports time series data to files in CSV format with one header line containing column headers. The import type is generalCSV.
Example
Here is an example:
No Format |
---|
DATE_SMP;LOC_CODE;Eenheid;PARAMETER_ID;PAR_REF;PROD_CODE;ANAL_CODE;TYPE;SMP_CODE;COST_CODE;Groep;Waarde 01-01-81 00:00;MBP012;-;TansleyS_PTB;Nymphoides peltata;OW;PTB;gemeten;713;ECOLDOEL;ANGIO;4.0 01-01-81 00:00;MBP012;-;TansleyS_PTB;Phragmites australis;OW;PTB;gemeten;713;ECOLDOEL;ANGIO;8.0 01-01-81 00:00;MBP012;-;TansleyS_PTB;Polygonum amphibium;OW;PTB;gemeten;713;ECOLDOEL;ANGIO;4.0 01-01-81 00:00;MBP012;-;TansleyS_PTB;Polygonum persicaria;OW;PTB;gemeten;713;ECOLDOEL;ANGIO;1.0 01-01-81 00:00;MBP044;-;TansleyS_PTB;Nymphaea alba;OW;PTB;gemeten;712;ECOLDOEL;ANGIO;8.0 01-01-81 00:00;MBP044;-;TansleyS_PTB;Phragmites australis;OW;PTB;gemeten;712;ECOLDOEL;ANGIO;8.0 01-01-81 00:00;MBP044;-;TansleyS_PTB;Polygonum amphibium;OW;PTB;gemeten;712;ECOLDOEL;ANGIO;4.0 01-01-81 00:00;MBP044;-;TansleyS_PTB;Polygonum persicaria;OW;PTB;gemeten;712;ECOLDOEL;ANGIO;1.0 |
...
Code Block | ||||
---|---|---|---|---|
| ||||
<timeSeriesExportRun xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/timeSeriesExportRun.xsd">
<export>
<general>
<serializerClassName>nl.wldelft.fews.system.plugin.dataExport.GeneralCsvTimeSeriesSerializer</serializerClassName>
<folder>$EXPORT_FOLDER$/HydroBiologie</folder>
<exportFileName>
<name>ExportGeneralCsv.csv</name>
</exportFileName>
<table>
<dateTimeColumn name="DATE_SMP" pattern="dd-MM-yy 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="TYPE" prefix="TYPE_"/>
<sampleIdColumn name="SMP_CODE"/>
<propertyColumn name="SMP_NAME" key="SMP_NAME"/>
<propertyColumn name="COST_CODE" key="COST_CODE"/>
<attributeColumn name="Groep" id="Groep"/>
<valueColumn name="Waarde"/>
</table>
<idMapId>IdExport_HydroBiologie</idMapId>
<exportMissingValueString>-9999.0</exportMissingValueString>
</general>
<timeSeriesSet>
...
</timeSeriesSet>
<timeSeriesSet>
...
</timeSeriesSet>
</export>
</timeSeriesExportRun>
|
For more information of the table layout configuration see Table Layout
Details of the import format
...