Re: [Dhis2-devs] Event data values are stored with option code which is not unique

[Busoye Anifalaje]

Hi Jhansi,

Your second suggestion is a good one with slight modification: introduce a 
setting for the option set to enforce unique option codes. This makes it 
optional per option set. The reason for this is that there are use cases where 
the option code is used as a value for example If the option set are possible 
answers to a question. The right answer (option) may have a code of 1 while all 
the alternative options will be assigned 0. In this case it is not essential to 
distinguish between the options just that one option was right while the rest 
were wrong. 

If the devs go ahead with your second suggestion, they will be introducing 
another problem. So making uniqueness of option codes optional would provide a 
more robust solution and flexibility.

Cheers.

- -




Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

> On 6 May 2017, at 09:47, jhansirk  wrote:
> 
> Hello DHIS Devs,
> 
> In DHIS, event capture app while registering an event, we have noticed that 
> the event dataValues (for the dataElements with optionSet) are posted with 
> the selected option code. Similarly, in the event list the event data values 
> are mapped with the option code to show the selected option.
> 
> We see a small problem with this approach, since, option code in option is 
> not a unique value, which means there is a possibility of two options having 
> the same option code leading to ambiguity in finding the selected option. 
> 
> Instead, we think it should be either of these two:
> - In Event capture, event data values should be saved with some unique option 
> property (like option id) instead of option code. But, this would be a very 
> huge migration, since, all the existing event data values should be changed 
> from option code to option id.
> - In Option, code should be made unique and there should be validations in 
> option creation form to ensure option code is unique. This would be the 
> simpler change to implement and our preferred solution to this issue.
> 
> Thanks,
> Jhansi
> ___
> 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] [Dhis2-users] Program Indicators

[Busoye Anifalaje]

Hi Seth,

You should try using the code instead of the label name. Version 2.22 also has 
a code.



- -



Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

> On 12 Jan 2017, at 12:28, Seth Okeyo  wrote:
> 
> Hi Busoye
> I'm using the label name for option set... we are running version 2.22.
> Regards
> 
> Seth Okeyo <>| Data Management Officer
> Drugs for Neglected Diseases initiative – Africa Regional Office
> Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani|  P.O. Box 21936 - 
> 00505| Nairobi | Kenya
> T: +254 020 3995000 | M: +254 727 389 149| sok...@dndi.org 
> <mailto:sok...@dndi.org> | skype: dndi_seth.okeyo
> Best Science for the Most Neglected | www.dndi.org <http://www.dndi.org/>
> From: Busoye Anifalaje 
> Sent: Thursday, January 12, 2017 2:56:53 PM
> To: Seth Okeyo
> Cc: dhis2-users; Dhis2-devs; DHIS 2 developers; Groupe Francophone du DHIS 2; 
> GROUT, Lise
> Subject: Re: [Dhis2-users] Program Indicators
>  
> Hi Seth,
> 
> Are you are using the code for the option set value instead of the label name?
> 
> Cheers,
> 
> - -
> 
> 
> Busoye Anifalaje (PhD)
> Director of Services (Principal), BAO Systems
> UK: +44 7901-740-757 | US: +1 682-307-0986|
>  bus...@baosystems.com <mailto:bus...@baosystems.com> | 
> http://www.baosystems.com <http://www.baosystems.com/> |
> Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007
> 
>> On 12 Jan 2017, at 11:52, Seth Okeyo > <mailto:sok...@dndi.org>> wrote:
>> 
>> Hello,
>> I'm developing Program indicators using data elements with Option sets, for 
>> example "Gender" with options "Male and Female", when I follow the manual by 
>> putting it like this:
>> 
>> expression:(event_count)
>> 
>> filter:
>> #{yUVXpYVeY6I.Z8W89lDV4IL} =='Male'
>> 
>> (Demographics, Admission and Treatment.Gender =='Male')
>> 
>> the data visualization returns empty results, is there something I'm not 
>> doing right?
>> 
>> regards.
>> 
>> Seth Okeyo <>| Data Management Officer
>> Drugs for Neglected Diseases initiative – Africa Regional Office
>> Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani|  P.O. Box 21936 - 
>> 00505| Nairobi | Kenya
>> T: +254 020 3995000 | M: +254 727 389 149| sok...@dndi.org 
>> <mailto:sok...@dndi.org> | skype: dndi_seth.okeyo
>> Best Science for the Most Neglected | www.dndi.org <http://www.dndi.org/>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] [Dhis2-users] Program Indicators

[Busoye Anifalaje]

Hi Seth,

Are you are using the code for the option set value instead of the label name?

Cheers,

- -



Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

> On 12 Jan 2017, at 11:52, Seth Okeyo  wrote:
> 
> Hello,
> I'm developing Program indicators using data elements with Option sets, for 
> example "Gender" with options "Male and Female", when I follow the manual by 
> putting it like this:
> 
> expression:(event_count)
> 
> filter:
> #{yUVXpYVeY6I.Z8W89lDV4IL} =='Male'
> 
> (Demographics, Admission and Treatment.Gender =='Male')
> 
> the data visualization returns empty results, is there something I'm not 
> doing right?
> 
> regards.
> 
> Seth Okeyo <>| Data Management Officer
> Drugs for Neglected Diseases initiative – Africa Regional Office
> Tetezi Towers, 3rd Floor, George Padmore Road, Kilimani|  P.O. Box 21936 - 
> 00505| Nairobi | Kenya
> T: +254 020 3995000 | M: +254 727 389 149| sok...@dndi.org 
> <mailto:sok...@dndi.org> | skype: dndi_seth.okeyo
> Best Science for the Most Neglected | www.dndi.org <http://www.dndi.org/>
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to : dhis2-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp 
> <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] [Dhis2-users] DHIS 2 (Version 2.23): Data doesn't display in DHIS Pivot table even after running analytics

[Busoye Anifalaje]

Hi Fred,
I actually thought about it after sending the initial email. If the same user 
can see the data in data set reports, there really shouldn’t be a reason not to 
see the data in pivot tables unless there are parameters you have added in 
pivot tables which weren’t in the data set report. 

Can you shed some light on what kind of table you are trying to create? 
Indicators, data elements, category dimension, org unit group dimension etc

Cheers

- -



Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

> On 10 Jan 2017, at 19:28, Fredrick Onyango  wrote:
> 
> Thanks Busoye,
> 
> I appreciate the feedback.
> 
> I've checked the dimension restrictions for data analytics and none is 
> selected.
> 
> On the second option,are you referring to the 'sharing settings' on the data 
> elements?Kindly clarify.
> 
> Fred
> 
> 
> 
> On Tue, Jan 10, 2017 at 9:44 PM, Busoye Anifalaje  <mailto:bus...@baosystems.com>> wrote:
> Hi Fred,
> 
> It is possible that the user has certain dimension restrictions for analytics.
> 
> Go to Apps -> Users. Select the user that is having problems visualising data 
> in analytics. Edit the User.  Scroll down and select “Show more options”. 
> 
> You should see a section title “Available dimension restrictions for data 
> analytics” (see attached). Check that there are no dimensions selected by 
> mistake. If there are selected dimensions, try deselecting these from the 
> user account and save. Run analytics to check  if  this resolves the problem.
> 
> If it doesn’t then it is possible that you may have other sharing protocols 
> for the data you want to view.
> 
> Hope this helps.
> 
> - -
> 
> 
> 
> Busoye Anifalaje (PhD)
> Director of Services (Principal), BAO Systems
> UK: +44 7901-740-757 | US: +1 682-307-0986|
>  bus...@baosystems.com <mailto:bus...@baosystems.com> | 
> http://www.baosystems.com <http://www.baosystems.com/> |
> Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007
> 
> 
> 
>> On 10 Jan 2017, at 18:32, Fredrick Onyango > <mailto:deefr...@gmail.com>> wrote:
>> 
>> Hi All,
>> 
>> I'm not able to view data on the Pivot table.
>> The data entered is however visible on the data entry screens and on the 
>> data set report but not on the DHIS 2 Pivot Table.
>> 
>> I've cleared the cache on Mozilla/Chrome and run analytics.Data mart jobs 
>> are scheduled to run every night at midnight.
>> 
>> Data is visible on PostgreSQL data value table.
>> 
>> Also noticed a message "(user) constrained by dimension" on the tomcat logs 
>> when attempting to access data on the pivot.
>> 
>> Please assist,
>> 
>> Fred
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] [Dhis2-users] DHIS 2 (Version 2.23): Data doesn't display in DHIS Pivot table even after running analytics

[Busoye Anifalaje]

Hi Fred,

It is possible that the user has certain dimension restrictions for analytics.

Go to Apps -> Users. Select the user that is having problems visualising data 
in analytics. Edit the User.  Scroll down and select “Show more options”. 

You should see a section title “Available dimension restrictions for data 
analytics” (see attached). Check that there are no dimensions selected by 
mistake. If there are selected dimensions, try deselecting these from the user 
account and save. Run analytics to check  if  this resolves the problem.

