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 <mailto: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
<mailto: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 <mailto: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
<https://launchpad.net/%7Edhis2-devs>
Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
<https://launchpad.net/%7Edhis2-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
<https://launchpad.net/%7Edhis2-devs>
Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
<https://launchpad.net/%7Edhis2-devs>
More help : https://help.launchpad.net/ListHelp
--
*******************************************
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472 <tel:%2B27-21-685-6472>
Cell: +27-82-853-5352 <tel:%2B27-82-853-5352>
Iridium SatPhone: +8816-315-19119 <tel:%2B8816-315-19119>
Email: calle.hedberg@xxxxxxxxx <mailto:calle.hedberg@xxxxxxxxx>
Skype: calle_hedberg
*******************************************
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
<https://launchpad.net/%7Edhis2-devs>
Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
<https://launchpad.net/%7Edhis2-devs>
More help : https://help.launchpad.net/ListHelp
--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx <mailto:jason.p.pickering@xxxxxxxxx>
tel:+46764147049
_______________________________________________
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
