dhis2-devs team mailing list archive

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

Hi there.
I have added a Postgresql function to delete a site with data here
<https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql>
.

Use at your own risk, but we have used this successfully in production
systems.

Regards,
Jason


On Wed, Apr 13, 2016 at 8:37 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
wrote:

> Hi,
>
> Alex and my posts crossed: if you want to keep that historic data, follow
> Alex' suggestion. But if you want to get rid of it - the data might be
> irrelevant or duplicates - then using a script is easiest.
>
> As far as I know, there is no "Prune Organisational Units" functionality
> (which would completely remove Orgunits with all their data) in DHIS2
> similar to the functionality in DHIS 1.4
>
> Regards
> Calle
>
> On 13 April 2016 at 13:32, Alex Tumwesigye <atumwesigye@xxxxxxxxx> wrote:
>
>> Dear Mohamed,
>>
>> Untag them from datasets. They will not affect your reporting rates and
>> completeness.
>>
>> If you delete them, you will be deleting historical data (which I think
>> you want).
>> How I have solved this problem in Uganda, I always tag them as closed or
>> Non functional using an organisation Unit Group Set.
>>
>> Alex
>>
>> On Wed, Apr 13, 2016 at 2:24 PM, Mohamed Bangura <mbangs87@xxxxxxxxx>
>> wrote:
>>
>>> Hi all,
>>>
>>> We are currently trying to delete old facilities from our main server
>>> but nothing seems to be happening since these facilities already have
>>> data.Is there a way one can do this or disable the facilities as this
>>> is currently affecting the completeness of our data.
>>>
>>> I need your help please.
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>>
>> --
>> Alex Tumwesigye
>>
>> Technical Advisor - DHIS2 (Consultant),
>> Ministry of Health/AFENET
>> Kampala
>> Uganda
>> +256 774149 775, + 256 759 800161
>> Skype ID: talexie
>>
>> IT Consultant (Servers, Networks and Security, Health Information Systems
>> - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant
>>
>>
>> "I don't want to be anything other than what I have been - one tree hill "
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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