Remote form entry synchronization

I’m interested in what is mentioned below as OpenMRS remote entry - I take it that uses Xforms. Sounds like something we should look into for DHIS 2 also.

Knut

···

---------- Forwarded message ----------

From: Jim Grace openmrs@jamesgrace.org
Date: Thu, Oct 15, 2009 at 9:01 PM
Subject: Re: [OPENMRS-DEV] Monthly site summary data in OpenMRS

To: openmrs-devel-l@listserv.iupui.edu

Thanks for all the responses so far. I’ll check out DHIS. Free Download Manager says I should have it here in Kisumu in just another 39 hours… Oops, make that infinite. OK, now 215 hours. We’ll see. :slight_smile:

I don’t yet see anything yet about DHIS data entry being distributed the way OpenMRS remote form entry or synchronization are. This is something that would really help us with our remote districts. Otherwise it’s sounding good so far. Reinventing the wheel is not my preferred mode. Running the new OpenMRS reporting over OpenMRS+DHIS sounds like a nice idea, Mike. Thanks for the tips everyone.

Jim

At 04:49 PM 15-10-09, Michael Seaton wrote:

Hi Jim,

As Justin mentioned, we have started down the road of implementing

exactly what you describe in your option #2 below via the facilitydata

module. We have been doing this for a few years now in our legacy

system (combining hand-entered monthly aggregate indicators with

calculated patient-data indicators) to produce our Pepfar reports, and

the aim of the facilitydata module was to allow us to reproduce this

process on OpenMRS.

Robby worked hard to get this module off the ground this past summer,

and if it is something that you are interested in I would be happy to

discuss it with you and talk over what it would take to make it

production-ready.

You can download it directly from svn, and you can see some of the wiki

documentation here:

http://openmrs.org/wiki/Facility_Data_Module

I have to say that, given discussions that happened at Cape Town this

year with Bob Jolliffe and others, I’m leaning towards revisiting the

above approach in favor of one that utilizes DHIS for the aggregate data

collection piece, and integrates with the new reporting module to

produce reports which combine indicators from both DHIS data and OpenMRS

patient data.

Regardless of the chosen approach, what you are describing is exactly

what we need to do when we roll OpenMRS out to our implementations in

Haiti, and I would be very interested in working together to make it

happen.

Thanks,

Mike

-----Original Message-----

From: dev@openmrs.org [mailto:dev@openmrs.org] On Behalf Of Justin

Miranda

Sent: Thursday, October 15, 2009 8:42 AM

To: openmrs-devel-l@LISTSERV.IUPUI.EDU

Subject: Re: [OPENMRS-DEV] Monthly site summary data in OpenMRS

I’m pretty sure each of our implementations (at PIH) has a need for this

type of data, but Mike (Seaton) has been advocating for collecting this

type of data specifically for our Haiti sites.

I see two approaches:

(1) Something similar to the approach you suggested (from a form entry

perspective). Robby (with Mike as mentor) started that process via the

Google Summer of Code and built an initial version of a faciliydata

module.

You can download the latest code at:

http://svn.openmrs.org/openmrs-modules/facilitydata/

(2) A reporting framework approach. I came to the conclusion at the

conference that we need a file-based dataset definition that will allow

users to upload spreadsheet data to be used within reports. That means

you can take those spreadsheets, upload them to OpenMRS and use them

within the reporting framework or third-party tools like Jasper or

BIRT. Clearly this approach won’t be useful until implementations start

building their reports using the new reporting tools, but it’s hopefully

an approach that will be possible in the not-so-distant future. For the

record, the file-based dataset definition does not exist yet. It has

been identified as a requirement for the AMPATH sites, so it should be

done eventually. However, without some development resources, it’s

probably not going to be completed any time soon.

If there are developers that want to contribute to either of these

projects, let me know.

Justin

Jim Grace wrote:

We’re sitting here at FACES in Kenya crunching through our

reporting-year-end data for PEPFAR (U.S. AIDS relief funding.) I’m

writing software to pull data out of massive Excel spreadsheets where

it’s been aggregated, to put it into PEPFAR reports. There must be a

better way.

Basically, PEPFAR wants a whole bunch of monthly measures for each of

our clinical sites, in such areas as prevention of HIV transmission

(including mother-to-child transmission), HIV counseling and testing,

antiretroviral treatment, etc. Some of these monthly numbers we can

aggregate from our HIV patient support and treatment patient-level data

in OpenMRS. Many others come from data not yet captured by us at the

patient level in OpenMRS, and some from data we won’t ever track at the

patient level (e.g., "Number of individuals trained in the provision of

laboratory-related activities", "Number of local organizations provided

with technical assistance for HIV-related policy development", etc.) We

need to report these monthly measures for 63 clinical sites, for 12

months.

I’m thinking that the OpenMRS data collection tools would be ideal for

us to input this data in the future. Define each measure as an OpenMRS

concept. Design one or more OpenMRS forms to collect the monthly summary

data for each site. Use the OpenMRS remote form entry infrastructure

we’ve already deployed (and hoping to migrate to synchronization) to get

all these numbers entered at the remote districts and brought back to

our central server. Design an export process to pull out all this data

(including aggregate summaries from patient-level data where applicable)

for our PEPFAR reporting.

Implementation possibilities include:

  1. The most crude approach requires no software development. We could

define a dummy patient (or one dummy per site or per district), a dummy

provider, set up our concepts and forms, and enter one form per site per

month (perhaps using the encounter date to represent the summary

year/month.)

  1. A much more ambitious plan is to design new tables that function

similarly to encounter and obs, with respect to form entry. These tables

could be used for monthly site summary data (or perhaps other kinds of

data too?), and would not relate to patient or provider.

  1. An in-between plan is to modify encounter and obs to make patient

and provider references optional.

Plans 2 and 3 would require a module with a UI so forms could be

entered by site/month without first selecting a patient.

Has anyone else considered or used OpenMRS data collection for this

kind of monthly site summary data – or for any other

non-patient-related data? Do you have any experience and/or advice for

us, as we consider these options?

Thanks,

Jim

P.S. For those who followed the OPENMRS-DEV "Location-based

Privileges" thread, it is not lost, just dormant while we attend to

other things. The need is still there, and the design is still

percolating. :slight_smile:


To unsubscribe from OpenMRS Developers’ mailing list, send an e-mail

to LISTSERV@LISTSERV.IUPUI.EDU with “SIGNOFF openmrs-devel-l” in the

body (not the subject) of your e-mail.

[mailto:LISTSERV@LISTSERV.IUPUI.EDU?body=SIGNOFF%20openmrs-devel-l]


To unsubscribe from OpenMRS Developers’ mailing list, send an e-mail to

LISTSERV@LISTSERV.IUPUI.EDU with “SIGNOFF openmrs-devel-l” in the body

(not the subject) of your e-mail.

[mailto:LISTSERV@LISTSERV.IUPUI.EDU?body=SIGNOFF%20openmrs-devel-l]


To unsubscribe from OpenMRS Developers’ mailing list, send an e-mail to LISTSERV@LISTSERV.IUPUI.EDU with “SIGNOFF openmrs-devel-l” in the body (not the subject) of your e-mail.

[mailto:LISTSERV@LISTSERV.IUPUI.EDU?body=SIGNOFF%20openmrs-devel-l]


To unsubscribe from OpenMRS Developers’ mailing list, send an e-mail to LISTSERV@LISTSERV.IUPUI.EDU with “SIGNOFF openmrs-devel-l” in the body (not the subject) of your e-mail.

[mailto:LISTSERV@LISTSERV.IUPUI.EDU?body=SIGNOFF%20openmrs-devel-l]


Cheers,
Knut Staring

I allow myself to spread some gospel on this list too...

Not many of you may be aware of all the things your work is contributing
to in other countries than your own, so here are a couple of links from
WHO showing the use of DHIS2 in Sierra Leone, which has no developers
in-country itself. Thanks to all for the common efforts, and for sharing
innovations through the network.

http://www.who.int/features/2009/sierra_leone/en/index.html

Johan

Nice - congrats to all !

Johan, we are also coming up with a community-system which will enable health workers track and locate individuals (e.g. a mother and child who are in ANC or Immunization program) and urge them complete services.

Abyot.

···

On Fri, Oct 16, 2009 at 11:33 AM, johansa@ifi.uio.no wrote:

I allow myself to spread some gospel on this list too…

Not many of you may be aware of all the things your work is contributing

to in other countries than your own, so here are a couple of links from

WHO showing the use of DHIS2 in Sierra Leone, which has no developers

in-country itself. Thanks to all for the common efforts, and for sharing

innovations through the network.

http://www.who.int/features/2009/sierra_leone/en/index.html

http://www.who.int/healthmetrics/HMN_Oct09_newsletter_web_new.pdf

Johan


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

It’s worth noting that this story is actually on the WHO front page today:
http://www.who.int/en/

Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization

Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@who.int|Tel: +41 788216897
Website: www.healthmetricsnetwork.org

Better Information. Better Decisions. Better Health.

···

2009/10/16 Abyot Gizaw abyota@gmail.com

Nice - congrats to all !

Johan, we are also coming up with a community-system which will enable health workers track and locate individuals (e.g. a mother and child who are in ANC or Immunization program) and urge them complete services.

Abyot.

On Fri, Oct 16, 2009 at 11:33 AM, johansa@ifi.uio.no wrote:

I allow myself to spread some gospel on this list too…

Not many of you may be aware of all the things your work is contributing

to in other countries than your own, so here are a couple of links from

WHO showing the use of DHIS2 in Sierra Leone, which has no developers

in-country itself. Thanks to all for the common efforts, and for sharing

innovations through the network.

http://www.who.int/features/2009/sierra_leone/en/index.html

http://www.who.int/healthmetrics/HMN_Oct09_newsletter_web_new.pdf

Johan


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Nice. I’m sure its tough getting non-flu related stories on to the WHO front page! Congrats to you lot in HMN.

Regards
Bob

···

2009/10/16 Ola Hodne Titlestad olatitle@gmail.com

It’s worth noting that this story is actually on the WHO front page today:
http://www.who.int/en/

Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization

Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@who.int|Tel: +41 788216897
Website: www.healthmetricsnetwork.org

Better Information. Better Decisions. Better Health.

2009/10/16 Abyot Gizaw abyota@gmail.com

Nice - congrats to all !

Johan, we are also coming up with a community-system which will enable health workers track and locate individuals (e.g. a mother and child who are in ANC or Immunization program) and urge them complete services.

Abyot.

On Fri, Oct 16, 2009 at 11:33 AM, johansa@ifi.uio.no wrote:

I allow myself to spread some gospel on this list too…

Not many of you may be aware of all the things your work is contributing

to in other countries than your own, so here are a couple of links from

WHO showing the use of DHIS2 in Sierra Leone, which has no developers

in-country itself. Thanks to all for the common efforts, and for sharing

innovations through the network.

http://www.who.int/features/2009/sierra_leone/en/index.html

http://www.who.int/healthmetrics/HMN_Oct09_newsletter_web_new.pdf

Johan


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp