Re: [Dhis2-users] Can't load option sets after upgrade

2018-06-07 Thread Barnabas Akumba
Hello Busoye,

You are right.
I did the update and everything worked.

Rights

On Thu, Jun 7, 2018 at 6:50 PM, Barnabas Akumba 
wrote:

> Hello Busoye,
>
> Thanks for the information.
> Will try that and revert.
>
> Regards
>
> On Thu, Jun 7, 2018 at 6:39 PM, Adebusoye Anifalaje  > wrote:
>
>> Hi Barnabas,
>>
>> This sounds like a recent bug that was fixed. Try updating to the latest
>> build to see if that solves the problem
>>
>> Best,
>>
>> - -
>>
>>
>>
>>
>>
>> *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 *
>>
>> On 7 Jun 2018, at 15:19, Barnabas Akumba  wrote:
>>
>> Hello All,
>>
>> I've upgraded from 2.28 to 2.29 and discovered that option sets can't
>> load in my event program which hitherto were loading.
>> i.e. there are some elements that have option sets as values to be
>> selected from during data entry but those options wouldn't load.
>>
>> Any one with this experience before? How can this be solved?
>>
>> Your usual responses will be appreciated.
>>
>> Regards
>>
>> --
>>
>> Barnabas AKUMBA
>>
>> *Mobile:* +2348036195778
>> *Skype:* barnabas.akumba
>> ___
>> 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
>>
>>
>>
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba
>



-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba
___
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] Can't load option sets after upgrade

2018-06-07 Thread Barnabas Akumba
Hello Busoye,

Thanks for the information.
Will try that and revert.

Regards

On Thu, Jun 7, 2018 at 6:39 PM, Adebusoye Anifalaje 
wrote:

> Hi Barnabas,
>
> This sounds like a recent bug that was fixed. Try updating to the latest
> build to see if that solves the problem
>
> Best,
>
> - -
>
>
>
>
>
> *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 *
>
> On 7 Jun 2018, at 15:19, Barnabas Akumba  wrote:
>
> Hello All,
>
> I've upgraded from 2.28 to 2.29 and discovered that option sets can't load
> in my event program which hitherto were loading.
> i.e. there are some elements that have option sets as values to be
> selected from during data entry but those options wouldn't load.
>
> Any one with this experience before? How can this be solved?
>
> Your usual responses will be appreciated.
>
> Regards
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba
> ___
> 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
>
>
>


-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba
___
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] Can't load option sets after upgrade

2018-06-07 Thread Adebusoye Anifalaje
Hi Barnabas,

This sounds like a recent bug that was fixed. Try updating to the latest build 
to see if that solves the problem 

Best, 

- -




Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +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

> On 7 Jun 2018, at 15:19, Barnabas Akumba  wrote:
> 
> Hello All,
> 
> I've upgraded from 2.28 to 2.29 and discovered that option sets can't load in 
> my event program which hitherto were loading.
> i.e. there are some elements that have option sets as values to be selected 
> from during data entry but those options wouldn't load.
> 
> Any one with this experience before? How can this be solved?
> 
> Your usual responses will be appreciated.
> 
> Regards
> 
> -- 
>  
> Barnabas AKUMBA
> 
> Mobile: +2348036195778
> Skype: barnabas.akumba
> ___
> 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

___
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] Customising timely submissions to a specific time

2018-06-07 Thread Jasper Timm
Surprised there wasn't any discussion on this.

Calle, I know you spoke about it with Les recently. This seems like a
sensible feature to add don't you agree?

There's certainly a need for it in Sierra Leone and the MoH in Liberia
asked for the same thing as well.

Maybe I should just put a JIRA feature request for it in?

On Fri, Jun 1, 2018 at 4:11 PM Jasper Timm 
wrote:

> Hi there DHIS2 folks,
>
> At the moment there is a field within aggregate dataSets for "days after
> period to qualify for timely submissions".
>
> Is there any plan to make this a little more customisable, so that we
> could for instance list a specific time as well? i.e. Monday at 12pm.
>
> We're currently using custom external scripts to calculate our own
> 'timely' values because this isn't possible, but it would be great to use
> the built in Reporting Rate Summary.
>
> Thanks,
>
> - Jasper
> --
>
> Jasper Timm
>
> Lead Software Developer
>
> 
>
> eHealth Africa
> 4A Renner Drive
> Off Wilkinson Road (behind Monoprix Supermarket)
> Freetown, Sierra Leone
>
> mobile +232 99891119 <+232%2099%20891119>
>
> --
>
> 
> 
> 
> 
> 
>
-- 

Jasper Timm

Lead Software Developer



