Data Connection Test | Software for Health Foundation

Building the new Data Connection Test (DCT) Mobile Application & Server

2020-05-22T15:47:54+00:00

During our work in connecting diagnostic devices out in the field, it became clear that not all locations were created equally. Sometimes there would be little to no issues with connecting to the mobile internet, whereas in others, it was an everyday struggle.

Evaluating the quality of a site before a site visit was essential to a successful deployment. Due to a phone’s small form factor, one could be mailed physically to a site, preconfigured with the data sizes and SIMs that should be used. This would allow us to test with multiple phones and networks and limit user error.

Partnering with FIND, we needed a way of determining the compatibility of a site by instructing local teams and cutting out the need for expensive diagnostic equipment.

The mobile application that we produced, DCT - also referred to as the ‘parachute phone’ – is cross-platform. It will run on both iOS and Android, as well as older Windows phone technology. In order to collect the testing results, there is a centralised server deployed in the cloud that collects and reports on the results from each site; this is also the endpoint that is used for testing.

Connectivity Toolbox

2022-08-24T13:35:43+00:00

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus lacus augue, maximus scelerisque erat id, lobortis vehicula metus. Proin tristique laoreet augue, vitae tristique ligula. Vivamus quis mauris consectetur tortor aliquet gravida. Fusce congue sem nibh, nec varius nisi laoreet non. Fusce suscipit tortor interdum nibh maximus euismod sit amet sit amet est. Nam nec velit porta, facilisis metus id, ullamcorper turpis. Etiam eros erat, semper in sem vel, convallis cursus dui. Donec sed volutpat sapien. Suspendisse ut erat id tellus dapibus euismod eget volutpat augue. Suspendisse potenti. Proin quis diam sodales, pharetra ante quis, sollicitudin leo. Maecenas magna mauris, vestibulum ut nunc quis, tristique bibendum nisl.

Features & Use-cases

2020-09-08T16:08:07+00:00

Open Interop is designed to support unlimited customisation and data manipulation, allowing a complete and comprehensive data system structure.

Our open-source software is already being utilised by the industry, including WHONet and point of care devices to enhance their data management.

Transforming data

Once the platform has received the data, it can be transformed using Open Interop's 'Tempr' (Templated endpoint mapping record) definitions. This can be configured in a number of ways, the simplest being a template builder which lets you select field names and define their endpoint. Alternatively, you can write the template manually using a popular mapping syntax called Moustache.js, or you can write code which will generate your output (currently only JavaScript is supported at release).

You can also chain Tempr's together, which allows you to perform an additional action based on the results of the previous Tempr. This is beneficial if you would like to create a record in your EMR and then use the ID of said record in another request, for example to update a surveillance system.

Transmitting data

Open Interop allows you to transmit data in a number of ways:

HTTP requests in JSON format, this includes HL7 FHIR (available at release)
HTTP requests in XML format (Planned Q1 2020)
Streamed TCP socket data (Planned Q1 2020)
Streamed UDP socket data (Planned Q1 2020)

You can optionally choose to store the request and response of these transmissions – therefore, storing the data that is transmitted to the platform (though purely for debugging purposes). When used in a production environment, the interoperability layer does not persist data that is passed through it.

How does it work?

Open Interop is designed to support unlimited customisation and data manipulation, allowing a complete and comprehensive data system structure. Configured to receive data in JSON, HL7 FHIR, XML, and CSV formats, Open Interop provides unrivalled flexibility.

You can build your own services and deploy them to the architecture to introduce your own data sources, or intermediary middleware, in order to process, encrypt, and otherwise manipulate the messages received by the platform.

Current uses

Open Interop has been deployed onto embedded hardware and can be used on a very small form factor to fit in your pocket for site visits if required.

We have current use cases wherein Open Interop receives data from a number of systems including WHONet, point of care devices, and simple spreadsheets via the use of data connectors. In addition to this, API based data generators are used to simulate device testing. We can manipulate this data and transmit it into DHIS2 as an event line listing for trackers, specifically into the WHO's TB tracker.

ODX - An Innovative Application for Spreadsheet Standardisation

2022-08-05T15:44:42+00:00

