[Dhis2-devs] unable to edit a program stage instance (re-published)

[Bernard Sadaka (IM Advisor)]

Dear All,

Our team is facing a problem with editing some program stage instances that
are open (not completed) and their enrollment is not completed.

I am superuser and usually I am able to edit any instance but I still can’t
edit these ones even after clearing browser cache, deleting cookies, logging
in from incognito browsing, different computer, different internet network…

My best guess is that someone else might be editing that instance which is
causing other users to not be able to edit it.

Have you faced similar problems?

Any idea how to solve it?

Ou current workaround: We are forcefully creating a new instance with the
same data and deleting the old instance; this solution is not really
sustainable since we are facing similar cases 10-15 times in the same day.

Here’s a screenshot:





Looking forward to hearing about your experience in this.



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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Scripts for import of TEI and events

[Bernard Sadaka (IM Advisor)]

Dear All,

I added my comment on webmaster this morning with regards to the
availability of scripts that could help importing of TEIs into DHIS2
(https://webmasters.stackexchange.com/questions/106521/importing-beneficiary
-records-into-dhis2-tracker-from-excel ) and I was wondering if any of you
have such scripts available.



I have searched without success the resources available at:
https://github.com/dhis2/dhis2-utils/tree/master/resources



What I would like to achieve is: We have spreadsheets of the extracted data
from the HIS of our supported PHCCs and we would like to import these into
our DHIS2 (both TEI and events). While event import is available, the TEI is
not (at least not to my knowledge)



It could really be of great value to our work to be able to do this import
(even if through the API) hence some guidance is appreciated.

Thank you in advance for your help.



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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Asked a new DHIS2 question on webmasters.stackexchange.com

[Bernard Sadaka (IM Advisor)]

Hello all,

I find the previously shared webmasters.stackexchange.com a good place to
build DHIS Q knowledge base, therefore I asked my own question:

 
 “How can we
edit a Program Stage Instance that is not marked as completed but DHIS2
doesn't allow to edit it?”

 

Appreciate if any of you know the answer, but please answer it on the
platform ;)

 

Thank you in advance.

 

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

 

 

___
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

[Bernard Sadaka (IM Advisor)]

Thank You Markus,

I started following the 2 issues and voted for them.

As for (X*100)%100 , it returns the first 2 digits after the comma, therefore 
the expression mentioned earlier would have simulates a rounding function if 
the parenthesis were processed correctly as mentioned in the JIRA issue ;)

Thank you again for the 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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Friday, February 9, 2018 11:16 AM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: dhis2-users <dhis2-us...@lists.launchpad.net>; DHIS 2 developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] [Dhis2-users] 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) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> 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) <lib@pu-ami.org <mailto:lib@pu-ami.org> 
>
Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net> ; 
DHIS 2 developers <dhis2-devs@lists.launchpad.net 
<mailto:dhis2-devs@lists.launchpad.net> >
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:

 
<https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#program_indicator_functions_variables_operators>
 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) < 

[Dhis2-devs] Support for Time and DateTime

[Bernard Sadaka (IM Advisor)]

Hello guys,

Maybe this was already tackled before, but apparently, in my 2.28 instance,
the Support for Time and DateTime is working in the “maintenance” app but
not in the “event capture” app (didn’t test the tracker capture app).





I have checked JIRA and found this one as solved in 2.28:
https://jira.dhis2.org/browse/DHIS2-2088



Is there a way to reopen it? Was it only solved for another app? Am I
missing something?



Thank you again for the 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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Support for Time and DateTime

[Bernard Sadaka (IM Advisor)]

Thank you Lukas,

You will add them to JIRA? To the repository?

When/where will the fix be available for download? In the WAR file? If yes, 
which one?

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:42 PM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: dhis2-users <dhis2-us...@lists.launchpad.net>; DHIS 2 developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi Bernard,

Apparently they have been missed out. I will add them now.



Best regards,

Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.17 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



Hello guys,

Maybe this was already tackled before, but apparently, in my 2.28 instance, the 
Support for Time and DateTime is working in the “maintenance” app but not in 
the “event capture” app (didn’t test the tracker capture app).





I have checked JIRA and found this one as solved in 2.28:  
<https://jira.dhis2.org/browse/DHIS2-2088> 
https://jira.dhis2.org/browse/DHIS2-2088



