ActionLevels Format – Added Custom Check to ActionLevelParameter.action_level_code [d46010]
Added a check to ActionLevelParameter.action_level_code to ensure that the incoming action_level_code either matches a value in the database or is within the ActionLevel section of the format.
ActionLevels Format – Added Lookups to DT_SUBFACILITY and DT_PERMIT [d44942]
Updated ActionLevels format to include error checks, ensuring that ActionLevel.subfacility_code and ActionLevel.permit_number exist in the database.
DMR Format – Added 'Export by Permit Number' in Permit EDD Export and Included Facility Section in All Exports [d42357]
The following have been added to DMR Format exports:
- Export by Permit Number in the Permit EDD Export
- New Facility_v2 section in the Lab Results EDD, Permit EDD, and Field Results EDD Exports
EDGE Format – Start_depth Not Populated in EDP for WellConstruction_v1.segment_type = "TOP_OF_CAP" [d42220]
Fixed a bug in the EDGE format that caused the start_depth fields to not populate where WellConstruction_v1.segment_type = TOP_OF_CAP when loading an EDD in EDP.
EDP – Added Password Reveal Button to Password Field of Sign and Submit Form [d42599]
Added a Password Reveal Button to the Password Field of the Sign and Submit Form.
EDP – Custom Check Tab No Longer Included in EDD Description File [d45822]
Fixed an issue in EDP that caused EDD Description files to be generated without the Custom Checks tab.
EDP – Does Not Recognize Cell References Used to Populate Time and/or Date fields [d45086]
Fixed a bug in EDP that prevented some EDDs created in Excel from being able to load dates generated through formulas.
EDP – EDGE Format Incorrectly Populates ST_EDD_BATCH.EDD_TYPE [d45507]
Fixed a bug where EDP would incorrectly set the EDD_TYPE for EDDs submitted using the EDGE format when the plugins folder contained a Format.xsd or Custom.xsd file.
EDP – Empty String Qualifier in RT_Qualifier No Longer Crashes EDP [d43110]
An empty string qualifier present in RT_QUALIFIER no longer crashes EDP.
EDP – Enterprise Licenses Now Recognized [d43456]
Formats now recognize Enterprise licenses in Professional EDP.
EDP – Error Added for Out-of-Range Lat / Long Values in the Geography Field [d43447]
Latitude and Longitude values that fall outside of the valid range (Latitude: ±90, Longitude: ±180) now generate an error message. This error message also reminds users that values should be inserted as (LONG, LAT).
EDP – Find and Replace "Within" Selection Is Now Preserved Between Uses [d42338]
The Find and Replace window now preserves the 'Within' selection between uses in EDP.
EDP – Performance Enhancements for EarthSoft.EDP.EddCustomhandler Methods [d42354]
Improved performance when getting sample_id and test_id for tables in an EDP format.
EDP – Refvals Warning Status Added to rt_unit Values Containing a Superscript or Subscript [d42869]
Loading a refvals EDD into EDP will now display a warning if a unit contains superscript or subscript characters (e.g., m²). This warning advises users to verify that they are not introducing a duplicate with the message "Please review existing reference values to ensure that your superscript or subscript entry is unique."
EDP – Tooltip Indicates if a Format Field Has an Enumeration Value [d42679]
Updated tooltip to indicate if a format field has an enumeration value.
EDP Standalone – Fixed Clear EDD Option to Remove Error Formatting at the Folder Level [d42297]
Selecting 'Clear EDD' now clears folder-level error formatting.
EDP/EDP Standalone – Ribbon Options Cut Off When Using Large Text Scaling [d45579]
Made changes in EDP and EDP Standalone to accommodate for a Windows Text Size setting that would cut off text in the EDP Ribbon.
Enterprise EDP – Add ST_CONFIG Setting to Notify Data Submitters when EDD Is Stuck [d43137]
Added an optional ST_CONFIG table setting to notify data submitters when an EDD has an ST_TASK.STUCK_DATE populated by the Enterprise workflow service.
Enterprise EDP – Fixed Error When Uploading EDDs Without Format Names [d45687]
Fixed a bug where EDDs without a format name uploaded through Enterprise could be marked stuck.
EQEDD and EQEDD_v2 Formats – EDD Gets Deleted After Attempting to 'Save' in EDP [d45281]
Fixed a bug in the EQEDD and EQEDD_v2 formats where apostrophes or single quote symbols in TestBatch_v1 and TestBatch_v2 would cause a saved EDD to be deleted.
EQEDD and EQEDD_v2 Formats – Increase Efficiency of the LabQC Section of the EDD Export [d43458]
Optimized the LabQC section of the EDD export for the EQEDD and EQEDD_v2 Formats.
EQEDD_v2 Format – Enumeration File Referenced Wrong Format Sections [d45415]
Updated EQEDD_v2-enum.xml file to correctly label items as "v2" instead of "v1".
EQEDD_v2 Format – Location_v2.datum_collect_method_code Not a Lookup [d45438]
Updated EQEDD_v2.xsd to map Location_v2.datum_collection_method_code field to DT_MEASURE_DATUM.DATUM_COLLECT_METHOD_CODE and RT_COORD_ELEV_METHOD.ELEV_COLLECT_METHOD_CODE.
ERPIMS Format – Add Ability to Populate Sample_Lab, Test_Lab, and Result_Lab from a Single Text File [d42430]
Updated the ERPIMS Format with the ability to parse through a single text file and populate the Sample_Lab, Test_Lab, and Result_Lab sections simultaneously.
ERPIMS Format – Changed Sample_Lab PK and sys_sample_code Mappings [d46062]
Updated the Sample_Lab.FLDSAMPID field to be nullable and added LABSAMPID to the primary key for the Sample_Lab section. Improved Sample_Lab method mapping. When populated, FLDSAMPID will map to DT_SAMPLE.SYS_SAMPLE_CODE. If FLDSAMPID is blank LABSAMPLEID will be mapped to DT_SAMPLE.SYS_SAMPLE_CODE instead.
ERPIMS Format – New ERPIMS Group 3 Prime Report [d44622]
Created a new ERPIMS Group 3 Prime report to export ERPIMS data in space-delimited, separate text files for sample, test, and result records that do not contain any extraneous fields.
EuroEQEDD Format – Removed Foreign Key on LabData.stat_type and value_type [d42564]
Removed foreign key on LabData.stat_type and LabData.value_type
Facility Format – Error when Deleting Rows [d42660]
Fixed an issue that caused an error when deleting rows from tables in the Facility Format that do not have a "task_code" column.
GeotrackerEDF Format – Updated Date Format Checking in the Survey/Gauge Data Section [d45499]
Fixed a bug where the GeotrackerEDF format did not check date formats correctly for fields in the Survey/Gauge Data section. The EDD description file now states that the date format for these fields is YYYYMMDD.
Historical Format – EDDs Have Orphan Row Errors When Child Rows Are Loaded Before Parent Row [d45612]
Updated the Historical format to refresh the HistoricalChemistry_v1 section on data load to clear Orphan Row errors in instances where EDD child rows are loaded before parent rows.
Oil_Gas_Baseline_EQEDD Format – Added New Format [d41751]
Created a new EQuIS Oil_Gas_Baseline_EQEDD format intended for loading fracking-specific data and includes a variety of exports that can be used for reporting purposes. The Oil_Gas_Baseline_EQEDD format is available as part of a format package (Oil_Gas_Baseline_EQEDD_FormatPackage.zip) file on the EarthSoft Community Center.
Person_and_Company Format – "Unable to Update Value" Error in RT_COMPANY Section [d45767]
Fixed a bug in the Person_and_Company format where clearing a value from the company_code in the RT_COMPANY section caused an error.
Person_and_Company Format – DT_PERSON No Longer Throws Error on EDP Create Step when Primary Key Exists [d42972]
Fixed an error which caused modified DT_PERSON rows to produce an error on the EDP Create step when the row's primary key already exists.
Professional and Standalone EDP – Tables with Warnings Only (No Errors) Displayed in Orange [d42644]
Updated Professional and Standalone EDP to distinguish between tables containing only warnings and tables with additional errors by displaying warning-only tables in orange. Tables containing errors will continue to be displayed in red.
Professional EDP – Changed Default Save Location When Downloading Files From EDP [d46007]
Changed the default save location to My EQuIS Work/databasename/currentfacility when downloading files from EDP.
refvals Format – Update Format Sections to Pull Data During Export [d43305]
The refvals format export will pull data into the sections of the format from the database tables of the same name. Updated the refvals format export to populate the following sections:
- at_material
- rt_land_use
- rt_material_type
- rt_param_type
- rt_subfacility_param_type
Scribe Format – Added Depth Check to SamplesSoil [d42520]
SamplesSoil.Samp_Depth_to will be required if SamplesSoil.Samp_Depth is not NULL.
SEDD Format – Deprecated [d48043]
The Staged Electronic Data Deliverable (SEDD) format has been deprecated and replaced with the EQuIS SEDD Report, which can be opened in the SEDD data interface in Professional to export data from an EQuIS database into an XML file that complies with the organizational structure required of SEDD.
Vapor Intrusion Format – Improved Format Functionality [d45449]
Removed the vi_task_code referenced enumeration, digitally signed the format, and changed the following task_code parameters to be lookup fields that pull values from DT_TASK.TASK_CODE:
- VI_Building_Address.task_code
- VI_Building_Inspection.task_code
- VI_Building_Parameter.task_code
- VI_Location_Parameter.task_code
- VI_Sample.task_code
- VI_Sample.task_code_2
WaterLevel Format – Added Warning for New sys_loc_codes [d46107]
Updated the WaterLevel Format to check the sys_loc_code field and flag a warning if it is not present in the database.