xLAB Importing LabPak Data
Introduction
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.
NOTE: If you are importing Setup FIles, Import Locations first as they will be required for importing Doctors
Importing LabPak 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.
Importing LabPak Procedure
Before proceeding with importing your LabPak Procedures it is important that you understand the differences between xLab and LabPak as it relates to Procedures and Panels. Of course your Deployment Associate can assist you in this process.
NOTE: You can obtain a "Printer Friendly" version of this screen by clicking here.
If you are importing any calculated results from your LabPak (and almost every customer will) you should also print a copy of "xLab Calculated Results" which describes the xLab Calculated Results Language. Click Here for a Printer Friendly version and print it.
Procedures and Panels in LabPak
In LabPak all reportable entities (anything that shows up on a Report with a value) are considered "Tests". 'Neut#' is a "Test", 'Appearance' is a "Test" as well as 'Glucose' is a "Test". Of course you never "Order" 'Appearance' or 'Neut#' but rather order a "UA" or "CBC"..
In LabPak Panels are a collection of "Tests" and in some cases another Panel. I.E. "CBC" is a Panel in LabPak made up of the "Tests" that are part of a "CBC". "Health Screen" may be a panel simply made up of "CBC" and "CMP".
Tests, Results, and Panels in xLab
In xLab, all reportable entities are considered "Results" and only Orderable items are considered "Tests". In xLab, "CBC" is a "Test" and has multiple Results. 'Neut#' is a "Result" and is part of the "CBC" Test and is never orderable (Unless, of course you have some reason to just order a 'Neut#')..
In xLab, Panels are a collection of "Tests". For example: a "Comprehensive Health screen" may contain a "CBC", "UA" and "BMP"
Test Volume and Containers in xLab
All "Tests" in xLab support a Volume and Container type. For example a "CMP" may require 10 ml volume of sample in a Lavender Top Container. Hepatic Profile may require 5 ml volume of sample in a Lavender Top Container and so on.
Of course there is no counterpart for Container in LabPak.
Why Containers and Volume are important.
In xLab Containers and Volume are used to establish number of sample container labels. Consider an order for a Hepatic Profile (a Lavender Top requiring 5mL) and a CMP (a Lavender Top requiring 10mL). Because we have defined a Lavender Top container that can hold 10mL, xLab can determine that two Lavender Top containers are required and print two labels (on for each Lavender Top Container).
Preparation for Importing Procedures
When the xLab Procedure Import is run it produces a list (for your review) of all LabPak "Tests" and "Panels" (that contained at lease one individual test). By default xLab marks all "Panels" as "Orderable" and all "Tests" as Not Orderable. In addition all "Tests" are marked as "Include" and all Panels are marked as "Do Not Include". Why?
The LabPak Export (used to create the Procedure.exp file) had no way of determining which LabPak "Tests" you normally order so the Import makes an assumption that all LabPak "Tests" are really results. (We know that this is not true however more LabPak "Tests" are not orderable in LabPak than are Orderable). Any of these "Tests" can be made Orderable in xLab simply be entering a Volume, Container, and selecting "Orderable".
The xLab Import also makes an assumption that all LabPak Panels (that contain at least one individual test) are "Orderable". More LabPak "Panels" are orderable than not orderable.

The above image is a small sample of the Import Review screen you will be presented with. Let's take the first line (2 HOUR POST PRANDIAL)
- Do you wish to import 2 HRPP at all? If not, no action on your part is required
- If you wish to Import 2 HRPP, you must enter a Volume, select a Container and optionally enter any Test Specific notes. Notes are displayed in Order Entry. After you enter a Volume and Container, the test is automatically set to Orderable (if if was not) and Include is checked.
Now let's look at A/G Ratio.
- Do you order A/G Ratio as a stand-alone Test? If not, then no action is required (A/G will automatically be imported as a "Result")
- If you wish to make A/G orderable, you must enter a Volume, select a Container, and optionally enter a Note. After you enter a Volume and Container, the test is automatically set to Orderable (if if was not) and Include is checked.
Running the Import Application
Once you "Click" on Next button , xLab will guide you through navigating to where you saved the Exported data, read all of the data and present you with the Step 2 Review screen.
Step 1
Tell the Import where to find the Exported file. (Note, if you are using the Wizard and have imported anything else, the import path will automatically be filled in.). Simply Browse to the folder where you saved the Procedure.exp file. Then Click Next.

After Clicking on Next above, the xLab import will read and parse the Procedure.exp file. It will report any errors it finds (like the one below). Once it has finished the parsing, it will tell you PARSING COMPLETE and the Next Button will appear.
You may print this Progress screen if you encountered any errors. Then Click on Next.

