Home : Release notes for interface Q12233
Q12236 - INFO: Release notes for interface Q12233

Version 8.0.7 (Released on 5/22/2023)

  • Added support for 'Integers as Value = True' in connection string.

Version 8.0.6 (Released on 2/24/2023)

  • FIRST.PICOMP & LAST.PICOMP Statistics query from piarchive..picomp table.

Version 8.0.4 (Released on 8/23/2022)

Version 8.0.3 (Released on 8/1/2022)

  • Added Checkbox to Source Configuration to add 999 milliseconds to the EndDate in queries.
    • Example: SELECT TOP 1 value, time FROM piarchive..piinterp2  WHERE Tag = 'CSO-29C11603'  AND time >= date('18-Jul-2022 00:00:00') AND time <= date('18-Jul-2022 00:14:59:999') 

Version 8.0.2 (Released on 4/20/2022)

  • Feature added to not overwrite data previously written to WIMS
  • Auto Run Constant to add to Start Date Each Time Import Runs extended to 60 days
  • Update Last Run Date updates Default Last Run in xml file when importing vars from CSV file

Version 8.0.1 (Released on 2/24/2022)

  • Updated Licensing

 Version 8.0.0 (Released on 11/23/2021)

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

Version 1.1.7 (Released Oct 22nd, 2021)

  • Added support for Export to CSV
    • Auto upload Not working yet
  • Updated ntinterface.ini file with correct references

Version 1.1.6 (Released Sept 14th, 2020)

  • Added support for SSPI (Windows Authentication) in Source Configuration 

Version 1.1.5 (Released on April 18th, 2019)

  • Removed Hexagora Unicode Controls
  • Updated to latest common framework 

Version 1.1.4 (Released on 12/7/2015)

Version 1.1.3 (Build 133, Released on 9/15/2015)

  • Fixed problem with RANGE and DIFF stats not working, return blank results (4505)

Version 1.1.2 (Build 128, Released on 3/12/2014)

  • Fixed a problem that prevented importing filtered data (4419)

Version 1.1.1 (Build 122, Released on 1/24/2013)

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

Version 1.1.0 (Build 105, Released on 5/11/2012)

  • Made changes that allows the custom source's connection object to stay open throughout the run
  • Added functionality to work with SQL Server 2012

Version 1.0.9 (Build 104, Released on 7/19/2011)

  • Fixed problem using Interpolated values that returned a set of values for MIN, MAX, and AVG instead of one value. Symptom is the interface appears to always return FIRST.

Version 1.0.8 (Build 93, Released on 10/26/2010)

  • Fixed INVENTORY statistic error: if/when PI system goes down it logs nulls, INVENTORY was counting this as zero (0) and using it in the calculation, which skewed the inventory value. Changed the INVENTORY function to skip over null values.

Version 1.0.7 (Build 91, Released on 9/2/2010)

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

Version 1.0.6 (Build 72, Released on 7/30/2010)

  • Upgraded interface to Common Framework Build 100

Version 1.0.5 (Build 57, Released on 2/8/2010)

  • Upgraded interface to SCADA2OPSSQL Framework Build 47

Version 1.0.4 (Build 50, Released on 12/18/2009)

  • Changed queries to PI from "time < '12-17-2009 00:15:00'" to "time <= '12-17-2009 00:14:59'" due to issue with the PI OLE DB driver.

Version 1.0.3 (Build 47, Released on 11/5/2009)

  • Added capability to specify data collection methodology for the interface; interpolated and non-interpolated
  • Added capapbiliyt to override interface data collection methodology when defining the varaible in Hach WIMS client by adding to the end of the statistic .I for interpolate and .R for non-interpolate (raw data). For example interpolated average would be AVERAGE.I

Version 1.0.2 (Build 46, Released on 10/22/2009)

  • Upgraded interface to Common Framework Build 85

Version 1.0.1 (Build 22, Released on 6/15/2009)

  • Updated framework because changes were needed in order to accomplish LIMS2OPSSQL common type (2693) 

Version 1.0.0 (Build 17, Released on 6/9/2009)

  • 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 5/20/2009 1:47 PM.
Last Modified on 5/22/2023 9:31 AM.
Last Modified by Steve Fifer.
Article has been viewed 5272 times.
Rated 8 out of 10 based on 2 votes.
Print Article
Email Article