Colleagues,
My colleague entered a tracked entity in a wrong OU and i want to delete that.Can someone tell me how to delete this entity? or move this entity to another OU.
You usual support is always appreciated.
Stanley
Hi Stanley,
It is only version 2.25 that has UI support for deleting Tracked Entity Instance. For the other versions, one has to do it manually using sql statements.
···
On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati skalyati@gmail.com wrote:
Colleagues,
My colleague entered a tracked entity in a wrong OU and i want to delete that.Can someone tell me how to delete this entity? or move this entity to another OU.
You usual support is always appreciated.
Stanley
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
–
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
Hi Stanley,
If the data has been entered from the Android client, and is still not sent to the server, you can delete with long pressing on the tracked entity instance and then press ‘delete’. If the icon next to the tracked entity instance is a orange disk, this means it is still unsent. If it is marked with a green tick then it is sent to the server, and at the moment we cannot delete it. It is on the roadmap to implement this feature
Regards,
Erling
···
On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati skalyati@gmail.com wrote:
Colleagues,
My colleague entered a tracked entity in a wrong OU and i want to delete that.Can someone tell me how to delete this entity? or move this entity to another OU.
You usual support is always appreciated.
Stanley
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
Abyot,
Could you help with the sql statements?
Thanks in advance.
Stanley
···
On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw abyot@dhis2.org wrote:
Hi Stanley,
It is only version 2.25 that has UI support for deleting Tracked Entity Instance. For the other versions, one has to do it manually using sql statements.
–
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati skalyati@gmail.com wrote:
Colleagues,
My colleague entered a tracked entity in a wrong OU and i want to delete that.Can someone tell me how to delete this entity? or move this entity to another OU.
You usual support is always appreciated.
Stanley
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
Erling,
It was on a desktop and the data is already in the database.
Should i just deactivate the entity?
Thanks
···
On Thu, Nov 3, 2016 at 11:23 AM, Erling Fjelstad erling@dhis2.org wrote:
Hi Stanley,
If the data has been entered from the Android client, and is still not sent to the server, you can delete with long pressing on the tracked entity instance and then press ‘delete’. If the icon next to the tracked entity instance is a orange disk, this means it is still unsent. If it is marked with a green tick then it is sent to the server, and at the moment we cannot delete it. It is on the roadmap to implement this feature
Regards,
Erling
On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati skalyati@gmail.com wrote:
Colleagues,
My colleague entered a tracked entity in a wrong OU and i want to delete that.Can someone tell me how to delete this entity? or move this entity to another OU.
You usual support is always appreciated.
Stanley
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
I don’t have ready made statements at hand.
But here is what you need to do - FOR THE TRACKED ENTITY INSTANCE in question
- Delete event values from trackedentitydatavalue
- Delete events from programstageinstance
- Delete enrollments from programinstance
- Delete attribute values from trackedentityattributevalue
- Delete the instance from trackedentityinstance
More on the associations:
trackedentityinstance uid → trackedentityinstance id → programinstance id → programstageinstance id
···
On Thu, Nov 3, 2016 at 10:27 AM, Stanley Kalyati skalyati@gmail.com wrote:
Abyot,
Could you help with the sql statements?
Thanks in advance.
Stanley
–
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw abyot@dhis2.org wrote:
Hi Stanley,
It is only version 2.25 that has UI support for deleting Tracked Entity Instance. For the other versions, one has to do it manually using sql statements.
–
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati skalyati@gmail.com wrote:
Colleagues,
My colleague entered a tracked entity in a wrong OU and i want to delete that.Can someone tell me how to delete this entity? or move this entity to another OU.
You usual support is always appreciated.
Stanley
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
has sql statement to delete?
···
On Thu, Nov 3, 2016 at 4:57 PM, Abyot Asalefew Gizaw abyot@dhis2.org wrote:
I don’t have ready made statements at hand.
But here is what you need to do - FOR THE TRACKED ENTITY INSTANCE in question
- Delete event values from trackedentitydatavalue
- Delete events from programstageinstance
- Delete enrollments from programinstance
- Delete attribute values from trackedentityattributevalue
- Delete the instance from trackedentityinstance
More on the associations:
trackedentityinstance uid → trackedentityinstance id → programinstance id → programstageinstance id
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
–
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
On Thu, Nov 3, 2016 at 10:27 AM, Stanley Kalyati skalyati@gmail.com wrote:
Abyot,
Could you help with the sql statements?
Thanks in advance.
Stanley
On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw abyot@dhis2.org wrote:
Hi Stanley,
It is only version 2.25 that has UI support for deleting Tracked Entity Instance. For the other versions, one has to do it manually using sql statements.
–
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati skalyati@gmail.com wrote:
Colleagues,
My colleague entered a tracked entity in a wrong OU and i want to delete that.Can someone tell me how to delete this entity? or move this entity to another OU.
You usual support is always appreciated.
Stanley
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
Hi Stanley,
To add on to what Abyot - if you are doing it via sql statements then the following tables might also have been populated:
trackedentityaudit
trackedentitydatavalueaudit
trackedentityattributevalueaudit
programstageinstance_messageconversation
programstageinstancecomments
and would need to be cleaned up otherwise you will hit foreign key constraints.
I would think it would be a lot easier to update the organisationunit id in the following tables:
Programstageinstance
Programinstance
Trackedentityinstance
and the sql statement would be something like:
update programstageinstance
set organisationunitid = nnnnnnnn (new orgunit’s internal id)
where organisationunitid = nnnnnnn (current orgunit’s internal id)
(this will move all the trackerdata from the current orgunit to the new orgunit)
and
exactly the same for programinstance and trackedentityinstance.
Afterwards you would have to clear cache and re-run analytics
Regards
Ant
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
···
On 3 November 2016 at 11:57, Abyot Asalefew Gizaw abyot@dhis2.org wrote:
I don’t have ready made statements at hand.
But here is what you need to do - FOR THE TRACKED ENTITY INSTANCE in question
- Delete event values from trackedentitydatavalue
- Delete events from programstageinstance
- Delete enrollments from programinstance
- Delete attribute values from trackedentityattributevalue
- Delete the instance from trackedentityinstance
More on the associations:
trackedentityinstance uid → trackedentityinstance id → programinstance id → programstageinstance id
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
–
–
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
On Thu, Nov 3, 2016 at 10:27 AM, Stanley Kalyati skalyati@gmail.com wrote:
Abyot,
Could you help with the sql statements?
Thanks in advance.
Stanley
On Thu, Nov 3, 2016 at 11:22 AM, Abyot Asalefew Gizaw abyot@dhis2.org wrote:
Hi Stanley,
It is only version 2.25 that has UI support for deleting Tracked Entity Instance. For the other versions, one has to do it manually using sql statements.
–
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
On Thu, Nov 3, 2016 at 10:16 AM, Stanley Kalyati skalyati@gmail.com wrote:
Colleagues,
My colleague entered a tracked entity in a wrong OU and i want to delete that.Can someone tell me how to delete this entity? or move this entity to another OU.
You usual support is always appreciated.
Stanley
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
Ant Snyman
Cell: 0824910449
Landline: 028 2713242
Health Information Systems Program - SA
1 Like
Do you mean 2.25 and above? And even in that case, where is the GUI button/icon that allows for deleting a tracked entity?
Thank you @jaime.bosque . It helped a lot. Also can you please say how to delete persons for whom only the enrollment was deleted. In such cases, It is not possible to get to the screenshot like you have posted above because such persons don’t appear in the Tracker Capture list.
If you search for that person, despite being deleted, it is not shown? I just did a test on the Play servers and I could get it…
1 Like
That was it. Thanks! Not immediately clear how to do it but now I know 
1 Like