dhis2-devs team mailing list archive
Mailing list archive
Re: Bulk Data |Set completeness
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@xxxxxxxxx> wrote:
> Hello Knut,
> This sounds good.
> Will try it out and revert.
> On Mon, Jun 18, 2018 at 9:56 AM, Knut Staring <knutst@xxxxxxxxx> 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@xxxxxxxxx>
>>> 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.
>>> Barnabas AKUMBA
>>> *Mobile:* +2348036195778
>>> *Skype:* barnabas.akumba
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help : https://help.launchpad.net/ListHelp
> Barnabas AKUMBA
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba