User’s Guide – version 3.5
NetFlow Tracker
85
Appendix 2: CSV File Format
Every standard chart and tabular report can be converted to comma-separated-value
format for importing into a database server or spreadsheet.
Chart CSV format
Each section is separated by a row of “=” signs. The first section is the chart title; the
second is the time range and filter.
Each subsequent section represents a single chart, equivalent to the tabs above the
chart in interactive mode. The first line of the section is the name of the chart. The
next two rows contain the start and end time of each sample in milliseconds UTC. Each
has an empty column at the start to accommodate the description of each data row
below. Each data row consists of a description followed by a usage, octet count or
packet count for each sample.
Pie chart CSV format
Each section is separated by a row of “=” signs. The first section is the chart title; the
second is the time range and filter.
Each subsequent section represents a single chart, equivalent to the tabs above the
chart in interactive mode. The first line of the section is the name of the chart, followed
by a row for each charted element consisting of a description followed by a usage,
octet count or packet count.
Tabular report CSV format
Each section is separated by a row of “=” signs. The first section is the report title; the
second is the time range and filter.
The third section starts with the title of each column, separated by a comma. Each
subsequent line in the section is a row with each value separated by a comma, and
text values contained within double quotes. There are several differences between a
report viewed in a browser and one converted to CSV; in CSV format all rows are
included, information normally available by hovering the mouse over a label is
unavailable, and traffic and packets passed are output as simple counts rather than
rates.
The fourth section contains column totals, again separated by commas. There will
usually be empty values in the total row corresponding to non-numeric columns.
