Re: [Dhis2-devs] Impossible to create a Program Stage through UI

[Sam Johnson]

Hi Devs,

I made this same mistake the first time I tried using the new 2.30 interface, 
so it would be great if we could correct the label on this button in the 
create/edit Program Stage screen – I’ve reported it as 
https://jira.dhis2.org/browse/DHIS2-5277.

Cheers, Sam.

From: Dhis2-devs 
 on behalf of 
Eric Barreda Prades 
Date: Wednesday, 14 November 2018 at 15:16
To: "hend...@dhis2.org" 
Cc: DHIS2 Developers 
Subject: Re: [Dhis2-devs] Impossible to create a Program Stage through UI

Hi Hendrik,

Oh... yes that was the "issue". Quite awkard from my side, I'm sorry... thanks 
for the response and for your time :)

Best,

Eric

El mié., 14 nov. 2018 a las 13:08, Hendrik de Graaf 
(mailto:hend...@dhis2.org>>) escribió:
Hi Eric,

Thanks for reporting this problem. I tried reproducing this on 
https://play.dhis2.org/2.31-rc1/ and I think what you are experiencing might be 
an unclear UI, not a bug.

What I did to save a program stage:

  1.  Create or Edit a tracker program
  2.  Go to section 4 - Program stages
  3.  Add a new stage
  4.  Click “save" on the program-stage-form
  5.  Click “save” on the tracker-program-form
Without step 5 nothing gets saved and you will see the behaviour you describe. 
I suspect that that is what is going on.

Step 5 is an easy one to miss because at the bottom of the program-stage-form 
you also see a “save” button. Clicking this doesn’t actually trigger a request 
to the server, it simply adds a stage to the program in the client. Only after 
clicking “save" on the main form an API call is triggered and the event-program 
(with its updated stages) is actually persisted in the DB.

Could you confirm that this is what's going on?

Thanks,
Hendrik
On 12 Nov 2018, 19:09 +0100, Eric Barreda Prades 
mailto:ericbarre...@gmail.com>>, wrote:

Dear devs,

I cannot create a Program Stage through a Maintenance App. Steps to reproduce 
it:

- Add a program Stage. The programStage seems to be added (screenshot1). 
However I see nothing from console and the programstage cannot be found from 
API.
- If I refresh the page, the programStage disappears. (screenshot2)

However, I've tried to create the programStage via POST call and found no 
issue. Tested in 2.29 version and 2.31, but not in 2.30 (system is down, 
although I think I will get the same error). As this behaviour is quite weird 
and silly I prefered to verify on the list whether this is actually a bug or I 
am missing something.

Best,

Eric
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Play demo password

[Sam Johnson]

Many thanks!  To help any users trying to access the demo site today, I’ve 
updated the login page to show this new password.

Since this password hash is just held in the database, my understanding is that 
it shouldn’t be difficult to script a chron job that tests whether the password 
has been changed, and then re-updates it to the default value if necessary.  I 
think this was set up a while ago (see email thread below) – would it be 
difficult to re-implement it?

Cheers, Sam.


From: Knut Staring 
Date: Monday, 29 October 2018 at 11:58
To: Sam Johnson 
Cc: Lars Helge Øverland , Morten Olav Hansen 
, DHIS2 Developers 
Subject: Re: [Dhis2-devs] Play demo password

Think it is only replaced once daily. You can use "D1$trict" for now

On Mon, Oct 29, 2018 at 4:46 PM Sam Johnson 
mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

I think someone has changed the ‘admin’ password on 
play.dhis2.org/demo<http://play.dhis2.org/demo>, and everyone is locked out – 
is this instance not still set up to reset itself every 5-10mins (see below)?

Cheers, Sam.

From: Lars Helge Øverland mailto:l...@dhis2.org>>
Date: Monday, 9 January 2017 at 04:09
To: Morten Olav Hansen mailto:mor...@dhis2.org>>
Cc: Sam Johnson mailto:samuel.john...@qebo.co.uk>>, 
DHIS2 Developers 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] Play demo password

Hi Sam,

Jason has added a script for resetting the password now.

Lars


On Thu, Jan 5, 2017 at 2:18 AM, Morten Olav Hansen 
mailto:mor...@dhis2.org>> wrote:
Hi Sam

It should be reset in about 2-3 hours automatically.

I thought we had this blocked now, Jason?

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Thu, Jan 5, 2017 at 6:33 AM, Sam Johnson 
mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Devs,

Looks like someone’s changed the ‘admin’ password on 
play.dhis2.org/demo<http://play.dhis2.org/demo> again, and we can’t log in – 
would it be possible to get it reset?

Re: the suggestion below, would it be worth scripting a quick chron job that 
runs every five minutes to update the ‘admin’ password back to ‘district’ if it 
has changed?

Cheers, Sam.


From: Dhis2-devs 
mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
mailto:samuel.john...@qebo.co.uk>>
Date: Friday, 11 November 2016 at 04:50
To: Victor Garcia mailto:vgarcia...@gmail.com>>, DHIS2 
Developers 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: [Dhis2-devs] Play demo password

Hi all,

Re: Victor’s note about being locked out of the demo server, this sort of 
lock-out has happened a few times recently.  Would it perhaps be worth setting 
up a chron job that runs every five minutes to update the ‘admin’ user password 
back to ‘district’ if it has changed?

Cheers, Sam.


From: Dhis2-devs 
mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Victor Garcia mailto:vgarcia...@gmail.com>>
Date: Thursday, 10 November 2016 at 09:05
To: DHIS2 Developers 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: [Dhis2-devs] Program rule actions of type ASSIGN not working on 
SCHEDULED events

Hi all,

we have noticed a buggy behavior when using program rule actions of type ASSIGN 
in scheduled events. The program rule is correctly evaluated, but the program 
rule action does not assign the desired value to the dataelement in that event. 
This happens only when the event is created using the visit scheduler. If the 
event is created using the "Add new event" button the program rule action works 
fine.

The steps to reproduce the issue:
1. Create a programRuleVariable of type "DATAELEMENT_CURRENT_EVENT" with the 
dataelement we want to copy.
2. Create a programRule limited to that programStage.
3. Assign a programRuleAction of type ASSIGN, with the previously crated 
programRuleVariable as the "data" and a dataelement as the target.

I couldn't access demo server to reproduce the issue (it seems that admin 
password has been changed), but I did in dev server and created an example that 
you can easily verify until it is reset tonight. It is in the program "WHO 
RMNCH Tracker", in the stage "Postpartum care visit". I added a new dataelement 
called "Copy HIV test result" just below "HIV test result" that copies its 
value. You can verify that if the stage is created using the "Add event button" 
the value is correctly copied; but it the stage is added using the visit 
scheduler, the value is not copied.

If there is doubt please let me know.

Thank you!

Víctor

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


_

Re: [Dhis2-devs] Play demo password

[Sam Johnson]

Hi all,

I think someone has changed the ‘admin’ password on play.dhis2.org/demo, and 
everyone is locked out – is this instance not still set up to reset itself 
every 5-10mins (see below)?

Cheers, Sam.

From: Lars Helge Øverland 
Date: Monday, 9 January 2017 at 04:09
To: Morten Olav Hansen 
Cc: Sam Johnson , DHIS2 Developers 

Subject: Re: [Dhis2-devs] Play demo password

Hi Sam,

Jason has added a script for resetting the password now.

Lars


On Thu, Jan 5, 2017 at 2:18 AM, Morten Olav Hansen 
mailto:mor...@dhis2.org>> wrote:
Hi Sam

It should be reset in about 2-3 hours automatically.

I thought we had this blocked now, Jason?

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Thu, Jan 5, 2017 at 6:33 AM, Sam Johnson 
mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Devs,

Looks like someone’s changed the ‘admin’ password on 
play.dhis2.org/demo<http://play.dhis2.org/demo> again, and we can’t log in – 
would it be possible to get it reset?

Re: the suggestion below, would it be worth scripting a quick chron job that 
runs every five minutes to update the ‘admin’ password back to ‘district’ if it 
has changed?

Cheers, Sam.


From: Dhis2-devs 
mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
mailto:samuel.john...@qebo.co.uk>>
Date: Friday, 11 November 2016 at 04:50
To: Victor Garcia mailto:vgarcia...@gmail.com>>, DHIS2 
Developers 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: [Dhis2-devs] Play demo password

Hi all,

Re: Victor’s note about being locked out of the demo server, this sort of 
lock-out has happened a few times recently.  Would it perhaps be worth setting 
up a chron job that runs every five minutes to update the ‘admin’ user password 
back to ‘district’ if it has changed?

Cheers, Sam.


From: Dhis2-devs 
mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Victor Garcia mailto:vgarcia...@gmail.com>>
Date: Thursday, 10 November 2016 at 09:05
To: DHIS2 Developers 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: [Dhis2-devs] Program rule actions of type ASSIGN not working on 
SCHEDULED events

Hi all,

we have noticed a buggy behavior when using program rule actions of type ASSIGN 
in scheduled events. The program rule is correctly evaluated, but the program 
rule action does not assign the desired value to the dataelement in that event. 
This happens only when the event is created using the visit scheduler. If the 
event is created using the "Add new event" button the program rule action works 
fine.

The steps to reproduce the issue:
1. Create a programRuleVariable of type "DATAELEMENT_CURRENT_EVENT" with the 
dataelement we want to copy.
2. Create a programRule limited to that programStage.
3. Assign a programRuleAction of type ASSIGN, with the previously crated 
programRuleVariable as the "data" and a dataelement as the target.

I couldn't access demo server to reproduce the issue (it seems that admin 
password has been changed), but I did in dev server and created an example that 
you can easily verify until it is reset tonight. It is in the program "WHO 
RMNCH Tracker", in the stage "Postpartum care visit". I added a new dataelement 
called "Copy HIV test result" just below "HIV test result" that copies its 
value. You can verify that if the stage is created using the "Add event button" 
the value is correctly copied; but it the stage is added using the visit 
scheduler, the value is not copied.

If there is doubt please let me know.

Thank you!

Víctor

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.dhis2.org/>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

[Sam Johnson]

Hi Terence,

Many thanks for your follow-up.  When Zubair investigated, it turned out that 
there was in fact an issue with the Clickatell gateway setup on 2.30, and a 
software change was necessary, which was pushed with the DHIS2 2.30 update on 3 
October.  Apologies, I should have returned and updated this thread with the 
outcome of Zubair’s investigations – thanks for prompting me to do so.  ☺

Despite the fix in 2.30, Zubair explained to me that it still wasn’t possible 
for me to set up a Clickatell gateway via the user interface on 2.30, as my 
Clickatell URL is https://platform.clickatell.com/messages, whereas DHIS2 is 
set up for https://platform.clickatell.com/rest/messages.  Zubair said that 
this will be made configurable in a future release of DHIS2, but in the 
meantime I’d need to use the following API call instead of the user interface:
curl -i -X POST -H "Content-Type: application/json" -H "Accept: 
application/json" -u : -d '{"name" : 
"clickatell","username": "","password": "","authtoken": "","urlTemplate":"https://platform.clickatell.com/messages"}' -s 
http://http://%3cDHIS2> server address>/api/gateways/clickatell

Another point: when generating an API key, Clickatell will default to ‘HTTP’, 
so don’t forget to change this to ‘REST’.

With Zubair’s help, my SMS setup is now working smoothly.  Hope this is useful 
for anyone else trying to do this in 2.30.

Cheers, Sam.


From: Terence Scott 
Date: Thursday, 11 October 2018 at 08:59
To: Sam Johnson 
Cc: DHIS 2 Users list , DHIS2 Developers 
, "zub...@dhis2.org" 
Subject: Re: [Dhis2-users] [Dhis2-devs] SMS/Mobile configuration

Dear Samuel

I am on 2.28 and I just set up the SMS configuration and gateway by following 
the steps that you laid out in your descriptive email. I used Clickatell also 
and have the + and country code included into the number. I used my Clickatell 
username (not the email address). The clickatell username for me was all lower 
case (despite initially entering it into their system as uppercase). I am not 
sure if that may be an issue, but as mentioned, I have managed to set up the 
SMS function from scratch using what you supplied.

One thing you may check is whether your in your "User settings" in your 
profile, you are over-riding the system settings for "Enabling message SMS 
notifications".

Kind regards,
Terence

Terence Scott

Global Alliance for Rabies Control (GARC)
Pan-African Rabies Control Network (PARACON) Steering Committee
terence.sc...@rabiesalliance.org<mailto:terence.sc...@rabiesalliance.org>
https://paracon.rabiesalliance.org
Skype: tpscott1987



On Tue, Oct 2, 2018 at 4:34 PM Zubair Asghar Raja 
mailto:zub...@dhis2.org>> wrote:
Yes. Share the key and i will take a look into it.


Zubair Asghar
DHIS-2 Developer
University of Oslo
zub...@dhis2.org<mailto:l...@dhis2.org>
https://www.dhis2.org<https://www.dhis2.org/>


On Tue, Oct 2, 2018 at 4:10 PM Sam Johnson 
mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Zubair,

Thanks for the quick response.  ☺  Yes, I’ve already tried both with and 
without the leading ‘+’, and without any country identifier at all.  Looking at 
the format of the Clickatell API call, I assume the ‘+’ should be left off, but 
my guess is that if the user leaves it on, the DHIS2 interface trims it off 
anyway.

I’ve noticed that the Clickatell API defaults to HTTP, whereas I’m guessing 
DHIS2 uses REST?  (I’ve tried both API configurations anyway, without success.) 
 If I email you a temporary Clickatell API key, would you have time to quickly 
test it, to see if the API call that DHIS2 2.30 generates still matches the one 
that Clickatell is expecting?

Cheers, Sam.


From: Zubair Asghar Raja mailto:zub...@dhis2.org>>
Date: Tuesday, 2 October 2018 at 15:21
To: Sam Johnson mailto:samuel.john...@qebo.co.uk>>
Cc: Shurajit Dutta mailto:shurajitdu...@gmail.com>>, 
"jahidsha...@gmail.com<mailto:jahidsha...@gmail.com>" 
mailto:jahidsha...@gmail.com>>, DHIS 2 Users List 
mailto:dhis2-us...@lists.launchpad.net>>, 
"skaly...@gmail.com<mailto:skaly...@gmail.com>" 
mailto:skaly...@gmail.com>>, DHIS2 Developers 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

Hi Samuel,
Have you tried different number formats? For instance with + and without +




Zubair Asghar
DHIS-2 Developer
University of Oslo
zub...@dhis2.org<mailto:l...@dhis2.org>
https://www.dhis2.org<https://www.dhis2.org/>


On Tue, Oct 2, 2018 at 2:31 PM Sam Johnson 
mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

I’ve created an account with Clickatell, but despite following the 
documentation listed below, I’m struggling to configure it in my DHIS2 instance 
(v2.30).

In the ‘Mobile Configur

Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

[Sam Johnson]

Hi Zubair,

Thanks for the quick response.  ☺  Yes, I’ve already tried both with and 
without the leading ‘+’, and without any country identifier at all.  Looking at 
the format of the Clickatell API call, I assume the ‘+’ should be left off, but 
my guess is that if the user leaves it on, the DHIS2 interface trims it off 
anyway.

I’ve noticed that the Clickatell API defaults to HTTP, whereas I’m guessing 
DHIS2 uses REST?  (I’ve tried both API configurations anyway, without success.) 
 If I email you a temporary Clickatell API key, would you have time to quickly 
test it, to see if the API call that DHIS2 2.30 generates still matches the one 
that Clickatell is expecting?

Cheers, Sam.


From: Zubair Asghar Raja 
Date: Tuesday, 2 October 2018 at 15:21
To: Sam Johnson 
Cc: Shurajit Dutta , "jahidsha...@gmail.com" 
, DHIS 2 Users List , 
"skaly...@gmail.com" , DHIS2 Developers 

Subject: Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

Hi Samuel,
Have you tried different number formats? For instance with + and without +




Zubair Asghar
DHIS-2 Developer
University of Oslo
zub...@dhis2.org<mailto:l...@dhis2.org>
https://www.dhis2.org<https://www.dhis2.org/>


On Tue, Oct 2, 2018 at 2:31 PM Sam Johnson 
mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

I’ve created an account with Clickatell, but despite following the 
documentation listed below, I’m struggling to configure it in my DHIS2 instance 
(v2.30).

In the ‘Mobile Configuration’ module, I’ve selected ‘Add gateway’, and entered 
the following:

  *   ‘Auth Token’ is my Clickatell API key (ending in ==)
  *   For ‘Login’ I’ve tried both my Clickatell username (samueldjohnson) and 
my email address (which is what Clickatell actually asks for when I log into 
their portal)
  *   In DHIS2, I’ve made sure that ‘Enable message SMS notifications’ is 
ticked in Settings | Messaging.
  *   I’m doing all testing as superuser (so roles/authorities aren’t an issue).

(Note that despite the DHIS2 
documentation<https://docs.dhis2.org/2.30/en/user/html/mobile_sms_service.html> 
saying that only login+password or API key need to be set up, I’ve had to enter 
both into the DHIS2 ‘Mobile Configuration’ module, as the screen enforces all 
three fields as mandatory.)

However, whenever I use the ‘Mobile Configuration’ module’s ‘Send SMS’ feature 
to send a test SMS message, it fails.  (In the ‘List of sent SMS’, it shows the 
correct number, but has [unknown] as recipient, and ‘FAILED’ as status.)  I’ve 
configured the correct countries in Clickatell, and have successfully sent test 
messages to the same phone with API calls (using curl).  Am I missing something 
in my DHIS2 configuration?

Many thanks for any tips/enlightenment that anyone is able to provide!

Cheers, Sam.






From: Dhis2-devs 
mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Shurajit Dutta 
mailto:shurajitdu...@gmail.com>>
Date: Sunday, 23 April 2017 at 08:16
To: Jahid Shahed mailto:jahidsha...@gmail.com>>
Cc: DHIS 2 Users List 
mailto:dhis2-us...@lists.launchpad.net>>, 
Stanley Kalyati mailto:skaly...@gmail.com>>, DHIS2 
Developers 
mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

Hi everyone

Are you trying to set up SMS to receive information, to send out messages such 
as notifications etc or both?

For receiving (aggregate) data, I would suggest reviewing the docs here:

https://docs.dhis2.org/master/en/user/html/mobile_sms_command.html

You may want to start with adding an SMS gateway to your configuration for 
sending back feedback and notifications as well. Popular services include 
BulkSMS and Clickatell.

https://docs.dhis2.org/master/en/user/html/mobile_sms_service.html

After this is configured, you would also have to configure the notifications. 
If it is for a program you can read more about that here

https://docs.dhis2.org/master/en/user/html/manage_program_notification.html




On Apr 23, 2017 1:04 PM, "Jahid Shahed" 
mailto:jahidsha...@gmail.com>> wrote:
I am also interested to learn this.


Regards,

Jahid Hossen Shahed
Skype: jahidshahed

[Image removed by sender. http://images.wisestamp.com/widgets/green_32.png]  
Please consider your environmental responsibility. Before printing this e-mail 
message, ask yourself whether you really need a hard copy.

On Mon, Apr 17, 2017 at 7:04 PM, Stanley Kalyati 
mailto:skaly...@gmail.com>> wrote:
I am also waiting to learn from this.

Has this been answered? if so can anyone forward to me the responses.

Thank you

Stanley

On Wed, Apr 12, 2017 at 7:21 AM, Adhi 
mailto:adh...@yahoo.com>> wrote:
Dear all,

I have DHIS2 ver. 2.25 installed on a server.
Can anyone help me how to configure SMS? What hardware or software do I have to 
prepare? (like what kind of cellphone will be used, SMS gateway application, 
etc.).
Step-by-step g

Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

[Sam Johnson]

Hi all,

I’ve created an account with Clickatell, but despite following the 
documentation listed below, I’m struggling to configure it in my DHIS2 instance 
(v2.30).

In the ‘Mobile Configuration’ module, I’ve selected ‘Add gateway’, and entered 
the following:

  *   ‘Auth Token’ is my Clickatell API key (ending in ==)
  *   For ‘Login’ I’ve tried both my Clickatell username (samueldjohnson) and 
my email address (which is what Clickatell actually asks for when I log into 
their portal)
  *   In DHIS2, I’ve made sure that ‘Enable message SMS notifications’ is 
ticked in Settings | Messaging.
  *   I’m doing all testing as superuser (so roles/authorities aren’t an issue).

(Note that despite the DHIS2 
documentation 
saying that only login+password or API key need to be set up, I’ve had to enter 
both into the DHIS2 ‘Mobile Configuration’ module, as the screen enforces all 
three fields as mandatory.)

However, whenever I use the ‘Mobile Configuration’ module’s ‘Send SMS’ feature 
to send a test SMS message, it fails.  (In the ‘List of sent SMS’, it shows the 
correct number, but has [unknown] as recipient, and ‘FAILED’ as status.)  I’ve 
configured the correct countries in Clickatell, and have successfully sent test 
messages to the same phone with API calls (using curl).  Am I missing something 
in my DHIS2 configuration?

Many thanks for any tips/enlightenment that anyone is able to provide!

Cheers, Sam.






From: Dhis2-devs 
 on behalf of 
Shurajit Dutta 
Date: Sunday, 23 April 2017 at 08:16
To: Jahid Shahed 
Cc: DHIS 2 Users List , Stanley Kalyati 
, DHIS2 Developers 
Subject: Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

Hi everyone

Are you trying to set up SMS to receive information, to send out messages such 
as notifications etc or both?

For receiving (aggregate) data, I would suggest reviewing the docs here:

https://docs.dhis2.org/master/en/user/html/mobile_sms_command.html

You may want to start with adding an SMS gateway to your configuration for 
sending back feedback and notifications as well. Popular services include 
BulkSMS and Clickatell.

https://docs.dhis2.org/master/en/user/html/mobile_sms_service.html

After this is configured, you would also have to configure the notifications. 
If it is for a program you can read more about that here

https://docs.dhis2.org/master/en/user/html/manage_program_notification.html




On Apr 23, 2017 1:04 PM, "Jahid Shahed" 
mailto:jahidsha...@gmail.com>> wrote:
I am also interested to learn this.


Regards,

Jahid Hossen Shahed
Skype: jahidshahed

[http://images.wisestamp.com/widgets/green_32.png]  Please consider your 
environmental responsibility. Before printing this e-mail message, ask yourself 
whether you really need a hard copy.

On Mon, Apr 17, 2017 at 7:04 PM, Stanley Kalyati 
mailto:skaly...@gmail.com>> wrote:
I am also waiting to learn from this.

Has this been answered? if so can anyone forward to me the responses.

Thank you

Stanley

On Wed, Apr 12, 2017 at 7:21 AM, Adhi 
mailto:adh...@yahoo.com>> wrote:
Dear all,

I have DHIS2 ver. 2.25 installed on a server.
Can anyone help me how to configure SMS? What hardware or software do I have to 
prepare? (like what kind of cellphone will be used, SMS gateway application, 
etc.).
Step-by-step guidance will be very helpful.

Best regards,
Adhi Andrianto
@ sekolahmalaria.info


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-us...@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-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


[https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]

Virus-free. 
www.avast.com


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Can not add "Tracked entity type attribute" to "tracked entity type"

[Sam Johnson]

Hi all,

Following up on Abumere’s issue below, the attributes section of the ‘Tracked 
Entity Type’ screen seems to be broken in 2.30 (but works fine in 2.29).  
Reported as DHIS2-4647.

If you try adding attributes, they fail to save “no changes to be saved” 
(possibly the cause of DHIS2-4478?).  
If you already have attributes attached to your Tracked Entity Type, the whole 
‘attributes’ section of the screen disappears, so you can’t see the attributes 
you’ve assigned.

To replicate:

  1.  Attributes can’t be added: in Play demo, go to the Tracked Entity Type 
screen for ‘ARV Commodity’ – if you add attributes, the bottom of the screen 
fails to update, and the changes don’t save (“no changes to be saved”).
  2.  Attributes section of screen disappearing: in Play demo, go to the 
Tracked Entity Type screen for ‘Person’ (which already has attributes assigned) 
– the ‘attributes’ section isn’t showing.

I can’t find any API documentation for Tracked Entity Types, so I can’t test 
adding an attribute via the API, but I’ve added a a trackedentitytypeattribute 
via the database, and all works well, so this looks like it’s an 
application/user interface bug.

This (and a couple of other bugs) are probably blockers for 2.30, as I don’t 
think it’s currently possible to create a new Tracker via the Maintenance app.

Cheers, Sam.


From: Dhis2-devs 
 on behalf of 
Abumere Ejakhegbe 
Date: Monday, 6 August 2018 at 14:54
To: DHIS2 Developers 
Subject: Re: [Dhis2-devs] Can not add "Tracked entity type attribute" to 
"tracked entity type"

Just to add, I just checked out this behavior at https://play.dhis2.org/2.30 
and it is similar.

[cid:ii_jkic6fgr0_1650f833b8325fa9]


On Mon, Aug 6, 2018 at 2:38 PM, Abumere Ejakhegbe 
mailto:abumere.ejakhe...@gmail.com>> wrote:
Hello All,

I upgraded from 2.29 to 2.30. I just realized that I can no longer add "Tracked 
entity type attributes" to "Tracked entity type". Can anyone please help me out?

I am using the superuser account.

Thanks

Abumere

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Sam Johnson]

Hi Markus and Bernard,

At the start of last year, we reported this exclusion of parentheses from all 
program indicator functions as a bug 
(DHIS2-590), but it actually turned 
out to be intentional, so was changed from a bug to an Improvement.

Since it seems to keep cropping up as an issue, is there any chance we could 
sneak this Improvement into 2.30?  Even if, for performance reasons, we still 
need to exclude nested functions, it would be great to be able to use 
parentheses within function expressions.

Cheers, Sam.


From: Dhis2-users 
 on behalf 
of Markus Bekken 
Date: Friday, 9 February 2018 at 09:20
To: "Bernard Sadaka (IM Advisor)" 
Cc: dhis2-users , DHIS2 Developers 

Subject: Re: [Dhis2-users] [Dhis2-devs] Using program rule expressions in 
Program indicator expressions

Hi again Bernard,
it seems that the problem you experience might be caused by the presence of 
parenthesis in the expression inside your d2:condition. This is a bug, and can 
be followed up here: https://jira.dhis2.org/browse/DHIS2-2813
If you are able to write your expression without parenthesis, this is a 
workaround that you can use.

The general implementation of new functions in program indicators is followed 
up in jira issues, but there was none covering the mathematical functions you 
need here, so I created one that you can look at: 
https://jira.dhis2.org/browse/DHIS2-2814
Please complement or comment, and consider voting for it :)

