Fluke Computer Accessories Appendix 2 CSV File Format, Chart CSV format, Pie chart CSV format

User’s Guide – version 3.5 NetFlow Tracker

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.

85