How do we remove Org Units not longer required

[rwardD4H]

We need to remove Bangladesh org units under VA global. This can't be done in DHIS2. We get a dependancy error (associations).

We have successfully uploaded Sri Lankan Org unit under VA global. But now want to remove or hide Bangladesh units as no longer relevant (for Sri Lanka).

[rwardD4H]

checking with David

[davidhuser]

There are a few ways to go about this:

a) Give users only access to Sri Lanka Org Units whenever you are creating a new user so they will not see those Org Units anywhere (except they are SuperUser)

b) Delete all events related to those orgunits, then deleting them "from bottom up". The dependency error means you attempted to delete an orgunit that still has children (e.g. deleting a District isn't possible because there are still Upazilas below)

c) Run the orgunit deletion database SQL script.

• If possible, do a backup or on a copy of a VM to test.

• Download the raw file in the VM:

wget https://raw.githubusercontent.com/dhis2/dhis2-utils/master/resources/sql/delete_orgunittree_with_data.sql

• import the SQL function file into the database:

psql -U dhis -d dhis2 -f /path/to/delete_orgunittree_with_data.sql

• run the function against the Bangladesh orgUnit:

select delete_orgunittree_with_data('gQx5Qrsrg8q');