Advanced Text Import

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