dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

OK I think we can remove the uniqueness constraint on orgunit names.

This is related to the discussion on meta-data object identifiers. If we
create a "dedicated" identifier property on meta-data objects and separate
it from the name we can remove uniqueness constraints on all attributes from
a system perspective. In the case of orgunits it makes sense because the
context can be retrieved from the hierarchy (parent). I am not sure if
removing uniqueness constraints on data elements, indicators, datasets etc
is sensible, wouldn't it eg. be confusing to select from a list where
multiple options has the same name?


Lars


On Wed, Aug 25, 2010 at 6:17 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> Not sure why they should be unique. There are lots of places with the
> same name (McDonalds, BP, etc) within a given administrative district.
> They have other unique properties of course such as ownership,
> address, telephone number, lat/long, etc, but this seems to be another
> one of those strange restrictions in the data model/business logic
> that keep hitting us in the face.
>
> I would argue these restrictions should be a data integrity rule, but
> should not be hard-coded into the system itself. If people want to
> have duplicate orgunits names, as you do Knut, there may be valid
> reasons for this. It seems like potentially bad practice within a
> given orgunit level, but this could only be a myopic view of things
> (see my McDonalds example above) Certainly mangling the names with
> arbitrary (supposedly) random numbers is no better.
>
> Regards,
> Jason
>
>
> On Wed, Aug 25, 2010 at 2:01 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
> > Hello,
> >
> > We really have to resolve the issue of unique orgunit names and
> > shortnames. I have 7000 orgunits, and it does not make sense to
> > pollute the name strings with random digits at the end or something
> > similar (another strategy is to use the parent name), just to make
> > them unique. I also don't know how to attach extra characters to just
> > the duplicates (i.e. not to the first one).
> >
> > --
> > Cheers,
> > Knut Staring
> >
> > _______________________________________________
> > 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
> >
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+17069260025
>
> _______________________________________________
> 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
>