← Back to team overview

dhis2-users team mailing list archive

Re: Sharing Pivot Table details between DHIS instances

 

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
>
>

Follow ups

References