Reset DataSet completeness to zero - DHIS2 2.25

Support - Assistance technique
1

Dear DHIS2 community,

I would like to ask if there is a way to reset report completeness to 0 (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API? We know the Orgunit uid, period and DataSet uid to reset.

Thank you already for your suggestions!

Regards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

2

If you have access to the backend database, you can just do something like

DELETE FROM completedatasetregistration WHERE … (put your conditions here);

using one of these paramaters

datasetid | integer | not null

periodid | integer | not null

sourceid | integer | not null

attributeoptioncomboid | integer | not null

Otherwise, use the API for this as described here:

https://docs.dhis2.org/master/en/developer/html/webapi_complete_data_set_registrations.html#webapi_uncompleting_data_sets

Regards,

Jason

···

On Wed, Nov 22, 2017 at 8:49 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear DHIS2 community,

I would like to ask if there is a way to reset report completeness to 0 (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API? We know the Orgunit uid, period and DataSet uid to reset.

Thank you already for your suggestions!

Regards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

3

Hello Jason,

Thank you for your support!

Regards,

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

···

On Wed, Nov 22, 2017 at 11:39 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

If you have access to the backend database, you can just do something like

DELETE FROM completedatasetregistration WHERE … (put your conditions here);

using one of these paramaters

datasetid | integer | not null

periodid | integer | not null

sourceid | integer | not null

attributeoptioncomboid | integer | not null

Otherwise, use the API for this as described here:

https://docs.dhis2.org/master/en/developer/html/webapi_complete_data_set_registrations.html#webapi_uncompleting_data_sets

Regards,

Jason

Tantely

On Wed, Nov 22, 2017 at 8:49 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear DHIS2 community,

I would like to ask if there is a way to reset report completeness to 0 (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API? We know the Orgunit uid, period and DataSet uid to reset.

Thank you already for your suggestions!

Regards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

–