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

Thanks Jason, Nice output and the advantage is you do not have to join to the resource table _orgunitstructure. It is quite a complex query though, but still a nice example of using arrays and the path column. Thanks Ant On 11 January 2017 at 07:18, Jason Pickering wrote: > Here is another piec

[Dhis2-devs] 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

Re: [Dhis2-devs] [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 z.organisat

Re: [Dhis2-devs] [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 Tantely, > > Try

Re: [Dhis2-devs] [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, ou2.orga

[Dhis2-devs] 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-devs] [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. C

Re: [Dhis2-devs] [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 re

Re: [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? > > Regards, > Erl

Re: [Dhis2-devs] [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). https://ci.dhis2.org/docs/2.25/en/developer/html/dhis2_developer_manual_ful

Re: [Dhis2-devs] DataCapture

Hello, Have you tried the one on Google Play? Regards, Erling On Tue, Jan 10, 2017 at 12:02 PM Guy Ekani wrote: > 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, > > -- > ===

Re: [Dhis2-devs] [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 upgra

Re: [Dhis2-devs] [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 basem

[Dhis2-devs] 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-devs Post to : dhis2-d

Re: [Dhis2-devs] [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, 2017 4:49 PM To: Paul B

[Dhis2-devs] Extract CommCare cases and import into DHIS2

Hi, We just wanted to share a simple tool to routinely extract cases from CommCare and load them as anonymous events into DHIS 2. https://github.com/SwissTPH/commcare-cases-dhis2-events Feedback is welcome -- This email

[Dhis2-devs] How to reduce table columns

I am new to DHIS2 andI have a data entry form which does not fit onto the screen below; [cid:1ff26a80-d34c-43ed-ba0e-1ae6c7007c33] I want to reduce the size of the columns and the text boxes so that that it fits properly. Your assistance is greatly appreciated. regards, Paul _

[Dhis2-devs] 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. A

Re: [Dhis2-devs] [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 the core due to some issues with

Re: [Dhis2-devs] [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) https://github.com/dhis2/dhis