Overview
The ZRXP format is a ASCII data exchange file format of Wiski. The file may contain one or more time series. A more detailed description of the complete format can be found in this document wiski_zrxp3.0_en.pdf.
The time series are defined by a header line that starts with #REXCHANGE.
Directly after this keyword the ID of the time series is defined: #REXCHANGE013S050
After the keyword RINVAL the missing value is defined.
In a complete example of the header
No Format |
---|
#REXCHANGE013S050|*|RINVAL-777|*|
|
...
More recent versions of ZRXP files may contain a separate location and parameter instead of #REXCHANGE. The location is defined by the keyword SANR and the parameter by CNAME.
The CUNIT keyword defines the unit and the RINVAL the missing value.
Configuration
The configuration for importing ZRXP files is described below. It is important to note that these files may contain various ways of describing the timeseries and the locations, parameters and units corresponding to the timeseries. The following three cases can be distinguished:
...
Example of the import module instance:
No Format |
---|
<import>
<general>
<importType>WISKI</importType>
<folder>$IMPORT_FOLDER$/zrxp</folder>
....
</general>
|
Example of the id mapping in case of a time series ID:
No Format |
---|
<?xml version="1.0" encoding="UTF-8"?> <idMap version="1.1" 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/idMap.xsd"> <map internalParameter="H" internalLocation="013" externalParameter="013S050" externalLocation="013S050"/> <map internalParameter="H" internalLocation="013" externalParameter="013S065" externalLocation="013S065"/> ..... |
Example of the id mapping in case of a parameter/location combination (REXCHANGE7424_N_15):
No Format |
---|
<?xml version="1.0" encoding="UTF-8"?> <idMap version="1.1" 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/idMap.xsd"> <map internalParameter="N.obs" internalLocation="test_location" externalParameter="N" externalLocation="7424"/> ..... |
Example file
FILE WITH ONLY A TIME SERIES ID
No Format |
---|
#REXCHANGE013S050|*|RINVAL-777|*|
20081111000000 7.538
20081111002000 7.541
20081111004000 7.544
20081111010000 7.547
20081111012000 7.549
20081111014000 7.550
20081111020000 7.553
20081111022000 7.554
20081111024000 7.555
|
...
FILE WITH LOCATION, PARAMETER AND UNIT
No Format |
---|
#SANR7424|*|#SNAMEPiding|*|
#REXCHANGE7424_N_15|*|#CNAMEN|*|#CUNITmm|*|RINVAL-777|*|
20091211001500 0
20091211003000 0
20091211004500 0
20091211010000 0
20091211011500 0
|
...
FILE WITH PARAMETER, LOCATION, UNIT AND QUALIFIER ID
No Format |
---|
#TSPATH/82/82_3/WATHTE/cmd.p|*|
#LAYOUT(timestamp,value,status,interpolation_type)|*|
#TZUTC+01|*|
#CUNITm|*|
20100127000000 -0.94 200 102
20100127001500 -0.93 200 102
20100127003000 -0.93 200 102
|
...
20100227000709 3.0 200 103 => 200103
20100227000709 3.0 0 103 => 103
20100227000709 3.0 200 0 => 200000
20100227000709 3.0 200 => 200000
Example of importing directly from WISKI Kiwis service
One can directly import from a Kiwis service. Various methods are possible. The below example shows an import that downloads a pre-defined timeseriesGroup in the Wiski database by its timeseriesgroup_id for a period of the last 3 weeks in zrxp format.
Code Block | ||
---|---|---|
| ||
<general>
<importTypeStandard>wiski</importTypeStandard>
<serverUrl>https://URL/KiWIS/KiWIS?service=kisters&type=queryServices&request=getTimeseriesValues&datasource=0×eriesgroup_id=XXXXXX&period=P3W&format=zrxp&timezone=CET</serverUrl>
...
</general> |