Best regards,
Markus

P.S. won't X*100%100 always be 0?


7. feb. 2018 kl. 09:21 skrev Bernard Sadaka (IM Advisor) 
>:

Hello Markus,
Thank you for the list and explanation; is there any expected timeline for 
that? (JIRA issue, I can track?)

With regards to the number of decimals, even if set to zero at the program 
indicator and after running the analytics, the “pivot table” still shows the 
digits.

Regarding the expression, yes it is true, I’m rounding the constants, because I 
am actually creating a budget report and applying a discount rate on the 
individual cost of a specific PHCC activity and aggregating them using sum (so 
I am using one constant per cost of a PHCC activity and another for discount 
rate of all activities). I ended up using exact values in the constant instead 
of a discounted factor; after all, changing a discount factor is easier than 
changing 200 values individually when the discount rate changes. The reason for 
all this, is that with a discounted factor there is a need to round the values 
and disallow them to be cumulated in the sum of the aggregation in order to 
keep the report error free.
Hope the above explains my usecase: aggregating the data elements of a TEI and 
multiplying them by a cost constant and a discount factor. And yes the round 
functions in this case would be very beneficial.

Thank you again for your support.

All the best,
Bernard



Bernard Sadaka
Information Management Advisor
Première Urgence - Aide Médicale Internationale
Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
Ain el Remmaneh, Beirut, Lebanon
E-mail: lib@pu-ami.org
Cell: +961 71 004 881 (208)
Skype: imapuami
Website: https://www.pu-ami.org



From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Wednesday, February 7, 2018 9:52 AM
To: Bernard Sadaka (IM Advisor) >
Cc: dhis2-us...@lists.launchpad.net; 
DHIS 2 developers 
>
Subject: Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in 
Program indicator expressions

Hi there Bernard,
We aim to support more and hopefully all the program rule functions in program 
indicators.
Unfortunately we are not there yet, and the list of supported functions in 
program indicators can be found here:
19.4.5. Reference information: Functions, variables and operators to use in 
program indicator expressions and 
filters

Where did you get the wrong number of decimals? In the Pivot or in the 
Tracker/Event capture?

One question on your expression below, it seems you are trying to round off a 
constant from your defined constant values? Your use case I would have guessed 
is to round off a data element or tracked entity attribute value?

Best regards
Markus



6. feb. 2018 kl. 15:31 skrev Bernard Sadaka (IM Advisor) 
>:

I found a similar issue on JIRA (https://jira.dhis2.org/browse/DHIS2-2734)

But still doesn’t explain why I can’t use different expressions in program 
indicators ☹

All the best,

Re: [Dhis2-devs] Meta-data export with dependencies Fails

[Sam Johnson]

Hi Calle,

Which version of DHIS2 are you using?  In November I found a similar bug in 
2.28 (DHIS2-2493), where the import 
chokes on an unknown catCombo, but the cause is slightly different – it 
attempts to persist the data element with a NULL catCombo instead of 
substituting ‘default’ (and catCombo is a NOT NULL column).

Importing unknown catCombos (eg foreign ‘default’ catCombos) worked well in 
2.25, 2.26 and 2.27 when we tested them back in November, so it would be great 
to get this feature working properly again in 2.28.

Cheers, Sam.


From: Dhis2-devs 
 on behalf of 
Calle Hedberg 
Reply-To: "calle.hedb...@gmail.com" 
Date: Tuesday, 13 February 2018 at 09:47
To: DHIS2 Developers 
Subject: [Dhis2-devs] Meta-data export with dependencies Fails

Hi

I'm trying to export a single data set from one instance to another - it is a 
relatively simple data set with about 20 data elements, all using the same 
categorycombo.

Import fails with the following message:

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique 
constraint "uk_qp9201a4m6jl53sei0huh4l6s"
  Detail: Key (shortname)=(default) already exists.

So it looks like the import cannot handle that the "default" catcombo obviously 
vary from the source to the destination instance.

Is this a bug, or expected behaviour?

Regards
Calle

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Bug in import of Program Rule Variables

[Sam Johnson]

Hi Devs,

I’ve noticed that during XML imports of Program Rule Variables in 2.28, any 
variables based on TE attributes are losing their link to the relevant 
attribute – so they no longer work.  (I haven’t tested JSON imports, but I’m 
guessing the same thing is probably happening.)

This means that any TE attribute variables that are imported won’t work.  I’ve 
logged this as DHIS2-2671, and have 
included detailed instructions on how to replicate this bug.

Cheers, Sam.



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Program rule evaluations no longer being displayed in the browser's Javascript Console (Tracker Capture)

[Sam Johnson]

Hi Devs,

Sometime after 14 August, the 2.27 Tracker Capture web app seems to have 
stopped displaying the results of program rule evaluations in the Browser’s 
Javascript console (using Chrome 60.0.3112.101).

To replicate, open the browser console, open the WHO RMNCH Tracker, register a 
new patient, and load the Tracker dashboard – none of the program rule 
evaluations that were previously displayed in the console are now being 
displayed.

This was an extremely valuable feature (in fact the only way I know of 
debugging program rules, which can be very complex) – would it be possible to 
get it restored?  (Or is there another way of accessing these reports?)

Many thanks,

Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] 'Ask user to create new event...' no longer respects hiding of program stages

[Sam Johnson]

Hi Markus,

I’ve tested your new bug fixes, based on update e7ef0ca (2017-08-15), and the 
bug below (user is prompted to create events for hidden program stages) now 
seems to be fixed – many thanks.  ☺  Many thanks too for the other Tracker 
bug-fixes you’ve done over the past week or so, they’re a huge improvement!

However, a new and related bug seems to have crept in (perhaps as a typo during 
your bug-fix?): instead of the next program stage being prompted, the last 
program stage seems to be shown by default.  Eg in the WHO RMNCH Tracker, if 
you complete the ‘First antenatal care visit’ stage, the next stage you should 
be prompted to book is ‘Antenatal care visit’, but the stage you are now 
prompted to book is ‘Care at birth’.  (In line with your very efficient 
refactoring, this bug is consistent across both the automated ‘complete’ prompt 
and the plus/calendar buttons.)

This bug is a lot more serious than it sounds, as users are now very accustomed 
to just clicking ‘Save’ when prompted, so this could potentially result in a 
lot of data-entry errors.  Is this something you might be able to quickly fix?

Many thanks,

Sam.


From: Sam Johnson <samuel.john...@qebo.co.uk>
Date: Tuesday, 8 August 2017 at 14:28
To: Markus Bekken <mar...@dhis2.org>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, "de la Torre, Cristina" 
<cristina.delato...@icf.com>
Subject: Re: [Dhis2-devs] 'Ask user to create new event...' no longer respects 
hiding of program stages

Hi Markus,

Brilliant, many thanks for such a prompt response!  I’ll update my instance 
later today, and let you know how I go.

Many thanks, Sam.


From: Markus Bekken <mar...@dhis2.org>
Date: Tuesday, 8 August 2017 at 14:10
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] 'Ask user to create new event...' no longer respects 
hiding of program stages

Hey Sam,
A fix is just checked in and a build is triggering for 2.27. Please have a look 
and see if your usecase is working better now.

Markus

7. aug. 2017 kl. 13.55 skrev Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>:

Hi Devs,

I’ve reported this as DHIS2-2012<https://jira.dhis2.org/browse/DHIS2-2012>.  
Basically, when users are prompted to create a new event booking, they are now 
offered the next available program stage – even if it’s supposed to be hidden.  
This used to work correctly (ie hidden program stages were skipped, and the 
user was prompted to create a new event booking in the next available unhidden 
program stage), but seems to have stopped working in 2.27.  (I haven’t had time 
to check whether the latest updates have also affected this in older versions 
of DHIS2.)

The hiding of program stages works well when users manually add a new event 
booking, it’s just the ‘Ask user to create new event…’ prompt that’s broken.

This has broken a Tracker program that we’ve developed, so I’d be very grateful 
if someone is able to take a quick look.  (I’ve included full instructions in 
the Jira ticket for reproducing this issue on the Play demo.)

Many thanks,

Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] 'Ask user to create new event...' no longer respects hiding of program stages

[Sam Johnson]

Hi Markus,

Brilliant, many thanks for such a prompt response!  I’ll update my instance 
later today, and let you know how I go.

Many thanks, Sam.


From: Markus Bekken <mar...@dhis2.org>
Date: Tuesday, 8 August 2017 at 14:10
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] 'Ask user to create new event...' no longer respects 
hiding of program stages

Hey Sam,
A fix is just checked in and a build is triggering for 2.27. Please have a look 
and see if your usecase is working better now.

Markus

7. aug. 2017 kl. 13.55 skrev Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>:

Hi Devs,

I’ve reported this as DHIS2-2012<https://jira.dhis2.org/browse/DHIS2-2012>.  
Basically, when users are prompted to create a new event booking, they are now 
offered the next available program stage – even if it’s supposed to be hidden.  
This used to work correctly (ie hidden program stages were skipped, and the 
user was prompted to create a new event booking in the next available unhidden 
program stage), but seems to have stopped working in 2.27.  (I haven’t had time 
to check whether the latest updates have also affected this in older versions 
of DHIS2.)

The hiding of program stages works well when users manually add a new event 
booking, it’s just the ‘Ask user to create new event…’ prompt that’s broken.

This has broken a Tracker program that we’ve developed, so I’d be very grateful 
if someone is able to take a quick look.  (I’ve included full instructions in 
the Jira ticket for reproducing this issue on the Play demo.)

Many thanks,

Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] 'Ask user to create new event...' no longer respects hiding of program stages

[Sam Johnson]

Hi Devs,

I’ve reported this as DHIS2-2012.  
Basically, when users are prompted to create a new event booking, they are now 
offered the next available program stage – even if it’s supposed to be hidden.  
This used to work correctly (ie hidden program stages were skipped, and the 
user was prompted to create a new event booking in the next available unhidden 
program stage), but seems to have stopped working in 2.27.  (I haven’t had time 
to check whether the latest updates have also affected this in older versions 
of DHIS2.)

The hiding of program stages works well when users manually add a new event 
booking, it’s just the ‘Ask user to create new event…’ prompt that’s broken.

This has broken a Tracker program that we’ve developed, so I’d be very grateful 
if someone is able to take a quick look.  (I’ve included full instructions in 
the Jira ticket for reproducing this issue on the Play demo.)

Many thanks,

Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] How do filters work in Enrolment program indicators?

[Sam Johnson]

Hi Markus,

Many thanks for both the clarification and the tip – both really useful.  
However, my scenario is a slightly complex one – I’m trying to track a cohort 
of patients over time, including events that extend beyond the reporting 
period.  So for example, I want to pick Q1 last year as my period, and see 
whether any of the patients enrolled then have ever subsequently had a test.

My understanding is:

· if I use an ‘event’ analytics type, as you suggest below, only events 
that fall within the selected period will be evaluated – in other words, I’ll 
see only tests done during that period, regardless of when the patient was 
actually enrolled (and regardless of whether they’ve had a test before or after 
that period);

· if, however, I use the ‘enrolment’ analytics type, only enrolments 
that start within the selected period will be counted, but all ‘newest’ events 
for each program stage (including those that fall outside of the period) will 
be evaluated in the expression…  allowing me to track a cohort of enrolments 
beyond the selected period.
Is this understanding of how it all works correct?

Once again, many thanks in advance for any advice/clarification you’re able to 
provide!

Cheers, Sam.


From: Markus Bekken <mar...@dhis2.org>
Date: Monday, 8 May 2017 at 18:48
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] How do filters work in Enrolment program indicators?

Hi Sam,

your suspicion is correct. In Enrollment program indicators you will always 
evaluate the newest value for each of the data elements within repeatable 
program stages - both for filters and expression. This means that for your use 
case you will have to use the event analyticstype.

I think you can acheive what you seek here by making the following program 
indicator:
AnalyticsType: Event
Aggregation type: Count
Expression: Enrollment count
Filter: Event macthing the test result

This program indicator will first find all events that matches the filter 
criteria, then make sure to count only how many distinct enrollments that is 
represented in this population of events.

Markus

8. mai 2017 kl. 12.09 skrev Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>:

Hi devs,

Just a quick question around the operation of the enrolment indicators.  I’m 
trying to do a program indicator which searches a repeatable program stage to 
see if one or more events include a specific data value (a test result).  The 
catch is that the data value could be in any event, and may even appear 
multiple times, but I only want to count each enrolment once, regardless of the 
number of test results.

I’ve tried using an ‘enrolment’ program indicator with a filter that ensures 
only events which include my data value are included in the indicator 
calculation; however, this doesn’t seem to be working as I expected, and the 
entire enrolment is often being filtered out, even though it contains a 
positive test result.

So I’d be grateful if you could clarify when the filter is applied for 
‘enrolment’ program indicators:
• Is it applied at the event level, before the enrolment record takes 
the ‘latest’ event for each program stage (so I can filter the events that are 
used to calculate the ‘latest’ event for each enrolment?)
• Or for Enrolment PIs is it actually an enrolment rather than an event 
filter, ie it’s applied after the ‘latest’ event has been pulled for each 
program stage (so the filter is only applied to the ‘latest’ events, not all 
events)?

I think the former would be more powerful, but if it’s the latter (which I 
suspect), is there another way of counting the number of enrolments that have 
had a particular value recorded during any one of a number of repeatable events?

Many thanks in advance for any help/thoughts you can share!

Cheers, Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] How do filters work in Enrolment program indicators?

[Sam Johnson]

Hi devs,

Just a quick question around the operation of the enrolment indicators.  I’m 
trying to do a program indicator which searches a repeatable program stage to 
see if one or more events include a specific data value (a test result).  The 
catch is that the data value could be in any event, and may even appear 
multiple times, but I only want to count each enrolment once, regardless of the 
number of test results.

I’ve tried using an ‘enrolment’ program indicator with a filter that ensures 
only events which include my data value are included in the indicator 
calculation; however, this doesn’t seem to be working as I expected, and the 
entire enrolment is often being filtered out, even though it contains a 
positive test result.

So I’d be grateful if you could clarify when the filter is applied for 
‘enrolment’ program indicators:

· Is it applied at the event level, before the enrolment record takes 
the ‘latest’ event for each program stage (so I can filter the events that are 
used to calculate the ‘latest’ event for each enrolment?)

· Or for Enrolment PIs is it actually an enrolment rather than an event 
filter, ie it’s applied after the ‘latest’ event has been pulled for each 
program stage (so the filter is only applied to the ‘latest’ events, not all 
events)?

I think the former would be more powerful, but if it’s the latter (which I 
suspect), is there another way of counting the number of enrolments that have 
had a particular value recorded during any one of a number of repeatable events?

Many thanks in advance for any help/thoughts you can share!

Cheers, Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture

[Sam Johnson]

Hi Markus,

Many thanks for this – you’re right, I’ve just tested it, and despite the name, 
the flag “Ask user to create new event when stage is complete” in fact seems to 
prompt the user even when just the event is complete (ie the stage is still 
open), which provides me with a workaround.  :-)

Cheers, Sam.


From: Markus Bekken <mar...@dhis2.org>
Date: Tuesday, 2 May 2017 at 08:35
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, "absolo...@yahoo.com" 
<absolo...@yahoo.com>, Immaculate Ayebazibwe <ekass...@gmail.com>
Subject: Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture

Hi Sam,
for the first part on event scheduling is fixed now. A bad version(without the 
schedule fix) was published inadvertently.

For the generation of the next visit, there seems to be a flag confusion here. 
There is two flags in the program stage config - one called "Display generate 
event box after completed" and another one called "Ask user to create new event 
when stage is complete".

For the moment the tracker only regards the last one - so if you check "Ask 
user to create new event when stage is complete" it should work.

We will clean this up as part of DHIS2-1507, but then you have a workaround.

Markus

1. mai 2017 kl. 13.51 skrev Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>:

Hi Markus,

Although I tested your fix for this when it was released, and it worked well in 
update 9a5f6d0 (25 April), this bug appears to have returned in the latest 
update 2e93869 (1 May) of 2.26.  What’s odd is that I can’t see any commits to 
the origin/v26 branch of tracker-capture-app since you made that change on 25 
April – is this now possibly a build error, or perhaps an underlying API issue?

This bug is very straightforward to reproduce – just use the calendar icon to 
schedule an event, and it instead creates the event. I’ve updated the existing 
Jira issue (DHIS2-1438<https://jira.dhis2.org/browse/DHIS2-1438>) with a 
comment – would it be possible to also re-open this issue?

Another bug also appears to have been introduced in both versions: the ‘Display 
generate event box after completed’ option no longer seems to be working.  This 
should (for repeatable program stages) prompt the user to schedule a future 
event at the appropriate interval – but now nothing happens at all.  (You can 
replicate this on Play Demo in the RMNCH Tracker, by first setting the 
‘standard interval days’ of the ‘Antenatal care visit’ program stage, then 
creating an event and ‘completing’ it – it fails to prompt you to schedule a 
follow-up ‘Antenatal care visit’.)  I’ve logged this as 
DHIS2-1507<https://jira.dhis2.org/browse/DHIS2-1507>.

I’d be very grateful if you’re able to find time to look at this again, as 
these two bugs have once again broken the Tracker in 2.26.

Many thanks, Sam.


From: Markus Bekken <mar...@dhis2.org<mailto:mar...@dhis2.org>>
Date: Tuesday, 25 April 2017 at 23:21
To: Sam Johnson <samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Cc: DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>, 
"absolo...@yahoo.com<mailto:absolo...@yahoo.com>" 
<absolo...@yahoo.com<mailto:absolo...@yahoo.com>>, Immaculate Ayebazibwe 
<ekass...@gmail.com<mailto:ekass...@gmail.com>>
Subject: Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture

Hey Sam!
Thanks for pushing this up the priority list. It was a relatively small fix, 
new versions of 2.26 and 2.27 snapshot are ready to download.

Best regards,
Markus

25. apr. 2017 kl. 17.35 skrev Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>:

Hi devs,

Just following up on the bug below 
(DHIS2-1438<https://jira.dhis2.org/browse/DHIS2-1438>).  I realize Abyot is on 
leave (congratulations! ☺), but this ticket is still assigned to him – is there 
anyone else who might be able to pick this up?

This bug is quite urgent, as it has effectively crippled the Tracker in 2.26.  
But I’m guessing that’s it’s just a case of the wrong code being fired, so 
should hopefully be fairly simple to fix?

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Date: Tuesday, 18 April 2017 at 19:55
To: Abyot Asalefew Gizaw <ab...@dhis2.org<mailto:ab...@dhis2.org>>, DHIS2 
Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Cc: "absolo...@yahoo.com<mailto:absolo...@yahoo.com>" 
<absolo...@yahoo.com<mailto:absolo...@yahoo.com>>

Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture

[Sam Johnson]

Hi Markus,

Although I tested your fix for this when it was released, and it worked well in 
update 9a5f6d0 (25 April), this bug appears to have returned in the latest 
update 2e93869 (1 May) of 2.26.  What’s odd is that I can’t see any commits to 
the origin/v26 branch of tracker-capture-app since you made that change on 25 
April – is this now possibly a build error, or perhaps an underlying API issue?

This bug is very straightforward to reproduce – just use the calendar icon to 
schedule an event, and it instead creates the event. I’ve updated the existing 
Jira issue (DHIS2-1438<https://jira.dhis2.org/browse/DHIS2-1438>) with a 
comment – would it be possible to also re-open this issue?

Another bug also appears to have been introduced in both versions: the ‘Display 
generate event box after completed’ option no longer seems to be working.  This 
should (for repeatable program stages) prompt the user to schedule a future 
event at the appropriate interval – but now nothing happens at all.  (You can 
replicate this on Play Demo in the RMNCH Tracker, by first setting the 
‘standard interval days’ of the ‘Antenatal care visit’ program stage, then 
creating an event and ‘completing’ it – it fails to prompt you to schedule a 
follow-up ‘Antenatal care visit’.)  I’ve logged this as 
DHIS2-1507<https://jira.dhis2.org/browse/DHIS2-1507>.

I’d be very grateful if you’re able to find time to look at this again, as 
these two bugs have once again broken the Tracker in 2.26.

Many thanks, Sam.


From: Markus Bekken <mar...@dhis2.org>
Date: Tuesday, 25 April 2017 at 23:21
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, "absolo...@yahoo.com" 
<absolo...@yahoo.com>, Immaculate Ayebazibwe <ekass...@gmail.com>
Subject: Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture

Hey Sam!
Thanks for pushing this up the priority list. It was a relatively small fix, 
new versions of 2.26 and 2.27 snapshot are ready to download.

Best regards,
Markus

25. apr. 2017 kl. 17.35 skrev Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>:

Hi devs,

Just following up on the bug below 
(DHIS2-1438<https://jira.dhis2.org/browse/DHIS2-1438>).  I realize Abyot is on 
leave (congratulations! ☺), but this ticket is still assigned to him – is there 
anyone else who might be able to pick this up?

This bug is quite urgent, as it has effectively crippled the Tracker in 2.26.  
But I’m guessing that’s it’s just a case of the wrong code being fired, so 
should hopefully be fairly simple to fix?

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Date: Tuesday, 18 April 2017 at 19:55
To: Abyot Asalefew Gizaw <ab...@dhis2.org<mailto:ab...@dhis2.org>>, DHIS2 
Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Cc: "absolo...@yahoo.com<mailto:absolo...@yahoo.com>" 
<absolo...@yahoo.com<mailto:absolo...@yahoo.com>>, Immaculate Ayebazibwe 
<ekass...@gmail.com<mailto:ekass...@gmail.com>>
Subject: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture


This sender failed our fraud detection checks and may not be who they appear to 
be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing>

Feedback<http://aka.ms/SafetyTipsFeedback>

Hi Abyot,

I’ve come across what looks like a new bug introduced into Tracker Capture in 
2.26 – I don’t seem to be able toschedule events.  Although I’ve not used 
periods in my Tracker programs, I’m wondering if the fix discussed in the 
thread below has triggered this new bug?

In 2.26, both the calendar icon and the ‘ask user to create new event when 
stage is complete’ option now generate an open event instead of a scheduled 
event.  (In 2.25, both of these correctly create a scheduled event instead of 
an open event.)  Note that the one thing that still works fine is if the 
booking is auto-generated on enrolment – this still schedules rather than 
creates the event.)

To reproduce this in the Play demo website:
1.  Open Tracker Capture, select Ngelehun CHC, and register a new patient 
for the WHO RMNCH Tracker (first visit = 2017-01-01).
2.  Complete the ‘First antenatal care visit’, which triggers a prompt to 
‘Schedule new event for stage Antenatal care visit’ – a new ‘open’ visit is 
created instead of a scheduled visit (a future ‘open’ event shouldn’t be 
possible!).
3.  Use the ‘+’ icon to create a new event for 2017-02-01 – a new ‘open’ 
visit is correctly created.
4.  Use the calendar icon to schedule a new event (booking) for 2017-03-01 
– a new ‘open’ visit is created, instead of a scheduled vi

Re: [Dhis2-devs] Many program rules not firing in 2.26

[Sam Johnson]

Hi Markus,

Just following up my question below – is there any chance we could get this 
treated as a bug, and fixed in 2.26?  This issue has crippled 30-odd programs 
that Metrics for Management (M4M) has already published and deployed, but I’m 
guessing that the fix is probably just be a very simple string-handling change…

Many thanks for any help you might be able to give!

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Friday, 21 April 2017 at 17:58
To: Markus Bekken <mar...@dhis2.org>
Cc: Kenzo Fry <kenzo.fry.consult...@gmail.com>, Andrea Sprockett 
<and...@m4mgmt.org>, DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Many program rules not firing in 2.26


This sender failed our fraud detection checks and may not be who they appear to 
be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing>

Feedback<http://aka.ms/SafetyTipsFeedback>

Hi Markus (and other devs),

Many thanks for diagnosing this so quickly.  You’re spot-on, it’s the dash in 
the source name that’s causing the rules to fail – if I remove dashes from all 
source names, the rules fire without problems.  In fact, this seems wider than 
just dashes – program rules that were failing in another instance seem to now 
work if I similarly remove brackets and spaces from source names.

Would it be at all possible to get this treated as a bug and fixed in 2.26, 
rather than treated as an improvement for a future version of DHIS2?  These 
rules were all working perfectly when we did intensive testing on our programs 
in 2.25 (eg they work properly in 2.25 da6a2df / 2017-02-02 06:43), so this 
limitation seems to have been recently introduced (very likely by accident, 
since other element names allow dashes), and it’s breaking configurations that 
have worked well up until now.

The reason we’re so keen on this is that Metrics for Management has published 
XMLs for 29 EquityTool programs, and these have now been downloaded and 
installed in a wide range of DHIS2 instances.   It will be a huge job to not 
only update the source names in all of these 29 programs and re-publish them, 
but also contact all existing users and ask them to reinstall the corrected 
programs.  If there’s any chance we could get the program rules in 2.26 working 
as they did before, this would save us an enormous amount of work…

Many thanks for any help you might be able to give us with this!

Regards, Sam.


From: Markus Bekken <mar...@dhis2.org>
Date: Wednesday, 19 April 2017 at 14:55
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, Kenzo Fry 
<kenzo.fry.consult...@gmail.com>
Subject: Re: [Dhis2-devs] Many program rules not firing in 2.26

Hey Sam!
Thanks for reporting.

I tested WHO RMNCH and 'Hide program stage' on Play, and found that it the 
problem is in fact what is indicated by the console message in point 4 below. 
The source field #{currentProganancyOutcome} did not exist. Seems someone has 
renamed it to
#{Current Progranancy Outcome} - see below to the left:
[id:7B8238F2-5B98-4966-B039-0DA99918253F]

Such a name change should ideally clean up the expressions using the source 
field, or at least flag the ones that has become illegal as a result of the 
name change. At the moment however you would have to manually update the 
expressions after a name change. Updated the expression now on Play, and the 
expression runs fine:
Expression with id rule:xOm49QX4Nsc was successfully run. Original condition 
was: #{current Progranancy Outcome}  != 'Live birth' - Evaluation ended up 
as:''  != 'Live birth' - Result of evaluation was:true
[id:6EF07903-D629-46AE-9D57-513472ADDDB7]

In general your rules hiding program stages should work fine, let me know if 
you find any other problems here.

Looking into the second part of the mail regarding Event Capture - this is a 
different problem: There is a dash in the source field name. Registered an 
improvement in Jira based on this: https://jira.dhis2.org/browse/DHIS2-1449 - 
but avoiding dashes is a possible workaround.

Best regards,
Markus

19. apr. 2017 kl. 12.43 skrev Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>:

Hi Devs,

I’m finding that a number of program rules aren’t firing in 2.26 – this is 
happening with both Event Capture and Tracker Capture.

This includes the sample ‘Hide Program Stage’ rule which has been added to the 
WHO RMNCH Tracker for the 2.26 release.  To reproduce in Play demo:
1.   add a new registration to the WHO RMNCH Tracker with date 2017-01-01
2.   complete the initial visit, and click ‘cancel’ to prevent creation of 
a second antenatal care visit
3.   click ‘+’ to create a ‘Care at birth’ event on 2017-02-01
4.   for WHOMCH pregnancy outcome, select ‘Stillbirth’, and compl

Re: [Dhis2-devs] Program rules/program validation(?) issue in latest 2.25

[Sam Johnson]

Hi Olav and Abyot,

We’ve come across the same bug in the Tuesday build of 2.25 (build revision 
41c0625, build date 2017-04-18 16:10) – program rules are failing to fire in 
Event Capture, without any errors in the console or logs.

I don’t think a Jira ticket’s been created for this yet, so I’ve added: 
https://jira.dhis2.org/browse/DHIS2-1459.

Cheers, Sam.


From: Dhis2-devs 
 on behalf of 
Abyot Asalefew Gizaw 
Date: Thursday, 20 April 2017 at 10:12
To: Olav Poppe 
Cc: Markus Bekken , DHIS2 Developers 

Subject: Re: [Dhis2-devs] Program rules/program validation(?) issue in latest 
2.25

Not sure, but I can suspect one thing: may be the removal of program rule json 
object affected the rules engine... I will check on this.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Thu, Apr 20, 2017 at 11:04 AM, Olav Poppe 
> wrote:
Thanks, Abyot.

If the 404 to programValidations is harmless as well, do you have any other 
idea of why program rules stop working when moving an instance from a 2.25 
build from March 10 to a build from April 20? These are the only errors.

Olav



20. apr. 2017 kl. 10.58 skrev Abyot Asalefew Gizaw 
>:

Hi,

Yes, we are aware that programValidation end point is removed ... we just have 
to remove a call to it.

Call to eventCaptureGridColumns is to check if the logged in user has saved any 
column show/hide settings ... the 404 says there are no settings saved.

The 404 errors in both cases are harmless ... users should be able to continue.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Thu, Apr 20, 2017 at 10:36 AM, Olav Poppe 
> wrote:
Forgot to say that this in EC - TC works.


20. apr. 2017 kl. 09.53 skrev Olav Poppe 
>:

Hi devs,
after upgrading to the latest 2.25 (build rev 1575b67) from an earlier 2.25 
version (build rev 210eb29), program rules have stopped working. The only 
issues I can see in the console and tomcat log is a failed call to 
/api/programValidations:

In catalina.out:
WARNING: No mapping found for HTTP request with URI 
[/stable/api/programValidations.json] in DispatcherServlet with name ‘webapi'

In browser console:
GET 
http://localhost:8080/stable/api/programValidations.json?paging=false=id=program.id:in:[jo4akTBhEqq]&_=1492674277324
 404 (Not Found)


Looks like the programValidations.json was removed in this commit: 
https://github.com/dhis2/dhis2-core/commit/9c6c4d0385064863e730827b621c53357ff555b7
There were no programValidations in the first place in this database (previous 
and working 2.25 version returns an empty result), but it is the only error I 
get.




Well, there is also this error, but this one seems like a permanent feature:
404 (Not Found) - 
http://localhost:8080/stable/api/userDataStore/gridColumns/eventCaptureGridColumns

Olav
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Many program rules not firing in 2.26

[Sam Johnson]

Hi Devs,

I’m finding that a number of program rules aren’t firing in 2.26 – this is 
happening with both Event Capture and Tracker Capture.

This includes the sample ‘Hide Program Stage’ rule which has been added to the 
WHO RMNCH Tracker for the 2.26 release.  To reproduce in Play demo:

1.   add a new registration to the WHO RMNCH Tracker with date 2017-01-01

2.   complete the initial visit, and click ‘cancel’ to prevent creation of 
a second antenatal care visit

3.   click ‘+’ to create a ‘Care at birth’ event on 2017-02-01

4.   for WHOMCH pregnancy outcome, select ‘Stillbirth’, and complete the 
event.
The rule which should hide the postnatal program stage has not fired.  In the 
browser console, the following two errors are recorded are:

· Expression #{currentProgranancyOutcome}  != 'Live birth' contains 
variable currentProgranancyOutcome - but this variable is not defined.

· Expression with id rule:xOm49QX4Nsc could not be run. Original 
condition was: #{currentProgranancyOutcome}  != 'Live birth' - Evaluation ended 
up as:#{currentProgranancyOutcome}  != 'Live birth' - error 
message:SyntaxError: Invalid or unexpected token

The important error seems to be the second one, as in many cases this is 
appearing in isolation (without the first one), and is still breaking program 
rules.  For example, I’ve loaded the Cameroon EquityTool into the Play Demo 
instance, and any attempt to enter new Event Capture events for this program 
keeps generating similar error messages in the browser console, eg:

· Expression with id rule:gXwzJFfRn5m could not be run. Original 
condition was: #{EQT-CM11Q06a} + #{EQT-CM11Q06b} >1 - Evaluation ended up 
as:#{EQT-CM11Q06a} + #{EQT-CM11Q06b} >1 - error message:SyntaxError: Invalid or 
unexpected token
These program rules have been extensively tested on earlier releases, and 
worked well – where users used to be prevented from entering invalid surveys, 
they can now save invalid surveys.

This is very serious, as it means that in 2.26, users can now bypass many 
program rules, and save incomplete or incorrect data.  But I’m also aware that 
there have recently been build issues with 2.25 and 2.26 releases – before I 
log a bug on Jira, could this be related to those build issues?

Regards, Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

[Sam Johnson]

Hi Devs,

I’m just following up again on the queries about new/retired authorities that I 
raised about a month ago (please see bottom of this thread).  This is becoming 
very urgent as PSI approaches its upgrade to 2.25.

I’m wondering if the silence is because there isn’t a single person on the Dev 
team who is able to answer all of the questions below?  If that’s the case, 
would it perhaps be possible for anyone on the Dev team to chime in with notes 
on just the specific authorities that they’ve worked on?

Many thanks for any help you can provide,

Regards, Sam.


From: Sam Johnson <samuel.john...@qebo.co.uk>
Date: Monday, 27 February 2017 at 18:57
To: Lars Helge Øverland <l...@dhis2.org>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, Rodolfo Melia 
<rodolfo.me...@knowtechture.com>, JM Alcantara <jmalcanta...@gmail.com>
Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

Hi Devs,

I’m just following up on the questions below regarding authority changes in 
2.25, which I circulated a few weeks ago (see the items highlighted in red).  
There’s unfortunately no documentation on authorities, so I’d be very grateful 
for any help you’re able to give.

Many thanks,

Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Wednesday, 15 February 2017 at 12:57
To: Lars Helge Øverland <l...@dhis2.org>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

Hi Lars,

Many thanks, that’s a really useful trick – takes less than half the time it 
took me to scrape the authorities!  :-)

Are you (or is someone else on the team) able to assist with the questions in 
my email below?  (I know the email is quite long, so I’ve just highlighted them 
in bold red.)

Many thanks,

Sam.


From: Lars Helge Øverland <l...@dhis2.org>
Date: Wednesday, 8 February 2017 at 03:58
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, JM Alcantara 
<jmalcanta...@gmail.com>, "rodolfo.me...@knowtechture.com" 
<rodolfo.me...@knowtechture.com>
Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)


Hi Sam,

thanks for bringing this up. It is an issue we need to handle better.

There is a trick to finding the complete set of authorities per version.
· Start up a DHIS instance of the desired version.
· Create a new user role, give it the name AAA, and select all 
available authorities, click Save.
· Then execute this SQL:

select ua.authority

into _auths

from userroleauthorities ua

inner join userrole ur on ua.userroleid=ur.userroleid

where ur.name<http://ur.name> = 'AAA';



You can repeat the process on the target DHIS 2 version instance, and then copy 
the tables into a single database and use SQL (..where not in..) to compare 
them.

You can also save this to a file and compare using CSV/Excel:

psql -d dhis2 -U dhis -c "select * from _auths"  > auths.txt

We can also work on this on our side and include pruning of obsolete 
authorities in a DHIS startup routine.

best,

Lars
​

On Tue, Feb 7, 2017 at 2:37 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Devs,

If possible, I’d be very grateful for some advice around authorities in 2.25.

In order to help prepare for PSI’s upgrade to 2.25, we’ve done an analysis of 
changes in Authorities between 2.22 and 2.25.  I couldn’t find a database table 
containing Authorities, and the list of Authorities in the DHIS2 documentation 
doesn’t appear to have been updated since version 2.22, so I’ve scraped the 
‘Authorities’ drop-down in the ‘Create Role’ screen to obtain lists of 
Authorities in 2.22 and 2.25 for comparison.

The following Authority changes seem fairly straightforward, and were 
documented as part of DHIS2 releases:

RETIRED (functionality no longer exists)

• View data browser

• See Data Set Maintenance module

• See Organisation Unit Maintenance module

• Scheduling case aggregate query builder
INTRODUCED (new functionality)

• Delete External Map Layer

• Add/Update Private External Map Layer

• Add/Update Public External Map Layer

• Add/Update Legend

• Delete Legend

• Delete Legend Set

• Add/Update Private Legend Set

• Add/Update Public Legend Set

• Metadata sync

• Add/Update Predictor

• Delete Predictor

• Delete Program Indicator Group

• Add/Update Private Program Indicator Group

• Add/Update Public Program Indicator Group

• Add/Update Push Analysis

• Delete Push Analysis

• See Usage Analytics module

I’m guessing the following Authorities have been retired because they duplicate 
exis

Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

[Sam Johnson]

Hi Devs,

I’m just following up on the questions below regarding authority changes in 
2.25, which I circulated a few weeks ago (see the items highlighted in red).  
There’s unfortunately no documentation on authorities, so I’d be very grateful 
for any help you’re able to give.

Many thanks,

Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Wednesday, 15 February 2017 at 12:57
To: Lars Helge Øverland <l...@dhis2.org>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

Hi Lars,

Many thanks, that’s a really useful trick – takes less than half the time it 
took me to scrape the authorities!  :-)

Are you (or is someone else on the team) able to assist with the questions in 
my email below?  (I know the email is quite long, so I’ve just highlighted them 
in bold red.)

Many thanks,

Sam.


From: Lars Helge Øverland <l...@dhis2.org>
Date: Wednesday, 8 February 2017 at 03:58
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, JM Alcantara 
<jmalcanta...@gmail.com>, "rodolfo.me...@knowtechture.com" 
<rodolfo.me...@knowtechture.com>
Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)


Hi Sam,

thanks for bringing this up. It is an issue we need to handle better.

There is a trick to finding the complete set of authorities per version.
· Start up a DHIS instance of the desired version.
· Create a new user role, give it the name AAA, and select all 
available authorities, click Save.
· Then execute this SQL:

select ua.authority

into _auths

from userroleauthorities ua

inner join userrole ur on ua.userroleid=ur.userroleid

where ur.name<http://ur.name> = 'AAA';



You can repeat the process on the target DHIS 2 version instance, and then copy 
the tables into a single database and use SQL (..where not in..) to compare 
them.

You can also save this to a file and compare using CSV/Excel:

psql -d dhis2 -U dhis -c "select * from _auths"  > auths.txt

We can also work on this on our side and include pruning of obsolete 
authorities in a DHIS startup routine.

best,

Lars
​

On Tue, Feb 7, 2017 at 2:37 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Devs,

If possible, I’d be very grateful for some advice around authorities in 2.25.

In order to help prepare for PSI’s upgrade to 2.25, we’ve done an analysis of 
changes in Authorities between 2.22 and 2.25.  I couldn’t find a database table 
containing Authorities, and the list of Authorities in the DHIS2 documentation 
doesn’t appear to have been updated since version 2.22, so I’ve scraped the 
‘Authorities’ drop-down in the ‘Create Role’ screen to obtain lists of 
Authorities in 2.22 and 2.25 for comparison.

The following Authority changes seem fairly straightforward, and were 
documented as part of DHIS2 releases:

RETIRED (functionality no longer exists)

• View data browser

• See Data Set Maintenance module

• See Organisation Unit Maintenance module

• Scheduling case aggregate query builder
INTRODUCED (new functionality)

• Delete External Map Layer

• Add/Update Private External Map Layer

• Add/Update Public External Map Layer

• Add/Update Legend

• Delete Legend

• Delete Legend Set

• Add/Update Private Legend Set

• Add/Update Public Legend Set

• Metadata sync

• Add/Update Predictor

• Delete Predictor

• Delete Program Indicator Group

• Add/Update Private Program Indicator Group

• Add/Update Public Program Indicator Group

• Add/Update Push Analysis

• Delete Push Analysis

• See Usage Analytics module

I’m guessing the following Authorities have been retired because they duplicate 
existing (more refined) Authorities?   Could you confirm whether this guess is 
correct?
RETIRED AS REDUNDANT?:

• Option Set Management

• Constant Management
DO THESE EXISTING AUTHORITIES MAINTAINED IN 2.25 PROVIDE THE SAME PERMISSIONS?

• Delete Option Set

• Add/Update Private Option Set

• Add/Update Public Option Set


• Add Constant

• Delete Constant

I’m not sure what the following new set of Authorities govern – I’ve looked at 
Option Sets (as distinct from Category Option Group Sets), but can’t find any 
concept of ‘Groups’ in Options/Option Sets…  What do these new authorities 
control?
INTRODUCED

• Delete Option Group

• Add/Update Private Option Group

• Add/Update Public Option Group

• Delete Option Group Set

• Add/Update Private Option Group Set

• Add/Update Public Option Group Set

The following appear 

Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

[Sam Johnson]

Hi Lars,

Many thanks, that’s a really useful trick – takes less than half the time it 
took me to scrape the authorities!  :-)

Are you (or is someone else on the team) able to assist with the questions in 
my email below?  (I know the email is quite long, so I’ve just highlighted them 
in bold red.)

Many thanks,

Sam.


From: Lars Helge Øverland <l...@dhis2.org>
Date: Wednesday, 8 February 2017 at 03:58
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, JM Alcantara 
<jmalcanta...@gmail.com>, "rodolfo.me...@knowtechture.com" 
<rodolfo.me...@knowtechture.com>
Subject: Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)


Hi Sam,

thanks for bringing this up. It is an issue we need to handle better.

There is a trick to finding the complete set of authorities per version.
· Start up a DHIS instance of the desired version.
· Create a new user role, give it the name AAA, and select all 
available authorities, click Save.
· Then execute this SQL:

select ua.authority

into _auths

from userroleauthorities ua

inner join userrole ur on ua.userroleid=ur.userroleid

where ur.name<http://ur.name> = 'AAA';



You can repeat the process on the target DHIS 2 version instance, and then copy 
the tables into a single database and use SQL (..where not in..) to compare 
them.

You can also save this to a file and compare using CSV/Excel:

psql -d dhis2 -U dhis -c "select * from _auths"  > auths.txt

We can also work on this on our side and include pruning of obsolete 
authorities in a DHIS startup routine.

best,

Lars
​

On Tue, Feb 7, 2017 at 2:37 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Devs,

If possible, I’d be very grateful for some advice around authorities in 2.25.

In order to help prepare for PSI’s upgrade to 2.25, we’ve done an analysis of 
changes in Authorities between 2.22 and 2.25.  I couldn’t find a database table 
containing Authorities, and the list of Authorities in the DHIS2 documentation 
doesn’t appear to have been updated since version 2.22, so I’ve scraped the 
‘Authorities’ drop-down in the ‘Create Role’ screen to obtain lists of 
Authorities in 2.22 and 2.25 for comparison.

The following Authority changes seem fairly straightforward, and were 
documented as part of DHIS2 releases:

RETIRED (functionality no longer exists)

• View data browser

• See Data Set Maintenance module

• See Organisation Unit Maintenance module

• Scheduling case aggregate query builder
INTRODUCED (new functionality)

• Delete External Map Layer

• Add/Update Private External Map Layer

• Add/Update Public External Map Layer

• Add/Update Legend

• Delete Legend

• Delete Legend Set

• Add/Update Private Legend Set

• Add/Update Public Legend Set

• Metadata sync

• Add/Update Predictor

• Delete Predictor

• Delete Program Indicator Group

• Add/Update Private Program Indicator Group

• Add/Update Public Program Indicator Group

• Add/Update Push Analysis

• Delete Push Analysis

• See Usage Analytics module

I’m guessing the following Authorities have been retired because they duplicate 
existing (more refined) Authorities?   Could you confirm whether this guess is 
correct?
RETIRED AS REDUNDANT?:

• Option Set Management

• Constant Management
DO THESE EXISTING AUTHORITIES MAINTAINED IN 2.25 PROVIDE THE SAME PERMISSIONS?

• Delete Option Set

• Add/Update Private Option Set

• Add/Update Public Option Set


• Add Constant

• Delete Constant

I’m not sure what the following new set of Authorities govern – I’ve looked at 
Option Sets (as distinct from Category Option Group Sets), but can’t find any 
concept of ‘Groups’ in Options/Option Sets…  What do these new authorities 
control?
INTRODUCED

• Delete Option Group

• Add/Update Private Option Group

• Add/Update Public Option Group

• Delete Option Group Set

• Add/Update Private Option Group Set

• Add/Update Public Option Group Set

The following appear to have been RETIRED prior to the 2.25 release – could you 
confirm that these Authorities have indeed been retired (rather than just 
missed off the drop-down of Authorities in the ‘Create Role’ screen)?  If they 
have been retired, which Authority now manages these permissions?
RETIRED?  (AND REPLACED BY?)

• Add Relationship Type – now covered by ???

• Delete Relationship Type – now covered by ???


