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" <knu...@gmail.com> 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...@gmail.com> 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@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 > >
_______________________________________________ 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
