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, save the visual chart as an image for reports, or generate electronic records for compliance purposes.

Compliance Note: For regulated environments requiring printable or electronic copies of historical data, use the Table export function below to generate immutable CSV or Excel records.

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, keep exact records of sensor data, or prepare data for manual backfilling.

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, exact historical records, or as a formatting template for manually uploading/backfilling missing data.
  • 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. Note: If you are exporting data to serve as a template for manual CSV uploads (e.g., to backfill data after a PLC connection drop), you must select this format.
• 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). *Ensure these match your import settings if you plan to re-upload data.*
• 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, presentations, or generating visual compliance reports.

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.