Supported variable configurations for the Hach WIMS Direct Server-Side Interface to Custom TRA LabWare LIMS.

To configure a variable to hold values from LabWare LIMS, select Edit/View Variables in the client and select the Interface tab.

Then click Interface To radio button. The drop down box next to the option is now enabled, click the drop down arrow and choose the Custom TRA LabWare LIMS interface name (name given when configuring the interface).

• CUSTOMER -This is known as LIMS_LOC field in Hach WIMS and is used to match the value in the LabWare SAMPLE table in the field CUSTOMER.
  
• SITE - This is known as LIMS_TEST field in Hach WIMS and is used to match the value in the LabWare SAMPLE table in the field TRA_COLLECTION_SITE or SAMPLING_POINT.
  
• ANALYSIS - This is known as LIMS_UD1 field in Hach WIMS and is used to match the value in the LabWare TEST table in the field ANALYSIS.

To enable the browser use the instructions found in: Configure the Hach WIMS Client for a Server-Side Interface for LIMS.

UPGRADE FROM OPSSQL to HACH WIMS

In order to upgrade from OPSSQL to Hach WIMS, use the following queries:

Step 1: What is the Interface ID number?

Run a SQL Console, log into OPSROOT, and enter the following query:

SELECT interface_id, lu_id, name from g2_server

In our example, the interface ID number is '1'.

Step 2: Update all variables in Hach WIMS.

Run a SQL Console, log into the facility, and enter the following query, BE SURE TO CHANGE g2_interface_id TO THE APPROPRIATE NUMBER WE GOT IN STEP 1 (everything else is exactly as it is shown):

UPDATE vardesc
SET
  lims_loc = ud1,
  lims_test = ud2,
  lims_ud1 = ud3,
  g2_interface_id = 1,
  g2_enabled = -1
WHERE ud1 is not null and ud2 is not null and ud3 is not null and ud1 <> ' ' and ud2 <> ' ' and ud3 <> ' '