Merge multiple orgUnits DHIS2 2.24

Dear community,

Do you find the way to merge multiple orgUnits into a single one in DHIS2 2.24. Do you have suggestions on doing this manually or via web API?

Best,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

Hi there,
This functionality was removed from the core due to some issues with its implementation.

I have created two SQL functions which may help you to merge organisation units

  1. https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql

  2. https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql

You may need to make some changes to these scripts to suit your version, but we have used them on a few different production systems with success.

Hope this helps.

Regards,

Jason

···

On Tue, Jan 10, 2017 at 8:28 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear community,

Do you find the way to merge multiple orgUnits into a single one in DHIS2 2.24. Do you have suggestions on doing this manually or via web API?

Best,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Dear Jason,

Thank you for your response. I will use those SQL scripts to merge multiple orgUnits. I will be back in case of trouble.

Many thanks !

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

···

Le 10 janv. 2017 10:59 AM, “Jason Pickering” jason.p.pickering@gmail.com a écrit :

Hi there,
This functionality was removed from the core due to some issues with its implementation.

I have created two SQL functions which may help you to merge organisation units

  1. https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql
  1. https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql

You may need to make some changes to these scripts to suit your version, but we have used them on a few different production systems with success.

Hope this helps.

Regards,

Jason

On Tue, Jan 10, 2017 at 8:28 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear community,

Do you find the way to merge multiple orgUnits into a single one in DHIS2 2.24. Do you have suggestions on doing this manually or via web API?

Best,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049