Advanced Text Import allows to define import settings for text files with more flexibility that the standard text import functions.
The settings dialog is available from the main menu under Options -> Default Import Settings...
Into File Extension the extension of the data files, that you want to import, has to be entered.
Description may contain a short description for the data file. You could enter the name or type of the instrument that generates the data files that you want to import. There are various import methods for data in MultiSens Analyzer. The content of this field is used to identify this method whenever you import data.
Many data files contain a header that cannot easily be imported. By setting the value of Number of lines to ignore you can skip these lines during import.
Separators define how individual values are separated. Enter any charactes into List to set them as separators. Additionally Tab and Space may be activated as separators. If Ignore consecutive separators is activated a new value will only be generated, if a non separator character is read from the text file. If Ignore consecutive separators is not activated, every separator will create a new valu, that may be empty.
The Decimal Separator discrminates the integral from the fractional part in a numeral value. Either a point "." or comma "," may be chosen. If set to Automatic the first comma or point, found in the numeral value, will be taken as decimal separator. Thousands separators are not supported!
Device Name lets you set the name of the device, that is used to generate the data.
Parameters is a list of arbitrary parameters that you can add to the import. These are fixed value parameters (all imported files will have the same values (entered in this dialog).
The measurement data in the text file is expected to have the form of a two dimensional array. The format is defined under Data:
If Rows contain measurements is checked, then each row in the data array contains an independent measurement. For each sensor/device only one measurement point is included in the file. If Rows contain measurements is not checked, then only one measurement is included in the file, but for each sensor/device a complete response curve may be included.
The input grid Columns contains the definitions for the column of the data matrix in the text file. The number of columns in this grid must match the number of columns in the text file.
For each column we have to assigne a Name and optionally a Type/Unit.
Action defines what to do with the data in the column. Following actions are available:
Action | Description | Format |
Value | Sets the Value of the sensor/device. | Decimal number |
Measurement | Sets the name of the measurement. | String |
Ignore | Ignores the column. | - |
DateTime | Sets date and time of the measurement. | Date and time according to Windows language settings |
Date | Sets date of the measurement. | Date according to Windows language settings |
Time | Sets time of the measurement. | Time according to Windows language settings |
Year | Sets the year of the measurement. | number |
Month | Sets the month of the measurement. | 1 .. 12 |
Day | Sets the day of the measurement. | 1 .. 31 |
Hour | Sets the hour of the measurement. | 0 .. 23 |
Minute | Sets the minute of the measurement. | 0 .. 59 |
Second | Sets the second of the measurement. | 0 .. 59 |
Sample | Sets the name of the sample. | String |
Parameter | Sets the content of a parameter. | String |
Float Parameter | Sets the content of a parameter. | decimal number |
Integer Parameter | Sets the content of a parameter. | number |
Class | Sets the class that the measurement is assigned to | String |
Target Value | Sets the target value that the measurement is assigned to. | Decimal number |