dhis2-users team mailing list archive

[Aaron Gladders <agladders@xxxxxxxxxx>]

Hi - we wrapped up a pilot a few months ago with Johns Hopkins University
National Evaluation Platform:

http://www.jhsph.edu/research/centers-and-institutes/institute-for-international-programs/current-projects/national-evaluation-platform/

to do something similar.  In their case they wanted to bring the DHS data
into stata to clean/prep it first, then export both metadata and the data
itself for import into DHIS 2.  We wrote a DHIS 2 user app + parallel java
app to handle the import and it's being piloted in 4 countries now, to
combine it with their routine health information where possible.  We didn't
use the DHS API's and I'd have to check on what cleanup/prep JHU was
doing.  Our work ends up being more of a generic stata import app although
I'm cc'ing in Lorill Crees who has been very involved with it and can
comment more.

JHU has tasked us to open source the work so we should be able to share
code.  We don't have it on online but I can check if we can send you a copy?

Our next round of work is on R integration so end users can conduct simple
analyses.  We've done our technical spikes and are doing proof of concept
work now.

Aaron

On Wed, Feb 3, 2016 at 3:10 AM, Olav Poppe <olav.poppe@xxxxxx> wrote:

> Thanks Jason. I realise I should learn R.
>
> I was thinking that it should be fairly simple to make a DHIS app that
> would let you interact with the DHS API to
> 1) select a country
> 2) select a survey/year for that country
> 3) select the indicators available for that survey
> If importing sub-national data, you would have to have some basic orgunit
> matching as well (though the number is limited for household surveys), but
> that's it.
>
> But it does not look like anyone has made that app yet unfortunately.
>
> Olav
>
>
>
>
>
>
> 2. feb. 2016 kl. 16.21 skrev Jason Pickering <jason.p.pickering@xxxxxxxxx
> >:
>
> Hi Olav,
> I have not worked with the DHS API per se, but have imported lots of data
> using the same approach which they outline here (
> http://api.dhsprogram.com/#/samples-r.cfm)
>
> I have written up a walkthrough of getting data out of one DHIS instance
> and into another one, and I think the basic principles would be the same (
> http://rpubs.com/jason_p_pickering/139589)
>
> Metadata needs to be mapped (or created), the data needs to be reshaped,
> and correctly formatted.
>
> It should not be too difficult. I used R, but there are other examples
> with Python and JavaScript on their examples page.
>
> Regards,
> Jason
>
>