We want to quickly (in groups) delete events related to a specific program and/or to a specific org unit (or list of org units). In DHIS2, we only managed to go one by one in the event capture app.
Can anyone recommend us any other convenient and faster way to do this, or if you are aware of an app that may help us?
We have also checked if it is possible to do it through the database, but we did not find easy to locate the table where the event data are stored and it is safe to delete them without loosing references to other objects.
Thank you!
Best,
Petar
···
--
_________________________________________________________________
Petar Jovanovic
Department of Service and Information System Engineering (ESSI)
Universitat Politècnica de Catalunya, BarcelonaTech
Barcelona, Spain
_____________ http://www.essi.upc.edu/~petar/ ___________________
The easier way is to use the api/events endpoint and query for events uids you want to delete. Once you have them, you can send http delete method via curl or nodejs or python or php,etc and loop through each to delete them via api/events/uid.
Alex
···
On Wednesday, January 24, 2018, Petar Jovanovic petar@essi.upc.edu wrote:
Hi,
We want to quickly (in groups) delete events related to a specific program and/or to a specific org unit (or list of org units). In DHIS2, we only managed to go one by one in the event capture app.
Can anyone recommend us any other convenient and faster way to do this, or if you are aware of an app that may help us?
We have also checked if it is possible to do it through the database, but we did not find easy to locate the table where the event data are stored and it is safe to delete them without loosing references to other objects.
Thank you!
Best,
Petar
–
Petar Jovanovic
Department of Service and Information System Engineering (ESSI)
Universitat Politècnica de Catalunya, BarcelonaTech
On Wed, Jan 24, 2018 at 9:32 PM +0100, “Alex Tumwesigye” atumwesigye@gmail.com wrote:
Hi,
The easier way is to use the api/events endpoint and query for events uids you want to delete. Once you have them, you can send http delete method via curl or nodejs or python or php,etc and loop through each to delete them via api/events/uid.
Alex
On Wednesday, January 24, 2018, Petar Jovanovic petar@essi.upc.edu wrote:
Hi,
We want to quickly (in groups) delete events related to a specific program and/or to a specific org unit (or list of org units). In DHIS2, we only managed to go one by one in the event capture app.
Can anyone recommend us any other convenient and faster way to do this, or if you are aware of an app that may help us?
We have also checked if it is possible to do it through the database, but we did not find easy to locate the table where the event data are stored and it is safe to delete them without loosing references to other objects.
Thank you!
Best,
Petar
–
Petar Jovanovic
Department of Service and Information System Engineering (ESSI)
Universitat Politècnica de Catalunya, BarcelonaTech
On Wed, Jan 24, 2018 at 9:32 PM +0100, “Alex Tumwesigye” atumwesigye@gmail.com wrote:
Hi,
The easier way is to use the api/events endpoint and query for events uids you want to delete. Once you have them, you can send http delete method via curl or nodejs or python or php,etc and loop through each to delete them via api/events/uid.
Alex
On Wednesday, January 24, 2018, Petar Jovanovic petar@essi.upc.edu wrote:
Hi,
We want to quickly (in groups) delete events related to a specific program and/or to a specific org unit (or list of org units). In DHIS2, we only managed to go one by one in the event capture app.
Can anyone recommend us any other convenient and faster way to do this, or if you are aware of an app that may help us?
We have also checked if it is possible to do it through the database, but we did not find easy to locate the table where the event data are stored and it is safe to delete them without loosing references to other objects.
Thank you!
Best,
Petar
–
Petar Jovanovic
Department of Service and Information System Engineering (ESSI)
Universitat Politècnica de Catalunya, BarcelonaTech
You might be able to adapt this script to your needs. This script will actually delete the orgunit, but I think the relevant part you need is here and here.
It sounds like in your case you want to delete the data, but not the orgunit itself.
You could then wrap this function in a loop, to remove the data in bulk, going one org unit at a time.
On Wed, Jan 24, 2018 at 9:32 PM +0100, “Alex Tumwesigye” atumwesigye@gmail.com wrote:
Hi,
The easier way is to use the api/events endpoint and query for events uids you want to delete. Once you have them, you can send http delete method via curl or nodejs or python or php,etc and loop through each to delete them via api/events/uid.
Alex
On Wednesday, January 24, 2018, Petar Jovanovic petar@essi.upc.edu wrote:
Hi,
We want to quickly (in groups) delete events related to a specific program and/or to a specific org unit (or list of org units). In DHIS2, we only managed to go one by one in the event capture app.
Can anyone recommend us any other convenient and faster way to do this, or if you are aware of an app that may help us?
We have also checked if it is possible to do it through the database, but we did not find easy to locate the table where the event data are stored and it is safe to delete them without loosing references to other objects.
Thank you!
Best,
Petar
–
Petar Jovanovic
Department of Service and Information System Engineering (ESSI)
Universitat Politècnica de Catalunya, BarcelonaTech