Re: [Dhis2-devs] Deletion of Program and all associated objects via API v 2.25

2017-06-02 Thread Lorill Crees
Hi, Jason - thanks for heading me in the right direction for this. I'm now looping through and deleting all related maps, charts, reportTables, eventReports and eventCharts, and dashboard items. I know this sounds dangerous, but the programs that the users are deleting are all either test data or

Re: [Dhis2-devs] Deletion of Program and all associated objects via API v 2.25

2017-05-30 Thread Lorill Crees
Hi Jason, Thanks for the tips. We have already developed a custom data import app in Grails, and have now already incorporated virtually all of the deletion functionality for both Data Sets and Programs via the Web API. The availability of this functionality via the web app is pretty key to the us

Re: [Dhis2-devs] Deletion of Program and all associated objects via API v 2.25

2017-05-30 Thread Jason Pickering
Hi Lorill, I am not too sure off-hand exactly how to do that. I suppose maybe you could loop through all of the available report tables or craft an API query to determine which report tables and other artifacts need to be deleted. These should be available through a report tables endpoint like htt

Re: [Dhis2-devs] Deletion of Program and all associated objects via API v 2.25

2017-05-30 Thread Lorill Crees
Hi Jason, How can I programatically determine this via the Web API? Are DataDimensionItems related to favourites? If so, I had asked the dev list about the querying and deletion of favourites via the Web API back in February and had created these three JIRA tasks: https://jira.dhis2.org/browse/DH

Re: [Dhis2-devs] Deletion of Program and all associated objects via API v 2.25

2017-05-30 Thread Jason Pickering
Hi Lorill, Is the data element linked to a chart, pivot or map? Regards, Jason On Mon, May 29, 2017 at 9:58 PM, Lorill Crees wrote: > Hi, > > Further to this, for some of our programs we are unable to delete > programdataelements via the Web API due to the following error: > > ERROR: update o

Re: [Dhis2-devs] Deletion of Program and all associated objects via API v 2.25

2017-05-29 Thread Lorill Crees
Hi, Further to this, for some of our programs we are unable to delete programdataelements via the Web API due to the following error: ERROR: update or delete on table "programdataelement" violates foreign key constraint "fk_datadimensionitem_programdataelementid" on table "datadimensionitem" Deta

[Dhis2-devs] Deletion of Program and all associated objects via API v 2.25

2017-05-26 Thread Lorill Crees
Hi, We have been working on functionality to delete full Programs and all associated data and metadata via the Web API using: Version: 2.25 Build revision: ee7e61b Build date: 2017-05-19 12:47 The instance being used is assuming that attributes and data elements are specific to a particular prog