dhis2-users team mailing list archive

[Gaurav Kumar <gkumar@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>]

Hi Aaron, Abda and Patrick,

I am actually working on building a web app around this concept (ODK to DHIS2) and done a bit of groundwork already.
I have previously also worked on integrating CommCare with DHIS2 which is based on ODK and has the same data model. It will be good to touch base sometime and discuss this in more detail and maybe work out a collaboration.

Thanks & regards,
GAURAV



From: Dhis2-users [mailto:dhis2-users-bounces+gkumar=internationalmedicalcorps.org@xxxxxxxxxxxxxxxxxxx] On Behalf Of Aaron Gladders
Sent: Monday, August 31, 2015 3:50 PM
To: Abda ANNE <girlajo@xxxxxxxxx>
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] Interoperability of ODK & DHIS2

Hi - we spoke with Patrick briefly but I thought I'd email the rest of the list too.  We've been engaged for some feasibility work linking together various mobile collection tools to DHIS 2 in as general a way as possible and not requiring IT or developers to do custom integration each time.  We hope to be done the first by the end of the Sept and there are tentative plans to continue after that.  Will try to report back if something fruitful comes of it, but generally it would follow the path Jason and Abda Anne have outlined with some sort of ETL/mapping process in the middle.

Aaron

On Mon, Aug 31, 2015 at 8:07 AM, Abda ANNE <girlajo@xxxxxxxxx<mailto:girlajo@xxxxxxxxx>> wrote:
Dear all,
We are currently working on similar project. We need to store in DHIS2 daata collected via ODK Collect.

We are working on the following scenario :
ODK Collect =>ODK Aggregate => ODK2DHIS (Custom Code) => DHIS2

We told ODK Aggregate to forward all inncoming data in JSON Format to our ODK2DHIS  custom code. ODK2DHIS will match ODK fields to DHIS2 dataelement and use DHIS API to submit data. Our ODK2DHIS is not ready yet, we shall start implementing it very shortly. If anyone is willing to sharing his custom program to transfert data from ODK to DHIS2, we will be very happy.

---
Abda Anne
Bamako, MALI



-----------------
Abda Anne
Bamako (Mali)

2015-08-31 11:13 GMT+00:00 Jason Pickering <jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>>:
Hi Patrick,
There is nothing really out of the box which will do this AFAIK.

In the past, I have worked in projects which have aggregated the event based data, and the passed it on to DHIS2 in aggregate format with custom code,similar to what Pierre mentions.

In another situation, we passed the event based data from ODK into DHIS2, again, using custom code.

In both cases, there was custom code to "clean" data from ODK which might not be suitable for import into DHIS2, such as incomplete or inconsistent or duplicate form submissions.

I know there have been some efforts in the past to integrate the two applications more closely, but as of now, there is nothing. But, with a bit of scripting (or even Excel!) it would not be too difficult to do this. I would however be clear from the outset if you need everything in DHIS2, as often it makes sense to aggregate and process the survey data obtained from ODK, into something which really makes more sense in DHIS2 (i.e. events or aggregate data). Working with the raw survey data should be possible now with the event modules, and with the advent of the program rules in the latest version, more complex skip logic (not as complex as ODK) is supported. So, it might be work looking at only using DHIS2 even capture for what you need, as opposed to building a custom integration layer between the two. For relatively simple surveys, it might work, but if you need very complex skip logic or ODK specific features, it might not.

Regards,
Jason


On Mon, Aug 31, 2015 at 12:44 PM, Pierre Dane <pierre@xxxxxxxxx<mailto:pierre@xxxxxxxxx>> wrote:
Hi Patrick,

I'm not aware of any existing ODK to DHIS2 interoperability modules and I would expect that some additional coding on the ODK side would be necessary to get data into a format that DHIS2 can accept. DHIS2 has a number of ways of accepting data via the api, so if a module can be built to read from ODK and transform data into json/xml/csv format (or preferably ADX) this can easily be ingested into DHIS2

Pierre

On Tue, Aug 25, 2015 at 7:59 PM, Patrick Malone <pmalone10@xxxxxxxxx<mailto:pmalone10@xxxxxxxxx>> wrote:
Hey all,

I'm currently working for an organization that is particularly curious about the interoperability of ODK and DHIS 2. Does anybody have any experience with syncing both systems? Does moving information stored through ODK into DHIS 2require additional coding? If so, is that more of a matter of DHIS 2 accepting the information that ODK is exporting rather than the other way around? Any help/information would be appreciated

Thanks,

Pat

--
Patrick Malone
MA, Law and Diplomacy | Graduate, 2015
The Fletcher School | Tufts University
Email: pmalone10@xxxxxxxxx <mailto:pmalone10@xxxxxxxxx>
Skype: pmalone10
Phone: +1 516-655-1784<tel:%2B1%20516-655-1784>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Pierre Dane

Development Manager
Jembi Health Systems

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>
tel:+46764147049<tel:%2B46764147049>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Aaron Gladders, 2Paths
http://www.2paths.com/