← Back to team overview

dhis2-devs team mailing list archive

Re: Data format for StatPlanet

 

The BIRT/Jasper job would be a one off thing where you define the full
format, fill in static values, and define where to put values from the
dynamic report table.

Then what you would need to do as a user would be to use the report table
edit window to select indicators, periods and orgunits and then generate it,
followed by an export of the report to csv.

1 report and 1 report table would be needed, as they can be reused. The user
can edit the selection of indicators, periods, and orgunits.

Sounds doable and not to complicated.

Ola
---------

2010/1/14 Knut Staring <knutst@xxxxxxxxx>

> Moving discussion to the list.
>
> It would be preferably to not have to go via BIRT. What is needed is an
> easy GUI for defining what data you want to export to StatPlanet, and then
> the CSV would be downloaded - though even better, StatPlanet could be
> included in the DHIS2 distribution and pop up as an extra window in the
> browser, populated from the generated CSV file.
>
> Knut
>
>
> On Thu, Jan 14, 2010 at 3:21 PM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> 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 <olatitle@xxxxxxxxx>
>> wrote:
>> > Hi,
>> >
>> > 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:
>> >
>> http://dhis.uio.no/demo/dhis-web-reporting/displayAddTableForm.action?id=586542&mode=indicators&dimension=false
>> >
>> > Ola
>> >
>> > 2010/1/14 Ola Hodne Titlestad <olatitle@xxxxxxxxx>
>> >>
>> >> 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:
>> >> titlestado@xxxxxxx|Tel: +41 788216897
>> >> Website: www.healthmetricsnetwork.org
>> >>
>> >> Better Information. Better Decisions. Better Health.
>> >>
>> >>
>> >> 2010/1/14 Knut Staring <knutst@xxxxxxxxx>
>> >>>
>> >>> 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
>> >
>> >
>>
>
>
>
> --
> Cheers,
> Knut Staring
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References