dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

They are duplicates in the sense that they have the same category options
and  the same combination of categories. For instance, there would be two
(Female, > 15 years) for the same category combination, but with different
UIDs.

What I have been able to determine though is that ones which seem to need
to be deleted do not show up in the resource table. I managed to get the
others out of
the categorycombos_optioncombos, categoryoptioncombos_categoryoptions,
and categoryoptioncombo tables, and it seems to work. The "duplicates" are
visible through the WebAPI, but their IDs are not present in the resource
tables. I suspect these category combos have been altered at some point in
time, but the categoryoptioncombos were never updated/deleted as they
should have been.

I think it will matter which one we keep, as what is important to be able
to sync with the master system is that we use the correct one.

Anyway, maybe that is a procedure? Delete anything from those tables which
is not present in the resource tables? Fishing a bit really, but there must
be some way to distinguish which ones of these are actually assigned to a
particular data element?

Regards,
Jason



On Wed, Oct 9, 2013 at 11:44 AM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

> Hi Jason,
>
> are they also duplicates in the sense that they have the same set of
> category options?
>
> If they are equal in terms of i) category combo and ii) set of category
> options and there are no data values, it does not matter which one you keep
> (just make sure you have no duplicates).
>
> cheers
>
> Lars
>
>
> On Wed, Oct 9, 2013 at 11:27 AM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> Hi Devs,
>> I am working on the transformation of a DHIS2 database from one metadata
>> base to another. One of the issues I have not really been able to figure
>> out is how to deal with apparent duplicated category option combos. The
>> database we are transforming to has for some reason, duplicated category
>> option combos.By duplicated I mean they have the same category combinations
>> , but different UIDs. I suspect one of these obviously is not real, but I
>> do not really have a good idea about how to discriminate between the "real"
>> one and the "bad" one.
>>
>> Any ideas?
>>
>> Best regards,
>> Jason
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>