Import Laboratory Test Data

Complete

The Import Laboratory Test Data window is used to import laboratory test data for offline laboratory providers.

This can be used to:

  • create and update the laboratory tests for a provider
  • update the unit prices for products that use the tests

File format

The file must be specified in a comma-separated-values format, containing the following columns:

Column Required Type Description
Laboratory Yes String The laboratory name. Alphanumeric.
Code Yes String The test code. This is the laboratory's unique identifier for the test.
Name Yes String The test name.
Description No String The test description.
Specimen No String Specimen collection details.
Turnaround Time No String A description of the turnaround time.
Price Yes Number The cost price.

Import

On import, a list of the imported tests will be displayed. If the tests haven't been imported before, enter the Investigation Type that the tests will be associated with.

Click Next to save any changes.

The Update Product Prices window will be displayed.
Here, products that use the tests will be shown, if their current cost price is different to the sum of the test prices.

Select the products that should be saved.
By default, all those products whose unit prices have increased will be selected.

Click OK to save selected products.

Limitations

The following products will not be updated if a test price changes:

  • Products that only have fixed prices
  • Products with unit prices that have Pricing Groups