Xylem SonTek FlowTracker2 - 12.2.2 CSV Variables

SonTek – a Xylem brand
FlowTracker2 User’s Manual (January 2019)
207
12.2. FlowTracker2 CSV Output
Comma Separated Values (CSV) file format is a basic output designed for easy access
and interpretation of the data with the most common variables of FlowTracker2
incorporated.
The variables included in the CSV format are similar to Original FlowTracker2 ASCII
exports and existing users will be familiar with the layout and content.
CSV File Structure 12.2.1
The Comma Separated Values files created during the export process consists of four
CSV files, defined by unique file name that summarizes the content of the file as
described in Table 12:1.
Table 12-1 - CSV File Types
File
Name
Description
Data Layout
ctl
Control
System configuration data
Rows
dat Raw Data
Raw, one-second velocity and SNR
data
Columns
dis Discharge
Final data results in a self-
explanatory form that is easy to
integrate with database utilities
Rows,
Columns
sum Summary
Velocity and quality control data from
all measurements
Columns
The layout of the data in each of the CSV files is organized based on Rows, Columns or
a combination of both. The data descriptions for the Row or Column layout are defined
in Table 12:2.
The Desktop Software Build Version is written in the first row of each CSV file
independent if the file layout is based on Row or Columns. The units included for each
variable in the CSV files are separated from the file name and data.
Table 12-2 - CSV Row and Column
Type
Number
Description
Row \ Column
1
st
Row contain Desktop Software Build version
Column
2
nd
Row contain the variable \ parameter name
3
rd
Row contain the units
4
th
Row contain the first data line
Row
2
nd
Column contain variable \ parameter name
3
rd
Column contain the units
4
th
Column contain X component or Beam 1
5th
Column contain Y component or Beam 2