Skip to main content

Tutorial: Data Export

This tutorial explains how to extract historical energy data from the WEVA local database for external reporting.

1. Entering Data Collection View​

Navigate to the Data Collection module from the side navigation bar. This view provides a tabular representation of every recorded entry in the SQL database.

2. Filtering Datasets​

To extract specific data, use the filtering controls:

  1. Device Filter: Select the specific WAGO meter.
  2. Date Picker: Define the start and end period (e.g., 2024-01-01 to 2024-01-31).
  3. Variable Selection: Choose specific metrics (e.g., Total Power only).

Data Filter Placeholder Screenshot: Highlighted filter controls and date picker in the Data Collection view.

3. Generating CSV Files​

Once the desired data is visible:

  1. Click the Export to CSV button.
  2. The browser will initiate a download of a .csv file.
  3. The file uses UTF-8 encoding and semicolon (;) delimiters by default, optimized for European industrial spreadsheet formats.

4. Data Integrity Verification​

Exported timestamps are recorded in UTC. Ensure your external analysis tools are configured for the correct local time zone offset.

CSV Export Placeholder GIF: Recording showing the filtering process and the resulting CSV file being opened in Excel.