Dear Jason, Thanks for your help and i will do a test on my laptop. How can i delete these facilities after merging
On 7/29/16, Jason Pickering <jason.p.picker...@gmail.com> wrote: > Hi Gerald, > This has been raised a few times on the list already. There were some > serious flaws with that functionality, and it was removed and has yet to be > put back in place. > > In the meantime, you can try this > > https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql > > and call it directly from the database with > > SELECT * FROM merge_organisationunits('SOURCE', 'DESTINATION', 'STRATEGY'); > > where > > SOURCE = the source orgunit UID > DESTINATION = the destination orgunit UID > STRATEGY= one of SUM,MAX,MIN,AVG,LAST,FIRST > > each of those paramaters should be encased with single-quotes. > > > It goes without saying, this should be thoroughly tested on your > non-production system before attempting it on your production machine, as > it is a destructive function (meaning things get permanently deleted). > > Regards, > Jason > > > On Fri, Jul 29, 2016 at 6:05 PM, gerald thomas <gerald17...@gmail.com> > wrote: > >> Dear All, >> On previous DHIS2 version we were using merge for duplicate sites but >> on version 2.22 i can't find merge. Please can someone help me? >> >> Also, after merging i will like to remove the duplicate facility, what >> are the procedures to remove or delete a facility. >> >> Thanks in advance for your help >> >> -- >> Regards, >> >> Gerald >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-us...@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 > -- Regards, Gerald _______________________________________________ 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