CSV 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:

ActionDescriptionFormatValueSets the Value of the sensor/device.Decimal numberMeasurementSets the name of the measurement.StringIgnoreIgnores the column.-DateTimeSets date and time of the measurement.Date and time according to Windows language settingsDateSets date of the measurement.Date according to Windows language settingsTimeSets time of the measurement.Time according to Windows language settingsYearSets the year of the measurement.numberMonthSets the month of the measurement.1 .. 12DaySets the day of the measurement.1 .. 31HourSets the hour of the measurement.0 .. 23MinuteSets the minute of the measurement.0 .. 59SecondSets the second of the measurement.0 .. 59SampleSets the name of the sample.StringParameterSets the content of a parameter.StringFloat ParameterSets the content of a parameter.decimal numberInteger ParameterSets the content of a parameter.numberClassSets the class that the measurement is assigned toStringTarget ValueSets the target value that the measurement is assigned to.Decimal number