Thanks very much, allow me to go through and implement the given knowledge On Sun, Jan 7, 2018 at 11:29 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote:
> 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 >> >> -- 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