Build 21.3 (Nov 2021)

The 7.21.3 Build files are available in the "Products" folder on the Downloads Dashboard of the EarthSoft Community Center.

A list of reports as well as Schema files and database scripts updated in this release can be found later in this article.

This build includes the following highlights:

•ArcEQuIS – Add-in for Esri ArcGIS Pro

•Include example templates required for ArcEQuIS Graphics By Locations.

•Collect

•Display GEOJSON layers on Collect Mobile map.

•Improve icons and display on Collect Mobile map.

•New user interface for Collect Enterprise dashboard and page settings.

•Enhanced moving fields in Template Designer.

•Implemented advanced search capabilities throughout Collect Enterprise.

•Numerous user interface and performance improvements for Collect Mobile and Collect Enterprise.

•Updates to Collect Field EDD, eCOC, COC, and Form Generator reports.

•Multiple bug fixes.

•DQM

•Redesign the In Process Event Form.

•Add DQM Event Status and DQM Notes to the In Process Event Form.

•New Dissolved Vs Total check that flags any Dissolved result that is greater than Total result for same CAS_RN and SYS_SAMPLE_CODE.

•Updated Relative Percent Difference (Field and Lab Dup) checks to handle non-detects.

•Re-organized and enhanced online help articles.

•Multiple bug fixes.

•EDGE

•Add COCParameter_v1 section to the EDGE format.

•Multiple bug fixes.

•EDP

•Updates to EQuIS Vapor Intrusion and EuroEQEDD formats.

•Fixed rollback issue in Professional EDP.

•Enterprise

•Add User Notices button to dashboard header.

•Encrypted credentials for EmailDeliver, EmailRetrieve, and FTPRetrieve agents.

•Boring Log Widget now respects dashboard filters.

•Esri Javascript API version updated to 4.20.

•New Filter - Map Widget.

•Map Widget – Add 3D view option.

•Implement vertical tabs in the Widget Editor of Traffic Light Map Widget.

•User interface and performance improvements as well as bug fixes.

•EnviroInsite

•Numerous improvements to Boring Log Template Designer.

•New Enterprise deployment package for EnviroInsite reports.

•Updates to the EnviroInsite Boring Logs report.

•Multiple bug fixes.

•Link

•New CPT, DPT, and Extensometer data sources.

•Live

•Add support for dynamic date columns in Live reports.

•New Live Neptune Cluster report – Gets data from the Triplepoint Solutions Neptune Cluster web API.

•Update Live Open Weather Map Agent/Report to include forecasts.

•Enhancements to Live File Processor Agent.

•Updates to Live File Processor and Historical Chart widgets.

•Power BI Data Connector

•EQuIS Data Connector no longer "Beta" as of October 2021 Microsoft Power BI release.

•Optimized loading of Facility Groups.

•Professional

•Add support for saving User Reports to specific folders.

•Allow non-admins without owner permissions to edit groups.

•New Analytical Results II with Location Parameters report.

•New User Activity report that shows breakdown of product use over time by user.

•New Action Level Exceedance II with Water Levels (Grid) report.

•Updates to Relative Percent Difference II and Relative Percent Difference III reports.

•Deprecating Relative Percent Difference (RPD) report; replacing it with the Relative Percent Difference II and Relative Percent Difference III reports.

•Crosstab output supports more column headers.

•Fix AutoCAD interface error that was preventing spider diagrams from plotting.

•Performance improvements and bug fixes.

•REST API

•Added and/or modified numerous endpoints.

•Schema – Standard Schema update required.

•Add a foreign key to DT_TASK.

•Add TASK_CODE to DT_BASIC_RESULT, DT_DRILL_ACTIVITY, and DT_PUMP_RATE.

•See Schema Files and Scripts section below.

•SPM

•Updates to EZSRN format.

•Updates to iCalendar, Labels, SPM Completeness Table - Equipment Activities, and SPM Completeness Report - Detailed reports.

•Enhancements and fixes to SPM Desktop and Enterprise.

Per our Product Support Lifecycle, this release will be supported for 24 months.

Known Issues:

•The "depth" X-axis in the Vertical Profile Chart widget does not respect culture formatting.

•At the time of the release, no other known issues are identified with this build. Please see https://forum.earthsoft.com for current information.

Report Files

Republishing reports is an additional step that an admin-level user can perform after an installation or build upgrade. Below are the reports that have been updated or created with this release. EarthSoft recommends reports be republished for this build of EQuIS if they have already been published to the database.

As you run user reports and custom reports built on any republished reports, please ensure that they function as expected. If not, they should be rebuilt (e.g., reloaded with the published report, new parameters selected if needed, and user reports resaved or custom reports republished). Added report parameters or changes to the DISPLAY_TYPE of report parameters are most likely to affect user reports.

Collect

EarthSoft.Reports.Library.149680.dll

•Collect COC and eCOC – See Release Notes d10804 and d12667 for details.

•Collect COC – See Release Note d12667 for details.

•Collect eCOC – See Release Notes d10798, d12667 and d12668 for details.

EarthSoft.Reports.Library.161941.dll

•Collect Field EDD – See Release Notes d11986, d12667, d12669, d12908 and d12910 for details.

EarthSoft.Reports.Library.174498.dll

•Collect Form Generator – See Release Notes d12667 and d12670 for details.

DQM

EarthSoft.Reports.Library.63867.dll

•DQM Event Report

•DQM Exceptions Report by EDD
See DQM Release Notes here.

EDGE

EarthSoft.Reports.Library.40338.dll

•EDGE Field EDD – See Release Note d11782 for details.

EnviroInsite

EarthSoft.Reports.Library.EnviroInsite.dll

•Boring Logs Report – See Release Notes d11731 and d12039 for details.

Live

EarthSoft.Live.Reports.dll

•Live CDEC Agent and Live CDEC Historical Data Loader – See Release Note d11364 for details.

•Live Neptune Cluster Agent – See Release Note d12157 for details.

•Live Open Weather Map Agent – See Release Note d8769 for details.

Professional

EarthSoft.Reports.Library.44408.dll

•Analytical and Water Results – See Release Note d10801 for details.

EarthSoft.Reports.Library.60983.dll and EarthSoft.Reports.Library.93818.dll

•Relative Percent Difference II – See Release Notes d11759 and d11830 for details.

•Relative Percent Difference III – See Release Notes d11760 and d11836 for details.

EarthSoft.Reports.Library.64102.dll

•Water Levels II – See Release Note d10685 for details.

New reports:

EarthSoft.Reports.Library.d7631.dll

•Action Level Exceedance II with Water Levels (Grid) – See Release Note d10594 for details.

EarthSoft.Reports.Library.d7621.dll

•Analytical Results II With Location Parameters – See Release Note d10677 for details.

EarthSoft.Reports.Library.d5752.dll

•User Activity – See Release Note d12146 for details.

SPM

EarthSoft.Reports.Library.48827.dll

•SPM - Completeness Report - Detailed – See Release Note d12564 for details.

•SPM - Completeness Table - Equipment Activities – See Release Note d11508 for details.

•SPM - iCalendar – See Release Note d10506 for details.

Schema Files and Scripts

The following Schema files and database scripts have changed since the previous build. The locations and purpose of these Schema files are provided on the Database Schema page. For information on applying new Schemas to a database, see Applying Additional Modules/Schemas to a Database.

Professional: schema.xme

•See Release Notes d11069, d11195, d11296, d11819, d11836, and d12406

Alive: schema.Alive.xme

•See Release Note d11296

DQM: schema.DQM.xme

•See Release Note d11296