Release Notes:

Version 8.0.4 (Released 8/7/2023)

• Updates Rio Parm Guid (SQL -  CLAROS_PARMGUID  in VarDesc) for Variables

Version 8.0.3 (Released 8/2/2023)

• Enabled SQL Connection screen
• Added modified About screen with link to this document
• Update Rio Location Type for Locations

Version 8.0.2

• TwinData updates in Rio for Locations and Parameters

Version 8.0.1

• Added Computations
• Basic computations such as Loads
• WAVG

Version 8.0.0

• Basic Transfer
• Locations
• Variables
• Limits

Tech Notes:

This utility will transfer Locations and Parameters from Rio to WIMS.  The transfer is from one Rio Operation to one WIMS Facility.  The transfer is intended to be run once per Operation/Facility.  Locations or Parameters will not be updated.  If New Locations are added or new parameters added to a location in Rio, the utility will transfer the new data.

The Utility is based on the Interface Framework, however most of the Interface features have been removed.

• UI
• Configuration
• Connection to Hach WIMS
• Connection Information to connect to WIMS Database  Note: Oracle has not been tested yet.
• Source Configuration
• Rio connection information (url, user & password)
• Proxy Server  (If needed, but not likely)
• Rio Operations
• Load button will load a list of all Rio Operations available to the user.  Choose from the dropdown.  List is maintained so Load is only needed if new Rio Operations have been added.
• WIMS Facilities
• Load button will load a list of WIMS Facilities.  Choose from the dropdown.  List is maintained so Load is only needed if new Facilities have been added.
• Import All
• Runs Utility for Operation and Facility set up in Source Configuration.

The Utility brings over the following from Rio

• Locations
• Transfers Locations from Rio to WIMS.
• Maintains the structure created in Rio.
• UD1 is set to the Rio Location TwinId.
• Don't remove or change this if the utility will be run again or you will get duplicate entries in WIMS.  This is used for two things:
• Reference to the Rio Location TwinId.
• Lets the Utility know that this location has already been transferred.
• Parameters
• Transfers Parameters from Rio to WIMS.
• Parameters are sorted alphabetically within the Location
• VarNums are incremented by 3 for each Variable.
• The Following is updated in WIMS
• Name and Short Name (left 20 or name)
• VarNum
• VarType
• Units
• Symbols (<, >, ND) are set up if units are mg/l
• LocId
• DecPlaces
• UD1 is set to the TwinId of the Rio Parameter.
• Don't remove or change this if the utility will be run again or you will get duplicate entries in WIMS.  This is used for two things:
• Reference to the Rio Parameter TwinId.
• Lets the Utility know that this Parameter has already been transferred.
• Claros_Parmguid is set to ID from the Rio Common Parameter Library.
• Computations
• Transfers basic computations
• Basic Computations such as Loads
• WAVG
• May need to add more if they are part of the Rio Wizard.
• Limits
• Regulatory limits will be set up as Regulatory Limits in WIMS
• Warnings will be set up as Entry Limits in the WIMS Variable.
• TwinData in Rio
• The WIMS section of TwinData will be added or updated in Rio for Locations and Parameters.