User’s Guide – version 3.1.3 NetFlow Tracker

82

Appendix 2: CSV File Format
Every standard chart and tabular report can be conver ted to comma-separated-value
format for importing into a database server or spreads heet.

Chart CSV format

Each section is separated by a row of “=” signs. The first s ection is the chart title; the
second is the time range and filter.
Each subsequent section represents a single chart, eq uivalent to the tabs above the
chart in an interactive chart. If a utilization chart is present it will be included in the
CSV file but with identical data to the traffic rate chart. The first line of the section is
the name of the chart. The next two rows contain the star t 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 con sists of a description
followed by an octet or packet count for each sample.

Tabular report CSV format

Each section is separated by a row of “=” signs. The first s ection 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 sep arated by a comma, and
text values contained within double quotes. There ar e several differences between a
report viewed in a browser and one converted to CSV; in CS V format all rows are
included, information normally available by hoverin g the mouse over a label is
unavailable, and traffic and packets passed are outp ut as simple counts rather than
rates.
The fourth section contains column totals, again se parated by commas. There will
usually be empty values in the total row corresponding to no n-numeric columns.