LIMS Interface Flyer

Other Data EntryIntegrate seamlessly to your Laboratory Information Manage-ment System (LIMS) or other application to eliminate double entry and increase data accuracy.LIMSProgramTest results areapproved andlogged into LIMSState ReportsProcess ControlReportsOther ReportsGraphingOnce data is entered into the LIMS program, it is transferred via a text file to theOperator10® orSynexus™ software database, automatically or manually.Using features in the Operator10 or Synexus program, data is then used for reporting and process control information.Operator10Wastewater, Water, BiosolidsSynexusPretreatmentOperator10/Synexus - Import FileExample Data09/01/00,~~1,Plant Effluent,BOD5,15.509/01/00,~~1,Plant Effluent,pH,7.509/01/00,~~1,Plant Effluent,Lead TOT Recov,10.9209/01/00,~~1,Plant Effluent,Temp Water C,8.9309/01/00,~~2,PlantTap,Turbidity NTV,.11209/01/00,~~2,PlantTap,ALK TOT CaCO3,51.809/02/00,~~1,Plant Effluent,BOD5,<14.109/02/00,~~1,Plant Effluent,pH,7.309/02/00,~~2,PlantTap,Turbidity NTV,.12509/02/00,~~2,PlantTap,ALK TOT CaCO3,AAA data line consists of date, time (optional), facility ID, location, parameter and data value.The data value may be a daily or hourly numeric value, less than, greater than or alpha code. The file can contain values for multiple facilities, dates, times, location and parameters.Other remaining data is then entered via SCADA or DataPort interfaces or by manual entry. SCADAInterfaceDataPortInterfaceManualEntryLIMS Data ImportText File Import UtilityIntegration has never been easier with the built-in LIMS import function, standard in Operator10 water, wastewater, biosolids, and Synexus pretreatment software. Compatible with LIMS Express®, Tribal®, Lab Works®, Lab Lynx®, Sample Master®, Aspen®, and almost all others.There is a new import utility application called “OP10_Imp.exe”. Its purpose is to allow seamless integration of data from other applications into the Operator10 or Synexus database, and may be used to import data to multiple facilities.The utility must be run from the directory where the OP10 License is located. It runs transparently, without user intervention. Basic information and all errors are recorded in the “Imp_log.txt” file.A data file must be named “Op10.imp” and also reside in the license directory. Each line in the PLC file must either be:• Blank• A comment, beginning with a semicolon ( ; ) or tab• A data line consisting of a: ? date ? space and a time (optional) ? comma (,) or tab ? facility ID ? comma (,) or tab ? location ? comma (,) or tab ? parameter ? comma (,) or tab ? data valueThere should be NO spaces before or after commas. All portions of the line must be valid in order for the import to succeed. The date may be in any of the supported Operator10 or Synexus date formats. The data value may be a numeric value, less than, greater than, alpha code, etc.For example, the line “09/01/00,~~1,PlntIf01,Flow Mgd,1.6” imports a numeric daily data value of 1.6 into the “AllMax Wastewater Sample Data” facility (facility ID “~~1”), using location “PlntIf01” and parameter “Flow Mgd”.To prevent data file conflicts and re-importing of data, the data file is initially renamed to “Op10.im~”. After processing, the file is renamed to “Op10.im”. Existing files are overwritten if/when another import is done.LIMS Data Import FunctionAllMax Software, Inc.911 S. Main St., P.O. Box 40, Kenton, OH 43326800-670-1867 419-673-8863 Fax: 419-673-8864sales@allmaxsoftware.com www.allmaxsoftware.com