Re: [Dhis2-devs] Aggregation Fails on MySQL using DHIS 2.11

2014-02-03 Thread John Mukulu
Hello Lars, I'm troubleshooting similar problem on aggregation query builder on test.dhis2.org for *2.14* revision 13755 I'll get back to you soon. ERROR LOG: * ERROR 2014-02-03 12:14:39,546 Exception occurred during processing request: Unable to instantiate Action,

Re: [Dhis2-devs-core] Change from OR to AND in object filter queries

2015-06-03 Thread John Mukulu
Hey Morten, Why [] in the filter, why not just plain ?filter=id:in:1,2,3 ?filter=name:in:John,Marie Concerning or with two different operators, you could probably introduce OR filter that overrides default AND logic, something like these: *type=int OR numberType=number*

Re: [Dhis2-devs-core] Update to like/ilike

2015-11-12 Thread John Mukulu
This is soo cool! Thanks Morten. On Nov 12, 2015 7:49 AM, "Morten Olav Hansen" wrote: > Hi everyone > > I just pushed some code that enables the new in-memory filter engine, in > that I have also added a few new operators, and updated a few old ones. > > The new operators are

Re: [Dhis2-devs-core] tip of the day: gmail filter for all unread emails for primary tab only

2016-06-22 Thread John Mukulu
Thanks lars John Francis Mukulu, Lead Developer, HISPTZ, University of Dar es salaam. http://hisptanzania.org/ On Jun 22, 2016 7:00 PM, "Lars Helge Øverland" wrote: > is:inbox -category:(updates OR promotions OR social OR forums) is:unread > > Put in search box and enter. Then

Re: [Dhis2-devs] [Dhis2-users] Table for SQL query for Indicators

2017-02-05 Thread John Mukulu
Hello Raminosoa, Analytics supports generation of query based on data, period and orgunit selection. You can use pivot table, select your periods, orgunits and indicators and use download option under advanced menu to download the query. I can't recall, but I think support for generation sql

Re: [Dhis2-devs] [Dhis2-users] About and Home Menu's hidden in the Pivot table

2017-02-09 Thread John Mukulu
Hello Muturi, The quick way around that problem is by resizing (zoom in and out) until you can see the menu. As Jan explain, you will experience this problem in small screens display or on a projector with lower resolutions. On 8 Feb 2017 01:55, "Jan Henrik Øverland" wrote: Hi

Re: [Dhis2-devs] [Dhis2-devs-core] switching to github for server-side code on tuesday

2016-08-29 Thread John Mukulu
Thanks for the updates. Looking forward to this. On Sun, Aug 28, 2016 at 1:29 PM, Lars Helge Øverland wrote: > Hi all, > > we will be transitioning the core source code branches from Launchpad to > Github on Tuesday this week (Aug 30). > > For developers - please do not make

Re: [Dhis2-devs-core] switching to github for server-side code on tuesday

2016-08-29 Thread John Mukulu
Thanks for the updates. Looking forward to this. On Sun, Aug 28, 2016 at 1:29 PM, Lars Helge Øverland wrote: > Hi all, > > we will be transitioning the core source code branches from Launchpad to > Github on Tuesday this week (Aug 30). > > For developers - please do not make

Re: [Dhis2-devs] [Dhis2-users] Completeness above 100% and inconsistency in reporting rates

2017-03-27 Thread John Mukulu
It's a design limitation issue, it's not a bug, and addressing it has implications on analytics, reports as well as way people will be assigning dataset to orgunits. So it will probably come in next releases, but unlikely to be backported to previous system because of breaking changes that will

Re: [Dhis2-devs] [Dhis2-users] Org unit lists

2017-04-06 Thread John Mukulu
Hello Saptarshi, Yes, there's a metadata repository on github with the orgunit lists, indicators, dashboard and more. There's also an application for browsing through the metadata and installing., you can install the app in your instance and download the metadata straight. See the app here:

Re: [Dhis2-devs] [Dhis2-users] Org unit lists

2017-04-11 Thread John Mukulu
com> wrote: > Dear Alvin > > John Mukulu also shared the metadata app though which any one can browse > through those metadata; https://play.dhis2.org/demo/api/apps/metabase2/ > index.html#/. > > If there is interest, me and my team can help to setup an repository for >

Re: [Dhis2-devs] [Dhis2-users] Org unit lists

2017-04-06 Thread John Mukulu
Hello again, Thanks for the feedback. Yes, the github repository is meant to be the core repository for all publicly shared repositories. If you have metadata you would like to contribute, you're warmly welcome to do so. I will get back to you soon with a fully fledged app with full detailed

Re: [Dhis2-devs] [Dhis2-users] Older war files

2017-07-10 Thread John Mukulu
You should be able to get as far back as 2.18 going forward with these URL https://www.dhis2.org/download/releases/2.18/dhis.war Just change version number in url. Though upgrade from version to version used to have upgrade notes on bunch of things to be done first.

Re: [Dhis2-devs] [Dhis2-users] Calculation of conditional Indicators

