[Dhis2-users] Scripting in aggregate custom forms

[Guy Ekani]

Hello team,

i will like to script into a custom aggregate form, so that i can inform
users that they leave some dataelements empty (without values) before
completing the form.

Please Anyone with a custom form like this one , kindly share.

Thanks and regards,

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

Re: [Dhis2-users] [Dhis2-devs] Setting "zeroissignificant" column from csv file import does not work -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Dear Alex,

Thank you for your suggestion! While trying to run the SQL script I get the
following error message: "SQL query contains illegal keywords" when
bringing the "zeroissignificant" field name in the script, even closing it
between brackets. Here it is:

update dataelement
set [zeroissignificant] = true
where lastupdated::date ='2017-05-25';

Thanks,

Tantely.


On Thu, May 25, 2017 at 9:57 PM, Alex Tumwesigye 
wrote:

> Dear Raminosoa,
>
> U can update the dataelement table directly and set the zeroissignificant
> to true for all after update for dataelement created that day. Then go to
> data administration->maintenance and the clear application cache.
> That works too.
> Sql script looks like
>
> Update dataelement set zeroissignificant = true where created::date
> ='2017-05-25'
>
> Note that the created helps not to update all dataelements, you can choose
> any other filter e.g a starting string.
>
> Alex
>
>
> On Thursday, May 25, 2017, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> Dear DHIS2 community,
>>
>>
>> When doing data elements upload from csv file (both add new or edit
>> existing) we are using the following csv file structure:
>>
>>
>> *Name, uid, code, shortname, description, formname, domaintype,
>> valuetype, aggregationtype, **zeroissignificant*
>>
>>
>> The last field is set to *true* for numeric data element as we would
>> like to store zero data values. As shown in the image below, the checkbox
>> still has to be checked manually.
>>
>>
>> Is there some step that I am missing, or should I use another syntax for
>> this last column. I have to update hundreds of data elements.
>>
>>
>> Your suggestions are welcome!
>>
>>
>> Regards,
>>
>>
>> Tantely.
>>
>>
>>
>> ​
>>
>> *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.*
>
>
>
> --
> Alex Tumwesigye
>
> Technical Advisor - DHIS2 (Consultant),
> Ministry of Health/AFENET  | HISP Uganda
> Kampala
> Uganda
> +256 774149 775, + 256 759 800161
> Skype ID: talexie
>
> IT Consultant (Servers, Networks and Security, Health Information Systems
> - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant
>
>
> "I don't want to be anything other than what I have been - one tree hill "
>
>

-- 
*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.*
___
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] [Dhis2-devs] Setting "zeroissignificant" column from csv file import does not work -- DHIS2 2.25

[Alex Tumwesigye]

Dear Raminosoa,

U can update the dataelement table directly and set the zeroissignificant
to true for all after update for dataelement created that day. Then go to
data administration->maintenance and the clear application cache.
That works too.
Sql script looks like

Update dataelement set zeroissignificant = true where created::date
='2017-05-25'

Note that the created helps not to update all dataelements, you can choose
any other filter e.g a starting string.

Alex


On Thursday, May 25, 2017, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Dear DHIS2 community,
>
>
> When doing data elements upload from csv file (both add new or edit
> existing) we are using the following csv file structure:
>
>
> *Name, uid, code, shortname, description, formname, domaintype, valuetype,
> aggregationtype, **zeroissignificant*
>
>
> The last field is set to *true* for numeric data element as we would like
> to store zero data values. As shown in the image below, the checkbox still
> has to be checked manually.
>
>
> Is there some step that I am missing, or should I use another syntax for
> this last column. I have to update hundreds of data elements.
>
>
> Your suggestions are welcome!
>
>
> Regards,
>
>
> Tantely.
>
>
>
> ​
>
> *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.*



-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET  | HISP Uganda
Kampala
Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems -
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant


