Build (23.3) (Nov 2023)

The EQuIS 7.23.3 Build files are available in the "Products" folder on the Downloads Dashboard of the EarthSoft Community Center. Please review the known issues listed below.

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:

EarthSoft executables and formats in Professional, SPM, and EDP installs are digitally signed with EarthSoft's code signing certificate.

•Alive

•Updates to Alive_EDGE format.

•ArcEQuIS

•Fixed compatibility issues with EnviroInsite functionality when running ArcEQuIS in ArcGIS Pro 3.0+. (Hotfixes for ArcEQuIS 7.22.3, 7.23.1 and 7.23.2 were released on the ECC to restore this functionality.)

•Update ArcEQuIS Crosstab Converter report.

•Fix live connection not refreshing after updating API Token.

•Bug fixes.

•Collect

•Updates to Collect Schema.

•Syncing requires Data Sets for new and edited templates.

•Toggle on/off which template reports are available.

•Remove Merge option for published or disabled templates.

•Add text tagging functionality for points in Map Plot Field on Mobile app.

•Improve performance of Collect Enterprise.

•Updates to Form Summary and Geotechnical Collect reports.

•Bug fixes.

•DQM

•Updates to numerous DQM Checks to set control limits for a group of MATRIX_CODEs by entering value in MEDIUM_CODE column of one row in the RT_DQM_CONTROL_LIMITS table.

•Add additional parameters for matching data in the Batch Completeness, Holding Time, Spike Recovery, Total vs Dissolved checks.

•Updates to DQM Schema.

•Updates to DQM-refvals format and DQM Starter QAPP.xlsx file.

•Improvements to numerous DQM checks.

•Updates to DQM Event report and Validation report.

•Updates to the DQM Third Party Validation import.

•Enhancements and bug fixes.

•EDGE

•Updates to EDGE format.

•EDP

•Updates to Analytical Result II, Action Level, Data_Tables, EQEDD, EQEDD_v2, ERPIMS, GeologyEDD, gINT, refvals, and Rockworks formats.

•Add option to disable auto-capitalization for key fields in EDP.

•Add "Value exceeds field length" error message.

•Bug fixes.

•Enterprise

•Improve performance of dashboard creation process.

•Improve workflow service for webhook EIAs.

•EDP EDD Upload Widget – Allow admins to define visible formats.

•Map Widget – Add ability to create new database locations from map.

•Web Forms Widget – Remove "Beta" and add numerous interface improvements.

•Workflow Widget – Users will now only be able to upload strongly named and approved in ST_CONFIG formats (compiled in a DLL file).

•EnviroInsite

•Update to use VectorDraw version 10.1003.1.0

•Update Boring Logs and Subsurface Profiles to display graphics/hatch styles from DT_GEO_BACKFILL.

•Improve performance of templates for Boring Logs and Subsurface Profiles.

•Bug fixes.

•Geotech

•Improve support for data exchange with AGS4 format; new Geotechnical Export - AGS 4 report and AGS4_Geotechnical_v2.link Mapping Project Template file.

•Updates to Geotech Schema, including database functions to facilitate reporting.

•Updates to Geotechnical_v2 format.

•Updates to the Geotech_Refvals_EDD.xlsx file.

•New Geotechnical Results and Geotechnical Lab Test Status reports.

•Updates to Geotechnical CPT Parameters, Geotechnical Lab Summary, Geotechnical Unconfined Compression, and Geotechnical Unconsolidated Undrained reports.

•Link

•Add support for loading external reference data source files to Link virtual format while being processed by Enterprise EDP.

•Add FIELDEXISTS function.

•Live

•Updates to the Live format.

•Updates to Live Chart, Circular Gauge, File Processor, Heatmap, Historical Chart, Table, and Windrose widgets.

•Professional

•Updates to standard Schema.

•Improve Action Level form to facilitate advanced action level setup review.

•Installer – Add Enterprise Permissions reports and remove LakeWatch Module.

•Enhanced Report Publishing and Customization

•Conversion of Text parameters to List parameters when publishing

•Able to republish SQL and RDL reports within the same day

•Updates to RDL report user interface (allowing for custom RDL report parameters)

•Permission improvements

•Fixes to crosstab and user report saving/publishing

•Updates to Action Level Exceedance II report, GWSDAT report, VLA - PPU Usage and Billing Statement report, crosstab reports, RDL reports, and SQL reports.

•REST API

•Remove several api/spm endpoints (if SPM Enterprise is installed).

•Schema – Collect, DQM, Geotechnical, and Standard updates required.

•See Schema Files and Scripts section below.

•SPM

•Update Monthly/Annually Recurrence options to include Day Offset option.

•Updates to SPM and SPM_REF formats.

•Updates to SPM COC, SPM Labels, SPM Labels (Custom), and SPM Land Access Planned reports.

•SPM Enterprise – Enhancements to Scheduler page, update Resources Group to honor session facility selection, remove several api/spm endpoints, and more.

•Third Party Components

•Update Newtonsoft.Json reference to version 13.0.3.

•Moved documentation for third party components to a PDF file on the Downloads Dashboard on the ECC.

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

Known Issues: All known issues will be considered for fixing in a future release.

•Collect and the Web Forms widget:

•If there are duplicate values according to the Unique Data Set field, the duplicate values will be deleted when using the Refresh functionality.

•Collect Enterprise:

