dhis2-devs team mailing list archive

[Barnabas Akumba <akumbabarns@xxxxxxxxx>]

Hello Knut,

This sounds good.
Will try it out and revert.

Regards

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>
> 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
>>
>


-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba