This article describes the Fleet CSV Export format
This format is for the Fleet CSV Export feature and is different to the Dashboard Data Export formats. Please refer to the Dashboard User Guide for information on the other formats available.
The Wattwatchers Fleet CSV Export format contains the following columns and data format
- device_id - the unique serial number of the Wattwatchers device
- interval_start - the local timestamp (Taken from the user's computer time) at the start of the interval period. This field is adjusted for the local timezone of the device
- interval_end - the local timestamp (Taken from the user's computer time) at the end of the interval period. This field is adjusted for the local timezone of the device
- duration - length of the interval
- timestamp - the unix epoch system timestamp for the interval period. As unix epoch is defined by GMT/UTC, this field is not adjusted for the local timezone of the device.
Groups of channel data for each of the 6 channels of the device (where x = 1 to 6)
- Cx_category - the category of the circuit as defined by the following list:
- Not Set
- Not connected
- Grid connect
- Lighting & Power
- Pool pump
- Air conditioning
- Solar generation
- Hot water
- Electric vehicle
- Battery
- Oven
- Lighting
- Power
- Hybrid solar & battery system
- Cx_label - the free-text user assigned label for the circuit
- Cx_ereal_kWh - net real (active) energy (kWh)
- Cx_erealpositive_kWh - real (active) energy in the positive (import) direction (kWh)
- Cx_erealnegative_kWh - real (active) energy in the negative (export) direction (kWh)
- Cx_ereactive - net reactive energy (kvarh)
- Cx_ereactivepositive - reactive energy in the positive (import) direction (kvarh)
- Cx_ereactivenegative - reactive energy in the negative (export) direction (kvarh)
- Cx_VRMSmin - minimum voltage (V)
- Cx_VRMSmax - maximum voltage (V)
- Cx_IRMSmin - minimum current (A)
- Cx_IRMSmax - maximum current (A)
- Cx_powerfactor - power factor
General Usage Notes
Some users have identified issues with apostrophes inserted in the conversion process when opening the CSV files using some versions of Microsoft Excel. If you get a message about data conversions, use the "Convert" option to apply the automatic conversions.
The following provides some general guidance on the normal expected configuration of devices. You may need to confirm the specific configuration and installation information for each device if these generalisations are not as expected.
- Single phase devices should generally only have one channel with the "Grid connect" category.
- Two or Three phase devices will generally have the same number of channels with the "Grid connect" category.
- For the "Grid connect" category, import energy from the grid is positive and export energy to the grid is negative.
- For "Solar generation" or "Hybrid solar & battery system" channels, solar generation or energy out of the battery is normally positive. Negative energy may indicate energy going into the battery or standby consumption of the solar inverter.
- Multi-phase appliances (eg: Three Phase Air conditioning) may have the same number of channels with the same category (eg: "Air conditioning").
- For "Battery" channels, positive energy is energy out of the battery (discharge). Negative values represent energy flowing into the battery (charge).
- For "Electric vehicle" channels, positive energy is for charging the vehicle. Negative is energy is for energy flowing out of the vehicle (V2G).
- All other load categories should generally be positive for normal consumption of energy.