Thanks. What I don't know is how the OrgUnitLevel would react - we'll need to update those too. I think they are linked through a simple number (and not a foreign key to the level table), but I may be wrong.
The script you shared is about deleting all data linked to a specific org unit, right ? Not sure how it related to levels. Martin On Mon, Sep 18, 2017 at 2:37 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Martin, > > I do not think we have anything specifically for that, but I think you > could write a short script > > 1) Reassign the direct descendants of the level you want to remove to the > desired level. This could be done through the API or SQL I guess. > 2) Use this script > <https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunit_with_data.sql> > to > remove the level. You would need to loop through all of the levels to > remove of course. > 3) Clear the cache and rebuild the orgunit paths. > > Regards, > Jason > > > On Mon, Sep 18, 2017 at 1:22 PM, Martin Van Aken <mar...@joyouscoding.com> > wrote: > >> Hello, >> We have a DHIS2 instance we support that already has data (Health >> Pyramid, Data Elements, DataValues). The system takes into account a level >> that is actually not used by most people and more importantly not by >> systems we need to integrate with. >> >> On a business side, it make sense removing it altogether - I'm wondering >> if someone already did something like that and how ? >> >> I can imagine something such as (supposing last level is 4 and we remove >> level 3): >> >> - Check any data linked to Org Unit of level 3 and backup/delete >> - Reattach all org unit of level 4 to their grand parent (level 2) >> - Delete level 3 entities >> - Regenerate or update the level 4 to 3 >> >> I suppose this would be easier done in the DB than with the API. >> >> Anyone with experience or advice on a process like that ? >> >> Thanks, >> >> Martin >> >> -- >> *Martin Van Aken - **Freelance Enthusiast Developer* >> >> Mobile : +32 486 899 652 >> >> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> >> Call me on Skype : vanakenm >> Hang out with me : mar...@joyouscoding.com >> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken >> Company website : www.joyouscoding.com >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 <+46%2076%20414%2070%2049> > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp