Build (22.2) (Jul 2022)

The EQuIS 7 22.2 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:

•Alive

•Updates to the Alive_EDGE format.

•Collect

•Add ability to enter data directly into a tabular grid format in Collect Mobile.

•Add ability to associate a Collect user group to a facility or facility group.

•New General Water Sampling template available.

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

•Multiple bug fixes.

•DQM

•Global Parameters now save with a DQM Event.

•Redesign of History Form.

•Updates to various checks.

•Add new functionality to Batch Completeness check.

•Multiple bug fixes.

•EDGE

•Updates to the EDGE format.

•Multiple bug fixes.

•EDP

•Improve security of formats.

•New EQEDD_v2 format.

•Updates to EuroEQEDD and GeoTrackerEDF formats.

•Updates to EDP Standalone installation.

•Enterprise

•Improve Enterprise workflow service.

•Update EIA Editor to have JSON validation in Webhook EIA.

•Enhancements to Web Forms widget (beta version).

•Explorer Widget – Add ability for non-admin users to create, edit, and delete folders (with permissions).

•Map Widget – Add ability to calculate distance and area.

•Map Widget – Add button to set default extent.

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

•Link

•Improve Mapper Messages within the Mapper Status dialog.

•Live

•Add ability to use Live File Processor with Enterprise EDP.

•Updates to Live File Processor, Heatmap, Historical Chart, and Wind Rose Chart widgets.

•Professional

•Improve EQuIS SQL Form to allow comments anywhere and common table expressions.

•Improve User Report performance.

•Fixed several bugs with using an advanced action level Method Analyte Group (MAG) sum in the Action Level Exceedance II reports.

•Fixed unit conversion errors for reports containing Location Parameters.

•Fixed several issues with filtered exports and with Crosstab reports.

•REST API

•Updates to several endpoints.

•Schema – AQS, SPM, and Standard Schema updates required.

•Add JSON data type.

•Add COMPANY_CODE column to DT_EQUIPMENT_PARAMETER.

•New CUSTOM_FIELDs and Geotechnical Fields to support geotechnical work.

•Increase DT_CHAIN_OF_CUSTODY_MAG.METHOD_ANALYTE_GROUP_CODE to 1500 characters.

•See Schema Files and Scripts section below.

•SPM

•Strongly Named SPM_REF format and Embedded Standard SPM formats.

•Enhancements made to SPM.

•New SPM - Populate Result Purpose report.

•New SPM - Labels (Custom2) report.

•Updates to SPM - Planned Task Details report.

•Numerous enhancements and fixes to SPM and SPM Enterprise.

•Batch scheduling tasks now available through the SPM Enterprise Scheduler page.

•Third Party Components

•Upgraded Syncfusion dependencies to version 20.1.0.48. Reports (or other customizations) compiled against older versions of Syncfusion should continue to work but, in some instances, may need to be recompiled with the new version reference.

•Apache log4net is a third party component used in EQuIS applications for application logging. Versions of log4net earlier than version 2.0.9 are known to have an XML External Entity (XXE) vulnerability. EQuIS applications have used version 1.2.10 for a number of years, and many custom assemblies (aka *.dll files) exist that reference version 1.2.10. Upgrading to a new version of log4net will break backwards compatibility and require that all custom assemblies be recompiled. In order to maintain backwards compatibility, EQuIS applications continue to use log4net version 1.2.10, but the XXE vulnerability has been mitigated in the EQuIS application code (starting in Build 7.22.2). In a future build, EQuIS may use a newer version of log4net, which means that all custom assemblies will need to be recompiled.

•Online Documentation

•Chapter-wide enhancements to Professional > Navigation & Workspace, Professional > Reports (in particular, Customize Report Parameters), and Enterprise > User Administration.

•Streamlined Table of Contents for Enterprise.

•EQuIS 7 hardware and system requirements have been moved from the Release Notes chapter to the Introduction chapter.

•Descriptions of third party components have been moved from the Release Notes chapter to the main table of contents.

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

Known Issues:

•In EQuIS Windows applications (EQuIS Professional, EDP, and SPM), moving a window to a secondary monitor that has a different scale may cause display issues. The application may appear partially blank or may not fully maximize within the window or screen. To reset the window to the correct display, click Maximize, then Restore for the window in the main monitor.

•A previously known issue causes values to be imported into EDP rounded or truncated if the Excel EDD has the column hidden or the column width narrowed. The Syncfusion Upgrade, listed above, has fixed the rounded values due to hidden columns. The rounded values due to narrow column widths will be configurable in an upcoming 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/COC and eCOC – See Release Note d18308 for details.

EarthSoft.Reports.Library.161941.dll

•Collect Field EDD – See Release Notes d20449, d20877, and d21363 for details.

DQM

EarthSoft.Reports.Library.63867.dll

•DQM Event Report – See Release Notes d19990 and d20377 for details.

Live

EarthSoft.Live.Reports.dll

•Live File Processor – See Release Note d21249 for details.

Professional

EarthSoft.Reports.Library.43582.dll

•Downhole Point Parameters – See Release Note d20748 for details.

EarthSoft.Reports.Library.50943.dll (republishing not required)

•Analytical Results II – See Release Notes d19727 and d21199 for details.

EarthSoft.Reports.Library.51729.dll (republishing not required)

•Action Level Exceedance II reports – See Release Notes d11387, d20677, and d20989 for details.

EarthSoft.Reports.Library.64102.dll

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

EarthSoft.Reports.Library.65991.dll

•Location Parameters (Extra Fields) – See Release Note d21061 for details.

EarthSoft.Reports.Library.160273.dll

•ARII-ALEII Crosstab – See Release Note d19508 for details.

EarthSoft.Reports.Library.d7621.dll

•Analytical Results II with Location Parameters – See Release Note d21061 for details.

SPM

EarthSoft.Reports.Library.48827.dll

•SPM Labels (Custom2) – See Release Note d20577 for details.

EarthSoft.Reports.Library.197834.dll

•SPM Populate Result Purpose – See Release Note d18365 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 d18314, d19855, d20391, d20828, d20860, and d20866

AQS: schema.AQS.xme

•See Release Note d20390

SPM: schema.SPM.xme

•See Release Note d21167

Build 22.2 (Jul 2022)

Build 22.2 (Jul 2022)