"I don't want to be anything other than what I have been - one tree hill "
___
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 "zeroissignificant" column from csv file import does not work -- DHIS2 2.25

[Raminosoa Rabemanantsoa, Tantely]

Dear DHIS2 community,


When doing data elements upload from csv file (both add new or edit
existing) we are using the following csv file structure:


*Name, uid, code, shortname, description, formname, domaintype, valuetype,
aggregationtype, **zeroissignificant*


The last field is set to *true* for numeric data element as we would like
to store zero data values. As shown in the image below, the checkbox still
has to be checked manually.


Is there some step that I am missing, or should I use another syntax for
this last column. I have to update hundreds of data elements.


Your suggestions are welcome!


Regards,


Tantely.



​

-- 
*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.*
___
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] Anyone who knows a version of Android Tracker that support relationships

[Stanley Kalyati]

I would love to learn this as well.

Stanley

On May 25, 2017 8:00 PM, "Prosper BT"  wrote:

> Dear Team,
>
> The latest version of Android tracker capture on google play doesn't
> support relationships (Creating and editing). I have been trying different
> versions but no luck, anyone using a version where this is supported?
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda
> pros...@hispuganda.org  | 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
>
>
___
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] Anyone who knows a version of Android Tracker that support relationships

[Prosper BT]

Dear Team,

The latest version of Android tracker capture on google play doesn't
support relationships (Creating and editing). I have been trying different
versions but no luck, anyone using a version where this is supported?

Regards

Prosper Behumbiize, MPH
DHIS2 Implementation| HISP Uganda
pros...@hispuganda.org  | 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] upgrade

[Em Le Hong]

Hi,

In order to upgrade from 2.20 to the latest release 2.26, you can do these
steps below:

1. Backup your current database, if you have some error when upgrading, you
can restore it.
2. Read the upgrade notes on https://www.dhis2.org/downloads carefully,
some version you need to execute upgrading script.
3. You need to upgrade it in order from 2.20 -> 2.21 -> 2.23 -> 2.24 ->2.25
->2.26, you can't switch directly from 2.20 to 2.26 latest version, you
have to follow the order.


Hope this work for you

Sincerely,

On Thu, May 25, 2017 at 11:28 PM, Knut Staring  wrote:

> Forwarding to user list
>
> On May 25, 2017 6:24 PM, "Mohamed Elkhou"  wrote:
>
> Dear Sir,
>
> I would like you please to provide me with the steps to follow in order to
> upgrade from 2.20 to the latest version. I am using DHIS2 locally on my
> computer.
>
> Thank you
>
> Best regards
>
> Mohamed
>
>
>
> ___
> 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
>
>


-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
___
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] upgrade

[Knut Staring]

Forwarding to user list

On May 25, 2017 6:24 PM, "Mohamed Elkhou"  wrote:

Dear Sir,

I would like you please to provide me with the steps to follow in order to
upgrade from 2.20 to the latest version. I am using DHIS2 locally on my
computer.

Thank you

Best regards

Mohamed
___
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] Difficulties with the Program Indicators

[Shurajit Dutta]

Hi Julie

Sorry did you get this fixed?

I believe it may have to do with your code of 0 as dhis2 reserves 0 for no
type values. So that option code may not be ready correctly in he filter.
Instead of 0 I typically use 99.

On May 19, 2017 5:00 PM, "Julie Vanhamme"  wrote:

