Easy way to import indicators into new database

Hi guys

I am sitting in Eritrea creating a new database with David Hagan … they have a wonderful set of indicators that conforms 90% to the international norms set by WHO …

To create the indicators I now have to type out 100 indicators by hand … a few days work for me!!

Can anyone help me with a SIMPLE way to get these indicators from another place where they have already been properly defined??

many Thanks

Arthur

···

*Without deviation from the norm, there can be no progress *(Frank Zappa)
Skype arthur_heywood_za

Tanzania* +255-773-669393 OR 0673 150252

Zim +263 778236899

Hi Arthur

Excel or openOffice is easy for doing bulk edits and replacements - that way you can also save your metadata to multiple formats

Greg

···

On Mon, Oct 12, 2015 at 12:36 PM, Arthur Heywood arthurheywood@gmail.com wrote:

Hi guys

I am sitting in Eritrea creating a new database with David Hagan … they have a wonderful set of indicators that conforms 90% to the international norms set by WHO …

To create the indicators I now have to type out 100 indicators by hand … a few days work for me!!

Can anyone help me with a SIMPLE way to get these indicators from another place where they have already been properly defined??

many Thanks

Arthur

*Without deviation from the norm, there can be no progress *(Frank Zappa)
Skype arthur_heywood_za

Tanzania* +255-773-669393 OR 0673 150252

Zim +263 778236899


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


Health Information Systems Program - South Africa

**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **

Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles

Hi Arthur,

sorry, no indicators from my side. I’d just like to use the occasion to advocate again the idea of maintaining a content repository for DHIS2, which would have been handy in your case:

Wouldn’t it be good to have a repository of standard and best practice indicators, data elements and>

The other advantage would be that you could build upon compatible>

Just thinking …

Uwe

···

*Without deviation from the norm, there can be no progress *(Frank Zappa)
Skype arthur_heywood_za

Tanzania* +255-773-669393 OR 0673 150252

Zim +263 778236899

Hi Arthur,

If you haven’t done this already, attached is an excel template that you can use to transform your indicator list into fields that can be imported into the DHIS-2 indicator table. I’ve left a couple of sample rows for you to see what the content should be like. Note that after you have imported the list, you still need to make sure that all of the data elements needed are in the system and then create the correct formulas for numerators and denominators manually.

The current CSV import doesn’t support importing indicators, but if you have access to the backend in Postgres it would be pretty easy to import these with a small SQL script that also assigns uid and indicatorid fields automatically.

Randy

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

indicatorimporttemplate.xlsx (9.74 KB)

···

On Mon, Oct 12, 2015 at 4:09 PM, Uwe Wahser uwe@wahser.de wrote:

Hi Arthur,

sorry, no indicators from my side. I’d just like to use the occasion to advocate again the idea of maintaining a content repository for DHIS2, which would have been handy in your case:

Wouldn’t it be good to have a repository of standard and best practice indicators, data elements and>

The other advantage would be that you could build upon compatible>

Just thinking …

Uwe

Arthur Heywood arthurheywood@gmail.com hat am 12. Oktober 2015 um 12:36 geschrieben:

Hi guys

I am sitting in Eritrea creating a new database with David Hagan … they have a wonderful set of indicators that conforms 90% to the international norms set by WHO …

To create the indicators I now have to type out 100 indicators by hand … a few days work for me!!

Can anyone help me with a SIMPLE way to get these indicators from another place where they have already been properly defined??

many Thanks

Arthur

*Without deviation from the norm, there can be no progress *(Frank Zappa)
Skype arthur_heywood_za

Tanzania* +255-773-669393 OR 0673 150252

Zim +263 778236899


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


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

Randy Wilson
*Team Leader: *Knowledge Management, Data Use and Research

Rwanda Health System Strengthening Activity

Management Sciences for Health

Rwanda-Kigali

Direct: +250 788308835

E-mail: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org

sorry, this got cut off by the web-mailer - next try:

Wouldn't it be good to have a repository of standard and best practice indicators, data elements, classifications and data-sets per health-program as down-loadable packages for easy import into a fresh DHIS2 installation? In my maybe naive thinking this would only mean to export them from an existing installation, zipping and uploading them to the repository.

Advantages:

- best practice templates of useful indicator sets

- faster implementation of new instances

- more compatible data-elements and indicators in the source-systems when approaching a supra-national HMIS, if the source installations were build upon standard indicators.

Uwe
···

arthurheywood@gmail.com

Hi guys�

        I am sitting in Eritrea creating a new database with David Hagan ... they have a wonderful set of indicators that conforms 90% to the international norms set by WHO .....�

        To create the indicators I now have to type out 100 indicators by hand ..... a few days work for me!!

        Can anyone help me with a SIMPLE way to get these indicators from another place where they have already been properly defined??

many Thanks�

Arthur

_ *Without deviation from the norm, there can be no progress *(Frank Zappa)_

                                      *Skype* arthur_heywood_za

                                      Tanzania* +255-773-669393 OR 0673 150252

Zim� +263 778236899

https://launchpad.net/~dhis2-users
dhis2-users@lists.launchpad.net
https://launchpad.net/~dhis2-users
https://help.launchpad.net/ListHelp
https://launchpad.net/~dhis2-usersdhis2-users@lists.launchpad.nethttps://launchpad.net/~dhis2-usershttps://help.launchpad.net/ListHelp