Re: [Dhis2-users] API: Mass-deleting data values

Wed, 02 Dec 2015 09:03:18 -0800

That's cheating :-D


What do you think of the option of just updating all the obsolete values to 0 and have them eliminated by DHIS2 (I assume that 0-Values are being eliminated unless I block this in the settings)?


Uwe

Lars Helge Øverland <[email protected]> hat am 2. Dezember 2015 um 17:49 geschrieben:

Hi Uwe,

you are right in that we do not support bulk deletion through the Web API. The main reason is that we want to avert disaster by someone doing it by mistake or through malicious activity. However we are getting an increasing number of requests for this so we will consider it.

An effective alternative is to simply use a SQL statement to accomplish it. Is that an option for you?

regards,

Lars




On Wed, Dec 2, 2015 at 5:44 PM, Uwe Wahser <[email protected]> wrote:

Dear all,


currently I am looking at ways of deleting larger amounts of DataValues based on their dimensions OrgUnit, Period, DataElement AND AttributeOptionCombination. the main purpose is to invalidate old values on AttributeOptionCombinations, which no there are no more values in an updated source-system. So far I tried the following options:


1 - DELETE api dataValues?pe=xxx&ou=xxx&de=xxx&cc=xxx&cp=xxxx: works, but take s a loong time since every delete-record has open the api-connection once.


2 - POST api dataValueSets?importStrategy=DELETE: should be the most applilcable, if it works - does it? I only get ignored records in the result set. Does it make sense to investigate further into this option, or is this api not forseen for deleting?


3 - POST api dataValueSets?importStrategy=UPDATE with all values set to 0: have not yet tried this option, but would fall back on this, if I can't get (2) to work. I assume that the 0-value-records will be eliminated by DHIS2 lateron (when? during analytical table-update?)


Could someone please comment, if any of these options make sense, or if there is another, more elegant version?


Thanks a lot in advance!


Regards,


Uwe


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp




--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland


 

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Reply via email to