After you click on Next, the xLab Import will build the Review Screen. This can take some time depending upon how may LabPak Tests and Panels you have so be patient.
Step 2
The Review Screen is displayed after completion of the build process.

Make your selections as described in 'Preparation for Importing Procedures" and when done, click on Next to begin the actual importing into xLab.
NOTE:
- It a LabPak Test already exists in xLab, that row will be grayed out and you cannot Import that test.
- You may click on the column headers; Orderable,Code, or Name to sort the Review list in assenting or descending order of that column. Each time you click the order is reversed.
- Hovering your mouse over the column header will expose a Drop Down indicator.
Click in the Drop Down will allow you to filter by items in that column in various ways.
You can Uncheck (Select All) then select only those tests you want in the list. You can also use the Test Filter to find one or more specific tests.
You can select criteria from the (Not Set) drop down and enter a value in the Text Box.
For example, you could select "Begins with" and enter an the letter A to list only Test Codes (in this case) beginning with the letter A. You can also find a specific Test by using "Equals" and entering the Test Code.
Step 3
After entering volumes and Containers and selecting what to not to import, click on Next and the Import process will start.

Once the import is finished, the Finish Button will be shown. You may print the list of the imported items for your records.
After you Click on Finish, if you imported any Calculated Results, you will be taking to the "Update Imported Calculations" screen.
Update Imported Calculations
The following assumes you have printed and read the "xLab Calculated Results" manual. If you have not, please do so now by Clicking Here
xLab provides an extensive feature rich Calculated Results language designed to enable the user to create a Calculated Result for virtually any logic and equation required. LabPak calculation definitions are considerably different than xLab's calculation definitions, as such, xLab imports the calculation definition from LabPak as a Comment. This allows you to see what the LabPak calculation looked like and provides guidance in defining the calculation in xLab.
The Update Imported Calculations Screen lists all of the Calculated Results that you imported and allows you to select them individually so update the calculation to the xLab format.

Simply click on a Calculated result to allow updating.

As you can see from the image above, xLab presents the LabPak Calculation as a comment. You may (and should) leave the comment in and add the xLab Language version of the calculation. In this simple case, we have added the xLab Language calculation below the comment.

After updating all of the Imported Continuations, Click on "Done"
Importing Locations
In xLab select Utilities->Maintenance->Locations from the main menu. Then select Import->HL-7 File. Browse to the LabPakExport folder then click Next. A list of locations will be displayed, simply click Next.
Importing LabPak Doctors
xLab Physicians must have an Npin Number and must be associated with one or more Locations. If your LabPak Export does not have Npin numbers you can "Assign Random Npin numbers" which will create an Npin using the Doctors Code and a random number. You cannot import Doctors unless they have an Npin number.
In xLab select Utilities->Maintenance->Physicians from the main menu. Then select Import->HL-7 File. Browse to the LabPakExport folder then click Next.

You can edit any of the fields for any Doctor.
LabPak did not support the Doctor to Location relationship. You may;
- Check the "Set All Doctors to use all Locations". You man then individually change Locations for any selected Doctor (by clicking on the "Locs" column and then the elipsis button)
- Assign Locations indipendantly for each Doctor (by clicking on the "Locs" column and then the elipsis button)
- Ignore assigning Locations and doing it later (You will receive a Warning but can simply proceed.
Once you are ready, Click on Next. The import will begin and when done Click on Finish.
Importing Canned Comments
xLab supports associating Canned Comments with specific xLab Dropdowns. For example: Some comments are used only for Result Comments so xLab allows seeting the Comment for Results only. This cases the Comment to appeary only for commenting results.
In xLab select Utilities->Maintenance->Comments from the main menu. Then select Import->HL-7 File. Browse to the LabPakExport folder then click Next.

The type of comment defaults to All. Modify the Type of comment as desired, then Click Next.
Importing Tech Codes
xLab contains more fields that were available in xLab. Specifficaly; Group and Start Up Screem. Before Importing Users you will need to set both the Group and Start Up Screen for each user. Import only those techs you need.
In xLab select Utilities->Maintenance->Ysers from the main menu.
You may set the Default Group and Default Startup Screen. Any techs where you did not speciffically set the Group or Start Up screen will be set to the selected Defaults during Import. Select your Defaults from the DropDowns, Browse to the appropriate Folder, then Click Next.

Then select Import->HL-7 File. Browse to the LabPakExport folder then click Next.

Passwords are required, supply any missing passwords, ensure all techs (that you wish to import) have a Group and Start Up Screen, You may also add additional missing indormaiton (Last name and first name, then Click Next.
Once complete, Click Finish.
AP-Visions is a leading provider of IT healthcare solutions to seamlessly manage, move, store, and report all your electronic laboratory data.


