LIMS.eu

The eTermin LIMS Integration: With the integrated WebPush function of eTermin, bookings including name, first name, address, collection date, etc., can be directly transferred to the Labordatenbank LIMS.

eTermin is a leading appointment booking tool used by test centers and laboratories to manage appointments for swab collection for Covid-19 rapid and PCR tests. With the eTermin interface, you can transfer booking details to the Labordatenbank before swab collection. As a laboratory, you do not need to record any further data and can directly process the booking details.

Proceed as follows to create an eTermin import interface in the Labordatenbank:

1.) Create a new import interface in the Labordatenbank with the following settings:

Data type: Import samples
Sample template: Select appropriate template (it's best to create your own eTermin sample template)
Separator: Semicolon
Line break: LF
Character set: UTF-8
Date format DD.MM.YYYY hh:mm:ss

Do not upload a sample file and do not perform any mapping.

2.) Activate data transfer via HTTPS and assign a username and a secure password. Note down the URL.

3.) Log in to eTermin and navigate to API Interfaces -> API & Web Push and activate the "Send Web Push" button. Enter the noted URL into the field and insert the username and password, separated by a colon, between https:// and labordatenbank.com. Click "Save changes" and book a new appointment or click "Send WebPush (CREATED) with test values."

4.) Switch back to your Labordatenbank LIMS and check if data has arrived. You should see a failed import. If this is the case, it means that data from eTermin is reaching the LIMS.

5. The data arrives in the Labordatenbank in an eTermin-specific format and must be converted into a format suitable for the Labordatenbank using a transformation code.

eTermin Transformation Code

function transform (data) {
  const result = {}
  
  data
    .split('&')
    .forEach(d => {
      const row = d.split('=')
      result[row[0]] = decodeURIComponent(row[1])
    })
  
  result['STARTDATETIME'] = dayjs(result['STARTDATETIME'], 'YYYYMMDD+HHmmss').format('DD.MM.YYYY HH:mm:ss')
  result['ENDDATETIME'] = result['ENDDATETIME'].replace('+', ' ')
  result['STARTDATETIMEUTC'] = result['STARTDATETIMEUTC'].replace('+', ' ')
  result['ENDDATETIMEUTC'] = result['ENDDATETIMEUTC'].replace('+', ' ')
  result['TOWN'] = result['TOWN'].replace('+', ' ')
  result['STREET'] = result['STREET'].replace('+', ' ')
    result['FIRSTNAME'] = result['FIRSTNAME'].replace('+', ' ')

return [result]
}

6.) Perform the desired mapping by manually adding the individual attributes

7.) In the "Translations" field, store the eTermin entries "Herr" (Mr.) and "Frau" (Ms.) into the gender information "männlich" (male) and "weiblich" (female) required for DEMIS notifications.

8.) Check the created samples

Tips:
a.) If you map the ID field to the sample designation, you can directly scan the eTermin QR code from the patient's smartphone upon their arrival and automatically set the sample to "in progress" status.
b.) eTermin can send three types of data records: CREATED for new appointments, MODIFIED for changes to existing appointments, and DELETED for canceled appointments. We have described here the creation of a sample using a sample import interface. For modifying an existing sample with MODIFIED, the import interface type "Update sample master data" should be used.