Re: [Dhis2-devs] [Dhis2-users] Program Indicator using data from multiple event stages to find TEA

2018-02-08 Thread Preeti Ajgaonkar 
Hi Aaron,

Could you try by setting the analytics type to 'Events' and then filter all
the events by Program stage id/Program stage name variable? Please let me
know if this serves as a workaround for your blocker.

Thanks
Preeti A

On Thu, Feb 8, 2018 at 8:19 PM, Aaron C White  wrote:

> Hi all,
>
> I'm trying to create a program indicator (or just query to the API
> directly) that evaluates conditions on data elements from two different
> event stages and then be used to find a relevant tracked entity attribute.
>
> From the docs, it seems that a program indicator type of enrollment would
> be most appropriate, but this only works at the aggregate level and not at
> an individual tracked entity instance level.  When I use an event type
> indicator, I don't receive any values back because the indicator definition
> contains data from two stages.
>
> Am I correct in this assessment?  Any thoughts on how to get around this?
>
> I've been testing on a v2.28 instance.  A similar reference example from
> the demo server would be the "Weight gain(in g) between birth and last
> postnatal for Child Programme" program indicator.  The one change would be
> that I want to see the weight gain for individual TEIs and view a TEA based
> on the weight gain amount instead of the average over all tracked entity
> instances.
>
> Thanks in advance,
>
> Aaron
>
> --
> Aaron C. White
> 919.522.5585
>
> ___
> 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
>
>


-- 
Thanks
Preeti Ajgaonkar
___
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] [Bug 1748325] [NEW] Design data entry form Text Field Properties values overwritten

2018-02-08 Thread Owen Eddins 
Public bug reported:

I am new to dhis2.  However, I have found what I believe to be a bug in
the Design data entry form on a custom form I am developing in
dhis2-live v2.28 running on a Window 10 laptop. I am using the Chrome
browser Version 64.0.3282.140 (Official Build) (64-bit).

I also verified the behavior I describe below on the play.dhis2.org/2.28
Sierra Leone demo on the custom form for the Life-Saving Commodities
Data Set.


Right click on a Data Set with a custom form containing text fields with data 
elements as values.

Choose Design data entry form

Double click on any of the input fields.

The Text Field Properties pop up window should appear.

Change one or more of the following values: Name, Value, Character Width, 
Maximum Characters, Type, Required
(I set the Width to 1 for test purposes.)

Choose OK

Click big blue Save button (Very important!)

Clear browser cache and dhis2 cache.

Navigate to the form in the Data Entry section.

Verify the changes were saved and are now part of the form.

Now go back to the Data Set’s Design data entry form and open the Text
Field Properties pop up window for the field you changed.  The values
are all empty or defaults.

Clicking on Cancel and saved values will not be overwritten.

However, when developing and laying out custom forms, developers will
need to usually change these values repeatedly.  Not seeing the saved
values with every iteration is a major impediment to developing custom
forms.

Having said all that, I am very impressed with dhis2!

** Affects: dhis2
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1748325

Title:
  Design data entry form Text Field Properties values overwritten

Status in DHIS:
  New

Bug description:
  I am new to dhis2.  However, I have found what I believe to be a bug
  in the Design data entry form on a custom form I am developing in
  dhis2-live v2.28 running on a Window 10 laptop. I am using the Chrome
  browser Version 64.0.3282.140 (Official Build) (64-bit).

  I also verified the behavior I describe below on the
  play.dhis2.org/2.28 Sierra Leone demo on the custom form for the Life-
  Saving Commodities Data Set.

  
  Right click on a Data Set with a custom form containing text fields with data 
elements as values.

  Choose Design data entry form

  Double click on any of the input fields.

  The Text Field Properties pop up window should appear.

  Change one or more of the following values: Name, Value, Character Width, 
Maximum Characters, Type, Required
(I set the Width to 1 for test purposes.)

  Choose OK

  Click big blue Save button (Very important!)

  Clear browser cache and dhis2 cache.

  Navigate to the form in the Data Entry section.

  Verify the changes were saved and are now part of the form.

  Now go back to the Data Set’s Design data entry form and open the Text
  Field Properties pop up window for the field you changed.  The values
  are all empty or defaults.

  Clicking on Cancel and saved values will not be overwritten.

  However, when developing and laying out custom forms, developers will
  need to usually change these values repeatedly.  Not seeing the saved
  values with every iteration is a major impediment to developing custom
  forms.

  Having said all that, I am very impressed with dhis2!

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1748325/+subscriptions

