We have a custom app which allows uploading of 2000+ events (without registration) from Excel file and the frequency is monthly. Say we have uploaded events for Jan 2021 and later need to upload again with updated data. I found that bulk delete of TEI and events using strategy=DELETE has been discontinued (it was there possibly till 2.29). Now the option is to delete one by one. As we need to del…

Hi @Mahmud , there is another option you can use in the meanwhile for versions >= 2.30. This endpoint accepts a SYNC strategy that allows to create, delete and update events in a single query (/api/events?strategy=SYNC). You just have to set the property deleted to false in the event payload ({ deleted: true }).

@Mahmud To answer your question, it is not possible to send update SQL command directly to backend from web app. SQL commands can be executed directly on the database if you have access to it. For example, by using pgadmin or psql and connecting to the db directly. But bulk delete of TEI and events using importStrategy=DELETE should still be supported. Home - DHIS2 Documentation This is the doc…

It is in documentation, but believe me, we had passed sleepless nights to understand why it is not working. There is no ‘importStrategy’ but ‘strategy’ is a valid keyword. In the following screen you see I am passing 2 event ids - [Screenshot 2021-08-09 162142] The returned success message shows 2 events are deleted - "responseType": "ImportSummaries", "status": "SUCCESS", …

@Mahmud That is interesting and it looks like a bug. Please create a jira issue with all the necessary details and specific version numbers and we will definitely look into it and hopefully resolve it. In the meantime, directly accessing the db might be the only choice.

Hi @Ameen We are delivering a web app that allows uploading monthly events. Directly accessing the DB is out of scope. To the Ministry it will be treated as - the app not working as you upload 2 times and records will continue to grow. Anyway, will see what to do.

@Mahmud In that case, it would help us if you can create a jira issue with all the necessary details. We can try to prioritize it and resolve the issue for the next patch release. You can share the jira issue in this thread once its created.

@Mahmud When we do deletes in DHIS2 tracker, they are primarily soft-deletes. You can run a routine to hard delete them another place. Can you check the database records and see if the records have their “deleted” column set to “true”?

@Stian nothing happens after bulk delete, deleted flag is not set. We do not realy need hard delete from database. As long as soft delete happens and it is not displayed in the front end it would be fine. Which is not happening when multiple event IDs are sent in the API.

@Mahmud Please create a jira issue with the details and share it in this thread. We will prioritize and release it in a patch as early as possible.

@vgarciabnz http://.........../api/events?strategy=SYNC with parameter - { "events": [ { "event": "Aukfl3mu5bW", "deleted": true }, { "event": "IpG2ZIbkQwF", "deleted": true } ] } The same bug. If I give 1 event, it gets deleted immediately - but 2 does not.

Which version are you using? I have just tested it with 2 events in 2.36.3 and it is working fine, both events are soft-deleted.

DHIS2.org
Documentation
Developers
Demo
Apps
Academy

DHIS2 Community

BULK delete of events

Support - Assistance technique

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled