dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Hi,

I agree wholeheartedly with Lars that DE names of 150 or 200 or 230
characters are to be avoided whenever possible - my personal preference has
always been to try to keep them well under 100 characters. BUT Crizelle
obviously also have a point - it's not good practice to specify one length
in the db and another in the UI.

My advice would be to look closely at the option of reducing those >160 to
<=160 though - if you set up the "old" and the "new" in a small match file,
it should be reasonably easy to update both DHIS2 and DHIS 1.4 instances?

Regards
calle

On 6 March 2015 at 18:57, Crizelle Nel <crizellenel@xxxxxxxxx> wrote:

> Hi Lars,
>
> The aim of my email was to increase the UI constraint to fit that of the
> db :0)
>
> While I understand the reasoning behind shortening the DE name field,
> reducing the db constraint now will have a major impact on existing
> instances.
>
> We currently have 117 out of 917 DE in the Core Standards system (which
> has been in Production for just over 2 years now) exceeding 160
> characters.This is a stable system that is a replica of a DHIS1.4 system
> (which is also still in use). We are also in the process of setting up a
> new CS db with a whole new set of DE (a few thousand) and the DE name
> length constraint provided to the NDoH was 230. I'm not sure if any of our
> other DHIS2 dbs have DE names that exceed 160 char as well. Elmarie/Calle?
> Reducing the number of DE name characters might affect interoperability
> with DHIS1.4 (which will be around for at least another year or two) and
> has a db DE name constraint of 230.
>
> P.S there is also a misfit between DE Group and DE Group Set name lengths
>
> --
>
> Regards,
> Crizelle Nel
>
> [image: HISP_Logo_sm]
> Software Development and Information Systems
>
>
> *Health Information Systems Program (HISP) -
> SA------------------------------------------------------------------------------*
> Email:       crizelle@xxxxxxxx <crizellenel@xxxxxxxxx>
> Cell:          +27 84 580 3342
> Fax:          0866 509 502
> Skype:      crizelle_nel
> Website:   http://www.hisp.org
>
> 66 Rigel Avenue North, Waterkloof Ridge
> Pretoria, 0181, South Africa
> E -25.7847787 S 28.2347984
>
> On Fri, Mar 6, 2015 at 5:05 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>
> wrote:
>
>> Hi Crizelle,
>>
>> good point. It's actually supposed to be 160, I have corrected that now.
>> The misfit between db constraint and ui constraint is unfortunate but its
>> the UI one that's most reasonable.
>>
>> The reason why we constrain it is that these kind of very long names
>> really makes the UI unusable - its impossible to read in most analysis
>> modules and you often cannot see the end of the text in the maintenance UI.
>>
>> 160 character is a pretty long name when you think of it. I would say its
>> not good practice to have such long names - better to find a way to reduce
>> the length of the name...
>>
>> regards,
>>
>> Lars
>>
>>
>> On Fri, Mar 6, 2015 at 12:03 PM, Crizelle Nel <crizellenel@xxxxxxxxx>
>> wrote:
>>
>>> Hi all,
>>>
>>> The dataelement table allows for DE names to be up to 230 characters.
>>> But when adding a DE name through the UI there is a limitation of 150
>>> characters.
>>>
>>> Can someone perhaps explain why this is?
>>>
>>> We have a project (Core Standards) where the DE names are in most cases
>>> > 150 char. The DE names were imported into the DHIS2 using csv without
>>> problems. In fact, everything (custom data entry forms, custom reports,
>>> pivot table) works fine and displays the full name. But when editing the
>>> name through the UI the changes cannot be saved if the name exceeds 150
>>> char.
>>>
>>> ---
>>>
>>> Regards,
>>> Crizelle Nel
>>>
>>> [image: HISP_Logo_sm]
>>> Software Development and Information Systems
>>>
>>>
>>> *Health Information Systems Program (HISP) -
>>> SA------------------------------------------------------------------------------*
>>> Email:       crizelle@xxxxxxxx <crizellenel@xxxxxxxxx>
>>> Cell:          +27 84 580 3342
>>> Fax:          0866 509 502
>>> Skype:      crizelle_nel
>>> Website:   http://www.hisp.org
>>>
>>> 66 Rigel Avenue North, Waterkloof Ridge
>>> Pretoria, 0181, South Africa
>>> E -25.7847787 S 28.2347984
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>
> _______________________________________________
> 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
>
>


-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************