← Back to team overview

dhis2-devs team mailing list archive

Re: Bulk Data |Set completeness


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> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp

Follow ups