dhis2-users team mailing list archive

[Stephen Gbanyan <mambu9@xxxxxxxxx>]

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 <jason.p.pickering@xxxxxxxxx> 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 <mambu9@xxxxxxxxx> 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     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>