dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

2010/8/26 Lars Helge Øverland <larshelge@xxxxxxxxx>

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

Supposed to be "shortnames".


>
> 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
>>
>
>