← Back to team overview

dhis2-users team mailing list archive

Re: Sharing Pivot Table details between DHIS instances

 

I guess I am talking about somehow parametrizing the PT favorites - and
being able to share the parametrizable favorites between DHIS2 instances.


On Fri, Jun 20, 2014 at 4:39 AM, Knut Staring <knutst@xxxxxxxxx> wrote:

> While I agree on the recommendation of a common meta-data repository for
> Data Elements and Indicators, this obviously does not help in the least
> when it comes to OrgUnits in different countries. We have OrgUnit as a
> parameter in the "ordinary" reports, but not for pivot tables (periods are
> of course already standardised across most countries -  those that use ISO
> calendars).
>
> I suppose the question highlights the increasing use of more flexible PT
> for reporting in addition to (or completely replacing) conventional
> reports. Does it make sense to think of an App that makes it easy to pass
> parameters (OU, periods) to ready-made pivot layouts - or would that really
> just be recreating the PT GUI? Is the API already capable of handling this?
>
> Knut
>
>
>
> On Thu, Jun 19, 2014 at 8:49 PM, Greg Rowles <greg.rowles@xxxxxxxxx>
> wrote:
>
>> Hi, Also agree with the abovementioned. We're working towards a "master"
>> data-dictionary for indicator and data element definitions to ensure
>> alignment and standardization here in South Africa. It might be good to
>> begin assessing alignment possibilities starting with indicators as they
>> determine which elements get collected...
>>
>> Regards,
>> Greg
>>
>>
>>
>> On Thu, Jun 19, 2014 at 8:33 PM, Lars Helge Øverland <larshelge@xxxxxxxxx
>> > wrote:
>>
>>> Hi, agree with Jason. On an additional note, if the meta-data (data
>>> elements in particular) actually are consistent across several instances it
>>> might be a good effort to standardize the UID, will be useful if you want
>>> to do comparative analysis across countries at a later stage.
>>>
>>> Lars
>>>
>>>
>>>
>>>
>>> On Thu, Jun 19, 2014 at 7:34 PM, Jason Pickering <
>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>
>>>> I would think the best way to go about this would be to have a common
>>>> meta-data repository. It would seem to be quite a bit of effort to try and
>>>> map metadata definitions between different instances, but the usual
>>>> approach here would be to have a "master" instance, which other "slave"
>>>> instances would draw their metadata from. In this case, the exchange of
>>>> pivots/reports would be possible, but very troublesome otherwise.
>>>>
>>>> It is certainly possible, but building the transformation would be one
>>>> more piece to maintain and would be quite fragile, as changes on either
>>>> side would break it.
>>>>
>>>> Best regards,
>>>> Jason
>>>>
>>>>
>>>>
>>>> On Thu, Jun 19, 2014 at 7:29 PM, Laura E. Lincks <
>>>> laura.lincks@xxxxxxxxxxxxxxxxx> wrote:
>>>>
>>>>> We have individual DHIS instances installed for individual countries.
>>>>> Many configuration needs are similar across countries including the set up
>>>>> of many reports. Is it possible to take a pivot table definition set up in
>>>>> one country and export that definition to another country's DHIS instance?
>>>>> I see that details can be exported for a pivot table using Meta-Data Export
>>>>> but it of course contains unique identifiers for that country which will
>>>>> not apply in another country's instance. Is there a way to query the data
>>>>> from the backend, create an output script, changing the unique IDs to the
>>>>> new country's respective IDs and then insert the data in the new country's
>>>>> database? It may be more trouble doing it that way than simply manually
>>>>> creating the pivot table structures in the new country, but I thought I'd
>>>>> ask if anyone has had success doing it in a more automated fashion.
>>>>>
>>>>> --
>>>>>
>>>>> *Laura E. Lincks*
>>>>> Database Developer
>>>>> ICAP - Columbia University
>>>>> Mailman School of Public Health
>>>>> 60 Haven Ave, Floor B1
>>>>> New York, NY 10032
>>>>> Tel: 212 304 7132
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>>
>> Business Intelligence Planner
>> *Health Information Systems Programme*
>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - -
>> - *
>> Mobile  :    073 246 2992
>> Landline:   021 554 3130
>> Fax:          086 733 8432
>> Skype:      gregory_rowles
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

Follow ups

References