dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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