SARPAM Using ODK in Eight Countries to Track Drug Availability

March 13th, 2012 by Yaw Anokwa

Adi Eyal and his colleagues are using ODK Collect and a custom backend in eight African countries (South Africa, Lesotho, Zimbabwe, Mozambique, Zambia, Malawi, Tanzania and DRC) to collect information on the availability and quality of medications. They have around 180 field workers who are using cheap Vodafone 858 Android phones to collect quantitative information, as well as photos and audio interviews.

The data is being used for the Tendai Project, which according to Daniel Molokele of SARPAM, is "a practical intervention designed to ease the burden of the people by monitoring the situation at community level and disseminating information. The project aims to raise awareness of the challenges communities face in accessing essential medicines, provider pharmaceutical marketplace information through a regional info hub and contribute to improving access to medicines in the Southern African Development Community."

Adi explains that, "the first step is to collect evidence of systemic failings. It is easy to dismiss a stock-out, sub-standard medicine or poor service delivery as an exceptional event which doesn’t deserve further action. With a project such as Tendai, evidence of systemic failings can be gathered nationally and regionally. Armed with data civil society is able to engage with governments to identify the cause of these failings and suggest solutions. Researchers too may use this information to inform policy.

This isn’t the end of the road. Once policy change has occurred, Tendai can be used to monitor the effectiveness of that intervention. For instance, large scale stock-outs of ciprofloxacin may indicate a problematic supply chain. Once a strategy is implemented to correct the problem, civil society, through Tendai can evaluate whether this solution has indeed resulted in a reduction in stock-outs.

This is of course a simplistic example but there is a lot of value in understanding the nature of a problem before attempting to take action to correct it. Specifically with Tendai, we are hoping to encourage increased collaboration between governments and civil society to improve public health systems."

Browse all the data the project has collected at http://tendai.medicinesinfohub.net

XLS2XForm is now XLSForm

March 8th, 2012 by nabreit

Not just the name has changed, we now share a updated syntax with Formhub.

There is some backwards compatibility with the old syntax but we encourage you to transition to using the new syntax documented here.

Additionally, we made some improvements to our error messages, but hopefully you never find out what they are.

If you find run into any problems, please post them to our issue tracker, or bring them up on our community mailing list.

And finally, here's a link to XLSForm: http://opendatakit.org/use/xlsform/

AMPATH Improving Care At Scale With ODK and OpenMRS

January 24th, 2012 by Yaw Anokwa

AMPATH is the one of the largest HIV treatment programs in sub-Saharan Africa and is Kenya's most comprehensive initiative to combat the virus. The program's catchment area has over 2 million people and provides care to more than 130,000 HIV-positive patients across 55 urban and rural clinics. To provide care at this scale, AMPATH has invested in tools like OpenMRS (an open source medical record system) and Open Data Kit, to help improve the efficiency and impact of their health providers.

Home-Based Counseling and Testing with ODK Collect
AMPATH has an extensive home-based and counseling program where community health workers (CHWs) go house to house to identify and enroll persons in need of care (i.e., pregnant women not in antenatal care, orphaned children, persons at high risk for tuberculosis infection). The workers need mobile data collection to document socio-economic data (including GPS location of household) and to implement the counseling and testing protocol.

Before using ODK, AMPATH used Palm TX devices running Pendragon Forms. GPS information was collected using eTrex devices. Problems with this approach were outlined by Rajput et al. in their Evaluation of an Android-based mHealth System for Population Surveillance in Developing Countries (AMIA 2011) paper.

They write, "First, although costs were significantly lower than paper-based data collection methods the costs were still substantial. Second, the data collected could not be directly integrated into the electronic medical record system [OpenMRS] which was already in use at the AMPATH clinics -- integration required dedicated time by several experienced data managers. Third, the cable connection between the PDA and GPS devices was not always reliable, and GPS information had to occasionally be entered manually into the PDA devices. Fourth, the use of the proprietary Pendragon Forms Software on the PDA devices limited flexibility to incorporate some functionality into the data collection software –- some of these functionality included advanced barcode scanning and check-digit algorithms."

In late 2009, we provided an early version of ODK Collect to AMPATH (on an HTC Dream, the first Android device). We spent a week with them in Kenya piloting the system, and based on the available functionality, AMPATH decided to switch to Open Data Kit. Below is a picture of one of the CHWs scanning a patient barcode with the phone.

In early 2010, AMPATH finalized the HCT form, made minor changes to the user interface, acquired Android devices, and started to scale up. It is important to note that ODK's core developers were not involved at this stage.

Rajput et al. evaluated the ODK implementation at AMPATH a few months after and showed that "Users of the system felt it was easy to use, and facilitated their home visits. It is more cost effective than pen-and-paper alternatives. Additionally, electronic data collection facilitated earlier reporting. We have implemented a viable solution at scale for collecting electronic data during household visits."

More importantly, that study also found that for the 63,000 persons encountered, "the direct capture of electronic records greatly facilitated the expeditious performance of initial analyses and reports prior to the conclusion of the three year HCT program. Our work has highlighted ... most notably that only 28% of persons we are identifying as infected with HIV are presenting for follow-up care." AMPATH has acted on this data by launching programs to improve follow-up.

It has been almost two years since AMPATH started using ODK Collect. We recently touched base with the HCT program to see how their use of technology has scaled. Since early 2010, ODK has been used by a few hundred CHWs in over 650,000 patient encounters! The HCT program has a greater than 98% rate of acceptance into the homes it visits, and with the help of technology, has been able to lower mother-to-child transmission of HIV/AIDS to lower than 3%.

Mobile Clinical Decision Support with ODK Clinic
We have continued our collaboration with AMPATH, and this year, we focused on tools for clinicians. We have created a new version of ODK Clinic, an Android-based application that downloads patient data like demographics, disease history, lab results, and recent medications from OpenMRS (and the Clinical Summary Module). We re-designed the entire application from our early v1 release and added features to enable correction of serious mistakes in the patient record. We also added decision support so clinicians receive patient-specific reminders when the system notices that sub-standard care is being offered. All this in near real time and at the point of care -- a major improvement over AMPATH's existing paper-based summaries.

If, for example, the system notices a scheduled lab test is overdue or a patient's health indicators have dropped dramatically, a reminder is inserted into the patient's record and displayed to the clinician. ODK Clinic can also enforce compliance with the reminders and can help compliance by wirelessly printing lab order test requisitions complete with all necessary patient data. We detailed our findings designing the system in our Design of a Phone-Based Clinical Decision Support System for Resource-Limited Settings paper from ICTD 2012. The talk slides are available and a video demo of the system is below.

Since that paper was written, the system has been used with about 7,500 patients at two adult HIV clinics. We are still evaluating the results of that deployment in a controlled trial, but very early results seem to show that clinicians using ODK Clinic deliver a higher standard of care. Moreover, clinicians enjoy using the system! As a few told us, "[We] can't see a patient without this phone."

We believe that technology only magnifies existing human intent and capacity and so, sustainable improvements require organizations who are dedicated to the communities they serve. With HCT and within HIV clinics, ODK and OpenMRS have helped make health care providers more efficient and through that efficiency, magnified their impact. We believe this is one of the reasons why this work was featured as one of the mHealth Alliance and Rockefeller Foundation's Top 11 in 2011 Innovators Challenge.

Our work at AMPATH has been in deep collaboration with many people. We want to thank Martin Were, Nyoman Ribeka, Sam Mbugua, Zeshan Rajput for their help. We also thank all our colleagues at OpenMRS and Regenstrief for their support, and Abbott Fund and Google for funding much of this work. Finally, we thank the CHWs and clinicians for their participation in our research. It is their hard work that is making a difference in the lives of the underserved.