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

2018-05-21 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Scripts for import of TEI and events

2018-06-13 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Asked a new DHIS2 question on webmasters.stackexchange.com

2018-05-03 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Cloning option sets

2018-01-28 Thread Bernard Sadaka (IM Advisor) 
Hello Nada,

Yes we are facing the same problem when cloning elements especially program 
rules: the actions disappear from the cloned item.

It is definitely a bug that we hope the developers will be able to fix.



After checking Jira, I saw the following issue already created here: 
https://jira.dhis2.org/browse/DHIS2-2342 (and was last updated on 30 Nov 2017) 
I added my support for this bug.

But it is definitely worth stressing on it.



Meanwhile, we are redoing each element aside and not using the clone function 
for many sections even though it is extremely useful and saves time.

Hope this helps.



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: Dhis2-users 
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf 
Of Nada Ghosn
Sent: Saturday, January 27, 2018 10:57 AM
To: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] Cloning option sets



Good morning,

Reference is made to option sets.

When cloning an existing option set, all values of the existing option set 
disappeared.

Is it normal to loose them?

Sincerely

NG




--

Nada Ghosn, MD

Head, Epidemiology Surveillance Program (Esumoh)

Ministry of Public Health

Beirut, Museum square

Lebanon

Tel +961.1.614194

Fax +961.1.610920

Email esumoh...@gmail.com  , esu...@moph.gov.lb 


Website www.moph.gov.lb 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Organisation Units repetitive structure

2018-01-29 Thread Bernard Sadaka (IM Advisor) 
Hello All,

I’m sending this message to seek your help in solving a problem with
repetitive organization unit structure in the pivot tables section as well
as user management and others:

* The same org units are showing under their respective org unit and
alone multiple times.

* The org units in pivot tables keep trying to load each of their
data without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito
browsing… nothing worked.

Is there a script or database queries I can run to fix 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Organisation Units repetitive structure

2018-01-29 Thread Bernard Sadaka (IM Advisor) 
Thank you Knut,

The console error while at the pivot table and viewing the org units is “Cannot 
read property ‘internalId’ of undefined ” as per the bellow screenshot:





My setup is Tomcat+ postgres+ Ubuntu 16.04.3LTS+ Certbot (for SSL)+nginx (for 
reverse proxy)



As for the catalina.out, what should I be looking exactly for in there? Because 
when I go to the pivot table section while monitoring catalina.out there’s no 
exception thrown/shown using “tail –f catalina.out” (even after cleaning the 
browser cache)



Thank you in advance for your invaluable help.



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:  <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: Knut Staring [mailto:knu...@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>; DHIS 2 developers 
<dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] Organisation Units repetitive structure



Hi Bernard,



In order to elucidate what is going on, the next places to check are the 
browser console and the server log.



1) In Chrome, click on Ctrl+Shit+I to open the console window and look for 
error messages in RED.



2) For the server, look for catalina.out in the logs folder (What is your 
setup? Tomcat or DHIS Live?. Operating system?)



Regards,

Knut



On Mon, Jan 29, 2018 at 11:47 AM, Bernard Sadaka (IM Advisor) 
<lib@pu-ami.org <mailto:lib@pu-ami.org> > wrote:

Hello All,

I’m sending this message to seek your help in solving a problem with repetitive 
organization unit structure in the pivot tables section as well as user 
management and others:

* The same org units are showing under their respective org unit and 
alone multiple times.

* The org units in pivot tables keep trying to load each of their data 
without finishing (attached/bellow a screenshot)

I tried but failed to find a similar bug in the JIRA.

I tried to perform Maintenance, browser cache cleaner, login using incognito 
browsing… nothing worked.

Is there a script or database queries I can run to fix 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:  <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/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-users
Post to : dhis2-users@lists.launchpad.net 
<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp







--

Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Organisation Units repetitive structure

2018-01-30 Thread Bernard Sadaka (IM Advisor) 
Hello Again Knut,

Any news about this issue?

Should I open a ticket for it in Jira? The challenge is I don’t know how to 
replicate this bug.



Here is what happening with my org units:

As you can see bellow, all the org units are there duplicated but in a 
scrambled order and not under their respective parent. Add to that when I click 
on one of the values that are supposed to show the underlying org units only of 
the copies will expand and show that.



Is this front end related? Backend? Database related?



Here is my org unit structure:

1.  Lebanon

a.  Organisation A

   i.  Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8



In some places on my DHIS2 it shows correctly, in other places it shows as per 
the bellow (in DHIS2 sections such as the “pivot tables” and the “data output 
and analytics organization units” under new/edit user section) (the pivot 
tables keep trying to load as mentioned before) :

1.   Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

2.  PHCC 1
3.  PHCC 4
4.  PHCC 2
5.  PHCC 3
6.  PHCC 5
7.  PHCC 6
8.  Lebanon

a.  Organisation A

   i.  Base 1

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8

9.  Organisation A
10. Base 2
11. PHCC 7
12. Test Base 1
13. Test PHCC 1
14. Test PHCC 4
15. Test PHCC 2
16. Test PHCC 5
17. Test PHCC 6
18. Test PHCC 7
19. Test Org A
20. Test Base 2



Your help is 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:  <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: Monday, January 29, 2018 2:29 PM
To: 'Knut Staring' <knu...@gmail.com>
Cc: 'DHIS 2 Users list' <dhis2-users@lists.launchpad.net>; 'DHIS 2 developers' 
<dhis2-d...@lists.launchpad.net>
Subject: RE: [Dhis2-users] Organisation Units repetitive structure



Thank you Knut,

The console error while at the pivot table and viewing the org units is “Cannot 
read property ‘internalId’ of undefined ” as per the bellow screenshot:





My setup is Tomcat+ postgres+ Ubuntu 16.04.3LTS+ Certbot (for SSL)+nginx (for 
reverse proxy)



As for the catalina.out, what should I be looking exactly for in there? Because 
when I go to the pivot table section while monitoring catalina.out there’s no 
exception thrown/shown using “tail –f catalina.out” (even after cleaning the 
browser cache)



Thank you in advance for your invaluable help.



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:  <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: Knut Staring [mailto:knu...@gmail.com]
Sent: Monday, January 29, 2018 1:04 PM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org <mailto:lib@pu-ami.org> 
>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net 
<mailto:dhis2-users@lists.launchpad.net> >; DHIS 2 developers 
<dhis2-d...@lists.launchpad.net <mailto:dhis2-d...@lists.launchpad.net> >
Subject: Re: [Dhis2-users] Organisation Units repetitive structure



Hi Bernard,



In order to elucidate what is going on, the next places to check are the 
browser console and the server log.



1) In Chrome, click on Ctrl+Shit+I to open the console window and look for 
error message

Re: [Dhis2-users] Organisation Units repetitive structure

2018-01-30 Thread Bernard Sadaka (IM Advisor) 
Thank you Knut,

Will look into that.

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: Knut Staring [mailto:knu...@gmail.com]
Sent: Tuesday, January 30, 2018 10:21 AM
To: Bernard Sadaka (IM Advisor) <lib@pu-ami.org>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>; DHIS 2 developers 
<dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] Organisation Units repetitive structure



Hi Bernard,



