Exporting Data & Graphs

Mervis SCADA allows you to export the data you are viewing in your graphs. You can download the raw numbers for analysis in Excel/Matlab, or save the visual chart as an image for reports.

To access these settings, click the Export button located in the Graph view menu.

Use the Table tab to download your data as a spreadsheet file (.xlsx, .csv). This is useful if you need to perform your own calculations or keep records of sensor data.

Key Settings:

• Aggregation (Export Type): This is the most important setting. It determines if you get raw data or calculated data.
  • Aligned: Exports raw data exactly as it is stored in the database. No calculations are made. If a sensor sent a value at 10:03:15, that exact timestamp and value will be in the file. Use this for troubleshooting or exact historical records.
  • Equidistant: Exports calculated data on a fixed grid (e.g., exactly every 10 minutes). If there is no record for a specific time, the system calculates the value based on the surrounding data. Use this for uniform reports where you need neat, regular rows.
  • BI: Exports data in a format optimized for Business Intelligence tools. This is a specific structure designed for importing into third-party analytics software.
• Interval: (Visible only for Equidistant aggregation) Defines the time step between rows (e.g., Minute, Hour, Day).
• Format:
  • .xlsx: Standard Microsoft Excel file.
  • .csv: Comma Separated Values (plain text), compatible with almost any data software.
• Value Delimiter / Decimal Separator: (Visible only for CSV) Allows you to customize the file format to match your specific regional settings (e.g., using a comma vs. a semicolon).
• Decimal Places: Control how many decimal points are included in the exported values.
• Timestamp Precision: Adjust how precise the time record should be (e.g., down to the second).

Once you have configured your settings, click Download.

Use the Graph tab to save a picture of the chart exactly as it looks on your screen. This is perfect for inserting into emails or presentations.

Settings:

• Width / Height: You can specify the exact pixel dimensions for the image. If you leave these blank, it will default to the current size of your browser window.

Click Download PNG to save the image file to your computer.

Use the Matlab tab if you need to process your data using MathWorks Matlab software.

This option generates a script file that allows you to import your selected data directly into the Matlab environment for engineering analysis.

Click Generate Matlab script to download the file.