[Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

Public bug reported: Bug found in 2.22, still present in 2.24 online demo (2.24 rev.23557) Online demo accessed using Chrome 52.0.2743.116. There appears to be a bug in the program indicator calculations when: a sum() custom aggregation is used twice, to enable the calculation of a percentage

[Dhis2-devs] Analytics crashed in DHIS2 Live - how do I drop H2 tables?

Hi all, I’m trying to whip up a quick 2.24 prototype using (first time for me) DHIS2 Live. However, after setting up all program metadata and entering 2 events, the second time I ran the analytics, it crashed, with an error message that includes “Table _ORGUNITSTRUCTURE_TEMP already exists”.

[Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

Hi Devs, If possible, I’d be very grateful for some advice around authorities in 2.25. In order to help prepare for PSI’s upgrade to 2.25, we’ve done an analysis of changes in Authorities between 2.22 and 2.25. I couldn’t find a database table containing Authorities, and the list of

Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

red.) Many thanks, Sam. From: Lars Helge Øverland <l...@dhis2.org> Date: Wednesday, 8 February 2017 at 03:58 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, JM Alcantara <jmalcanta...@gmail.com>, "rodolfo.me...@k

Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

. From: Dhis2-devs <dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <samuel.john...@qebo.co.uk> Date: Wednesday, 15 February 2017 at 12:57 To: Lars Helge Øverland <l...@dhis2.org> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net

Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

Hi all, Just following up on this bug report again – is there any chance I could get it looked at/prioritized? I’ve dug a little deeper, and it looks like this bug could be as simple as an error in variable handling. Specifically, although in the example I originally gave, the following

[Dhis2-devs] Cannot create new program stage reminder template

Hi all, I’m using a 2.24 instance which I’ve just updated to 704143a, and am attempting to create reminder templates on a repeatable program stage. I can successfully use the front end to create this reminder on one of the program stages on play.dhis2.org/demo, but when I attempt it in my own

Re: [Dhis2-devs] Cannot create new program stage reminder template

to be missing from that failed row? Cheers, Sam. From: Lars Helge Øverland <l...@dhis2.org> Date: Thursday, 6 October 2016 at 12:47 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net> Subject: Re: [Dhis2-devs] Cannot create new prog

Re: [Dhis2-devs] Cannot create new program stage reminder template

ces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <samuel.john...@qebo.co.uk> Date: Thursday, 6 October 2016 at 13:48 To: Lars Helge Øverland <l...@dhis2.org>, Knut Staring <knu...@gmail.com> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net> Su

Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

a custom aggregation for V{event_count} – I’ll put that in now, so the eventual upgrade to 2.25 goes smoothly. ☺ Cheers, Sam. From: Markus Bekken <markus.bek...@gmail.com> Date: Friday, 7 October 2016 at 08:44 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers

Re: [Dhis2-devs] Cannot create new program stage reminder template

19:56 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net> Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template I don't think so, unfortunately. Perhaps the programmessage table? On Sun, Oct 9, 2016 at 6:55 PM, Sam Joh

Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi all, Still banging my head against the wall with this one. Is there any schema documentation available for DHIS2? Cheers, Sam. From: Dhis2-devs <dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <samuel.john...@qebo.co.uk> Date: Frida

Re: [Dhis2-devs] 'Search tracked entity instance in all Org Units' authority not working?

will return only tracked entity instances that are registered/enrolled within their own assigned org units. Cheers, Sam. From: Brajesh Murari <brajesh.mur...@gmail.com> Date: Monday, 19 September 2016 at 10:10 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@list

Re: [Dhis2-devs] 'Search tracked entity instance in all Org Units' authority not working?

Hi Abyot, Should I report this as a bug on Launchpad? Cheers, Sam. From: Abyot Asalefew Gizaw <ab...@dhis2.org> Date: Monday, 19 September 2016 at 10:18 To: Brajesh Murari <brajesh.mur...@gmail.com> Cc: Sam Johnson <samuel.john...@qebo.co.uk>, DHIS2 Developers <dhis2-dev

[Dhis2-devs] [Bug 1625143] [NEW] The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are

Public bug reported: Hi all, The ‘search tracked entity instance in all Org Units’ authority doesn’t appear to be working in 2.24 – see section 26.2 of the 2.24 User Guide for details of this authority. (This feature has been documented for quite some time now, but I haven’t yet had a chance to

[Dhis2-devs] 'Search tracked entity instance in all Org Units' authority not working?

Hi all, The ‘search tracked entity instance in all Org Units’ authority doesn’t appear to be working in 2.24 – see section 26.2 of the 2.24 User Guide for details of this authority. (This feature has been documented for quite some time now, but I haven’t yet had a chance to check whether or

Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

Hi all, I reported a bug in the web program indicator calculations a couple of weeks ago, and included in the report everything that’s needed to quickly replicate the bug, but I don’t think anyone has had a chance to look at this report yet. Have I followed the correct process for reporting

[Dhis2-devs] Possible bug with event data capture without the 'ALL' authority?

Hi all, am just-resending this, as it doesn’t seem to have got through to the mailing list (apologies if I end up double-posting). In my 2.25 instance, I’m running into problems when a user without the ‘ALL’ authority attempts to save an event-without-registration: it caches the data values,

[Dhis2-devs] FW: Bug in XML export / import for Program Rules

Hi all, Using 2.25, revision 221c5d8 (Wed morning), Chrome I just wanted to report a bug in the XML export / import for Program Rules: · When you export XML for a program rule, ‘&&’ operators are kept as plain-text in the XML that is exported. · When you re-import this XML, it

Re: [Dhis2-devs] FW: Bug in XML export / import for Program Rules

? ;-) Cheers, Sam. From: Morten Olav Hansen <mor...@dhis2.org> Date: Friday, 11 November 2016 at 01:42 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net> Subject: Re: [Dhis2-devs] FW: Bug in XML export / import for Program Rules Hm ok, thank

Re: [Dhis2-devs] Possible bug with event data capture without the 'ALL' authority?

. From: Abyot Asalefew Gizaw <ab...@dhis2.org> Date: Friday, 11 November 2016 at 07:58 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net> Subject: Re: [Dhis2-devs] Possible bug with event data capture without the 'ALL' authority?

[Dhis2-devs] Play demo password

Hi all, Re: Victor’s note about being locked out of the demo server, this sort of lock-out has happened a few times recently. Would it perhaps be worth setting up a chron job that runs every five minutes to update the ‘admin’ user password back to ‘district’ if it has changed? Cheers, Sam.

Re: [Dhis2-devs] [Dhis2-users] 25 hours in completing Analytic

, so there wouldn’t be any point in VACUUMing them. Cheers, Sam. From: Dhis2-users <dhis2-users-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <samuel.john...@qebo.co.uk> Date: Wednesday, 19 October 2016 at 12:28 To: DHIS 2 Users li

Re: [Dhis2-devs] [Dhis2-users] 25 hours in completing Analytic

Hi Neeraj, Using VACUUM and ANALYZE Like Brajesh, my background is MySQL, and one database admin task that is often overlooked in MySQL is OPTIMIZE TABLEs. This reclaims unused space (we’ve had 100Gb databases files drop to half their size) and refreshes index statistics (if the shape of

Re: [Dhis2-devs] Event Capture 0.5.x - programs not showing up if they have program rules

Hi Araz, That’s great news, many thanks – I look forward to testing it as soon as it’s released. ☺ Cheers, Sam. From: Araz Abishov <a...@dhis2.org> Date: Tuesday, 18 October 2016 at 09:34 To: Sam Johnson <samuel.john...@qebo.co.uk>, Alex Tumwesigye <atumwesi...@gmail.com>

Re: [Dhis2-devs] XML import bug

Hi Viet, This fix looks like it has worked – the whole program XML is now importing smoothly into my 2.25 instance. Many thanks for sorting this out so quickly! ☺ Cheers, Sam. From: Viet Nguyen <v...@dhis2.org> Date: Wednesday, 19 October 2016 at 05:16 To: Sam Johnson <sa

[Dhis2-devs] Event Capture 0.5.x - programs not showing up if they have program rules

<atumwesi...@gmail.com> Date: Friday, 14 October 2016 at 06:43 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: "Laura E. Lincks" <laura.lin...@icap.columbia.edu>, Simon Muyambo <smmuya...@gmail.com>, DHIS2 Developers <dhis2-devs@lists.launchpad.net> Subject:

[Dhis2-devs] [Bug 1625143] Re: The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are re

Hi Abyot, On reflection, I think this might still be a bug after all. If you can assign search org units to users, then why would the authority 'Search tracked entity instances in all org units' even exist? The very name of that authority seems to imply that it should override any specific

[Dhis2-devs] [Bug 1625143] Re: The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are re

Hi Abyot, Many thanks, I've just tested this, and it resolves the issue! :-) I hadn't realised this 'assign search org units' feature existed, and I can't find a reference to it anywhere in the User Guide (which says you only need the special authority) - would it be possible to get the

Re: [Dhis2-devs] Event Capture 0.5.x - programs not showing up if they have program rules

is2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <samuel.john...@qebo.co.uk> Date: Friday, 14 October 2016 at 12:25 To: Alex Tumwesigye <atumwesi...@gmail.com>, "a...@dhis2.org" <a...@dhis2.org>, DHIS2 Developers <dhis2-devs

[Dhis2-devs] [Bug 1625143] Re: The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are re

Hi Abyot, When you say “users have no control”, do you mean admin users, or data capture users? My understanding is that admin users can control this by having different roles, and only giving the relevant ones this authority. They would only assign the role if they want enforce users to being

[Dhis2-devs] [Bug 1625143] Re: The role/authority ‘Search tracked entity in all Org Units’ is not working, and even with this authority, a search will return only tracked entity instances that are re

PPS - should we still be reporting bugs here on Launchpad, or should we now register them on Github? -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1625143 Title: The role/authority ‘Search

Re: [Dhis2-devs] Tracker - enter data for different stages in programme in different orgunits

; Date: Monday, 31 October 2016 at 11:28 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: Olav Poppe <olav.po...@me.com>, DHIS2 Developers <dhis2-devs@lists.launchpad.net> Subject: Re: [Dhis2-devs] Tracker - enter data for different stages in programme in different orgunits Hi

Re: [Dhis2-devs] Confirming 'official' handling of Yes and No in program indicators

: Lars Helge Øverland <l...@dhis2.org> Date: Wednesday, 2 November 2016 at 12:20 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net> Subject: Re: [Dhis2-devs] Confirming 'official' handling of Yes and No in program indicators Hi Sam, On

[Dhis2-devs] Confirming 'official' handling of Yes and No in program indicators

Hi Devs, I’ve been working on some quite complex program indicators, and before I commit them to production, I would be very grateful if you could confirm how Yes and No are supposed to be handled in program indicator expressions. I’ve noticed that within the program indicators, they currently

Re: [Dhis2-devs] Tracker - enter data for different stages in programme in different orgunits

Hi Abyot and Olav, I’m very interested in this thread, but really confused by it. ;-) What do you mean by ‘data view’ org units – are you referring to ‘Data output and analysis organisation units’? Like Olav, my understanding was that this should be handled by ‘Assign search org units’ – ie

Re: [Dhis2-devs] Event Capture - option set not working

Hi all, Is there a version of the Event Capture app that works with 2.25? I’ve just tested the official Event Capture Android app (0.3.4-2.22) that’s on Google Play, and it looks like it still has the option set bug that Simon and Laura reported below. Has anyone come across a workaround for

[Dhis2-devs] FW: Null pointer exception calling .../api/me/programs

Hi all, I’m trying to produce a generic EventCapture XML config that can be imported into any DHIS2 instance, which requires the data elements and program to use the default CategoryCombo of the target instance. My understanding from the documentation (and the email thread below) is that if

[Dhis2-devs] XML import bug

ted from play.dhis2.org to speed up testing. I’d be very grateful if you could look into this urgently, as I can’t currently do XML imports into my 2.25 instance. Many thanks, Sam. From: Dhis2-devs <dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sa

Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

Hi Rachael, I just wanted to congratulate the team on successfully migrating to Jira – it’s a great system, and will make feedback and collaboration around DHIS2 even easier. (I’ve just set up a custom Kanban dashboard for PSI to monitor 2.25 bug-testing, which was very easy to do.) One

Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

Hi Rachael/Devs, Am just following up on the query below – is it at all possible to enable creation of private user groups within the DHIS2 Jira instance? Regards, Sam. From: Dhis2-devs <dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <sa

Re: [Dhis2-devs] Play demo password

to ‘district’ if it has changed? Cheers, Sam. From: Dhis2-devs <dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <samuel.john...@qebo.co.uk> Date: Friday, 11 November 2016 at 04:50 To: Victor Garcia <vgarcia...@gmail.com>, DHIS2 Devel

Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting Started doc

Helge Øverland <l...@dhis2.org> Date: Monday, 2 January 2017 at 18:17 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: Rachael Brooke <rach...@dhis2.org>, DHIS 2 Users list <dhis2-us...@lists.launchpad.net>, DHIS2 Developers <dhis2-devs@lists.launchpad.net>, Juan Manue

Re: [Dhis2-devs] Program rules/program validation(?) issue in latest 2.25

Hi Olav and Abyot, We’ve come across the same bug in the Tuesday build of 2.25 (build revision 41c0625, build date 2017-04-18 16:10) – program rules are failing to fire in Event Capture, without any errors in the console or logs. I don’t think a Jira ticket’s been created for this yet, so I’ve

[Dhis2-devs] Many program rules not firing in 2.26

Hi Devs, I’m finding that a number of program rules aren’t firing in 2.26 – this is happening with both Event Capture and Tracker Capture. This includes the sample ‘Hide Program Stage’ rule which has been added to the WHO RMNCH Tracker for the 2.26 release. To reproduce in Play demo: 1.

Re: [Dhis2-devs] FW: Authorities in 2.25 (vs 2.22)

on the Dev team who is able to answer all of the questions below? If that’s the case, would it perhaps be possible for anyone on the Dev team to chime in with notes on just the specific authorities that they’ve worked on? Many thanks for any help you can provide, Regards, Sam. From: Sam Johnson

Re: [Dhis2-devs] Many program rules not firing in 2.26

simple string-handling change… Many thanks for any help you might be able to give! Cheers, Sam. From: Dhis2-devs <dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <samuel.john...@qebo.co.uk> Date: Friday, 21 April 2017 at 17:58 To: Markus

Re: [Dhis2-devs] 'Ask user to create new event...' no longer respects hiding of program stages

Hi Markus, Brilliant, many thanks for such a prompt response! I’ll update my instance later today, and let you know how I go. Many thanks, Sam. From: Markus Bekken <mar...@dhis2.org> Date: Tuesday, 8 August 2017 at 14:10 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Devel

[Dhis2-devs] 'Ask user to create new event...' no longer respects hiding of program stages

Hi Devs, I’ve reported this as DHIS2-2012. Basically, when users are prompted to create a new event booking, they are now offered the next available program stage – even if it’s supposed to be hidden. This used to work correctly (ie hidden program

Re: [Dhis2-devs] How do filters work in Enrolment program indicators?

/clarification you’re able to provide! Cheers, Sam. From: Markus Bekken <mar...@dhis2.org> Date: Monday, 8 May 2017 at 18:48 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net> Subject: Re: [Dhis2-devs] How do filters work in Enrolment

[Dhis2-devs] How do filters work in Enrolment program indicators?

Hi devs, Just a quick question around the operation of the enrolment indicators. I’m trying to do a program indicator which searches a repeatable program stage to see if one or more events include a specific data value (a test result). The catch is that the data value could be in any event,

Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture

2.26. Many thanks, Sam. From: Markus Bekken <mar...@dhis2.org> Date: Tuesday, 25 April 2017 at 23:21 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, "absolo...@yahoo.com" <absolo...@yahoo.com>, Immaculate Ayeba

Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture

. :-) Cheers, Sam. From: Markus Bekken <mar...@dhis2.org> Date: Tuesday, 2 May 2017 at 08:35 To: Sam Johnson <samuel.john...@qebo.co.uk> Cc: DHIS2 Developers <dhis2-devs@lists.launchpad.net>, "absolo...@yahoo.com" <absolo...@yahoo.com>, Immaculate Ayebazibwe <ek

[Dhis2-devs] Program rule evaluations no longer being displayed in the browser's Javascript Console (Tracker Capture)

Hi Devs, Sometime after 14 August, the 2.27 Tracker Capture web app seems to have stopped displaying the results of program rule evaluations in the Browser’s Javascript console (using Chrome 60.0.3112.101). To replicate, open the browser console, open the WHO RMNCH Tracker, register a new

Re: [Dhis2-devs] 'Ask user to create new event...' no longer respects hiding of program stages

.) This bug is a lot more serious than it sounds, as users are now very accustomed to just clicking ‘Save’ when prompted, so this could potentially result in a lot of data-entry errors. Is this something you might be able to quickly fix? Many thanks, Sam. From: Sam Johnson <samuel.j

[Dhis2-devs] Bug in import of Program Rule Variables

Hi Devs, I’ve noticed that during XML imports of Program Rule Variables in 2.28, any variables based on TE attributes are losing their link to the relevant attribute – so they no longer work. (I haven’t tested JSON imports, but I’m guessing the same thing is probably happening.) This means

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

Hi Markus and Bernard, At the start of last year, we reported this exclusion of parentheses from all program indicator functions as a bug (DHIS2-590), but it actually turned out to be intentional, so was changed from a bug to an Improvement. Since it

Re: [Dhis2-devs] Meta-data export with dependencies Fails

Hi Calle, Which version of DHIS2 are you using? In November I found a similar bug in 2.28 (DHIS2-2493), where the import chokes on an unknown catCombo, but the cause is slightly different – it attempts to persist the data element with a NULL catCombo

Re: [Dhis2-devs] Can not add "Tracked entity type attribute" to "tracked entity type"

Hi all, Following up on Abumere’s issue below, the attributes section of the ‘Tracked Entity Type’ screen seems to be broken in 2.30 (but works fine in 2.29). Reported as DHIS2-4647. If you try adding attributes, they fail to save “no changes to be

Re: [Dhis2-devs] Play demo password

changed, and then re-updates it to the default value if necessary. I think this was set up a while ago (see email thread below) – would it be difficult to re-implement it? Cheers, Sam. From: Knut Staring Date: Monday, 29 October 2018 at 11:58 To: Sam Johnson Cc: Lars Helge Øverland , Morten

Re: [Dhis2-devs] Play demo password

: Sam Johnson , DHIS2 Developers Subject: Re: [Dhis2-devs] Play demo password Hi Sam, Jason has added a script for resetting the password now. Lars On Thu, Jan 5, 2017 at 2:18 AM, Morten Olav Hansen mailto:mor...@dhis2.org>> wrote: Hi Sam It should be reset in about 2-3 hours automat

Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

call that DHIS2 2.30 generates still matches the one that Clickatell is expecting? Cheers, Sam. From: Zubair Asghar Raja Date: Tuesday, 2 October 2018 at 15:21 To: Sam Johnson Cc: Shurajit Dutta , "jahidsha...@gmail.com" , DHIS 2 Users List , "skaly...@gmail.com"

Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

Hi all, I’ve created an account with Clickatell, but despite following the documentation listed below, I’m struggling to configure it in my DHIS2 instance (v2.30). In the ‘Mobile Configuration’ module, I’ve selected ‘Add gateway’, and entered the following: * ‘Auth Token’ is my

Re: [Dhis2-devs] [Dhis2-users] SMS/Mobile configuration

s"}' -s http://http://%3cDHIS2> server address>/api/gateways/clickatell Another point: when generating an API key, Clickatell will default to ‘HTTP’, so don’t forget to change this to ‘REST’. With Zubair’s help, my SMS setup is now working smoothly. Hope this is useful for anyone els

Re: [Dhis2-devs] Impossible to create a Program Stage through UI

Hi Devs, I made this same mistake the first time I tried using the new 2.30 interface, so it would be great if we could correct the label on this button in the create/edit Program Stage screen – I’ve reported it as https://jira.dhis2.org/browse/DHIS2-5277. Cheers, Sam. From: Dhis2-devs on