|J Pathol Inform 2014,
Streamlined sign-out of capillary protein electrophoresis using middleware and an open-source macro application
Gagan Mathur1, Thomas H Haugen2, Scott L Davis1, Matthew D Krasowski1
1 Department of Pathology, University of Iowa Hospitals and Clinics, Iowa City, IA, USA
2 Department of Pathology, University of Iowa Hospitals and Clinics; Department of Pathology, Veteran Affairs Medical Centre, Iowa City, IA, USA
|Date of Submission||14-Jun-2014|
|Date of Acceptance||01-Aug-2014|
|Date of Web Publication||30-Sep-2014|
Department of Pathology, University of Iowa Hospitals and Clinics, Iowa City, IA
Source of Support: None, Conflict of Interest: None
| Abstract|| |
Background: Interfacing of clinical laboratory instruments with the laboratory information system (LIS) via "middleware" software is increasingly common. Our clinical laboratory implemented capillary electrophoresis using a Sebia; Capillarys-2™ (Norcross, GA, USA) instrument for serum and urine protein electrophoresis. Using Data Innovations Instrument Manager, an interface was established with the LIS (Cerner) that allowed for bi-directional transmission of numeric data. However, the text of the interpretive pathology report was not properly transferred. To reduce manual effort and possibility for error in text data transfer, we developed scripts in AutoHotkey, a free, open-source macro-creation and automation software utility. Materials and Methods: Scripts were written to create macros that automated mouse and key strokes. The scripts retrieve the specimen accession number, capture user input text, and insert the text interpretation in the correct patient record in the desired format. Results: The scripts accurately and precisely transfer narrative interpretation into the LIS. Combined with bar-code reading by the electrophoresis instrument, the scripts transfer data efficiently to the correct patient record. In addition, the AutoHotKey script automated repetitive key strokes required for manual entry into the LIS, making protein electrophoresis sign-out easier to learn and faster to use by the pathology residents. Scripts allow for either preliminary verification by residents or final sign-out by the attending pathologist. Conclusions: Using the open-source AutoHotKey software, we successfully improved the transfer of text data between capillary electrophoresis software and the LIS. The use of open-source software tools should not be overlooked as tools to improve interfacing of laboratory instruments.
Keywords: Capillary electrophoresis, instrumentation, laboratory information system, middleware, open-source software
|How to cite this article:|
Mathur G, Haugen TH, Davis SL, Krasowski MD. Streamlined sign-out of capillary protein electrophoresis using middleware and an open-source macro application. J Pathol Inform 2014;5:36
|How to cite this URL:|
Mathur G, Haugen TH, Davis SL, Krasowski MD. Streamlined sign-out of capillary protein electrophoresis using middleware and an open-source macro application. J Pathol Inform [serial online] 2014 [cited 2021 Jul 24];5:36. Available from: https://www.jpathinformatics.org/text.asp?2014/5/1/36/141990
| Introduction|| |
Clinical laboratories are a key component of modern health care.  Modern laboratories are equipped with increasing number of sophisticated instruments, which provide precise and accurate diagnostic information and help physicians make correct clinical decisions.  For proper workflow in the laboratory, interfacing of clinical laboratory instruments with the laboratory information system (LIS) via "middleware" software is increasingly common.  Some instruments come with vendor supported middleware, but most of the time a third party middleware facilitates this interfacing. ,
The core clinical laboratory at University of Iowa Hospitals and Clinics replaced gel electrophoresis and implemented capillary electrophoresis using a Sebia® Capillarys-2™ (Norcross, GA, USA) instrument for serum and urine protein electrophoresis. University of Iowa Hospitals and Clinics is a quaternary care academic medical center which includes a multiple myeloma treatment service. Our laboratory performed 3250 serum protein electrophoresis (SPE), 2548 serum immunofixation electrophoresis (SIFE), 528 urine protein electrophoresis, Twenty four hour (UPET), 188 urine protein electrophoresis, random specimen (UPE) and 886 urine immunofixation electrophoresis (UIFE) during 2012-2014. Our laboratory utilizes Data Innovations Instrument Manager (South Burlington, Vermont, USA) as a middleware to establish communication between most of our instrument and Cerner Laboratory Information System (Kansas City, MO, USA).  This same middleware was used for data transfer between Sebia® Capillarys-2™ instrument and Cerner LIS. The interface after initial troubleshooting successfully allowed bi-directional transmission of numeric data, that is, the total protein value and its fractions. However, the text of the interpretive pathology report was not properly transferred. The incompatibility between instrument, middleware and LIS resulted in losing the text formatting during the transfer [Figure 1]. This resulted in manual re-entry of interpretive text and made the system prone to copy-paste errors. ,
|Figure 1: Screen 1 showing Sebia interface, screen 2 showing unformatted transferred interpretation in laboratory information system (LIS) and screen 3 showing formatted interpretation in LIS transferred with the help of AutoHotKeys|
Click here to view
| Materials and methods|| |
After exploring options for this trivial appearing problem, we evaluated AutoHotkey (http://www.autohotkey.com), a free, open-source macro-creation and automation software utility.  Scripts were written in AutoHotkey to create macros that automated mouse and key strokes (script included in the supporting material). The scripts retrieve the specimen accession number, capture user input text, and insert the text interpretation in the correct patient record in the desired format [Figure 2].
AutoHotkey was also used to create abbreviations for various interpretation templates [Table 1]. These keystrokes which are sent in response to typed abbreviations are known as "hotstrings."  In addition, AutoHotkey automated repetitive nonintuitive keys strokes which were required for maneuvering through our LIS. Using AutoHotkey, we were able to save a substantial number of nonintuitive keystrokes involved in sign-out [Table 2].
|Table 2: Key strokes to sign-out electrophoresis and number of keystrokes saved |
Click here to view
| Results|| |
The Autohotkey scripts executed well and accurately transferred narrative interpretation into the LIS in desired text formatting [Figure 1], thus reducing the manual effort of reentering the interpretation and also decreased the possibility for error in text data transfer. The scripts were basically executing copy-paste in an automated way. An important additional feature was that the script acquired both the accession number and the specimen type (e.g. SPE and SIFE for serums and UPE, UPET and UIFE for urines) from the Sebia instrument. Using the accession number and the specimen type, the script opened the patient's record for this specimen in the LIS. This step ensured that the narrative was inserted into the correct patient record and type. Errors in patient and sample identification are minimized. The result was smooth and efficient transfer of data in the correct patient record.
The Autohotkey scripts were easy and intuitive to learn by users. Executing the script for transferring the text data included just two simple key strokes [Table 2], thus facilitating ease of adoption by pathology residents who rotated through the clinical chemistry service. Scripts allow for either preliminary verification by residents or final sign-out by the attending pathologist [Figure 3]. Finally, the scripts promoted a nearly paperless process for data entry into the electronic record.
| Conclusions|| |
Using the open-source AutoHotKey software, we successfully improved the transfer of text data between capillary electrophoresis software and the LIS. Open-source software allows the end user to review, modify, or share the source code, blueprint or design of the software for their own needs, customization, curiosity or troubleshooting under defined terms and conditions.  Open-source software are often free or available at low cost. Although open-source software have been successfully used in many fields of medicine like imaging, electronic medical records, electronic health records, public health and bio surveillance, research, etc.,  but there is no published data on use of open-source software for interfacing clinical laboratory instruments with the LIS or middleware. Proper interfacing of complex laboratory instruments often requires sophisticated middleware software, but compatibility issues arise from time to time and hinder smooth functioning of an automated laboratory. Open-source software tools should not be overlooked as tools to improve interfacing of laboratory instruments.
| References|| |
|1.||Kurec AS, Lifshitz MS. General concepts and administrative issues. In: Abraham NZ, Bluth MH, Bock JL, Hutchinson RE, Massey HD, Miller JL, et al., editors. Henry's Clinical Diagnosis and Management by Laboratory Methods. 22 nd ed. Philadelphia, PA: Elsevier/Saunders; 2011.p.3-12.e1. |
|2.||Killeen AA. The clinical laboratory in modern health care. In: Longo DL, Fauci AS, Kasper DL, Hauser SL, Loscalzo JJ, editors. Harrison's Principles of Internal Medicine. 18 th ed., Ch. 53. New York City, NY: McGraw-Hill; 2011. |
|3.||Pantanowitz L, Henricks WH, Beckwith BA. Medical laboratory informatics. Clin Lab Med 2007;27:823-43, vii. |
|4.||Wagner KL. Middleware to 'littleware': Vendors catering to smaller labs. CAP Today 2011;3:14-18. |
|5.||Swain M, Patel V. Health Information Exchange among Clinical Laboratories. ONC Data Brief 2014, No. 14, February, 2014. |
|6.||Krasowski MD, Davis SR, Drees D, Morris C, Kulhavy J, Crone C, et al. Autoverification in a core clinical chemistry laboratory at an academic medical center. J Pathol Inform 2014;5:13. |
|7.||Siegler EL, Adelman R. Copy and paste: A remediable hazard of electronic health records. Am J Med 2009;122:495-6. |
|8.||Bowman S. Impact of electronic health record systems on information integrity: Quality and safety implications. Perspect Health Inf Manag 2013;10:1c. |
|9.||autohotkey.com. AutoHotkey-A scripting language for desktop automation Free and Open Source software, licensed under the GNU GPLv2. Available from: http://www.autohotkey.com/. [Last updated on 2014 Aug 16Last cited on 2014 Jun 13]. |
|10.||opensource.org. Open source initiative. Available from: http://www.opensource.org/licenses. [Last updated on 2014 Jun 09; Last cited on 2014 Jun 09]. |
|11.||Wikipedia contributors. List of open-source healthcare software. Wikipedia, the Free Encyclopedia. Available from: http://www.en.wikipedia.org/w/index.php?title=List_of_open-source_healthcare_software and oldid=611874172. [Last updated on 2014 Jun 06; Last cited 2014 Jun 13]. |
[Figure 1], [Figure 2], [Figure 3]
[Table 1], [Table 2]