A list of all the Custom Exports available in MonitorPro
Introduction
MonitorPro has several flexible standard options for data layout when exporting data to Excel or .csv. In some situations, there is a need for bespoke formatting of exports to meet specific workflows such as onward integration with other systems, meet regulator demands or other internal/external stakeholders' requirements.
To facilitate this MonitorPro has a number of Custom Export options. These enable specific formats to be built in, which cannot be achieved by other means within MonitorPro.
To achieve this a library of Custom Exports has been made and can be activated on request. The list details below the general function of these exports.
| Grid Based | Custom Export - Export Grid to Excel - Custom Order.sql | Merges sample ref/lab ref and overrides the selection variable order | .xls |
| Grid Based | Custom Export - Crosstab with Sample Ref.sql | Variable Grid (Variables as columns) including Sample Ref | .csv |
| Grid Based | Custom Export - Export Grid to CSV - Short Names (Aggregate Source) setup.sql | Variable Grid including Comments, Aggregated Data Source | .csv |
| Grid Based | Custom Export - Crosstab Grid with Qualifier - CSV.sql | Variable Grid including Data Qualifier | .csv |
| Grid Based | Custom Export - Crosstab with Sample Point Metadata.sql | Variable Grid including Sample Point X/Y, Lat/Long and UDF1-10 | .csv |
| Grid Based | Custom Export - Crosstab with Coordinates and UDFs.sql | Variable Grid including Sample Point X/Y, Lat/Long, UDF10 and UDF14 | .csv |
| Grid Based | Custom Export - Export Grid to CSV - Samples (Aggregate Sources).sql | Variable Grid including Sample Ref, Lab Ref, Comments Aggregated Data Source | .csv |
| Grid Based | Custom Export - Crosstab (Long + Short Spt Names).sql | Variable Grid showing Sample Point Long and Short names | .csv |
| Grid Based | Custom Export - Crosstab (Long + Short Spt Names) - Numeric.sql | Variable Grid showing Sample Point Long and Short names, numeric values | .csv |
| Grid Based | Custom Export - Variable Grid Export.sql | Variable Grid showing Sample Point Long names | |
| Grid Based | Custom Export - Variable Grid Export (Ignore Time).sql | Variable Grid showing Sample Point Long names, merges date by removing time | |
| Grid Based | Custom Export - Crosstab (Short Names).sql | Variable Grid showing Sample Point Short names | .csv |
| Grid Based | Custom Export - Grid (aggregate with reference number) with Limits - Tab by Sample Point (Excel) Export.sql | Variable Grid, Aggregate sources with sample/lab ref columns included, includes compliance values, tab per sample point | .xls |
| Grid Based | Custom Export - Grid (Aggregate Sources) With Limits and Stats - Tab By Sample Point (Excel).sql | Variable Grid, Aggregate sources, includes compliance values and stats (avg/min/max) per variable/date, tab per sample point | .xls |
| Grid Based | Custom Export - Grid (Aggregate Sources) With Limits - Tab By Sample Point (Excel).sql | Variable Grid, Aggregate sources, removes time from date, includes compliance values, tab per sample point | .xls |
| Grid Based | Custom Export - Grid - Aggregate Source with reference numbers Excel Export.sql | Variable Grid, aggregated sources, merges rows with matching lab ref to sample ref, applies sample ref/Lab ref/sample type to same sample point/date to avoid splitting field data | .xls |
| Grid Based | Custom Export - Grid - Aggregate Source with reference numbers Export.sql | Variable Grid, aggregated sources, merges rows with matching lab ref to sample ref, applies sample ref/Lab ref/sample type to same sample point/date to avoid splitting field data | .csv |
| Grid Based | Custom Export - Grid - Aggregate Source with reference numbers alternate Export.sql | Variable Grid, aggregated sources, merges rows with matching lab ref to sample ref, applies sample ref/Lab ref/sample type to same sample point/date to avoid splitting field data, includes sample point UDF1 | .csv |
| Grid Based | Custom Export - Grid (Simplified) With Limits - Tab By Sample Point (Excel).sql | Variable Grid, excluding Source, Sample ref and sample type, including 'Frequency/UDF3' and compliance limits, tab per sample point. | .xls |
| Grid Based | Custom Export - Grid (Detail) With Limits and Stats - Tab By Sample Point.sql | Variable Grid, including compliance limits and stats (min/max/avg), tab per sample point. | .xls |
| Grid Based | Custom Export - Grid (Detail) With Limits - Tab By Sample Point.sql | Variable Grid, including compliance limits, tab per sample point. | .xls |
| Grid Based | Custom Export - Grid (detail) with Limits and Stats Monthly Average - Tab by Sample Point (Excel) Export.sql | Variable Grid, including compliance limits,stats (min/max/avg) and monthly average, tab per sample point. | .xls |
| Grid Based | Custom Export - Grid (detail) with Limits and Stats Override Multiplier Numeric - Tab by Sample Point (Excel) Export.sql | Variable Grid, Overrides set LTM using 0.5 with values formatted as numeric, including compliance limits and stats (min/max/avg), tab per sample point. | .xls |
| Grid Based | Custom Export - Grid (detail) with Limits and Stats Monthly Average Override Multiplier Numeric - Tab by Sample Point (Excel) Export.sql | Variable Grid, Overrides set LTM using 0.5 with values formatted as numeric, including compliance limits,stats (min/max/avg) and monthly average, tab per sample point. | .xls |
| Grid Based | Custom Export - Grid (detail) with Limits and Stats Override Multiplier Text - Tab by Sample Point (Excel) Export.sql | Variable Grid, Overrides set LTM using 0.5 with values formatted as text, including compliance limits and stats (min/max/avg), tab per sample point. | .xls |
| Grid Based | Custom Export - Grid (detail) with Limits and Stats Monthly Average Override Multiplier Text - Tab by Sample Point (Excel) Export.sql | Variable Grid, Overrides set LTM using 0.5 with values formatted as text, including compliance limits,stats (min/max/avg) and monthly average, tab per sample point. | .xls |
| Grid Based | Custom Export - Grid Export Paged By Sample Point - Excel.sql | Variable grid, sample point long name, site short name, variable short name, tab by sample point | .xls |
| Grid Based | Custom Export - Split Header Crosstab By Date.sql | Variable Grid, with compliance | .csv |
| Grid Based | Custom Export - Simplified Crosstab.sql | Variable Grid, with compliance and displays Variables from the dataset as columns even with no data | .csv |
| Grid Based | Custom Export - Grid (detail) with Limits and Stats Monthly Average No Refs - Tab by Sample Point (Excel) Export.sql | Variable Grid,Excluding sample/lab refs, including compliance limits,stats (min/max/avg) and monthly average, tab per sample point. | .xls |
| Lab | Custom Export - ALS eCoC Export - XML.sql | Electronic Chain of Custody with ALS | .xml |
| List Based | Custom Export - Extended List Export with Data Qualifiers (csv).sql | List Export including Data Qualifier | .csv |
| List Based | Custom Export - Extended List Export with Data Qualifiers (Excel).sql | List Export including Data Qualifier | .xlsx |
| List Based | Custom Export - Extended List Export with Data Qualifiers Filtered (csv).sql | List Export including Data Qualifier where UDF is empty string ''/blank | .csv |
| List Based | Custom Export - Extended List Export with Sample Point UDFs.sql | List Export including Sample Point User Defined Fields | .csv |
| List Based | Custom Export - List Export with Coordinates.sql | List Export including X/Y and Lat/Long coordinates | .csv |
| List Based | Custom Export - DL Export.sql | List export which includes text and value, Sample Ref, Lab Ref, Sample Type, Source, Comment and Detection Limit | .csv |
| List Based | Custom Export - List Export with Qualifier.sql | List Export with Data Quaifiers | .csv |
| List Based | Custom Export - List Export with Detection Limit - csv Export.sql | List Export with data UDF, Test Method and Detection Limit | .csv |
| List Based | Custom Export - Export List all Compliance Limits (csv).sql | List including all applicable compliance limits | .csv |
| Regulator | Custom Export - Overall Equipment Effectiveness.sql | Australian National Pollution Inventory | .csv |
| Regulator | Custom Export - Overall LBL $ Differences Summary Export.sql | Australian National Pollution Inventory | .csv |
| Regulator | Custom Export - OGIA Export (csv) Export.sql | Australian Queensland Office of Groundwater Impact Assessment Export | .csv |
| Regulator | Custom Export - EMS Export Alternate.sql | Canada British Columbia Export | .csv |
| Regulator | Custom Export - EMS Export without data.sql | Canada British Columbia Export | .csv |
| Regulator | Custom Export - EMS Export.sql | Canada British Columbia Export | .csv |
| Regulator | Custom Export - NPRI Data Summary with 0.5x DL Export (Excel).sql | Canada National Pollution Inventory | .xls |
| Regulator | Custom Export - NPRI Export Date over Parameters - csv.sql | Canada National Pollution Inventory | .csv |
| Regulator | Custom Export - NPRI Monthly Summary with 0.5x DL Export (Excel).sql | Canada National Pollution Inventory | .xls |
| Regulator | Custom Export - Annual Federal Report Export (Excel).sql | Custom Export for Annual Federal Report - Variable Grid | .xls |
| Regulator | Custom Export - Quarterly GHG Export.sql | Date Grid export, dates summed to calendar quarters | .csv |
| Regulator | Custom Export - GOIS Data Form Export.sql | Date grid, variables grouped by suites. | .csv (UTF-8) |
| Regulator | Custom Export - FYXX Commentary Export.sql | LBL | .csv |
| Regulator | Custom Export -$Breakdown Export.sql | LBL | |
| Regulator | Custom Export - Table with Fees Data Export.sql | LBL | .csv |
| Regulator | Custom Export - WaTERS Submission Export Water Storages (Yancoal).sql | List export for Queensland regulatory WaTERS submission, duplicates variable sample comment to same date/sample point | .csv |
| Regulator | Custom Export - WaTERS Submission Export - Groundwater.sql | List export for Queensland regulatory WaTERS submission, duplicates variable sample comment to same date/sample point, and source group/family as record type | .csv |
| Regulator | Custom Export - NDEP Excel Export (CSV version).sql | Nevada Dept of Environmental Protection (NDEP) Export | .csv |
| Regulator | Custom Export - NDEP Excel Export.sql | Nevada Dept of Environmental Protection (NDEP) Export | .xls |
| Regulator | Custom Export - BMRR Data Upload Export (with Sample Ref).sql | Nevada Dept of Environmental Protection (NDEP)'s Bureau of Mining Regulation and Reclamation (BMRR) Export | .csv |
| Regulator | Custom Export - BMRR Data Upload Export (with Sampled By + Detection Limit).sql | Nevada Dept of Environmental Protection (NDEP)'s Bureau of Mining Regulation and Reclamation (BMRR) Export | .csv |
| Regulator | Custom Export - BMRR Data Upload Export (with Sampled By).sql | Nevada Dept of Environmental Protection (NDEP)'s Bureau of Mining Regulation and Reclamation (BMRR) Export | .csv |
| Regulator | Custom Export - BMRR Data Upload Export by Selection Folder - Excel.sql | Nevada Dept of Environmental Protection (NDEP)'s Bureau of Mining Regulation and Reclamation (BMRR) Export | .csv |
| Regulator | Custom Export - BMRR Data Upload Export Data Types.sql | Nevada Dept of Environmental Protection (NDEP)'s Bureau of Mining Regulation and Reclamation (BMRR) Export | .csv |
| Regulator | Custom Export - BMRR Data Upload Export LCN From Data.sql | Nevada Dept of Environmental Protection (NDEP)'s Bureau of Mining Regulation and Reclamation (BMRR) Export | .csv |
| Regulator | Custom Export - BMRR Data Upload Export.sql | Nevada Dept of Environmental Protection (NDEP)'s Bureau of Mining Regulation and Reclamation (BMRR) Export | .csv |
| Regulator | Custom Export - EA Data Return standard.sql | UK Environment Agency Export | .csv |
| Regulator | Custom Export - EA Data Return Suez.sql | UK Environment Agency Export | .csv |
| Regulator | Custom Export - Quarterly Federal Report Export (Excel).sql | Variable Grid export for MDMER, includes min/max/avg/sum summary. | .xls |
| Regulator | Custom Export - WaTERS Submission Coal Export.sql | Variable Grid export for Queensland regulatory WaTERS submission, includes bore and sample information as columns | .csv |
| Regulator | Custom Export - MEWS Export - XMLExport.sql | XML format for Ontario MEWS submission | .xml |
| Regulator | Custom Export - MEWS Export Frequency Split - XMLExport.sql | XML format for Ontario MEWS submission, duplicates and splits data with multiple frequencies | .xml |
| Regulator | Custom Export - MEWS Export Alternate - XMLExport.sql | XML format for Ontario MEWS submission, mapping specific for Red Lake | .xml |
| Sample Point | Custom Export - Basic with Sample Point Ordering (csv) Export.sql | Basic List export, ordered by sample point | .csv |
| Sample Point | Custom Export - Monitoring Location Metadata Export.sql | List export for BMRR/NDEP | .xls |
| Sample Point | Custom Export - Monitoring Location Metadata Export Data Types.sql | List export for BMRR/NDEP, using UDFs instead of short names | .xls |
| Sample Point | Custom Export - All Sample Point details.sql | List export for sample point details, including X/Y, Lat/Long, Projection, Datum | .csv |
| Sample Point | Custom Export - Selected Sample Points location details (Excel).sql | List export for sample point details, including X/Y, Lat/Long, Projection, Datum, Category, Comments | .xls |
| Sample Point Grid | Custom Export - Sample Point Details with Group (CSV).sql | List export for sample point details, including X/Y, Lat/Long, Projection, Datum, Category, Comments and group | .csv |
| Sample Point Grid | Custom Export - Sample Point Grid Export.sql | Sample Point grid export | .csv |
| Sample Point Grid | Custom Export - Sample Point Grid File with Tabs (Excel) Export.sql | Sample point grid export, including stats (Avg, Standard Deviation, Min, Max, Count), tab per date | .xls |
| Sample Point Grid | Custom Export - Sample Header Export Tab By Sample Point - Excel.sql | Variable Grid export, includes sample information row with MEWSCode (UDF4), tab by sample point | .xls |
| System | Custom Export - System Baseline Information.sql | System infomation such as version and db size | .csv |
| Trend Export | Custom Export - Monthly Parameter count By Source Export.sql | Monthly data count per Variable and Source | .csv |
| Trend Export | Custom Export - Export Effluent Quality Summary Data - csv Export.sql | Monthly stats in grid format showing, Sample Point, Statistics, Variables | .csv |
| Trend Export | Custom Export - Export Data Verification Table - CSV.sql | Sample Point Header Grid with stats for each variable | .csv |
| Trend Export | Custom Export - Result and Limit Range Export.sql | Statistics export with counts, last results and compliance | .csv |
| Trend Export | Custom Export - Trend Exception Export.sql | Statistics export with Linear Regression and trending | .csv |