If it doesn’t then it is possible that you may have other sharing protocols for 
the data you want to view.

Hope this helps.

- -



Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007


> On 10 Jan 2017, at 18:32, Fredrick Onyango  wrote:
> 
> Hi All,
> 
> I'm not able to view data on the Pivot table.
> The data entered is however visible on the data entry screens and on the data 
> set report but not on the DHIS 2 Pivot Table.
> 
> I've cleared the cache on Mozilla/Chrome and run analytics.Data mart jobs are 
> scheduled to run every night at midnight.
> 
> Data is visible on PostgreSQL data value table.
> 
> Also noticed a message "(user) constrained by dimension" on the tomcat logs 
> when attempting to access data on the pivot.
> 
> Please assist,
> 
> Fred
> ___
> 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

Re: [Dhis2-devs] Org. unit tree is not open with org. units selected (datasets, orgunit groups, etc.)

[Busoye Anifalaje]

+1 

- -



Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

> On 3 Nov 2016, at 11:07, Jose Garcia Muñoz  wrote:
> 
> 
> Hi devs,
> 
> I believe we have already talked about this... So right now, it is difficult 
> to know the org. units that are selected for a particular dataset/org. unit 
> group/etc (see attached image).
> 
> I think you are going to change the behaviour of this... Is this something we 
> could have in the following days? (it is a bit complicated to manage when you 
> have more than 40.000 org. units in the system :) ).
> 
> It will be nice to have this fix for 2.24 and 2.25.
> 
> Thanks
> Jose
> 
> 
> 
> ___
> 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] Restricting Data Set assignment through User Role doesn't work for a user with 'ALL' authority

[Busoye Anifalaje]

Hi Archana,

This is expected behaviour with the ‘ALL’ authority. You would not be able to 
restrict access to most objects created for a user with All authority in their 
user role. This is what distinguishes the default Superuser role from the rest. 

The only instance I am aware of that the All authority is restricted by default 
is with Dashboard created as private.

I think the idea is that the All authority allows a sys admin to troubleshoot 
most issues without having to request access from a user that might either not 
be able to provide the access required or does not know how to.
  

Hope that helps.

Regards,

- -



Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

> On 17 Aug 2016, at 07:31, Archana Chillala  wrote:
> 
> Hi,
> 
> We are working on DHIS version 2.24 (revision - 23565). We are testing the 
> behaviour of restricting data Sets through User Roles. We have created a user 
> role with all the authorities, except 'ALL' authority. And did not assign any 
> data Sets to this user role. Then we assigned the role to a user. So, when 
> the user is logged in, and opens data entry app, and goes to the right 
> organisation unit where that particular data set is assigned to, the user 
> cannot find any data sets. This is the expected behaviour. However, we 
> modified the user role, by giving only the 'ALL' authority now (no other 
> authorities are given). And tested the same again. Now, the user is able to 
> see the data set in the data entry app, even if the data set is not assigned 
> to the user role. Is this expected of the user who has "ALL" authority? Or a 
> bug?
> 
> Any help here would be appreciated.
> 
> 
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com <mailto:archa...@thoughtworks.com>
> Telephone +91 9100960533 
>  
> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
> ___
> 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] Android aggregated app updates updates datavalues but not datavalueaudit and dataset report not showing changed values

[Busoye Anifalaje]

Hi Elmarie,

Did you run Analytics after you update the data values? This would be necessary 
to update your data set report. 

Regards

- -



Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

> On 12 Jul 2016, at 08:05, Elmarie Claasen  wrote:
> 
> Hi all,
>  
> We are testing an implementation of the latest android apk against 2.20 
> instance capturing aggregated data values weekly for a campaign dataset. 
> From our testing the following:
>  
> 1.  Capturing data on the apk posted data to DHIS2. 
> 2.  Running a dataset report and viewing the data in the UI and pulling a 
> SQL view all showed consistent data values
> 3.  Updating datavalues on the apk updated the datavalues in the 
> datavalue table but did not update the datavalueaudit. Dataset report did not 
> pull the updated values but still showed the first captured values even after 
> clearing cache in every possible way. SQL view of the datavalue table shows 
> that the data is updated. 
> 4.  Updating datavalues in the UI updated datavalues in the datavalue, 
> datavalue audit table and the dataset report. 
>  
> Is the fact that the datavalue audit table is not updated when editing values 
> in the apk a bug?
> Where does the dataset report pull data from if not the datavalue table and 
> why is it not displaying the correct value – is this a bug?
>  
> Regards,
>  
> Elmarie Claasen
> 
> Project Manager
> Health Information Systems Program
> Tel:  041-367 1027
> Cell: 082 374 2209
> E-mail: elma...@hisp.org <mailto:elma...@hisp.org>
> Skype:  elmarie.claasen52 
>  
>  
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer  
> <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  <mailto: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. 
> 
>  
> 
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer 
> <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 <mailto: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 
> <https://launchpad.net/~dhis2-devs>
> Post to : dhis2-devs@lists.launchpad.net 
> <mailto:dhis2-devs@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-devs 
> <https://launchpad.net/~dhis2-devs>
> More help   : https://help.launchpad.net/ListHelp 
> <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] Data capturer - Events: Authorisation privilege missing

