Re: [Dhis2-devs] Discrepancy in table table programstageusergroupaccesses in version 2.29

[Calle Hedberg]

Hi,

Well spotted - the problem here is the NAMES for the column and the
constraints' foreign key - I presume it is supposed to be column
programstageid (not programid) and constraint foreign key programstageid
(not programid). NOTE that both FK constrainst need updating.

i can confirm that the "programid" DATA stored in the
programstageusergroupaccesses table refers to the programstageid values in
the programstaget table, NOT the programid values in the same table.

So submit a JIRA "bug" report for it - I cannot see that it will result in
any failures, but naming conventions should be consistent.

Regards
Calle

On Tue, 28 Aug 2018 at 12:55, Mithilesh Kumar Thakur <
mithilesh.h...@gmail.com> wrote:

> Hi,Team
>
> while i am checking database structure of version 2.29 i am see the
> following  discrepancy
>
> in programstageusergroupaccesses table there is two columns  programid
> and usergroupaccessid and  column programid is reference to table
> programstage (programstageid)
>
> please see below the structure of table programstageusergroupaccesses
>
> CREATE TABLE public.programstageusergroupaccesses
> (
>   programid integer NOT NULL,
>   usergroupaccessid integer NOT NULL,
>   CONSTRAINT programstageusergroupaccesses_pkey PRIMARY KEY (programid,
> usergroupaccessid),
>   CONSTRAINT fkbm0pqhdj9xudinnssoxjdgq6b FOREIGN KEY (programid)
>   REFERENCES public.programstage (programstageid) MATCH SIMPLE
>   ON UPDATE NO ACTION ON DELETE NO ACTION,
>   CONSTRAINT fkhrmc5b26i4fv714agdvwm2tly FOREIGN KEY (usergroupaccessid)
>   REFERENCES public.usergroupaccess (usergroupaccessid) MATCH SIMPLE
>   ON UPDATE NO ACTION ON DELETE NO ACTION,
>   CONSTRAINT uk_tcggvcb1rsd9tlnd1ub7mt0e0 UNIQUE (usergroupaccessid)
> )
> WITH (
>   OIDS=FALSE
> );
> ALTER TABLE public.programstageusergroupaccesses
>   OWNER TO dhis;
> --
>
> Thanks and Regards
>
> Mithilesh Kumar Thakur
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

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

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

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

Skype: calle_hedberg

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

Re: [Dhis2-devs] [Dhis2-users] Installation of dhis2 on docker

[gerald thomas]

Hi all,
I got it docker using postgresql is fixed now but i need to drop the
current database and import another database. Please can anyone help?

On Mon, Aug 27, 2018 at 2:55 PM gerald thomas  wrote:

> Dan,
> I am using my laptop which is mac pro where i had already installed docker
> and now i want to install an Ubuntu DHIS2 instance on it.
>
> On Mon, Aug 27, 2018 at 2:32 PM Dan Cocos  wrote:
>
>> Hi Gerald,
>>
>> You can also try this for local dev.
>> https://github.com/baosystems/dhis2-centos
>>
>> Cheers,
>> Dan
>>
>>
>> Dan Cocos
>> Principal, BAO Systems
>> dco...@baosystems.com | http://www.baosystems.com |  2900 K Street,
>> Suite 507, Washington D.C. 20007
>>
>>
>> On Aug 27, 2018, at 3:52 AM, Gerald Thomas  wrote:
>>
>> Dear Paulo,
>> Can i only have mysql database for this instance?
>>
>> On Aug 27, 2018, at 5:58 AM, Paulo Grácio  wrote:
>>
>> https://github.com/pgracio/dhis2-docker
>>
>> Hasn’t been updated for a while so not sure if there is a better way.
>>
>> On 27 Aug 2018, at 00:35, gerald thomas  wrote:
>>
>> Dear all,
>> I am trying to do a dhis2 instance using docker on my laptop. Please can
>> anyone help with the procedures; this is my first time to do it on docker
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

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

Re: [Dhis2-devs] TEI and Enrollments API GET calls are not considering date range

[Djibril Dione]

Hi Rajeswari, 

please remove the page & pageSize and try again

 

Kind regards

Djibril