• Scheduling send messages – now covered by ???


• Add/Update Section – now covered by ???

• Delete Section – now covered by ???


• Add/Update Tracked Entity – now covered by ???

• Delete Tracke

[Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

[Sam Johnson]

Hi Devs,

If possible, I’d be very grateful for some advice around authorities in 2.25.

In order to help prepare for PSI’s upgrade to 2.25, we’ve done an analysis of 
changes in Authorities between 2.22 and 2.25.  I couldn’t find a database table 
containing Authorities, and the list of Authorities in the DHIS2 documentation 
doesn’t appear to have been updated since version 2.22, so I’ve scraped the 
‘Authorities’ drop-down in the ‘Create Role’ screen to obtain lists of 
Authorities in 2.22 and 2.25 for comparison.

The following Authority changes seem fairly straightforward, and were 
documented as part of DHIS2 releases:

RETIRED (functionality no longer exists)

· View data browser

· See Data Set Maintenance module

· See Organisation Unit Maintenance module

· Scheduling case aggregate query builder
INTRODUCED (new functionality)

· Delete External Map Layer

· Add/Update Private External Map Layer

· Add/Update Public External Map Layer

· Add/Update Legend

· Delete Legend

· Delete Legend Set

· Add/Update Private Legend Set

· Add/Update Public Legend Set

· Metadata sync

· Add/Update Predictor

· Delete Predictor

· Delete Program Indicator Group

· Add/Update Private Program Indicator Group

· Add/Update Public Program Indicator Group

· Add/Update Push Analysis

· Delete Push Analysis

· See Usage Analytics module

I’m guessing the following Authorities have been retired because they duplicate 
existing (more refined) Authorities?   Could you confirm whether this guess is 
correct?
RETIRED AS REDUNDANT?:

· Option Set Management

· Constant Management
DO THESE EXISTING AUTHORITIES MAINTAINED IN 2.25 PROVIDE THE SAME PERMISSIONS?

· Delete Option Set

· Add/Update Private Option Set

· Add/Update Public Option Set


· Add Constant

· Delete Constant

I’m not sure what the following new set of Authorities govern – I’ve looked at 
Option Sets (as distinct from Category Option Group Sets), but can’t find any 
concept of ‘Groups’ in Options/Option Sets…  What do these new authorities 
control?
INTRODUCED

· Delete Option Group

· Add/Update Private Option Group

· Add/Update Public Option Group

· Delete Option Group Set

· Add/Update Private Option Group Set

· Add/Update Public Option Group Set

The following appear to have been RETIRED prior to the 2.25 release – could you 
confirm that these Authorities have indeed been retired (rather than just 
missed off the drop-down of Authorities in the ‘Create Role’ screen)?  If they 
have been retired, which Authority now manages these permissions?
RETIRED?  (AND REPLACED BY?)

· Add Relationship Type – now covered by ???

· Delete Relationship Type – now covered by ???


· Scheduling send messages – now covered by ???


· Add/Update Section – now covered by ???

· Delete Section – now covered by ???


· Add/Update Tracked Entity – now covered by ???

· Delete Tracked Entity – now covered by ???


· Manage Tracked Entities – now covered by ???

· Update Tracked Entities – now covered by ???


· Delete Tracked Entity Attribute – now covered by ???

· Add/Update Private Tracked Entity Attribute – now covered by ???

· Add/Update Public Tracked Entity Attribute – now covered by ???


· Manage Tracked Entity Instance Reminders


· M_dhis-web-menu-management


We’d be very grateful for any advice or feedback you can provide on the 
questions above, as it would be a huge help in adjusting our own Roles to 
ensure permissions work smoothly during our 2.25 upgrade.

(Once the dust has settled on our 2.25 upgrade, I’d also be very happy to re-do 
this exercise for 2.26, and share it with this Dev list.)

Many thanks,

Sam.


Samuel Johnson - Consultant
—
Qebo Ltd
288a Gloucester Rd, Bristol BS7 8RP
Phone: +44 7734 960 923
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Play demo password

[Sam Johnson]

Hi Devs,

Looks like someone’s changed the ‘admin’ password on play.dhis2.org/demo again, 
and we can’t log in – would it be possible to get it reset?

Re: the suggestion below, would it be worth scripting a quick chron job that 
runs every five minutes to update the ‘admin’ password back to ‘district’ if it 
has changed?

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Friday, 11 November 2016 at 04:50
To: Victor Garcia <vgarcia...@gmail.com>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>
Subject: [Dhis2-devs] Play demo password

Hi all,

Re: Victor’s note about being locked out of the demo server, this sort of 
lock-out has happened a few times recently.  Would it perhaps be worth setting 
up a chron job that runs every five minutes to update the ‘admin’ user password 
back to ‘district’ if it has changed?

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Victor Garcia <vgarcia...@gmail.com>
Date: Thursday, 10 November 2016 at 09:05
To: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: [Dhis2-devs] Program rule actions of type ASSIGN not working on 
SCHEDULED events

Hi all,

we have noticed a buggy behavior when using program rule actions of type ASSIGN 
in scheduled events. The program rule is correctly evaluated, but the program 
rule action does not assign the desired value to the dataelement in that event. 
This happens only when the event is created using the visit scheduler. If the 
event is created using the "Add new event" button the program rule action works 
fine.

The steps to reproduce the issue:
1. Create a programRuleVariable of type "DATAELEMENT_CURRENT_EVENT" with the 
dataelement we want to copy.
2. Create a programRule limited to that programStage.
3. Assign a programRuleAction of type ASSIGN, with the previously crated 
programRuleVariable as the "data" and a dataelement as the target.

I couldn't access demo server to reproduce the issue (it seems that admin 
password has been changed), but I did in dev server and created an example that 
you can easily verify until it is reset tonight. It is in the program "WHO 
RMNCH Tracker", in the stage "Postpartum care visit". I added a new dataelement 
called "Copy HIV test result" just below "HIV test result" that copies its 
value. You can verify that if the stage is created using the "Add event button" 
the value is correctly copied; but it the stage is added using the visit 
scheduler, the value is not copied.

If there is doubt please let me know.

Thank you!

Víctor
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

[Sam Johnson]

Hi Lars,

OK, it sadly looks like permissions in Jira aren’t as sophisticated as 
permissions in DHIS2.  ;-)

We’ll just use a naming convention that makes it clear who should be using the 
dashboards (and others are of course welcome to take a peek if they want!).

Regards, Sam.


From: Lars Helge Øverland <l...@dhis2.org>
Date: Monday, 2 January 2017 at 18:17
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: Rachael Brooke <rach...@dhis2.org>, DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>, Juan Manuel Alcantara Acosta 
<jmalcanta...@gmail.com>, Rodolfo Melia <rodolfo.me...@knowtechture.com>
Subject: Re: [Dhis2-users] [Dhis2-devs] DHIS2-JIRA mini Getting Started doc

Hi Sam,

it seems this is not so easy and requires you to be a Jira administrator:

https://confluence.atlassian.com/jira064/managing-groups-720412316.html

We don't plan to grant admin rights at this point but let us know if you find a 
more clever way of achieving this ;)

Lars




On Mon, Jan 2, 2017 at 4:49 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Rachael/Devs,

Am just following up on the query below – is it at all possible to enable 
creation of private user groups within the DHIS2 Jira instance?

Regards, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Date: Tuesday, 6 December 2016 at 00:52
To: Rachael Brooke <rach...@dhis2.org<mailto:rach...@dhis2.org>>, DHIS 2 Users 
list <dhis2-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net>>, 
DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Cc: Juan Manuel Alcantara Acosta 
<jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>, Rodolfo Melia 
<rodolfo.me...@knowtechture.com<mailto:rodolfo.me...@knowtechture.com>>
Subject: Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

Hi Rachael,

I just wanted to congratulate the team on successfully migrating to Jira – it’s 
a great system, and will make feedback and collaboration around DHIS2 even 
easier.  (I’ve just set up a custom Kanban dashboard for PSI to monitor 2.25 
bug-testing, which was very easy to do.)

One quick request: would it be possible to enable ordinary users to set up 
custom user groups?  In order for PSI team members to be able to see this 
Kanban dashboard, I’ve had to open it up to ‘all logged-in users’, whereas I’m 
guessing things will very quickly get very cluttered if everyone can see 
everyone else’s dashboards…  Would it be possible for us to set up custom user 
groups, so we can share our custom filters and dashboards within a smaller set 
of users?

Cheers, Sam.


From: Dhis2-users 
<dhis2-users-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Rachael Brooke <rach...@dhis2.org<mailto:rach...@dhis2.org>>
Date: Monday, 28 November 2016 at 12:05
To: DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net>>, 
DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Subject: [Dhis2-users] DHIS2-JIRA mini Getting Started doc

Dear all,

As announced previously, we've shifted over to JIRA<https://jira.dhis2.org> for 
issue tracking.

Here's a mini JIRA guide we've compiled for you: Using DHIS2-JIRA for issue 
tracking<https://ci.dhis2.org/docs/master/en/implementer/html/dhis2_implementation_guide_full.html#jira-gettingstarted>.

Best regards,
DHIS2 content team<https://www.dhis2.org/learn>

rach...@dhis2.org<mailto:rach...@dhis2.org>
ceci...@dhis2.org<mailto:ceci...@dhis2.org>

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.dhis2.org/>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

[Sam Johnson]

Hi Rachael/Devs,

Am just following up on the query below – is it at all possible to enable 
creation of private user groups within the DHIS2 Jira instance?

Regards, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Tuesday, 6 December 2016 at 00:52
To: Rachael Brooke <rach...@dhis2.org>, DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>
Cc: Juan Manuel Alcantara Acosta <jmalcanta...@gmail.com>, Rodolfo Melia 
<rodolfo.me...@knowtechture.com>
Subject: Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

Hi Rachael,

I just wanted to congratulate the team on successfully migrating to Jira – it’s 
a great system, and will make feedback and collaboration around DHIS2 even 
easier.  (I’ve just set up a custom Kanban dashboard for PSI to monitor 2.25 
bug-testing, which was very easy to do.)

One quick request: would it be possible to enable ordinary users to set up 
custom user groups?  In order for PSI team members to be able to see this 
Kanban dashboard, I’ve had to open it up to ‘all logged-in users’, whereas I’m 
guessing things will very quickly get very cluttered if everyone can see 
everyone else’s dashboards…  Would it be possible for us to set up custom user 
groups, so we can share our custom filters and dashboards within a smaller set 
of users?

Cheers, Sam.


From: Dhis2-users 
<dhis2-users-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf 
of Rachael Brooke <rach...@dhis2.org>
Date: Monday, 28 November 2016 at 12:05
To: DHIS 2 Users list <dhis2-us...@lists.launchpad.net>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>
Subject: [Dhis2-users] DHIS2-JIRA mini Getting Started doc

Dear all,

As announced previously, we've shifted over to JIRA<https://jira.dhis2.org> for 
issue tracking.

Here's a mini JIRA guide we've compiled for you: Using DHIS2-JIRA for issue 
tracking<https://ci.dhis2.org/docs/master/en/implementer/html/dhis2_implementation_guide_full.html#jira-gettingstarted>.

Best regards,
DHIS2 content team<https://www.dhis2.org/learn>

rach...@dhis2.org<mailto:rach...@dhis2.org>
ceci...@dhis2.org<mailto:ceci...@dhis2.org>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

[Sam Johnson]

Hi Rachael,

I just wanted to congratulate the team on successfully migrating to Jira – it’s 
a great system, and will make feedback and collaboration around DHIS2 even 
easier.  (I’ve just set up a custom Kanban dashboard for PSI to monitor 2.25 
bug-testing, which was very easy to do.)

One quick request: would it be possible to enable ordinary users to set up 
custom user groups?  In order for PSI team members to be able to see this 
Kanban dashboard, I’ve had to open it up to ‘all logged-in users’, whereas I’m 
guessing things will very quickly get very cluttered if everyone can see 
everyone else’s dashboards…  Would it be possible for us to set up custom user 
groups, so we can share our custom filters and dashboards within a smaller set 
of users?

Cheers, Sam.


From: Dhis2-users 
 on behalf 
of Rachael Brooke 
Date: Monday, 28 November 2016 at 12:05
To: DHIS 2 Users list , DHIS2 Developers 

Subject: [Dhis2-users] DHIS2-JIRA mini Getting Started doc

Dear all,

As announced previously, we've shifted over to JIRA for 
issue tracking.

Here's a mini JIRA guide we've compiled for you: Using DHIS2-JIRA for issue 
tracking.

Best regards,
DHIS2 content team

rach...@dhis2.org
ceci...@dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Possible bug with event data capture without the 'ALL' authority?

[Sam Johnson]

Hi Abyot,

Thanks for your reply.  It’s good to know that’s the only authority needed – I 
had included it, but was still getting these odd persistence errors unless the 
‘ALL’ authority was also included.

I’ve now upgraded to the latest update of 2.25, and the problem has 
disappeared!  I’m not sure what happened here – I hadn’t tried restarting the 
server, so perhaps that fixed something?   Or is someone actively working on 
permissions/persistence for the web EventCapture app in 2.25, and this was 
temporarily introduced as a bug?

Anyway, all now seems to be working.

Cheers, Sam.


From: Abyot Asalefew Gizaw <ab...@dhis2.org>
Date: Friday, 11 November 2016 at 07:58
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Possible bug with event data capture without the 
'ALL' authority?

Hi,

The required authority to save event is either F_TRACKED_ENTITY_DATAVALUE_ADD 
which is (Add/Update Tracked Entity Data Value)  or ALL.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Fri, Nov 11, 2016 at 12:19 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all, am just-resending this, as it doesn’t seem to have got through to the 
mailing list (apologies if I end up double-posting).

In my 2.25 instance, I’m running into problems when a user without the ‘ALL’ 
authority attempts to save an event-without-registration: it caches the data 
values, but doesn’t save them into the database.

I’m using 2.25, revision 221c5d8 (Wed morning), Chrome 54.0.2840.71 (64-bit),

Specifically:

• I can successfully open EventCapture, register a new event, and start 
capturing data.

• However, when I save, a programStageInstance is created in the 
database, but no records are saved to the trackedEntityDataValues table.

• Re-opening the event at first displays the data that was entered (but 
if the cache is cleared, it will appear empty, since no data has in fact been 
saved).

• If the browser is refreshed before clearing the cache, the message 
“There is data stored locally, please upload to server” appears, even though 
I’m online.

• Clicking ‘Update’ starts the upload to server, but it never completes 
(the logs show a single entry:
* INFO  2016-11-10 13:38:14,583 Import done: 00:00:00.000 
(Clock.java [http-bio-8080-exec-7])

• After clearing the cache, if the event is opened and fresh data 
entered, it sometimes updates the existing event, and sometimes creates a 
duplicate event on the same date; in both cases, the data is just cached, and 
although two events still appear if the cache is cleared, they are both empty 
again.

I don’t think this relates to a specific authority, as I’ve tried it with:

• a role with just selected EventCapture authorities

• a role with every authority except ‘ALL’

• a role with the ‘ALL’ authority.
Users with the ‘ALL’ role can successfully capture data, the other two run into 
this issue.

I also don’t think it relates to sharing, as I’ve opened up data element and 
program sharing to rw-- for the relevant User Group.  (The program contains 
only yes/no data elements, so there are no Option Sets to share.)

Is there some other aspect of sharing/authorities I’ve missed?  (The 
documentation includes an authority for ‘Single Event Without Registration Data 
Entry’ / ‘F_ANONYMOUS_DATA_ENTRY’, but that’s not available via the UI, and I’m 
guessing it doesn’t really exist any longer?)

Or is there perhaps a bug in part of the persistence process, which requires 
‘ALL’ permissions?  I’m wondering if this bug might have been introduced into 
2.25 by a recent update, as I’m pretty sure I successfully captured events 
using this user/role a week or two ago…

I have a project that’s completely stuck on this, so very grateful for any 
enlightenment anyone can provide…

Cheers, Sam.



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] FW: Bug in XML export / import for Program Rules

[Sam Johnson]

Many thanks.  :-)

BTW, I reported this via the email forum, as I’m still not sure where to 
formally report bugs – should we still be using Launchpad, or are you switching 
over to GitHub?  There seem to be recent issues listed on both sites...  which 
one will get noticed more quickly?  ;-)

Cheers, Sam.


From: Morten Olav Hansen <mor...@dhis2.org>
Date: Friday, 11 November 2016 at 01:42
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] FW: Bug in XML export / import for Program Rules

Hm ok, thanks Sam, I will look into it (it should have been encoded 
automatically)

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Fri, Nov 11, 2016 at 6:15 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

Using 2.25, revision 221c5d8 (Wed morning), Chrome

I just wanted to report a bug in the XML export / import for Program Rules:

• When you export XML for a program rule, ‘&&’ operators are kept as 
plain-text in the XML that is exported.

• When you re-import this XML, it crashes with the following log:
Caused by: com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character 
'&' (code 38) (expected a name start character)
If converted to character codes (‘ ’) they import fine, so I’m 
guessing the export routine just needs to be updated to convert them on export.

This is a blocker because the ‘and’ variant doesn’t seem to work for Program 
Rules (they fail to fire), so you are tied to using ‘&&’ in expressions.

Cheers, Sam.


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Possible bug with event data capture without the 'ALL' authority?

[Sam Johnson]

Hi all, am just-resending this, as it doesn’t seem to have got through to the 
mailing list (apologies if I end up double-posting).

In my 2.25 instance, I’m running into problems when a user without the ‘ALL’ 
authority attempts to save an event-without-registration: it caches the data 
values, but doesn’t save them into the database.

I’m using 2.25, revision 221c5d8 (Wed morning), Chrome 54.0.2840.71 (64-bit),

Specifically:

· I can successfully open EventCapture, register a new event, and start 
capturing data.

· However, when I save, a programStageInstance is created in the 
database, but no records are saved to the trackedEntityDataValues table.

· Re-opening the event at first displays the data that was entered (but 
if the cache is cleared, it will appear empty, since no data has in fact been 
saved).

· If the browser is refreshed before clearing the cache, the message 
“There is data stored locally, please upload to server” appears, even though 
I’m online.

· Clicking ‘Update’ starts the upload to server, but it never completes 
(the logs show a single entry:
* INFO  2016-11-10 13:38:14,583 Import done: 00:00:00.000 (Clock.java 
[http-bio-8080-exec-7])

· After clearing the cache, if the event is opened and fresh data 
entered, it sometimes updates the existing event, and sometimes creates a 
duplicate event on the same date; in both cases, the data is just cached, and 
although two events still appear if the cache is cleared, they are both empty 
again.

I don’t think this relates to a specific authority, as I’ve tried it with:

· a role with just selected EventCapture authorities

· a role with every authority except ‘ALL’

· a role with the ‘ALL’ authority.
Users with the ‘ALL’ role can successfully capture data, the other two run into 
this issue.

I also don’t think it relates to sharing, as I’ve opened up data element and 
program sharing to rw-- for the relevant User Group.  (The program contains 
only yes/no data elements, so there are no Option Sets to share.)

Is there some other aspect of sharing/authorities I’ve missed?  (The 
documentation includes an authority for ‘Single Event Without Registration Data 
Entry’ / ‘F_ANONYMOUS_DATA_ENTRY’, but that’s not available via the UI, and I’m 
guessing it doesn’t really exist any longer?)

Or is there perhaps a bug in part of the persistence process, which requires 
‘ALL’ permissions?  I’m wondering if this bug might have been introduced into 
2.25 by a recent update, as I’m pretty sure I successfully captured events 
using this user/role a week or two ago…

I have a project that’s completely stuck on this, so very grateful for any 
enlightenment anyone can provide…

Cheers, Sam.


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] FW: Bug in XML export / import for Program Rules

[Sam Johnson]

Hi all,

Using 2.25, revision 221c5d8 (Wed morning), Chrome

I just wanted to report a bug in the XML export / import for Program Rules:

· When you export XML for a program rule, ‘&&’ operators are kept as 
plain-text in the XML that is exported.

· When you re-import this XML, it crashes with the following log:
Caused by: com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character 
'&' (code 38) (expected a name start character)
If converted to character codes (‘ ’) they import fine, so I’m 
guessing the export routine just needs to be updated to convert them on export.

This is a blocker because the ‘and’ variant doesn’t seem to work for Program 
Rules (they fail to fire), so you are tied to using ‘&&’ in expressions.

Cheers, Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Play demo password

[Sam Johnson]

Hi all,

Re: Victor’s note about being locked out of the demo server, this sort of 
lock-out has happened a few times recently.  Would it perhaps be worth setting 
up a chron job that runs every five minutes to update the ‘admin’ user password 
back to ‘district’ if it has changed?

Cheers, Sam.


From: Dhis2-devs 
 on behalf of 
Victor Garcia 
Date: Thursday, 10 November 2016 at 09:05
To: DHIS2 Developers 
Subject: [Dhis2-devs] Program rule actions of type ASSIGN not working on 
SCHEDULED events

Hi all,

we have noticed a buggy behavior when using program rule actions of type ASSIGN 
in scheduled events. The program rule is correctly evaluated, but the program 
rule action does not assign the desired value to the dataelement in that event. 
This happens only when the event is created using the visit scheduler. If the 
event is created using the "Add new event" button the program rule action works 
fine.

The steps to reproduce the issue:
1. Create a programRuleVariable of type "DATAELEMENT_CURRENT_EVENT" with the 
dataelement we want to copy.
2. Create a programRule limited to that programStage.
3. Assign a programRuleAction of type ASSIGN, with the previously crated 
programRuleVariable as the "data" and a dataelement as the target.

I couldn't access demo server to reproduce the issue (it seems that admin 
password has been changed), but I did in dev server and created an example that 
you can easily verify until it is reset tonight. It is in the program "WHO 
RMNCH Tracker", in the stage "Postpartum care visit". I added a new dataelement 
called "Copy HIV test result" just below "HIV test result" that copies its 
value. You can verify that if the stage is created using the "Add event button" 
the value is correctly copied; but it the stage is added using the visit 
scheduler, the value is not copied.

If there is doubt please let me know.

Thank you!

Víctor
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Confirming 'official' handling of Yes and No in program indicators

[Sam Johnson]

Hi Lars,

Many thanks, that’s great to know – it makes handling Yes/No data types in 
indicators very easy!  ☺

Apologies, I’ve checked that “bug” again, and noticed I’d actually changed 
those data elements from my own custom Yes/No (ie an option set with Integer 
codes) to the native Yes/No – so it was possibly legacy data that had been 
saved before the datatype change that was showing up in the UI.  (That data’s 
unfortunately now been over-written, so I can’t be sure.)  For now, assume 
there’s no UI bug – I’ll let you know if I come across anything.

Many thanks again,

Sam.

From: Lars Helge Øverland <l...@dhis2.org>
Date: Wednesday, 2 November 2016 at 12:20
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Confirming 'official' handling of Yes and No in 
program indicators

Hi Sam,

On Mon, Oct 31, 2016 at 10:51 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Devs,

I’ve been working on some quite complex program indicators, and before I commit 
them to production, I would be very grateful if you could confirm how Yes and 
No are supposed to be handled in program indicator expressions.

I’ve noticed that within the program indicators, they currently resolve as 
Yes=1, No=0 and non-response=null.  So for example:

• Putting the data element ‘YesNoDE’ itself into an Event Report 
displays: Yes

• Creating an indicator containing #{YesNoDE} displays: 1

• You can do complex indicators involving the Yes/No data element, eg 
an index calculation:
1.2345 + #{YesNoDE_A}*2.3456+#{YesNoDE_B}*0.7654.

• You can even put these complex calculations within a d2:condition, eg 
to test thresholds:
d2:condition('1.2345 + #{YesNoDEa}*2.3456+#{YesNoDEb}*0.7654>3.1',1,0)

