Event Reports Question

Hi Community,
I am using dhis2 2.30. When i download data from event reports, the columns with options are downloaded as codes yet i would love to view the actual names, how do i go about this?

1 Like

Hi @herbert_kiwalya,
You can append the following to the download link

&outputIdScheme=NAME&dataIdScheme=NAME

For example, to download the event report linked here, click Download, HTML. The download URL is in the address bar:
https://play.dhis2.org/2.30/api/29/analytics/events/query/…ou;oZg33kd9taw;fWIAEtYVEGk.

Then append “&outputIdScheme=NAME&dataIdScheme=NAME” as follows:
https://play.dhis2.org/2.30/api/29/analytics/events/query/…ou;oZg33kd9taw;fWIAEtYVEGk&outputIdScheme=NAME&dataIdScheme=NAME

You may modify .html+css to .csv for a csv download.

Hope this helps. You can follow this JIRA ticket for more information on a fix
https://jira.dhis2.org/browse/DHIS2-4990

Regards,
Muhammad

4 Likes

Hi @medallion.,

I tried downloading in excel format as I need to work on the excel file but not able to work as you have mentioned.

Nirija

2 Likes

Hi @medallion,
I appreciate you taking the time to help. The dowload link to the .xls format for that report is:
https://play.dhis2.org/2.30/api/29/analytics/events/query/eBAyeGv0exc.xls?dimension=pe:LAST_4_QUARTERS&dimension=ou:jUb8gELQApl;TEQlaapDQoK;eIQbndfxQMb;Vth0fbpFcsO;PMa2VCrupOd;O6uvpzGd5pu;bL4ooGhyHRQ;kJq2mPyFEHo;fdc6uOvgoji;at6UHUQatSo;lc3eMKXaEfw;qhqAxPSTUXp;jmIPBj66vD6&dimension=oZg33kd9taw:IN:Female;Male&dimension=fWIAEtYVEGk&stage=Zj7UnCAulEk&displayProperty=NAME&tableLayout=true&columns=pe;ou;oZg33kd9taw;fWIAEtYVEGk&rows=pe;ou;oZg33kd9taw;fWIAEtYVEGk

I appended &outputIdScheme=NAME&dataIdScheme=NAME to it but the site can’t be reached is the error i get.
Did i miss something?

1 Like

Hi @herbert_kiwalya. Be sure that you have logged in to https://play.dhis2.org/2.30.
The link is pasted below:
https://play.dhis2.org/2.30/api/29/analytics/events/query/eBAyeGv0exc.xls?dimension=pe:LAST_4_QUARTERS&dimension=ou:jUb8gELQApl;TEQlaapDQoK;eIQbndfxQMb;Vth0fbpFcsO;PMa2VCrupOd;O6uvpzGd5pu;bL4ooGhyHRQ;kJq2mPyFEHo;fdc6uOvgoji;at6UHUQatSo;lc3eMKXaEfw;qhqAxPSTUXp;jmIPBj66vD6&dimension=oZg33kd9taw:IN:Female;Male&dimension=fWIAEtYVEGk&stage=Zj7UnCAulEk&displayProperty=NAME&tableLayout=true&columns=pe;ou;oZg33kd9taw;fWIAEtYVEGk&rows=pe;ou;oZg33kd9taw;fWIAEtYVEGk&outputIdScheme=NAME&dataIdScheme=NAME

1 Like

Hi @nirijastha
What error did you get?

1 Like

Not sure why it was not working, now it is :grinning: Thanks @medallion

2 Likes