User Manual DEV 1951
56 Copyright DEV Systemtechnik GmbH 2004-2017
The actual data starts in the second line of the csv-file. Note that the time infor-
mation is stated in standard MS Excel format, i.e. the integral part of the number
defines the date (starting from 1 being the 01-Jan-1900, e.g. 43017 denotes the
date 09-Oct-2017) and the fractional part defines the time within the date
(1/(24 * 60 * 60) = 00:00:01, e.g. .66 = 15:50:24).
In the following only the first few lines of a csv-file are listed which was created by
exporting the data shown in this chapter via the button ("⌡" and "⌠"
are symbolizing that the two consecutive lines are actually one line in the file):
In 2 A RF Level Time;In 2 A RF Level Values;⌡
⌠In 2 B RF Level Time;In 2 B RF Level Values;
43017.662175925925926;-21.9;43017.578842592592593;-23.6;
43017.662291666666667;-22.0;43017.662291666666667;-23.6;
43017.662407407407407;-22.2;43017.662407407407407;-23.9;
43017.662523148148148;-22.3;43017.662523148148148;-23.9;
43017.662638888888889;-21.9;43017.662638888888889;-23.7;
43017.662754629629630;-22.1;43017.662754629629630;-23.9;
43017.662870370370370;-22.3;43017.662870370370370;-23.9;
43017.662986111111111;-22.1;43017.662986111111111;-23.7;
43017.663101851851852;-22.1;43017.663101851851852;-23.9;
43017.663217592592593;-22.1;43017.663217592592593;-23.8;
After import and formatting the "Time" columns to the format
"DD-MMM-YYYY, hh:mm:ss" this results in the following table:
Note:
The decimal separator in the csv-file is the point character ("."), this has to be
considered during the data import of the csv-file e.g. into an Excel worksheet.
For the data import into an empty MS Excel worksheet, select the tab "Data"
and there the icon "From Text". Then locate the csv-file and follow the instruc-
tions of the text import wizard.
The correct time information is dependent on the proper configuration of a
timeserver and of the timezone. The settings can be applied via the network
setup of the Setup Tab (chapter 5.5.7.2.1).
If no timeserver is configured for the device, the recording of the data starts at
01-Jan-2000, 00:00:00; after a device reset the time is reset to 01-Jan-2000,
00:00:00 as well, but the recording of the data is continued with the time of the
last sample.
If a timeserver was configured for the device that is not available anymore after
a reset, the recording of the data is continued with the time of the last sample
as well. Otherwise, if the timeserver is available after a device reset, the
recording of the data is continued with the correct time; i.e. this causes a time
gap within the data.
To Next Page
Loading...