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] [Dhis2-users] Not able to assign organisation units to an event program (v2.29)
Dear Isaiah, Can you check on your user orgunit assignment, Its probably deselected Regards Prosper Behumbiize, MPH DHIS2 Implementation Adviser| HISP Uganda pros...@hispuganda.org | pros...@dhis2.org | Skype: prospertb On Mon, Jun 18, 2018 at 1:07 PM, Isaiah Nyabuto wrote: > Hi Community, > > I am creating an event program in dhis2 2.29. > > There is no option to select and assign the organisation units. Its only > says *determining your root organisation units*. > > I realise that no organisation unit was successfully fetched. > > > Any helps on this will be appreciated. > > Thanks! > > -- > Isaiah Nyabuto > email: isaiahnyab...@gmail.com > Tel: +254 729 572 616 > > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > 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
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
Re: [Dhis2-devs] [Dhis2-users] Authorities for dragging and droping Dashboard Items
Hi Eric, That issue was fixed for the newly rewritten Dashboard app from 2.29 and has not been back-ported to legacy Dashboard app yet. Could you create an issue on jira ? I will check if I could back-port it. Regards, On Thu, Jun 14, 2018 at 5:42 PM, Eric Barreda Prades wrote: > Dear Viet, > > I have seen that the issue has also been fixed in v.29. Thanks a lot. Is > there any intention to fix it in v.28 ? > > Best, > > Eric > > 2018-05-24 2:50 GMT+02:00 GROUT, Lise : > >> Dear all, >> >> >> We have already reported similar. Actually in our case, if the people has >> only "See Dashboard" but does not have the other visualization Apps, they >> see the dashboards with ghost widget (no chart, table or maps). We have to >> give them access to all the other Apps, which was not our primary >> intention, and we don't see the rationale behind this neither. >> >> >> Best >> Lise >> -- >> *From:* Dhis2-users > o@lists.launchpad.net> on behalf of Morten Olav Hansen < >> mor...@dhis2.org> >> *Sent:* Thursday, May 24, 2018 2:03:23 AM >> *To:* Eric Barreda Prades; Viet Nguyen >> *Cc:* DHIS Users; DHIS 2 Developers list >> *Subject:* Re: [Dhis2-users] [Dhis2-devs] Authorities for dragging and >> droping Dashboard Items >> >> Hi Eric >> >> This is a bug we are aware of, and it has been fixed in master (what will >> be 2.30). I'm not sure if it has been backported yet. >> >> Viet? >> >> -- >> Morten Olav Hansen >> Senior Engineer, DHIS 2 >> University of Oslo >> http://www.dhis2.org >> >> On Wed, May 23, 2018 at 10:41 PM, Eric Barreda Prades < >> ericbarre...@gmail.com> wrote: >> >>> Dear developers, >>> >>> I have observed in our system that some users weren't able to >>> Drag/Arrange/redistribute dashboardItems from a Dashboard. After testing it >>> in DHIS2 Demo (at least tested for version 28) I have observed that users >>> must have the following authorities: >>> >>> See Data Visualizer app >>> See Event Reports app >>> See Dashboard Classic >>> See Event Visualizer app >>> See Pivot Table app >>> >>> Basically, they must have ALL related analysis app authorities. Is there >>> any rationality behind restricting it to that level? I mean, we have to >>> allow users seeing apps they might not use (for example program related >>> analytic apps) for dragging objects that might not be related to that >>> applications (Aggregated Tables). Am I missing something? Is this a bug? >>> >>> >>> >>> >>> >>> Best, >>> >>> Eric >>> >>> >>> ___ >>> 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 >>> >>> >> > -- Viet Nguyen Software Developer, DHIS 2 University of Oslo http://www.dhis2.org ___ 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
[Dhis2-devs] Bulk Data |Set completeness
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