Re: [Dhis2-devs] Bulk Data |Set completeness
Thanks for the advice. Well noted. On Tue, Jun 19, 2018 at 5:07 AM, Knut Staring 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 > wrote: > >> Hello Knut, >> >> This sounds good. >> Will try it out and revert. >> >> Regards >> >> On Mon, Jun 18, 2018 at 9:56 AM, Knut Staring 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 >>> 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@lists.launchpad.net 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 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] 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 wrote: > Hello Knut, > > This sounds good. > Will try it out and revert. > > Regards > > On Mon, Jun 18, 2018 at 9:56 AM, Knut Staring 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 >> 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@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >> > > > -- > > Barnabas AKUMBA > > *Mobile:* +2348036195778 > *Skype:* barnabas.akumba > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Bulk Data |Set completeness
Hello Knut, This sounds good. Will try it out and revert. Regards On Mon, Jun 18, 2018 at 9:56 AM, Knut Staring 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 > 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@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > -- Barnabas AKUMBA *Mobile:* +2348036195778 *Skype:* barnabas.akumba ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] 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 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp