CSV Import


This filter allows to import comma separated text files.
Rows that only contain comma "," separated numbers (or decimal numbers) are treated as measurement data. Each number is assigned to a sensor/device. The number of sensors/devices is automatically matched to the numbers available in the longest row.

The decimal separator for decimal numbers is a point ".".

Rows that start with a string (something that cannot be interpreted as a number) will assign following parameters / information:

String Description
DATE Sets the date and time of the measurement. The format needs to follow the Windows language settings.
DEVICE Sets the name of the device used for the measurement.
SAMPLE Sets the name of the sample.
SENSORS Sets the names of the sensors/devices. The remaining comma separated fields in the line are assigned the the sensors/devices.
SOURCE Sets the source of the sample.
Sensor Number Sets the names of the sensors. The remaining comma separated fields in the line are assigned the the sensors.
Also sets the device in the measurement to Aromascan.
Time Interval Sets the parameter Time Interval.
Purge Humidity Sets the parameter Purge Humidity.
Reference Humidity Sets the parameter Reference Humidity
Base Resistances Sets the parameter Base Resistance for each sensor.
any other string Creates a new parameter and sets the name to this string. Reads the next value from the line and sets the value of the parameter.

Example:

DEVICE,ENose 100
DATE,10/10/2008 17:29:04
SAMPLE,Soya Bean
SENSORS,S1,S2,S3,S4
1.23,4.54,2.15,3.29
2.78,2.96,3.01,3.45
4.89,2.22,5.23,3.08
5.21,3.87,3.68,5.12