> Hi Shurajit,
>
> Thank you very much. It worked! :-)))
>
> I tested it with several data elements and I get just one more issue for
> one data element.
>
> I have Program Indicator 1 == Not at all satisfied (which was 0)
> Expression: event count
> filter : dataelement == 0
>
> I also took my Program Indicator 2: number of surveys which was already
> set up, as it is the same as for the others.
>
> I combined the two indicators and I got 100, as 100%. For all the others,
> it worked and I got the right percentage.
> I dubble checked if my configuration was ok and it is the same logic as
> with the other. Any idea why I get 100%? And actually, it is supposed to be
> 0% as none of the respondents selected this option (not at all satisfied).
>
> Is it because of the 0 value?
>
> Thank you
> Julie
>
>
>
> Julie Vanhamme
>
>
>
> 2017-05-19 9:09 GMT+02:00 Shurajit Dutta :
>
>> Hi Julie,
>>
>> I believe you should make two program indicators and combine them
>> together in the indicator maintenance app.
>>
>> The aggregation type should be count for both
>>
>> Program Indicator 1 = very satisfied responses
>> Expression: event count
>> filter: dataelement == very satisfied code
>>
>> Program Indicator 2 = number of surveys
>> Expression: event count
>> filter: blank
>>
>> Combined indicator in indicator maintenance app
>> Numerator: Program Indicator 1 = very satisfied responses
>> Denominator: Program Indicator 2 = number of surveys
>> Type = factor of 100
>>
>>
>>
>> On Fri, May 19, 2017 at 3:00 PM, Julie Vanhamme 
>> wrote:
>>
>>> Hi Ola,
>>>
>>> Thank you very much for your advices. I am a DHIS2 beginner and I guess
>>> that I am making some mistakes in the configuration and/or formula. I tried
>>> yesterday and I get data in my pivot tables but not the data I need. In
>>> only get "2" as I wrote it in my filter (see below). Let me answer to your
>>> questions and explain the situation :-)
>>>
>>> I am using "Event capture" as we did a one shot survey and we don't
>>> track the patient.
>>>
>>> *Program configuration:*
>>>
>>>- without registration
>>>- version: 4
>>>- Drop-down list
>>>- other field are empty or have the default configuration
>>>
>>> *Program indicator set up *(I believe that here is the problem and that
>>> I am making some mistakes with the formula):
>>>
>>>
>>>- I have one Data Element as follow : Are you satisfied with the
>>>gynecological service? Very satisfied (1), more or less (2) , and not at
>>>all (3) (these are the three responses possibles of my DE)
>>>- I wanted to create an indicator as follow: % of the respondents
>>>that say that they are "very satisfied" with the gynecological service.
>>>
>>>
>>>- Aggregation type: Average
>>>- Expression: I only selected my data element divided by the number
>>>of event count and then multiple by 100 : (#{qH1SRxSAoWI.AbdjW61ac8I} /
>>>V{event_count}) * 100
>>>- Filter I select my data element == 1 , so it is something like
>>>that : #{qH1SRxSAoWI.AbdjW61ac8I} == 2
>>>
>>> I guess I am wrong in my formula. Any guidance, solution or advice?
>>>
>>> Thank you again very much in advance for your support.
>>> Julie
>>>
>>>
>>> Julie Vanhamme
>>>
>>>
>>>
>>> 2017-05-18 9:28 GMT+02:00 Ola Hodne Titlestad :
>>>
 Hi Julie,

 Would be good if you could share some more details about your program
 configuration, including how you set up your program indicator.

 Are you using event capture (single event data) or tracker capture
 (multiple events and registration) for this use cases?

 When you say you can see the data in event reports, does that include
 aggregate values in the 'aggregated mode'?

 If I have trouble with my program indicators, I typically like to use
 pivot table app to debug. Try to add a few indicators that just count all
 events or all enrollments and display these at the same time. Will give you
 an indication of whether event analytics worked or not.

 Then for your program indicators where you struggle to get data, try to
 play with the different options of aggregation, e.g event count, enrollment
 count etc. You'll soon see if the issue is related to aggregation or the
 filter.

 Ola
 ---

 On 17 May 2017 17:48, "Em Le Hong"  wrote:

> Hi,
>
> If everything is ok and your formula is correct but you can't see the
> result. I guess you select both program indicator and data elements to 
> show
> in Pivot table or Event report.
> Until now, DHIS2 only shows