Is there a way to reopen it? Was it only solved for another app? Am I missing 
something?



Thank you again for the 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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org








  _


 <https://www.avast.com/antivirus>

This email has been checked for viruses by Avast antivirus software.
 <https://www.avast.com/antivirus> www.avast.com





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





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Support for Time and DateTime

[Bernard Sadaka (IM Advisor)]

Thank you.



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:52 PM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: dhis2-users <dhis2-us...@lists.launchpad.net>; DHIS 2 developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi again,

I will push a fix to the repository. The fix will be for version 2.28 and 2.29.

If all goes as planned you should be able to download a new war-file at the end 
of the day or latest tomorrow.



Regards

- Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.48 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



Thank you Lukas,

You will add them to JIRA? To the repository?

When/where will the fix be available for download? In the WAR file? If yes, 
which one?

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [ <mailto:lukase...@gmail.com> 
mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:42 PM
To: Bernard Sadaka (IM Advisor) < <mailto:lib@pu-ami.org> 
lib@pu-ami.org>
Cc: dhis2-users < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi Bernard,

Apparently they have been missed out. I will add them now.



Best regards,

Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.17 skrev Bernard Sadaka (IM Advisor) < 
<mailto:lib@pu-ami.org> lib@pu-ami.org>:



Hello guys,

Maybe this was already tackled before, but apparently, in my 2.28 instance, the 
Support for Time and DateTime is working in the “maintenance” app but not in 
the “event capture” app (didn’t test the tracker capture app).





I have checked JIRA and found this one as solved in 2.28:  
<https://jira.dhis2.org/browse/DHIS2-2088> 
https://jira.dhis2.org/browse/DHIS2-2088



Is there a way to reopen it? Was it only solved for another app? Am I missing 
something?



Thank you again for the 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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org








  _



 <https://www.avast.com/antivirus> <~WRD000.jpg>

This email has been checked for viruses by Avast antivirus software.
 <https://www.avast.com/antivirus> www.avast.com






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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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

[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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> 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) <lib@pu-ami.org>
Cc: dhis2-us...@lists.launchpad.net; DHIS 2 developers 
<dhis2-devs@lists.launchpad.net>
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 
<https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#program_indicator_functions_variables_operators>



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) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



I found a similar issue on JIRA ( <https://jira.dhis2.org/browse/DHIS2-2734> 
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,

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Dhis2-users [ 
<mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net> 
mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf Of 
Bernard Sadaka (IM Advisor)
Sent: Tuesday, February 6, 2018 3:53 PM
To:  <mailto:dhis2-us...@lists.launchpad.net> dhis2-us...@lists.launchpad.net; 
'DHIS 2 developers' < <mailto:dhis2-devs@lists.launchpad.net> 
dhis2-devs@lists.launchpad.net>
Subject: [Dhis2-users] Using program rule expressions in Program indicator 
expressions



Can anyone tell me why I can’t use program rule expressions in Program 
indicator expressions?

Functions like ceil, floor, round and others are very useful.



Also I tried to use the “Decimals in data output” in the program indicator 
details, it didn’t work.

Also I tried to simulate the round function using conditional modulo 
subtraction/addition (the pivot table keeps trying to load) :

C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 + 
d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)



Thank you in advance.

Please advise.



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 

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

[Bernard Sadaka (IM Advisor)]

Can anyone tell me why I can’t use program rule expressions in Program
indicator expressions?

Functions like ceil, floor, round and others are very useful.



Also I tried to use the “Decimals in data output” in the program indicator
details, it didn’t work.

Also I tried to simulate the round function using conditional modulo
subtraction/addition (the pivot table keeps trying to load) :

C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 +
d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)



Thank you in advance.

Please advise.



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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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

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

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 <mailto:lib@pu-ami.org>

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org <https://www.pu-ami.org/>





From: Dhis2-users
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On
Behalf Of Bernard Sadaka (IM Advisor)
Sent: Tuesday, February 6, 2018 3:53 PM
To: dhis2-us...@lists.launchpad.net; 'DHIS 2 developers'
<dhis2-devs@lists.launchpad.net>
Subject: [Dhis2-users] Using program rule expressions in Program indicator
expressions



Can anyone tell me why I can’t use program rule expressions in Program
indicator expressions?

Functions like ceil, floor, round and others are very useful.



Also I tried to use the “Decimals in data output” in the program indicator
details, it didn’t work.

Also I tried to simulate the round function using conditional modulo
subtraction/addition (the pivot table keeps trying to load) :

C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 +
d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)



Thank you in advance.

Please advise.



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 <mailto:lib@pu-ami.org>

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org <https://www.pu-ami.org/>









<https://www.avast.com/sig-email?utm_medium=email_source=link_campai
gn=sig-email_content=emailclient_term=icon>

Virus-free.
<https://www.avast.com/sig-email?utm_medium=email_source=link_campai
gn=sig-email_content=emailclient_term=link> www.avast.com





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Support for Time and DateTime

[Bernard Sadaka (IM Advisor)]

Dear Lukas,

Was this fix pushed to the repository?

And if yes, will I be able to download it from: 
https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.28/dhis.war or on 
another url?



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org]
Sent: Tuesday, February 13, 2018 3:07 PM
To: 'Lukas Wijgaart-van Dijk' <lukase...@gmail.com>
Cc: 'dhis2-users' <dhis2-us...@lists.launchpad.net>; 'DHIS 2 developers' 
<dhis2-devs@lists.launchpad.net>
Subject: RE: [Dhis2-devs] Support for Time and DateTime



