Manual v1.7 – Nov 2017 © Utilivista Ltd. 2017 24
The first column of all rows of data is a timestamp, showing the date (in your chosen date format) and the
time (HH:MM:SS).
Data in the columns after this is written as numbers (without any characters separating thousands), with
the number of decimal places used being dependent on 1) the type of field this is measuring, if a C2i
input, or 2) the specified number of decimal places for that register, if a Modbus input.
There will be one row in the CSV file for each timestamp for which data was sampled for any of the
inputs that the CSV file is for. The CSV file will only apply to a specific range e.g. the latest 24 hours.
6.4.2 - Downloading a one-off CSV file
To download a CSV file:
1.
Open the
Diagnostics
folder from the menu then click
Data
.
2.
Use the check boxes for device and input type to select which combination of devices and
input types you are interested in.
3.
Click the
CSV Download
link below the checkboxes.
4.
Select a start date and (inclusive) end date.
5.
Use either the
Download CSV File
link or the
No Timeout Download
link. The first of these
will take no longer than a few minutes but if you have requested lots of data (e.g. 100,000
values in total) the file may be incomplete. (In this case the filename will indicate that it is
incomplete). The second of these can take an unlimited length of time and will always give a
complete file with all the data you are requesting.
If your browser shows a security bar asking you to confirm download of the file, click to
Confirm
. You
may then have to do the previous step again.
6.4.3 - Description of scheduled CSV reports
A report can be scheduled so that data relating to a user defined combination of devices and input types
is emailed and / or uploaded via FTP, at a defined frequency.
The input types you can select from are:
•
C2i Inputs:
Voltage
(If applicable you can select just Max, Min or Average. See Section 5.7.2, P16)
.
Current
Temperature
Status / Pulse
4-20 mA
•
Modbus Inputs (can be combined in the same report):
Discrete Coils
Discrete Inputs
Holding Registers
Input Registers
