The Hach WIMS Direct Server-Side Interface to Aspen LIMS imports values from Telecations' Aspen LIMS and brings the value into Hach WIMS.

The interface will query out the data by when it was approved (table.field - TESTS.APPROVEDDATE) and store the results when the sample was collected (table.field - SAMPLES.COLLECT_DATE). The user can specify LIMS Location and LIMS Test if they wish to use something other than the default values. The defaults are:

• LIMS Location - SAMPLES.SAMPLEID
• LIMS Test - TEST.TESTID

The result captured (TESTS.REPORTEDRESULT) is evaluated for symbols.

Other values from Aspen can be imported using Additional Info (see Configuration - Advanced Configuration: Additional Info for details).

The fields available to import into properly configured Additional Info fields are:

• TESTCOMMENT - Test Comments from TESTS table
• SAMPLENOTE - Sample Notes from SAMPLES table
• DATAQUALIFIER - Data Qualifiers from TESTS table
• LABNUMBER - Lab Number from SAMPLES table
• APPROVEDDATE - Approved Date from TESTS table (this date field is used by the interface to determine what values to import, the data is stored based on the date contained in COLLECT_DATE in SAMPLES table)