dhis2-users team mailing list archive

[Ibrahim Bayoh <ibrahim.bayoh@xxxxxxxxxxxxxxxxxxxx>]

Thanks Jason and Knut, I will try these steps and revert if i need anymore
assistance.



On Wed, Apr 20, 2016 at 1:07 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> 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
>



-- 
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/