Delete data values based on dataset -- DHIS2 2.25

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.

···

Hello everyone,

I need to delete data values based on some datasets and each corresponding completeness. I can delete all the data values by importing “null” data from csv format, but with this, the completeness do not change. My question is what is the simplest way to do the data values deletion and simultaneously make the change in the completeness information.

All your suggestions are welcome!

Best,

Tantely.

Hi Raminosoa.

You can do it using sql script if you have access to the database.

Kind regards

Djibril

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.

···

On 24 Jul 2017 16:33, “Raminosoa Rabemanantsoa, Tantely” traminosoa@mikolo.org wrote:

Hello everyone,

I need to delete data values based on some datasets and each corresponding completeness. I can delete all the data values by importing “null” data from csv format, but with this, the completeness do not change. My question is what is the simplest way to do the data values deletion and simultaneously make the change in the completeness information.

All your suggestions are welcome!

Best,

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-users

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

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

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

Dear Djibril,

Thank you for your response. Yes, I could access to the database. Could you please point a link to an appropriate SQL query in order to do this process?

Kind 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.

···

On Mon, Jul 24, 2017 at 5:50 PM, Djibril Dione djibril@hisp.org wrote:

Hi Raminosoa.

You can do it using sql script if you have access to the database.

Kind regards

Djibril

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.

On 24 Jul 2017 16:33, “Raminosoa Rabemanantsoa, Tantely” traminosoa@mikolo.org wrote:

Hello everyone,

I need to delete data values based on some datasets and each corresponding completeness. I can delete all the data values by importing “null” data from csv format, but with this, the completeness do not change. My question is what is the simplest way to do the data values deletion and simultaneously make the change in the completeness information.

All your suggestions are welcome!

Best,

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-users

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

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

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