...
Code Block | ||||
---|---|---|---|---|
| ||||
<general>
<importTypeStandard>database</importTypeStandard>
<jdbcDriverClass>com.mysql.jdbc.Driver</jdbcDriverClass>
<jdbcConnectionString>jdbc:mysql://192.168.101.215/cwb_ac</jdbcConnectionString>
<user>sobek</user>
<password>Tohek>cwa</password>
<relativeViewPeriod startOverrulable="true" endOverrulable="true" start="-1" end="1" unit="day"/>
<table name="qpe_sums_obs">
<dateTimeColumn name="rehdate"/>
<valueColumn name="rad_gz" unit="mm/hr" locationId="Qesums" parameterId="P.radar.actual" parser="Mosaic"/>
</table>
<table name="qpe_sums_fo">
<forecastDateTimeColumn name="createdate"/>
<dateTimeColumn name="raddate"/>
<valueColumn name="rad_gz" unit="mm/hr" locationId="Qpesums" parameterId="P.radar.forecast" parser="Mosaic"/>
</table>
<unitConversionsId>ImportUnitConversions</unitConversionsId>
<importTimeZone>
<timeZoneOffset>+00:00</timeZoneOffset>
</importTimeZone>
<dataFeedId>QPE_Sum</dataFeedId>
</general>
|
sftp example:
Code Block | ||||
---|---|---|---|---|
| ||||
<general> <importType>TypicalAsciiForecast</importType> <folder>sftp://wf:2004wrf@130.167.66.114:22/home/WRF</folder> <relativeViewPeriod startOverrulable="true" endOverrulable="true" start="-1" end="3" unit="day"/> <unitConversionsId>ImportUnitConversions</unitConversionsId> <importTimeZone> <timeZoneOffset>+00:00</timeZoneOffset> </importTimeZone> <dataFeedId>Forecast</dataFeedId> </general> |
...
Skips the first n lines of a ASCII file (like CSV). Error is logged when this option is configured for a binary file.
validate
Option to allow validation of the import files against the template, i.e. xml-schema. If there is no template available, this option wil be ignored.
charset
Since 2017.01 it is possible to explicitly configure the charset for text file imports, like the generalCsv import.
...