From: Dhis2-devs  On 
Behalf Of Rajeswari Gottipati
Sent: Tuesday, 28 August 2018 11:44 AM
To: dhis2-devs ; Morten Olav Hansen 
; Lars Helge Øverland 
Cc: Evgenia ZELIKOVA ; Thomas RODRIGUEZ 
; twmsf ; Anceline 
DUPOUY ; Megan McGuire 
; Kristina Reinhardt 
; Sonia Diverres 

Subject: [Dhis2-devs] TEI and Enrollments API GET calls are not considering 
date range

 

Hi DHIS Team,

 

We are using below API calls to get the TrackedEntityInstance Ids and 
Enrollment Ids.

 

https:// 

 
/api/trackedEntityInstances?lastUpdatedStartDate=2018-06-17=2018-09-02=trackedEntityInstance==DESCENDANTS=5=1000==true

 

 

http:// 

 
/api/enrollments?programEndDate=2018-08-05=2018-05-20=enrollment==DESCENDANTS=1=1000=true=

 

The above API calls returning the total number of ids but not returning any 
ids. Could you please help us to identify what we have done incorrect. 

 

Thanks,

Rajeswari & Gaurav.


-- 


*This message and any attachments are subject to a disclaimer published

at http://www.hisp.org/policies.html#comms_disclaimer 
. 
Please read the 
disclaimer before opening any attachment or taking any other
action in 
terms of this electronic transmission.  If you cannot access the

disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By

replying to this e-mail or opening any attachment you agree to be bound by 
the
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] TEI and Enrollments API GET calls are not considering date range

[Rajeswari Gottipati]

Hi DHIS Team,

We are using below API calls to get the TrackedEntityInstance Ids and
Enrollment Ids.

*https:///api/trackedEntityInstances?lastUpdatedStartDate=2018-06-17=2018-09-02=trackedEntityInstance==DESCENDANTS=5=1000==true*



*http:///api/enrollments?programEndDate=2018-08-05=2018-05-20=enrollment==DESCENDANTS=1=1000=true=*

The above API calls returning the total number of ids but not returning any
ids. Could you please help us to identify what we have done incorrect.

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

Re: [Dhis2-devs] [Dhis2-users] Tragic passing of Dr Dapo Adejumo

[Derek Kahongo Mukenge]

Aaah! I've no word to express my deep sad. May his soul rest in peace
forever long.



On Fri, Aug 24, 2018 at 4:10 PM Adebusoye Anifalaje 
wrote:

> Dear DHIS 2 community,
>
> I am deeply saddened to inform you that Dapo passed away yesterday. This
> is still very shocking to us.
>
> We have set up a gofundme  page
> where you can donate to support his wife and two children. Even if you are
> not able to give a monetary donation his family will appreciate if you can
> share messages and memories on this page.
>
> Many thanks for your support. May his soul will rest in peace
>
> Very best wishes,
>
> - -
>
>
>
>
>
> *Busoye Anifalaje (PhD)Director of Services (Principal), BAO SystemsUK:
> +44 7901-740-757 | US: +1 682-307-0986| bus...@baosystems.com
>  | http://www.baosystems.com
>  |Skype: busoye | 2900 K Street, Suite 406,
> Washington D.C. 20007 *
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


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

Re: [Dhis2-devs] Updating multiple events via the WebAPI

[Morten Olav Hansen]

Hi Farai

No, this is not possible (with PUT). What you can do, is to just do a POST,
but set strategy=CREATE_AND_UPDATE and that should give you what you want
(strategy=UPDATE if you are sure its all updates only)

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


On Tue, Aug 28, 2018 at 11:57 AM Farai Mutero  wrote:

> Hi Team
>
> The DHIS2 Developer documentation discusses here
> ,
> the ability to POST multiple events to the Web API in a single payload,
> which is absolutely useful. Is this feature also available for updating
> existing events via a PUT request, In DHIS2 2.27 and later?
>
> Regards
> --
> Farai Mutero
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Updating multiple events via the WebAPI

[Farai Mutero]

Hi Team

The DHIS2 Developer documentation discusses here
,
the ability to POST multiple events to the Web API in a single payload,
which is absolutely useful. Is this feature also available for updating
existing events via a PUT request, In DHIS2 2.27 and later?

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