Thanks Jason, I have seen it been dropped from 2.21, we will use these in the meantime
Regards On Tue, Oct 13, 2015 at 9:55 AM, Jason Pickering < [email protected]> wrote: > Hi Prosper, > > Yes, this functionality was dropped due to multiple complications with the > code. In older versions it is still there, but I would strongly encourage > you not ot use it. It was either non-functional in certain cases (but > appear to work through the UI) , or would possibly corrupt data in others > due to outdated logic in the code. > > In the meantime, I have added two SQL for PostgreSQL functions here > <https://github.com/dhis2/dhis2-utils/tree/master/resources/sql>. > > 1) SELECT * FROM delete_site_with_data(UID) where UID is the uid of the > "site" is required. This will drop all references to an organisation unit > with no children. It will not work if the site has children. This is needed > by the second script. You do not need to execute this, but rather it needs > to be present in the database. > > 2) SELECT * FROM merge_orgunits(source_uid,destination_uid); > > will merge two organisation units. There are a number of caveats > > a) Overlapping data which is not of type "INT", will be dropped from the > source organisation unit, in favor of the destination organisation unit. > > b) Events/tracker data is currently not supported. More code would need to > be added to handle this. > > You can probably modify these to suit your needs. We are still > contemplating putting the functionality back in, but it will be quite a bit > of work to get it right, and due to the possible differences in how > overlapping data should be handled between different instances of DHIS2, it > may require even more work to get it right. In the end, this is a quite > tricky operation, and may depend on specific logic of how to handle > overlapping data. If you have no overlapping data, then it should be pretty > simple to switch the organisation unit ID references, and then delete the > source organisation unit as usual. > > Hope this helps. > > Regards, > Jason > > > On Tue, Oct 13, 2015 at 6:44 AM, Prosper BT <[email protected]> wrote: > >> Dear Developers, >> >> For a long time with the different versions and builds the organisational >> unit merge has not been working, I have submitted bugs but not solutions. >> >> Was this dropped or? >> >> Regards >> >> -- >> Prosper Behumbiize, MPH >> Global HISP| University Of Oslo/HISP Uganda >> +256 752 751 776 | +256 776 139 139 >> [email protected] | [email protected] | Skype: prospertb >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: [email protected] > tel:+46764147049 > -- Prosper Behumbiize, MPH Global HISP| University Of Oslo/HISP Uganda +256 752 751 776 | +256 776 139 139 [email protected] | [email protected] | Skype: prospertb
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
