====== 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. ===== 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 or keep records of sensor data. {{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 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). {{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 or presentations. {{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.