Halytech
hydroSpider2 User’s Manual v1.23
Page 120
Appendix I.
Report Formats
Report data is sent as a comma separated value (CSV) file, with the extension “.csv”. This is a very
simple file type which can be opened using spreadsheet software (eg: Microsoft Excel), read directly
with any text editor, or even easily parsed using custom software.
The hydroSpider has a number of report formats which can be selected to suit the application/user
requirements. Each format is described below along with a sample snippet of the report format for
illustration purposes.
Appendix I1.
Report File Names
Reports files will be named to reflect the type of report, format of the data, and the date and time it
was triggered:
Daily
<location>
_
<format>
D_
<date>
.csv
Periodic
<location>
_
<format>
P_
<date>
_
<time of trigger>
.csv
Requested (current day’s data)
<location>
_
<format>
A_
<date>
_
<time of request>
.csv
Requested (previous data)
<location>
_
<format>
A_
<date report starts>
.csv
Where:
<location>
is the first 18 characters of the hydroSpider’s location name
<format>
is the character representing the format of the report (R for raw, F for filtered, D for
diagnostic, M for multi-column, S for user ID)
<date>
is the date of the report in the format ddmmyy
<time of trigger>
is when the report transmission was triggered in the format HHmm
<time of request> is when the report was requested by the user in the format HHmm
<date x days ago>
is the date that the report starts from in the format ddmmyy
Note
that spaces in the location part of the filename will be replaced by ‘-‘ characters.
For example
: a raw daily report that was sent on the 6
th
December 2013 from a hydroSpider with
location name ‘my hydroSpider’ will have the following name:
“my-hydroSpider_RD_061213.csv”
For example
: a multi-column daily report that was sent on the 6
th
December 2013 at 12:00 from a
hydroSpider with location name ‘my HydroSpider’ will have the following name:
“my-hydroSpider_MP_061213_1200.csv”
For example
: a diagnostic report of the last 24 hours of data is requested from the hydroSpider. The
hydroSpider has its location name set to “my hydroSpider”, and the report was requested on the 6
th
December 2013 at 11:33am. The report’s name will be:
“my-hydroSpider_DA_061213_1133.csv”
For example
: a filtered report of the last 3 days of data is requested from the hydroSpider. The
hydroSpider has its location name set to “my hydroSpider”, and the report was requested on the 6
th
December 2013. The report’s name will be:
“my-hydroSpider_FA_031213.csv”
