LabPak to xLab Migration
Several tools are available to export some data from LabPak and Import that data into xLab.
The process consists of two parts:
- Exporting the Data from LabPak
- Importing the Data into xLab
All of the Export application require a valid copy of the LabPak LPIIX folder to be sent to AP-Visions. Note that we can only export data to the extent that the data exists in LabPak. There are three Export tools available:
- Export LabPak Patient Demographics
- Export LabPak Procedures and setup files
- Export LabPak Archival Data.
With the exception of Archival Data, xLab has built in functions to import the data once the export files have been created.
Patient Demographics
Once we have completed the export, a file folder (LabPakExport) is created and the Deployment Associate can use this file to import Demographic information into xLab. Specific instructions follow.
In xLab from the main menu select Patient->Order Entry

Click on Utilities and Select "Import LabPak Demographics".

Using the Browse button, browse to where you placed the "LabPakExport" folder, then click Next.
The File in the Folder is read and parsed to prepare for the import. This can take several minutes depending upon the number of patients and the speed of the computer. When completed you will see a screen simular to the following:

This screen gives you the opportunity ti exclude any patients you do not want to import. Simply un-check the CheckBox for any you do not want to import. Then click Next.

BE PATIENT! Depending upon the number of patients, this process can take up to an hour or so to complete. Once complete, Click Finish.
Procedures
Procedures Export Tool
This tool allows us to export Procedure information, Doctors information, Location information, Species information and, Tech Code information from LabPak. It is run by AP-Visions at our offices and requires a valid copy of the LabPak LPIIX folder to be sent to AP-Visions. Note that we can only export data to the extent that the data exists in LabPak. Procdure information includes Panels, Tests, Reference Ranges and Alpha results.
After compleation by AP-Visions of the export, a Folder containing several files will be created, "LabPakExport". This folder needs to be on the customers xLab Server machine.
Importing Procedures
Some important differences between LabPak and xLab as they relate to Procedures.
LabPak contains Panels which are a collection of LabPak Tests. In LabPak there is one result per LabPak Test. In xLab a Test is a collection of Results and a Panel is a collection of tests. LabPak has no concept of Collection containers where xLab does (including the volume of sample a Collection Container can hold.) During the Import process, LabPak Panels are imported as xLab Tests and some LabPak Tests are imported as xLab Tests. The LabPak Tests that are part of a LabPak Panel are imported as xLab Results. Some LabPak Tests may also be imported as results. During the delection process you will be required to define what Collection Container is required foe a Panel/Test and the volume the Panel/Test requires.
NOTE: While not required, it is a good idea to start with a Clean xLab Database (one that has no tests or results defined).
From the main menu select Utilities._Maintenance->Procedures

Select "Import" then HL-7 File to open the Import screen.

You are promted to read the Importing procedure (this document), Simply click Next.

Browse to where you saved the LabPakExport Folder, then Click Next.

The application will begin parsing the proper file and, when complete, will enable the Next button. (Note this may take several seconds depending upon the number of procedures). When it appears, click Next.

Initally this screen shows you which LabPak Panels exists (Marked "Orderable" Yes) and all LabPak Tests (Marked "Orderable" No).
LabPak Panels: You may mark any of the LabPak Panels to "Include" my checking the appropriate Include check box. Including will mean that the importer will create an xLab Test for the included item and any LabPak "Tests" that are part of the panel will be included as xLab Results for the selected item. NOTE: Do not uncheck any of the LabPak Tests.
LabPak Tests: You may set any of the LabPak Tests to "Orderable" by simply clicking on the "No" which will change it to a yes (Clicking on it again will change it back to No). If set to yes, an xLab Test will be created alone with an xLab Result.
Volume: You must enter a Volume for any Orderable item. This is the volume that the item requires (just like the Volume you select when defineing a new Test in xLab).
Container: You must select a Container for any Orderable Item. The Dropdown for Container lists the xLab Containers already defined in xLab.
Notes: You may optionally enter a note for any Orderable Item. This is the same as the Note you would enter when defining a new Test in xLab.
You may click on any Column name to sort the colume. For example clicking on the Orderable column with sort the rows grouping all of the "Yes" and "NO" together.
NOTE: If any Row is grayed out, it means that an xLab Test (or Result) with the same code already exists in xLab and you cannot Import.
Note: You may export the List (Export CVS) to get a comma deliminated list of all the rows to review before clicking next.
Once you have made your selections, simply click Next.

This Import will run and when Complete, will enable a Finish Button. SImply click on Finish. Once you click on Finish, the Application will open up a Browser Window. Scroll down to the section as shone below and READ IT COMPLETLY before clicking Next.

The import will have imported all LabPak Calculations as they were defined in LabPak as a Comment Record. You must then write the appropriate xLab Script to duplicate the Calculation in xLab.