dhis2-users team mailing list archive

[Edwin Mulwa <eddiemu@xxxxxxxxx>]

Hi Bob,

Thanks for your response. I see that my thinking is in line with what you
described. I see this working with customized reports built into OpenMRS.
Ideally, in our implementation, the ETL will be executed from a central
database that has data synced from several facilities as opposed to running
it separately from different facilities.

Edwin



On Tue, Feb 11, 2014 at 2:36 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:

> Hi Edwin
>
> This module (for better or for worse) doesn't make use of the openmrs
> reporting framework.  It works on the basis of reading the metadata for the
> dhis2 report (the dataelements) and mapping each of those to a SQL query.
>  This make it highly suitable for (i) very customised openmrs deployments
> and (ii) when you have many reported dataelements which don't easily derive
> from cohort indicators.
>
> If you have an existing custom report you might want to take a different
> approach.  I guess there are a couple.  Not sure exactly what "custom
> report" means but if it can be rendered as an xml then I think I would look
> at creating a custom xslt to perform the required mapping and
> transformation to produce a dxf2 dataset and then either push through api
> or transport and import "manually".
>
> Either approach is feasible.  Are you looking from the position of a
> single facility, or looking at something which needs to work across many
> facilities?  Where the openmrs metadata is not well coordinated between
> facilities, it can be really difficult to do the mapping over and over.
>
> Bob
>
>
> On 28 January 2014 04:54, Edwin Mulwa <eddiemu@xxxxxxxxx> wrote:
>
>> Thanks Awanthika,
>>
>> Any idea how this module works? I ideally would like a tool that has the
>> flexibility to allow a user to choose a custom report from OpenMRS, be able
>> to select some or all fields from the report and map it to data elements
>> from DHIS and then transfer the selected report data to DHIS.
>>
>> Edwin
>>
>>
>>
>> On Tue, Jan 28, 2014 at 7:11 AM, awanth sen <wnthksnrth@xxxxxxxxx> wrote:
>>
>>> Hi Edwin,
>>>
>>> I dont know about a tool to automate. but there is a dhis connector
>>> module in hisp india which enables data transfer through a report generation
>>>
>>> regards
>>> awanthika
>>>
>>>
>>> On Mon, Jan 27, 2014 at 11:57 AM, Edwin Mulwa <eddiemu@xxxxxxxxx> wrote:
>>>
>>>> Hi All,
>>>>
>>>> Is there a tool/module that automates data transfer from OpenMRS to
>>>> DHIS2? I need such a tool for some work that I am doing.
>>>>
>>>> Thanks.
>>>>
>>>> Edwin
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> *------------------------------------------------------------------------------------------->>*
>>> *AWANTHIKA SENARATH*
>>> *Undergraduate*
>>> *Department of Electronics and Telecommunication Engineering*
>>> *University of Moratuwa*
>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>>
>