The Hach WIMS Direct Server-Side Interface to Custom Q13156 LIMS imports values from Microsoft Access database files.  The interface is intended to import data from external (commerical) labs who produce Microsoft Access database files that contains an EDD table with the required fields.  The interface processes all MDB files under an appointed input folder. Once the MDB file has been processed, it is moved to an archive folder.

The interface will query out data from an EDD table within the MDB file. The fields are defined in Source Configuration for this interface. The source data is matched to a field referred to as LIMS Location and LIMS Test and each one can be associated with any field in the database. The default value for LIMS Location is 'SampleLocation' and the default value for LIMS Test is 'Analyte'.

SPECIAL CASE:

When a value does not match any variable, the value is written to a "Catch-All" type variable. This is a special condition where the LIMS Location in Hach WIMS is set to CATCH-ALL, and the LIMS Test field is set to SPECIAL, as shown below:

Notice this is set to be a minutely variable. Also, if you set this as a parameter, the MDL Rules must be enabled:

The other fields available to import into Data Additional Information fields are:

• SAMPLEID - Sample ID
• SAMPLELOCATION - Sample Location, used as the LIMS Location field by default
• SAMPLERID -Sampler ID
• SAMPLEDATE - Sample date and time
• RECEIVEDDATE - Received date and time
• EXTRACTIONDATE - Extraction date and time
• ANALYSISDATE - Analysis date and time
• ANALYST - Analyst
• SAMPLETYPE - Sample type
• MATRIX - Matrix
• ANALYTE - Test or analyte, used as the LIMS Test field by default
• METHOD - Method
• UNITOFSAMPLE - Units, which is also default for the Units import by default
• QUALIFIERS - Qualifier, used as the qualifier on import by default
• DETECTIONLIMIT - Detection limit
• REPORTINGLIMIT - Reporting limit
• LABNOTES - Lab notes are retrieved based on qualifier from the TextBody field in LabNotes table.