dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Henri,
As Knut says, there is no "automatic" way of doing this, mostly because
your Excel files are likely completely custom. Thus, you will need to
transform your Excel files into something which DHIS2 can understand,
possibly using CSV to import data.

I have developed a somewhat more technical example of how this can be
accomplished with the R programming language, although regardless of you
what use, the steps are basically the same.

You can find that here <http://rpubs.com/jason_p_pickering/139589>.

Regards,
Jason




On Mon, Mar 21, 2016 at 5:21 PM, henri claude moungui <henrimoungui@xxxxxxxx
> wrote:

> Thank you Knut.
>
> Henri
>
>
>
>
>
> Le Lundi 21 mars 2016 15h25, Knut Staring <knutst@xxxxxxxxx> a écrit :
>
>
> Hi Henri,
>
> There is no specific 3rd party software that you have to use, people use
> many different tools. Perhaps most commonly, people use scripts in Python
> or R or similar to load data. You can import both metadata and data in CSV
> format, for example.
>
> http://dhis2.github.io/dhis2-docs/2.21/en/developer/html/ch01s10.html
> http://dhis2.github.io/dhis2-docs/2.21/en/user/html/ch21.html
>
> Knut
>
> On Mon, Mar 21, 2016 at 3:15 PM, henri claude moungui <
> henrimoungui@xxxxxxxx> wrote:
>
> Hi to all.
> I want to test the ETL process with DHIS2. Is there an automated way to do
> this? is there a recommended tiers soft to use for this? my operational DB
> to use are excel files.
> Thank you in advance.
>
> Henri Moungui
>
>
>
>
> _______________________________________________
> 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
>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
>
>
> _______________________________________________
> 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