Hi Jason, Thanks for the quick respond. To explain better let me say firstly two facilities was created with the same names and the only difference was one has a lower "C" in clinic and the other has a Capital "C". What we noticed was there were two persons entering data for each months and the same data was entered in October and November by difference person but in Jaurzon Clinic and Jaurzon clinic. Starting from November to present they were just alternating the facilities. One month data was entered in Juarzon Clinic and the other month in Juarzon clinic.
Now what needs to be done is to take those months that have data and move them to the appropriate facility and delete the other. Hope this explanation helps. Thanks Stephen On 4/24/12, Jason Pickering <[email protected]> wrote: > By duplicated, you mean something like > > Juarzon Clinic has a data element = 1 > Juarzon clinic has a data element = 1 > and the merged facility has a new value = 2? > > In principle, you should be able to run an SQL command like > > UPDATE datavalue set sourceid = <new organisationunitid> where > sourceid = <old organisationunitid> > > replacing the <new organisationunitid> with the desired facility to > merge to and replacing <old organisationunitid> with the facility you > want to get rid of. > > But this will not work if you have the same data elements entered for > the same month for both facilities. Then you will need to remove the > data elements which conflict for this time period. However, it would > be good if you could describe the problem with duplication in more > detail, as this sounds worrisome. > > Regards, > Jason > > > On Tue, Apr 24, 2012 at 12:25 PM, Stephen Gbanyan <[email protected]> wrote: >> Hi All, >> >> I have a situation and need some help. The are two facilities in my >> database with the same name but the difference is capital letter. One >> is spell Juarzon Clinic and the other is Juarzon clinic. Both of them >> have the same data in for September and October 2011. In November 2011 >> Juarzon clinic got data but Juarzon Clinic has nothing, in December >> Juarzon Clinic has data and Juarzon clinic has nothing and that goes >> on till March of this year. When I merged organization units I >> noticed the months of September and October figures got duplicated. I >> need a command to execute that I just move the months data to the >> appropriate facility and delete the other facility. >> >> Thanks >> >> Steephen >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
