File transfer

Specification for path to the import file. Wildcards can be used (*) as well as special characters such as %LNAME% or %RFE3%.

You may choose to move the file after it has been imported and/or to delete the import file. Save Directory indicates where imported files are to be move after import. If “leave” or nothing is indicated, the file is left where it is.

Extra 1-2

The field Extra2 applies to general settings that are common to all import formats. The field Extra1 applies to protocol-specific settings.

For the StdTextEx format protocol there are four protocol-specific settings described in the table below. The date format and time format must be in accordance with .NET’s coding standards.

The order must be as follows: datestring@numeric

Example of an Extra 1 setting for the StdText can be as follows:

yyyy-MM-dd@numeric

 

Name

Meaning

<DateString>

E.g the format of the date can be one of the following; yyMMdd, yyyyMMdd, yyyy-MM-dd or yy-MM-dd.

<numeric>

 

Numeric specifies if a column index is to be used instead of a column name.  If “@numeric” (default) is not present, the column name is used as a string.

Numeric specifies how to interpret the “Column ID”. If @numeric is present in Extra field 1 the Column ID is interpreted as a numeric index of the column and not as a string.

Note! It only works if there are no column headers.

<factor>

 

The factor that is multiplied with each value when importing. Valid values are any integer or abs, which takes the absolute value

<warnmissing>

Used to indicate that missing series in file should be considered as warnings and not be ignored.