Build (23.1) (Mar 2023)

The EQuIS 7.23.1 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 Alive_Survey format.

•Updates to Survey Results (Basic) II report.

•AQS Module

•Updates to the COLLECT_INSPECTION_AQS format.

•ArcEQuIS

•Updates to the "Created by" and "Description" add-in information within ArcGIS Pro 3.0.

•Tables labels now displaying.

•Collect

•Updates to Collect Schema.

•Updates to COLLECT_INSPECTION format.

•Add options to change background and title colors for all field types.

•Add ability to draw points, lines, and polygons on map in app.

•Data forms can be marked as "Complete" automatically.

•Add ability to rearrange order of subforms.

•Add logger functionality to Table Form field type.

•Add Form Table Summary report.

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

•Bug fixes.

•DQM

•Updates to DQM Schema.

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

•Allow export/import of Third Party Validated data in a DQM Event.

•DQM qualifier and reason code rankings are now QAPP specific.

•New DQM Event Report (Grid) report.

•Bug fixes.

•EDGE

•Improve interface for collecting data in EDGE Location Chooser while using ALIVE_EDGE format.

•Improve print layout for EDGE forms to minimize empty white space.

•Add option to print forms as a JPEG.

•Bug fixes.

•EDP

•Updates to EQEDD, Facility, and GeotrackerEDF formats.

•Add coordinate conversion to DB Format tool.

•Change default saving file type from .xls to .xlsx.

•Add tooltips for commit types in drop-down.

•Bug fixes.

•Enterprise

•File Editor – Upload error translations.

•EIA Editor – Add validation to URI field.

•EIA Widget – Add wizard for creating EIAs.

•Explorer Widget – Expands all sub-folders when folder name is clicked.

•Map Widget – Add print screen functionality and improve using GeoJSON layers.

•Traffic Light Widget – Add Filter option.

•Traffic Light Map Widget – Add ability to edit Legend.

•Web Forms Widget – Numerous enhancements.

•Bug fixes.

•EnviroInsite

•Improvements to Boring Logs and Boring Log Template Designer.

•Link

•Add batch process support for CSV and TRX files.

•Improve mapping process.

•Live

•Updates to Live Chart, Heatmap, Historical Chart, and Table widgets.

•Professional

•Updates to standard Schema.

•Improve encryption of *.equis files.

•Format interface buttons launch *.ZIP files.

•OpenID now uses Microsoft Edge as the rendering engine.

•Updates to Action Level Exceedance II, Analytical Results II, Ionic Charge Balance, and crosstab reports.

•REST API

•Enhance security for multiple REST API endpoints and URI logging.

•Improve Swagger documentation.

•Schema – Collect, DQM and Standard updates required.

•See Schema Files and Scripts section below.

•SPM

•Updates to SPM_eQuote format.

•Updates to SPM - Bottle Request, SPM - COC, SPM - Completeness Table - Analytical Results, and SPM - Completeness (Summary and Details) reports.

•Updates to user interface for the Scheduler in SPM Enterprise.

•Numerous enhancements and fixes.

•Online Documentation

•Table of Contents reorganization:

•"Configuration" chapter now "Administration and Configuration", with more administrator-specific articles.

oNew article added to summarize update requirements and steps across all EQuIS components, Overview of EQuIS Updates.

•New "Database" chapter, moved from under the Professional chapter, with database- or Schema-specific articles

•New "Formats" chapter under the "EQuIS Library" chapter.

•New searchable/filterable Microsoft Excel file of EQuIS standard, custom, and product-specific reports developed by EarthSoft is available in the "Reports" chapter under the "EQuIS Library" chapter.

•Chapter-wide enhancements to Professional > Tables & Views and Professional > Navigation & Workspace.

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.

•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 and then Restore for the window in the main monitor.

•In 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.

•In Collect Enterprise, 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.

•In Collect Enterprise, not all formulas are evaluating as expected when using the "Test" tab functionality to assess the output of a formula in the Formula Builder.

•In Collect Enterprise, the Drag/Drop functionality is not working when adjusting the Collect widget settings when using Mozilla Firefox or Microsoft Edge.

•In Collect Mobile, attachments added to Data Forms created on the server might not be visible to all users when syncing Data Forms.

•In 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.

•In Collect Mobile, using Windows 11, generating a report (e.g., Form Summary, COC, etc.) and attempting to save the report to OneDrive will cause Collect Mobile to crash. This issue may also occur with other 3rd party cloud storage services (e.g., Dropbox, Box, etc.). The workaround is to download the report to the internal storage on your device and then upload it to cloud storage.

•In EQuIS Link, the "Evaluate" functionality for assessing the output of a formula is not working.

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

Alive

EarthSoft.Reports.Library.149680.dll

•Survey Results (Basic) II – See Release Note d25368 for details.

Collect

EarthSoft.Reports.Library.149680.dll

•Collect COC / COC and eCOC – See Release Notes d17877, d25558 and d25831 for details.

EarthSoft.Reports.Library.161941.dll

•Collect Field EDD – See Release Note d23609 for details.

EarthSoft.Reports.Library.174498.dll

•Collect Form Generator – See Release Note d27210 for details.

DQM

EarthSoft.Reports.Library.63867.dll

•DQM Event Report (Grid) – See Release Note d25828 for details.

Professional

EarthSoft.Reports.Library.51729.dll

•Action Level Exceedance II – See Release Notes d26525, d25453, and d26480 for details.

EarthSoft.Reports.Library.50943.dll

•Analytical Results II – See Release Notes d25691, d25477, and d23030 for details.

EarthSoft.Reports.Library.60525.dll

•Ionic Change Balance – See Release Note d25959 for details.

SPM

EarthSoft.Reports.Library.48827.dll

•SPM Bottle Request – See Release Note d26494 for details.

•SPM Completeness Report Details – See Release Note d23322 for details.

•SPM Completeness Report Summary – See Release Note d23322 for details.

•SPM Completeness Table - Analytical Results – See Release Note d25540 for details.

EarthSoft.Reports.Library.72317.dll

•SPM COC Report – See Release Note d26473 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.

Professional: schema.xme

•See Release Notes d24558, d24556, d26521, d26141, and d26362

Collect: schema.Collect.xme

•See Release Note d26288

DQM: schema.DQM.xme

•See Release Notes d26352 and d26361

Build 23.1 (Mar 2023)

Build 23.1 (Mar 2023)