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
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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp