← Back to team overview

dhis2-users team mailing list archive

Re: Dealing with multiple age categorisations in a single form

 

Hi Dylan,
Just as a follow up to this, the proposed workarounds which I mention here
will not work, I think.

You must use categories such as "0-1" and "0-1 yr" and "0-1 yrs" in order to
create separate category options in different categories. The reason for
this is, each category option must have a unique name when it is collapsed
to XML/SQL. "0-1" and "0-1 " (with a space) will get collapsed to "0-1" and
cause the import to crash.

The other hack which I mention (forcibly reusing categories by direct
manipulation of the database)  will also fail according to Lars, so it is
best not even to try messing with it.

It seems this will be looked at by the development team at some point in
time and the blueprint has been developed here

https://blueprints.launchpad.net/dhis2/+spec/extend-category-and-groupsets-model-with-concepts

Regards,
Jason


On Thu, Aug 11, 2011 at 8:19 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> Hi Dylan,
> I have had a closer look at this, and there is some traffic on the
> developer list about this now which may be of interest to you.
>
> My conclusion is DHIS2 actually supports the type of disaggregation which
> you (and others including myself) desire, namely the ability to have a
> single category option in multiple categories. We are still waiting to hear
> back with some reaction from the developers on this, most of whom are on
> holiday I think. The problem is the workaround is not supported through the
> UI, and a bit tricky to get to work with direct manipulation of the
> database.
>
> I would suggest you follow the workaround I mention in the mail "0-1", "0-1
> ", etc to deal with this for now, until we find/implement a more complete
> solution.
>
> Best regards,
> Jason
>
>
> On Wed, Aug 10, 2011 at 11:06 PM, Dylan Tovey <dylan@xxxxxxxxxxxxxxxx>wrote:
>
>>  Thanks Jason. I eventually worked my way through the whole thread
>> (although something to revisit on a weekend I think when my head is
>> clearer!)****
>>
>> ** **
>>
>> Thanks for the suggestions – will trial a few and see which is least
>> painful.****
>>
>> ** **
>>
>> Cheers****
>>
>> ** **
>>
>> Dylan ****
>>
>> *From:* Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx]
>> *Sent:* Wednesday, 10 August 2011 2:56 PM
>> *To:* Dylan Tovey
>> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx
>> *Subject:* Re: [Dhis2-users] Dealing with multiple age categorisations in
>> a single form****
>>
>> ** **
>>
>> Hi Dylan,****
>>
>> ** **
>>
>> You may want to check out the infamous "Zooks" thread for a much longer
>> discussion on some of the issues here
>> http://dhis-developers-list.1563109.n2.nabble.com/On-categories-and-dimensions-and-zooks-td3657695.html
>> ****
>>
>> ** **
>>
>> If I understand DHIS2 correctly, it is not possible to create multiple age
>> categories options and assign then partially to different category
>> combinations, at least in a way that makes them easy to analyze. ****
>>
>> ** **
>>
>> In your case you might have categories "Age1", "Age2", "Age 3"...****
>>
>> ** **
>>
>> You then may want to aggregate or analyze "Age1"/0-1 and "Age3"/0-1
>> together, since they are effectively the same age group. It is not possible
>> currently in DHIS2 to do this, as category options cannot be shared between
>> categories. It would seem to me to make sense to have a category called
>> "Age" with all possible category options (all of your age groups) and then
>> assign specific category options to a category group (each of your cells in
>> the table) and then assign this category group to a specific data element.
>> This does not seem to currently be possible, if my understanding is correct.
>> ****
>>
>> ** **
>>
>> Having said that, if you do not want to have an age group "0-1" and "0-1 "
>> (note the space) it is possible to have two category options which may
>> appear to the end user as the same, but which appear to be different to
>> DHIS2. This is of course, a very hacky approach. The restriction of not
>> being able to re-use categories options across categories is still a bit
>> mystifying to me, as the use case seems pretty clear. ****
>>
>> ** **
>>
>> Another possibility, with other potential issues, is to create a single
>> age category, which would contain all possible age category options, and
>> then implement custom data entry forms to only allow entry into the relevant
>> age groups, depending on the data element. Also, relatively clunky. ****
>>
>> ** **
>>
>> Another option, is the use of plain-ole-data-elements with no categories,
>> which as you say is a bit clunky, but would of course work in this case.
>> ****
>>
>> ** **
>>
>> Hopefully Lars, Bob or Ola or others could offer better insight (and a
>> solution).****
>>
>> ** **
>>
>> Regards,****
>>
>> Jason****
>>
>> ** **
>>
>> ** **
>>
>> On Wed, Aug 10, 2011 at 6:24 AM, Dylan Tovey <dylan@xxxxxxxxxxxxxxxx>
>> wrote:****
>>
>> Dear all,****
>>
>>  ****
>>
>> We have slowly been moving our internal reporting over to DHIS2. ****
>>
>>  ****
>>
>> We are also looking at some of the external government-mandated forms –
>> and wondered if somebody could provide some advice.****
>>
>>  ****
>>
>> We have an existing National Health Information System form that we would
>> like to transfer as is to electronic format. ****
>>
>>  ****
>>
>> On a single form they have eight different ways of breaking up age related
>> data (for different data elements) ****
>>
>>  ****
>>
>>  ****
>>
>> 0-1****
>>
>> 1-4****
>>
>> 5+****
>>
>>  ****
>>
>> 0-4****
>>
>> 5-14****
>>
>> 15+****
>>
>> 0-1****
>>
>> 1-4****
>>
>> 0-4****
>>
>> 5-16****
>>
>> 17+****
>>
>> Under 5 ****
>>
>> 0-4****
>>
>> 5-9****
>>
>> 10-14****
>>
>> 15-19****
>>
>> 20-24****
>>
>> 25-29****
>>
>> 30-49****
>>
>> 50+****
>>
>>  ****
>>
>>  ****
>>
>>  ****
>>
>>  ****
>>
>> Just wondering if anybody had any suggestions about an elegant way to
>> integrate such a cross-section into DHIS?****
>>
>>  ****
>>
>> I’ve looked at creating separate age-related data elements – or at six
>> different data element categories – but both seem reasonably clunky.****
>>
>>  ****
>>
>> Any thoughts?****
>>
>>  ****
>>
>> Cheers****
>>
>> Dylan ****
>>
>>
>> _______________________________________________
>> 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****
>>
>> ** **
>>   ------------------------------
>>
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 10.0.1388 / Virus Database: 1513/3717 - Release Date: 06/21/11
>> Internal Virus Database is out of date.****
>>
>
>

References