This is all excellent, as it enables us to do all sorts of powerful 
calculations/conditions with Yes/No responses interpreted as 1 or 0.  ☺

So my question: is this expected behaviour, and will it remain consistent in 
future versions of DHIS2?  I’ve noticed, for example, that there are some 
rendering bugs in Event Capture, where ‘No’ appears as ‘0’ etc – is there any 
chance that the handling above will be broken when those bugs are fixed, or 
will I be able to continue to rely on it?

Yes, it is expected, and will be continued.

To elaborate: In the trackedentity datavalue table we store boolean values as 
true | false. We convert this to 0 | 1 when we generate the analytics tables to 
make it more suited for aggregation (as you point out above).

Re the event capture bug - please report with a bit more context and we will 
try to fix - it is strange that it shows up as 0.

best regards,

Lars




Cheers, Sam.


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.dhis2.org/>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Tracker - enter data for different stages in programme in different orgunits

[Sam Johnson]

Hi Abyot,

Deepest apologies, you’re right, I’ve just checked and this is exactly the same 
in 2.24.  (I hadn’t noticed that I’d given all staff ‘data output’ permissions 
to the entire org unit tree.)

And on reflection, this actually makes a lot of sense the way it is: if a user 
can see the individual patient records in the Tracker, there’s not much point 
hiding the same data from them in the analytics.  (If you want to block them 
from exploring the data, I guess you could just give them the ‘Dashboard’ app, 
without any other analytics apps.)  The current setup also means you can set 
wide ‘search org units’ to allow an individual org unit to find any TEI and 
attach data to it, while still maintaining narrow ‘data output org units’ to 
prevent them seeing other org units’ data when they open a TEI’s dashboard.

Cheers, Sam.



From: Abyot Asalefew Gizaw <ab...@dhis2.org>
Date: Monday, 31 October 2016 at 11:28
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: Olav Poppe <olav.po...@me.com>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Tracker - enter data for different stages in 
programme in different orgunits

Hi Sam,
Yes, by data view I meant data output and analysis organisation units.
Nothing has changed in 2.25. What we have so far, TEI search organisation unit 
applies only for tracked entity instances. As I mentioned in my earlier mail, 
we need to do some work from server side so that we allow not only access to 
TEI but also to related enrollments and events.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Mon, Oct 31, 2016 at 11:10 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Abyot and Olav,

I’m very interested in this thread, but really confused by it.  ;-)

What do you mean by ‘data view’ org units – are you referring to ‘Data output 
and analysis organisation units’?

Like Olav, my understanding was that this should be handled by ‘Assign search 
org units’ – ie if you give a user ‘Data capture’ and ‘Data output’ permissions 
for just one org unit, but give them ‘Search org units’ for the whole tree, 
then they can search and view records for any TEI, but can only edit records 
for their own org unit.

I’m pretty sure that’s how it works in 2.24 – has this changed in 2.25?

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Olav Poppe <olav.po...@me.com<mailto:olav.po...@me.com>>
Date: Friday, 28 October 2016 at 19:41
To: Abyot Asalefew Gizaw <ab...@dhis2.org<mailto:ab...@dhis2.org>>
Cc: DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] Tracker - enter data for different stages in 
programme in different orgunits

Thanks, Abyot! I though data view only concerned output (analytics etc), I 
didn’t know it also had implications for data entry.

Olav



28. okt. 2016 kl. 16.37 skrev Abyot Asalefew Gizaw 
<ab...@dhis2.org<mailto:ab...@dhis2.org>>:

Just looked at your setting.
You need to give both clinic_dingo and lab_apple data view orgunit. I just 
assigned Trainingland for both them and it works.


--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org<http://www.dhis2.org/>

On Fri, Oct 28, 2016 at 4:01 PM, Abyot Asalefew Gizaw 
<ab...@dhis2.org<mailto:ab...@dhis2.org>> wrote:
I see... now I know the difference of scenarios we have been testing. I was 
using the same user with access to both facilities...

with the scenario you are setting, seems we need to do some work from server 
side so that we allow not only access to TEI but also to related enrollments 
and events ... Seems we don't really need TEI Search orgunit rather data view 
orgunit which we already have ...

Have you set data view orgunit to your user?

May be Lars and Morten can comment on if we are using data view orgunits in 
enrollments and events

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org<http://www.dhis2.org/>

On Fri, Oct 28, 2016 at 3:52 PM, Olav Poppe 
<olav.po...@me.com<mailto:olav.po...@me.com>> wrote:
Thanks, Abyot. I tried to set up user accounts on 
play.dhis2.org/demo<http://play.dhis2.org/demo> so that you could see, but for 
some reason I’m not able to assign "Search orgunits", server returns this error:
{"httpStatus":"Internal Server 
Error","httpStatusCode":500,"status":"ERROR","message":"Month not valid [1,7]"}

Will share logons to a different server privately.

The steps to reproduce is:
One user assigned to facility A creates a TEI and enrols the TEI in a program 
in his/her facility.

Another user assigned to facility B searches for the TEI

Re: [Dhis2-devs] Tracker - enter data for different stages in programme in different orgunits

[Sam Johnson]

Hi Abyot and Olav,

I’m very interested in this thread, but really confused by it.  ;-)

What do you mean by ‘data view’ org units – are you referring to ‘Data output 
and analysis organisation units’?

Like Olav, my understanding was that this should be handled by ‘Assign search 
org units’ – ie if you give a user ‘Data capture’ and ‘Data output’ permissions 
for just one org unit, but give them ‘Search org units’ for the whole tree, 
then they can search and view records for any TEI, but can only edit records 
for their own org unit.

I’m pretty sure that’s how it works in 2.24 – has this changed in 2.25?

Cheers, Sam.


From: Dhis2-devs 
 on behalf of 
Olav Poppe 
Date: Friday, 28 October 2016 at 19:41
To: Abyot Asalefew Gizaw 
Cc: DHIS2 Developers 
Subject: Re: [Dhis2-devs] Tracker - enter data for different stages in 
programme in different orgunits

Thanks, Abyot! I though data view only concerned output (analytics etc), I 
didn’t know it also had implications for data entry.

Olav



28. okt. 2016 kl. 16.37 skrev Abyot Asalefew Gizaw 
>:

Just looked at your setting.
You need to give both clinic_dingo and lab_apple data view orgunit. I just 
assigned Trainingland for both them and it works.


--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Fri, Oct 28, 2016 at 4:01 PM, Abyot Asalefew Gizaw 
> wrote:
I see... now I know the difference of scenarios we have been testing. I was 
using the same user with access to both facilities...

with the scenario you are setting, seems we need to do some work from server 
side so that we allow not only access to TEI but also to related enrollments 
and events ... Seems we don't really need TEI Search orgunit rather data view 
orgunit which we already have ...

Have you set data view orgunit to your user?

May be Lars and Morten can comment on if we are using data view orgunits in 
enrollments and events

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Fri, Oct 28, 2016 at 3:52 PM, Olav Poppe 
> wrote:
Thanks, Abyot. I tried to set up user accounts on 
play.dhis2.org/demo so that you could see, but for 
some reason I’m not able to assign "Search orgunits", server returns this error:
{"httpStatus":"Internal Server 
Error","httpStatusCode":500,"status":"ERROR","message":"Month not valid [1,7]"}

Will share logons to a different server privately.

The steps to reproduce is:
One user assigned to facility A creates a TEI and enrols the TEI in a program 
in his/her facility.

Another user assigned to facility B searches for the TEI, and opens the TEI 
dashboard. However, the enrolment done in facility A is not visible. At the 
same time, it is not possible to enrol the TEI again in facility B, because the 
TEI has an active enrolment in the same programme.

Olav




28. okt. 2016 kl. 09.21 skrev Abyot Asalefew Gizaw 
>:

Hi Olav,

I am not able to reproduce. It works fine from my side when testing with Child 
program.

Can you tell the steps to reproduce?

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Thu, Oct 27, 2016 at 4:47 PM, Olav Poppe 
> wrote:
Hi devs,
I struggling to set up tracker so that users in different orgunits can enter 
data for different stages in the same enrollement. I’ve been testing both in a 
dev database I’m working on and on play, with 2.24 and 2.25, and the result is 
the same:
- User A in Facility A enrolls a TEI in a program
- User B in Facility B searches for the TEI, but when opening the dashboard it 
just shows "No active enrollment.". At the same time, trying to enroll the 
person also fails, since the TEI is already enrolled…

Any advice on what I’m missing? I’ve even tested with "superusers" with no 
luck, so I don’t think its a user role issue.

Regards
Olav



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp






___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Confirming 'official' handling of Yes and No in program indicators

[Sam Johnson]

Hi Devs,

I’ve been working on some quite complex program indicators, and before I commit 
them to production, I would be very grateful if you could confirm how Yes and 
No are supposed to be handled in program indicator expressions.

I’ve noticed that within the program indicators, they currently resolve as 
Yes=1, No=0 and non-response=null.  So for example:

· Putting the data element ‘YesNoDE’ itself into an Event Report 
displays: Yes

· Creating an indicator containing #{YesNoDE} displays: 1

· You can do complex indicators involving the Yes/No data element, eg 
an index calculation:
1.2345 + #{YesNoDE_A}*2.3456+#{YesNoDE_B}*0.7654.

· You can even put these complex calculations within a d2:condition, eg 
to test thresholds:
d2:condition('1.2345 + #{YesNoDEa}*2.3456+#{YesNoDEb}*0.7654>3.1',1,0)

This is all excellent, as it enables us to do all sorts of powerful 
calculations/conditions with Yes/No responses interpreted as 1 or 0.  ☺

So my question: is this expected behaviour, and will it remain consistent in 
future versions of DHIS2?  I’ve noticed, for example, that there are some 
rendering bugs in Event Capture, where ‘No’ appears as ‘0’ etc – is there any 
chance that the handling above will be broken when those bugs are fixed, or 
will I be able to continue to rely on it?

Cheers, Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1625143] Re: The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are re

[Sam Johnson]

PPS - should we still be reporting bugs here on Launchpad, or should we
now register them on Github?

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625143

Title:
  The role/authority ‘Search tracked entity in all Org Units’  is not
  working, and even with this authority, a search will return only
  tracked entity instances that are registered/enrolled within user's
  own assigned org units

Status in DHIS:
  New

Bug description:
  Hi all,

  The ‘search tracked entity instance in all Org Units’ authority
  doesn’t appear to be working in 2.24 – see section 26.2 of the 2.24
  User Guide for details of this authority.  (This feature has been
  documented for quite some time now, but I haven’t yet had a chance to
  check whether or not it’s working in earlier versions of DHIS2.)  Even
  after being given a role containing this authority, users do not
  appear to be able to search for tracked entity instances outside of
  their assigned ‘data capture’ Org Units.

  
  To reproduce this in the 2.24 stable demo:

  1. While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH /
  PNC (Adult Woman)’, and select the Njandama MCHP org unit.

  2. Type ‘Sarah’ in the search box – it should return a record for
  Sarah Thompson registered at Ngelehun CHC.

  3. Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) program’ 
to include the following authorities:
  - Add/update tracked entity data value
  - Add/update tracked entity instance
  - Delete tracked entity data value
  - Delete tracked entity instance
  - Search tracked entity instance
  - Search tracked entity instance in All Org Units
  - See browser cache cleaner module
  - See dashboard integration module
  - See Tracker Capture Module

  4. Create a new user with just this role, and give it only the
  Njandama MCHP Org Unit.

  5. Log out and back in again with this new user.

  6. Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it
  should be the only one showing), and select the ‘MNCH / PNC’ program.

  7. Type ‘Sarah’ in the search box – no records are returned; click to
  show ‘detailed search’, and only the Njandama Org Unit is showing
  (rather than the wider OU tree mentioned in the documentation),
  meaning this user is not able to search for tracked entity instances
  registered/enrolled at Ngelehun CHC.

  
  Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625143/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1625143] Re: The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are re

[Sam Johnson]

Hi Abyot,

When you say “users have no control”, do you mean admin users, or data
capture users?

My understanding is that admin users can control this by having
different roles, and only giving the relevant ones this authority.  They
would only assign the role if they want enforce users to being able to
search all tracked entity instances – eg they want to avoid the same
patient ending up with duplicate records in different regions, simply
because one region’s users weren’t able to find the other region’s
original patient record.  (For us, ensuring everyone shares a single
patient record is very important.)

And data capture users should still have control over their searches –
even if they’re given this authority, they can still go into advanced
search, and use the tree to narrow down the tree of all org units to
just show patients from a particular district or facility.

I think it’s really useful keeping this authority – it is effectively a
shortcut which saves admins from having to individually assign each user
the top-level org unit as a ‘search org unit’ (and making this a role
rather than a user-by-user setting will reduce the number of manual
setup errors, which will in turn reduce the risk of duplicate tracked
entity instances).  It also makes managing security much easier/safer –
if there’s a role that we decide shouldn’t be able to search all
patients after all, we can just remove this authority from that role;
without this authority, we’d have to go into potentially hundreds of
individual user records, manually re-assigning each user’s ‘search org
units’ to match their data capture org units.

>From my perspective, the current design is actually quite good – it just
needs this bug fixed.

Cheers, Sam.

PS – the one tiny tweak I’d suggest would be to move the ‘search org
units’ setting to the same place as the ‘data capture org units’ and the
‘data output org units’, ie the user management screen, so we can see
them all side-by-side (which is important, because my understanding is
that in the absence of a specific ‘search org units’ setting, DHIS2 will
use the ‘data capture org units’ by default).

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625143

Title:
  The role/authority ‘Search tracked entity in all Org Units’  is not
  working, and even with this authority, a search will return only
  tracked entity instances that are registered/enrolled within user's
  own assigned org units

Status in DHIS:
  New

Bug description:
  Hi all,

  The ‘search tracked entity instance in all Org Units’ authority
  doesn’t appear to be working in 2.24 – see section 26.2 of the 2.24
  User Guide for details of this authority.  (This feature has been
  documented for quite some time now, but I haven’t yet had a chance to
  check whether or not it’s working in earlier versions of DHIS2.)  Even
  after being given a role containing this authority, users do not
  appear to be able to search for tracked entity instances outside of
  their assigned ‘data capture’ Org Units.

  
  To reproduce this in the 2.24 stable demo:

  1. While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH /
  PNC (Adult Woman)’, and select the Njandama MCHP org unit.

  2. Type ‘Sarah’ in the search box – it should return a record for
  Sarah Thompson registered at Ngelehun CHC.

  3. Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) program’ 
to include the following authorities:
  - Add/update tracked entity data value
  - Add/update tracked entity instance
  - Delete tracked entity data value
  - Delete tracked entity instance
  - Search tracked entity instance
  - Search tracked entity instance in All Org Units
  - See browser cache cleaner module
  - See dashboard integration module
  - See Tracker Capture Module

  4. Create a new user with just this role, and give it only the
  Njandama MCHP Org Unit.

  5. Log out and back in again with this new user.

  6. Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it
  should be the only one showing), and select the ‘MNCH / PNC’ program.

  7. Type ‘Sarah’ in the search box – no records are returned; click to
  show ‘detailed search’, and only the Njandama Org Unit is showing
  (rather than the wider OU tree mentioned in the documentation),
  meaning this user is not able to search for tracked entity instances
  registered/enrolled at Ngelehun CHC.

  
  Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625143/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] XML import bug

[Sam Johnson]

Hi Viet,

This fix looks like it has worked – the whole program XML is now importing 
smoothly into my 2.25 instance.  Many thanks for sorting this out so quickly!  ☺

Cheers, Sam.

From: Viet Nguyen <v...@dhis2.org>
Date: Wednesday, 19 October 2016 at 05:16
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] XML import bug

Hi Sam,

I have applied a fix for this issue on 2.25

Please try again.

Regards,


On Tue, Oct 18, 2016 at 12:23 PM, Viet Nguyen 
<v...@dhis2.org<mailto:v...@dhis2.org>> wrote:
Hi Sam,

Can you try to  use the full object name "dataElementCategoryCombo" instead of 
"categoryCombo" and try again. It works on my local.

Need more investigation to understand why the short name does not work though.

Regards.



On Mon, Oct 17, 2016 at 9:55 PM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi Devs,

The problem I reported yesterday has actually turned out to be what I think is 
a new bug in 2.25, which is stopping XML imports for data elements.

No matter what I do, any attempt at an XML import of data elements seems to 
throw the error “DataElementCategoryCombo Missing required property 
`categoryCombo`”, even if a valid CategoryCombo is supplied.  The same XML 
import works fine in 2.21.

To reproduce on play.dhis2.org<http://play.dhis2.org>:

• Using the import/export module, do an XML export of data elements 
only.

• Delete all data elements from the XML except DE_1148614 (which uses 
the default CategoryCombo), and change the user of that data element to .

• To circumvent a couple of other export/import bugs:
1. delete the three ‘<’ characters (which have been exported as plaintext 
instead of )
2. delete the  tags (I have no idea why these tags are failing)

• Import this XML file back into play.dhis2.org<http://play.dhis2.org>.

The import fails, and the import summary has the error message 
“DataElementCategoryCombo Missing required property `categoryCombo`” – despite 
the fact that the data element has the default categoryCombo id.

I’ve attached the XML I extracted from play.dhis2.org<http://play.dhis2.org> to 
speed up testing.  I’d be very grateful if you could look into this urgently, 
as I can’t currently do XML imports into my 2.25 instance.

Many thanks,

Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Date: Monday, 17 October 2016 at 04:54
To: DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Cc: Rodolfo Melia 
<rodolfo.me...@knowtechture.com<mailto:rodolfo.me...@knowtechture.com>>
Subject: [Dhis2-devs] FW: Null pointer exception calling .../api/me/programs

Hi all,

I’m trying to produce a generic EventCapture XML config that can be imported 
into any DHIS2 instance, which requires the data elements and program to use 
the default CategoryCombo of the target instance.

My understanding from the documentation (and the email thread below) is that if 
the CategoryCombo for a data element is null, then during metadata import the 
data element will automatically be assigned the local ‘default’ CategoryCombo; 
the problem is that I can’t figure out how to represent this ‘null’ 
CategoryCombo in the XML. I’ve tried:

• simply removing all  tags from the data elements in 
the XML;

• using ;

• using 

• using .

In 2.25, all of these throw the error “DataElementCategoryCombo Missing 
required property `categoryCombo`”…  How can I get these data elements to take 
on the local ‘default’ CategoryCombo as the XML is loaded?

Many thanks for any help anyone is able to give!

Regards, Sam.



From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Rodolfo Melia <rme...@knowming.com<mailto:rme...@knowming.com>>
Date: Monday, 9 May 2016 at 09:37
To: Lars Helge Øverland <l...@dhis2.org<mailto:l...@dhis2.org>>
Cc: Adebusoye Anifalaje <bus...@baosystems.com<mailto:bus...@baosystems.com>>, 
DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>, JM 
Alcantara <jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>
Subject: Re: [Dhis2-devs] Null pointer exception calling .../api/me/programs

Noted - we look forward to get a resolution to the setting of CatCombo to 
'default' in 2.22 soon - we import hundred of new data elements to our servers 
every week, and many of the templates out there have that column null. This was 
not a problem in 2.20.

R


On 9 May 2016 at 09:24, Lars Helge Øverland

Re: [Dhis2-devs] [Dhis2-users] 25 hours in completing Analytic

[Sam Johnson]

One other point to mention: if you do try runing VACUUM FULL, you should do it 
before running the analytics (ie on your initial 100Gb database, not the 500Gb 
database you end up with after running the analytics), as my guess is that the 
DHIS2 analytics tables are dropped and re-created anyway, so there wouldn’t be 
any point in VACUUMing them.

Cheers, Sam.


From: Dhis2-users 
<dhis2-users-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf 
of Sam Johnson <samuel.john...@qebo.co.uk>
Date: Wednesday, 19 October 2016 at 12:28
To: DHIS 2 Users list <dhis2-us...@lists.launchpad.net>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

Hi Neeraj,

Using VACUUM and ANALYZE

Like Brajesh, my background is MySQL, and one database admin task that is often 
overlooked in MySQL is OPTIMIZE TABLEs.  This reclaims unused space (we’ve had 
100Gb databases files drop to half their size) and refreshes index statistics 
(if the shape of your data has changed over time, this can make indices run 
faster).

I’m new to PostgreSQL, but the core principles are the same, and a quick bit of 
Googling shows that the equivalents in PostgreSQL are the VACUUM and ANALYZE 
commands.  If your database isn’t set to automatically do VACUUMs (the default 
DHIS2 postgres config doesn’t seem to be), you might want to try VACUUM FULL, 
which will literally rewrite all of your database tables and indices into 
smaller, more efficient files (note, however, that on a 500Gb database this 
could take a looong time – perhaps test on a backup first?).  The following 
forum post is a really nice, plain-English explanation of what VACUUM does:
http://dba.stackexchange.com/questions/126258/what-is-table-bloating-in-databases

As I mentioned, my background is MySQL rather than Postgres, so someone with 
more specific Postgres experience might like to also chime in here.

Cheers, Sam.


From: Dhis2-users 
<dhis2-users-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf 
of Brajesh Murari <brajesh.mur...@gmail.com>
Date: Wednesday, 19 October 2016 at 08:28
To: Knut Staring <knu...@gmail.com>
Cc: DHIS 2 Users list <dhis2-us...@lists.launchpad.net>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

Dear Neeraj,

The physical database size doesn't matter much, even the number of records 
don't matter. In my experience the biggest problem that one can going to run in 
to is not size, but the number of queries you can handle at a time instance 
specially during analytic functionality execution. Most probably you should 
going to have to move to a master/slave configuration of your database, so that 
the read queries can run against the slaves and the write queries run against 
the master. However, if you and your database management team are not ready for 
this than, you can tweak your indexes for the queries you are running to speed 
up the response times. Also there is a lot of tweaking you can do to the 
network stack and kernel in Linux where MySQL Server has been installed that 
will help.Perhaps, I would focus first on your indexes, then have a server 
admin look at your OS, and if all that doesn't help it might be time to 
implement a master/slave configuration. The most important scalability factor 
is RAM. If the indexes of your tables fit into memory and your queries are 
highly optimized in analytic functionality, you can serve a reasonable amount 
of requests with a average machine. The number of records do matter, depending 
of how your tables look like. It's a difference to have a lot of varchar fields 
or only a couple of ints or longs. The physical size of the database matters as 
well,  think of backups, for instance. Depending on your engine, your physical 
db files on grow, but don't shrink, for instance with innodb. So deleting a lot 
of rows, doesn't help to shrink your physical files. Thus the database size 
does matter. If you have more than one table with more than a million records, 
then performance starts indeed to degrade. Indexig is one of the important 
stand need to take care, If you hit one million records you will get 
performance problems, if the indices are not set right (for example no indices 
for fields in "WHERE statements" or "ON conditions" in joins). If you hit 10 
million records, you will start to get performance problems even if you have 
all your indices right. Hardware upgrades - adding more memory and more 
processor power, especially memory - often help to reduce the most severe 
problems by increasing the performance again, at least to a certain degree.

On Wed, Oct 19, 2016 at 12:35 PM, Knut Staring 
<knu...@gmail.com<mailto:knu...@gmail.com>> wrote:
Just a heads-up that there seems to be a JDBC issue with Postgres 9.6, so 
perhaps you should

Re: [Dhis2-devs] [Dhis2-users] 25 hours in completing Analytic

[Sam Johnson]

Hi Neeraj,

Using VACUUM and ANALYZE

Like Brajesh, my background is MySQL, and one database admin task that is often 
overlooked in MySQL is OPTIMIZE TABLEs.  This reclaims unused space (we’ve had 
100Gb databases files drop to half their size) and refreshes index statistics 
(if the shape of your data has changed over time, this can make indices run 
faster).