Our recent work launching an AMR Surveillance System in Nepal highlighted the recurring issue that exists in standardising spreadsheet data from multiple locations. The human and animal data gathered for transmission into the Nepal One Health system was coming from over 20 different laboratories, with multiple spreadsheet formats used by the locations. Prior to this innovation, data had to be manually cleansed and reformatted by individuals within Nepal’s National Public Health Laboratory (NPHL) and Central Veterinary Laboratory (CVL). This process was extremely time consuming, so the requirement for a more automated cleansing mechanism was identified early on in the project. To address this issue, and simplify the data cleansing process, SfHF has developed a desktop application, Open Data XLS Transformer (or ODX), which can be mapped to automatically cleanse and standardise spreadsheets ahead of loading them into an analytics platform, or health information system. Spreadsheets are passed through a ‘fix cycle’, where the automatic “correction” mappings and “error” call out features are used to produce a clean, standardised spreadsheet output.

Using ODX to reformat, fix and cleanse spreadsheet data

The initial development of ODX allows for the transmission of information from multiple public health laboratory spreadsheets to DHIS2, specifically for AMR AST/DST testing. The application aims to solve the manual process required to sort data and can make both “corrections” and identify “errors” in spreadsheets uploaded to a data analytics system. It can be modified to map for spreadsheets from different origins and can be programmed to be sent to the desired analytics platform (not exclusively DHIS2). The current version of ODX has been programmed to identify relevant headings and information for data analytics.

The main features of the application are the ODX mappings, which can be set up to ‘correct’ and standardise column headings, common spelling mistakes or name variations for pathogens and antibiotics, and reformat the spreadsheet so that all columns are in the same order and header information is in the same place. ODX is also able to identify any ‘errors’ in a spreadsheet that would prevent data rows from being sent into an analytics platform, such as missing information or information entered in an unrecognised format. This cleansing process is known as a ‘fix cycle’, as the user may need to pass a spreadsheet through ODX more than once to ensure that all errors have been addressed. Additional features can be added to meet country-specific needs, such as the more unique requirement of the Nepal project for mappings to correct for variation in date format used, as some Nepal laboratories use both the Gregorian and Bikram Sambat date formats.

The following walkthrough video demonstrates how the ODX application runs, and how it has been used in Nepal:

Open Interop

2020-09-08T16:06:23+00:00

PEARL Pal - On Device Interoperability

2022-08-22T10:35:34+00:00

The Android application, PEARL Pal, was developed to provide on-device interoperability, specifically meet the requirements of the PEARL Study in South Tarawa. The Software for Health Foundation was initially part of the project to assess the feasibility of integrating data from the REDCap database into a Simprints application. When it became apparent that the two applications do not communicate directly, our team began development on a companion application (later named PEARL Pal) which would allow for the transfer of vital information between platforms.

The development of this application was based on the requirements provided by the PEARL team from the University of Sydney and involved direct communication with members of the Simprints company to ensure that the companion app was able to pull the correct information, a unique patient identifier based on facial coordinates, from the Simprints app and into the correct REDCap field, via PEARL Pal.

Although the current version of the application is for the specific project, the wider potential of the application has been discussed, including how the app could be made more distributable.

TAC

2022-08-24T13:35:29+00:00

WHONet Connector

2020-05-22T15:47:54+00:00

The WHONet software, maintained and developed by the World Health Organisation Collaborating Centre for Surveillance of Antimicrobial Resistance, is an application that allows labs to track antibiotic susceptibility tests and then report them in a standardised format to GLASS, a database for specific pathogens.

Until now there was no clear automated and connected way of retrieving results from the software’s database. The development of the WHONet connector was a way of retrieving results and transmitting them onward to another system so that the data could be reported on and backed up.

The WHONet Connector runs as a desktop application on all modern operating systems and receives over the air updates as the software is updated.

As well as WHONet data files, you can upload CSV and Excel spreadsheets to the software. New rows will be automatically transmitted when you save a new version, and you can track the progress of the upload within the application. You can also track a folder of Excel / CSV documents so that all files within this folder are transmitted, or you can track a single Excel / CSV document, allowing new rows saved to this file to be automatically uploaded.

This software has been used effectively in multiple countries in order to connect their WHONet datasets to more sophisticated reporting systems, allowing ministries and the WHO to have a clearer picture of the AMR testing going on.

For more information on how to download and use the WHONet Connector, please get in touch here.