Not sure if this will become an app or not, too early to tell. I think
Jason's json URL will definitely work! Thanks guys!
On Thu, Mar 19, 2015 at 11:52 AM, Mark Polak <mar...@ifi.uio.no> wrote:
> Yes exactly, but we’re not sure if he’s building an app, or importing it
> somewhere. But non the less i agree that should be easy enough to do.
>
> Kind regards,
>
> Mark Polak
> m...@thedutchies.com
> mar...@ifi.uio.no
> +47 970 36 752
>
> On 19 Mar 2015, at 10:51, Jason Pickering <jason.p.picker...@gmail.com>
> wrote:
>
> OK, but but the "level" attribute is numeric, and seems it could easily be
> sorted by the client?
>
>
> {"created":"2015-03-19T09:46:38.286+0000","organisationUnitLevels":[{"name":"District","created":"2011-12-24T11:24:22.935+0000","lastUpdated":"2014-04-29T18:23:38.202+0000","externalAccess":false,
> "level":2,
> "id":"wjP19dkFeIk"},{"name":"Chiefdom","created":"2011-12-24T11:24:22.935+0000","lastUpdated":"2014-04-29T18:23:38.209+0000","externalAccess":false,
> "level":3,
> "id":"tTUf91fCytl"},{"name":"National","created":"2011-12-24T11:24:22.935+0000","lastUpdated":"2014-04-29T18:23:38.212+0000","externalAccess":false,
> "level":1,
> "id":"H1KlN4QIauv"},{"name":"Facility","created":"2011-12-24T11:24:22.935+0000","lastUpdated":"2014-04-29T18:23:38.215+0000","externalAccess":false,"
> level":4,"id":"m9lBJogzE95"}]}
>
> On Thu, Mar 19, 2015 at 10:49 AM, Mark Polak <mar...@ifi.uio.no> wrote:
>
>> It does return the orgunit levels, but Greg’s initial request was to
>> return them ordered by level instead of name. :)
>>
>> Kind regards,
>>
>> Mark Polak
>> m...@thedutchies.com
>> mar...@ifi.uio.no
>> +47 970 36 752
>>
>> On 19 Mar 2015, at 10:47, Jason Pickering <jason.p.picker...@gmail.com>
>> wrote:
>>
>> Does this not provide what you need?
>>
>>
>> https://apps.dhis2.org/demo/api/metaData.json?assumeTrue=false&organisationUnitLevels=true
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Thu, Mar 19, 2015 at 9:27 AM, Greg Rowles <greg.row...@gmail.com>
>> wrote:
>>
>>> Is there any chance we could get organisationUnitLevels data added into
>>> the [metaData] branch of the JSON output?
>>>
>>> On Thu, Mar 19, 2015 at 10:10 AM, Mark Polak <mar...@ifi.uio.no> wrote:
>>>
>>>> If you are indeed building your own app, you can also sort the levels
>>>> on the client :)
>>>>
>>>> Kind regards,
>>>>
>>>> Mark Polak
>>>> m...@thedutchies.com
>>>> mar...@ifi.uio.no
>>>> +47 970 36 752
>>>>
>>>> On 19 Mar 2015, at 08:47, Abyot Gizaw <aby...@gmail.com> wrote:
>>>>
>>>> Seems you are creating your own app? If so, you can fetch OUs based on
>>>> level whenever drill down/up is triggered
>>>>
>>>> -----
>>>> Thank you,
>>>> Abyot.
>>>>
>>>> (sent from mobile)
>>>> On Mar 19, 2015 8:14 AM, "Greg Rowles" <greg.row...@gmail.com> wrote:
>>>>
>>>>> Hi Mark
>>>>>
>>>>> My JSON request:
>>>>>
>>>>> api/analytics.json?dimension=pe:LAST_3_MONTHS&dimension=dx:trqWVUf9e6D;lPVvmrINVHS;eDktBD88IUL&dimension=ou:LEVEL-3;JLA7wl59oN3&hierarchyMeta=true&displayProperty=NAME&showHierarchy=true
>>>>>
>>>>> The objective is to reconstruct JSON to include columns for all
>>>>> parent-orgunits.
>>>>>
>>>>> Some background to this - we have several reports specified in 'pivot
>>>>> table' layout but we need to make these outputs drill-through. Reporting
>>>>> is
>>>>> expected down to facility level for the last 3 months for the entire
>>>>> country - I assume this amount of data would probably choke the browser so
>>>>> I'm wanting to create a dynamic HTML report with drill-through
>>>>> capabilities
>>>>> but starting at regional levels. The current 'show hierarchy'
>>>>> functionality
>>>>> in pivot tables is insufficient plus it does not support drill-through
>>>>> 'mining'. I was planning on using PivotTable.js to accomplish this...
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Mar 19, 2015 at 8:56 AM, Mark Polak <mar...@ifi.uio.no> wrote:
>>>>>
>>>>>> If you’re getting the data in JSON format. And you’re using it to
>>>>>> reconstruct something, how are you retrieving this data? Otherwise it
>>>>>> would
>>>>>> be trivial to sort it on your side?
>>>>>>
>>>>>> Kind regards,
>>>>>>
>>>>>> Mark Polak
>>>>>> m...@thedutchies.com
>>>>>> mar...@ifi.uio.no
>>>>>> +47 970 36 752
>>>>>>
>>>>>> On 19 Mar 2015, at 07:49, Greg Rowles <greg.row...@gmail.com> wrote:
>>>>>>
>>>>>> Thanks Jason, I'll do some testing. I know offhand of a viewClass
>>>>>> parameter but it may not be applicable to this object, will see...
>>>>>>
>>>>>> Best,
>>>>>> Greg
>>>>>>
>>>>>> On Thu, Mar 19, 2015 at 7:46 AM, Jason Pickering <
>>>>>> jason.p.picker...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi Greg,
>>>>>>>
>>>>>>> Yeah, I can understand that. Jan can probably provide more detail
>>>>>>> here, but for instance
>>>>>>>
>>>>>>> [1]https://apps.dhis2.org/demo/api/organisationUnitLevels/
>>>>>>>
>>>>>>> gives you all levels
>>>>>>>
>>>>>>> [2]
>>>>>>> https://apps.dhis2.org/demo/api/organisationUnitLevels/H1KlN4QIauv
>>>>>>>
>>>>>>> gives you the number of the level, in this case 1. You could do this
>>>>>>> for each level.
>>>>>>>
>>>>>>> [3]
>>>>>>> https://apps.dhis2.org/demo/api/organisationUnits?filter=level:eq:1
>>>>>>>
>>>>>>> Gives all units at a given level, or
>>>>>>>
>>>>>>>
>>>>>>> https://apps.dhis2.org/demo/api/organisationUnits?fields=id,level,name,parent[id]&paging=false
>>>>>>>
>>>>>>> which would give you a list which you could then recursively parse
>>>>>>> to get what you need I think.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Jason
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Thu, Mar 19, 2015 at 6:34 AM, greg.row...@gmail.com <
>>>>>>> greg.row...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Hi Jason
>>>>>>>>
>>>>>>>> Yes, we've considered that but we want to avoid depending on
>>>>>>>> SQlviews for everything (too many variations need to be built to cater
>>>>>>>> for
>>>>>>>> different OUlevels) which becomes something of a db mgmt concern. I
>>>>>>>> will
>>>>>>>> try a different method of looking up OUlevels - that sequence issue
>>>>>>>> would
>>>>>>>> have made things really simple though.
>>>>>>>>
>>>>>>>> In DHIS 1.4 we associated a level number with a level name. I see
>>>>>>>> this was not implemented in DHIS2... Does anyone know why not?
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Greg
>>>>>>>>
>>>>>>>> ------ Original message------
>>>>>>>> *From: *Jason Pickering
>>>>>>>> *Date: *Thu, 19 Mar 2015 07:10
>>>>>>>> *To: *greg.row...@gmail.com;
>>>>>>>> *Cc: *Mark Polak;DHIS 2 developers;
>>>>>>>> *Subject:*Re: [Dhis2-devs] api/organisationUnitLevels
>>>>>>>>
>>>>>>>> Hi Greg,
>>>>>>>> Have you considered (if it is possible for you) to use an SQL view
>>>>>>>> for this? Sounds like it would be rather trivial to generate this view
>>>>>>>> from
>>>>>>>> the _orgunitstructure table by joining with the organisationunit
>>>>>>>> table. May
>>>>>>>> not be feasible in this case, but might save a bit of trouble on the
>>>>>>>> client
>>>>>>>> side.
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Jason
>>>>>>>>
>>>>>>>>
>>>>>>>> On Thu, Mar 19, 2015 at 6:06 AM, greg.row...@gmail.com <
>>>>>>>> greg.row...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Hi Mark
>>>>>>>>>
>>>>>>>>> I'm reconstructing the JSON output called by the analytics API to
>>>>>>>>> (hopefully) give me the parent hierarchy structure in individual
>>>>>>>>> "columns".
>>>>>>>>> This ties in with my previous email about SHORTNAME outputting long
>>>>>>>>> NAME
>>>>>>>>> values for the ouNameHierarchy collection. I'm trying to split
>>>>>>>>> ouNameHierarchy
>>>>>>>>> into its different parent values for use in a custom report.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>> Greg
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ------ Original message------
>>>>>>>>> *From: *Mark Polak
>>>>>>>>> *Date: *Wed, 18 Mar 2015 22:44
>>>>>>>>> *To: *Greg Rowles;
>>>>>>>>> *Cc: *DHIS 2 developers;
>>>>>>>>> *Subject:*Re: [Dhis2-devs] api/organisationUnitLevels
>>>>>>>>>
>>>>>>>>> Hey Greg,
>>>>>>>>>
>>>>>>>>> Unfortunately i don’t think sorting through the api is available
>>>>>>>>> “yet”.
>>>>>>>>>
>>>>>>>>> What are you using it for?
>>>>>>>>>
>>>>>>>>> Kind regards,
>>>>>>>>>
>>>>>>>>> Mark Polak
>>>>>>>>> m...@thedutchies.com
>>>>>>>>> mar...@ifi.uio.no
>>>>>>>>> +47 970 36 752 <+47%20970%2036%20752>
>>>>>>>>>
>>>>>>>>> On 18 Mar 2015, at 21:26, Greg Rowles <greg.row...@gmail.com>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>> Hi Devs
>>>>>>>>>
>>>>>>>>> Is it possible to have the organisationUnitLevels stack outputted
>>>>>>>>> in the sequence the hierarchy is arranged? E.g. it appears to be
>>>>>>>>> sorted by
>>>>>>>>> name value with 'National' always appearing down the list (it
>>>>>>>>> should be 1st)...
>>>>>>>>>
>>>>>>>>> Best,
>>>>>>>>> Greg
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> *Health Information Systems Program - South Africa*
>>>>>>>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **-
>>>>>>>>> - - - - *
>>>>>>>>> Mobile : 073 246 2992
>>>>>>>>> Landline: 021 554 3130
>>>>>>>>> Fax: 086 733 8432
>>>>>>>>> Skype: gregory_rowles
>>>>>>>>> _______________________________________________
>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>>> Post to : dhis2-devs@lists.launchpad.net
>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>>> More help : https://help.launchpad.net/ListHelp
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>>> Post to : dhis2-devs@lists.launchpad.net
>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>>> More help : https://help.launchpad.net/ListHelp
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Jason P. Pickering
>>>>>>>> email: jason.p.picker...@gmail.com
>>>>>>>> tel:+46764147049
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Jason P. Pickering
>>>>>>> email: jason.p.picker...@gmail.com
>>>>>>> tel:+46764147049
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Health Information Systems Program - South Africa*
>>>>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- -
>>>>>> - - - *
>>>>>> Mobile : 073 246 2992
>>>>>> Landline: 021 554 3130
>>>>>> Fax: 086 733 8432
>>>>>> Skype: gregory_rowles
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *Health Information Systems Program - South Africa*
>>>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- -
>>>>> - - - *
>>>>> Mobile : 073 246 2992
>>>>> Landline: 021 554 3130
>>>>> Fax: 086 733 8432
>>>>> Skype: gregory_rowles
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to : dhis2-devs@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> *Health Information Systems Program - South Africa*
>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - -
>>> - - *
>>> Mobile : 073 246 2992
>>> Landline: 021 554 3130
>>> Fax: 086 733 8432
>>> Skype: gregory_rowles
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049
>>
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
>
>
--
*Health Information Systems Program - South Africa*
*- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - *
Mobile : 073 246 2992
Landline: 021 554 3130
Fax: 086 733 8432
Skype: gregory_rowles
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
