Lars – Thank you for the prompt response last week. I determined that it was not possible to make these SQL changes while in Haiti, but I will work with my team in Boston to make these changes in the coming weeks. Thankfully we have no data stored in the wrong COC. We only need to remove it from the Default categoryCombo. I really appreciate your support!
Android Team -- The problem that I described is not affecting the DHIS2 Data Capture Android application. It is only affecting the HISP Tanzania DHIS Touch application. So congratulations to the Android team on their work. The DIHS2 Data Capture application is what I am using now in Haiti. Congratulations to Ignacio, Marta, Kjerstin, and the Android team. This application is working really well, and the only challenge for us now is that the error messaging needs to be more like a pop-up for our users to know whether data was successfully submitted or if there was a connection error. I will make this request in the next survey. All the best, Mike Mike Johnson, MSc | MEQ Manager Monitoring, Evaluation & Quality Improvement | Partners In Health Boston, MA USA Email: mjohn...@pih.org<mailto:mjohn...@pih.org> Mobile: +1 857-206-5246 From: Lars Helge Øverland [mailto:l...@dhis2.org] Sent: Thursday, March 01, 2018 4:53 AM To: Mike Johnson <mjohn...@pih.org> Cc: dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] Need to modify or regenerate the default categoryOptionCombo Hi Mike, this was an unfortunate bug which existed in the API at some point which caused some trouble in various databases. Cleaning it up is a bit involved if you have data for both default option combos and want to merge it. We have an SQL script here with various commands which is helpful: https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/fix-duplicate-default-category-option-combos.sql<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fdhis2%2Fdhis2-utils%2Fblob%2Fmaster%2Fresources%2Fsql%2Ffix-duplicate-default-category-option-combos.sql&data=02%7C01%7Cmjohnson%40pih.org%7C493cbc14fc3343b9b22d08d57f5a3f93%7C5254789f6860437585bc302509fad508%7C1%7C1%7C636554947986170052&sdata=1KK3yVQDhnTHQt0Jfvywqq5hTo0EL23md21%2B91%2F6SKo%3D&reserved=0> regards, Lars On 1 March 2018 at 04:47, Mike Johnson <mjohn...@pih.org<mailto:mjohn...@pih.org>> wrote: I have an instance on 2.27, but it was originally built in 2.24 and upgraded to 2.25 and 2.26. I need to regenerate my default categoryCombo. Somehow I have two categoryOptionCombos associated with the default categoryCombo (default, and “Cured”, which is an unrelated disaggregation from another categoryCombo). The only way I noticed this was that I was using the HISP Touch app, and I was seeing two input fields for each data element with default category combo. I have regenerated category option combos in the data administration app, I have cleared the app cache, changed public access to “rw------“, restarted the server, and pulled a few other things, but nothing seems to work. Is there any other way to manually remove this extraneous category option combo from the “default” category combo? Below is the metadata, if anyone is curious to take a look. Thank you! Mike Mike Johnson, MSc | MEQ Manager Monitoring, Evaluation & Quality Improvement | Partners In Health Email: mjohn...@pih.org<mailto:mjohn...@pih.org> Mobile: +1 857-206-5246<tel:+1%20857-206-5246> Submit an MEQ data request<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpartnersinhealth.sharepoint.com%2Fsites%2Fmeq%2FLists%2FMEQ%2520Request%2520Form%2FNewForm2.aspx&data=02%7C01%7Cmjohnson%40pih.org%7C493cbc14fc3343b9b22d08d57f5a3f93%7C5254789f6860437585bc302509fad508%7C1%7C1%7C636554947986170052&sdata=Gv%2FoWaHAxacmxG0fs%2Fc9VpDSmzrCnDIsRDpjgYeyByg%3D&reserved=0> <categoryCombo xmlns="http://dhis2.org/schema/dxf/2.0<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdhis2.org%2Fschema%2Fdxf%2F2.0&data=02%7C01%7Cmjohnson%40pih.org%7C493cbc14fc3343b9b22d08d57f5a3f93%7C5254789f6860437585bc302509fad508%7C1%7C1%7C636554947986170052&sdata=tLsbJo3NZB7VudAIpHB4GrUsdfYYH91vRzoyGbibNNk%3D&reserved=0>" created="2015-11-04T12:56:52.922" lastUpdated="2018-02-28T22:11:57.151" name="default" href="https://_______/dhis/api/categoryCombos/gWY___"; id="gWY___"> <dataDimensionType>DISAGGREGATION</dataDimensionType> <displayName>default</displayName> <publicAccess>rw------</publicAccess> <externalAccess>false</externalAccess> <isDefault>true</isDefault> <skipTotal>false</skipTotal> <lastUpdatedBy id="Hq3___"/> <access> <read>true</read> <update>true</update> <externalize>true</externalize> <delete>true</delete> <write>true</write> <manage>true</manage> </access> <user id="Hq3Uq69cGEq"/> <categoryOptionCombos> <categoryOptionCombo id="q3kk___"/> ## This is default <categoryOptionCombo id="UnxN___"/> ## This is “Cured”, which I want to remove </categoryOptionCombos> <categories> <category id="QNCD___"/> # This is default </categories> </categoryCombo> _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs<https://na01.safelinks.protection.outlook.com/?url=https:%2F%2Flaunchpad.net%2F~dhis2-devs&data=02%7C01%7Cmjohnson%40pih.org%7C493cbc14fc3343b9b22d08d57f5a3f93%7C5254789f6860437585bc302509fad508%7C1%7C1%7C636554947986170052&sdata=XRAfr6MwEtitWM%2BMnhB7coZtxLwylFqa%2Fzp8TbJeSN0%3D&reserved=0> Post to : dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs<https://na01.safelinks.protection.outlook.com/?url=https:%2F%2Flaunchpad.net%2F~dhis2-devs&data=02%7C01%7Cmjohnson%40pih.org%7C493cbc14fc3343b9b22d08d57f5a3f93%7C5254789f6860437585bc302509fad508%7C1%7C1%7C636554947986170052&sdata=XRAfr6MwEtitWM%2BMnhB7coZtxLwylFqa%2Fzp8TbJeSN0%3D&reserved=0> More help : https://help.launchpad.net/ListHelp<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fhelp.launchpad.net%2FListHelp&data=02%7C01%7Cmjohnson%40pih.org%7C493cbc14fc3343b9b22d08d57f5a3f93%7C5254789f6860437585bc302509fad508%7C1%7C1%7C636554947986170052&sdata=8SVrfGNsHd02qK0NDZW0n4d651i2eHBPJ73Zt4h7Q%2FY%3D&reserved=0> -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland l...@dhis2.org<mailto:l...@dhis2.org> http://www.dhis2.org<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dhis2.org%2F&data=02%7C01%7Cmjohnson%40pih.org%7C493cbc14fc3343b9b22d08d57f5a3f93%7C5254789f6860437585bc302509fad508%7C1%7C1%7C636554947986170052&sdata=MmcadQaOMdqfQWicwXgGflIFl2I1vwHUeOC%2FW%2BVr8Ys%3D&reserved=0>
_______________________________________________ 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
