dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Bayoh,
Please have a look at the two sql functions here

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

The first one, will delete a site with data, and is used by the second to
merge data according to different strategies.

This used to be available in the core, but has been removed for now, as it
was not implemented properly. Hopefully, it will be back soon.

In the meantime, you should be able to use or adjust these scripts to your
needs. We have used these successfully in production systems, but as
always, review it and make a backup.

Regards,
Jason


On Wed, Apr 20, 2016 at 3:02 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> Hi Ibrahim,
>
> Are you saying you have data for two separate orgunits, but now you want
> only to keep one of them?
>
> So, if malaria cases at Clinic A was 50 and Clinic B was 32, you want to
> just keep Clinic B, but add the data to 82?
>
> Knut
>
> On Wed, Apr 20, 2016 at 2:45 PM, Ibrahim Bayoh <
> ibrahim.bayoh@xxxxxxxxxxxxxxxxxxxx> wrote:
>
>> Hi All,
>> What is the best and prefered way to removing(delete) an org-units or
>> merging two org-units so the data in the other can be move to the unified
>> org-units.
>> As is now you can't delete an org-units that holds data.
>>
>> Thanks,
>> Bayoh.
>>
>> On Mon, Apr 18, 2016 at 3:50 PM, Ibrahim Bayoh <
>> ibrahim.bayoh@xxxxxxxxxxxxxxxxxxxx> wrote:
>>
>>> Hi All,
>>> What is the best and prefered way to removing(delete) an org-units or
>>> merging two org-units so the data in the other can be move to the unified
>>> org-units.
>>> As is now you can't delete an org-units that holds data.
>>>
>>> Thanks,
>>> Bayoh.
>>> --
>>> Ibrahim Rashid Bayoh
>>> Information Systems Coordinator,
>>> eHealth Africa(Sierra Leone)
>>> *117 Wilkinson Rd, Freetown, Sierra Leone*
>>> Mobile: +232 88-765-638
>>> ibrahim.bayoh@xxxxxxxxxxxxxxxxxxxx
>>> http://ehealthafrica.org/
>>>
>>>
>>
>>
>> --
>> Ibrahim Rashid Bayoh
>> Information Systems Coordinator,
>> eHealth Africa(Sierra Leone)
>> *117 Wilkinson Rd, Freetown, Sierra Leone*
>> Mobile: +232 88-765-638
>> ibrahim.bayoh@xxxxxxxxxxxxxxxxxxxx
>> http://ehealthafrica.org/
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049