Name

Description

Valid values

Default value

/source

The source to import fractions from, either a file or a database.

Complete filepath to either the importfile or the databasefile describing the connectionstring, etc.

<none>

/type

Determines if the source if a file or a database to import from.

File, database

file

/fileformat

Determines if the importformat is either POWELMSC or VSTORE-format. Only works when importing from a file.

Powelmsc, Vstore, Delfor

vstore

/keypattern

Determines where in the seriesname you should check the ID against. Default value is start position 1 and length 3, e.g. 1;3

Any combination of Integer;integer

1;3

/stringpattern

Determines where in the ID-field in the source you should get the ID from. Default value is start position 1 and length 3, e.g. 1;3

Only used for file imports.

Any combination of Integer;integer

1;3

/namepattern

Determines a substring that should be added to the ID-field in source when comparing the ID in config. Use % to specify where the ID should be in the string.

e.g. ‘Profil_%’

Cannot be combined with keypattern

Any string value containing %

<none>

/copy

Determines if the files should be copied to the specified folder after the import is done. The folder is always named BAK and is located in the same directory as the importfiles.

True,false

false

/delete

Determines if the files should be deleted after the import is done.

True;false

false

/loadpartcode

Determines the code used both for high and low values in the file. Should only be set if high and low values aren't used. Only works for Powelmsc.

Integer

<none>

/loadlosscode

Determines the code used both for high and low losses in the file. Should only be set if high and low values aren't used. Only works for Powelmsc.

Integer

<none>

/onevalue

Specify if only one of the column values should be saved. Valid values are ‘Hi’, ‘Lo’, ‘FacHi’, ‘FacLo’, ‘DivHi’, ‘DivLo’

String

<none>

/supplierpattern

This only applies to the DELFOR format. This is used to extract part of the supplier identifier for use as the supplier code.

String

<none>

Name

Description

Connect

This contains the connect string to the database.

SQL

This node should contain the SQL query to be sent to the database. You can use the variables #THISMONTH# and #NEXTMONTH# in the SQl statement. These variables are replaced with the current date before the query is sent to the database. #THISMONTH# is replaced with the current month and #NEXTMONTH# is replaced with the next month.
The format is YYYY-MM-DD

RSTYPE

This tells the import program what format the fractions have from the database. The following exist today:
OneRowPercent means that one row contains all information for one combination of area, supplier and balance-responsible. The result set from the query should start with exactly these 6 columns in the following order;
NetAreaCode (NHA), Balance responsible, Supplier, Start of the period (2006-11-01), fraction high price time in percent (12,3% should come as 0,123), fraction low price time in percent
TwoRowsPercent means that the information for one net area, balance responsible and supplier are on two rows. Every row should then start with exactly the following 5 columns in this order;
NetAreaCode (NHA), Balance responsible, Supplier, Start of the period (2006-11-01), fraction in percent (12,3% should come as 0,123). Two consecutive rows must be for the same combination of area, supplier and balance-responsible and the first row should be the high price fraction.
TwoRowsAbsoluteSingle means that one must question the percentage figures in absolute terms. A combined network area & balance & supplier responsible and in this case in two lines (rows). Percentage item should come first, then the total record. Each entry must therefore contain the following fields in exactly that order; area, balance manager, supplier, period, value.

Provider

Name of what database provider that should be used. For SQL server the OLEDB provider is called SQLOLEDB.

Dateformat

The format of the date in the database. Used by the import to parse the datevalue in the fractions.