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 email@example.com wrote:
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 firstname.lastname@example.org
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 email@example.com 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 firstname.lastname@example.org
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:
email@example.com|Tel: +41 788216897
Better Information. Better Decisions. Better Health.
2010/1/14 Knut Staring firstname.lastname@example.org
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?