User Manual DEV 2194
Copyright DEV Systemtechnik GmbH 2013-2017 27
The actual data starts in the second line of the csv-file. Note that the time
information 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. 42917
denotes the date 01-Jul-2017 and the fractional part defines the time within the
date (1/(24 * 60 * 60) = 00:00:01, e.g. .575 = 13:48:00).
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):
Amp 1 RF Level Time;Amp 1 RF Level Values;⌡
⌠Amp 2 RF Level Time;Amp 2 RF Level Values
42917.568773148148148;-18.5;42917.568773148148148;-17.7;
42917.569467592592593;-18.5;42917.569467592592593;-17.8;
42917.570162037037037;-18.5;42917.570162037037037;-17.8;
42917.570856481481481;-18.5;42917.570856481481481;-17.7;
42917.571550925925926;-18.5;42917.571550925925926;-17.8;
42917.572245370370370;-18.5;42917.572245370370370;-17.8;
42917.572939814814815;-18.5;42917.572939814814815;-17.8;
42917.573634259259259;-18.5;42917.573634259259259;-17.8;
42917.574328703703704;-18.5;42917.574328703703704;-17.8;
42917.575023148148148;-18.5;42917.575023148148148;-17.8;
42917.575717592592593;-18.5;42917.575717592592593;-17.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 time zone. The settings can be applied via the network
setup of the Setup Tab (chapter 5.4.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, which 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...