eHealth Africa
4A Renner Drive
Off Wilkinson Road (behind Monoprix Supermarket)
Freetown, Sierra Leone

mobile +232 99891119

--






___
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] Short name as a system setting

2018-06-07 Thread Knut Staring
There is a lot of value in being able to select "short names" for
analytical outputs like charts and tables, but currently this is a system
setting, i.e. you have to make the decision for EVERYTHING. Would it not
make more sense to specify this PER FAVORITE? And should CODE be a third
option?

To make it a slightly wider discussion, to what extent are people actually
using short names for?

Thanks,
Knut
___
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] Can't load option sets after upgrade

2018-06-07 Thread Barnabas Akumba
Hello All,

I've upgraded from 2.28 to 2.29 and discovered that option sets can't load
in my event program which hitherto were loading.
i.e. there are some elements that have option sets as values to be selected
from during data entry but those options wouldn't load.

Any one with this experience before? How can this be solved?

Your usual responses will be appreciated.

Regards

-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba
___
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 while deleting a data element

2018-06-07 Thread Preeti Ajgaonkar
Hi Nayeem

Thank you for your suggestion. The association of data element from the
programs and program stages was removed. Removing foreign key references
from trackedentitydataelementdimension, dataelementtranslations,
dataelementattributevaluestables helped in deleting the data element.


On Thu, Jun 7, 2018 at 12:07 PM, Nayeem Al Mifthah 
wrote:

> Dear Preeti
> Tracker data values are in separate table. Could you please-
>
>- Check that this data element is not assigned in any program or
>program stage
>- Tracker data values are stored in separate table named tracked
>entity data value please check that table
>- Check audit tables for tracked entity data value named
>trackedentitydatavalueaudit
>
>
>
> *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
> ​
>
> On Wed, Jun 6, 2018 at 4:28 PM, Preeti Ajgaonkar  > wrote:
>
>> Hey Knut, this is a Tracker type data element, it does not have any rows
>> in datavalue table.
>>
>> On Wed, Jun 6, 2018 at 3:45 PM, Knut Staring  wrote:
>>
>>> I don't know what the issue would be, but have you checked that there is
>>> nothing in the datavalue table with this dataelementid?
>>>
>>> Knut
>>>
>>> On Wed, Jun 6, 2018 at 12:14 PM Preeti Ajgaonkar <
>>> apre...@thoughtworks.com> wrote:
>>>
 Hi,

 I am receiving a *504-Gateway-Timeout* exception whenever I try to
 delete any of the data elements in DHIS 2.27. The DELETE
 https://hmis-qa.ehealthunit.org/api/27/dataElements/a6a1a84029f call
 runs for a long time and finally fails with the above error in console and 
 '*undefined
 was not deleted*' error in the UI. There is no error in the server log
 as well. Could anyone help me know how to get this issue resolved?

 --
 Thanks
 Preeti Ajgaonkar
 ___
 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

>>>
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks
>> Preeti Ajgaonkar
>>
>> ___
>> 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
>>
>>
>


-- 
Thanks
Preeti Ajgaonkar
___
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] Missing orderby clause in TrackedEntityInstance Ids query

2018-06-07 Thread Morten Olav Hansen
Hi

Postgres should return the results in row-order if no order by clause is
specified, so it should be OK. You can always specify additional ordering
if you need it.

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

On Thu, Jun 7, 2018 at 8:54 AM, Rajeswari Gottipati <
rajes...@thoughtworks.com> wrote:

> Hi DHIS team,
>
> We are hitting the below API to fetch TrackedEntityInstance(TEI) Ids
>
> http:///api/25/trackedEntityInstances?eventEndDate=2018-06-03&
> eventStartDate=2018-03-18&fields=trackedEntityInstance&
> ou=a2620f76786&ouMode=DESCENDANTS&page=1&pageSize=1000&totalPages=true
> 
>
> The above API call will give first 1000 TEI ids because the call is
> paginated with pagesize=1000. Like that we are making calls for other pages
> to fetch all the TEI Ids.
>
> DHIS is using the below query to get the TEI ids
>
> select distinct tei from TrackedEntityInstance tei left join 
> tei.trackedEntityAttributeValues
> where (  tei.organisationUnit.path LIKE '/a2cf79e8g34/a1c343a3w24%') and  
> tei.deleted
> is false;
>
> In this query we couldn't find any order by clause. Is there any chance
> that few of the TEI ids which are returned in some page are going to be
> repeated in another page also.
> Is this query going to be executed every time for each paginated API call?
>
> --
> Rajeswari Gottipati
> Sr Consultant
> Email rajes...@thoughtworks.com
> Telephone +91 9949292931 <+91%209949292931>
> [image: ThoughtWorks]
> 
>
> ___
> 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