___
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] Catalina Error

2018-02-08 Thread gerald thomas 
Dear All,
I had been receiving these errors in my catalina logs and i don't know how
to fix or correct this error.

* ERROR 2018-02-08 20:54:31,592 ERROR: duplicate key value violates unique
constraint "datavalue_pkey"
  Detail: Key (dataelementid, periodid, sourceid, categoryoptioncomboid,
attributeoptioncomboid)=(1959, 8293416, 1248, 13, 13) already exists.
(SqlExceptionHelper.java [tomcat-http-218])
* ERROR 2018-02-08 20:54:31,593 HHH000346: Error during managed flush
[could not execute statement] (SessionImpl.java [tomcat-http-218])
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; constraint [datavalue_pkey]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not execute
statement


Please can someone help




-- 
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] [Dhis2-users] DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

2018-02-08 Thread gerald thomas 
Dear Isaiah,
I am sure this is a bug. Knut had already asked Stanley to a ticket of this
issue on http://jira.dhis2.org/ We will continue to do follow up on this
issue there.

On Thu, Feb 8, 2018 at 6:36 PM, Isaiah Nyabuto 
wrote:

> Hi Stanley and Dear dhis2 community.
>
> I have been in the same situation and its now two days while still trying
> to figure out why some of my data elements are not showing values in the
> pivot table.
>
> Maybe my set up is different. I have data elements assigned into a data
> set with category combination. My data elements are using the default
> category combo -after I was unable to assign categories combo to the data
> elements.
>
> I posted some data into the data elements while following the section on:
> sending datavalues in the dhis2 developers guide. My API client returns a
> status code: 200, meaning that data was successfully sent.
>
> So when I run analytics, there are only few data elements displaying data
> on the pivot table. I have tried to rerun the analytics and cleared cache
> several times, there is no change.
>
> Maybe this is an issue with dhis2 version 2.28? I do understand.
>
> I need help.
>
> Thank you.
> ==
> Isaiah Nyabuto
> +254729572616 <+254%20729%20572616>
> Bsc. Health Records Management and Informatics
>
> On Feb 6, 2018 14:12, "Stanley Kalyati"  wrote:
>
>> Hi All,
>>
>> I posted something similar sometime two weeks ago.
>>
>> I have data elements whose value type is number and aggregation type is
>> Sum.I created a data set and assigned it to the Organisation unit.
>>
>> I captured data and run analytics.When i run the pivot tables,no data
>> values.
>>
>> However,when i add a Category Combination which is an attribute to the
>> data set,enter data and run pivot tables,data is there.
>>
>> I am confused.
>>
>> Anyone with an idea?
>>
>> Thank you
>>
>>
>> ___
>> 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-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

[Dhis2-devs] Date for 2.28 mobile app release

2018-02-08 Thread Edward Robinson 
Hi, apologies if I missed it, but I'm curious about the planned date for 
release of the 2.28 mobile application.  Is there an estimated release date?
Thanks!
Ed
___
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] DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

2018-02-08 Thread Knut Staring 
Hi Andrey,

Please report this in JIRA: http://jira.dhis2.org/

Thanks,
Knut

On 2/8/18, Andrey Kolpakov  wrote:
> Hi, Gerald and Stanley.
>
> I have the same issue, data can not be aggregated. Tried everything
> (regenerate reporting, clear cache).
>
> I've tried it on the official demo server (https://play.dhis2.org/2.27/).
> Version 2.26 works as expected, but not 2.27 and 2.28.
> Here are steps to reproduce:
> https://docs.google.com/document/d/1mRjfBvVfwqjxz9c0JotRIlQMJK4wV5V7qf6wEkskkrc/edit
> 
>
> Will be appreciated for any help
>
>> On 6 Feb 2018, at 13:47, gerald thomas  wrote:
>>
>> Stanley,
>> It simply means your data is based on those category combinations that is
>> why you are seeing them. Please share a print screen of that data set
>> whose data elements you pivoting for now.
>>
>> On Tue, Feb 6, 2018 at 12:33 PM, Stanley Kalyati > > wrote:
>> Hi Gerald,
>>
>> I have run analytics,i have also gone to data admin and also cleared catch
>> but no results.
>>
>> Only when i add a category combination to the data set,that is when i am
>> able to see data when i run pivot or data visualizer.
>>
>> I cant understand
>>
>> On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas > > wrote:
>> Stanley,
>> Please run analytics and check your pivot tables again.
>>
>> On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati > > wrote:
>> Hi All,
>>
>> I posted something similar sometime two weeks ago.
>>
>> I have data elements whose value type is number and aggregation type is
>> Sum.I created a data set and assigned it to the Organisation unit.
>>
>> I captured data and run analytics.When i run the pivot tables,no data
>> values.
>>
>> However,when i add a Category Combination which is an attribute to the
>> data set,enter data and run pivot tables,data is there.
>>
>> I am confused.
>>
>> Anyone with an idea?
>>
>> Thank you
>>
>>
>> ___
>> 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
>> 
>>
>>
>>
>>
>> --
>> 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
>
>


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

