XML Element

Default

Function

ConnectString

Must exist

Connect string to the database

DateTimeFormat

YYYY-MM-DD HH:nn

Date & time format. Same syntax as VB6 used. This is used to format date-time variables before they are substituted into the SQL statement.

HourUpdateOK

Optional

This is a statement sent to the database to return all the hours that are ok to update. If this tag is missing no statement is sent to the database and all values are exported.

HourUpdate

Must exist

SQL statement to UPDATE values in the database

HourExisting

Must exist

SQL statement to check which values already exist in the database. These hours are UPDATED, the hours not returned by this statement are INSERTED

HourInsert

Must exist

Statement to INSERT values for the hours that don’t exist in the database from before

ValueFormat

(empty) = all decimals

Format specification of the values. VB6 syntax: # as a placeholder for digits that can be left out, 0 as a placeholder for digits that can’t be left out. Example; 0.0 = one decimal and leading zero

TimeRef

WALL

What time reference is used in the database. Possible time references are UTC, Standardtime or day-light saving (=wall-clock time). Values used in the file are: UTC, NORM, WALL

Integration

Backward

Describes if an hour should be marked with the start or end time. Possible values; FORWARD or BACKWARD.

Forward means the hour is marked with the starting time. Backward means the hour is marked with the ending time.

PreExport

Optional

Statements sent before the export is completed. Several statements can be separated with a vertical bar |

PostExport

Optional

Statements sent after the export is completed. Several statements can be separated with a vertical bar |

IsDayRecord

Optional, default: False

Value: True or False

Indicatets weather the export is to be made to a database containing 24 values per record.