•Multi Selector and Group Multi Selector field types are not displaying the "Multi Select Delimiter" option. The default value for the "Multi Select Delimiter" is a comma (,) which is being applied in Collect Mobile. The following workaround is available:

1.Switch the Type to Dynamic Selector and select the Multi Select check box.

2.Switch the Type back to Multi Selector or Group Multi Selector.

3.The Multi Select Delimiter will be displayed and can be changed from the default delimiter.

•The Data Forms page will no longer display data in the User Groups column after opening the Uploaded or Status columns of a Data Form. User group data will be displayed again after refreshing using the Refresh button in the upper right corner of the Data Forms page.

•Users without an Admin role can remove members of a User Group from that group but are unable to add users to User Groups.

•The Allow Form Refresh check box does not return to the default value (i.e., unchecked) when switching templates while creating a new data form.

•The User Report title changes to "Modified Report Parameters" and the Allow Form Refresh becomes disabled when switching between templates that contain pre-population while creating a new data form. The workaround for this behavior is to select a different user report, then re-select the desired user report, resetting the User Report title and making Allow Form Refresh selectable.

•When building a formula using the Add Outer Function tool, the necessary nodes required for the outer function are not shown and a parameter count error is displayed.

•The Drag/Drop functionality is not working when adjusting the Collect widget settings while using Mozilla Firefox.

•Collect Mobile:

•An error is displayed when attempting to load a Collect Mobile backup package on Windows 11, resulting in the backup package not being loaded.

•Using an Android device with French language settings, users cannot enter decimal values in decimal fields. The workaround for this issue is to install a third party keyboard and set it as the default keyboard.

•Enterprise:

•The Workflow EmailRetrieve agent stops processing EDDs if an invalid attachment in the email inbox is encountered, which interrupts the loading of the current EDD and stops all subsequent EDDs from being processed by the EmailRetrieve agent.

•The status.aspx web page shows an incorrect FAIL status for all Live File Processor Workflow EFD configurations.

•When Remarks are added to data points in a Live Historical Chart widget, the datum values saved to the database are not correctly converted to UTC from the timezone configured for displaying data points, causing incorrect date range values.

•The "Begin schedule on" property is missing for Daily, Weekly, and Monthly recurring EIAs. The workaround is to select the Once EIA option, which does include the "Begin schedule on" property, to set the desired time and date, and then switch to the Daily, Weekly, or Monthly EIA option to finish configuring the EIA.

•EQuIS Link:

•The "Evaluate" functionality for assessing the output of a formula is not working.

•Professional:

•The SampleTestResult II Form or SampleTestResult III Form may encounter an error if the parameters are adjusted and rerun, or upon attempting to save the changes.

•XML-structured files downloaded through the EQuIS Professional Docs & Photos Form are missing the final ">" of the closing tag. To avoid issues, download these files via the EQuIS Blobber Form in EQuIS Professional or the Explorer widget in EQuIS Enterprise.

•Reports – Including RT_GROUP_MEMBER.CUSTOM_FIELD_1 through _5 (added to the Schema in d31727) as Additional Fields will cause the report to fail with the "Invalid column name" message.

•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.d13047.dll

•Collect Geotechnical – See Release Notes d30886, d31529, and d34584 for details.

DQM

EarthSoft.Reports.Library.63867.dll

•DQM Event Report – See Release Notes d31442 and d34071 for details.

Geotech

EarthSoft.Reports.Library.176839.dll

•Geotechnical Lab Test Status – See Release Note d33821 for details.

•Geotechnical Lab Summary – See Release Notes d30845 and d34108 for details.

•Geotechnical Unconfined Compression – See Release Note d31239 for details.

•Geotechnical Unconsolidated Undrained – See Release Note d31239 for details.

EarthSoft.Reports.Library.d26526.dll

•Geotechnical CPT Parameters – See Release Note d33942 for details.

EarthSoft.Reports.Library.d30189.dll

•Geotechnical Results – See Release Note d31136 for details.

EarthSoft.Reports.Library.d31073.dll

•Geotechnical Export - AGS 4 – See Release Note d31222 for details.

Professional

EarthSoft.Reports.Library.51729.dll

•Action Level Exceedance II – See Release Note d33812 for details.

EarthSoft.Reports.Library.73174.dll

•Viewer License Agreement - Billing – See Release Note d31711 for details.

EarthSoft.Reports.Library.119331.dll

•GWSDAT – See Release Notes d31712 and d34017 for details.

EarthSoft.Reports.Library.627608.dll

•ArcEQuIS Crosstab Converter – See Release Note d31410 for details.

SPM

EarthSoft.Reports.Library.48827.dll

•SPM - Labels and SPM - Labels (Custom) – See Release Note d31588 for details.

•SPM - Land Access Planned – See Release Note d31294 for details.

EarthSoft.Reports.Library.72317.dll

•SPM COC Report – See Release Note d31503 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. Custom formats can be updated to match the new Schema changes. See Making Changes to Format Files for additional information. Contact your account manager if assistance is needed from EarthSoft in updating a custom format.

Collect: schema.Collect.xme

•See Release Note d31622

DQM: schema.DQM.xme

•See Release Note d30951

Geotech: schema.geotech.xme

•See Release Notes d31167, d31670, and d31746

Professional: schema.xme

•See Release Notes d31444, d31727, and d33953

Build 23.3 (Nov 2023)

Build 23.3 (Nov 2023)