dmaritim
(Daniel Kiprono Maritim)
8 May 2020 09:56
1
Dear Community,
I have DHIS2 implementation that has some programs and events in it, which we want to clean in order to begin a fresh, the develop of events and tracker programs. The existing programs were done poorly and cleaning it will take time.
DHIS2 instance is version 2.32
Your help will be highly appreciated.
Karoline
(Karoline Tufte Lien)
28 May 2020 12:22
2
Dear @dmaritim ,
I found a potential script that can be used to delete these programs here:
Hi there!
I have a starting pont for you. The script has not been used in a while, and it is only tested with my one program - so expect that there is a relation or two that needs to be added before everything works. Obviously you need to change the script to delete your program, and not the program named ‘Some program’ as it is currently:
delete from program_attributes where programtrackedentityattributeid in(select pa.programtrackedentityattributeid from program p join program_attributes pa …
Also tagging @Markus to see if he has any further input.
Best regards,
Karoline
1 Like
Karoline
(Karoline Tufte Lien)
22 June 2020 15:10
3
Dear @dmaritim ,
Did you have a chance to try the script?
Best regards,
Karoline