[Dhis2-users] Sample Query for Tracker Program with stages

[Walusiku Muyunda]

Dear All,

I have started working on a query to pull data from the first 2 stages of
one of the tracker programs. Anyone with a sample query structure with
tables of where data is stored.

Thank you.



*Walusiku J. Muyunda*


*Cell: +260967006614Cell: +260971000614*

*"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] Indicator totals count is incorrect

[gourav sachdeva]

Hello Team,

I'm facing an issue in a pivot table, version 2.28 while calculating the
total of indicators.

Whenever I try to generate the pivot report with indicators it shows the
average instead of the sum in the total section. I checked, the same issue
has been created on Jira and the status is resolved but I am still facing
the above mentioned.

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

Version: 2.28
Build Revision: 6657e9d
Build Date: 2018-09-17 03:20

The screenshot is enclosed for the reference with the mail.
Looking forward to your response.

-- 
*Thanks & Regards,*

*Gourav Sachdeva*
___
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] Setup DHIS2 in Linux (Debian)

[Bob Jolliffe]

I have made a package of dhis2 management scripts for Ubuntu (dhis2-tools)
also described in implementers manual.

It would be trivial enough to repackage for Debian in there is particular
demand.

On Mon, 17 Sep 2018, 11:01 Viktor Varland,  wrote:

> Hi Nayeem
>
> I have written down Debian 9 specific information for basic[1] and
> advanced[2] setups.
>
> Hope it helps.
>
> [1] https://github.com/dhis2/wow-frontend/blob/master/dhis2-basic-setup.md
> [2]
> https://github.com/dhis2/wow-frontend/blob/master/dhis2-advanced-setup.md
>
> BR
> /v.
>
> On Mon, Aug 27, 2018 at 9:45 AM Nayeem Al Mifthah 
> wrote:
>
>> Anyone having documentation on setup DHIS2 in Debian?
>>
>>
>> *Nayeem Al Mifthah*
>> *Health Information Systems Specialist*
>> Support to the National HMIS
>> MIS, Directorate General of Health Services, Ministry of Health and
>> Family Welfare, Bangladesh
>> Telephone: +880-2-58816459|Fax: +880-2-58813875|Mobile:
>>  +88-01914 030 574
>> Email: n.mift...@gmail.com|Skype: nayeem.a.m|   LinkedIn:
>> linkedin.com/in/nayeemam
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> 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] [Dhis2-devs] Error when upgrading DHIS2 from 2.29 to 2.30 - relationships

[Bernard Sadaka (IM Advisor)]

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

SELECT *

FROM pg_tables t

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

and schemaname = 'public';

 

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

Thanks for the help.

 

All the best,

Bernard

 




Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

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




 

-- 

Em Le Hong

DHIS2 Implementation| HISP Vietnam 

em.hispviet...@gmail.com   | Skype:  
 em.hispviet...@gmail.com

 



 

 

 


___
Mailing list: ht

[Dhis2-users] Could not find the report table

[Nibras Ar Rakib]

Dear all,

I am currently working with the report functionality of DHIS2 (2.29).

According to the documentation 
(https://docs.dhis2.org/2.29/en/user/html/reporting_creating_tables.html#reporting_selecting_data)
there should be an option under Reports module. But I am not finding any report 
table option under Report module.

Thanks & Regards,
Nibras Ar Rakib
___
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] How to enable 'Make referral' and 'Schedule new' buttons in Tracker tabular entry

[Em Le Hong]

Dear DHIS2 Community,

I'm using DHIS2 2.29 Tracker Capture module, I notice that there's a
different between Timeline Data Entry and Tabular Data Entry
The 2 buttons Schedule new and Make referral are enabled on Timeline Data
Entry, see screenshot
[image: Screenshot from 2018-09-17 15-18-29.png]
But those buttons are disabled on Tabular Data Entry, see screenshot
[image: Screenshot from 2018-09-17 15-18-48.png]

Does anyone know how to enable those buttons in Tabular Data Entry? if you
don't mind please share.

Thanks,
-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Setup DHIS2 in Linux (Debian)

[Viktor Varland]

Hi Nayeem

I have written down Debian 9 specific information for basic[1] and
advanced[2] setups.

Hope it helps.

[1] https://github.com/dhis2/wow-frontend/blob/master/dhis2-basic-setup.md
[2]
https://github.com/dhis2/wow-frontend/blob/master/dhis2-advanced-setup.md

BR
/v.

On Mon, Aug 27, 2018 at 9:45 AM Nayeem Al Mifthah 
wrote:

> Anyone having documentation on setup DHIS2 in Debian?
>
>
> *Nayeem Al Mifthah*
> *Health Information Systems Specialist*
> Support to the National HMIS
> MIS, Directorate General of Health Services, Ministry of Health and Family
> Welfare, Bangladesh
> Telephone: +880-2-58816459|Fax: +880-2-58813875|Mobile:
>  +88-01914 030 574
> Email: n.mift...@gmail.com|Skype: nayeem.a.m|   LinkedIn:
> linkedin.com/in/nayeemam
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Tracker Capture Authorities 2.28

[Walusiku Muyunda]

Am trying to disallow some user authority to delete records after they have
entered them. I cant seem to find which role from the below to remove in
order to enforce this. Below are the authorities I currently have assigned
to these users:
Add/Update Enrollment
Add/update Tracked entity instance
Read Enrollment
Search Tracked entity instance
See Browser cache cleaner
See dashboard
See Data Visualizer
See Pivot Table module
See report module
See Tracker capture module
Update Tracked Entities

Thank you.



*Walusiku J. Muyunda*


*Cell: +260967006614Cell: +260971000614*

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