2017-05-10 Thread John Mukulu
Hello Prosper at all, As discussed earlier, we're working on rather complete solution to this problem, rather than work arounds, you can get a sneak peak, https://play.dhis2.org/dev/api/apps/function-manager/index.html The idea is you function will serve as analytics, but gives you room to

Re: [Dhis2-devs] [Dhis2-users] HOW TO SHARE SCORECARD RESULTS ON DASHBOARD

2017-05-23 Thread John Mukulu
Hello Stanley, Are you referring to HISP Tanzania interactive scorecard? If so, you can get the dashboard widget for it from hisptz appstore. http://appstore.hisptanzania.org/ On Tue, May 23, 2017 at 5:21 PM, Stanley Kalyati wrote: > How can i share the Scorecard results i

Re: [Dhis2-devs] [Dhis2-users] HOW TO SHARE SCORECARD RESULTS ON DASHBOARD

2017-05-24 Thread John Mukulu
gt; > Thanks > > Stanley > > > > On May 23, 2017 6:50 PM, "John Mukulu" <john.f.muk...@gmail.com> wrote: > >> Hello Stanley, >> Are you referring to HISP Tanzania interactive scorecard? If so, you can >> get the dashboard widget for it from hisptz ap

Re: [Dhis2-devs] [Dhis2-users] Calculation of conditional Indicators

2017-12-13 Thread John Mukulu
Hello Sam, We haven't made a formal release of this function maintenance app yet, but i thought i could keep you posted. It's already in appstore you can download it here: https://play.dhis2.org/appstore/app/dXX2Fk6jwCX You can take it for a spin here:

Re: [Dhis2-devs] SCORECARD V4

2017-12-07 Thread John Mukulu
Hello Stanley, That's a night build you've seen in development server, it still have couple of issues being fixed. It'll be uploaded to same appstore once all known issues are fixed. App store is https://play.dhis2.org/appstore We'll keep your posted. Cheers. John Francis Mukulu Lead

Re: [Dhis2-devs] [Dhis2-users] TAB IN CUSTOM FORMS

2017-12-08 Thread John Mukulu
Hello Stanley, There's a section form feature that supports tabs horizontal or vertical. But if it doesn't suit you, you can write your html form and use jQuery tab feature so it's rendered as custom form. See this link https://jqueryui.com/tabs/ John Francis Mukulu Lead Developer, HISPTZ

Re: [Dhis2-devs] DASHBOARD: NEXT BIG THING IS HERE

2017-12-11 Thread John Mukulu
hen switch mode. > > Regards > Calle > > On 11 December 2017 at 14:17, John Mukulu <john.f.muk...@gmail.com> wrote: > >> Great! >> Yes, we'll expand the amount of favorites >> >> Will get back to you later to also know the combination of fav

Re: [Dhis2-devs] CONTROLLING THE DIRECTION THE CURSOR-CUSTOM FORMS

2017-12-11 Thread John Mukulu
If your form is simple enough just add attribute tabindex to each input field and increment the number in the direction of input fields you want. Input boxes may look like this Though the catch is If you're inserting those input boxes with html editor, you'll need to edit those input boxes for

Re: [Dhis2-devs] DASHBOARD: NEXT BIG THING IS HERE

2017-12-11 Thread John Mukulu
Great! Yes, we'll expand the amount of favorites Will get back to you later to also know the combination of favorites you have, I.e. - More of pivot tables and charts than maps - More of aggregate data than events That'll really help to strain it further and identify where performance tuning is

Re: [Dhis2-devs] DASHBOARD: NEXT BIG THING IS HERE

2017-12-11 Thread John Mukulu
Hi Calle, Great to see you're taking it for a spin. And thanks for stress testing the dashboard. Certainly, we need to do further stress testing on such a scenario, and there's plenty of room for that. Would you mind letting us know version of dhis2 you're using. We'll setup an environment to

Re: [Dhis2-devs] DASHBOARD: NEXT BIG THING IS HERE

2017-12-11 Thread John Mukulu
ndicators makes little sense; a chart with 600 bars makes no sense either).Users can then first simply the pivot and then switch mode. Regards Calle On 11 December 2017 at 14:17, John Mukulu <john.f.muk...@gmail.com> wrote: Great! Yes, we'll expand the amount of favorites Will get ba

Re: [Dhis2-devs] DHIS2 Dashboard Apps

2018-04-28 Thread John Mukulu
These are very interesting topics, Just weigh in on few of the issues raised. 1. Way of widgets identifying themselves, this is actually supposed to be for all apps, to sort of have unique-app-id that'll unique like android apps, so names and version can change but it'll stay the same, this is

[Dhis2-devs] LAST AGGREGATION OPERATIONS

2018-04-28 Thread John Mukulu
Hello everyone, Has anyone tried the LAST aggregation operations for data elements in 2.29? Seems like impossible to create dataelements of such type and save them, and if you bypass web interface with direct api posts or changing operator directly on the database with query, analytics would

Re: [Dhis2-devs] How to perform logical operations in indicator calculations

