dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

How much data would it be if you took everything?
On 19 Mar 2015 08:14, "Greg Rowles" <greg.rowles@xxxxxxxxx> 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 <markpo@xxxxxxxxxx> 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
>> mark@xxxxxxxxxxxxxxx
>> markpo@xxxxxxxxxx
>> +47 970 36 752
>>
>> On 19 Mar 2015, at 07:49, Greg Rowles <greg.rowles@xxxxxxxxx> 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.pickering@xxxxxxxxx> 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.rowles@xxxxxxxxx <
>>> greg.rowles@xxxxxxxxx> 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.rowles@xxxxxxxxx;
>>>> *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.rowles@xxxxxxxxx <
>>>> greg.rowles@xxxxxxxxx> 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
>>>>> mark@xxxxxxxxxxxxxxx
>>>>> markpo@xxxxxxxxxx
>>>>> +47 970 36 752 <+47%20970%2036%20752>
>>>>>
>>>>> On 18 Mar 2015, at 21:26, Greg Rowles <greg.rowles@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Jason P. Pickering
>>>> email: jason.p.pickering@xxxxxxxxx
>>>> tel:+46764147049
>>>>
>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.pickering@xxxxxxxxx
>>> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>