I’m new to PostgreSQL, but the core principles are the same, and a quick bit of 
Googling shows that the equivalents in PostgreSQL are the VACUUM and ANALYZE 
commands.  If your database isn’t set to automatically do VACUUMs (the default 
DHIS2 postgres config doesn’t seem to be), you might want to try VACUUM FULL, 
which will literally rewrite all of your database tables and indices into 
smaller, more efficient files (note, however, that on a 500Gb database this 
could take a looong time – perhaps test on a backup first?).  The following 
forum post is a really nice, plain-English explanation of what VACUUM does:
http://dba.stackexchange.com/questions/126258/what-is-table-bloating-in-databases

As I mentioned, my background is MySQL rather than Postgres, so someone with 
more specific Postgres experience might like to also chime in here.

Cheers, Sam.


From: Dhis2-users 
 on behalf 
of Brajesh Murari 
Date: Wednesday, 19 October 2016 at 08:28
To: Knut Staring 
Cc: DHIS 2 Users list , DHIS2 Developers 

Subject: Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

Dear Neeraj,

The physical database size doesn't matter much, even the number of records 
don't matter. In my experience the biggest problem that one can going to run in 
to is not size, but the number of queries you can handle at a time instance 
specially during analytic functionality execution. Most probably you should 
going to have to move to a master/slave configuration of your database, so that 
the read queries can run against the slaves and the write queries run against 
the master. However, if you and your database management team are not ready for 
this than, you can tweak your indexes for the queries you are running to speed 
up the response times. Also there is a lot of tweaking you can do to the 
network stack and kernel in Linux where MySQL Server has been installed that 
will help.Perhaps, I would focus first on your indexes, then have a server 
admin look at your OS, and if all that doesn't help it might be time to 
implement a master/slave configuration. The most important scalability factor 
is RAM. If the indexes of your tables fit into memory and your queries are 
highly optimized in analytic functionality, you can serve a reasonable amount 
of requests with a average machine. The number of records do matter, depending 
of how your tables look like. It's a difference to have a lot of varchar fields 
or only a couple of ints or longs. The physical size of the database matters as 
well,  think of backups, for instance. Depending on your engine, your physical 
db files on grow, but don't shrink, for instance with innodb. So deleting a lot 
of rows, doesn't help to shrink your physical files. Thus the database size 
does matter. If you have more than one table with more than a million records, 
then performance starts indeed to degrade. Indexig is one of the important 
stand need to take care, If you hit one million records you will get 
performance problems, if the indices are not set right (for example no indices 
for fields in "WHERE statements" or "ON conditions" in joins). If you hit 10 
million records, you will start to get performance problems even if you have 
all your indices right. Hardware upgrades - adding more memory and more 
processor power, especially memory - often help to reduce the most severe 
problems by increasing the performance again, at least to a certain degree.

On Wed, Oct 19, 2016 at 12:35 PM, Knut Staring 
> wrote:
Just a heads-up that there seems to be a JDBC issue with Postgres 9.6, so 
perhaps you should try upgrading to 9.5 first.

On Wed, Oct 19, 2016 at 8:58 AM, Lars Helge Øverland 
> wrote:

Hi Neeraj,

what usually helps to improve runtime is to improve/increase:

- ssd (read and write speed)
- number of CPUs
- using latest postgresql (9.6 claims to have even better indexing 
performance than 
9.5)
- 
tuning
 of postgresql


regards,

Lars



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://www.dhis2.org


___
Mailing list: 

[Dhis2-devs] [Bug 1625143] Re: The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are re

[Sam Johnson]

Hi Abyot,

On reflection, I think this might still be a bug after all.

If you can assign search org units to users, then why would the
authority 'Search tracked entity instances in all org units' even exist?
The very name of that authority seems to imply that it should override
any specific assignments, and allow users to search _all_ tracked entity
instances.

My guess, looking at how these features have been named, is that the 
functionality should ideally work as follows:
1. By default, users can only search in their Data Capture org units (just as, 
by default, they can only see analytics for their Data Capture org units);
2. This can be overridden by assigning wider/specific Search org units (in the 
same way that you can assign wider/specific Data Output org units).
3. For searching, both of these assignments can be overridden by giving the 
user a role with the 'Search tracked entity instances in all org units' 
authority, which (as the documentation states and the authority name implies) 
gives you the same Search permissions as the ALL authority, and removes the 
need for specifying Search org unit assignments on a user-by-user basis.

I'm thinking through our own (very typical) use case, which is that we
want all users to be able to share a common list of patients (tracked
entity instances) across a DHIS2 instance, while still only being able
to record events for their own org unit.  Having to individually assign
(and maintain) Search org units for each one of dozens/hundreds of users
would be a logistical nightmare, whereas if the feature works as
specified above (and as the documentation states), we can easily just
add this authority into the role we set up for the program.  :-)

I'd be very grateful for your feedback on this, and whether or not you
would be happy to still keep this open as a bug.

Many thanks, Sam.

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625143

Title:
  The role/authority ‘Search tracked entity in all Org Units’  is not
  working, and even with this authority, a search will return only
  tracked entity instances that are registered/enrolled within user's
  own assigned org units

Status in DHIS:
  New

Bug description:
  Hi all,

  The ‘search tracked entity instance in all Org Units’ authority
  doesn’t appear to be working in 2.24 – see section 26.2 of the 2.24
  User Guide for details of this authority.  (This feature has been
  documented for quite some time now, but I haven’t yet had a chance to
  check whether or not it’s working in earlier versions of DHIS2.)  Even
  after being given a role containing this authority, users do not
  appear to be able to search for tracked entity instances outside of
  their assigned ‘data capture’ Org Units.

  
  To reproduce this in the 2.24 stable demo:

  1. While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH /
  PNC (Adult Woman)’, and select the Njandama MCHP org unit.

  2. Type ‘Sarah’ in the search box – it should return a record for
  Sarah Thompson registered at Ngelehun CHC.

  3. Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) program’ 
to include the following authorities:
  - Add/update tracked entity data value
  - Add/update tracked entity instance
  - Delete tracked entity data value
  - Delete tracked entity instance
  - Search tracked entity instance
  - Search tracked entity instance in All Org Units
  - See browser cache cleaner module
  - See dashboard integration module
  - See Tracker Capture Module

  4. Create a new user with just this role, and give it only the
  Njandama MCHP Org Unit.

  5. Log out and back in again with this new user.

  6. Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it
  should be the only one showing), and select the ‘MNCH / PNC’ program.

  7. Type ‘Sarah’ in the search box – no records are returned; click to
  show ‘detailed search’, and only the Njandama Org Unit is showing
  (rather than the wider OU tree mentioned in the documentation),
  meaning this user is not able to search for tracked entity instances
  registered/enrolled at Ngelehun CHC.

  
  Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625143/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1625143] Re: The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are re

[Sam Johnson]

Hi Abyot,

Many thanks, I've just tested this, and it resolves the issue!  :-)

I hadn't realised this 'assign search org units' feature existed, and I
can't find a reference to it anywhere in the User Guide (which says you
only need the special authority) - would it be possible to get the
documentation updated?

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625143

Title:
  The role/authority ‘Search tracked entity in all Org Units’  is not
  working, and even with this authority, a search will return only
  tracked entity instances that are registered/enrolled within user's
  own assigned org units

Status in DHIS:
  New

Bug description:
  Hi all,

  The ‘search tracked entity instance in all Org Units’ authority
  doesn’t appear to be working in 2.24 – see section 26.2 of the 2.24
  User Guide for details of this authority.  (This feature has been
  documented for quite some time now, but I haven’t yet had a chance to
  check whether or not it’s working in earlier versions of DHIS2.)  Even
  after being given a role containing this authority, users do not
  appear to be able to search for tracked entity instances outside of
  their assigned ‘data capture’ Org Units.

  
  To reproduce this in the 2.24 stable demo:

  1. While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH /
  PNC (Adult Woman)’, and select the Njandama MCHP org unit.

  2. Type ‘Sarah’ in the search box – it should return a record for
  Sarah Thompson registered at Ngelehun CHC.

  3. Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) program’ 
to include the following authorities:
  - Add/update tracked entity data value
  - Add/update tracked entity instance
  - Delete tracked entity data value
  - Delete tracked entity instance
  - Search tracked entity instance
  - Search tracked entity instance in All Org Units
  - See browser cache cleaner module
  - See dashboard integration module
  - See Tracker Capture Module

  4. Create a new user with just this role, and give it only the
  Njandama MCHP Org Unit.

  5. Log out and back in again with this new user.

  6. Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it
  should be the only one showing), and select the ‘MNCH / PNC’ program.

  7. Type ‘Sarah’ in the search box – no records are returned; click to
  show ‘detailed search’, and only the Njandama Org Unit is showing
  (rather than the wider OU tree mentioned in the documentation),
  meaning this user is not able to search for tracked entity instances
  registered/enrolled at Ngelehun CHC.

  
  Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625143/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Event Capture 0.5.x - programs not showing up if they have program rules

[Sam Johnson]

Hi Araz,

That’s great news, many thanks – I look forward to testing it as soon as it’s 
released.  ☺

Cheers, Sam.


From: Araz Abishov <a...@dhis2.org>
Date: Tuesday, 18 October 2016 at 09:34
To: Sam Johnson <samuel.john...@qebo.co.uk>, Alex Tumwesigye 
<atumwesi...@gmail.com>, DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Event Capture 0.5.x - programs not showing up if they 
have program rules

Hi Sam,

My apologies for slow response.

We have already fixed compatibility issues with 2.25 and will release an update 
today. I will update you as soon as it will be available on GitHub.

Best regards,

—
Araz Abishov,
Android developer, DHIS 2
University of Oslo
https://www.dhis2.org/


On October 18, 2016 at 2:11:20 AM, Sam Johnson 
(samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>) wrote:
Hi Araz/Developers,

Just following up on my query below.  As per Alex’s recommendation, I’ve just 
had a play with Android Event Capture 0.5.5, and it looks great –  is there a 
timeline for fixing it (or any version, for that matter) to work with 2.25?

Regards, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Date: Friday, 14 October 2016 at 12:25
To: Alex Tumwesigye <atumwesi...@gmail.com<mailto:atumwesi...@gmail.com>>, 
"a...@dhis2.org<mailto:a...@dhis2.org>" 
<a...@dhis2.org<mailto:a...@dhis2.org>>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Subject: [Dhis2-devs] Event Capture 0.5.x - programs not showing up if they 
have program rules


This sender failed our fraud detection checks and may not be who they appear to 
be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing>

Feedback<http://aka.ms/SafetyTipsFeedback>

Hi Alex,

That’s great to hear, I’ll definitely check out 0.5.5, and many thanks also for 
the heads-up on that bug.

We do actually rely on program rules to maintain data integrity in this 
project, so that’s a killer for us.  But looking at Github, it sounds like the 
program rules have already been implemented in 0.5.5 – so if the problem is 
just a bug around the visibility of programs with rules, should that be fairly 
easy to fix?  (I do realise the reality may be a little more complex than it 
sounds!)

Devs/Araz, is this bug on your radar?

Many thanks, Sam.


From: Alex Tumwesigye <atumwesi...@gmail.com<mailto:atumwesi...@gmail.com>>
Date: Friday, 14 October 2016 at 06:43
To: Sam Johnson <samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Cc: "Laura E. Lincks" 
<laura.lin...@icap.columbia.edu<mailto:laura.lin...@icap.columbia.edu>>, Simon 
Muyambo <smmuya...@gmail.com<mailto:smmuya...@gmail.com>>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] Event Capture - option set not working

Dear Sam,

The 0.5.x are far better than the google play release. We have been trying them 
here in Uganda and they should considered as an option.

The known issue currently is that the app does not show up the program if the 
program has program rules unless that bug is fixed. But the 0.5.x version is 
worth trying.

Alex

On Friday, October 14, 2016, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

Is there a version of the Event Capture app that works with 2.25?  I’ve just 
tested the official Event Capture Android app (0.3.4-2.22) that’s on Google 
Play, and it looks like it still has the option set bug that Simon and Laura 
reported below.  Has anyone come across a workaround for this?

If not, given that the 0.5.x releases are still in alpha, would it be at all 
possible to get a fix for this bug backported to the official Google Play 
version of the Android app?  We’re planning to use it for field survey work, so 
need a very stable version.

Many thanks,

Sam

From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<_e(%7B%7D,'cvml','qebo.co...@lists.launchpad.net');>>
 on behalf of Erling Fjelstad 
<erl...@dhis2.org<_e(%7B%7D,'cvml','erl...@dhis2.org');>>
Date: Thursday, 1 September 2016 at 13:45
To: "Laura E. Lincks" 
<laura.lin...@icap.columbia.edu<_e(%7B%7D,'cvml','laura.lin...@icap.columbia.edu');>>
Cc: DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net<_e(%7B%7D,'cvml','dhis2-us...@lists.launchpad.net');>>,
 Simon Muyambo <smmuya...@gmail.com<_e(%7B%7D,'cvml','smmuya...@gmail.com');>>, 
DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<_e(%7B%7D,'cvml','dhis2-devs@lists.launchpad.net');>>
Subject: Re: [Dhis2-devs] Event 

Re: [Dhis2-devs] Event Capture 0.5.x - programs not showing up if they have program rules

[Sam Johnson]

Hi Araz/Developers,

Just following up on my query below.  As per Alex’s recommendation, I’ve just 
had a play with Android Event Capture 0.5.5, and it looks great –  is there a 
timeline for fixing it (or any version, for that matter) to work with 2.25?

Regards, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Friday, 14 October 2016 at 12:25
To: Alex Tumwesigye <atumwesi...@gmail.com>, "a...@dhis2.org" <a...@dhis2.org>, 
DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: [Dhis2-devs] Event Capture 0.5.x - programs not showing up if they 
have program rules


This sender failed our fraud detection checks and may not be who they appear to 
be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing>

Feedback<http://aka.ms/SafetyTipsFeedback>

Hi Alex,

That’s great to hear, I’ll definitely check out 0.5.5, and many thanks also for 
the heads-up on that bug.

We do actually rely on program rules to maintain data integrity in this 
project, so that’s a killer for us.  But looking at Github, it sounds like the 
program rules have already been implemented in 0.5.5 – so if the problem is 
just a bug around the visibility of programs with rules, should that be fairly 
easy to fix?  (I do realise the reality may be a little more complex than it 
sounds!)

Devs/Araz, is this bug on your radar?

Many thanks, Sam.


From: Alex Tumwesigye <atumwesi...@gmail.com>
Date: Friday, 14 October 2016 at 06:43
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: "Laura E. Lincks" <laura.lin...@icap.columbia.edu>, Simon Muyambo 
<smmuya...@gmail.com>, DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Event Capture - option set not working

Dear Sam,

The 0.5.x are far better than the google play release. We have been trying them 
here in Uganda and they should considered as an option.

The known issue currently is that the app does not show up the program if the 
program has program rules unless that bug is fixed. But the 0.5.x version is 
worth trying.

Alex

On Friday, October 14, 2016, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

Is there a version of the Event Capture app that works with 2.25?  I’ve just 
tested the official Event Capture Android app (0.3.4-2.22) that’s on Google 
Play, and it looks like it still has the option set bug that Simon and Laura 
reported below.  Has anyone come across a workaround for this?

If not, given that the 0.5.x releases are still in alpha, would it be at all 
possible to get a fix for this bug backported to the official Google Play 
version of the Android app?  We’re planning to use it for field survey work, so 
need a very stable version.

Many thanks,

Sam

From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','qebo.co...@lists.launchpad.net');>>
 on behalf of Erling Fjelstad 
<erl...@dhis2.org<javascript:_e(%7B%7D,'cvml','erl...@dhis2.org');>>
Date: Thursday, 1 September 2016 at 13:45
To: "Laura E. Lincks" 
<laura.lin...@icap.columbia.edu<javascript:_e(%7B%7D,'cvml','laura.lin...@icap.columbia.edu');>>
Cc: DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','dhis2-us...@lists.launchpad.net');>>,
 Simon Muyambo 
<smmuya...@gmail.com<javascript:_e(%7B%7D,'cvml','smmuya...@gmail.com');>>, 
DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','dhis2-devs@lists.launchpad.net');>>
Subject: Re: [Dhis2-devs] Event Capture - option set not working

Hello Simon & Laura,
You can try out the new Event Capture. Note that it is still in beta and 
doesn't have all the functionality as the old one yet. You can find it here: 
https://github.com/dhis2/dhis2-android-eventcapture/releases/download/0.5.1/event-capture-0.5.1.apk
Regards,
Erling - DHIS2 Android Team

On Mon, Aug 29, 2016 at 6:57 PM, Laura E. Lincks 
<laura.lin...@icap.columbia.edu<javascript:_e(%7B%7D,'cvml','laura.lin...@icap.columbia.edu');>>
 wrote:
Yes, we're experiencing the same problem.


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<tel:212%20304%207132>

On Mon, Aug 29, 2016 at 9:32 AM, Simon Muyambo 
<smmuya...@gmail.com<javascript:_e(%7B%7D,'cvml','smmuya...@gmail.com');>> 
wrote:
I am using the latest event capture from google play and Version:2.24 Build 
revision: 23585
Option Set on the event capture showing as text even on programs that used to 
work on 2.22.

Has anyone come across this?

Regards
Simon Muyambo


___
Mailing list: https://launchpad.net

[Dhis2-devs] XML import bug

[Sam Johnson]

Hi Devs,

The problem I reported yesterday has actually turned out to be what I think is 
a new bug in 2.25, which is stopping XML imports for data elements.

No matter what I do, any attempt at an XML import of data elements seems to 
throw the error “DataElementCategoryCombo Missing required property 
`categoryCombo`”, even if a valid CategoryCombo is supplied.  The same XML 
import works fine in 2.21.

To reproduce on play.dhis2.org:

· Using the import/export module, do an XML export of data elements 
only.

· Delete all data elements from the XML except DE_1148614 (which uses 
the default CategoryCombo), and change the user of that data element to .

· To circumvent a couple of other export/import bugs:
1. delete the three ‘<’ characters (which have been exported as plaintext 
instead of )
2. delete the  tags (I have no idea why these tags are failing)

· Import this XML file back into play.dhis2.org.

The import fails, and the import summary has the error message 
“DataElementCategoryCombo Missing required property `categoryCombo`” – despite 
the fact that the data element has the default categoryCombo id.

I’ve attached the XML I extracted from play.dhis2.org to speed up testing.  I’d 
be very grateful if you could look into this urgently, as I can’t currently do 
XML imports into my 2.25 instance.

Many thanks,

Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Monday, 17 October 2016 at 04:54
To: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Cc: Rodolfo Melia <rodolfo.me...@knowtechture.com>
Subject: [Dhis2-devs] FW: Null pointer exception calling .../api/me/programs

Hi all,

I’m trying to produce a generic EventCapture XML config that can be imported 
into any DHIS2 instance, which requires the data elements and program to use 
the default CategoryCombo of the target instance.

My understanding from the documentation (and the email thread below) is that if 
the CategoryCombo for a data element is null, then during metadata import the 
data element will automatically be assigned the local ‘default’ CategoryCombo; 
the problem is that I can’t figure out how to represent this ‘null’ 
CategoryCombo in the XML. I’ve tried:

· simply removing all  tags from the data elements in 
the XML;

· using ;

· using 

· using .

In 2.25, all of these throw the error “DataElementCategoryCombo Missing 
required property `categoryCombo`”…  How can I get these data elements to take 
on the local ‘default’ CategoryCombo as the XML is loaded?

Many thanks for any help anyone is able to give!

Regards, Sam.



From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Rodolfo Melia <rme...@knowming.com>
Date: Monday, 9 May 2016 at 09:37
To: Lars Helge Øverland <l...@dhis2.org>
Cc: Adebusoye Anifalaje <bus...@baosystems.com>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>, JM Alcantara <jmalcanta...@gmail.com>
Subject: Re: [Dhis2-devs] Null pointer exception calling .../api/me/programs

Noted - we look forward to get a resolution to the setting of CatCombo to 
'default' in 2.22 soon - we import hundred of new data elements to our servers 
every week, and many of the templates out there have that column null. This was 
not a problem in 2.20.

R


On 9 May 2016 at 09:24, Lars Helge Øverland 
<l...@dhis2.org<mailto:l...@dhis2.org>> wrote:


On Mon, May 9, 2016 at 10:23 AM, Rodolfo Melia 
<rme...@knowming.com<mailto:rme...@knowming.com>> wrote:
Hi - I just want to confirm that I'm getting my facts right.

The fix for ensuring that a imported DEs with CatCombo=null are set to default 
is only available in 2.23, latest build.


Any 2.23 build, but yes.

The only workaround available right now for 2.22, that avoids re-starting 
tomcat (which makes the necessary correction at start-up) is to make sure that 
when importing DEs, we set the CatCombo to default in the XML/ CSV.


Correct.


Lars

R

Rodolfo Meliá
Principal  |  rme...@knowming.com<mailto:rme...@knowming.com>
Skype: rod.melia  |  +44 777 576 4090  |  +1 708 872 
7636<tel:%2B1%20708%20872%207636>
www.knowming.com<http://www.knowming.com/>

On 9 May 2016 at 08:19, Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>> wrote:
And yes, we don't allow null in the categoryCombo field from 2.23 and upwards

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Mon, May 9, 2016 at 2:15 PM, Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>> wrote:

On Mon, May 9, 2016 at 1:47 PM, Lars Helge Øverland 
<l...@dhis2.org<mailto:l...@dhis2.org>> wrote:
Morten do you think you could comment?

Hi, these kinds of issues are fixed in our new importer (available in 2.23), 
f

[Dhis2-devs] FW: Null pointer exception calling .../api/me/programs

[Sam Johnson]

Hi all,

I’m trying to produce a generic EventCapture XML config that can be imported 
into any DHIS2 instance, which requires the data elements and program to use 
the default CategoryCombo of the target instance.

My understanding from the documentation (and the email thread below) is that if 
the CategoryCombo for a data element is null, then during metadata import the 
data element will automatically be assigned the local ‘default’ CategoryCombo; 
the problem is that I can’t figure out how to represent this ‘null’ 
CategoryCombo in the XML. I’ve tried:

· simply removing all  tags from the data elements in 
the XML;

· using ;

· using 

· using .

In 2.25, all of these throw the error “DataElementCategoryCombo Missing 
required property `categoryCombo`”…  How can I get these data elements to take 
on the local ‘default’ CategoryCombo as the XML is loaded?

Many thanks for any help anyone is able to give!

Regards, Sam.



From: Dhis2-devs 
 on behalf of 
Rodolfo Melia 
Date: Monday, 9 May 2016 at 09:37
To: Lars Helge Øverland 
Cc: Adebusoye Anifalaje , DHIS2 Developers 
, JM Alcantara 
Subject: Re: [Dhis2-devs] Null pointer exception calling .../api/me/programs

Noted - we look forward to get a resolution to the setting of CatCombo to 
'default' in 2.22 soon - we import hundred of new data elements to our servers 
every week, and many of the templates out there have that column null. This was 
not a problem in 2.20.

R


On 9 May 2016 at 09:24, Lars Helge Øverland 
> wrote:


On Mon, May 9, 2016 at 10:23 AM, Rodolfo Melia 
> wrote:
Hi - I just want to confirm that I'm getting my facts right.

The fix for ensuring that a imported DEs with CatCombo=null are set to default 
is only available in 2.23, latest build.


Any 2.23 build, but yes.

The only workaround available right now for 2.22, that avoids re-starting 
tomcat (which makes the necessary correction at start-up) is to make sure that 
when importing DEs, we set the CatCombo to default in the XML/ CSV.


