Objective
This article covers the Historical Data tab on the Edit Site page in EnviroAutomate. This tab provides access to all historical environmental monitoring data for the site, organised by sampling matrix.
What This Tab Shows
The Historical Data tab is split into three areas, top to bottom:
A Data Dashboard card with a button that opens the Historical Data Visualiser
An Import and Export accordion organised by sampling matrix
An ESDAT Import card for loading historical analytical results from ESDAT exports
Fresh Water is fully supported today. Soil, Vapour, Air, Sediments, Biota and Saline Water each have their own accordion section marked "Import and export coming soon".
Data Types Available (Fresh Water)
For the Fresh Water matrix, five types of historical data are available under the Groundwater Monitoring Event heading:
Gauging Data - Water level measurements from monitoring wells
Water Quality Parameters - Field water quality parameters (pH, conductivity, temperature, etc.)
Analytical Results - Laboratory analytical results for sampled analytes
QA/QC - Quality assurance and quality control data
RPD - Relative Percentage Differences (duplicate sample comparison)
Each row shows the current record count.
Key Actions
Opening the Data Dashboard
Click Open Data Dashboard at the top of the tab to launch the Historical Data Visualiser, which provides interactive charts, filtering and panel-based exploration of the site's historical data. See the Historical Data Visualiser article for details.
Exporting Data
Click Export next to any individual data type to download that dataset as an Excel file
Click Export All (ZIP) to download all five Fresh Water data types as a single ZIP
Importing Data
Click Import next to any individual data type to upload new data for that type
Click Import All (ZIP) to upload a ZIP file containing multiple data types at once
Select the file in the file picker dialog that appears
Importing ESDAT Files
The ESDAT card below the per-matrix accordion lets you bulk-import historical analytical results from an ESDAT export:
Drop the paired ZIP (or a single XLSX) into the upload area
The system parses each row, infers the laboratory, and writes rows into Analytical Results
The Recent Imports list shows the result of each run; click into a run to see auto-created analytes, unmatched analytes, and skipped rows
Failed rows do not abort the import. They are recorded against the run with a reason, and you can download a CSV error report for review
Other Actions
Expand/Collapse All - Expand or collapse all matrix accordion sections at once
Cautionary Notes
Imported data must be in the correct format. Export the matching data type first to see the expected template.
Only Fresh Water is fully supported; the other matrices show "Import and export coming soon".
Large imports may take some time to process. Leave the tab open while an import is running.
The ESDAT card supports both paired ZIP uploads and standalone XLSX uploads. Use the same naming conventions as your lab.
Tips for Efficiency
Export existing data first to use as a template for preparing import files
Use Export All (ZIP) to back up all historical data for a site at once
Use Import All (ZIP) when you have multiple data types to upload simultaneously
Check the record counts next to each data type to quickly see what data is already loaded
Use Open Data Dashboard to visualise trends and patterns before or after importing