dhis2-devs team mailing list archive

[Edwin Mulwa <eddiemu@xxxxxxxxx>]

Bob,

We do have some custom reports and will create others as needed. We are
likely develop a tool that will allow us to map the fields from the custom
reports to the data elements in DHIS and generate the XML file needed to
push the data into DHIS. I will report on our progress moving forward.

Edwin



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

> Hi Edwin
>
> On 11 February 2014 13:19, Edwin Mulwa <eddiemu@xxxxxxxxx> wrote:
>
>> 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.
>>
>
> That does make the task simpler.  Do you have these custom reports already
> or are you still to make them?  Will they be coming through the reporting
> module or something more custom than that?
>
>>
>>
>> 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
>>>>
>>>>
>>>
>>
>