====== 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. ===== 1. Exporting Data (Table) ===== 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. {{en:mervis-scada:90-how-to:ExportData1.png?600}} **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). {{en:mervis-scada:90-how-to:ExportData2.png?600}} Once you have configured your settings, click **Download**. ===== 2. Exporting Images (Graph) ===== 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. {{en:mervis-scada:90-how-to:ExportData3.png?600}} **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. ===== 3. Exporting for Matlab ===== Use the **Matlab** tab if you need to process your data using MathWorks Matlab software. {{en:mervis-scada:90-how-to:ExportData4.png?600}} 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.