...
Code Block | ||||
---|---|---|---|---|
| ||||
<?xml version="1.0" encoding="UTF-8"?> <timeSeriesImportRun 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/timeSeriesImportRun.xsd"> <import> <!--QPEsums Actuals and Forecast--> <general> <importTypeStandard>database</importTypeStandard> <jdbcDriverClass>com.mysql.jdbc.Driver</jdbcDriverClass> <jdbcBinDir>$REGION_HOME$\Modules\jdbc</jdbcBinDir> <jdbcConnectionString>jdbc:mysql://myhost/cwb_ac</jdbcConnectionString> <user>?</user> <encryptedPassword>?</encryptedPassword> <relativeViewPeriod startOverrulable="true" endOverrulable="true" start="-1" end="1" unit="day"/> <table name="qpe_sums_obs"> <dateTimeColumn name="recdate"/> <valueColumn name="rad_gz" unit="mm/hr" locationId="Qpesums" parameterId="P.radar.actual" parser="Mosaic"/> </table> <table name="qpe_sums_foc"> <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_Sums</dataFeedId> </general> <timeSeriesSet> <moduleInstanceId>Import_Qpesums</moduleInstanceId> <valueType>grid</valueType> <parameterId>P.radar.actual</parameterId> <locationId>Qpesums</locationId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="minute" multiplier="10"/> <readWriteMode>add originals</readWriteMode> <expiryTime unit="day" multiplier="14"/> </timeSeriesSet> <timeSeriesSet> <moduleInstanceId>Import_Qpesums</moduleInstanceId> <valueType>grid</valueType> <parameterId>P.radar.forecast</parameterId> <locationId>Qpesums</locationId> <timeSeriesType>external forecasting</timeSeriesType> <timeStep unit="nonequidistant"/> <readWriteMode>add originals</readWriteMode> <expiryTime unit="day" multiplier="2"/> </timeSeriesSet> </import> </timeSeriesImportRun> |
userColumn
Since 2016.02 there is a column that allows for specifying a user with each data point.
Code Block | ||||
---|---|---|---|---|
| ||||
<table>
<dateTimeColumn name="DATE" pattern="dd-MM-yy HH:mm"/>
<locationColumn name="LOC"/>
<unitColumn name="UNIT"/>
<parameterColumn name="PARAM"/>
<valueColumn name="VALUE"/>
<userColumn name="USER"/>
</table>
|