exporter - export timeseries from WISKI

NAME

exporter - export timeseries from WISKI

COPYRIGHT

Copyright (C) 2012-2021 TBBM <https://www.tbbm.at>

SYNOPSIS

exporter.pl [options] -iniFile [file]

OPTIONS

General Options

-java

Path to java executable.

-wiskiPlotMap

Path to WiskiPlotMap jar file.

-h

Print a brief help message and exits.

-help

Prints the manual page and exits.

-logLevel

Sets the log level: DEBUG, DEBUG, WARN, ERROR, defaults to INFO.

-logDir

Sets the directory to store the log files, defaults to ./logs.

Configuration based

-iniFile

The EXPORTER config file, such as:

    [EXPORTER]
    groupPurpose =              # Gruppenzweck in WISKI
    group =                     # Gruppe in WISKI
    filename =                  # Dateiname, kann über variablen festgelegt werden
    days =                      # Angabe von days als Exportintervall (bis aktueller Zeitpunkt)
    fullDays =
    format =
    interval =
    dateTimeFormatter =
    timezone =
    numberPattern =
    dataLinePattern =
    decimalSeparator =
    fieldSeparator =
    no_header =
    headerOncePerFile =
    headerTemplate =
    transformation =
    missingValue =
    lastEntry =
    skipRemainingMissingValues =
    path =
    config =
    configOverride =

Unicode escape characters are evaluated. For instance, use \u0020 for a space.

Variablen für Header, DataLine Pattern oder Dateinamen Generierung:
    Allgemeiner Variablen:
    
    WTO_OBJECT          Gewässername
    GAUGE_DATUM         Pegelnullpunkt der Stations
    GWREF_DATUM         Messpunkthöhe der Station
    altitude            Stationshöhe
    number              Stationsnummer
    station.number      Stationsnummer
    name                Stationsname
    station.name        Stationsname
    parameter           Parametername
    timeseries          Zeitreihenname
    datetime            Zeitstempel
    value               Wert
    value.status        Status des Werts
    absvalue            Wert der Absolutspalte
    absvalue.status     Status der Absolutwertspalte
    
    Wiski Spezifische Variablen:
    
    Kurzname des Stammdatenfelds in WISKI (z.b. HYDAMS_Nummer, STA_ATTR_OWNER,...)

EXAMPLES

ZRXP Export from timeseries groups

    [EXPORTER]
    groupPurpose = Datenlieferungen
    group        = export-HD-Oberoesterreich
    filename     = ftp://YYYYYY:DDDDDDDDDDDD@ftp.lfrz.at/HD-HD/Salzburg/Pegel/OOEExport.zrx
    fullDays     = 2
    

RESULT

    #ZRXPCREATORWiskiPlotMap|*|
    #SNAMESalzburg (Nonntaler Brücke)|*|
    #SANR204180|*|
    #RINVAL-777|*|
    #CUNITm³/s|*|
    #CNAMEQ|*|
    #TSPATH/177531/204180/Q/15m.Cmd.RunOff|*|
    #REXCHANGE204180_Q|*|
    #SWATERSalzach|*|
    20200303000000 120.75
    20200303001500 116.75
    20200303003000 108.75
    ...
    20200304234500 -777
    20200305000000 -777
    
    #ZRXPCREATORWiskiPlotMap|*|
    #SNAMESalzburg (Nonntaler Brücke)|*|
    #SANR204180|*|
    #RINVAL-777|*|
    #CUNITcm|*|
    #CNAMEW|*|
    #TSPATH/177531/204180/W/15m.Cmd.WiskiWeb|*|
    #REXCHANGE204180_W|*|
    #SWATERSalzach|*|
    20200303000000 205
    20200303001500 204
    ...
        

Hydams-Export with header Template

    [EXPORTER]
    groupPurpose = Datenlieferungen
    group        = export-HyDaMS-NLV-LT
    filename     = //lcfs06/o/Hydro_Importdaten/NLV/LT.ascii
    fullDays     = 38
    missingValue = \u0020
    headerTemplate = J:/Data/wiski/ini/HyDaMS_NLV_LT.tmpl.txt
    dateTimeFormatter = dd.MM.yyyy HH:mm:ss
    numberPattern = 0.00
    

benötigt eine headerTemplate Datei:

    BEGIN 
    Parameter: Temperatur
    Ort: {WISKIZA_DBMS_Nr}
    DefArt: K
    Herkunft: O
    Quelle: 
    Reihenart: Z
    Version: 0
    X: 0
    Y: 0
    Einheit: {unit}
    Messgenau: 
    FToleranz: 
    NWGrenze: 
    Kommentar: {station.number}-Datensammlerwerte
    Hoehe: 0
    Werte: 
    