[Busoye Anifalaje]

Hi Calle,
Have you added the event program to the role. The ALL authority is not a
summation of all other permissions but a special designation that provides
access to grant access to all apps and privately created objects (with the
exception of dashboards).

Hope that helps.

Cheers,
Busoye
On 6 Jul 2016 2:00 p.m., "Calle Hedberg"  wrote:

> Hi
>
> Small correction: we have now ascertained that if the Data Capturer -
> Events have every single authorisation selected (except ALL), it does NOT
> work. If we on the other hand select ALL, then it works.
>
> What is the difference between ALL and the sum of all individual
> authorisations?
>
> regards
> callee
>
> On 6 July 2016 at 12:35, Calle Hedberg  wrote:
>
>> Hi,
>>
>> We have an instance with an Event program and a user role called "Data
>> Capturer - Events" with the following authorisations - but one or more is
>> missing:
>>
>> Add/Update event
>> Add/Update Tracked Entity
>> Add/Update Tracked Entity Data Value
>> Delete Data Value
>> Generate Min-Max Value
>> Run validation
>> See Browser Cache Cleaner module
>> See Dashboard Intergration Module
>> See even Capture Module
>> See Event Report Module
>> See Event Visualiser module
>> See GIS Module
>> See Pivot table module
>> See report module
>> See validation rule
>>
>> Something is missing, though - when a data capturer opens the Event
>> Capture app and selects an orgunit with a number of pre-existing events,
>> nothing is showing. Also when selecting "Register event", all the drop-down
>> option sets with a large number of options are blank.
>>
>> If I add ALL to the user role, or if I add all the individual
>> authorisations, everything works fine.
>>
>> Two questions:
>>
>> 1. Can anybody see which authorisation(s) is/are missing in the list
>> above?
>>
>> 2. Where can I find an overview of all authorisations in the system with
>> a detailed explanation of (a) what exactly that authorisation provides
>> access to and (b) what authorisations have an impact on which areas
>> (routine data capture/use, event data capture/use, tracker data
>> capture/use).
>>
>> Best regards
>> Calle
>>
>> ***
>>
>> 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
>>
>> ***
>>
>>
>
>
> --
>
> ***
>
> 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
>
>

-- 


*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

Re: [Dhis2-devs] Hiding a category in a pulldown list

[Busoye Anifalaje]

Hi Laura,

To limit access to the category option for data entry, one option would be to 
achieve this through sharing. You can

1) Go to the category option sharing
2) Set public to none

For reporting purposes, you can create a category option group and category 
option group set. These can either be public (view only would be fine) or share 
with relevant user groups if relevant. 

I am assuming that you are referring to data set category options. So, 
Categories with Attribute Data Dimension Type.

Hope this helps.

Best regards,

Busoye

> On 7 Jun 2016, at 11:44, Laura E. Lincks  
> wrote:
> 
> Version:2.21
> Build revision:21018
> 
> ​(We'll be upgrading to 2.23 soon)
> 
> We wish to import historical data into a Category at the dataset level. This 
> option need only exist for historical purposes... no new data will be entered 
> into this category going forward. We would like to prevent users from 
> accessing this category option when performing data entry  (but still have 
> access to the other options in this same category) going forward. Is there a 
> way to hide this one option from the data entry screen but enable it for 
> reporting historical data along with current data? 
> 
> Laura E. Lincks <>
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
> 
> ___
> 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 Indicators: Legend Sets Association not rendering in Event Report

[Busoye Anifalaje]

Hi devs,

I associated a legend set to a Program Indicator but this does not render in 
event reports. Is this supported? If not, are their plans to support this 
functionality. It is quite critical to one of our implementation projects.

To replicate on the demo server

1) Add a legend set to Average weight (Child Health) program indicator

2) Go to event report

3) Select Average Weight indicator from Child Health -> “No Range Set” 

Tried with Apgar Score Data Element and this works. See attached file for 
comparison.

Thanks


This affects

Version 2.22 (22016)
Version 2.23 (22905)


--


Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
+44 7901-740-757 | bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007
___
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] [Bug 1578302] [NEW] Program Indicators issue in DHIS2

[Busoye Anifalaje]

To add to this description

If a data element is in more than one (non-repeated) program stage and a 
program indicator is created for one of those program stages, the pivot table 
returns calculated values for all program stages. 

This makes it extremely limited to reused data elements across program stages. 

Thanks

Version: 2.23, 2.22 and 2.21




> On 4 May 2016, at 17:31, Jhonson Charles  wrote:
> 
> Public bug reported:
> 
> For a Data Element (DE) present in more than 1 program stage, if you
> create a program indicator for each stage using that DE. the system use
> the first value entered in the first stage to compile the result and
> does not take into account the other value entered in the other stage.
> 
> Let's take as example:
> 
> Women weight  for a particular  MNCH Program, which is collected at each 
> women visit. if you create an indicator for each stage using that DE value 
> collected in each stage, the system will only use the first value entered 
> during the first visit for all the other 
> follow up visit
> 
> I understand  if a program indicator is created for a specific program
> stage, that should be ideally respected in analytics.
> 
> Please let us know if this is the  behavior you expected  this to have.
> 
> Best
> 
> ** 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/1578302
> 
> Title:
>  Program Indicators issue in DHIS2
> 
> Status in DHIS:
>  New
> 
> Bug description:
>  For a Data Element (DE) present in more than 1 program stage, if you
>  create a program indicator for each stage using that DE. the system
>  use the first value entered in the first stage to compile the result
>  and does not take into account the other value entered in the other
>  stage.
> 
>  Let's take as example:
> 
>  Women weight  for a particular  MNCH Program, which is collected at each 
> women visit. if you create an indicator for each stage using that DE value 
> collected in each stage, the system will only use the first value entered 
> during the first visit for all the other 
>  follow up visit
> 
>  I understand  if a program indicator is created for a specific program
>  stage, that should be ideally respected in analytics.
> 
>  Please let us know if this is the  behavior you expected  this to
>  have.
> 
>  Best
> 
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1578302/+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

___
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] Delete a bad enrollment

[Busoye Anifalaje]

Thanks Abyot. Checked and the orgunit is consistent and there is no other 
active enrollment. 

So the main issue here is that the report is no longer editable. If you need 
access to have a closer look I can send a link to you separately.


--


Busoye Anifalaje (PhD)
Director of Services, BAO Systems
+44 7901-740-757 | bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

> On 22 Mar 2016, at 17:05, Abyot Asalefew Gizaw  wrote:
> 
> Hi Busoye,
> 
> I can't remember which version ... but check this
> 
> - see if you are trying to access the data (enrollment + event) from the same 
> orgunit that has collected it
> - see if there is no other active enrollment going on for the selected person 
> (or tracked entity instance)
> 
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org <http://www.dhis2.org/>
> On Tue, Mar 22, 2016 at 6:01 PM, Busoye Anifalaje  <mailto:bus...@baosystems.com>> wrote:
> Hi Abyot,
> 
> I am having problems enrolling a tracked entity instance into a program. This 
> is even though multiple program stages had previously been completed for the 
> same instance. After completion, I understand that the user clicked on 
> complete enrolment. After this it has been impossible to access the data 
> previously entered or to re-enrol into the program. When I try a new 
> enrolment I get a 500 in the console (below). This doesn’t happen in all 
> cases but I haven’t been able to trace the root of this particular problem.
> 
> Any ideas where to look to resolve this issue?
> 
> Thanks
> 
> --
> 
> 
> Busoye Anifalaje (PhD)
> Director of Services, BAO Systems
> +44 7901-740-757 | bus...@baosystems.com <mailto:bus...@baosystems.com> | 
> http://www.baosystems.com <http://www.baosystems.com/> |
> Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007
> 
> 
> 
> 
> 
>> On 22 Mar 2016, at 11:18, Abyot Asalefew Gizaw > <mailto:ab...@dhis2.org>> wrote:
>> 
>> Hi Pepe,
>> 
>> We do not have a delete button at the moment. What you could do is use the 
>> "Cancel" button to cancel an enrollment. It will still be there, but you 
>> won't be able to enter data to it.
>> 
>> --
>> Abyot A. Gizaw.
>> Senior Engineer, DHIS2
>> University of Oslo
>> http://www.dhis2.org <http://www.dhis2.org/>
>> On Tue, Mar 22, 2016 at 6:18 AM, Pepe Ken Mvulu > <mailto:pepeken...@gmail.com>> wrote:
>> Hi All,
>> How we can delete a bad enrollment of org.unit in the tracker capture ?
>> I can not find a "delete OrgUnit" button in the new version of the tracker
>> I use the V2.21
>> Build: 21025
>> All ideas are welcome
>> Regards !
>> 
>> Pepe Ken Mvulu
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] [Dhis2-users] Delete a bad enrollment

