can't delete data element

Great, thanks Lars!

···

On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sure - will keep you posted - we will get it done in a few weeks time.

regards,

Lars

On Fri, Nov 18, 2016 at 7:01 PM, Lorill Crees lcrees@2paths.com wrote:

Thanks Lars. Yes - keeping it on a data element will work for us.

Could you please let me know when this is complete for us to try out? Or let me know the issue so I can track it?

Thanks for accommodating this functionality - much appreciated!


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:50 AM, Lars Helge Øverland lars@dhis2.org wrote:


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:43 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

That functionality would be what we need. Is this something that you could backport to 2.25?

Okay we can work on that. I have written an issue. Yes I think we can back-port to 2.25.

Also wondering if it would be possible to prune for a Data Set? That would reduce the amount of API calls as our end goal is to delete the Data Set itself.

I think we will keep it on data element - don’t want to take this too far. I guess you could chain API calls for this without too much hassle.

best regards,

Lars

Let me know. Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:16 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sorry Lorill, I misread your question.

No we haven’t changed the policy that data element can be deleted if data value audits exist.

We recently implemented a feature for pruning data (including approval records, data set completeness records, data value audits and data values) for organisation unit units.

/api/26/maintenance/dataPruning/organisationUnits/<org-unit-id>

We could implement something similar for data elements.

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:03 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Thanks for the quick reply. Does this mean if we soft delete all data values associated with a data element we will then be able to hard delete the data element?

Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 8:54 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

in 2.25 we introduced “soft data value” delete, meaning that in the database we simply mark data values as deleted using the “deleted” property (this is transparent to the users). This means that foreign key constraints from data value audit values should not be a problem anymore. Let us know if that solves it.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 5:48 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

We have a long standing request to allow users of our custom DHIS 2 app to delete specific Data Sets and all corresponding data elements and values. We need to do this via the API.

It seems the only thing preventing us from doing this now is the deletion of datavalueaudit records. Is there any plan to allow deletion of datavalueaudit records via the API? Or to remove dependencies from the datavalueaudit records so they can be standalone and not prevent the deletion of the corresponding data elements?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, Nov 17, 2016 at 11:37 PM, channara rin rin.channara@gmail.com wrote:


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

YES,

thank you for reminding…

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

Hi Lars,

Just following up on progress with this. Do you have an ETA on when this will be available in 2.25?

Thanks!

Lorill

···

On Fri, Nov 18, 2016 at 10:11 AM, Lorill Crees lcrees@2paths.com wrote:

Great, thanks Lars!

On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sure - will keep you posted - we will get it done in a few weeks time.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 7:01 PM, Lorill Crees lcrees@2paths.com wrote:

Thanks Lars. Yes - keeping it on a data element will work for us.

Could you please let me know when this is complete for us to try out? Or let me know the issue so I can track it?

Thanks for accommodating this functionality - much appreciated!


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:50 AM, Lars Helge Øverland lars@dhis2.org wrote:


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:43 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

That functionality would be what we need. Is this something that you could backport to 2.25?

Okay we can work on that. I have written an issue. Yes I think we can back-port to 2.25.

Also wondering if it would be possible to prune for a Data Set? That would reduce the amount of API calls as our end goal is to delete the Data Set itself.

I think we will keep it on data element - don’t want to take this too far. I guess you could chain API calls for this without too much hassle.

best regards,

Lars

Let me know. Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:16 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sorry Lorill, I misread your question.

No we haven’t changed the policy that data element can be deleted if data value audits exist.

We recently implemented a feature for pruning data (including approval records, data set completeness records, data value audits and data values) for organisation unit units.

/api/26/maintenance/dataPruning/organisationUnits/<org-unit-id>

We could implement something similar for data elements.

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:03 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Thanks for the quick reply. Does this mean if we soft delete all data values associated with a data element we will then be able to hard delete the data element?

Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 8:54 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

