Hi Guy, Well, not really sure you can- This functionality has been removed from the core, so this SQL script is only a work around until it gets back in.
Regards, Jason On Tue, Aug 30, 2016 at 11:04 AM, Guy Ekani <[email protected]> wrote: > hello Jason, > > Please how could we run this without creating a function ? > > Sincerely > > ========================= > EKANI Guy > > > > > > > Le Vendredi 29 juillet 2016 18h16, Jason Pickering < > [email protected]> a écrit : > > > They are deleted when you perform the merge by that function. > > On Fri, Jul 29, 2016, 19:01 gerald thomas <[email protected]> wrote: > > 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 <[email protected]> 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 <[email protected]> > > 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 : [email protected] > >> Unsubscribe : https://launchpad.net/~dhis2-users > >> More help : https://help.launchpad.net/ListHelp > >> > > > > > > > > -- > > Jason P. Pickering > > email: [email protected] > > tel:+46764147049 > > > > > -- > Regards, > > Gerald > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
