Integration (Table-Based Exports)

Task Name

Description

Argument Template

ExportAllForecasts

Exports all Schedule Forecasts to the Export Staging Tables.

<args>

<arg name="shiftMPI" value="0" type="System.Int32" />

<arg name="Comment" value="Scheduled Export" type="System.String" />

<arg name="ExportInUTC" value="false" type="System.Boolean" />

</args>

ExportForecast

Exports a subset of Schedule Forecasts to the Export Staging Tables. Takes a filter string, e.g. CUSTOM1='Export' as a required argument.

<args>

<arg name="FilterString" value="{filterstring}" />

<arg name="shiftMPI" value="0" type="System.Int32" />

<arg name="Comment" value="Scheduled Export" type="System.String" />

<arg name="ExportInUTC" value="false" type="System.Boolean" />

</args>

ExportAllPublished Forecasts

Exports schedule published forecasts to the EXPORT_PUBLISHED_INFO and EXPORT_PUBLISHED Table.

<args>

<arg name="minBOD" value="{StartDate}" type="System.DateTime" />

<arg name="maxBOD" value="{EndDate}" type="System.DateTime" />

<arg name="shiftMPI" value="0" type="System.Int32" />

<arg name="ExportInUTC" value="false" type="System.Boolean" />

</args>

ExportPublished Forecasts

Exports schedule published forecasts based on the specified fileter (e.g. CUSTOM1=’Group1’) to the EXPORT_PUBLISHED_INFO and EXPORT_PUBLISHED Table.

<args>

<arg name="FilterString" value="{filterstring}" />

<arg name="minBOD" value="{StartDate}" type="System.DateTime" />

<arg name="maxBOD" value="{EndDate}" type="System.DateTime" />

<arg name="shiftMPI" value="0" type="System.Int32" />

<arg name="ExportInUTC" value="false" type="System.Boolean" />

</args>

ExportMTForecast

Exports an MT Scenario Forecast to the Export Staging Tables. Takes an MT Scenario ID as a required argument.

<args>

<arg name="MT Scenario" value="{scenario}" />

<arg name="shiftMPI" value="0" type="System.Int32" />

<arg name="Comment" value="Scheduled Export" type="System.String" />

<arg name="ExportInUTC" value="false" type="System.Boolean" />

</args>

ExportWeather

Exports Weather Forecasts and Actuals based on the Export field on the Weather Stations, Weather Zones, Weather Concepts, and Weather Forecast tables to EXPORT_WEATHER_INFO and EXPORT_WEATHER tables.

<args>

<arg name="IncludeActuals" value="false" type="System.Boolean" />

<arg name="shiftMPI" value="0" type="System.Int32" />

<arg name="ExportInUTC" value="false" type="System.Boolean" />

</args>

TruncateExportTables

Deletes old data out of the Export Staging Tables. Takes a required daysToKeep argument.

<args>

<arg name="daysToKeep" value="7" type="System.Int32" />

</args>