Overview
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:
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
for configuration of the table layout see
Table Layout
<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>
Details of the import format
If the first line contains a comma, the decimal separator is taken to be a period (.), otherwise it is supposed to be a semicolon (;) and the decimal separator is taken to be a comma. This way locale-specific CSV files are supported.
The field separator is either a comma or a semicolon. Tabs are not supported.