Una lista de todas las exportaciones personalizadas disponibles en MonitorPro
Introducción
MonitorPro ofrece múltiples opciones de diseño a la hora exportar datos en archivos excel ó .csv. A su vez, cuando el cliente lo requiere, es posible desarrollar formatos de exportación personalizados con el fin de cumplir con flujos de trabajo específicos, como la integración con otros sistemas y/o cumplir con las demandas de entes reguladores o de otras partes interesadas internas o externas.
Para ello, MonitorPro cuenta con una serie de opciones de exportación personalizadas. Esto permite crear formatos de exportación específicos, no disponibles inicialmente con las opciones predeterminadas de MonitorPro.
A raíz de esto, EHS Data ha creado una biblioteca de exportaciones personalizadas a partir de la cual el cliente puede solicitar la creación de exportaciones de acuerdo a su necesidad. La lista que se presenta a continuación describe la función general de cada una de las exportaciones disponibles.
| 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 |