Correct.


Lars

R

Rodolfo Meliá
Principal  |  rme...@knowming.com
Skype: rod.melia  |  +44 777 576 4090  |  +1 708 872 
7636
www.knowming.com

On 9 May 2016 at 08:19, Morten Olav Hansen 
> wrote:
And yes, we don't allow null in the categoryCombo field from 2.23 and upwards

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Mon, May 9, 2016 at 2:15 PM, Morten Olav Hansen 
> wrote:

On Mon, May 9, 2016 at 1:47 PM, Lars Helge Øverland 
> wrote:
Morten do you think you could comment?

Hi, these kinds of issues are fixed in our new importer (available in 2.23), 
for now I would include the default category combo. When you say Import, are 
you creating this payload yourself, or is it coming from another system?

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp




--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://www.dhis2.org


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Event Capture 0.5.x - programs not showing up if they have program rules

[Sam Johnson]

Hi Alex,

That’s great to hear, I’ll definitely check out 0.5.5, and many thanks also for 
the heads-up on that bug.

We do actually rely on program rules to maintain data integrity in this 
project, so that’s a killer for us.  But looking at Github, it sounds like the 
program rules have already been implemented in 0.5.5 – so if the problem is 
just a bug around the visibility of programs with rules, should that be fairly 
easy to fix?  (I do realise the reality may be a little more complex than it 
sounds!)

Devs/Araz, is this bug on your radar?

Many thanks, Sam.


From: Alex Tumwesigye <atumwesi...@gmail.com>
Date: Friday, 14 October 2016 at 06:43
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: "Laura E. Lincks" <laura.lin...@icap.columbia.edu>, Simon Muyambo 
<smmuya...@gmail.com>, DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Event Capture - option set not working

Dear Sam,

The 0.5.x are far better than the google play release. We have been trying them 
here in Uganda and they should considered as an option.

The known issue currently is that the app does not show up the program if the 
program has program rules unless that bug is fixed. But the 0.5.x version is 
worth trying.

Alex

On Friday, October 14, 2016, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

Is there a version of the Event Capture app that works with 2.25?  I’ve just 
tested the official Event Capture Android app (0.3.4-2.22) that’s on Google 
Play, and it looks like it still has the option set bug that Simon and Laura 
reported below.  Has anyone come across a workaround for this?

If not, given that the 0.5.x releases are still in alpha, would it be at all 
possible to get a fix for this bug backported to the official Google Play 
version of the Android app?  We’re planning to use it for field survey work, so 
need a very stable version.

Many thanks,

Sam

From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','qebo.co...@lists.launchpad.net');>>
 on behalf of Erling Fjelstad 
<erl...@dhis2.org<javascript:_e(%7B%7D,'cvml','erl...@dhis2.org');>>
Date: Thursday, 1 September 2016 at 13:45
To: "Laura E. Lincks" 
<laura.lin...@icap.columbia.edu<javascript:_e(%7B%7D,'cvml','laura.lin...@icap.columbia.edu');>>
Cc: DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','dhis2-us...@lists.launchpad.net');>>,
 Simon Muyambo 
<smmuya...@gmail.com<javascript:_e(%7B%7D,'cvml','smmuya...@gmail.com');>>, 
DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','dhis2-devs@lists.launchpad.net');>>
Subject: Re: [Dhis2-devs] Event Capture - option set not working

Hello Simon & Laura,
You can try out the new Event Capture. Note that it is still in beta and 
doesn't have all the functionality as the old one yet. You can find it here: 
https://github.com/dhis2/dhis2-android-eventcapture/releases/download/0.5.1/event-capture-0.5.1.apk
Regards,
Erling - DHIS2 Android Team

On Mon, Aug 29, 2016 at 6:57 PM, Laura E. Lincks 
<laura.lin...@icap.columbia.edu<javascript:_e(%7B%7D,'cvml','laura.lin...@icap.columbia.edu');>>
 wrote:
Yes, we're experiencing the same problem.


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<tel:212%20304%207132>

On Mon, Aug 29, 2016 at 9:32 AM, Simon Muyambo 
<smmuya...@gmail.com<javascript:_e(%7B%7D,'cvml','smmuya...@gmail.com');>> 
wrote:
I am using the latest event capture from google play and Version:2.24 Build 
revision: 23585
Option Set on the event capture showing as text even on programs that used to 
work on 2.22.

Has anyone come across this?

Regards
Simon Muyambo


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','dhis2-devs@lists.launchpad.net');>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<javascript:_e(%7B%7D,'cvml','dhis2-devs@lists.launchpad.net');>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



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

Re: [Dhis2-devs] Event Capture - option set not working

[Sam Johnson]

Hi all,

Is there a version of the Event Capture app that works with 2.25?  I’ve just 
tested the official Event Capture Android app (0.3.4-2.22) that’s on Google 
Play, and it looks like it still has the option set bug that Simon and Laura 
reported below.  Has anyone come across a workaround for this?

If not, given that the 0.5.x releases are still in alpha, would it be at all 
possible to get a fix for this bug backported to the official Google Play 
version of the Android app?  We’re planning to use it for field survey work, so 
need a very stable version.

Many thanks,

Sam

From: Dhis2-devs 
 on behalf of 
Erling Fjelstad 
Date: Thursday, 1 September 2016 at 13:45
To: "Laura E. Lincks" 
Cc: DHIS 2 Users list , Simon Muyambo 
, DHIS2 Developers 
Subject: Re: [Dhis2-devs] Event Capture - option set not working

Hello Simon & Laura,
You can try out the new Event Capture. Note that it is still in beta and 
doesn't have all the functionality as the old one yet. You can find it here: 
https://github.com/dhis2/dhis2-android-eventcapture/releases/download/0.5.1/event-capture-0.5.1.apk
Regards,
Erling - DHIS2 Android Team

On Mon, Aug 29, 2016 at 6:57 PM, Laura E. Lincks 
> wrote:
Yes, we're experiencing the same problem.


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

On Mon, Aug 29, 2016 at 9:32 AM, Simon Muyambo 
> wrote:
I am using the latest event capture from google play and Version:2.24 Build 
revision: 23585
Option Set on the event capture showing as text even on programs that used to 
work on 2.22.

Has anyone come across this?

Regards
Simon Muyambo


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Cannot create new program stage reminder template

[Sam Johnson]

Hi Knut (and Lars),

Knut, many thanks for your reply.  All of the tables with ‘message’ in the name 
seem to relate to the new in-instance messaging system (which has a nice, tight 
naming convention), but you prompted me to do another schema search, and it 
looks like the following table holds the program and programstage reminders 
I’ve been looking for:
trackedentityinstancereminder
(Despite the name, this table doesn’t seem to have anything to do with tracked 
entity instances.)

When I compare 2.21 with the 2.24 Play demo, the table schema for 
trackedentityinstancereminder appears to have changed in 2.24/2.25 – the column 
order has been moved around.  (Note that I’ve only been able to do this 
comparison with a DHIS2 ‘SQL view’, since I don’t have access to the database.)

Play demo 2.24 instance (using DHIS2 ‘SQL view’ to view the table):
Trackedentityinstancereminderid
name
Daysallowedsendmessage
Templatemessage
Programstageid
Datetocompare
Programid
Sendto
Whentosend
Usergroupid
Messagetype
Uid
Code
Created
lastupdated

2.21 instance (using DHIS2 ‘SQL view’ to view the table) and my 2.24 instance 
upgraded from 2.21:
trackedentityinstancereminderid
uid
code
created
lastupdated
name
daysallowedsendmessage
templatemessage
datetocompare
sendto
whentosend
messagetype
usergroupid
programstageid
programid

My 2.24 instance has been upgraded from 2.21 to 2.24, and seems to have the 
2.21 version of this table schema, rather than the 2.24/2.25 version – could 
this change in the order of the columns between DHIS2 versions be causing my 
bug?  (ie does the DHIS2 application include SQL statements that rely on column 
order, rather than explicitly naming columns?)

Many thanks,

Sam.


From: Knut Staring <knu...@gmail.com>
Date: Sunday, 9 October 2016 at 19:56
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

I don't think so, unfortunately. Perhaps the programmessage table?

On Sun, Oct 9, 2016 at 6:55 PM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

Still banging my head against the wall with this one.  Is there any schema 
documentation available for DHIS2?

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Date: Friday, 7 October 2016 at 15:11
To: DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>

Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi all,

Am still struggling with this missing UID bug on my own instance.  Does anyone 
know the name of the table into which these ProgramStage reminder templates are 
persisted?  (Is there any schema documentation available for DHIS2?)

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:qebo.co...@lists.launchpad.net>>
 on behalf of Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Date: Thursday, 6 October 2016 at 13:48
To: Lars Helge Øverland <l...@dhis2.org<mailto:l...@dhis2.org>>, Knut Staring 
<knu...@gmail.com<mailto:knu...@gmail.com>>
Cc: DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Knut and Lars,

Many thanks for such a prompt response.

Knut, thanks for the reminder about the upgrade notes; apologies, I should have 
been clearer: I did actually follow these upgrade instructions, noting the one 
SQL script (which I didn’t bother running, as at the time I hadn’t created any 
program rule variables, and was only using programs-with-registration anyway).  
But I was wondering if any further scripts were required for the updates that 
have been done to 2.24, since I started with a very early release of 2.24?

Lars, I’ve unfortunately developed a proof-of-concept which I need to 
demonstrate in the next day or two, and I’m guessing that 2.25 isn’t yet stable 
enough for a client-facing demo?  (I’d need to be sure that all aspects of a 
complex Tracker program would run smoothly!)

In the meantime, do you have any idea why I’m getting this UID error?  What 
seems to be missing from that failed row?

Cheers, Sam.


From: Lars Helge Øverland <l...@dhis2.org<mailto:l...@dhis2.org>>
Date: Thursday, 6 October 2016 at 12:47
To: Sam Johnson <samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Cc: DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Sam,

okay. You w

Re: [Dhis2-devs] Cannot create new program stage reminder template

[Sam Johnson]

Hi all,

Still banging my head against the wall with this one.  Is there any schema 
documentation available for DHIS2?

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Friday, 7 October 2016 at 15:11
To: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi all,

Am still struggling with this missing UID bug on my own instance.  Does anyone 
know the name of the table into which these ProgramStage reminder templates are 
persisted?  (Is there any schema documentation available for DHIS2?)

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Thursday, 6 October 2016 at 13:48
To: Lars Helge Øverland <l...@dhis2.org>, Knut Staring <knu...@gmail.com>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Knut and Lars,

Many thanks for such a prompt response.

Knut, thanks for the reminder about the upgrade notes; apologies, I should have 
been clearer: I did actually follow these upgrade instructions, noting the one 
SQL script (which I didn’t bother running, as at the time I hadn’t created any 
program rule variables, and was only using programs-with-registration anyway).  
But I was wondering if any further scripts were required for the updates that 
have been done to 2.24, since I started with a very early release of 2.24?

Lars, I’ve unfortunately developed a proof-of-concept which I need to 
demonstrate in the next day or two, and I’m guessing that 2.25 isn’t yet stable 
enough for a client-facing demo?  (I’d need to be sure that all aspects of a 
complex Tracker program would run smoothly!)

In the meantime, do you have any idea why I’m getting this UID error?  What 
seems to be missing from that failed row?

Cheers, Sam.


From: Lars Helge Øverland <l...@dhis2.org>
Date: Thursday, 6 October 2016 at 12:47
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Sam,

okay. You would probably like to know that for 2.25, the "reminder message 
template" functionality has been replaced by a new version referred to as 
"program notifications" and "program stage notifications". This is a better 
implementation of the notifications system and is mostly equivalent in terms of 
features.

https://www.dhis2.org/225-upgrade

Are you able to upgrade to 2.25 snapshot?

best regards,

Lars





On Thu, Oct 6, 2016 at 1:26 PM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

I’m using a 2.24 instance which I’ve just updated to 704143a, and am attempting 
to create reminder templates on a repeatable program stage.  I can successfully 
use the front end to create this reminder on one of the program stages on 
play.dhis2.org/demo<http://play.dhis2.org/demo>, but when I attempt it in my 
own instance, I get the ‘An exception occurred’ page, with the following log 
entries:
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "uid" 
violates not-null constraint
Detail: Failing row contains (1190, null, null, null, null, ANCReminder, -1, 
This is a reminder that you are due to come to the clinic for a ..., null, 1, 
2, 1, null, null, null).

Why would my instance not be populating this uid column?  (I’ve tested this 
same reminder on other program stages and on the program itself, and all 
attempts at saving return the same error.)

A couple of notes:

• My instance was originally installed as 2.21, and upgraded to 2.22, 
2.23 and then 2.24.

• My user has a role with ‘ALL’ and every other authority in it, and 
has all programs assigned to it.

• I’ve done all updates to 2.24 by simply replacing the .war file – 
were any database scripts required for any updates?

Many thanks for any help you can give, as I’m currently stuck and unable to 
create reminders!

Cheers, Sam.


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.dhis2.org/>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Cannot create new program stage reminder template

[Sam Johnson]

Hi all,

Am still struggling with this missing UID bug on my own instance.  Does anyone 
know the name of the table into which these ProgramStage reminder templates are 
persisted?  (Is there any schema documentation available for DHIS2?)

Cheers, Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Thursday, 6 October 2016 at 13:48
To: Lars Helge Øverland <l...@dhis2.org>, Knut Staring <knu...@gmail.com>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Knut and Lars,

Many thanks for such a prompt response.

Knut, thanks for the reminder about the upgrade notes; apologies, I should have 
been clearer: I did actually follow these upgrade instructions, noting the one 
SQL script (which I didn’t bother running, as at the time I hadn’t created any 
program rule variables, and was only using programs-with-registration anyway).  
But I was wondering if any further scripts were required for the updates that 
have been done to 2.24, since I started with a very early release of 2.24?

Lars, I’ve unfortunately developed a proof-of-concept which I need to 
demonstrate in the next day or two, and I’m guessing that 2.25 isn’t yet stable 
enough for a client-facing demo?  (I’d need to be sure that all aspects of a 
complex Tracker program would run smoothly!)

In the meantime, do you have any idea why I’m getting this UID error?  What 
seems to be missing from that failed row?

Cheers, Sam.


From: Lars Helge Øverland <l...@dhis2.org>
Date: Thursday, 6 October 2016 at 12:47
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Sam,

okay. You would probably like to know that for 2.25, the "reminder message 
template" functionality has been replaced by a new version referred to as 
"program notifications" and "program stage notifications". This is a better 
implementation of the notifications system and is mostly equivalent in terms of 
features.

https://www.dhis2.org/225-upgrade

Are you able to upgrade to 2.25 snapshot?

best regards,

Lars





On Thu, Oct 6, 2016 at 1:26 PM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

I’m using a 2.24 instance which I’ve just updated to 704143a, and am attempting 
to create reminder templates on a repeatable program stage.  I can successfully 
use the front end to create this reminder on one of the program stages on 
play.dhis2.org/demo<http://play.dhis2.org/demo>, but when I attempt it in my 
own instance, I get the ‘An exception occurred’ page, with the following log 
entries:
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "uid" 
violates not-null constraint
Detail: Failing row contains (1190, null, null, null, null, ANCReminder, -1, 
This is a reminder that you are due to come to the clinic for a ..., null, 1, 
2, 1, null, null, null).

Why would my instance not be populating this uid column?  (I’ve tested this 
same reminder on other program stages and on the program itself, and all 
attempts at saving return the same error.)

A couple of notes:

• My instance was originally installed as 2.21, and upgraded to 2.22, 
2.23 and then 2.24.

• My user has a role with ‘ALL’ and every other authority in it, and 
has all programs assigned to it.

• I’ve done all updates to 2.24 by simply replacing the .war file – 
were any database scripts required for any updates?

Many thanks for any help you can give, as I’m currently stuck and unable to 
create reminders!

Cheers, Sam.


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.dhis2.org/>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

[Sam Johnson]

Hi Markus,

Many thanks for looking into this, I know the code for these program indicators 
is complex!  Will this be fixed in a future release?  (I realise it’s probably 
not a high priority for 2.25 if there’s a known workaround.)

And many thanks for clarifying that I now need to specify a custom aggregation 
for V{event_count} – I’ll put that in now, so the eventual upgrade to 2.25 goes 
smoothly.  ☺

Cheers, Sam.


From: Markus Bekken <markus.bek...@gmail.com>
Date: Friday, 7 October 2016 at 08:44
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, Lars Helge Øverland 
<l...@dhis2.org>
Subject: Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in 
percentage calculations when using d2:condition (inconsistent results at 
different levels of aggregation)

Hi there Sam,
thank you for the detailed report.

The division is done with integers when both the inputs are integers. So the 
result of the divison is rounded down from f.ex. 0,66 to 0 before the 
multiplication with 100 happens. You found a workaround yourself, another 
option would be to do the multiplication before the division:
• sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) * 100 / 
V{event_count}

P.S. To get the given example to work on the latest 2.24 and 2.25 snapshot with 
custom aggregation it was also necessary to specify aggregation operator for 
the event count variable:
• sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) * 100 / 
count(V{event_count})

Best regards,
Markus

25. aug. 2016 kl. 15.13 skrev Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>:

Hi all,

Just following up on this bug report again – is there any chance I could get it 
looked at/prioritized?

I’ve dug a little deeper, and it looks like this bug could be as simple as an 
error in variable handling.

Specifically, although in the example I originally gave, the following DOESN’T 
work:
• sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) / 
V{event_count} * 100
the following DOES seem to work:
• sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',100,0)) / 
V{event_count}

Is it possible that when the aggregation step of the indicator calculation is 
undertaken, any decimal results are at some point forced to an integer, 
generating incorrect values wherever the result is <1?

Cheers,

Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net>>
 on behalf of Samuel Scott 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Date: Tuesday, 23 August 2016 at 15:08
To: DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>, Lars 
Helge Øverland <l...@dhis2.org<mailto:l...@dhis2.org>>
Subject: Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in 
percentage calculations when using d2:condition (inconsistent results at 
different levels of aggregation)

Hi all,

I reported a bug in the web program indicator calculations a couple of weeks 
ago, and included in the report everything that’s needed to quickly replicate 
the bug, but I don’t think anyone has had a chance to look at this report yet.

Have I followed the correct process for reporting this?  Is it at all possible 
to get an idea of when a fix for this might be available?  (It’s quite a 
serious bug, as ‘valid’ expressions are returning incorrect/inconsistent 
results at different levels of aggregation.)

Many thanks,

Sam.


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net<mailto:dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net>>
 on behalf of Samuel Scott 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>>
Reply-To: Bug 1612375 
<1612...@bugs.launchpad.net<mailto:1612...@bugs.launchpad.net>>
Date: Thursday, 11 August 2016 at 19:21
To: DHIS2 Developers 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Subject: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in 
percentage calculations when using d2:condition (inconsistent results at 
different levels of aggregation)

Public bug reported:

Bug found in 2.22, still present in 2.24 online demo (2.24 rev.23557)
Online demo accessed using Chrome 52.0.2743.116.

There appears to be a bug in the program indicator calculations when:
a sum() custom aggregation is used twice, to enable the calculation of a 
percentage AND
an element of the percentage calculation includes d2:condition.

Note that either of these situations works properly on its own - ie the
numerator and denominator work perfectly when separated into two
different indicators - it is only when combined that the bug occurs.

TO REPRODUCE THIS BUG

In the online demo instanc

Re: [Dhis2-devs] Cannot create new program stage reminder template

[Sam Johnson]

Hi Knut and Lars,

Many thanks for such a prompt response.

Knut, thanks for the reminder about the upgrade notes; apologies, I should have 
been clearer: I did actually follow these upgrade instructions, noting the one 
SQL script (which I didn’t bother running, as at the time I hadn’t created any 
program rule variables, and was only using programs-with-registration anyway).  
But I was wondering if any further scripts were required for the updates that 
have been done to 2.24, since I started with a very early release of 2.24?

Lars, I’ve unfortunately developed a proof-of-concept which I need to 
demonstrate in the next day or two, and I’m guessing that 2.25 isn’t yet stable 
enough for a client-facing demo?  (I’d need to be sure that all aspects of a 
complex Tracker program would run smoothly!)

In the meantime, do you have any idea why I’m getting this UID error?  What 
seems to be missing from that failed row?

Cheers, Sam.


From: Lars Helge Øverland <l...@dhis2.org>
Date: Thursday, 6 October 2016 at 12:47
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Sam,

okay. You would probably like to know that for 2.25, the "reminder message 
template" functionality has been replaced by a new version referred to as 
"program notifications" and "program stage notifications". This is a better 
implementation of the notifications system and is mostly equivalent in terms of 
features.

https://www.dhis2.org/225-upgrade

Are you able to upgrade to 2.25 snapshot?

best regards,

Lars





On Thu, Oct 6, 2016 at 1:26 PM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

I’m using a 2.24 instance which I’ve just updated to 704143a, and am attempting 
to create reminder templates on a repeatable program stage.  I can successfully 
use the front end to create this reminder on one of the program stages on 
play.dhis2.org/demo<http://play.dhis2.org/demo>, but when I attempt it in my 
own instance, I get the ‘An exception occurred’ page, with the following log 
entries:
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "uid" 
violates not-null constraint
Detail: Failing row contains (1190, null, null, null, null, ANCReminder, -1, 
This is a reminder that you are due to come to the clinic for a ..., null, 1, 
2, 1, null, null, null).

Why would my instance not be populating this uid column?  (I’ve tested this 
same reminder on other program stages and on the program itself, and all 
attempts at saving return the same error.)

A couple of notes:

• My instance was originally installed as 2.21, and upgraded to 2.22, 
2.23 and then 2.24.

• My user has a role with ‘ALL’ and every other authority in it, and 
has all programs assigned to it.

• I’ve done all updates to 2.24 by simply replacing the .war file – 
were any database scripts required for any updates?

Many thanks for any help you can give, as I’m currently stuck and unable to 
create reminders!

Cheers, Sam.


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.dhis2.org/>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Cannot create new program stage reminder template

[Sam Johnson]

Hi all,

I’m using a 2.24 instance which I’ve just updated to 704143a, and am attempting 
to create reminder templates on a repeatable program stage.  I can successfully 
use the front end to create this reminder on one of the program stages on 
play.dhis2.org/demo, but when I attempt it in my own instance, I get the ‘An 
exception occurred’ page, with the following log entries:
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "uid" 
violates not-null constraint
Detail: Failing row contains (1190, null, null, null, null, ANCReminder, -1, 
This is a reminder that you are due to come to the clinic for a ..., null, 1, 
2, 1, null, null, null).

Why would my instance not be populating this uid column?  (I’ve tested this 
same reminder on other program stages and on the program itself, and all 
attempts at saving return the same error.)

A couple of notes:

· My instance was originally installed as 2.21, and upgraded to 2.22, 
2.23 and then 2.24.

· My user has a role with ‘ALL’ and every other authority in it, and 
has all programs assigned to it.

· I’ve done all updates to 2.24 by simply replacing the .war file – 
were any database scripts required for any updates?

Many thanks for any help you can give, as I’m currently stuck and unable to 
create reminders!

Cheers, Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1625143] [NEW] The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are

[Sam Johnson]

Public bug reported:

Hi all,

The ‘search tracked entity instance in all Org Units’ authority doesn’t
appear to be working in 2.24 – see section 26.2 of the 2.24 User Guide
for details of this authority.  (This feature has been documented for
quite some time now, but I haven’t yet had a chance to check whether or
not it’s working in earlier versions of DHIS2.)  Even after being given
a role containing this authority, users do not appear to be able to
search for tracked entity instances outside of their assigned ‘data
capture’ Org Units.


To reproduce this in the 2.24 stable demo:

