Using the interface browser for Hach WIMS Direct Server-Side Interface to Iconics TrendWorx Logger.

The browser connection must be properly configured in the Hach WIMS client:

• Select System Tables -> Entire System -> Server-Side Interface Setup.

• If you have not uploaded the definition file for this interface (need to do only once per version) click the New Definition button. Navigate to the 12580.g2_server_lu file, it should be in the same location as where the interface was installed. Typically, the interface installs under the Hach WIMS folder, under the folder name Q12580.
• Next, is there an entry? You will have one entry per interface, so if you need three of these interfaces then you will have three entries in the table shown below. If you have an entry, click Edit button next to that entry and look at the Browser tab. There should be a connection string to the Iconics Logger database.

If you do not have an entry, create one:

1. Ensure the Hach WIMS Direct Server-Side Interface to Iconics TrendWorx Logger is installed.
2. Click on New to create a new instance of the interface. Fill in the General tab information.
3. Click on the Browser tab and enter the information necessary to connect to the Iconics TrendWorx Logger. Make sure Browser Enabled is checked and click OK button.
   
   An example of an MS SQL Server connection string:
   
   Provider=SQLNCLI;Data Source=MY_SERVER;initial catalog=TWXLogger;User Id=sa;password=password;OLE DB Services =-2;

While in the Hach WIMS Client, click on System Setup ->Edit/View Variables and click the Interface tab.

You are ready to view tags from the historian. Click the button with a ? (question mark) on it as shown below:

The browser will load:

• Interface Menu
  
•  Under File we have options: OK, Cancel, and Exit which work exactly the same as the shortcut buttons, explained next.
  
  
•  Under Help we have options: Help which displays the help for the interface, and About which shows the application information.
  
• Shortcut Buttons
  
• button will send the selected tag name back to the Hach WIMS client.
• button will cancel selecting a tag.
• button will allow user to find a specific tag or series of tags.
• button will bring up help information about the interface and specifically the browser.
• button will exit the browser without making a tag selection.
  
• Tag
• This area will populate with tag names. To select a tag simply click on it and press OK button.

TECH NOTES:

The Browser run the following query to load the list of tags:

select table_name from twx_master_groups order by table_name

It will then run the following query for each table_name

select logging_name from tablename_tags order by logging_name  

where tablename is replaced by the table_name returned in the first query.  For example, if the tablename is Headworks the query becomes:

select logging_name from Headworks_tags order by logging_name

NOTE: We have seen some databases with spaces in the Group Name.  This may cause tags to not be listed for that group name as the table_name associated with that group name is not correct.