dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 <constyekani@xxxxxxxx> wrote:

> hello Jason,
>
> Please how could we run this without creating a function ?
>
> Sincerely
>
> =========================
> EKANI Guy
>
>
>
>
>
>
> Le Vendredi 29 juillet 2016 18h16, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> a écrit :
>
>
> They are deleted when you perform the merge by that function.
>
> On Fri, Jul 29, 2016, 19:01 gerald thomas <gerald17006@xxxxxxxxx> 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 <jason.p.pickering@xxxxxxxxx> 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 <gerald17006@xxxxxxxxx>
> > 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-users@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-users
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >
> >
> >
> > --
> > Jason P. Pickering
> > email: jason.p.pickering@xxxxxxxxx
> > tel:+46764147049
> >
>
>
> --
> Regards,
>
> Gerald
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to    : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help  : https://help.launchpad.net/ListHelp
>
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049