Sorry, I'm very busy with a series of meetings this week, and also not in the 
best position to resolve this, so hoping for others on the list to step up. 
Thanks for the detailed explanation of your issue, my guess it is likely just 
some small thing with your database. You could perhaps also try to take a look 
directly at your organsationunit table in the db and scan for any anomalies 
such as 10 digit UIDs or null values (can also be done through the DHIS2 GUI 
with an SQL View (under Data Administration).



Knut



On Tue, Jan 30, 2018 at 9:10 AM, Bernard Sadaka (IM Advisor) 
<lib@pu-ami.org <mailto:lib@pu-ami.org> > wrote:

Hello Again Knut,

Any news about this issue?

Should I open a ticket for it in Jira? The challenge is I don’t know how to 
replicate this bug.



Here is what happening with my org units:

As you can see bellow, all the org units are there duplicated but in a 
scrambled order and not under their respective parent. Add to that when I click 
on one of the values that are supposed to show the underlying org units only of 
the copies will expand and show that.



Is this front end related? Backend? Database related?



Here is my org unit structure:

1.  Lebanon

a.  Organisation A

   i.  Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8



In some places on my DHIS2 it shows correctly, in other places it shows as per 
the bellow (in DHIS2 sections such as the “pivot tables” and the “data output 
and analytics organization units” under new/edit user section) (the pivot 
tables keep trying to load as mentioned before) :

1.   Base 1

1.   PHCC 1

2.   PHCC 2

3.   PHCC 3

2.  PHCC 1
3.  PHCC 4
4.  PHCC 2
5.  PHCC 3
6.  PHCC 5
7.  PHCC 6
8.  Lebanon

a.  Organisation A

   i.  Base 1

 ii.  Base 2

1.   PHCC 4

2.   PHCC 5

3.   PHCC 6

4.   PHCC 7

b.  Test Org A

   i.  Test 
Base 1

1.   Test PHCC 1

2.   Test PHCC 2

3.   Test PHCC 3

 ii.  Test Base 
2

1.   Test PHCC 4

2.   Test PHCC 5

3.   Test PHCC 6

4.   Test PHCC 7

5.   Test PHCC 8

9.  Organisation A
10. Base 2
11. PHCC 7
12. Test Base 1
13. Test PHCC 1
14. Test PHCC 4
15. Test PHCC 2
16. Test PHCC 5
17. Test PHCC 6
18. Test PHCC 7
19. Test Org A
20. Test Base 2



Your help is 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:  <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





From: Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org 
<mailto:lib@pu-ami.org> ]
Sent: Monday, January 29, 2018 2:29 PM
To: 'Knut Staring' <knu...@gmail.com <mailto:knu...@gmail.com> >
Cc: 'DHIS 2 Users list' <dhis2-users@lists.launchpad.net 
<mailto:dhis2-users@lists.launchpad.net> >; 'DHIS 2 developers' 
<dhis2-d...@lists.launchpad.net <mailto:dhis2-d...@lists.launchpad.net> >
Subject: RE: [Dhis2-users] Organisation Units repetitive structure



Thank you Knut,

The console error while at

Re: [Dhis2-users] How to track users activity in Dhis2

2018-02-06 Thread Bernard Sadaka (IM Advisor) 
Hello Jean,

I am pretty sure you can run a query in the DB to do so, not sure the graphical 
interface has this (other than the SQL view to run the queries)

@Others, please correct me if I am mistaken.

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: Dhis2-users 
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf 
Of Jean de Dieu Anoubissi
Sent: Tuesday, February 6, 2018 11:51 AM
To: DHIS Users 
Subject: [Dhis2-users] How to track users activity in Dhis2



Hello all,

Is it possible to know what users are doing in the system.?

If yes what is the procedure



Thank you



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

2018-02-11 Thread 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-users@lists.launchpad.net>; DHIS 2 developers 
<dhis2-d...@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-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net> ; 
DHIS 2 developers <dhis2-d...@lists.launchpad.net 
<mailto:dhis2-d...@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) <

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

2018-02-13 Thread 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-users@lists.launchpad.net>; DHIS 2 developers 
<dhis2-d...@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-d...@lists.launchpad.net> 
dhis2-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Support for Time and DateTime

2018-02-13 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

2018-02-13 Thread 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-users@lists.launchpad.net>; DHIS 2 developers 
<dhis2-d...@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-users@lists.launchpad.net> 
dhis2-users@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-d...@lists.launchpad.net> dhis2-d...@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-d...@lists.launchpad.net> 
dhis2-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

2018-02-07 Thread 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-users@lists.launchpad.net; DHIS 2 developers 
<dhis2-d...@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-users@lists.launchpad.net> dhis2-users@lists.launchpad.net; 
'DHIS 2 developers' < <mailto:dhis2-d...@lists.launchpad.net> 
dhis2-d...@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-users] Using program rule expressions in Program indicator expressions

2018-02-06 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

2018-02-06 Thread 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-users@lists.launchpad.net; 'DHIS 2 developers'
<dhis2-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

2018-02-23 Thread 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-users@lists.launchpad.net>; 'DHIS 2 developers' 
<dhis2-d...@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-users@lists.launchpad.net> 
dhis2-users@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-d...@lists.launchpad.net> dhis2-d...@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-users@lists.launchpad.net> 
dhis2-users@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-d...@lists.launchpad.net> dhis2-d...@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-d...@lists.launchpad.net> 
dhis2-d...@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-users] [Dhis2-devs] Support for Time and DateTime

2018-02-23 Thread 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-users@lists.launchpad.net>; DHIS 2 developers 
<dhis2-d...@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-users@lists.launchpad.net> 
dhis2-users@lists.launchpad.net>; 'DHIS 2 developers' < 
<mailto:dhis2-d...@lists.launchpad.net> dhis2-d...@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-users@lists.launchpad.net> 
dhis2-users@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-d...@lists.launchpad.net> dhis2-d...@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-users@lists.launchpad.net> 
dhis2-users@lists.launchpad.net>; DHIS 2 developers < 
<mailto:dhis2-d...@lists.launchpad.net> dhis2-d...@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

Re: [Dhis2-users] PIVOTS WEEK NUMBERS WRONG

2018-09-06 Thread Bernard Sadaka (IM Advisor) 
Hello,

Are you facing something similar to this Jira issue?

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

 

If yes, according to that jira entry it has been solved. Maybe worth updating 
to the latest war file?

 

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: Dhis2-users 
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf 
Of Walusiku Muyunda
Sent: Thursday, September 6, 2018 10:25 AM
To: dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] PIVOTS WEEK NUMBERS WRONG

 

Dear All,

 

I need help understanding why our DHIS2 instance shows the same week number for 
consecutive weeks when you run pivots? This is making it difficult for users to 
understand the data. We are still using 2.28.

 

 

Walusiku J. Muyunda

 

Cell: +260967006614
Cell: +260971000614

Cell: +260953063387

  "We have heaven to win and hell to shun, our 
lives testify better!"

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

[Dhis2-users] FW: External Dashboard URL

2018-03-01 Thread 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-users@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Custom colors for pivot and charts

2018-03-01 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] 2.29 upgrade script error

2018-03-09 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] 2.29 upgrade script error

2018-03-09 Thread 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-users@lists.launchpad.net; 'DHIS 2 Developers list' 
<dhis2-d...@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-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net> ; 
DHIS 2 Developers list <dhis2-d...@lists.launchpad.net 
<mailto:dhis2-d...@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-d...@lists.launchpad.net> 
dhis2-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] 2.29 upgrade script error

2018-03-09 Thread 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-users@lists.launchpad.net; DHIS 2 Developers list 
<dhis2-d...@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-d...@lists.launchpad.net> 
dhis2-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] org unit in program variable/rule

2018-04-10 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] org unit in program variable/rule

2018-04-10 Thread 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-d...@lists.launchpad.net>; dhis2-users@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-users@lists.launchpad.net 
<mailto:dhis2-users@lists.launchpad.net> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help  : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] WeeklySunday period labels wrong pattern

2018-03-04 Thread 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-users@lists.launchpad.net; DHIS 2 Developers list 
<dhis2-d...@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-users@lists.launchpad.net 
<mailto:dhis2-users@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] External Dashboard URL

2018-02-26 Thread Bernard Sadaka (IM Advisor) 
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

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

[Dhis2-users] WeeklySunday period labels wrong pattern

2018-03-02 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] events report through API

2018-10-26 Thread Bernard Sadaka (IM Advisor) 
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 

Cell: +961 71 004 881 (208)

Skype: imapuami

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

 

 

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

Re: [Dhis2-users] DHIS2 Android SMS gateway

2018-09-21 Thread 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: Android [mailto:andr...@dhis2.org] 
Sent: Friday, September 21, 2018 01:31 PM
To: Bernard Sadaka (IM Advisor) 
Cc: Derek Kahongo Mukenge ; dhis2-users 

Subject: Re: [Dhis2-users] DHIS2 Android SMS gateway

 

Hello Bernard, 

 

that App was outdated and did not work after not being updated to the DHIS2 new 
versions in a long time. 

 

We plan to start working on it and put it back on Google play after October 
(when we release the next version of the DHIS2 Android App).

 

I hope the apk that you found on github can help you meanwhile.

 

Best,

Marta

 

On Wed, 19 Sep 2018 at 13:42, Bernard Sadaka (IM Advisor) mailto:lib@pu-ami.org> > wrote:

Thank you!

But is there an official place where we can find the APK published? I don’t 
really trust third party providers.

 

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: Derek Kahongo Mukenge [mailto:derek.eli...@gmail.com 
<mailto:derek.eli...@gmail.com> ] 
Sent: Wednesday, September 19, 2018 02:39 PM
To: lib@pu-ami.org <mailto:lib@pu-ami.org> 
Cc: dhis2-users mailto:dhis2-users@lists.launchpad.net> >
Subject: Re: [Dhis2-users] DHIS2 Android SMS gateway

 

