dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #50495
Re: merging facilities (org-units) without losing data
Hi Moses
We have some SQL scripts for this here.
https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql
This script will not handle tracker data but could probably be adapted
fairly easily to do so.
Regards,
Jason
On Jan 7, 2018 7:28 AM, "Knut Staring" <knutst@xxxxxxxxx> wrote:
> Hi Moses,
> I would take a backup of the database and then do this with an sql script,
> just changing the sourceid (the database internal referent to the
> organisationunitid) in the datavalues table. But you may get blocked if the
> same period has been filled for both, in which case you may want to do a
> "NOT IN" or left join.
>
> Knut
>
> On Jan 7, 2018 10:29, "moses mwale" <isoftcom.ic@xxxxxxxxx> wrote:
>
>> Hey devs is it possible to merge facilities without losing data, some
>> admin accidentally created other duplicates units into the system. anyone
>> knows how its done?
>>
>> developer_lusaka_systems
>>
>> _______________________________________________
>> 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
>
>
Follow ups
References