Home : Products : Hach WIMS : Interfaces : Hach WIMS Direct Server-Side Interface to Generic LIMS OLE DB : Documentation : Topics specific to the operation of this interface : Supported variable configurations for interface Q13618
Q13624 - HOWTO: Supported variable configurations for interface Q13618

In order to import data from Generic LIMS Interface you must configure (cross reference) the variable's interface settings to pull the correct data.  Basically, you need to specify the Sample Location, Analyte and optionally LIMS UD1 to pull data from:

The LIMS Location will match on the Source Query's SAMPLOC field. 

The LIMS Test will match on the Source Query's Analyte field.  The LIMS Test field may also specify multiple analytes to import data from by separating the analytes with a ~ (tilda).  Example, I want to get data from the Analyte BOD or CBOD:

The LIMS UD1 field will match on the LIMS_UD1 field.

NOTE: If both analytes for a location are run for the same data slot (i.e. day) the interface will write data for the first record and then overwrite with the second record found.  Therefore, the ORDER BY Clause in the query will set which one is used. 

Example Source Configuration:

 

 

 

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 12/20/2011 11:44 AM.
Last Modified on 10/20/2020 3:59 PM.
Last Modified by Steve Fifer.
Article has been viewed 3524 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article