Hello Knut, This sounds good. Will try it out and revert.
Regards On Mon, Jun 18, 2018 at 9:56 AM, Knut Staring <knu...@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 <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 >> > -- 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