RESULT:

    BEGIN 
    Parameter: Temperatur
    Ort: 5002171
    DefArt: K
    Herkunft: O
    Quelle: 
    Reihenart: Z
    Version: 0
    X: 0
    Y: 0
    Einheit: °C
    Messgenau: 
    FToleranz: 
    NWGrenze: 
    Kommentar: 104240-Datensammlerwerte
    Hoehe: 0
    Werte: 
    27.01.2020 00:00:00 1.00
    27.01.2020 00:15:00 1.20
    27.01.2020 00:30:00 0.50
    27.01.2020 00:45:00 0.60
    ...
    04.03.2020 23:30:00  
    04.03.2020 23:45:00  
    05.03.2020 00:00:00  
    
    BEGIN 
    Parameter: Temperatur
    Ort: 5002169
    DefArt: K
    Herkunft: O
    Quelle: 
    Reihenart: Z
    Version: 0
    X: 0
    Y: 0
    Einheit: °C
    Messgenau: 
    FToleranz: 
    NWGrenze: 
    Kommentar: 104224-Datensammlerwerte
    Hoehe: 0
    Werte: 
    27.01.2020 00:00:00 -0.10
    27.01.2020 00:15:00 -0.10
    27.01.2020 00:30:00 0.10
    ...
    
    

OGD export of timeseries data

    [EXPORTER]
    groupPurpose = Datenlieferungen
    group        = export-OGD-Seen
    filename     = //lcfs06/n/204ogd/Hydrographische Messdaten[3c589dc0-35ed-48cf-b598-428e4588b19c]/data/Hydrografie.txt
    fullDays     = 1
    missingValue = --
    no_header    = 1
    dateTimeFormatter = yyyy.MM.dd HH:mm
    dataLinePattern   = {name};{WTO_OBJECT};{GAUGE_DATUM};{GWREF_DATUM};{datetime};{value}{unit};{WISKIZA_Koord_RW};{WISKIZA_Koord_HW}
    numberPattern = 0.0
    

RESULT:

    Zell am See (Seepegel);Zeller See;2020.03.04 00:00;189.0cm;409750;242790
    Zell am See (Seepegel);Zeller See;2020.03.04 00:15;189.0cm;409750;242790
    Zell am See (Seepegel);Zeller See;2020.03.04 00:30;189.0cm;409750;242790 
    ...
    Obertrum (Seepegel);Obertrumer See;2020.03.04 00:00;4.5°C;430370;311630
    Obertrum (Seepegel);Obertrumer See;2020.03.04 06:00;4.3°C;430370;311630
    ...
    

Export von Absolutwertspalte und Status des Absolutwerts mit Rundung:

    [EXPORTER]
    path = CH/HG2060/W/15m.Cmd.RelAbs.O
    interval = P1Y/now
    dateTimeFormatter = yyyy.MM.dd HH:mm
    dataLinePattern   = {datetime} {absvalue} {absvalue.status}
    numberPattern = 0.0
    

Export of timeseries data in SMET Format for snowpack

    [EXPORTER]
    groupPurpose = Export
    group = Export-Infra.Wetter-Snowpack
    filename = F:/Datenmanagement/export/oebb_infra_wetter_smet/{LWD-Nummer:-number}.smet.gz
    interval = 2019-09-01/now
    config = F:/Datenmanagement/ini/export_oebb_smet.properties
    numberPattern = 0.###
    missingValue = -999
    format = SMET
    

benötigt eine SMET-Konfiguration

RESULT:

    SMET 1.1 ASCII
    [HEADER]
    station_id = SOBP1
    station_name = Schoberpass Windstation
    latitude = 47.4421
    longitude = 14.6375
    altitude = 1893.0
    source = 
    nodata = -999
    creation = 2020-03-04T14:11:34.771285Z
    fields = timestamp RH TA VW VW_MAX DW
    #parameters = timestamp LF LT WG WG.Boe WR
    #units = ISO8601 1 K m/s m/s °
    [DATA]
    2019-08-31T22:00:00Z 0.829 286.15 9.01 11.72 195
    2019-08-31T22:10:00Z 0.832 286.25 6.63 8.53 200
    2019-08-31T22:20:00Z 0.829 286.25 5.3 7.56 197
    2019-08-31T22:30:00Z 0.836 286.15 4.26 5.44 204
    ...
        
 exporter - export timeseries from WISKI