in 2.25 we introduced “soft data value” delete, meaning that in the database we simply mark data values as deleted using the “deleted” property (this is transparent to the users). This means that foreign key constraints from data value audit values should not be a problem anymore. Let us know if that solves it.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 5:48 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

We have a long standing request to allow users of our custom DHIS 2 app to delete specific Data Sets and all corresponding data elements and values. We need to do this via the API.

It seems the only thing preventing us from doing this now is the deletion of datavalueaudit records. Is there any plan to allow deletion of datavalueaudit records via the API? Or to remove dependencies from the datavalueaudit records so they can be standalone and not prevent the deletion of the corresponding data elements?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, Nov 17, 2016 at 11:37 PM, channara rin rin.channara@gmail.com wrote:


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

YES,

thank you for reminding…

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

Hi Lorill,

this is done in master. Issue here:

https://jira.dhis2.org/browse/DHIS2-209

Will see if it can be back-ported.

Lars

···

On Tue, Dec 13, 2016 at 4:58 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Just following up on progress with this. Do you have an ETA on when this will be available in 2.25?

Thanks!

Lorill

On Fri, Nov 18, 2016 at 10:11 AM, Lorill Crees lcrees@2paths.com wrote:

Great, thanks Lars!


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sure - will keep you posted - we will get it done in a few weeks time.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 7:01 PM, Lorill Crees lcrees@2paths.com wrote:

Thanks Lars. Yes - keeping it on a data element will work for us.

Could you please let me know when this is complete for us to try out? Or let me know the issue so I can track it?

Thanks for accommodating this functionality - much appreciated!


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:50 AM, Lars Helge Øverland lars@dhis2.org wrote:


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:43 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

That functionality would be what we need. Is this something that you could backport to 2.25?

Okay we can work on that. I have written an issue. Yes I think we can back-port to 2.25.

Also wondering if it would be possible to prune for a Data Set? That would reduce the amount of API calls as our end goal is to delete the Data Set itself.

I think we will keep it on data element - don’t want to take this too far. I guess you could chain API calls for this without too much hassle.

best regards,

Lars

Let me know. Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:16 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sorry Lorill, I misread your question.

No we haven’t changed the policy that data element can be deleted if data value audits exist.

We recently implemented a feature for pruning data (including approval records, data set completeness records, data value audits and data values) for organisation unit units.

/api/26/maintenance/dataPruning/organisationUnits/<org-unit-id>

We could implement something similar for data elements.

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:03 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Thanks for the quick reply. Does this mean if we soft delete all data values associated with a data element we will then be able to hard delete the data element?

Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 8:54 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

in 2.25 we introduced “soft data value” delete, meaning that in the database we simply mark data values as deleted using the “deleted” property (this is transparent to the users). This means that foreign key constraints from data value audit values should not be a problem anymore. Let us know if that solves it.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 5:48 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

We have a long standing request to allow users of our custom DHIS 2 app to delete specific Data Sets and all corresponding data elements and values. We need to do this via the API.

It seems the only thing preventing us from doing this now is the deletion of datavalueaudit records. Is there any plan to allow deletion of datavalueaudit records via the API? Or to remove dependencies from the datavalueaudit records so they can be standalone and not prevent the deletion of the corresponding data elements?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, Nov 17, 2016 at 11:37 PM, channara rin rin.channara@gmail.com wrote:


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

YES,

thank you for reminding…

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Thanks Lars.

···

On Tue, Dec 13, 2016 at 8:10 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

this is done in master. Issue here:

https://jira.dhis2.org/browse/DHIS2-209

Will see if it can be back-ported.

Lars

On Tue, Dec 13, 2016 at 4:58 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Just following up on progress with this. Do you have an ETA on when this will be available in 2.25?

Thanks!

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 10:11 AM, Lorill Crees lcrees@2paths.com wrote:

Great, thanks Lars!


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sure - will keep you posted - we will get it done in a few weeks time.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 7:01 PM, Lorill Crees lcrees@2paths.com wrote:

Thanks Lars. Yes - keeping it on a data element will work for us.

Could you please let me know when this is complete for us to try out? Or let me know the issue so I can track it?

