Import file: Specification for path to the import file. Wildcards can be used (*) as well as special characters such as %LNAME% or %REF3%.
You may choose to move the file after it has been imported and/or to delete the import file. Import Directory indicates where imported files are to be move after import. If “leave” or nothing is indicated, the file is left where it is.
Transfer import file: Not used
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@timeformat@regex@numeric
Example of an Extra 1 setting for the StdTextEx can be as follows:
yyyy-MM-dd@HH:mm@(\d{4}-\d{2}-\d{2})\s?(\d{2}:\d{2})?@numeric
|
Name |
Meaning |
|
<DateString> |
If no date format is specified, an attempt is made to use the date string yyyyMMdd. |
|
E.g the format of the hour/time of day can be one of the following; HH, HH:mm:ss | |
|
<regex>
|
“regex” is what is termed a “regular expression” that picks out the components that are a date or a time. It is important that the regex expression has two groups, the first for date and the second for time. The program “The RegEx coach” is recommended for building and debugging regular expressions. Examples for regex setting: (\d{4}-\d{2}-\d{2})\s?(\d{2}:\d{2})? For a date such as ’2015-06-09 16:30’ Or (\d{4}-\d{2}-\d{2})\s?(\d{2}:\d{2}:\d{2})? For a date such as ’2014-10-21 17:39:12’ |
|
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! Works only when no column header. | |
|
<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. |