[Dhis2-users] The DHIS 2 Tracker Academy - Goa 2017 is coming up. Register now!

* * *20 - 24 February* *2017* *DHIS 2 Tracker Academy - Goa 2017* We are pleased to announce the "DHIS 2 Tracker Academy, Level 1 - Goa 2017" to be held at "The International Centre, Goa" from Feb

Re: [Dhis2-users] SQL View to output all levels of orgUnits

Here is another piece of SQL which will transform the "path" to names. You can then join this clause with your organisation unit table (or whatever) on the organisationunitid property. It presents all names in a single column, as opposed to the multiple columns in Ant's example SELECT

Re: [Dhis2-users] SQL View to output all levels of orgUnits

I should also add that by changing the where clause you can use this code for any level, for example if you change it to: where ous.level = 6 you will only get the structure for your level 6 orgunits Regards Ant Snyman On 11 January 2017 at 07:05, Ant Snyman wrote: > Hi

Re: [Dhis2-users] SQL View to output all levels of orgUnits

Hi Tantely, Try the code below. I normally exclude OU1 in the list because that is generally the country code and just makes the report even more wide. Regards Ant Snyman SELECT ous.level, ou2.name as ou2_name, ou2.shortname as ou2_shortnamme, ou2.uid as ou2_uid, ou2.code as ou2_code,

[Dhis2-users] SQL View to output all levels of orgUnits

Dear Community, I am trying to output a list of all the orgUnits from the SQLView (DHIS2 2.24). I would like to have all the information of all the levels of the orgUnits for each of the 6 levels implemented. I would like to have a result in the following form: orgUnitName (level6), orgUnitName

Re: [Dhis2-users] DHIS 2 (Version 2.23): Data doesn't display in DHIS Pivot table even after running analytics

Thanks again for your help, Now that you mentioned consistency of parameters,I've re-examined the setup and suspect I may have erroneously excluded a few category and data element components when importing meta-data. Allow me to revert as soon as I review the imports for further assistance.

Re: [Dhis2-users] DHIS 2 (Version 2.23): Data doesn't display in DHIS Pivot table even after running analytics

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.

Re: [Dhis2-users] DHIS 2 (Version 2.23): Data doesn't display in DHIS Pivot table even after running analytics

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

Re: [Dhis2-users] DHIS 2 (Version 2.23): Data doesn't display in DHIS Pivot table even after running analytics

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

[Dhis2-users] DHIS 2 (Version 2.23): Data doesn't display in DHIS Pivot table even after running analytics

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

Re: [Dhis2-users] [Dhis2-devs] DataCapture

Thank u Erling, It seems that the one actualiy on Google Play don't synchronising with our version of DHIS 2.24 #704143a Sincerely, = EKANI Guy On Tue, Jan 10, 2017 at 2:03 PM, Erling Fjelstad wrote: > Hello, > Have you tried the one on Google Play?

Re: [Dhis2-users] how to set "scheduling automated aggregation"

Dear Channara, if you want to run aggregations at your own intervals you can trigger them via the web-api /api/25/resourceTables/analytics, e.g. with curl in a cron-job. (I am using a step in kettle after loading data).

Re: [Dhis2-users] Error on GIS

Hi Mahbubul, Google Maps have changed policies and this is fixed in DHIS 2.23 and above. I would advice you to upgrade your DHIS 2 instance, as there are several new GIS features in 2.23, 2.24 and 2.25 - and the upcoming 2.26. If you still need to use DHIS 2.21, you can use the OpenStreetMap

Re: [Dhis2-users] Error on GIS

Dear Mahbub Google Map change there policy, as Bjørn already mentioned, upgrade to upper version version. As our Director General Health is instructed we are in process to work together with IEDCR and we are in process to meet your director and relevant person soon. Also we can help you to

[Dhis2-users] DataCapture

Hello Team, Happy New Year ! Please could you share the good DHIS2 Data Capture APK that's working fine with DHis 2.24#704143a Sincerely, -- = EKANI Guy ___ Mailing list: https://launchpad.net/~dhis2-users Post to :

Re: [Dhis2-users] How to reduce table columns

Dear Prosper, I have checked the style on the source code and is, style="width:3em///" on each text box. Is it proper CSS to have tripple slashes '///' or double slashes '//'. regards, Paul From: Prosper BT Sent: Monday, January 9,

[Dhis2-users] Error on GIS

Dear Team, Hope you doing well. we facing some problem with GIS on DHIS2 version 2.21 please see the attached screenshot for error details. Plz help.. -- [image: http://iedcr.gov.bd/images/stories/logo_new.jpg] Thanks *Mahbubul Alam* | "*IT Consultant*" (GHSA Project) Msc in CSE, Bsc in CSc.

Re: [Dhis2-users] Merge multiple orgUnits DHIS2 2.24

Dear Jason, Thank you for your response. I will use those SQL scripts to merge multiple orgUnits. I will be back in case of trouble. Many thanks ! Tantely. Le 10 janv. 2017 10:59 AM, "Jason Pickering" a écrit : > Hi there, > This functionality was removed from

Re: [Dhis2-users] Merge multiple orgUnits DHIS2 2.24

Hi there, This functionality was removed from the core due to some issues with its implementation. I have created two SQL functions which may help you to merge organisation units 1) https://github.com/dhis2/dhis2-utils/blob/master/ resources/sql/merge_orgunits.sql 2)