[Busoye Anifalaje]

Just to confirm software details:

Version:
2.22
Build revision:
21939





--


Busoye Anifalaje (PhD)
Director of Services, BAO Systems
+44 7901-740-757 | bus...@baosystems.com <mailto:bus...@baosystems.com> | 
http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

> On 22 Mar 2016, at 17:01, Busoye Anifalaje  wrote:
> 
> Hi Abyot,
> 
> I am having problems enrolling a tracked entity instance into a program. This 
> is even though multiple program stages had previously been completed for the 
> same instance. After completion, I understand that the user clicked on 
> complete enrolment. After this it has been impossible to access the data 
> previously entered or to re-enrol into the program. When I try a new 
> enrolment I get a 500 in the console (below). This doesn’t happen in all 
> cases but I haven’t been able to trace the root of this particular problem.
> 
> Any ideas where to look to resolve this issue?
> 
> Thanks
> 
> --
> 
> 
> Busoye Anifalaje (PhD)
> Director of Services, BAO Systems
> +44 7901-740-757 | bus...@baosystems.com <mailto:bus...@baosystems.com> | 
> http://www.baosystems.com <http://www.baosystems.com/> |
> Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007
> 
> 
> 
> 
> 
>> On 22 Mar 2016, at 11:18, Abyot Asalefew Gizaw > <mailto:ab...@dhis2.org>> wrote:
>> 
>> Hi Pepe,
>> 
>> We do not have a delete button at the moment. What you could do is use the 
>> "Cancel" button to cancel an enrollment. It will still be there, but you 
>> won't be able to enter data to it.
>> 
>> --
>> Abyot A. Gizaw.
>> Senior Engineer, DHIS2
>> University of Oslo
>> http://www.dhis2.org <http://www.dhis2.org/>
>> On Tue, Mar 22, 2016 at 6:18 AM, Pepe Ken Mvulu > <mailto:pepeken...@gmail.com>> wrote:
>> Hi All,
>> How we can delete a bad enrollment of org.unit in the tracker capture ?
>> I can not find a "delete OrgUnit" button in the new version of the tracker
>> I use the V2.21
>> Build: 21025
>> All ideas are welcome
>> Regards !
>> 
>> Pepe Ken Mvulu
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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

___
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] 2.23 Metadata importer rewrite and dryRuns

[Busoye Anifalaje]

Since there is no rollback feature we rely on the dry run to test imports
before actually importing. If you will replace with a comparable feature
then great otherwise please let it live through the next season.

Thanks.

Busoye
On 2 Feb 2016 08:19, "Pamod Amarakoon"  wrote:

> Hi Morten,
>
> We are using metaData import frequently when transferring data back and
> forth in running instances. Dry Run feature is almost always used just to
> check any incompatibility before actual transfer. So it's quite useful.
>
> On Tue, Feb 2, 2016 at 1:45 PM, Morten Olav Hansen 
> wrote:
>
>> Hi everyone
>>
>> I'm currently in the process of re-writing our DXF2 metadata importer,
>> and was wondering if anyone is actually using the dryRun option? its adds
>> quite a bit of complexity to the code, so it will be added only to the new
>> importer if people are actually using it for imports
>>
>> --
>> Morten
>>
>> ___
>> 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,
> Pamod Amarakoon
>
> Confidentiality Notice: the information contained in this email and any
> attachments may be legally privileged and confidential. If you are not an
> intended recipient, you are hereby notified that any dissemination,
> distribution, or copying of this e-mail is strictly prohibited. If you have
> received this e-mail in error, please notify the sender and permanently
> delete the e-mail and any attachments immediately. You should not retain,
> copy or use this e-mail or any attachments for any purpose, nor disclose
> all or any part of the contents to any other person.
>
>
>
>
> ___
> 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
>
>

-- 


*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

Re: [Dhis2-devs] Option sets on dhislive 2.22 data capture

[Busoye Anifalaje]

Hi Simon,

I also reported this error you can see description here 
.

Cheers

Busoye


> On 29 Jan 2016, at 09:20, Simon Muyambo  wrote:
> 
> Any one experienced this problem: Data capture failing to list option sets on 
> dhis2 live version 2.22. 
> Where can I download an older version dhislive 2.21?
>  
> Regards
> Simon Muyambo
>  
> 
> 
> __ Information from ESET NOD32 Antivirus, version of virus signature 
> database 12940 (20160128) __
> 
> The message was checked by ESET NOD32 Antivirus.
> 
> http://www.eset.com 
> ___
> 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 
> 

-- 


*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

Re: [Dhis2-devs] Labels for Option sets are not shown in Data Capture App with DHIS 2.22

[Busoye Anifalaje]

Hi Devs,

I am experiencing a similar problem: option labels aren't showing on the web 
UI. 

I am using 

Version:
2.22
Build revision:
21773
Thanks




> On 22 Jan 2016, at 13:18, Knut Staring  wrote:
> 
> Should probably be reported as a bug.
> 
> Knut
> 
> On Fri, Jan 22, 2016 at 4:12 AM, Archana Chillala  > wrote:
> Attaching a screenshot for the same.
> 
> 
> 
> 
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com 
> Telephone +91 9100960533 
>  
> 
> 
> On Fri, Jan 22, 2016 at 8:25 AM, Archana Chillala  > wrote:
> Hi,
> 
> In the Data Capture android app, data elements with option sets show only a 
> blank drop down list with no labels. 
> 
> But the option sets had labels when working with DHIS 2.21
> I am currently using DHIS version 2.22 revision 21763. 
> 
> Could you please fix that.
> 
> 
> Thanks & Regards,
> 
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com 
> Telephone +91 9100960533 
>  
> 
> 
> 
> ___
> 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
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org 
> ___
> 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


-- 


*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

Re: [Dhis2-devs] dhis version 2.21 is released

[Busoye Anifalaje]

Excellent work, dev team!


> On 21 Oct 2015, at 21:03, Lars Helge Øverland  wrote:
> 
> Hi all,
> 
> DHIS version 2.21 is out with a lot of great new features and improvements. 
> 
> Log in with admin/district on the demo  system.
> 
> File cloud storage: You can now upload and store large files directly from 
> data entry forms. Data elements can have a file value type and render as file 
> upload widgets in forms. Files can be stored either on the Web server or sent 
> directly to AWS S3  cloud storage, which in 
> practice provides unlimited storage capacity. This capability allows you to 
> use DHIS 2 as a general document repository which can be utilized for project 
> management, documentation, CMS and many other purposes. 
> 
> File storage currently works for aggregate data entry forms - tracker coming 
> up. Have a look at the “Project management” data set in data entry on the 
> demo:
> 
> Demo  | Docs 
>  
> | Screenshot 
> 
> Settings app: The settings front-end has been re-written as a true app. It 
> features real-time saving, search for settings and a fresh new look.
> 
> Demo  | Docs 
>  | Screenshot 
> 
> 
> Data import constraints: Several optional constraints for data import can be 
> enabled to provide stricter control of the data being imported. These include 
> require period to be of same type as data set, data element to be assigned to 
> data set through org units, and more. The import constraints can be enabled 
> in settings app under “data import”.
> 
> Docs 
> 
> 
> ANALYTICS FEATURES
> ---
> 
> Functions and variables in program indicators: Program indicators support a 
> range of functions and variables. Functions allows for conditional 
> statements, calculation of number of days between dates and more. Variables 
> allows you to insert e.g. event date, enrollment date and value count into 
> expressions. This is useful for example to calculate “inpatient bed days” and 
> complex scores.
> 
> Docs  | Demo 1 
>  | 2 
>  | 
> Screenshot 1 
>  | 2 
>  | 3 
>  | 4 
>  |
> 
> 
> Custom aggregation types: A program indicator now has an aggregation type 
> property with the standard options such as sum, avg, count, std dev min, max. 
> When set to custom, the indicator expression can contain inline aggregation 
> types, allowing for greater control over aggregation.
> 
> Docs  | 
> Screenshot 
> 
> 
> Program indicators and data elements in GIS: The GIS app lets you analyse 
> program indicators, attributes and data elements on maps.
> 
> Demo  
> | Screenshot 1  
> | 2 
> 
> Program indicators in event reports: The individual event overview supports 
> program indicators, which allows you to display calculations per event 
> directly in the overview.
> 
> Demo 
>  
> | Screenshot 
> 
> 
> Download data dump: Pivot table lets you download data in CSV format directly 
> without first rendering the data in the Web browser (which might lead to the 
> browser freezing for large data volumes). This allows you to download much 
> larger batches of data which is useful for later offline analysis.
> 
> Screenshot 
> 
> Complete events only option: All analysis apps provides an option for only 
> including completed events in the aggregation process. This is useful e.g. to 
> exclude partial events in indicator calculations.
> 
> Screenshot 
> 
> 
> Full precision option: Pivot table has an option for “skip rounding” of 
> values, i.e. full precision o

Re: [Dhis2-devs] [Bug 1286687] [NEW] selecting attributes for tracked entity throws exception

[Busoye Anifalaje]

Hi Tran,

Thanks for checking. I have upgraded and just tested again but got the same
Exception. Log copied below. Happy to supply any more details as required.


Thanks

Busoye

Version:

2.15-SNAPSHOT

Build revision:

14131


* ERROR 2014-03-03 13:06:24,859 ERROR: null value in column
"programattributeid" violates not-null constraint

  Detail: Failing row contains (null, null, 1, t, null, null, 232092,
232090). (SqlExceptionHelper.java [http-apr-8080-exec-6])

* ERROR 2014-03-03 13:06:24,859 Error while executing action
(ExceptionInterceptor.java [http-apr-8080-exec-6])

org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; constraint [programattributeid]; nested exception is

org.hibernate.exception.ConstraintViolationException: could not execute
statement

at
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:138)

at
org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:680)

at
org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:562)

at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)

at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)

at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)

at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270)

at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)

at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy32.updateProgram(Unknown Source)

at
org.hisp.dhis.trackedentity.action.program.AddProgramAction.execute(AddProgramAction.java:322)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)

at
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)

at
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:88)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:93)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:97)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:147)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:83)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:81)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at
org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:85)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at
org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:113)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at
org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:108)

at
com.opensymphony.xwork2.DefaultAction

Re: [Dhis2-devs] [Dhis2-users] Entering Monthly Data for Future Periods - beyond December 2013

[Busoye Anifalaje]

Hi Jason,

Your reply was much appreciated.

I had populated the period table with the months I needed and can actually
see this in the pdf data entry version (see attachments from previous
email). The problem I am having is that I can't see these months in the
data entry screen. Is there a way around this or anything else I need to do
to allow the later periods to be visible for data entry?

Many thanks.

Busoye



On 30 September 2013 07:11, Jason Pickering wrote:

> Hi Busoye,
> I think the problem is that these periods have not been generated yet. In
> the past, we have generated them using SQL. Something like
>
>
> INSERT INTO period
> SELECT nextval('hibernate_sequence'::regclass) as periodid ,
> (SELECT periodtypeid from periodtype where name = 'Monthly')  periodtypeid,
>  (startdate + '1 year'::interval)::date as startdate,
>  (enddate + '1 year'::interval)::date as enddate
>  from period
>  where periodtypeid = (SELECT periodtypeid from periodtype where name =
> 'Monthly')
>  and startdate >= '2013-01-01' and enddate <='2013-12-31'
>
> This is a really basic statement, and would not check for things like
> periods which already exist so you might need to tweak it a bit.
>
> There should really be a method to pre-generate future periods, but I am
> not sure this exists.
>
> Regards,
> Jason
>
>
>
>
> On Sun, Sep 29, 2013 at 5:20 PM, Adebusoye Anifalaje wrote:
>
>> Just an update
>>
>> I have added 2014 monthly data to the Period table. I still can't see the
>> periods in the data entry screen (see file attached) but when I use the
>> "Get pdf for Data Entry" function in the data set module, I can see the
>> future periods displayed (see attached).
>>
>> Any insight would be much appreciated.
>>
>> Many thanks.
>>
>> Regards,
>> Busoye
>>
>>
>> On 29 Sep 2013, at 09:17, Adebusoye Anifalaje  wrote:
>>
>> Hi all,
>>
>> Can anyone help with getting around entering monthly data for future
>> periods beyond what is available by default?
>>
>> I have a use case where users need to enter data for months in 2014
>> (these are advance monthly payments) but currently the future periods
>> allowed do not extend beyond December 2013. The "Next Year" function does
>> not make a difference here.
>>
>> It is critical that the data is entered monthly rather than yearly. It is
>> also important that users can enter data in (theoretically) unlimited
>> periods in the future if the case arises that payment is made up until tim
>> "t".
>>
>> Thaks
>>
>> Busoye
>>
>> DHIS2.12
>> Build: 11285
>> ___
>> 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-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