Thanks for accommodating this functionality - much appreciated!


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:50 AM, Lars Helge Øverland lars@dhis2.org wrote:


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:43 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

That functionality would be what we need. Is this something that you could backport to 2.25?

Okay we can work on that. I have written an issue. Yes I think we can back-port to 2.25.

Also wondering if it would be possible to prune for a Data Set? That would reduce the amount of API calls as our end goal is to delete the Data Set itself.

I think we will keep it on data element - don’t want to take this too far. I guess you could chain API calls for this without too much hassle.

best regards,

Lars

Let me know. Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:16 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sorry Lorill, I misread your question.

No we haven’t changed the policy that data element can be deleted if data value audits exist.

We recently implemented a feature for pruning data (including approval records, data set completeness records, data value audits and data values) for organisation unit units.

/api/26/maintenance/dataPruning/organisationUnits/<org-unit-id>

We could implement something similar for data elements.

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:03 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Thanks for the quick reply. Does this mean if we soft delete all data values associated with a data element we will then be able to hard delete the data element?

Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 8:54 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

in 2.25 we introduced “soft data value” delete, meaning that in the database we simply mark data values as deleted using the “deleted” property (this is transparent to the users). This means that foreign key constraints from data value audit values should not be a problem anymore. Let us know if that solves it.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 5:48 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

We have a long standing request to allow users of our custom DHIS 2 app to delete specific Data Sets and all corresponding data elements and values. We need to do this via the API.

It seems the only thing preventing us from doing this now is the deletion of datavalueaudit records. Is there any plan to allow deletion of datavalueaudit records via the API? Or to remove dependencies from the datavalueaudit records so they can be standalone and not prevent the deletion of the corresponding data elements?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, Nov 17, 2016 at 11:37 PM, channara rin rin.channara@gmail.com wrote:


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

YES,

thank you for reminding…

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

This should be back-ported to 2.25 now.

https://jira.dhis2.org/browse/DHIS2-209

Lars

···

On Tue, Dec 13, 2016 at 5:15 PM, Lorill Crees lcrees@2paths.com wrote:

Thanks Lars.

On Tue, Dec 13, 2016 at 8:10 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

this is done in master. Issue here:

https://jira.dhis2.org/browse/DHIS2-209

Will see if it can be back-ported.

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Tue, Dec 13, 2016 at 4:58 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Just following up on progress with this. Do you have an ETA on when this will be available in 2.25?

Thanks!

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 10:11 AM, Lorill Crees lcrees@2paths.com wrote:

Great, thanks Lars!


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sure - will keep you posted - we will get it done in a few weeks time.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 7:01 PM, Lorill Crees lcrees@2paths.com wrote:

Thanks Lars. Yes - keeping it on a data element will work for us.

Could you please let me know when this is complete for us to try out? Or let me know the issue so I can track it?

Thanks for accommodating this functionality - much appreciated!


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:50 AM, Lars Helge Øverland lars@dhis2.org wrote:


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:43 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

That functionality would be what we need. Is this something that you could backport to 2.25?

Okay we can work on that. I have written an issue. Yes I think we can back-port to 2.25.

Also wondering if it would be possible to prune for a Data Set? That would reduce the amount of API calls as our end goal is to delete the Data Set itself.

I think we will keep it on data element - don’t want to take this too far. I guess you could chain API calls for this without too much hassle.

best regards,

Lars

Let me know. Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:16 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sorry Lorill, I misread your question.

No we haven’t changed the policy that data element can be deleted if data value audits exist.

We recently implemented a feature for pruning data (including approval records, data set completeness records, data value audits and data values) for organisation unit units.

/api/26/maintenance/dataPruning/organisationUnits/<org-unit-id>

We could implement something similar for data elements.

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:03 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Thanks for the quick reply. Does this mean if we soft delete all data values associated with a data element we will then be able to hard delete the data element?

Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 8:54 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

in 2.25 we introduced “soft data value” delete, meaning that in the database we simply mark data values as deleted using the “deleted” property (this is transparent to the users). This means that foreign key constraints from data value audit values should not be a problem anymore. Let us know if that solves it.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 5:48 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

We have a long standing request to allow users of our custom DHIS 2 app to delete specific Data Sets and all corresponding data elements and values. We need to do this via the API.

It seems the only thing preventing us from doing this now is the deletion of datavalueaudit records. Is there any plan to allow deletion of datavalueaudit records via the API? Or to remove dependencies from the datavalueaudit records so they can be standalone and not prevent the deletion of the corresponding data elements?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, Nov 17, 2016 at 11:37 PM, channara rin rin.channara@gmail.com wrote:


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

YES,

thank you for reminding…

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

1 Like

Excellent - thanks Lars!

···

On Thu, Dec 15, 2016 at 4:28 AM, Lars Helge Øverland lars@dhis2.org wrote:

This should be back-ported to 2.25 now.

https://jira.dhis2.org/browse/DHIS2-209

Lars

On Tue, Dec 13, 2016 at 5:15 PM, Lorill Crees lcrees@2paths.com wrote:

Thanks Lars.


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Tue, Dec 13, 2016 at 8:10 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

this is done in master. Issue here:

https://jira.dhis2.org/browse/DHIS2-209

Will see if it can be back-ported.

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Tue, Dec 13, 2016 at 4:58 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Just following up on progress with this. Do you have an ETA on when this will be available in 2.25?

Thanks!

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 10:11 AM, Lorill Crees lcrees@2paths.com wrote:

Great, thanks Lars!


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 10:03 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sure - will keep you posted - we will get it done in a few weeks time.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 7:01 PM, Lorill Crees lcrees@2paths.com wrote:

Thanks Lars. Yes - keeping it on a data element will work for us.

Could you please let me know when this is complete for us to try out? Or let me know the issue so I can track it?

Thanks for accommodating this functionality - much appreciated!


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:50 AM, Lars Helge Øverland lars@dhis2.org wrote:


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:43 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

That functionality would be what we need. Is this something that you could backport to 2.25?

Okay we can work on that. I have written an issue. Yes I think we can back-port to 2.25.

Also wondering if it would be possible to prune for a Data Set? That would reduce the amount of API calls as our end goal is to delete the Data Set itself.

I think we will keep it on data element - don’t want to take this too far. I guess you could chain API calls for this without too much hassle.

best regards,

Lars

Let me know. Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 9:16 AM, Lars Helge Øverland lars@dhis2.org wrote:

Sorry Lorill, I misread your question.

No we haven’t changed the policy that data element can be deleted if data value audits exist.

We recently implemented a feature for pruning data (including approval records, data set completeness records, data value audits and data values) for organisation unit units.

/api/26/maintenance/dataPruning/organisationUnits/<org-unit-id>

We could implement something similar for data elements.

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 6:03 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars,

Thanks for the quick reply. Does this mean if we soft delete all data values associated with a data element we will then be able to hard delete the data element?

Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Fri, Nov 18, 2016 at 8:54 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

in 2.25 we introduced “soft data value” delete, meaning that in the database we simply mark data values as deleted using the “deleted” property (this is transparent to the users). This means that foreign key constraints from data value audit values should not be a problem anymore. Let us know if that solves it.

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Fri, Nov 18, 2016 at 5:48 PM, Lorill Crees lcrees@2paths.com wrote:

Hi,

We have a long standing request to allow users of our custom DHIS 2 app to delete specific Data Sets and all corresponding data elements and values. We need to do this via the API.

It seems the only thing preventing us from doing this now is the deletion of datavalueaudit records. Is there any plan to allow deletion of datavalueaudit records via the API? Or to remove dependencies from the datavalueaudit records so they can be standalone and not prevent the deletion of the corresponding data elements?

Thanks,

Lorill


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, Nov 17, 2016 at 11:37 PM, channara rin rin.channara@gmail.com wrote:


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

YES,

thank you for reminding…

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15