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