1. While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH /
PNC (Adult Woman)’, and select the Njandama MCHP org unit.

2. Type ‘Sarah’ in the search box – it should return a record for Sarah
Thompson registered at Ngelehun CHC.

3. Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) program’ 
to include the following authorities:
- Add/update tracked entity data value
- Add/update tracked entity instance
- Delete tracked entity data value
- Delete tracked entity instance
- Search tracked entity instance
- Search tracked entity instance in All Org Units
- See browser cache cleaner module
- See dashboard integration module
- See Tracker Capture Module

4. Create a new user with just this role, and give it only the Njandama
MCHP Org Unit.

5. Log out and back in again with this new user.

6. Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it should
be the only one showing), and select the ‘MNCH / PNC’ program.

7. Type ‘Sarah’ in the search box – no records are returned; click to
show ‘detailed search’, and only the Njandama Org Unit is showing
(rather than the wider OU tree mentioned in the documentation), meaning
this user is not able to search for tracked entity instances
registered/enrolled at Ngelehun CHC.


Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

** Affects: dhis2
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625143

Title:
  The role/authority ‘Search tracked entity in all Org Units’  is not
  working, and even with this authority, a search will return only
  tracked entity instances that are registered/enrolled within user's
  own assigned org units

Status in DHIS:
  New

Bug description:
  Hi all,

  The ‘search tracked entity instance in all Org Units’ authority
  doesn’t appear to be working in 2.24 – see section 26.2 of the 2.24
  User Guide for details of this authority.  (This feature has been
  documented for quite some time now, but I haven’t yet had a chance to
  check whether or not it’s working in earlier versions of DHIS2.)  Even
  after being given a role containing this authority, users do not
  appear to be able to search for tracked entity instances outside of
  their assigned ‘data capture’ Org Units.

  
  To reproduce this in the 2.24 stable demo:

  1. While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH /
  PNC (Adult Woman)’, and select the Njandama MCHP org unit.

  2. Type ‘Sarah’ in the search box – it should return a record for
  Sarah Thompson registered at Ngelehun CHC.

  3. Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) program’ 
to include the following authorities:
  - Add/update tracked entity data value
  - Add/update tracked entity instance
  - Delete tracked entity data value
  - Delete tracked entity instance
  - Search tracked entity instance
  - Search tracked entity instance in All Org Units
  - See browser cache cleaner module
  - See dashboard integration module
  - See Tracker Capture Module

  4. Create a new user with just this role, and give it only the
  Njandama MCHP Org Unit.

  5. Log out and back in again with this new user.

  6. Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it
  should be the only one showing), and select the ‘MNCH / PNC’ program.

  7. Type ‘Sarah’ in the search box – no records are returned; click to
  show ‘detailed search’, and only the Njandama Org Unit is showing
  (rather than the wider OU tree mentioned in the documentation),
  meaning this user is not able to search for tracked entity instances
  registered/enrolled at Ngelehun CHC.

  
  Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625143/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] 'Search tracked entity instance in all Org Units' authority not working?

[Sam Johnson]

Hi Abyot,

Should I report this as a bug on Launchpad?

Cheers, Sam.


From: Abyot Asalefew Gizaw <ab...@dhis2.org>
Date: Monday, 19 September 2016 at 10:18
To: Brajesh Murari <brajesh.mur...@gmail.com>
Cc: Sam Johnson <samuel.john...@qebo.co.uk>, DHIS2 Developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] 'Search tracked entity instance in all Org Units' 
authority not working?

Hi,

Thank you for reporting.

We will take a look to this very soon and do a fix if necessary.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org


From: Dhis2-devs 
<dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of 
Sam Johnson <samuel.john...@qebo.co.uk>
Date: Monday, 19 September 2016 at 12:31
To: Brajesh Murari <brajesh.mur...@gmail.com>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] 'Search tracked entity instance in all Org Units' 
authority not working?

Hi Brajesh,

A short summary might be:

The role/authority ‘Search tracked entity in all Org Units’ should enable a 
user to do a search that includes tracked entity instances outside of their own 
assigned org units; however, this is not working, and even with this authority, 
a search will return only tracked entity instances that are registered/enrolled 
within their own assigned org units.

Cheers, Sam.

On Mon, Sep 19, 2016 at 11:10 AM, Brajesh Murari 
<brajesh.mur...@gmail.com<mailto:brajesh.mur...@gmail.com>> wrote:
Dear Sam,

I am getting exactly what your are talking about in your email, could you 
provide your elaboration on your issue in just 2 to 4 line ?

On Mon, Sep 19, 2016 at 5:37 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

The ‘search tracked entity instance in all Org Units’ authority doesn’t appear 
to be working in 2.24 – see section 26.2 of the 2.24 User Guide for details of 
this authority.  (This feature has been documented for quite some time now, but 
I haven’t yet had a chance to check whether or not it’s working in earlier 
versions of DHIS2.)  Even after being given a role containing this authority, 
users do not appear to be able to search for tracked entity instances outside 
of their assigned ‘data capture’ Org Units.

To reproduce this in the 2.24 stable demo:

1.   While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH / 
PNC (Adult Woman)’, and select the Njandama MCHP org unit.

2.   Type ‘Sarah’ in the search box – it should return a record for Sarah 
Thompson registered at Ngelehun CHC.

3.   Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) 
program’ to include the following authorities:
- Add/update tracked entity data value
- Add/update tracked entity instance
- Delete tracked entity data value
- Delete tracked entity instance
- Search tracked entity instance
- Search tracked entity instance in All Org Units
- See browser cache cleaner module
- See dashboard integration module
- See Tracker Capture Module

4.   Create a new user with just this role, and give it only the Njandama 
MCHP Org Unit.

5.   Log out and back in again with this new user.

6.   Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it should 
be the only one showing), and select the ‘MNCH / PNC’ program.

7.   Type ‘Sarah’ in the search box – no records are returned; click to 
show ‘detailed search’, and only the Njandama Org Unit is showing (rather than 
the wider OU tree mentioned in the documentation), meaning this user is not 
able to search for tracked entity instances registered/enrolled at Ngelehun CHC.

Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

I’d be very grateful if anyone can see anything that’s missing in what I’ve 
configured above, or is alternatively able to confirm this as a known bug.

Many thanks,

Sam.


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Thanks and Regards

Brajesh Murari
| Senior Technical Annalist | www.sdrc.co.in<http://www.sdrc.co.in> | 
Ph.:(+91)-9430124938<tel:%28%2B91%29-9430124938> |

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] 'Search tracked entity instance in all Org Units' authority not working?

[Sam Johnson]

Hi Brajesh,

A short summary might be:

The role/authority ‘Search tracked entity in all Org Units’ should enable a 
user to do a search that includes tracked entity instances outside of their own 
assigned org units; however, this is not working, and even with this authority, 
a search will return only tracked entity instances that are registered/enrolled 
within their own assigned org units.

Cheers, Sam.

From: Brajesh Murari <brajesh.mur...@gmail.com>
Date: Monday, 19 September 2016 at 10:10
To: Sam Johnson <samuel.john...@qebo.co.uk>
Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] 'Search tracked entity instance in all Org Units' 
authority not working?

Dear Sam,

I am getting exactly what your are talking about in your email, could you 
provide your elaboration on your issue in just 2 to 4 line ?

On Mon, Sep 19, 2016 at 5:37 AM, Sam Johnson 
<samuel.john...@qebo.co.uk<mailto:samuel.john...@qebo.co.uk>> wrote:
Hi all,

The ‘search tracked entity instance in all Org Units’ authority doesn’t appear 
to be working in 2.24 – see section 26.2 of the 2.24 User Guide for details of 
this authority.  (This feature has been documented for quite some time now, but 
I haven’t yet had a chance to check whether or not it’s working in earlier 
versions of DHIS2.)  Even after being given a role containing this authority, 
users do not appear to be able to search for tracked entity instances outside 
of their assigned ‘data capture’ Org Units.

To reproduce this in the 2.24 stable demo:

1.   While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH / 
PNC (Adult Woman)’, and select the Njandama MCHP org unit.

2.   Type ‘Sarah’ in the search box – it should return a record for Sarah 
Thompson registered at Ngelehun CHC.

3.   Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) 
program’ to include the following authorities:
- Add/update tracked entity data value
- Add/update tracked entity instance
- Delete tracked entity data value
- Delete tracked entity instance
- Search tracked entity instance
- Search tracked entity instance in All Org Units
- See browser cache cleaner module
- See dashboard integration module
- See Tracker Capture Module

4.   Create a new user with just this role, and give it only the Njandama 
MCHP Org Unit.

5.   Log out and back in again with this new user.

6.   Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it should 
be the only one showing), and select the ‘MNCH / PNC’ program.

7.   Type ‘Sarah’ in the search box – no records are returned; click to 
show ‘detailed search’, and only the Njandama Org Unit is showing (rather than 
the wider OU tree mentioned in the documentation), meaning this user is not 
able to search for tracked entity instances registered/enrolled at Ngelehun CHC.

Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

I’d be very grateful if anyone can see anything that’s missing in what I’ve 
configured above, or is alternatively able to confirm this as a known bug.

Many thanks,

Sam.


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Thanks and Regards

Brajesh Murari
| Senior Technical Annalist | www.sdrc.co.in<http://www.sdrc.co.in> | 
Ph.:(+91)-9430124938 |
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] 'Search tracked entity instance in all Org Units' authority not working?

[Sam Johnson]

Hi all,

The ‘search tracked entity instance in all Org Units’ authority doesn’t appear 
to be working in 2.24 – see section 26.2 of the 2.24 User Guide for details of 
this authority.  (This feature has been documented for quite some time now, but 
I haven’t yet had a chance to check whether or not it’s working in earlier 
versions of DHIS2.)  Even after being given a role containing this authority, 
users do not appear to be able to search for tracked entity instances outside 
of their assigned ‘data capture’ Org Units.

To reproduce this in the 2.24 stable demo:

1.   While logged in as ‘Admin’, go to ‘Tracker Capture’, select ‘MNCH / 
PNC (Adult Woman)’, and select the Njandama MCHP org unit.

2.   Type ‘Sarah’ in the search box – it should return a record for Sarah 
Thompson registered at Ngelehun CHC.

3.   Go to the User app, and update the role ‘MNCH / PNC (Adult Woman) 
program’ to include the following authorities:
- Add/update tracked entity data value
- Add/update tracked entity instance
- Delete tracked entity data value
- Delete tracked entity instance
- Search tracked entity instance
- Search tracked entity instance in All Org Units
- See browser cache cleaner module
- See dashboard integration module
- See Tracker Capture Module

4.   Create a new user with just this role, and give it only the Njandama 
MCHP Org Unit.

5.   Log out and back in again with this new user.

6.   Go to ‘Tracker Capture’, select the Njandama MCHP Org Unit (it should 
be the only one showing), and select the ‘MNCH / PNC’ program.

7.   Type ‘Sarah’ in the search box – no records are returned; click to 
show ‘detailed search’, and only the Njandama Org Unit is showing (rather than 
the wider OU tree mentioned in the documentation), meaning this user is not 
able to search for tracked entity instances registered/enrolled at Ngelehun CHC.

Tested on DHIS2 2.24 stable demo (revision fff20a3); Chrome version 
53.0.2785.116 (64-bit); Mac OSX 10.11.6 (15G1004)

I’d be very grateful if anyone can see anything that’s missing in what I’ve 
configured above, or is alternatively able to confirm this as a known bug.

Many thanks,

Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

[Sam Johnson]

Hi all,

Just following up on this bug report again – is there any chance I could get it 
looked at/prioritized?

I’ve dug a little deeper, and it looks like this bug could be as simple as an 
error in variable handling.

Specifically, although in the example I originally gave, the following DOESN’T 
work:

· sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) / 
V{event_count} * 100
the following DOES seem to work:

· sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',100,0)) / 
V{event_count}

Is it possible that when the aggregation step of the indicator calculation is 
undertaken, any decimal results are at some point forced to an integer, 
generating incorrect values wherever the result is <1?

Cheers,

Sam.


From: Dhis2-devs 
 on behalf of 
Samuel Scott 
Date: Tuesday, 23 August 2016 at 15:08
To: DHIS2 Developers , Lars Helge Øverland 

Subject: Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in 
percentage calculations when using d2:condition (inconsistent results at 
different levels of aggregation)

Hi all,

I reported a bug in the web program indicator calculations a couple of weeks 
ago, and included in the report everything that’s needed to quickly replicate 
the bug, but I don’t think anyone has had a chance to look at this report yet.

Have I followed the correct process for reporting this?  Is it at all possible 
to get an idea of when a fix for this might be available?  (It’s quite a 
serious bug, as ‘valid’ expressions are returning incorrect/inconsistent 
results at different levels of aggregation.)

Many thanks,

Sam.


From: Dhis2-devs 
 on behalf of 
Samuel Scott 
Reply-To: Bug 1612375 <1612...@bugs.launchpad.net>
Date: Thursday, 11 August 2016 at 19:21
To: DHIS2 Developers 
Subject: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in 
percentage calculations when using d2:condition (inconsistent results at 
different levels of aggregation)

Public bug reported:

Bug found in 2.22, still present in 2.24 online demo (2.24 rev.23557)
Online demo accessed using Chrome 52.0.2743.116.

There appears to be a bug in the program indicator calculations when:
a sum() custom aggregation is used twice, to enable the calculation of a 
percentage AND
an element of the percentage calculation includes d2:condition.

Note that either of these situations works properly on its own - ie the
numerator and denominator work perfectly when separated into two
different indicators - it is only when combined that the bug occurs.

TO REPRODUCE THIS BUG

In the online demo instance, using the Antenatal Care Visit program:

1. Create a program indicator called TestNumerator, with aggregation type 
'custom' and expression:
sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0))

2. Create a program indicator called TestDenominator, with aggregation type 
'custom' and expression:
V{event_count}

3. Create a program indicator called TestPercentage, with aggregation type 
'custom' and expression, which combines these two expressions as a percentage:
sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) / V{event_count} * 100

4. Create a pivot table based on the Antenatal program, add all three 
indicators to the pivot, and run it:
Numerator and denominator calculate correctly, but percentage returns 2/3 = 0 
(instead of 66.7)

5. Now change the Period from Last 12 months to Last 52 weeks, and re-run:
All indicators now calculate correctly, with percentage correctly showing 0/1 = 
0 and 2/2 = 100.


Note that this is not a bug in the event_count variable, as the same bug 
consistently appears even when V{event_count} is replaced by sum(1) in the 
indicator expressions.

I have a project whose viability depends on being able to correctly
calculate these percentages at higher levels of aggregation (regions
etc), so if confirmed as a bug, I would be hugely grateful if it were
possible to fix this in the current release, rather than in 2.25.

Many thanks, Sam.

** Affects: dhis2
 Importance: Undecided
 Status: New

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1612375

Title:
  Program indicators: error in percentage calculations when using
  d2:condition (inconsistent results at different levels of aggregation)

Status in DHIS:
  New

Bug description:
  Bug found in 2.22, still present in 2.24 online demo (2.24 rev.23557)
  Online demo accessed using Chrome 52.0.2743.116.

  There appears to be a bug in the program indicator calculations when:
  a sum() custom aggregation is used twice, to enable the calculation of a 
percentage AND
  an element of the percentage calculation includes d2:condition.

  

Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

[Sam Johnson]

Hi all,

I reported a bug in the web program indicator calculations a couple of weeks 
ago, and included in the report everything that’s needed to quickly replicate 
the bug, but I don’t think anyone has had a chance to look at this report yet.

Have I followed the correct process for reporting this?  Is it at all possible 
to get an idea of when a fix for this might be available?  (It’s quite a 
serious bug, as ‘valid’ expressions are returning incorrect/inconsistent 
results at different levels of aggregation.)

Many thanks,

Sam.


From: Dhis2-devs 
 on behalf of 
Samuel Scott 
Reply-To: Bug 1612375 <1612...@bugs.launchpad.net>
Date: Thursday, 11 August 2016 at 19:21
To: DHIS2 Developers 
Subject: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in 
percentage calculations when using d2:condition (inconsistent results at 
different levels of aggregation)

Public bug reported:

Bug found in 2.22, still present in 2.24 online demo (2.24 rev.23557)
Online demo accessed using Chrome 52.0.2743.116.

There appears to be a bug in the program indicator calculations when:
a sum() custom aggregation is used twice, to enable the calculation of a 
percentage AND
an element of the percentage calculation includes d2:condition.

Note that either of these situations works properly on its own - ie the
numerator and denominator work perfectly when separated into two
different indicators - it is only when combined that the bug occurs.

TO REPRODUCE THIS BUG

In the online demo instance, using the Antenatal Care Visit program:

1. Create a program indicator called TestNumerator, with aggregation type 
'custom' and expression:
sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0))

2. Create a program indicator called TestDenominator, with aggregation type 
'custom' and expression:
V{event_count}

3. Create a program indicator called TestPercentage, with aggregation type 
'custom' and expression, which combines these two expressions as a percentage:
sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) / V{event_count} * 100

4. Create a pivot table based on the Antenatal program, add all three 
indicators to the pivot, and run it:
Numerator and denominator calculate correctly, but percentage returns 2/3 = 0 
(instead of 66.7)

5. Now change the Period from Last 12 months to Last 52 weeks, and re-run:
All indicators now calculate correctly, with percentage correctly showing 0/1 = 
0 and 2/2 = 100.


Note that this is not a bug in the event_count variable, as the same bug 
consistently appears even when V{event_count} is replaced by sum(1) in the 
indicator expressions.

I have a project whose viability depends on being able to correctly
calculate these percentages at higher levels of aggregation (regions
etc), so if confirmed as a bug, I would be hugely grateful if it were
possible to fix this in the current release, rather than in 2.25.

Many thanks, Sam.

** Affects: dhis2
 Importance: Undecided
 Status: New

--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1612375

Title:
  Program indicators: error in percentage calculations when using
  d2:condition (inconsistent results at different levels of aggregation)

Status in DHIS:
  New

Bug description:
  Bug found in 2.22, still present in 2.24 online demo (2.24 rev.23557)
  Online demo accessed using Chrome 52.0.2743.116.

  There appears to be a bug in the program indicator calculations when:
  a sum() custom aggregation is used twice, to enable the calculation of a 
percentage AND
  an element of the percentage calculation includes d2:condition.

  Note that either of these situations works properly on its own - ie
  the numerator and denominator work perfectly when separated into two
  different indicators - it is only when combined that the bug occurs.

  TO REPRODUCE THIS BUG

  In the online demo instance, using the Antenatal Care Visit program:

  1. Create a program indicator called TestNumerator, with aggregation type 
'custom' and expression:
  sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0))

  2. Create a program indicator called TestDenominator, with aggregation type 
'custom' and expression:
  V{event_count}

  3. Create a program indicator called TestPercentage, with aggregation type 
'custom' and expression, which combines these two expressions as a percentage:
  sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) / V{event_count} * 100

  4. Create a pivot table based on the Antenatal program, add all three 
indicators to the pivot, and run it:
  Numerator and denominator calculate correctly, but percentage returns 2/3 = 0 
(instead of 66.7)

  5. Now change the Period from Last 12 months to Last 52 weeks, and re-run:
  All indicators now calculate correctly, with percentage correctly showing 0/1 
= 0 

[Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

[Sam Johnson]

Public bug reported:

Bug found in 2.22, still present in 2.24 online demo (2.24 rev.23557)
Online demo accessed using Chrome 52.0.2743.116.

There appears to be a bug in the program indicator calculations when:
a sum() custom aggregation is used twice, to enable the calculation of a 
percentage AND
an element of the percentage calculation includes d2:condition.

Note that either of these situations works properly on its own - ie the
numerator and denominator work perfectly when separated into two
different indicators - it is only when combined that the bug occurs.

TO REPRODUCE THIS BUG

In the online demo instance, using the Antenatal Care Visit program:

1. Create a program indicator called TestNumerator, with aggregation type 
'custom' and expression:
sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0))

2. Create a program indicator called TestDenominator, with aggregation type 
'custom' and expression:
V{event_count}

3. Create a program indicator called TestPercentage, with aggregation type 
'custom' and expression, which combines these two expressions as a percentage:
sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) / V{event_count} * 100

4. Create a pivot table based on the Antenatal program, add all three 
indicators to the pivot, and run it:
Numerator and denominator calculate correctly, but percentage returns 2/3 = 0 
(instead of 66.7)

5. Now change the Period from Last 12 months to Last 52 weeks, and re-run:
All indicators now calculate correctly, with percentage correctly showing 0/1 = 
0 and 2/2 = 100.


Note that this is not a bug in the event_count variable, as the same bug 
consistently appears even when V{event_count} is replaced by sum(1) in the 
indicator expressions.

I have a project whose viability depends on being able to correctly
calculate these percentages at higher levels of aggregation (regions
etc), so if confirmed as a bug, I would be hugely grateful if it were
possible to fix this in the current release, rather than in 2.25.

Many thanks, Sam.

** Affects: dhis2
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1612375

Title:
  Program indicators: error in percentage calculations when using
  d2:condition (inconsistent results at different levels of aggregation)

Status in DHIS:
  New

Bug description:
  Bug found in 2.22, still present in 2.24 online demo (2.24 rev.23557)
  Online demo accessed using Chrome 52.0.2743.116.

  There appears to be a bug in the program indicator calculations when:
  a sum() custom aggregation is used twice, to enable the calculation of a 
percentage AND
  an element of the percentage calculation includes d2:condition.

  Note that either of these situations works properly on its own - ie
  the numerator and denominator work perfectly when separated into two
  different indicators - it is only when combined that the bug occurs.

  TO REPRODUCE THIS BUG

  In the online demo instance, using the Antenatal Care Visit program:

  1. Create a program indicator called TestNumerator, with aggregation type 
'custom' and expression:
  sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0))

  2. Create a program indicator called TestDenominator, with aggregation type 
'custom' and expression:
  V{event_count}

  3. Create a program indicator called TestPercentage, with aggregation type 
'custom' and expression, which combines these two expressions as a percentage:
  sum(d2:condition('#{dBwrot7S420.vANAXwtLwcT}>=10',1,0)) / V{event_count} * 100

  4. Create a pivot table based on the Antenatal program, add all three 
indicators to the pivot, and run it:
  Numerator and denominator calculate correctly, but percentage returns 2/3 = 0 
(instead of 66.7)

  5. Now change the Period from Last 12 months to Last 52 weeks, and re-run:
  All indicators now calculate correctly, with percentage correctly showing 0/1 
= 0 and 2/2 = 100.

  
  Note that this is not a bug in the event_count variable, as the same bug 
consistently appears even when V{event_count} is replaced by sum(1) in the 
indicator expressions.

  I have a project whose viability depends on being able to correctly
  calculate these percentages at higher levels of aggregation (regions
  etc), so if confirmed as a bug, I would be hugely grateful if it were
  possible to fix this in the current release, rather than in 2.25.

  Many thanks, Sam.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1612375/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Analytics crashed in DHIS2 Live - how do I drop H2 tables?

[Sam Johnson]

Hi all,

I’m trying to whip up a quick 2.24 prototype using (first time for me) DHIS2 
Live.  However, after setting up all program metadata and entering 2 events, 
the second time I ran the analytics, it crashed, with an error message that 
includes “Table _ORGUNITSTRUCTURE_TEMP already exists”.  (Presumably the 
analytics didn’t tidy up after itself properly the first time it ran.)  All 
further attempts to run the analytics have generated the same error message.

How can I reset/clear the analytics tables?  I’ve never worked with embedded H2 
databases before – is it possible to get a SQL console, so I can list and drop 
the offending temp tables?  (I’m using the vanilla DHIS2 Live download in an 
Ubuntu 14.04 VM.)

Cheers, Sam.

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp