Re: [Dhis2-users] Adding a time lag functionality to DHIS2
Thanks Elmarie, that’s good to know. My problem is how to deal with aggregate data where the period for treatment outcomes of TB cases has been assigned to the period the report was compiled and not the period when the patients were notified (registered). The standard practice in TB is to report outcomes 12 months after cases are notified. We recommend assigning outcomes to the same period in which cases are notified, but we see many countries that don't do that, so I was looking for a DHIS2-native way to compare patient numbers notified with patient numbers with treatment outcomes. Of course with tracker this wouldn't be a problem at all! Cheers, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland From: Elmarie Claasen Sent: 06 November 2018 10:32 To: TIMIMI, Hazim Bakir ; DHIS 2 Users list Subject: RE: [Dhis2-users] Adding a time lag functionality to DHIS2 Hi Hazim, We are also eagerly awaiting the flexibility for indicator expressions. Note that if you are collecting data using tracker and using v2.30 or later you can use the analytics period boundaries in program indicators to set up timelag indicators. [cid:image001.jpg@01D475BD.BD727290] Regards, Elmarie Claasen [Hisp logo] 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 From: Dhis2-users mailto:hisp@lists.launchpad.net>> On Behalf Of TIMIMI, Hazim Bakir Sent: Tuesday, November 6, 2018 11:18 AM To: DHIS 2 Users list mailto:dhis2-users@lists.launchpad.net>> Subject: Re: [Dhis2-users] Adding a time lag functionality to DHIS2 Many thanks Jim. I’m glad this is being looked at and seriously considered. I don’t use DHIS2 regularly, but whenever I do I find it frustrating not to be able to use more flexible expressions such as the ones listed at https://jira.dhis2.org/browse/DHIS2-4469 when defining indicators. Cheers, Hazim From: Jim Grace mailto:j...@dhis2.org>> Sent: 05 November 2018 19:30 To: TIMIMI, Hazim Bakir mailto:timi...@who.int>> Cc: DHIS 2 Users list mailto:dhis2-users@lists.launchpad.net>> Subject: Re: [Dhis2-users] Adding a time lag functionality to DHIS2 Hazim, you are not alone! We are looking at exactly this kind of thing now, based on requests from many users. Just now I've commented on this at https://community.dhis2.org/t/expression-enhancements-to-space-shift-and-time-shift-data/774. In the meantime you might consider the use of predictors that can be used to bring data forward in time and store it in new data elements, which can then be used in indicators alongside current data. This does require new data elements, and storing the same data under two different periods in the database. We hope to be able to avoid this in the future by allowing time-shifting in the indicators themselves, very much like what you saw in the Launchpad blueprint. But using predictors is something you could do today with existing DHIS2 functionality. Cheers, Jim Grace On Mon, Nov 5, 2018 at 5:41 PM TIMIMI, Hazim Bakir mailto:timi...@who.int>> wrote: There are various things we would like to calculate using data from different time periods, such as % change between one period and the next, or to perform cohort analysis. I see this was raised in 2015 (see https://blueprints.launchpad.net/dhis2/+spec/indicator-time-lags). Does anyone have any experience of doing this in DHIS2? I didn’t find anything on JIRA. We surely can’t be the only people wondering about this? Any helpful hints would be most welcome! Thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Jim Grace Core developer, DHIS 2 HISP US Inc. http://www.dhis2.org<https://www.dhis2.org/> 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<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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Adding a time lag functionality to DHIS2
Many thanks Jim. I’m glad this is being looked at and seriously considered. I don’t use DHIS2 regularly, but whenever I do I find it frustrating not to be able to use more flexible expressions such as the ones listed at https://jira.dhis2.org/browse/DHIS2-4469 when defining indicators. Cheers, Hazim From: Jim Grace Sent: 05 November 2018 19:30 To: TIMIMI, Hazim Bakir Cc: DHIS 2 Users list Subject: Re: [Dhis2-users] Adding a time lag functionality to DHIS2 Hazim, you are not alone! We are looking at exactly this kind of thing now, based on requests from many users. Just now I've commented on this at https://community.dhis2.org/t/expression-enhancements-to-space-shift-and-time-shift-data/774. In the meantime you might consider the use of predictors that can be used to bring data forward in time and store it in new data elements, which can then be used in indicators alongside current data. This does require new data elements, and storing the same data under two different periods in the database. We hope to be able to avoid this in the future by allowing time-shifting in the indicators themselves, very much like what you saw in the Launchpad blueprint. But using predictors is something you could do today with existing DHIS2 functionality. Cheers, Jim Grace On Mon, Nov 5, 2018 at 5:41 PM TIMIMI, Hazim Bakir mailto:timi...@who.int>> wrote: There are various things we would like to calculate using data from different time periods, such as % change between one period and the next, or to perform cohort analysis. I see this was raised in 2015 (see https://blueprints.launchpad.net/dhis2/+spec/indicator-time-lags). Does anyone have any experience of doing this in DHIS2? I didn’t find anything on JIRA. We surely can’t be the only people wondering about this? Any helpful hints would be most welcome! Thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Jim Grace Core developer, DHIS 2 HISP US Inc. http://www.dhis2.org<https://www.dhis2.org/> ___ 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] Adding a time lag functionality to DHIS2
There are various things we would like to calculate using data from different time periods, such as % change between one period and the next, or to perform cohort analysis. I see this was raised in 2015 (see https://blueprints.launchpad.net/dhis2/+spec/indicator-time-lags). Does anyone have any experience of doing this in DHIS2? I didn't find anything on JIRA. We surely can't be the only people wondering about this? Any helpful hints would be most welcome! Thanks, Hazim . Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland ___ 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] Calculations across different time periods in DHIS2
Is there an out-of-the-box way in DHIS2 to define indicators or to perform calculations that compare data elements between different time periods, such as calculating a % change between one month and the next? The only way we have found to do this at the moment is to export the data and do the calculations outside DHIS2. Thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland ___ 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] Weird behaviour in pivot table
Happy new year, folks. Here's a puzzling thing we see in our DHIS2 instance (version 2.27, build revision 9f0f047 dated 2017-08-29 04:02) when using pivot tables. If we display a data element or an indicator with the default row and column totals shown then all is well and good, see attached screenshot 1. If we open the options and untick 'show row totals' then the column total is doubled as shown in attached screenshot 2. If we do this for, say, 3 data elements we get a similar problem but only for the third (rightmost) column -- see screenshots 3 and 4. We get the same effect if there is more than one org unit in the pivot table. Any ideas why this is happening? I haven't been able to reproduce it in the DHIS2 play instance, Thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland ___ 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] Standard approach for recording age at the time of diagnosis when date of birth is unknown
Thanks very much Lise, you described my concerns very well (although I had to stop to work out what DE and PI meant!). Cheers, Hazim From: GROUT, Lise Sent: 11 October 2017 17:09 To: Abyot Asalefew Gizaw; TIMIMI, Hazim Bakir Cc: dhis2-users@lists.launchpad.net Subject: RE: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown Dear all, I tested the Age-type date element which is good to capture the approximate age of the patient. But this is a dynamic variable, in the sense that every day, the patient will be older of one day. Obviously, this is a very good attribute for the registration for example in tracker, in order to be able to look for a patient with the age variable, even if s/he shows up months or years later. But it is also important for us to capture the age at the moment of clinical examination/admission/presentation (whatever the name you give it) and that this variable is static (it won’t change over time). And for this, the age-type DE is therefore not helpful. We currently have “Date of birth” which is date-type and “Age in years” which is number-type DE, and we would actually like to have a PI “Age at clinical examination” which is calculated with “DOB” if available or “Age in years” if not available (not configured properly yet). Probably, ideally, the PI “Age at clinical examination” should be calculated either on the “DOB” DE or in the approximative DOB provided through the Age-type DE, but I don’t know if this is possible. (Don’t know if I make sense). Best Lise. From: Dhis2-users [mailto:dhis2-users-bounces+groutl=who@lists.launchpad.net] On Behalf Of Abyot Asalefew Gizaw Sent: 11 October 2017 16:46 To: TIMIMI, Hazim Bakir Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown Hi, We will try to update the documentation :) As to the issue you refereed, it is a new one and most of us here haven't looked into it before... Nonetheless, looking into the requirement mentioned there - I think introducing the concept of age there will probably over complicate things. What is required seems to capture a static figure - and defining a simple data element of type number will handle that. -- Abyot A. Gizaw. Senior Engineer, DHIS2 University of Oslo http://www.dhis2.org On Wed, Oct 11, 2017 at 4:23 PM, TIMIMI, Hazim Bakir wrote: Hi Abyot, Interesting, thanks. I wasn’t aware of the value type called AGE within DHIS2. I tried to find some documentation for this at https://www.dhis2.org/documentation but couldn't see anything. I only found references to it on Github and also on the 2.26 release notes (https://www.dhis2.org/226). It doesn't explain what to do if you only know approximate age in years, not whether the reference date is the data entry date or the report/event/diagnosis date (if data entry is post hoc). I see this is already reported as a request in JIRA (https://jira.dhis2.org/browse/DHIS2-2345). Cheers, Hazim From: Abyot Asalefew Gizaw [mailto:ab...@dhis2.org] Sent: 11 October 2017 15:02 To: TIMIMI, Hazim Bakir Cc: Edward Robinson; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown Hi, We don't capture the additional data if DOB is approximated or not... Otherwise, we have a value type called AGE, then during data entry a special input field is rendered, see below [Inline image 1] Users are free to fill any or combination of these and behind the scene the system calculates/updates each field and in the end DOB is saved. -- Abyot A. Gizaw. Senior Engineer, DHIS2 University of Oslo http://www.dhis2.org On Wed, Oct 11, 2017 at 2:21 PM, TIMIMI, Hazim Bakir wrote: Hi Ed, Thanks very much, that makes sense. I also came across this yesterday which seems similar to what you have done in the past (see under "Collection and usage attributes"): http://meteor.aihw.gov.au/content/index.phtml/itemId/287007 Cheers, Hazim -Original Message- From: Edward Robinson [mailto:erobin...@projectbalance.com] Sent: 11 October 2017 13:40 To: TIMIMI, Hazim Bakir; dhis2-users@lists.launchpad.net Subject: RE: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown What we've done in the past with other systems is have a field for estimated age at time of registration - only completed if the DOB is not known. DOB is then auto-populated based on the entered age, and an additional YES/NO field is updated to note that the DOB is estimated and not exact. Ed -Original Message- From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of TIMIMI, Hazim Bakir Sent: Tuesday, 10 October 2017 5:01 PM
Re: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown
Hi Abyot, Interesting, thanks. I wasn’t aware of the value type called AGE within DHIS2. I tried to find some documentation for this at https://www.dhis2.org/documentation but couldn't see anything. I only found references to it on Github and also on the 2.26 release notes (https://www.dhis2.org/226). It doesn't explain what to do if you only know approximate age in years, not whether the reference date is the data entry date or the report/event/diagnosis date (if data entry is post hoc). I see this is already reported as a request in JIRA (https://jira.dhis2.org/browse/DHIS2-2345). Cheers, Hazim From: Abyot Asalefew Gizaw [mailto:ab...@dhis2.org] Sent: 11 October 2017 15:02 To: TIMIMI, Hazim Bakir Cc: Edward Robinson; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown Hi, We don't capture the additional data if DOB is approximated or not... Otherwise, we have a value type called AGE, then during data entry a special input field is rendered, see below [Inline image 1] Users are free to fill any or combination of these and behind the scene the system calculates/updates each field and in the end DOB is saved. -- Abyot A. Gizaw. Senior Engineer, DHIS2 University of Oslo http://www.dhis2.org On Wed, Oct 11, 2017 at 2:21 PM, TIMIMI, Hazim Bakir wrote: Hi Ed, Thanks very much, that makes sense. I also came across this yesterday which seems similar to what you have done in the past (see under "Collection and usage attributes"): http://meteor.aihw.gov.au/content/index.phtml/itemId/287007 Cheers, Hazim -Original Message- From: Edward Robinson [mailto:erobin...@projectbalance.com] Sent: 11 October 2017 13:40 To: TIMIMI, Hazim Bakir; dhis2-users@lists.launchpad.net Subject: RE: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown What we've done in the past with other systems is have a field for estimated age at time of registration - only completed if the DOB is not known. DOB is then auto-populated based on the entered age, and an additional YES/NO field is updated to note that the DOB is estimated and not exact. Ed -Original Message- From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of TIMIMI, Hazim Bakir Sent: Tuesday, 10 October 2017 5:01 PM To: dhis2-users@lists.launchpad.net Subject: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown Is there a standard approach commonly in use to handle ages when the exact date of birth of a patient is unknown? I can think of two ways -- either using a surrogate (approximate) date of birth that tallies with a person's reported age, or have an extra data element for age at time of diagnosis to be used only if date of birth is unknown. Obviously, if date of birth is known then age is calculated automatically. I would like to know what people have been using and have seen to be working in practice (and not necessarily just in DHIS2). Thanks! Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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 ___ 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] Standard approach for recording age at the time of diagnosis when date of birth is unknown
Hi Ed, Thanks very much, that makes sense. I also came across this yesterday which seems similar to what you have done in the past (see under "Collection and usage attributes"): http://meteor.aihw.gov.au/content/index.phtml/itemId/287007 Cheers, Hazim -Original Message- From: Edward Robinson [mailto:erobin...@projectbalance.com] Sent: 11 October 2017 13:40 To: TIMIMI, Hazim Bakir; dhis2-users@lists.launchpad.net Subject: RE: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown What we've done in the past with other systems is have a field for estimated age at time of registration - only completed if the DOB is not known. DOB is then auto-populated based on the entered age, and an additional YES/NO field is updated to note that the DOB is estimated and not exact. Ed -Original Message- From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of TIMIMI, Hazim Bakir Sent: Tuesday, 10 October 2017 5:01 PM To: dhis2-users@lists.launchpad.net Subject: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown Is there a standard approach commonly in use to handle ages when the exact date of birth of a patient is unknown? I can think of two ways -- either using a surrogate (approximate) date of birth that tallies with a person's reported age, or have an extra data element for age at time of diagnosis to be used only if date of birth is unknown. Obviously, if date of birth is known then age is calculated automatically. I would like to know what people have been using and have seen to be working in practice (and not necessarily just in DHIS2). Thanks! Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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] Standard approach for recording age at the time of diagnosis when date of birth is unknown
Is there a standard approach commonly in use to handle ages when the exact date of birth of a patient is unknown? I can think of two ways -- either using a surrogate (approximate) date of birth that tallies with a person's reported age, or have an extra data element for age at time of diagnosis to be used only if date of birth is unknown. Obviously, if date of birth is known then age is calculated automatically. I would like to know what people have been using and have seen to be working in practice (and not necessarily just in DHIS2). Thanks! Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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] Map legends when maps are shown in a dashboard
Dear all, Is there any way of making map legends appear permanently when a map is included in a dashboard *without* having to hover the mouse over the legend placeholder? Thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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] Dashboard sharing access rights (again!)
Dear all, I am fishing again for a workaround to this problem (v2.25, v2.26). To recap: Dashboard sharing options in our DHIS2 instance are: public access set to ‘None’, TB user group set to ‘Can view’ and TB module superuser group set to ‘Can edit and view’ as per screenshot below: [cid:image002.jpg@01D2B2A7.5180E510] However, when our TB user group members log in, the ‘Remove’ and ‘Resize’ links in the box bounding each object in the dashboard remain active, so users can easily (and often unintentionally) remove objects. This is clearly a bug. Note that they cannot re-insert the removed object because they do not have edit rights! In other words the sharing settings are being applied correctly for addition of objects but *not* being applied correctly for removal of objects. Please please please if anyone has found a workaround to this problem please share as it is causing us a lot of problems! Many thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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] Dashboard sharing access rights
Hi Trøyel, As I said, I have also tried restricting public access to 'None' and only granting 'Can View' to a specific user group, and 'Can Edit and View' to a very small number, but I still find users in the group with 'Can View' permission are able to remove objects from the dashboards. I’m not sure how that differs from what you suggest. Sorry, I didn't quite understand your first paragraph. Just to note we don't have access to the server itself, just the web interface. Hazim From: Trøyel Nerbø [mailto:troyel.ne...@nrc.no] Sent: 06 April 2017 16:44 To: TIMIMI, Hazim Bakir; Antonia - Pro; dhis2-users@lists.launchpad.net Subject: RE: [Dhis2-users] Dashboard sharing access rights I haven’t tested this yet, but a potential work around would be to monitor/schedule a reset of the dashboard items by updating the /api/dashboards/uid.json with the dashboard items it is supposed to contain. Not sure how this would work with resizing and ordering, though. Altneratively, a perhaps better solution. What about adding all users to a user group with the purpose of sharing it as non-public but with the “all users” group? I haven’t tested if the bug is with all “view only” or just the public setting. Trøyel From: TIMIMI, Hazim Bakir [mailto:timi...@who.int] Sent: torsdag 6. april 2017 16.05 To: Trøyel Nerbø ; Antonia - Pro ; dhis2-users@lists.launchpad.net Subject: RE: [Dhis2-users] Dashboard sharing access rights No worries Trøyel! Olav Poppe reporting it on JIRA on my behalf a while back – I was just trying to find out if anybody has a workaround or solution until the bug is fixed J Cheers, Hazim From: Trøyel Nerbø [mailto:troyel.ne...@nrc.no] Sent: 06 April 2017 14:24 To: Trøyel Nerbø; Antonia - Pro; dhis2-users@lists.launchpad.net; TIMIMI, Hazim Bakir Subject: RE: [Dhis2-users] Dashboard sharing access rights Oh, apologies. I didn’t read the complete email and see you are already aware of the issue J /T From: Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf Of Trøyel Nerbø Sent: torsdag 6. april 2017 14.21 To: Antonia - Pro ; dhis2-users@lists.launchpad.net; TIMIMI, Hazim Bakir Subject: Re: [Dhis2-users] Dashboard sharing access rights This is a known bug. If you want to follow the development and get notified when there is a fix you can register and watch the bug issue here: https://jira.dhis2.org/browse/DHIS2-500 Best, Trøyel From: Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf Of Antonia - Pro Sent: torsdag 6. april 2017 14.06 To: dhis2-users@lists.launchpad.net; TIMIMI, Hazim Bakir Subject: Re: [Dhis2-users] Dashboard sharing access rights yes, we have the same problem. 2017-04-06 13:43 GMT+02:00 TIMIMI, Hazim Bakir : Dear DHIS2 friends, I wonder if anyone else has come across the following problem and, if so, how you solved it: All dashboards on our instance have their public access (with login) sharing setting as 'Can View'. However users are able to remove or resize objects in the dashboard which affects everybody else! I have tried restricting public access to 'None' and only granting 'Can View' to a specific user group, and 'Can Edit and View' to a very small number, but I still find users in the group with 'Can View' permission are able to remove objects from the dashboards. We are using v 2.25, but I can reproduce the problem in v2.26 on https://play.dhis2.org/demo/. This bug was logged in Jira a while ago (https://jira.dhis2.org/projects/DHIS2/issues/DHIS2-500) and I also logged another request for a warning dialog to appear when users click on the 'Remove' link (https://jira.dhis2.org/browse/DHIS2-1383). Any help or pointers would be much appreciated! Thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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] Dashboard sharing access rights
No worries Trøyel! Olav Poppe reporting it on JIRA on my behalf a while back – I was just trying to find out if anybody has a workaround or solution until the bug is fixed J Cheers, Hazim From: Trøyel Nerbø [mailto:troyel.ne...@nrc.no] Sent: 06 April 2017 14:24 To: Trøyel Nerbø; Antonia - Pro; dhis2-users@lists.launchpad.net; TIMIMI, Hazim Bakir Subject: RE: [Dhis2-users] Dashboard sharing access rights Oh, apologies. I didn’t read the complete email and see you are already aware of the issue J /T From: Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf Of Trøyel Nerbø Sent: torsdag 6. april 2017 14.21 To: Antonia - Pro ; dhis2-users@lists.launchpad.net; TIMIMI, Hazim Bakir Subject: Re: [Dhis2-users] Dashboard sharing access rights This is a known bug. If you want to follow the development and get notified when there is a fix you can register and watch the bug issue here: https://jira.dhis2.org/browse/DHIS2-500 Best, Trøyel From: Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf Of Antonia - Pro Sent: torsdag 6. april 2017 14.06 To: dhis2-users@lists.launchpad.net; TIMIMI, Hazim Bakir Subject: Re: [Dhis2-users] Dashboard sharing access rights yes, we have the same problem. 2017-04-06 13:43 GMT+02:00 TIMIMI, Hazim Bakir : Dear DHIS2 friends, I wonder if anyone else has come across the following problem and, if so, how you solved it: All dashboards on our instance have their public access (with login) sharing setting as 'Can View'. However users are able to remove or resize objects in the dashboard which affects everybody else! I have tried restricting public access to 'None' and only granting 'Can View' to a specific user group, and 'Can Edit and View' to a very small number, but I still find users in the group with 'Can View' permission are able to remove objects from the dashboards. We are using v 2.25, but I can reproduce the problem in v2.26 on https://play.dhis2.org/demo/. This bug was logged in Jira a while ago (https://jira.dhis2.org/projects/DHIS2/issues/DHIS2-500) and I also logged another request for a warning dialog to appear when users click on the 'Remove' link (https://jira.dhis2.org/browse/DHIS2-1383). Any help or pointers would be much appreciated! Thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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] Dashboard sharing access rights
Dear DHIS2 friends, I wonder if anyone else has come across the following problem and, if so, how you solved it: All dashboards on our instance have their public access (with login) sharing setting as 'Can View'. However users are able to remove or resize objects in the dashboard which affects everybody else! I have tried restricting public access to 'None' and only granting 'Can View' to a specific user group, and 'Can Edit and View' to a very small number, but I still find users in the group with 'Can View' permission are able to remove objects from the dashboards. We are using v 2.25, but I can reproduce the problem in v2.26 on https://play.dhis2.org/demo/. This bug was logged in Jira a while ago (https://jira.dhis2.org/projects/DHIS2/issues/DHIS2-500) and I also logged another request for a warning dialog to appear when users click on the 'Remove' link (https://jira.dhis2.org/browse/DHIS2-1383). Any help or pointers would be much appreciated! Thanks, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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] Help! What has happened to my data element and indicator translations?
Ah, yes, I see now, thanks for that. The dataelementtranslations table, as was the objecttranslation table. I added a couple of translations via the interface and see now how they are populated. Do you know of any ready-made SQL script that would take translations from the old format and populate the new tables, or should I just roll my own? Thanks again! Hazim From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 01 December 2016 12:53 To: TIMIMI, Hazim Bakir Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Help! What has happened to my data element and indicator translations? Hi. If you are on 2.25, these should be stored in the dataelementtranslations table. Is there anything there? Otherwise, something may have gone wrong during the upgrade procedure. Regards, Jason On Thu, Dec 1, 2016 at 12:44 PM, TIMIMI, Hazim Bakir wrote: Hi Jason, Thanks for the quick reply. Like I said, we upgraded from 2.23 to 2.25. It looks like we are on build revision 6ce8201. I have seen the same problem on a local Ubuntu test server using build revision 221c5d8. The translations are not visible anywhere, not in the visualisation modules nor in the maintenance module. But I know they are in the database’s translate table as per my email below. See screenshots of maintenance module and output of the SQL view for one of the data elements. [cid:image001.jpg@01D24BCE.06E0D5F0] [cid:image002.jpg@01D24BCE.06E0D5F0] Mystifying! Any hints most welcome. Thanks and best wishes, Hazim From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 01 December 2016 12:14 To: TIMIMI, Hazim Bakir Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Help! What has happened to my data element and indicator translations? Hi Hazim, Which version are you running? Depending on the version, the translations of data elements are no longer in that table. Does this happen in specific apps or are they not even visible in the maintenance module when looking at a specific data element? Regards Jason On Thu, Dec 1, 2016 at 10:23 AM, TIMIMI, Hazim Bakir wrote: Hi there, We recently upgraded our DHIS2 server from 2.23 to 2.25. The French translations we previously had for data elements and indicators no longer appear if you change language preferences. In the maintenance module clicking on the translate for those data elements/indicators no longer shows the translations. Yet when I run the following query (via Data Administration > SQL View) I can see that the French translations are still there in the translation table: /* See data element names and descriptions along with French translations */ SELECT object.uid, object.code, object.name, object.shortname, object.description, t_name.name_fr, shortname_fr, description_fr FROM dataelement AS object LEFT OUTER JOIN (SELECT objectuid, value AS name_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'name' ) AS t_name ON object.uid = t_name.objectuid LEFT OUTER JOIN (SELECT objectuid, value AS shortname_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'shortName' ) AS t_shortname ON object.uid = t_shortname.objectuid LEFT OUTER JOIN (SELECT objectuid, value AS description_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'description' ) AS t_description ON object.uid = t_description.objectuid; Any clues/advice on how to fix this would be much appreciated! With many thanks in advance, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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 -- Jason P. Pickering email:
Re: [Dhis2-users] Help! What has happened to my data element and indicator translations?
Hi Jason, Thanks for the quick reply. Like I said, we upgraded from 2.23 to 2.25. It looks like we are on build revision 6ce8201. I have seen the same problem on a local Ubuntu test server using build revision 221c5d8. The translations are not visible anywhere, not in the visualisation modules nor in the maintenance module. But I know they are in the database’s translate table as per my email below. See screenshots of maintenance module and output of the SQL view for one of the data elements. [cid:image001.jpg@01D24BCE.06E0D5F0] [cid:image002.jpg@01D24BCE.06E0D5F0] Mystifying! Any hints most welcome. Thanks and best wishes, Hazim From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 01 December 2016 12:14 To: TIMIMI, Hazim Bakir Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Help! What has happened to my data element and indicator translations? Hi Hazim, Which version are you running? Depending on the version, the translations of data elements are no longer in that table. Does this happen in specific apps or are they not even visible in the maintenance module when looking at a specific data element? Regards Jason On Thu, Dec 1, 2016 at 10:23 AM, TIMIMI, Hazim Bakir wrote: Hi there, We recently upgraded our DHIS2 server from 2.23 to 2.25. The French translations we previously had for data elements and indicators no longer appear if you change language preferences. In the maintenance module clicking on the translate for those data elements/indicators no longer shows the translations. Yet when I run the following query (via Data Administration > SQL View) I can see that the French translations are still there in the translation table: /* See data element names and descriptions along with French translations */ SELECT object.uid, object.code, object.name, object.shortname, object.description, t_name.name_fr, shortname_fr, description_fr FROM dataelement AS object LEFT OUTER JOIN (SELECT objectuid, value AS name_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'name' ) AS t_name ON object.uid = t_name.objectuid LEFT OUTER JOIN (SELECT objectuid, value AS shortname_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'shortName' ) AS t_shortname ON object.uid = t_shortname.objectuid LEFT OUTER JOIN (SELECT objectuid, value AS description_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'description' ) AS t_description ON object.uid = t_description.objectuid; Any clues/advice on how to fix this would be much appreciated! With many thanks in advance, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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 -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 ___ 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] Help! What has happened to my data element and indicator translations?
Hi there, We recently upgraded our DHIS2 server from 2.23 to 2.25. The French translations we previously had for data elements and indicators no longer appear if you change language preferences. In the maintenance module clicking on the translate for those data elements/indicators no longer shows the translations. Yet when I run the following query (via Data Administration > SQL View) I can see that the French translations are still there in the translation table: /* See data element names and descriptions along with French translations */ SELECT object.uid, object.code, object.name, object.shortname, object.description, t_name.name_fr, shortname_fr, description_fr FROM dataelement AS object LEFT OUTER JOIN (SELECT objectuid, value AS name_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'name' ) AS t_name ON object.uid = t_name.objectuid LEFT OUTER JOIN (SELECT objectuid, value AS shortname_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'shortName' ) AS t_shortname ON object.uid = t_shortname.objectuid LEFT OUTER JOIN (SELECT objectuid, value AS description_fr FROMtranslation WHERE locale = 'fr' AND objectproperty = 'description' ) AS t_description ON object.uid = t_description.objectuid; Any clues/advice on how to fix this would be much appreciated! With many thanks in advance, Hazim ….. Hazim Timimi Data Manager, Tuberculosis Monitoring and Evaluation, World Health Organization, Geneva, Switzerland Tel : +41 22 791 3468 ___ 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