___
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] DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

2018-02-08 Thread Andrey Kolpakov 
Hi, Gerald and Stanley.

I have the same issue, data can not be aggregated. Tried everything (regenerate 
reporting, clear cache).

I've tried it on the official demo server (https://play.dhis2.org/2.27/). 
Version 2.26 works as expected, but not 2.27 and 2.28.
Here are steps to reproduce: 
https://docs.google.com/document/d/1mRjfBvVfwqjxz9c0JotRIlQMJK4wV5V7qf6wEkskkrc/edit
 


Will be appreciated for any help

> On 6 Feb 2018, at 13:47, gerald thomas  wrote:
> 
> Stanley,
> It simply means your data is based on those category combinations that is why 
> you are seeing them. Please share a print screen of that data set whose data 
> elements you pivoting for now.
> 
> On Tue, Feb 6, 2018 at 12:33 PM, Stanley Kalyati  > wrote:
> Hi Gerald,
> 
> I have run analytics,i have also gone to data admin and also cleared catch 
> but no results.
> 
> Only when i add a category combination to the data set,that is when i am able 
> to see data when i run pivot or data visualizer.
> 
> I cant understand
> 
> On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas  > wrote:
> Stanley,
> Please run analytics and check your pivot tables again.
> 
> On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati  > wrote:
> Hi All,
> 
> I posted something similar sometime two weeks ago.
> 
> I have data elements whose value type is number and aggregation type is Sum.I 
> created a data set and assigned it to the Organisation unit.
> 
> I captured data and run analytics.When i run the pivot tables,no data values.
> 
> However,when i add a Category Combination which is an attribute to the data 
> set,enter data and run pivot tables,data is there.
> 
> I am confused.
> 
> Anyone with an idea?
> 
> Thank you
> 
> 
> ___
> 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 
> 
> 
> 
> 
> 
> -- 
> 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

___
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] Access Tracker capture program stage data through API

2018-02-08 Thread Andrey Kolpakov 
Hi, Georgi

Here is example:
https://play.dhis2.org/2.27/api/27/events.json?orUnit=ImspTQPwCqd&program=IpHINAT79UW
 


Or it can be retrieved for each tracker entity:
https://play.dhis2.org/2.27/api/27/events.json?trackedEntityInstance=PlHxepospot
 


> On 5 Feb 2018, at 17:20, Georgi Chakarov  wrote:
> 
> Hi all,
>  
> Can anyone tell me what is the query to read all data entered in a Tracker 
> capture program stage?
>  
> We have tried this:
> /api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc  
> and other versions like 
> /api/26/events.json?orgUnit=YuQRtpLP10I&ouMode=CHILDREN but we get the result 
> below. Your feedback is highly appreciated!
>  
>  
> 
>  
> Georgi
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> 
>  
> ___
> 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] Program Indicator using data from multiple event stages to find TEA

2018-02-08 Thread Aaron C White 
Hi all,

I'm trying to create a program indicator (or just query to the API
directly) that evaluates conditions on data elements from two different
event stages and then be used to find a relevant tracked entity attribute.

>From the docs, it seems that a program indicator type of enrollment would
be most appropriate, but this only works at the aggregate level and not at
an individual tracked entity instance level.  When I use an event type
indicator, I don't receive any values back because the indicator definition
contains data from two stages.

Am I correct in this assessment?  Any thoughts on how to get around this?

I've been testing on a v2.28 instance.  A similar reference example from
the demo server would be the "Weight gain(in g) between birth and last
postnatal for Child Programme" program indicator.  The one change would be
that I want to see the weight gain for individual TEIs and view a TEA based
on the weight gain amount instead of the average over all tracked entity
instances.

Thanks in advance,

Aaron

--
Aaron C. White
919.522.5585
___
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