Version 8.0.3 (Released Apr 2, 2024)

• Added option to handle dates stored as UTC in the Trihedral Database.

Version 8.0.2 (Released Dec 14, 2023)

• Fixed problem with Browser Tab in WIMS Server Side Interface Setup not showing input fields.

Version 8.0.1 (Released Jan 10, 2022)

• Added support for Trihedral Version 12.  This version uses a wide format table for storing data.

Version 8.0.0 ( Released Nov 23, 2021)

• Added support for CSV Export and Upload to Aquatic Compliance & Operations (ACO)
• Upgraded to Spread 8

Version 1.1.2 (Release Feb 26th, 2020)

• Updated Interface to work with Trihedral Database version 11.5.

Version 1.1.1 (Release Jan 9th, 2018)

• Updated query to use Value:TimeofMIN for timestamp.
• Fixed issue when using Filters (collect data when) if filter tag returned a low number of records for time period. 
• Update for Common Framework changes (license issues)
• Removed Hexagora Controls

Version 1.1.0 (Released on 12/7/2015)

• Fixed DIFF function (4623)
• Upgraded interface to Common Framework Build 149

• Updated to the latest common framework
• Fixed problem uploading the G2_Server_LU file
  

• Added functionality to work with SQL Server 2012
  
• Fixed issue where the Interface Last Run Date was not getting updated

Version 1.0.7 (Build 97, Released on 2/20/12)

• Changed query to enclose the table in double quotes (4161)

Version 1.0.6 (Build 91, Released on 1/3/12)

• Fixed problem processing data with new configuration (4199)

Version 1.0.5 (Build 89, Released on 12/13/11)

• Fixed problem with query. Added to interface Source Configuration (Q12363.XML) the following fields:

FIELD ADDED	DEFAULT VALUE	TESTING VALUES
VALUEFIELD	:Interpolated
DATAPOINTSPERSECOND	:60
DATEFORMAT	yyyy-mm-dd hh:nn:ss	mm/dd/yyyy hh:nn:ss
DATEDELIMITER	'	#

All fields are shown in Source Configuration on the Advanced Options tab and are optional. To eliminate a field, delete all text from field. The Default Value for DATEDELIMITER is a single quote mark. Testing Values are setup values for a MS Access database using a DSN connection.

• DATAPOINTSPERSECOND - this is the frequency of data points and can be set overall in the interfaces Source Configuration > Advanced Options tab. A variable can override this setting by simply adding the colon and value to the TAG name field in Hach WIMS Client under System Setup > Edit/View Variables on the Interface tab as shown:

This example shows our TAG value as AI001:60 and means we want a data point from the AI001 table every 60 seconds. If we wanted one data point per hour (60 seconds X 60 minutes), we could ask for 3600 by entering AI001:3600. The interface might have a default of :60 but the :3600 will override that value. One thing that will cause problems is if the tag name contains a colon other than the one specifying the data point frequency.

• In Source Configuration, the fields mentioned above will be loaded and saved to the XML file. This is so the first time this new version is installed, it will initially put the default values in the XML file. 
• Removed the field to enter the Database Name that requested a file location of a database, this is part of the DSN connection.

Version 1.0.4 (Build 73, Released on 9/3/10)

• Upgraded to Common Framework build 116, LIMS Framework build 34, Updated framework to handle time zone differences and how they affect direct and indirect interfaces
  

Version 1.0.3 (Build 58, Released on 7/30/10)

• Upgraded interface to Common Framework Build 100

Version 1.0.2 (Build 44, Released on 2/8/10)

• Upgraded interface to SCADA2OPSSQL Framework Build 47

Version 1.0.1 (Build 38, Released on 10/22/09)

• Upgraded interface to Common Framework Build 85

Version 1.0.0 (Build 19, Released on 8/11/09)

• Initial release