Home : Release notes for interface Q12363
Q12403 - INFO: Release notes for interface Q12363

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)

Version 1.0.9 (Build 106, Released on 1/24/2013)

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

Version 1.0.8 (Build 98, Released on 5/11/12)

  • 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
Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 7/17/2009 10:18 AM.
Last Modified on 1/10/2022 2:32 PM.
Last Modified by Steve Fifer.
Article has been viewed 3986 times.
Rated 3 out of 10 based on 2 votes.
Print Article
Email Article