[Dhis2-users] Easy way to import indicators into new database

[Arthur Heywood]

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

Re: [Dhis2-users] Easy way to import indicators into new database

[Wilson, Randy]

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



On Mon, Oct 12, 2015 at 4:09 PM, Uwe Wahser  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  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: rwil...@msh.org
Skype: wilsonrandy_us

Stronger health systems. Greater health impact.



www.msh.org

-- 
*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
Description: MS-Excel 2007 spreadsheet
___
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

Re: [Dhis2-users] Issue with data element of type "long text" in custom forms

[Abyot Gizaw]

Hi Ese,

Do you have some screenshots to share? In custom form, we don't apply any
style - you as custom form designer are fully in charge.


---
Thank you,
Abyot.

On Mon, Oct 12, 2015 at 5:11 PM, Ese Egerega  wrote:

> Dear all,
>
> I am facing a challenge with data elements of type *"long text"* in *custom
> forms in *Tracker Capture.
>
> Data element with data type "Long text" is usually rendered as* text area
> i*n data entry when using the default data entry form. However, the same
> data element is rendered as an input box (*not text area*) in *custom
> forms* making it impossible to see parts of your text as you are typing.
>
> I have tried to work around this by using HTML style tag to stretch the
> input box so it fills the entire cell area but it still doesn't make it a 
> *text
> area *actually.
>
> Any suggestions will be appreciated.
>
> Thanks,
> Ese
>
>
> ___
> 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

[Dhis2-users] Request for new aggregation operator

[Seid Hussein]

Hi all,

We have a peculiar aggregation need here. I don't know if any other country
uses it or it is only Ethiopia but here it is.

Consider this data element which is collected monthly:

*Number of adults and children who are currently on ART - **First Line
Regimen *

When analyzing data for a year, the last month's data shall always be taken
rather than the summation or average of the data values.

There are a few data elements like this we  capture every month.


However, the current aggregation operators cannot handle this. The max and
the min operators may be the closest ones to handle this (for data that
increases and decreases over time respectively).

Would it be possible to add one more aggregation operator that always takes
the last period's value when the aggregation is across periods and when it
is hierarchically it sums the last period's values of each captured data.

Regards,


Seid,
___
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

Re: [Dhis2-users] Easy way to import indicators into new database

[Greg Rowles]

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 
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
___
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

Re: [Dhis2-users] Easy way to import indicators into new database

[Uwe Wahser]

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 ...UweArthur Heywood  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_zaTanzania* +255-773-669393 OR 0673 150252Zim +263 778236899___Mailing list: https://launchpad.net/~dhis2-usersPost to : dhis2-users@lists.launchpad.netUnsubscribe : https://launchpad.net/~dhis2-usersMore 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

[Dhis2-users] Issue with data element of type "long text" in custom forms

[Ese Egerega]

Dear all,

I am facing a challenge with data elements of type *"long text"* in *custom
forms in *Tracker Capture.

Data element with data type "Long text" is usually rendered as* text area i*n
data entry when using the default data entry form. However, the same data
element is rendered as an input box (*not text area*) in *custom forms*
making it impossible to see parts of your text as you are typing.

I have tried to work around this by using HTML style tag to stretch the
input box so it fills the entire cell area but it still doesn't make it a *text
area *actually.

Any suggestions will be appreciated.

Thanks,
Ese
___
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

Re: [Dhis2-users] Easy way to import indicators into new database

[uwe wahser]

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

---
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  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


___
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

Re: [Dhis2-users] Issue with data element of type "long text" in custom forms

[Ese Egerega]

Thanks for your response Abyot.
Custom forms appear to be more flexible with aggregate datasets than in the
Tracker. Here are screenshots of the same data element in aggregate dataset
and in Tracker.

Data element in a custom form in aggregate dataset --
http://awesomescreenshot.com/0615bcug0c

The same data element in Tracker -- http://awesomescreenshot.com/0265bcyt99

Thanks,
Ese

On Mon, Oct 12, 2015 at 4:50 PM, Abyot Gizaw  wrote:

> Hi Ese,
>
> Do you have some screenshots to share? In custom form, we don't apply any
> style - you as custom form designer are fully in charge.
>
>
> ---
> Thank you,
> Abyot.
>
> On Mon, Oct 12, 2015 at 5:11 PM, Ese Egerega  wrote:
>
>> Dear all,
>>
>> I am facing a challenge with data elements of type *"long text"* in *custom
>> forms in *Tracker Capture.
>>
>> Data element with data type "Long text" is usually rendered as* text
>> area i*n data entry when using the default data entry form. However, the
>> same data element is rendered as an input box (*not text area*) in *custom
>> forms* making it impossible to see parts of your text as you are typing.
>>
>> I have tried to work around this by using HTML style tag to stretch the
>> input box so it fills the entire cell area but it still doesn't make it a 
>> *text
>> area *actually.
>>
>> Any suggestions will be appreciated.
>>
>> Thanks,
>> Ese
>>
>>
>> ___
>> 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

[Dhis2-users] Setting up Point of Service sites

[Laura E. Lincks]

Hello all,

I am interested in knowing how teams are setting up Point of Service sites
in DHIS.

