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@sl.ehealthafrica.org
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@sl.ehealthafrica.org 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 Rashid Bayoh
Information Systems Coordinator,
eHealth Africa(Sierra Leone)
117 Wilkinson Rd, Freetown, Sierra Leone
Mobile: +232 88-765-638
ibrahim.bayoh@sl.ehealthafrica.org
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@sl.ehealthafrica.org 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.
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
On Mon, Apr 18, 2016 at 3:50 PM, Ibrahim Bayoh ibrahim.bayoh@sl.ehealthafrica.org 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 Rashid Bayoh
Information Systems Coordinator,
eHealth Africa(Sierra Leone)
117 Wilkinson Rd, Freetown, Sierra Leone
Mobile: +232 88-765-638
ibrahim.bayoh@sl.ehealthafrica.org
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
@Knut that exactly my case. I will like add orgunit B to A and Delete B.
On Wed, Apr 20, 2016 at 1:02 PM, Knut Staring knutst@gmail.com 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@sl.ehealthafrica.org 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.
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
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
–
On Mon, Apr 18, 2016 at 3:50 PM, Ibrahim Bayoh ibrahim.bayoh@sl.ehealthafrica.org 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 Rashid Bayoh
Information Systems Coordinator,
eHealth Africa(Sierra Leone)
117 Wilkinson Rd, Freetown, Sierra Leone
Mobile: +232 88-765-638
ibrahim.bayoh@sl.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@sl.ehealthafrica.org
Hi Bayoh,
Please have a look at the two sql functions here
https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql
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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
On Wed, Apr 20, 2016 at 2:45 PM, Ibrahim Bayoh ibrahim.bayoh@sl.ehealthafrica.org 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.
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
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
–
On Mon, Apr 18, 2016 at 3:50 PM, Ibrahim Bayoh ibrahim.bayoh@sl.ehealthafrica.org 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 Rashid Bayoh
Information Systems Coordinator,
eHealth Africa(Sierra Leone)
117 Wilkinson Rd, Freetown, Sierra Leone
Mobile: +232 88-765-638
ibrahim.bayoh@sl.ehealthafrica.org
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
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@gmail.com wrote:
Hi Bayoh,
Please have a look at the two sql functions here
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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On Wed, Apr 20, 2016 at 2:45 PM, Ibrahim Bayoh ibrahim.bayoh@sl.ehealthafrica.org 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.
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
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
–
On Mon, Apr 18, 2016 at 3:50 PM, Ibrahim Bayoh ibrahim.bayoh@sl.ehealthafrica.org 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 Rashid Bayoh
Information Systems Coordinator,
eHealth Africa(Sierra Leone)
117 Wilkinson Rd, Freetown, Sierra Leone
Mobile: +232 88-765-638
ibrahim.bayoh@sl.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@sl.ehealthafrica.org