test Browse by Author Names Browse by Titles of Works Browse by Subjects of Works Browse by Issue Dates of Works

Advanced Search
& Collections
Issue Date   
Sign on to:   
Receive email
My Account
authorized users
Edit Profile   
About T-Space   

T-Space at The University of Toronto Libraries >
Journal of Medical Internet Research >
Volume 1 (1999) >

Please use this identifier to cite or link to this item: http://hdl.handle.net/1807/4519

Title: CIS1/336: Use of a Database Program to Convert Laboratory Information System (LIS) Data to Intranet Web Pages
Authors: Massey, L
Keywords: Abstract
Clinical Laboratory Information Systems
Hospital Information Systems
Database Systems
Issue Date: 19-Sep-1999
Publisher: Gunther Eysenbach; Centre for Global eHealth Innovation, Toronto, Canada
Citation: L Massey. CIS1/336: Use of a Database Program to Convert Laboratory Information System (LIS) Data to Intranet Web Pages. J Med Internet Res 1999;1(suppl1):e6 <URL: http://www.jmir.org/1999/suppl1/e6/>
Abstract: [This item is a preserved copy and is not necessarily the most recent version. To view the current item, visit http://www.jmir.org/1999/suppl1/e6/ ] Introduction: The composition of Laboratory Ward Manuals is a time-consuming exercise. To keep manually prepared books up-to-date requires constant effort, amounting to several days or weeks of activity every year. As most of this information is found in the various tables of the usual Laboratory Information System (LIS), it should be possible to reformat this data into a form suitable for publishing on paper or on Web Pages. When the three hospitals in Saskatoon became part of a single operating entity, it became a necessity to redo the procedure manuals and ward manuals for all of the laboratories. As part of this exercise, we sought ways to minimize the work required. One method was to automate the ward manuals. Accordingly, an automated way of producing an Intranet ward manual was devised to reduce the work of the laboratory staff in this continuing endeavour. Methods: The query language of the SoftLab LIS (SCC Clinical Information Systems, Palm Harbor, Fla, USA) was used to extract standard test data, including various descriptive terms, specimens required, minimum volumes, reference ranges, &c, &c in a comma-delimited form for input to a database application program. Paradox 8 (Corel Corporation) was used to build the several files necessary to hold the various forms of data from the many databases of the LIS. Paradox Macros were written to combine records from the various files into a single record containing concatenated strings to format the appropriate data in a form, which would display in a single column in the ultimate report. Using the standard Paradox report forms, HTML Web pages could then be generated which became available for publishing on the Hospital Intranet. Results: This procedure was used with the Saskatoon LIS to produce Intranet Web Pages, and also a print version of the Ward Manual). Once the Paradox Macros have been debugged, preparation of the updated Web Pages takes only a few minutes, and updates can be incorporated almost completely automatically. Discussion: Spread Sheet (SS) and Database (dB) Handlers have become highly flexible tools for generating many different types of reports, from almost any form of data. With the addition of HTML generation capabilities in the standard dB and SS application programs this becomes an even easier matter. This puts highly sophisticated Web Page generation capabilities into everyone's hands.
URI: http://hdl.handle.net/1807/4519
ISSN: 1438-8871
Other Identifiers: doi:10.2196/jmir.1.suppl1.e6
Rights: Copyright (cc) Retained by author(s) under a Creative Commons License: http://creativecommons.org/licenses/by/2.0/
Appears in Collections:Volume 1 (1999)

Files in This Item:

File Description SizeFormat
jmir.html4.75 kBHTMLView/Open

Items in T-Space are protected by copyright, with all rights reserved, unless otherwise indicated.