dhis2-users team mailing list archive

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

Hi Frank,
This question has been asked a few times, one rather recently. Basically,
you will need to transform your data either into XML which can be imported
by DHIS2. The format can be seen by looking at the Web API of the demo (
http://apps.dhis2.org/demo).  For instance, this (
http://apps.dhis2.org/demo/api/organisationUnits/ueuQlqb8ccl.xml)

Once you have done this, you can simply import this using the "Metadata
import" function.

The other way which I am aware of is by transforming the Excel sheet into
SQL INSERT statements and injecting it directly into the database.

There is currently no way to directly import Excel files into DHIS2, to
create the organisational hierarchy, although it has been something often
discussed.

Hope this helps .

Best regards,
Jason



On Tue, Feb 4, 2014 at 10:26 AM, HAKIZIMANA Franck
<francescohaki@xxxxxxxxx>wrote:

> Hi,
> Could someone help me on how to import data( like organisation unit,data
> element etc.) from an excel sheet to dhis2.
> your help is welcome.
>
> thank you
>
> _______________________________________________
> 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
>
>