Thanks Jason and Knut, I will try these steps and revert if i need anymore assistance.
On Wed, Apr 20, 2016 at 1:07 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Bayoh, > Please have a look at the two sql functions here > > 1) > https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql > 2) > https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql > > The first one, will delete a site with data, and is used by the second to > merge data according to different strategies. > > This used to be available in the core, but has been removed for now, as it > was not implemented properly. Hopefully, it will be back soon. > > In the meantime, you should be able to use or adjust these scripts to your > needs. We have used these successfully in production systems, but as > always, review it and make a backup. > > Regards, > Jason > > > On Wed, Apr 20, 2016 at 3:02 PM, Knut Staring <knu...@gmail.com> wrote: > >> Hi Ibrahim, >> >> Are you saying you have data for two separate orgunits, but now you want >> only to keep one of them? >> >> So, if malaria cases at Clinic A was 50 and Clinic B was 32, you want to >> just keep Clinic B, but add the data to 82? >> >> Knut >> >> On Wed, Apr 20, 2016 at 2:45 PM, Ibrahim Bayoh < >> ibrahim.ba...@sl.ehealthafrica.org> wrote: >> >>> Hi All, >>> What is the best and prefered way to removing(delete) an org-units or >>> merging two org-units so the data in the other can be move to the unified >>> org-units. >>> As is now you can't delete an org-units that holds data. >>> >>> Thanks, >>> Bayoh. >>> >>> On Mon, Apr 18, 2016 at 3:50 PM, Ibrahim Bayoh < >>> ibrahim.ba...@sl.ehealthafrica.org> wrote: >>> >>>> Hi All, >>>> What is the best and prefered way to removing(delete) an org-units or >>>> merging two org-units so the data in the other can be move to the unified >>>> org-units. >>>> As is now you can't delete an org-units that holds data. >>>> >>>> Thanks, >>>> Bayoh. >>>> -- >>>> Ibrahim Rashid Bayoh >>>> Information Systems Coordinator, >>>> eHealth Africa(Sierra Leone) >>>> *117 Wilkinson Rd, Freetown, Sierra Leone* >>>> Mobile: +232 88-765-638 >>>> ibrahim.ba...@sl.ehealthafrica.org >>>> http://ehealthafrica.org/ >>>> >>>> >>> >>> >>> -- >>> Ibrahim Rashid Bayoh >>> Information Systems Coordinator, >>> eHealth Africa(Sierra Leone) >>> *117 Wilkinson Rd, Freetown, Sierra Leone* >>> Mobile: +232 88-765-638 >>> ibrahim.ba...@sl.ehealthafrica.org >>> http://ehealthafrica.org/ >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> Norway: +4791880522 >> Skype: knutstar >> http://dhis2.org >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 > -- Ibrahim Rashid Bayoh Information Systems Coordinator, eHealth Africa(Sierra Leone) *117 Wilkinson Rd, Freetown, Sierra Leone* Mobile: +232 88-765-638 ibrahim.ba...@sl.ehealthafrica.org http://ehealthafrica.org/
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
