Example xml settingsfile

<?xml version="1.0" encoding="ISO-8859-1"?>

<Definition>

                <ConnectString>

                Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Aiolos\Tmp\Export\Access_Export\Export_1.accdb;Persist Security Info=False

                </ConnectString>

                <DateTimeFormat>

                                YYYY-MM-DD HH:mm

                </DateTimeFormat>

                <!-- Query for updateble dates -->  

                <HourUpdateOK>

                </HourUpdateOK>            

                <!-- Update query -->         

                <HourUpdate>

                                UPDATE Forecasts SET %ID%=%VAL%

                                                WHERE SeriesID='%LNAME%' AND

                                                [DateTime]=#%TIME%#

                </HourUpdate>

                <!-- Query for existing hours

                                 INSERT on the rest -->     

                <HourExisting>

                                SELECT [DateTime] FROM Forecasts WHERE

                                                [DateTime] &gt;= #%FIRSTTIME%# AND

                                                [DateTime] &lt;= #%LASTTIME%# AND

                                                SeriesID='%LNAME%'

                </HourExisting>

                <!-- INSERT query-->

                <HourInsert>

                                INSERT INTO Forecasts ([SeriesID], [DateTime], %ID%)

                                                VALUES ('%LNAME%', #%TIME%#, %VAL%)

                </HourInsert>

                <ValueFormat>

                                0.00

                </ValueFormat>

                <TimeRef>

                                WALL

                </TimeRef>

                <Integration>

                                Forward

                </Integration>

</Definition>