2018-05-24 Thread John Mukulu
Hello Olaleke and Jason, We're currently slowly working through documenting the functions maintenance, but if you need quick intro and help on it, I have copied my Colleague Vincent Minde who's working on it, he'll help. Cheers. On Wed, May 23, 2018 at 6:25 PM, Olaleke Seweje

Re: [Dhis2-devs] [Dhis2-users] SCORE CARD 2.4 BETA 1.4

2018-06-14 Thread John Mukulu
Feel free to vote the issue up for it to be prioritized. John Francis Mukulu Software Architect, HISPTZ http://hisptanzania.org/ On Thu, Jun 14, 2018, 13:13 Stanley Kalyati wrote: > Thanks John,much appreciated > > On Thu, Jun 14, 2018, 11:53 John Mukulu wrote: > >> Hello St

Re: [Dhis2-devs] [Dhis2-users] SCORE CARD 2.4 BETA 1.4

2018-06-14 Thread John Mukulu
version 2.4 and thats the one that is not > working. > > On Thu, May 31, 2018 at 11:23 PM, John Mukulu > wrote: > > Try to download scorecard widget for version 2.4, make sure you're not > using widget for scorecard version 2.2 > > You can find out version you're using in ap

Re: [Dhis2-devs] [Dhis2-users] SCORE CARD 2.4 BETA 1.4

2018-06-15 Thread John Mukulu
t; On Thu, Jun 14, 2018, 11:53 John Mukulu wrote: > >> Hello Stanley and Selemani, >> Sorry for taking too long to work this out. >> >> After following up, we've come to agreement it's a bug in 2.29 dashboard, >> i've filed an issue in jira. >> https://jira.dhis

Re: [Dhis2-devs] [Dhis2-users] SCORE CARD 2.4 BETA 1.4

2018-05-31 Thread John Mukulu
Try to download scorecard widget for version 2.4, make sure you're not using widget for scorecard version 2.2 You can find out version you're using in app management. Let us know if you're still facing challenges with version 2.4 of the widget. John Francis Mukulu Software Architect, HISPTZ

Re: [Dhis2-devs] [Dhis2-users] SCORE CARD 2.4 BETA 1.4

2018-06-22 Thread John Mukulu
cifically download > from the site provided by you? > > Thanks again > > On Fri, Jun 22, 2018 at 1:43 PM John Mukulu > wrote: > >> Hello Again, >> The bug have been fixed please download latest war file from continous >> integration server: >> >> ht

Re: [Dhis2-devs] [Dhis2-users] SCORE CARD 2.4 BETA 1.4

2018-06-22 Thread John Mukulu
Hello Again, The bug have been fixed please download latest war file from continous integration server: https://ci.dhis2.org/job/dhis2-2.29/ On Fri, Jun 15, 2018 at 4:51 PM, John Mukulu wrote: > Hello Stanley and Selemani, > > I recommend you vote this issue, as i see it's been move

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

2018-03-07 Thread John Mukulu
Great Job Congratulations for major milestones on this release. John Francis Mukulu Software Architect, HISPTZ http://hisptanzania.org/ On Mar 8, 2018 00:40, "Lars Helge Øverland" wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >

Re: [Dhis2-devs] [Dhis2-users] dhis version 2.29 is released

2018-03-07 Thread John Mukulu
> channara >> >> On Thu, Mar 8, 2018 at 7:55 AM, Pamod Amarakoon <pam...@gmail.com> wrote: >> >>> Thank you and great job ! >>> >>> On Thu, Mar 8, 2018, 3:53 AM DJIBRIL Hakim <djib.ha...@gmail.com> wrote: >>> >>>&g

Re: [Dhis2-devs] [Dhis2-users] version 2.29 overview

2018-03-13 Thread John Mukulu
Thanks Lars, We're taking it for a spin, we'll getting back to you with feedback. Excellent job. On Tue, Mar 13, 2018 at 3:24 PM, Lars Helge Øverland wrote: > Hi, > > for those looking for brief overview of the features which went into 2.29 > (and found the release notes tl;dr

Re: [Dhis2-devs] importing Indicators in DHIS2

2018-03-15 Thread John Mukulu
Hello, Import via csv would be the best way for bulk import I hope that's the way you found in documentation, though it won't support auto importing of formula for numerator and denominator, that you'll have to go through web interface and modify. John Francis Mukulu Software Architect, HISPTZ

Re: [Dhis2-devs] [Dhis2-users] Indicators disappeared

2018-03-15 Thread John Mukulu
Hello Peter, All create, edit and delete operations on metadata usually have logs on the back-end, check logs in dhis2home to find our what happened. They may also disappear if sharing settings have been changed in user groups permissions to those objects, or they were made private by the creator.

Re: [Dhis2-devs] DHIS2 application

2018-03-18 Thread John Mukulu
I have not held of bulletin app, but Malaria program in Tanzania is having one powered fully by interactive dashboard. If you just want to customize it based on your dashboard you can find it in play.dhis2.org/appstore, if you want to completely tweak it to be very specific to your