dhis2-devs team mailing list archive

[Barnabas Akumba <akumbabarns@xxxxxxxxx>]

Thanks for the advice.
Well noted.

On Tue, Jun 19, 2018 at 5:07 AM, Knut Staring <knutst@xxxxxxxxx> wrote:

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


-- 

Barnabas AKUMBA

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