Migrating to LabHQ
Importing Result Data
It is possible to import existing result data from another LIMS or other data sources by using the import results data feature of LabHQ.
ℹ️ The Import: Result data permission is required to import results data to LabHQ.
Data Formatting
Results data uploaded to LabHQ must be in a CSV file adhering to the RFC-7180 standard containing the following headings and data types:
| Header Name | Required? | Data Type | Description | Limitations |
| SampleIdentifier | Y | text | Unique sample ID | - |
| Result | Y | text | Result value | - |
| Product | Y | text | Product name | Max of 100 characters** |
| Client | Y | text | Client name | Max of 100 characters** |
| TestMethod | Y | text | Test method name or ID | Max of 100 characters** |
| TestOutput | Y | text | Test output name or ID | Max of 100 characters** |
| SubmittedOn | Y | date | Date of result submission | ISO 8601 e.g. 2022-09-15T13:16:43 |
| SpecResult | N* | text | Specification result | "Pass", "Warning", "Fail", "N/A" |
| SpecDescription | N* | text | Description of specification | Max of 2000 characters* |
| SpecLower | N* | numeric | Lower specification limit | - |
| SpecUpper | N* | numeric | Upper specification limit | - |
| SpecTrendLower | N* | numeric | Lower trend limit | - |
| SpecTrendUpper | N* | numeric | Upper trend limit | - |
While data for these fields is not required, the uploaded CSV must still have these headers present. Any data over these limits will be truncated and any characters over the limit will be lost.
A template CSV file is provided below:
How to Import Result Data into LabHQ
To upload a CSV file containing results data to be imported to LabHQ:
- Go to Administration > More Settings, or select the Administration icon (cog) from the top toolbar.
- From the Administration screen, select the [ Import ] button next to Import Result Data to open the file upload window.
- Select the CSV file containing the results data that you would like to upload, either by dragging and dropping the file or by selecting the [ Browse for File ] button.
- A progress bar will track the progress of your upload. Once your file has been uploaded it will be processed by LabHQ - this can take some time.
- When LabHQ has processed your uploaded results data a confirmation message will appear in the audit log. If the upload fails a list of errors is shown in the audit log.
- Your imported results data will now be available to view under Reporting Trend.
Limitations
- A file limit of 200MB applies to the imported results data. CSV files over 200MB will be rejected and no data uploaded.
- CSV filenames must not contain spaces (remove them prior to upload). The only permitted characters are alphanumeric and the following special characters:
!-_.*'() - Imported results data will only be visible within LabHQ’s reporting tools when at least one result with a matching client, product, test method, and test method output has been entered via the lifecycle of LabHQ (i.e. not imported).
ℹ️ Only a single CSV file containing results data may be imported. Uploading a CSV results data file into LabHQ will overwrite any previously imported data.