Temperature logger files, in text format (.txt) can be imported by approved laboratories.
Prerequisite:
The File name must be a concatenation of the data logger ID ("Temp Logger ID) and the date of sample reception by the lab (in local time) separated by an underscore.
Example: Temp Logger ID = "KG34V10".
Date of sample reception (YYYY-MM-DD) ="2015-03-25".
Filename="KG34V10_2015-03-25.txt".
How to import a new temperature logger file
- Login as an Approved Laboratory user
- Go to Import Temp Logger File
- Click Choose File to browse to the relevant temp logger file
- click Import.
The page also lists the import history of the past 3 months - Wait for the import status to be complete
- The "Details" function offers four options:
- Print: to print the current page
- Close: to leave the screen
- Post: to submit the import (the status will be "Submitted" instead of "temporary").
- Reject import: in case of errors, the user has the possibility to reject the file (the system will not take into account this file).
- When the import of a temperature logger file is successful and the import is posted by the user (status is changed to "Submitted"), a match is triggered with a matched DCF and BPLR.
Supported formats
Currently ADAMS supports Data in the following formats:
Case 1: 3 columns separated by tab/space. This format is used by the company Berlinger.
-
- First column is date in the format yyyy-MM-dd.
- Second column Time in the format HH:mm (24 hour clock)
- Third Temperature. And it should be in English format. For example 4.6 but not 4,6
- Example: 2017-01-24 14:20 11.8
Sample file: GVREAL_2017-02-06.txt
Case 2: 4 columns separated by tab/space. This format is used by the company Sensitech
- First column is a row number.
- Second column is date in the format yyyy/MM/dd.
- Third column Time in the format HH:mm:ss (24 hour clock)
- Fourth Temperature. And it should be in English format. For example 4.6 but not 4,6
- Example: 1 2016/12/14 5:02:58 22.61
Sample file: CN83100R50_B_2017-03-06.txt
Case 3: 5 columns separated by tab/space. This format is used by the company Sensitech
-
- First column is a row number.
- Second column is date in the format yyyy/MM/dd.
- Third column Time in the format hh:mm
- Fourth column is AM/PM Marker
- Fifth Temperature. And it should be in English format. For example 4.6 but not 4,6
- Example: 1 2016/12/14 4:01 PM 2.22
Sample file: CN83100R50_C_2017-03-06.txt
Case 4: 5 columns separated by tab/space. This format is used by the company LogTag
- First column is a row number.
- Second column is date in the format yyyy/MM/dd.
- Third column Time in the format hh:mm:ss
- Fourth column is AM/PM Marker
- Fifth Temperature.And it should be in English format. For example 4.6 but not 4,6
- Example: 1 2016/11/21 06:47:24 PM 26.0
Sample file: LogTagFormatD_2016-11-27.txt
Temp Logger file examples
For references, here are examples of supported temp logger file format: