I am trying approach 2 below because I don't have access to the system generating the export file. Which tables should I mess around with?
Regards, Moses On Wednesday, 18 November 2015, Lars Helge Øverland <larshe...@gmail.com> wrote: > Some approaches: > > 1. Set the code property on all category option combos on both sides to be > the same. Then import the data using the import option / > property: categoryOptionComboIdScheme=CODE > > https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s12.html#d5e1541 > > 2. Manually set the category option combo uid on either side to match the > other. Remember that this might have huge effects on things like indicator > expressions, validation rule expressions, custom forms, etc. > > Lars > > > On Wed, Nov 18, 2015 at 9:56 AM, Moses Marimo <mar...@ict.co.zw > <javascript:_e(%7B%7D,'cvml','mar...@ict.co.zw');>> wrote: > >> Sorry, The import file is coming from a 2.19 system into a 2.20 system. >> Previous, it was an import file coming from a 2.14 system to a 2.14 system. >> >> The import file from a 2.14 system did not explicitly include the >> attributeOptionCombo. >> Now that the 2.19 export file is coming with the attributeOptionCombo, >> my challenge is, how do I "synchronise" both sides. Trying Meta data import >> did not help (exporting meta data from 2.19 system and importing into 2.20 >> system). >> >> Yes, the import file comes with a UID on the attributeOptionCombo, but >> that UID maps to a different attributeOptionComboID column value in the >> Datavalue table as compared to the previous 2.14 imports. >> >> On Wed, Nov 18, 2015 at 10:42 AM, Lars Helge Øverland < >> larshe...@gmail.com <javascript:_e(%7B%7D,'cvml','larshe...@gmail.com');> >> > wrote: >> >>> Hi Moses, >>> >>> >>> >>> On Mon, Nov 16, 2015 at 10:00 AM, Moses Marimo <mar...@ict.co.zw >>> <javascript:_e(%7B%7D,'cvml','mar...@ict.co.zw');>> wrote: >>> >>>> I have a system that I migrated from from DHIS2.14 to 2.20. In the >>>> 2.14, there was no attributeOptionCombo in the export file. The Datavalue >>>> table was populated with a default value of 15 in the >>>> attributeOptionComboID column. >>>> >>>> After migrating the system, the export file from a 2.20 system now >>>> comes with the attributeOptionCombo value.nc >>>> >>> >>> Sorry this part is a bit unclear. Is it coming from yet another 2.20 >>> system? >>> >>> In general we do not match on database identifiers (15 etc) but on UIDs. >>> If you would like to exchange data seamlessly between systems you should >>> ensure that the UIDs (or the codes) of category option combos (and data >>> elements, org units) are equal (synchronized) on both sides. >>> >>> regards, >>> >>> Lars >>> >>> -- >>> Lars Helge Øverland >>> Lead developer, DHIS 2 >>> University of Oslo >>> Skype: larshelgeoverland >>> http://www.dhis2.org <https://www.dhis2.org> >>> >>> >> >> >> -- >> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation" >> 7 Chelmsford Belgravia, Harare >> Tel: +263-8644-102349 >> Cell: +263-772-268353 >> Website: *www.ict.co.zw <http://www.ict.co.zw>* >> >> >> Innovative solutions in Web Design and E-Commerce, Software Engineering, >> Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT >> Solutions and Consultancy. >> > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > http://www.dhis2.org <https://www.dhis2.org> > > -- ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation" 7 Chelmsford Belgravia, Harare Tel: +263-8644-102349 Cell: +263-772-268353 Website: *www.ict.co.zw <http://www.ict.co.zw>* Innovative solutions in Web Design and E-Commerce, Software Engineering, Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT Solutions and Consultancy.
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
