Hello All,
Is there a way of completing submitted data sets in bulk? For example I have over 20,000 data set reports submitted but not completed. The data values are saved but the data set is not completed (the complete button is still active). Trying to submit the data by going to the entry page to click the complete button will be a herculian task.
The Developer’s manual indicates that datasets can be completed by interacting with this end point: /api/26/completeDataSetRegistrations. This means I have to get the period, dataset and organisation unit for all the reports. I have several datasets and so many organisation units.
Is there a way I can manipulate the end-point to complete the data for all the pending datasets?
Your advice will be highly appreciated.
Regards
···
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba
I suppose you could check all the (orgunit,period) combinations in the datavalue table and also which datasets are assigned to which orgunits from the datasetsource table:
select distinct sourceid,periodid from datavalue;
select * from datasetsource;
Then insert what is missing into the completedatasetregistration table…
···
On Mon, Jun 18, 2018, 8:39 AM Barnabas Akumba akumbabarns@gmail.com wrote:
Hello All,
Is there a way of completing submitted data sets in bulk? For example I have over 20,000 data set reports submitted but not completed. The data values are saved but the data set is not completed (the complete button is still active). Trying to submit the data by going to the entry page to click the complete button will be a herculian task.
The Developer’s manual indicates that datasets can be completed by interacting with this end point: /api/26/completeDataSetRegistrations. This means I have to get the period, dataset and organisation unit for all the reports. I have several datasets and so many organisation units.
Is there a way I can manipulate the end-point to complete the data for all the pending datasets?
Your advice will be highly appreciated.
Regards
–
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba
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
Hello Knut,
This sounds good.
Will try it out and revert.
Regards
···
On Mon, Jun 18, 2018 at 9:56 AM, Knut Staring knutst@gmail.com wrote:
I suppose you could check all the (orgunit,period) combinations in the datavalue table and also which datasets are assigned to which orgunits from the datasetsource table:
select distinct sourceid,periodid from datavalue;
select * from datasetsource;
Then insert what is missing into the completedatasetregistration table…
On Mon, Jun 18, 2018, 8:39 AM Barnabas Akumba akumbabarns@gmail.com wrote:
Hello All,
Is there a way of completing submitted data sets in bulk? For example I have over 20,000 data set reports submitted but not completed. The data values are saved but the data set is not completed (the complete button is still active). Trying to submit the data by going to the entry page to click the complete button will be a herculian task.
The Developer’s manual indicates that datasets can be completed by interacting with this end point: /api/26/completeDataSetRegistrations. This means I have to get the period, dataset and organisation unit for all the reports. I have several datasets and so many organisation units.
Is there a way I can manipulate the end-point to complete the data for all the pending datasets?
Your advice will be highly appreciated.
Regards
–
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba
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
–
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba
As usual with direct DB manipulation, please take backups for each step along the way so you can easily roll back.
···
On Mon, Jun 18, 2018 at 9:56 AM, Knut Staring knutst@gmail.com wrote:
I suppose you could check all the (orgunit,period) combinations in the datavalue table and also which datasets are assigned to which orgunits from the datasetsource table:
select distinct sourceid,periodid from datavalue;
select * from datasetsource;
Then insert what is missing into the completedatasetregistration table…
On Mon, Jun 18, 2018, 8:39 AM Barnabas Akumba akumbabarns@gmail.com wrote:
Hello All,
Is there a way of completing submitted data sets in bulk? For example I have over 20,000 data set reports submitted but not completed. The data values are saved but the data set is not completed (the complete button is still active). Trying to submit the data by going to the entry page to click the complete button will be a herculian task.
The Developer’s manual indicates that datasets can be completed by interacting with this end point: /api/26/completeDataSetRegistrations. This means I have to get the period, dataset and organisation unit for all the reports. I have several datasets and so many organisation units.
Is there a way I can manipulate the end-point to complete the data for all the pending datasets?
Your advice will be highly appreciated.
Regards
–
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba
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
–
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba
Thanks for the advice.
Well noted.
···
On Tue, Jun 19, 2018 at 5:07 AM, Knut Staring knutst@gmail.com wrote:
As usual with direct DB manipulation, please take backups for each step along the way so you can easily roll back.
On Tue, Jun 19, 2018, 4:21 AM Barnabas Akumba akumbabarns@gmail.com wrote:
Hello Knut,
This sounds good.
Will try it out and revert.
Regards
–
On Mon, Jun 18, 2018 at 9:56 AM, Knut Staring knutst@gmail.com wrote:
I suppose you could check all the (orgunit,period) combinations in the datavalue table and also which datasets are assigned to which orgunits from the datasetsource table:
select distinct sourceid,periodid from datavalue;
select * from datasetsource;
Then insert what is missing into the completedatasetregistration table…
On Mon, Jun 18, 2018, 8:39 AM Barnabas Akumba akumbabarns@gmail.com wrote:
Hello All,
Is there a way of completing submitted data sets in bulk? For example I have over 20,000 data set reports submitted but not completed. The data values are saved but the data set is not completed (the complete button is still active). Trying to submit the data by going to the entry page to click the complete button will be a herculian task.
The Developer’s manual indicates that datasets can be completed by interacting with this end point: /api/26/completeDataSetRegistrations. This means I have to get the period, dataset and organisation unit for all the reports. I have several datasets and so many organisation units.
Is there a way I can manipulate the end-point to complete the data for all the pending datasets?
Your advice will be highly appreciated.
Regards
–
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba
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
–
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba
Barnabas AKUMBA
Mobile: +2348036195778
Skype: barnabas.akumba