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 measurements.
Time according to Windows language settings
Year
Sets the year of the measurements.
Number
Month
Sets the month of the measurements.
1 .. 12
Day
Sets the day of the measurements.
1 .. 31
Hour
Sets the hour of the measurements.
1 .. 23
Minute
Sets the minute of the measurements.
0 .. 59
Second
Sets the second of the measurements.
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
