Data format for StatPlanet

Yes, you could do that, but it seems better to me to just add the static fields directly, as a variant of the current Report table CSV export.


On Thu, Jan 14, 2010 at 3:27 PM, Ola Hodne Titlestad wrote:

Agree Jason.
You can create a Jasper or BIRT report with static fields needed by StatPlan and dynamic fields from that report table and make the report available in DHIS with CSV export.


2010/1/14 Jason Pickering

Looks pretty close indeed and a good start for sure. I was thinking

that BIRT might be better to take get all of those other fields and

text in there. not sure if this is needed or not however.

On Thu, Jan 14, 2010 at 4:13 PM, Ola Hodne Titlestad wrote:


Attached a report table (filtered using display properties and then exported

to csv) that could be a starting point. You probably need to add a few

columns manually to match the StatPlanet format, but the core data is there.

You can see the report table definition here:


2010/1/14 Ola Hodne Titlestad

Report table with crosstab on orgunit should do most of this.

Ola Hodne Titlestad |Technical Officer|

Health Metrics Network (HMN) | World Health Organization

Avenue Appia 20 |1211 Geneva 27, Switzerland | Email:|Tel: +41 788216897


Better Information. Better Decisions. Better Health.

2010/1/14 Knut Staring

Hi guys,

Would love some ideas on whether and how we could generate this kind of

file from DHIS2: Report tables? DXF export + XSLT?

What should be the approach?


Knut Staring