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

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

[Dhis2-users] Catalina Error

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

Re: [Dhis2-users] coordinates not found

[Patrick Albert Chikumba]

Hi Natalie

To which organization units have you imported coordinates? and which ones
are you trying to access in GIS module?

In other words, describe what you have done. May be you are missing
something. Or give example.



On Thu, Feb 8, 2018 at 6:57 PM, Natalie Tibbels  wrote:

> ​Hi all,
>
> Trying to set up GIS in my DHIS2 instance. The GML import is successful,
> but then when I try to add the layer in GIS, it says "valid coordinates not
> found". Any ideas of what to check?
>
> Thanks,
>
> Natalie
>
>
>
> ---
> *Natalie Tibbels, MSPH*
> Senior Research Assistant
> 410.370.5048 (cell) • natalietib (Skype)
>
> Johns Hopkins Bloomberg School of Public Health
> Center for Communication Programs • ccp.jhu.edu
>
>
> ___
> 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
>
>


-- 
Patrick Albert Chikumba
Computing & IT Department - The Malawi Polytechnic
+265 885 123 533, patrick_chiku...@yahoo.com

PhD Student
University of Oslo - Dept. of Informatics
OSLO, Norway
Cell: +47 9575 4367
Email: patr...@ifi.uio.no
___
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] Possibility of creating non numerical UID prefixes in tracker capture

[Isaiah Nyabuto]

Hi Aimee,

What is the length of the UIDs? The dhis2 accepts UID length of 11 and can
accept any other types (letters and numbers) so long as the first one is a
letter.

If you want to avoid duplication of UID, the easiest way is by generating
them yourself using other tools or languages.
See the following example on UID generation.
https://github.com/jason-p-pickering/dhis2-data-munging/blob/master/bootstrap/bootstrap.Rmd

Thank you.
==
Isaiah Nyabuto
+254729572616
Bsc. Health Records Management and Informatics


On Feb 8, 2018 16:32, "Aimee Edmondo"  wrote:

Greetings all,
In Zambia we are investigating the possibility of having sub instances of
tracker capture that feed into a main instance, but we want to avoid the
issue of duplicate UIDs coming from the sub instances. We were hoping to
add a prefix onto the automatic UID generation - such as NG###, where
the prefix "NG" remains consistent and the numbers are automatically
generated. We've experimented with the UID options and the system does not
accept this pattern. Has anyone successfully done this before or have any
ideas as to how to do this?
Thanks,
*Aimee Edmondo, MPH* | Informatics Associate
aedmo...@akros.com  | +260.976.076524

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

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


-- 
Regards,

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

[Isaiah Nyabuto]

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

[Dhis2-users] coordinates not found

[Natalie Tibbels]

?Hi all,

Trying to set up GIS in my DHIS2 instance. The GML import is successful, but 
then when I try to add the layer in GIS, it says "valid coordinates not found". 
Any ideas of what to check?

Thanks,

Natalie


---
Natalie Tibbels, MSPH
Senior Research Assistant
410.370.5048 (cell) * natalietib (Skype)

Johns Hopkins Bloomberg School of Public Health
Center for Communication Programs * ccp.jhu.edu

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

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

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

[Andrey Kolpakov]

Hi, Georgi

Here is example:
https://play.dhis2.org/2.27/api/27/events.json?orUnit=ImspTQPwCqd=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=eBAyeGv0exc  
> and other versions like 
> /api/26/events.json?orgUnit=YuQRtpLP10I=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-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] Program Indicator using data from multiple event stages to find TEA

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

[Dhis2-users] Possibility of creating non numerical UID prefixes in tracker capture

[Aimee Edmondo]

Greetings all,
In Zambia we are investigating the possibility of having sub instances of
tracker capture that feed into a main instance, but we want to avoid the
issue of duplicate UIDs coming from the sub instances. We were hoping to
add a prefix onto the automatic UID generation - such as NG###, where
the prefix "NG" remains consistent and the numbers are automatically
generated. We've experimented with the UID options and the system does not
accept this pattern. Has anyone successfully done this before or have any
ideas as to how to do this?
Thanks,
*Aimee Edmondo, MPH* | Informatics Associate
aedmo...@akros.com  | +260.976.076524
___
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 use condition

[Victor Tabu]

Hello Team,

Could you tell me if I can use logic function like and,or in 
d2:condition('bool-expr',true-val,false-val) because when I try I get this 
message

[cid:image002.jpg@01D3A0E8.0D0EFFE0]

Thank you for your help

-
Victor TABU TSHIBAMBULA
Adminstrateur Gestionnaire du Système d'Information - Kinshasa
Tel: + (243) 814784184 , VoIP : 243 0301 1096, E-mail: 
vt...@unicef.org, skype : vtabu

Fonds des Nations Unies pour l'Enfance
372, avenue Colonel Mondiba, Kinshasa - Ngaliema
Suivez nous sur Facebook, 
Twitter, Pona Bana et 
http://www.unicef.org/







[cid:image003.jpg@01D37EE0.B5EF0170]


___
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