← Back to team overview

dhis2-users team mailing list archive

Re: 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> 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>:
>
>> 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> 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>
>>> 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  <pmalone10@xxxxxxxxx>
>>>> Skype: pmalone10
>>>> Phone: +1 516-655-1784
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : 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
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : 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
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Follow ups

References