Hi Hannan, There were issues with the implementation in DHIS2, and it could have caused major havoc with the data, depending on the situation, thus there was a decision to remove this for now. I think the devs are working on a more permanent fix, but in the time being, I created two Postgresql functions (if you are using MySQL..these will not work).
The first, is to delete sites with data. https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql and then to merge them (which depends on the first function) https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql Absolutely no warranty on this, so be sure to test very thoroughly your self! The merge function accepts different strategies (MIN, MAX, SUM, AVG, LATEST, FIRST) for numeric data. Non-aggregatable data (option sets, text, etc) will use the "latest" data in case of conflicts. You can of course tweak this to your needs. Good luck! Regards, Jason On Wed, Feb 24, 2016 at 11:43 AM, Hannan Khan <[email protected]> wrote: > Dear Experts > > From version 2.21 the "Organisation unit merge" function are discontinued. > In some context this was very useful. Can it be added back again? > > Or I have to write SQL query to manually merge that. > > Regards > > Hannan Khan > HISP Bangladesh > -- 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