Thank you.



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [ <mailto:lukase...@gmail.com> 
mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:52 PM
To: Bernard Sadaka (IM Advisor) < <mailto:lib@pu-ami.org> 
lib@pu-ami.org>
Cc: dhis2-users < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi again,

I will push a fix to the repository. The fix will be for version 2.28 and 2.29.

If all goes as planned you should be able to download a new war-file at the end 
of the day or latest tomorrow.



Regards

- Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.48 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



Thank you Lukas,

You will add them to JIRA? To the repository?

When/where will the fix be available for download? In the WAR file? If yes, 
which one?

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [ <mailto:lukase...@gmail.com> 
mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:42 PM
To: Bernard Sadaka (IM Advisor) < <mailto:lib@pu-ami.org> 
lib@pu-ami.org>
Cc: dhis2-users < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi Bernard,

Apparently they have been missed out. I will add them now.



Best regards,

Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.17 skrev Bernard Sadaka (IM Advisor) < 
<mailto:lib@pu-ami.org> lib@pu-ami.org>:



Hello guys,

Maybe this was already tackled before, but apparently, in my 2.28 instance, the 
Support for Time and DateTime is working in the “maintenance” app but not in 
the “event capture” app (didn’t test the tracker capture app).





I have checked JIRA and found this one as solved in 2.28:  
<https://jira.dhis2.org/browse/DHIS2-2088> 
https://jira.dhis2.org/browse/DHIS2-2088



Is there a way to reopen it? Was it only solved for another app? Am I missing 
something?



Thank you again for the 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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org








  _



 <https://www.avast.com/antivirus> <~WRD000.jpg>

This email has been checked for viruses by Avast antivirus software.
 <https://www.avast.com/antivirus> www.avast.com





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

Re: [Dhis2-devs] Support for Time and DateTime

[Bernard Sadaka (IM Advisor)]

Thank you Lukas,

Just moved our instance from build 28c2dcd to 0468366; I guess several fixes 
have already been applied… I also started to watch some apps of the project on 
github.

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [mailto:lukase...@gmail.com]
Sent: Friday, February 23, 2018 10:22 AM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: dhis2-users <dhis2-us...@lists.launchpad.net>; DHIS 2 developers 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi Bernard,

The fix has been pushed, here is a reference to the commit: 
https://github.com/dhis2/event-capture-app/commit/32229900dd95d47a01259c82fbe52f4b4ae49903.

You should be able to download it from the link you have provided.



Best regards,

Lukas Wijgaart van Dijk



23. feb. 2018 kl. 09.00 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



Dear Lukas,

Was this fix pushed to the repository?

And if yes, will I be able to download it from:  
<https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.28/dhis.war> 
https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.28/dhis.war or on 
another url?



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Bernard Sadaka (IM Advisor) [ <mailto:lib@pu-ami.org> 
mailto:lib@pu-ami.org]
Sent: Tuesday, February 13, 2018 3:07 PM
To: 'Lukas Wijgaart-van Dijk' < <mailto:lukase...@gmail.com> 
lukase...@gmail.com>
Cc: 'dhis2-users' < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; 'DHIS 2 developers' < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Subject: RE: [Dhis2-devs] Support for Time and DateTime



Thank you.



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [ <mailto:lukase...@gmail.com> 
mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:52 PM
To: Bernard Sadaka (IM Advisor) < <mailto:lib@pu-ami.org> 
lib@pu-ami.org>
Cc: dhis2-users < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi again,

I will push a fix to the repository. The fix will be for version 2.28 and 2.29.

If all goes as planned you should be able to download a new war-file at the end 
of the day or latest tomorrow.



Regards

- Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.48 skrev Bernard Sadaka (IM Advisor) < 
<mailto:lib@pu-ami.org> lib@pu-ami.org>:



Thank you Lukas,

You will add them to JIRA? To the repository?

When/where will the fix be available for download? In the WAR file? If yes, 
which one?

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Lukas Wijgaart-van Dijk [ <mailto:lukase...@gmail.com> 
mailto:lukase...@gmail.com]
Sent: Tuesday, February 13, 2018 2:42 PM
To: Bernard Sadaka (IM Advisor) < <mailto:lib@pu-ami.org> 
lib@pu-ami.org>
Cc: dhis2-users < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Support for Time and DateTime



Hi Bernard,

Apparently they have been missed out. I will add them now.



Best regards,

Lukas Wijgaart van Dijk



13. feb. 2018 kl. 13.17 skrev Bernard Sadaka (IM Advisor) < 
<mailt

[Dhis2-devs] latest 2.28 build not working?

[Bernard Sadaka (IM Advisor)]

Dear Developpers,

Today, 30 minutes ago (noon UTC), I tried to deploy the latest 2.28 .war (
available at:
https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.28/dhis.war ) but it
failed to start on my server so I reverted back to my previous .war

Please advise.

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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] outstanding but important and urgent bug

[Bernard Sadaka (IM Advisor)]

Dear developers team,

 

In Apr 2018 I reported the bellow bug, which denies us from putting some
dates where the corresponding date and time does not exist due to daylight
saving.

While this is not very disruptive to our operations, it has become a major
source of wrong data, because in order to be able to enter the data, we are
choosing a different date (usually 1 day before or after).

 

Do you think you can have a look at it?

https://jira.dhis2.org/browse/DHIS2-3329

I have just escalated its priority to highest.

 

Thank you in advance for the hard work!

 

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

 

 

___
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] Upgrade from 2.28 to 2.29 to 2.30: ALTER TABLE public.relationshipitem OWNER to dhis;

[Bernard Sadaka (IM Advisor)]

Dear All,

 

I did upgrade from 2.28 to 2.29 checked everything was working well

then upgraded from 2.29 to 2.30 checked everything was working well too.

 

few weeks later i did the same as above but upgrading from 2.29 to 2.30 had
this error: ERROR: permission denied for relation relationshipitem

so i ran this psql query and everything was ok: ALTER TABLE
public.relationshipitem OWNER to dhis;

 

Is this a problem in the upgrade script? is the ownership of the table
possibly not handled in the upgrade script?

The problem is solved for now for me, but I am sharing if this could
improved somehow.

 

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

 

 

___
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: External Dashboard URL

[Bernard Sadaka (IM Advisor)]

Hello All,

Since I didn’t get any answer for the bellow on the users list, I am
forwarding to the developers list in the hope to get an answer.

Thank you in advance.

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 <mailto:lib@pu-ami.org>

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org <https://www.pu-ami.org/>





From: Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org]
Sent: Monday, February 26, 2018 4:53 PM
To: 'dhis2-users' <dhis2-us...@lists.launchpad.net>
Subject: External Dashboard URL



Dear All,

I created a dashboard and made it available externally. How can I find the
URL for that Dashboard?

Does the dashboard itself becomes available for the external viewers? Or
only via the API?

I tried to use the URLs:

* /dhis-web-dashboard-integration/index.html?id=QrdYXtKt2e6

* /api/dashboards/QrdYXtKt2e6

* /api/dashboards/QrdYXtKt2e6.json

I can share the individual items of the dashboard using:
/api/26/charts/gk5bXuhH7DL/data.html+css but then shouldn’t there be a
similar url for the dashboard?

I can also try and create an external html page with each of the charts’
external URL, but I do believe that the share dashboard externally should
allow this, no? please correct me if I am wrong.



Thank you for your help in advance.



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 <mailto:lib@pu-ami.org>

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org <https://www.pu-ami.org/>







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] Custom colors for pivot and charts

[Bernard Sadaka (IM Advisor)]

Hello All,

Is it possible to customize the color of the pivot table rows as well as the
charts?

What I would like to achieve is provide pivot table and charts that match
colors: e.g. the target data in blue and the actual data in green both in
the pivot rows/columns as well as in the chart.

Advice appreciated.



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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] 2.29 upgrade script error

[Bernard Sadaka (IM Advisor)]

Dear All,

I am trying to migrate from 2.28 (aff610f) to 2.29, by first running the
upgrade script and then updating the .war file.

However I am stuck at the upgrade script with this error:



Please advise.



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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] 2.29 upgrade script error

[Bernard Sadaka (IM Advisor)]

Dear Markus,

After a closer look, I found this table:

public | program_userroles | table | dhis

Is it the same?



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Dhis2-users 
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf 
Of Bernard Sadaka (IM Advisor)
Sent: Friday, March 9, 2018 3:17 PM
To: 'Markus Bekken' <mar...@dhis2.org>
Cc: dhis2-us...@lists.launchpad.net; 'DHIS 2 Developers list' 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-users] [Dhis2-devs] 2.29 upgrade script error



Hello Markus,

Unfortunately I don’t have that table:

dhisdb=# \dt userrole*

 List of relations

Schema |   Name| Type  | Owner

+---+---+---

public | userrole  | table | dhis

public | userroleauthorities   | table | dhis

public | userroledataset   | table | dhis

public | userrolemembers   | table | dhis

public | userroletranslations  | table | dhis

public | userroleuseraccesses  | table | dhis

public | userroleusergroupaccesses | table | dhis

(7 rows)

Is there any maintenance scripts I need to run in order to create that table?



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Friday, March 9, 2018 2:32 PM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org <mailto:lib@pu-ami.org> 
>
Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net> ; 
DHIS 2 Developers list <dhis2-devs@lists.launchpad.net 
<mailto:dhis2-devs@lists.launchpad.net> >
Subject: Re: [Dhis2-devs] 2.29 upgrade script error



Hi there Bernard,

that was strange - your 2.28 database should have contained the table 
userroleprogram.

Assuming you are running 2.28, can you try running this query on your command 
line?

\dt userrole*

Expecting that one of the lines output is:

public | userroleprogram   | table | dhis



Best regards,

Markus



9. mar. 2018 kl. 10:04 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



Dear All,

I am trying to migrate from 2.28 (aff610f) to 2.29, by first running the 
upgrade script and then updating the .war file.

However I am stuck at the upgrade script with this error:



Please advise.



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org








 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>

Virus-free.  
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
 www.avast.com

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





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] 2.29 upgrade script error

[Bernard Sadaka (IM Advisor)]

Hello Markus,

Unfortunately I don’t have that table:

dhisdb=# \dt userrole*

 List of relations

Schema |   Name| Type  | Owner

+---+---+---

public | userrole  | table | dhis

public | userroleauthorities   | table | dhis

public | userroledataset   | table | dhis

public | userrolemembers   | table | dhis

public | userroletranslations  | table | dhis

public | userroleuseraccesses  | table | dhis

public | userroleusergroupaccesses | table | dhis

(7 rows)

Is there any maintenance scripts I need to run in order to create that table?



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Friday, March 9, 2018 2:32 PM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: dhis2-us...@lists.launchpad.net; DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] 2.29 upgrade script error



Hi there Bernard,

that was strange - your 2.28 database should have contained the table 
userroleprogram.

Assuming you are running 2.28, can you try running this query on your command 
line?

\dt userrole*

Expecting that one of the lines output is:

public | userroleprogram   | table | dhis





Best regards,

Markus





9. mar. 2018 kl. 10:04 skrev Bernard Sadaka (IM Advisor) <lib@pu-ami.org 
<mailto:lib@pu-ami.org> >:



Dear All,

I am trying to migrate from 2.28 (aff610f) to 2.29, by first running the 
upgrade script and then updating the .war file.

However I am stuck at the upgrade script with this error:



Please advise.



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org








 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>

Virus-free.  
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
 www.avast.com

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





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] org unit in program variable/rule

[Bernard Sadaka (IM Advisor)]

Hello all,

Is there a way to get the organization unit as a program variable and/or use
it in the program rules?

My usecase is that I want to use the program rule to create a unique value
based on:

* The PHCC (org unit)

* The family number

* The individual number

Thanks in advance for the help.

 

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

 

 

___
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] org unit in program variable/rule

[Bernard Sadaka (IM Advisor)]

Thank you Sakibou!

It worked.

 

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org

 

 

From: Sakibou ALASSANI [mailto:sakibou.al...@yahoo.fr] 
Sent: Tuesday, April 10, 2018 2:27 PM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>; 'DHIS 2 Developers list' 
<dhis2-devs@lists.launchpad.net>; dhis2-us...@lists.launchpad.net
Subject: Re: [Dhis2-users] org unit in program variable/rule

 

Hi Sadaka

>From my knowledge Only orgunit code is supported at now

You can use V{orgunit_code} in the assignment expression 

 


Sakibou 

 

 

Le mardi 10 avril 2018 à 10:59:39 UTC, Bernard Sadaka (IM Advisor) 
<lib@pu-ami.org <mailto:lib@pu-ami.org> > a écrit : 

 

 

Hello all,

Is there a way to get the organization unit as a program variable and/or use it 
in the program rules?

My usecase is that I want to use the program rule to create a unique value 
based on:

* The PHCC (org unit)

* The family number

* The individual number

Thanks in advance for the help.

 

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.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

___
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] 2 Urgent bugs

[Bernard Sadaka (IM Advisor)]

Dear All,

We are facing a bit of an issue with some bugs on DHIS 2.28 (most are on
JIRA), however 2 are extremely urgent and render our work very difficult:

* WeeklySunday period labels wrong pattern:
https://jira.dhis2.org/browse/DHIS2-2371  (since 15 Oct 2017) but also
duplicated here:  https://jira.dhis2.org/browse/DHIS2-3112 



* Downloading completed events in events report downloads
everything: https://jira.dhis2.org/browse/DHIS2-3357 

 

We would be really thankful if someone can have a look.

Thank you in advance for your invaluable help.

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

 

 

___
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] WeeklySunday period labels wrong pattern

[Bernard Sadaka (IM Advisor)]

Thank you Nayeem,

I updated my JIRA issue accordingly.

Any chance we can fast forward the solution of this problem?

It renders this particular reporting useless with the wrong labels :( for all 
our projects and we can’t substitute.

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Nayeem Al Mifthah [mailto:n.mift...@gmail.com]
Sent: Friday, March 2, 2018 7:36 PM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: dhis2-us...@lists.launchpad.net; DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-users] WeeklySunday period labels wrong pattern



Dear Bernard

Thanks a lot for raising the issue.



It seems same issue, I have also found earlier and reported.



https://jira.dhis2.org/browse/DHIS2-2371



Jan is looking after the issue and marked as to do. Hope to get solution soon.



Kindly search issues before report. If your issue is completely similar to any 
issue reported earlier, kindly vote for the issue rather creating a new one.





Regards,
Nayeem Al Mifthah
Consultant for HSS, HMIS, M, GIS and Surveillance

Kindly ignore typos.



On 2 Mar 2018 21:37, "Bernard Sadaka (IM Advisor)" <lib@pu-ami.org 
<mailto:lib@pu-ami.org> > wrote:

Hello All,

After entering some yearlong data on a weekly basis, I realized that the format 
we use is EPI WeeklySunday and now iso. So I changed the period type of the 
dataset to WeeklySunday and got a bug which I registered at: 
https://jira.dhis2.org/browse/DHIS2-3112

In short, the bug shows the WeeklySunday labels in the pivot table wrong as per 
the bellow screenshot:



Further details explained in the jira…

I also checked the DB table _periodstructure and it doesn't show the above 
pattern (even after doing maintenance)

Meanwhile, is there a way to fix this while we wait for a proper solution?



Thank you again for the invaluable help on the many support requests we are 
sending :)



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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 <tel:+961%2071%20004%20881>  (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org







  _


 <https://www.avast.com/antivirus>

This email has been checked for viruses by Avast antivirus software.
www.avast.com <https://www.avast.com/antivirus>






___
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





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] WeeklySunday period labels wrong pattern

[Bernard Sadaka (IM Advisor)]

Hello All,

After entering some yearlong data on a weekly basis, I realized that the
format we use is EPI WeeklySunday and now iso. So I changed the period type
of the dataset to WeeklySunday and got a bug which I registered at:
https://jira.dhis2.org/browse/DHIS2-3112

In short, the bug shows the WeeklySunday labels in the pivot table wrong as
per the bellow screenshot:



Further details explained in the jira…

I also checked the DB table _periodstructure and it doesn't show the above
pattern (even after doing maintenance)

Meanwhile, is there a way to fix this while we wait for a proper solution?



Thank you again for the invaluable help on the many support requests we are
sending :)



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







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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: events report through API

[Bernard Sadaka (IM Advisor)]

I sent the bellow few days ago to the users mailing list, but I believe the
developers would be able to help more.

Thank you in advance for your help.

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 <mailto:lib@pu-ami.org>  

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.premiere-urgence.org/ 

 

 

From: Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org] 
Sent: 26 October 2018 16:49
To: 'dhis2-us...@lists.launchpad.net' 
Subject: events report through API

 

Dear All,

I’m trying to get events report data through API and so far failing, here is
what I am doing:

· The report is saved and I can see it in the web browser

· I’m opening favorites and then get link:



· I’m taking the open in web api url:



· I try to get it using curl, postman or any other method (using
basic authentication), it give me nothing: {}

· I try to get another TEI report through the API:
/api/28/trackedEntityInstances.json?ou=H6GHIV7zcTD=DESCENDANTS It
works perfectly and gives all the data

· I’m using  Version: 2.28 Build revision: a5da35f Build date:
2018-08-02 06:23

 

Your help is very much appreciated.

Looking forward to hearing from you.

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 <mailto:lib@pu-ami.org>  

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.premiere-urgence.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] https://play.dhis2.org/2.30 down?

[Bernard Sadaka (IM Advisor)]

https://play.dhis2.org/2.30 down?

 

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.premiere-urgence.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] https://play.dhis2.org/2.30 down?

[Bernard Sadaka (IM Advisor)]

Thank you it is solved now.

 

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 <mailto:lib@pu-ami.org>  

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.premiere-urgence.org/ 

 

 

From: Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org] 
Sent: 03 December 2018 11:36
To: 'DHIS 2 developers' ; 'dhis2-users'

Subject: https://play.dhis2.org/2.30 down?

 

https://play.dhis2.org/2.30 down?

 

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 <mailto:lib@pu-ami.org>  

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.premiere-urgence.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] Design data entry from - Hangs

[Bernard Sadaka (IM Advisor)]

Hello Peter,

I’m not an expert in this matter, however when I tried to setup our server with 
4GB RAM only we faced lots of trouble; so we ended up using 8GB RAM instead.

Not sure if this is the reason for your problem though.

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.premiere-urgence.org/ 

 

 

From: Dhis2-users 
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf 
Of Peter D Lubambi
Sent: 19 November 2018 20:07
To: DHIS 2 developers ; dhis2-users 

Subject: [Dhis2-users] Design data entry from - Hangs

 

Dear All,

I am facing a problem with my DHIS2 instance, I am running version 2.30 build 
number 10b133f , whenever I try to edit my custom data entry from it loads 
forever and nothing is logged in log. I have added about 7 data elements with 
(2* 10 = 24 category options)

Server specs are 4GB RAM and 4Core. 

 

Any idea of what could be cause will be appreciated.

Regards,

 

Peter Dotto Lubambi,

Skype: plubambi
Mobile: +255 786 087 087

___
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] Error when upgrading DHIS2 from 2.29 to 2.30 - relationships

[Bernard Sadaka (IM Advisor)]

Also in order to detect the problems in other permissions on other tables I ran 
this query:

SELECT *

FROM pg_tables t

WHERE t.tableowner <> 'dhis' – dhis is my DHIS2 db user

and schemaname = 'public';

 

I discovered there’s also the table public.spatial_ref_sys that was not under 
my dhis db user, so I altered its owner too.

Thanks for the help.

 

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org

 

 

From: Stian Sandvold [mailto:st...@dhis2.org] 
Sent: Monday, September 17, 2018 03:28 PM
To: Bob Jolliffe 
Cc: lib@pu-ami.org; DHIS 2 Users list ; 
DHIS 2 Developers list 
Subject: Re: [Dhis2-users] [Dhis2-devs] Error when upgrading DHIS2 from 2.29 to 
2.30 - relationships

 

Did the sql fix your issues or are you still having issues? The superuser and 
ownership is a tricky challenge since we dont know the name of the user, but 
aside from the postgis extension, the upgradescript should be runnable as a 
non-superuser if I remember correctly.

 

On Mon, Sep 17, 2018 at 12:36 PM Bob Jolliffe mailto:bobjolli...@gmail.com> > wrote:

Good point Bernard.  

 

Interestingly this is the reverse problem to that of creating the postgis 
extension. You have to be a superuser role in the database to create the 
postgis extension in the database.  But ...

 

If you have run the upgrade script from 
https://github.com/dhis2/dhis2-releases/blob/master/releases/2.30/upgrade-230.sql
 as a superuser (eg postgres) then you are going to be left with two new tables 
(and a function?) owned by the postgres user.

 

So you should, in fact, have to do afterwards both:

ALTER TABLE public.relationshipitem OWNER to dhis;

ALTER TABLE public.relationshipconstraint OWNER to dhis;

 

Which is a little messy :-)  But hard to figure the neatest way around because 
we cannot know in advance the name of the dhis db user.

 

Cheers

Bob 

 

On 17 September 2018 at 09:58, Bernard Sadaka (IM Advisor) mailto:lib@pu-ami.org> > wrote:

I faced this same error before: “'permission denied for relation XXX”

and I fixed it using this query in the DB:

 

ALTER TABLE public.relationshipitem OWNER to dhis;

 

Replace dhis with your DB user

 

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:  <mailto:lib@pu-ami.org> lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org

 

 

From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima 
<mailto:dhis2-users-bounces%2Blib.ima> =pu-ami@lists.launchpad.net 
<mailto:pu-ami@lists.launchpad.net> ] On Behalf Of Em Le Hong
Sent: Monday, September 17, 2018 11:51 AM
To: Shurajit Dutta mailto:shurajitdu...@gmail.com> >; 
DHIS 2 Developers list mailto:dhis2-devs@lists.launchpad.net> >
Cc: DHIS 2 Users list mailto:dhis2-us...@lists.launchpad.net> >
Subject: Re: [Dhis2-users] Error when upgrading DHIS2 from 2.29 to 2.30 - 
relationships

 

Hi all,

 

I got the same problem with Nick. 

It says 'permission denied for relation relationshipitem', 

 



 

On Tue, Sep 11, 2018 at 11:18 PM Shurajit Dutta mailto:shurajitdu...@gmail.com> > wrote:

Hi everyone,

 

I am trying to upgrade a DHIS2 instance from 2.29 to 2.30. I have done this on 
a couple other instances successfully. The issue I seem to be having here is 
with the relationship types. In 2.29, I have the following relationships:

 



 

This changes to the following (as per the release notes this is expected) in 
2.30:

 



 

There are a couple issues I seem to be running into. 

 

1. I can not seem to edit these relationship types at all (the log error says 
"permission denied for relation relationshipconstraint"

 



 

2. I can not seem to open any tracker programs in tracker capture (the log 
error says "permission denied for relation relationshipitem")

 



 

Has anyone encountered this error? Any suggestions on how to fix it?

 

Thanks

 

-- 

Shurajit Dutta (MPH, MHI)

Health Information Systems Adviser

___
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




 

-- 

Em Le Hong

DHIS2 Implementation| HISP Vietnam 

em.hispviet...@gmail.com <mailto:em.hispviet...@gmail.com>  | Skype:  
<mailto:em.hispviet...