Hi Sadaka,

 

You can use its. The one that was in google play was deprecated.

 

Thanks

 

On Fri, Sep 14, 2018 at 12:21 PM Bernard Sadaka (IM Advisor) 
mailto:lib@pu-ami.org> > wrote:

Hello All,

Is the apk for the android application that works as SMS gateway still 
available somewhere?

I found this one, but I’m not sure I can trust this source: 
https://apkpure.com/sms-gateway-for-dhis-2/org.dhis2.androidsms 

Thank you 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-users@lists.launchpad.net 
<mailto:dhis2-users@lists.launchpad.net> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp




 

-- 

Derek Kahongo Mukenge

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

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

Re: [Dhis2-users] android capture appp's field with options list can't input select option's value.

2018-09-23 Thread Bernard Sadaka (IM Advisor) 
Maybe worth keeping it in English and using the translation for Chinese?

 

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: Dhis2-users
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On
Behalf Of ???
Sent: Sunday, September 23, 2018 07:16 PM
To: 林晓东 
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] android capture appp's field with options list
can't input select option's value.

 

the option name is chinese isn't work?

I changed the option "gender" 's option to: 男，female,  so, can choose
female, but can't for '男',

(play.dhis2.org/android-current)

 

but for my installed instance ,for English name option, still can't work,
and the tab key skip all the field with option list chooser in input form.





--

此致

   林晓东

莫愁前路无知己，天下谁人不识君。


在 2018-09-23 10:03:54，"林晓东" mailto:lin...@126.com> >
写道：



hi,all,

   I have got the newest code from github , build successfully, but when I
use in my phone, the capture form 's field with option list can't fill
select option .

   I also installed the app from google  play, it's has the same problem.

 

   can help?



Thanks

--

此致
easy

莫愁前路无知己，天下谁人不识君。

 

 

 

 
【网易自营|30天无忧退货】爱上书写：施华洛世奇制造商星空原色水晶笔，限时仅29
元>>

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

Re: [Dhis2-users] DHIS2 Android SMS gateway

2018-09-19 Thread Bernard Sadaka (IM Advisor) 
Thank you!

But is there an official place where we can find the APK published? I don’t 
really trust third party providers.

 

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: Derek Kahongo Mukenge [mailto:derek.eli...@gmail.com] 
Sent: Wednesday, September 19, 2018 02:39 PM
To: lib@pu-ami.org
Cc: dhis2-users 
Subject: Re: [Dhis2-users] DHIS2 Android SMS gateway

 

Hi Sadaka,

 

You can use its. The one that was in google play was deprecated.

 

Thanks

 

On Fri, Sep 14, 2018 at 12:21 PM Bernard Sadaka (IM Advisor) 
mailto:lib@pu-ami.org> > wrote:

Hello All,

Is the apk for the android application that works as SMS gateway still 
available somewhere?

I found this one, but I’m not sure I can trust this source: 
https://apkpure.com/sms-gateway-for-dhis-2/org.dhis2.androidsms 

Thank you 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-users@lists.launchpad.net 
<mailto:dhis2-users@lists.launchpad.net> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp




 

-- 

Derek Kahongo Mukenge

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

[Dhis2-users] https://play.dhis2.org/2.30 down?

2018-12-03 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] https://play.dhis2.org/2.30 down?

2018-12-03 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

2018-11-20 Thread 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] DHIS2 Android SMS gateway

2018-09-14 Thread Bernard Sadaka (IM Advisor) 
Hello All,

Is the apk for the android application that works as SMS gateway still
available somewhere?

I found this one, but I’m not sure I can trust this source:
https://apkpure.com/sms-gateway-for-dhis-2/org.dhis2.androidsms 

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

Re: [Dhis2-users] [Dhis2-devs] Error when upgrading DHIS2 from 2.29 to 2.30 - relationships

2018-09-17 Thread 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-d...@lists.launchpad.net> >
Cc: DHIS 2 Users list mailto:dhis2-users@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-users@lists.launchpad.net 
<mailto:dhis2-users@lists.launchpad.net> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp




 

-- 

Em Le Hong

DHIS2 Implementation| HISP Vietnam 

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