Category option combinations in data import/datasets

Support - Assistance technique
1

Hi all,

Is there a way to view names of category option combinations instead of UIDs of category option combination when I import data from data set using import/export App?

The example below is from child health dataset from DHIS 2 play

image
image1504×407 41 KB

Thanks

2

Hi @hernandezmachava

In general, you cannot rely on the name of the category option combo during import. Due to the way in which category combos are created it is totally possible that you will have two category option combinations with the same name but which belong to different category combinations, and have different UIDs. A good example might be age groups:

Coarse: <1, 1-15, 15+
Fine: <1. 1-5, 5-10, 10-15, etc.

In this case, the “<1” category option combination might have the same name, but it would have a different UID. This is why it is usually not a good idea to rely on the name for this dimension.

You can however change the export format to export the “code” of the category option combination.

image

This is under ID scheme. Note that the “Name” property is not there. Some implementations do create codes however for category option combos to make them more human readable, but they must also be unique (unlike the names) so it can get tricky and difficult to maintain.

Hope this helps to answer your question.

Best regards,
Jason

3

Hi @jason,

From your explanation, I now understand why the name property is not there when data import is concerned. One question: what is the difference between fine and coarse?

Thanks

4

hi @hernandezmachava ,
These were just some arbitrary category combos which I made up to illustrate the point. I just wanted to show that the “<1” category option combo could show up in more than one category combo (and thus, have a different UID).

Best regards,
Jason

5

Hi @jason,

Thanks for your support.

1 Like