I have thought of a couple of ways to do so:


   - Create an Organisational Unit level (POS) underneath facility level
   which will collect Testing and Counseling data via a data set which is set
   up to only be accessible to Org Units at this POS level


   - Create a data set for Testing and Counseling data and add a Point of
   Service Category to it. Data will be added at the Facility level: data set,
   reporting period AND Point of Service Type would be selected prior to
   adding data on the data entry screen.


I imagine this is not an issue unique to us and am curious what others'
solutions are.

Thanks in advance.

*Laura E. Lincks*
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132
___
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

Re: [Dhis2-users] Using Dashboard

[Prosper BT]

Hi Channara,

Sharing interpretations using groups is not yet implemented.

Its a blue print in 2.22
https://blueprints.launchpad.net/dhis2/+spec/interpretations-sharing

Regards

On Wed, Sep 16, 2015 at 8:19 PM, channara rin 
wrote:

> Hi every one,
> Do you know what step to use interpretation to share
> report/chart/map/table in one group?
>
> thank you
> CHANNARA
>
> ___
> 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
>
>


-- 
Prosper Behumbiize, MPH
Global HISP| University Of Oslo/HISP Uganda
+256 752 751 776 | +256 776 139 139
ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb
___
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

Re: [Dhis2-users] Data element with many category options - any alternative to custom-designed data entry form

[Prosper BT]

Hi Goncalo,

Right now you can only control the entry fields size by designing custom
forms for you data sets.

There you can the style you want like (style="width:5em;")

Regards

On Mon, Sep 28, 2015 at 6:22 PM,  wrote:

> Quick question:
>
> Imagine a data set with several columns due to having several categories
> with several category options for the data elements..
>
> Is there any way to reduce the width through tabs that allow me to group,
> e.g., 1 option from the 1st category per tab?
>
> Thank you & best regards
>
> Gonçalo Castro
>
> --
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error, please notify us immediately by
> reply e-mail and delete this message from your system.
> --
> ___
> 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
>
>


-- 
Prosper Behumbiize, MPH
Global HISP| University Of Oslo/HISP Uganda
+256 752 751 776 | +256 776 139 139
ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb
___
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

Re: [Dhis2-users] store a value into indicator and indicator field

[Prosper BT]

Hi Joao,

Do you want this for aggregate datasets or individual records?

You can create an indicator and assign the aggregate data element value to
the new indictor and add in the dataset.

Same for individual records

Regards

On Tue, Sep 8, 2015 at 4:04 PM, Joao Mazuze 
wrote:

> Dear dhis2 professionals,
>
> Is it possible to get a value from one field and store it into an
> indicator field? If so, how do I perform it using a javascript/JQuery?
>
>
>
> Kind regards,
>
> João
>
>
> --
> This message may contain privileged and confidential information intended
> solely for the addressee. Please do not read, disseminate or copy it unless
> you are the intended recipient. If this message has been received in error,
> we kindly ask that you notify the sender immediately by return email and
> delete all copies of the message from your system.
>
> ___
> 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
>
>


-- 
Prosper Behumbiize, MPH
Global HISP| University Of Oslo/HISP Uganda
+256 752 751 776 | +256 776 139 139
ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb
___
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

Re: [Dhis2-users] Pluriannual pivot table

[Prosper BT]

Dear Guy,

You can only and one if the Years in the rows are data elements, otherwise
if its a period and the months in the column are periods you cannot.

Regards

On Tue, Sep 15, 2015 at 5:21 PM, Guy Ekani  wrote:

> Hello everyone,
>
> Please how can we build a pluriannual pivot table like the one below ? In
> DHIS 2.18 with a aggregated dataelement
>
> Sincerely,
>
> Dataelement | January | February| March   |
> +++-+
> 2015|   1 |   2|  7 |
> 2014|   4 |   5|  5 |
> 2013|   7 |   7| 2 |
> 2012|   7 |   8| 0 |
>
> =
> EKANI Guy
>
>
>
>
>
>
> ___
> 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
>
>


-- 
Prosper Behumbiize, MPH
Global HISP| University Of Oslo/HISP Uganda
+256 752 751 776 | +256 776 139 139
ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb
___
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

Re: [Dhis2-users] Using Attributes for Program Rules

[Prosper BT]

Hi Nic,

Sorry program rules using attributes has been implemented in 2.21, see the
blue print

https://blueprints.launchpad.net/dhis2/+spec/program-rules-during-registration-enrollment

Regards


On Sun, Oct 11, 2015 at 6:33 AM, Shurajit Dutta 
wrote:

> Hi everyone,
>
> I am trying to use an attribute to define a program rule. In this case I
> want to hide a "pregnant" field in data entry if the person's sex is male.
> I save the program rule, but when I go back in to edit it the attribute
> variable that I defined is no longer there as a source field. I tried to
> register some patients and I find it is still not working. The other rule I
> have made using program stage data elements is working fine. I am using
> version 2.20.
>
> [image: Inline image 1]
>
> ​Thanks
> Nick​
>
>
> --
> Shurajit Dutta
> Health Information Consultant
>
> ___
> 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
>
>


-- 
Prosper Behumbiize, MPH
Global HISP| University Of Oslo/HISP Uganda
+256 752 751 776 | +256 776 139 139
ptb3...@gmail.com | pros...@dhis2.org | Skype: prospertb
___
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