Interoperability of ODK & DHIS2

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@gmail.com
Skype: pmalone10
Phone: +1 516-655-1784

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@gmail.com 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,

Patrick Malone
MA, Law and Diplomacy | Graduate, 2015
The Fletcher School | Tufts University
Email: pmalone10@gmail.com
Skype: pmalone10
Phone: +1 516-655-1784

Pat


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

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

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

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

Pierre Dane

Development Manager

Jembi Health Systems

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@jembi.org 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


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

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

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

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

On Tue, Aug 25, 2015 at 7:59 PM, Patrick Malone pmalone10@gmail.com 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,

Patrick Malone
MA, Law and Diplomacy | Graduate, 2015
The Fletcher School | Tufts University
Email: pmalone10@gmail.com
Skype: pmalone10
Phone: +1 516-655-1784

Pat


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

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

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

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

Pierre Dane

Development Manager

Jembi Health Systems

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

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.

···

2015-08-31 11:13 GMT+00:00 Jason Pickering jason.p.pickering@gmail.com:

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


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

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

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

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


Abda Anne
Bamako (Mali)

On Mon, Aug 31, 2015 at 12:44 PM, Pierre Dane pierre@jembi.org 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


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

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

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

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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Tue, Aug 25, 2015 at 7:59 PM, Patrick Malone pmalone10@gmail.com 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,

Patrick Malone
MA, Law and Diplomacy | Graduate, 2015
The Fletcher School | Tufts University
Email: pmalone10@gmail.com
Skype: pmalone10
Phone: +1 516-655-1784

Pat


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

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

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

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

Pierre Dane

Development Manager

Jembi Health Systems

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@gmail.com 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


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

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

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

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


Abda Anne
Bamako (Mali)

2015-08-31 11:13 GMT+00:00 Jason Pickering jason.p.pickering@gmail.com:

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


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

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

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

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

On Mon, Aug 31, 2015 at 12:44 PM, Pierre Dane pierre@jembi.org 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


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

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

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

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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Tue, Aug 25, 2015 at 7:59 PM, Patrick Malone pmalone10@gmail.com 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,

Patrick Malone
MA, Law and Diplomacy | Graduate, 2015
The Fletcher School | Tufts University
Email: pmalone10@gmail.com
Skype: pmalone10
Phone: +1 516-655-1784

Pat


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

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

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

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

Pierre Dane

Development Manager

Jembi Health Systems

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

We’ve done a prototype of this which works for syncing of forms. We didn’t tackle org ids fully which is a bit more complex. We’d be interested in developing a Django web bridge that would allow you to collect ona or one of the formhub derivatives to dhis2 if there is interest.

Keen to see thiugh what 2paths comes up with.

Thanks,

Matt

···

On Mon, Aug 31, 2015 at 8:07 AM, Abda ANNE girlajo@gmail.com 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


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

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

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

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


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


Abda Anne
Bamako (Mali)

2015-08-31 11:13 GMT+00:00 Jason Pickering jason.p.pickering@gmail.com:

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


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

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

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

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

On Mon, Aug 31, 2015 at 12:44 PM, Pierre Dane pierre@jembi.org 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


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

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

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

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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

On Tue, Aug 25, 2015 at 7:59 PM, Patrick Malone pmalone10@gmail.com 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,

Patrick Malone
MA, Law and Diplomacy | Graduate, 2015
The Fletcher School | Tufts University
Email: pmalone10@gmail.com
Skype: pmalone10
Phone: +1 516-655-1784

Pat


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

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

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

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

Pierre Dane

Development Manager

Jembi Health Systems

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

···

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@gmail.com 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@gmail.com:

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@jembi.org 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@gmail.com 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@gmail.com

Skype: pmalone10

Phone: +1 516-655-1784


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

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

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@lists.launchpad.net

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

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

Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+46764147049


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

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

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

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


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

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

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

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

Aaron Gladders, 2Paths

http://www.2paths.com/

Hello dhis2community,

I have been using ODK for many years but DHIS2 nothing much.

How far did this interoperability conversation go?

Paul