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 <akumbaba...@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 >
_______________________________________________ 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
