dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #03928
Re: Data format for StatPlanet
Sounds like an integration job here. Is this really a requirement?
On Thu, Jan 14, 2010 at 4:37 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
> Fine, I guess we are thinking that everyone will have the report engine.
> However, the next question is what happens to the generated file. The way I
> see it, the most user friendly use case would be for the user to not see the
> CSV file at all, but be presented directly with the data in the StatPlanet
> GUI.
> On Thu, Jan 14, 2010 at 3:32 PM, Ola Hodne Titlestad <olatitle@xxxxxxxxx>
> wrote:
>>
>> 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
>>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help : https://help.launchpad.net/ListHelp
>>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Cheers,
> Knut Staring
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
Follow ups
References