OpenMRS to DHIS2

Support - Assistance technique
1

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

1 Like
2

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@gmail.com 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@lists.launchpad.net

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

3

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@gmail.com 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@gmail.com 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@lists.launchpad.net

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

–

4

Hi Edwin,
Which data are you going to transfer? I think you can make a automatic script to use DHIS2 webapi. It’s strong!

You can also reference the module as awanthika said.

···

2014-01-28 awanth sen wnthksnrth@gmail.com

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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–
Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134

On Mon, Jan 27, 2014 at 11:57 AM, Edwin Mulwa eddiemu@gmail.com 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@lists.launchpad.net

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

–

5

Hi Thai,

I would like to transfer different types of data from time to time based on user’s needs, without having to always write a custom script every time a user’s report needs changes. So, in the ideal scenario, the user would create the reporting structure in DHIS based on an existing report in OpenMRS and then using this tool, would map fields from the OpenMRS report to the reporting data elements in DHIS and then execute a data transfer. Should there be a need to add/remove fields in the future, the user should be able to use this tool to just add or remove the necessary mapping for the data transfer.

Edwin

···

On Tue, Jan 28, 2014 at 7:57 AM, Thái Chương thaichuong159@gmail.com wrote:

Hi Edwin,
Which data are you going to transfer? I think you can make a automatic script to use DHIS2 webapi. It’s strong!

You can also reference the module as awanthika said.

2014-01-28 awanth sen wnthksnrth@gmail.com

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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134

–

On Mon, Jan 27, 2014 at 11:57 AM, Edwin Mulwa eddiemu@gmail.com 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@lists.launchpad.net

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

–

6

Hi Edwin,

Follow the document attached here which describes how to transfer data from openmrs to dhis2 using the DHIS2 reporting module. This is an example from Community Health Information Tracking System (CHITS). Christine ceblano is an expert on this topics as she has done this for Philippine.

DHIS2ModuleonCHITS-OpenMRS.docx (1 MB)

···

On Mon, Jan 27, 2014 at 12:27 PM, Edwin Mulwa eddiemu@gmail.com 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-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Mohammad Ullah

Technical Advisor - HIS
Priority Area - Health

Deutsche Gesellschaft fĂĽr Internationale Zusammenarbeit (GIZ) GmbH
House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

**
Office location:**
Room # 304, Shahid Dr. Milan Bhavan,

Management Information System (MIS)
Directorate General of Health Services of MoHFW, Mohakhali,
Dhaka-1212, Bangladesh
T. +880 (0) 8816459, 8816412 Ext:118

M. +88 0196 3156 988
Web. http://lnkd.in/gQrxXz

E mohammad.ullah@giz.de , munnabcis@gmail.com
Skype : mohammad_ullah_giz

7

Currently I don’t think that we have a tool for mapping between openMRS report and DHIS2 report.
But the module which awanth and Mohammad Ullah said can collect data from openMRS (by sql queries) and transfer to a dataset in DHIS2. And It’s not automatic.

It should give you some ideas

···

2014-01-28 Mohammad Ullah munnabcis@gmail.com

Hi Edwin,

Follow the document attached here which describes how to transfer data from openmrs to dhis2 using the DHIS2 reporting module. This is an example from Community Health Information Tracking System (CHITS). Christine ceblano is an expert on this topics as she has done this for Philippine.

–
Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134

On Mon, Jan 27, 2014 at 12:27 PM, Edwin Mulwa eddiemu@gmail.com 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-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Mohammad Ullah

Technical Advisor - HIS
Priority Area - Health

Deutsche Gesellschaft fĂĽr Internationale Zusammenarbeit (GIZ) GmbH
House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

**
Office location:**
Room # 304, Shahid Dr. Milan Bhavan,

Management Information System (MIS)
Directorate General of Health Services of MoHFW, Mohakhali,
Dhaka-1212, Bangladesh
T. +880 (0) 8816459, 8816412 Ext:118

M. +88 0196 3156 988
Web. http://lnkd.in/gQrxXz

E mohammad.ullah@giz.de , munnabcis@gmail.com
Skype : mohammad_ullah_giz

8

Hi,

This module may also be of interest.

Regards,

Pascal

···

On 28 January 2014 08:33, Thái Chương thaichuong159@gmail.com wrote:

Currently I don’t think that we have a tool for mapping between openMRS report and DHIS2 report.
But the module which awanth and Mohammad Ullah said can collect data from openMRS (by sql queries) and transfer to a dataset in DHIS2. And It’s not automatic.

It should give you some ideas

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–
*Pascal Brandt
Senio**r Software Developer, Jembi Health Systems | SOUTH AFRICA

Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt
E-mail: pascal@jembi.org*

2014-01-28 Mohammad Ullah munnabcis@gmail.com

Hi Edwin,

Follow the document attached here which describes how to transfer data from openmrs to dhis2 using the DHIS2 reporting module. This is an example from Community Health Information Tracking System (CHITS). Christine ceblano is an expert on this topics as she has done this for Philippine.

–
Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134

On Mon, Jan 27, 2014 at 12:27 PM, Edwin Mulwa eddiemu@gmail.com 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-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Mohammad Ullah

Technical Advisor - HIS
Priority Area - Health

Deutsche Gesellschaft fĂĽr Internationale Zusammenarbeit (GIZ) GmbH
House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

**
Office location:**
Room # 304, Shahid Dr. Milan Bhavan,

Management Information System (MIS)
Directorate General of Health Services of MoHFW, Mohakhali,
Dhaka-1212, Bangladesh
T. +880 (0) 8816459, 8816412 Ext:118

M. +88 0196 3156 988
Web. http://lnkd.in/gQrxXz

E mohammad.ullah@giz.de , munnabcis@gmail.com
Skype : mohammad_ullah_giz

9

Thanks Mohammad,

I will take a look and let you know if it was helpful.

Eddie

···

On Tue, Jan 28, 2014 at 8:15 AM, Mohammad Ullah munnabcis@gmail.com wrote:

Hi Edwin,

Follow the document attached here which describes how to transfer data from openmrs to dhis2 using the DHIS2 reporting module. This is an example from Community Health Information Tracking System (CHITS). Christine ceblano is an expert on this topics as she has done this for Philippine.

On Mon, Jan 27, 2014 at 12:27 PM, Edwin Mulwa eddiemu@gmail.com 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-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Mohammad Ullah

Technical Advisor - HIS
Priority Area - Health

Deutsche Gesellschaft fĂĽr Internationale Zusammenarbeit (GIZ) GmbH
House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

**
Office location:**
Room # 304, Shahid Dr. Milan Bhavan,

Management Information System (MIS)
Directorate General of Health Services of MoHFW, Mohakhali,
Dhaka-1212, Bangladesh
T. +880 (0) 8816459, 8816412 Ext:118

M. +88 0196 3156 988
Web. http://lnkd.in/gQrxXz

E mohammad.ullah@giz.de , munnabcis@gmail.com
Skype : mohammad_ullah_giz

10

Thanks Christine,

I will certainly try this during the week and give you feedback on whether it worked for us.

Thanks!

Edwin

···

On Tue, Jan 28, 2014 at 6:50 PM, christine ceblano hakuna21@gmail.com wrote:

Hi Edwin,

Attached is the updated documentation of the steps (almost similar to the doc that Mohammad Ullah shared with you, although more organized I think). It uses the DHIS2 Reporting Module of Bob Jolliffe (+Saptarshi). It’s more of mysql query inside the xml that you’ll need to customize.

As Pascal mentioned, there is also an OpenMRS-DHIS2 Integration module made by Srimaurya that employs another approach (Cohort instead of mysql queries). You may also wish to check that out if doing the cohort is more suited in your case.

Just let us know how we can help. Thanks.

On Tue, Jan 28, 2014 at 8:38 PM, Edwin Mulwa eddiemu@gmail.com wrote:

Thanks Mohammad,

I will take a look and let you know if it was helpful.

Eddie

–
Christine A. CEBLANO

Research Associate

Health Infomatics

NATIONAL TELEHEALTH CENTER

University of the Philippines Manila

3rd Floor IT Complex, Philippine General Hospital

Taft Ave., Ermita, Manila, Philippines 1000

Email: admin@info.telehealth.ph

Telefax: +63 2 525 6501

Website: http://www.telehealth.ph

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law. If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

On Tue, Jan 28, 2014 at 8:15 AM, Mohammad Ullah munnabcis@gmail.com wrote:

Hi Edwin,

Follow the document attached here which describes how to transfer data from openmrs to dhis2 using the DHIS2 reporting module. This is an example from Community Health Information Tracking System (CHITS). Christine ceblano is an expert on this topics as she has done this for Philippine.

On Mon, Jan 27, 2014 at 12:27 PM, Edwin Mulwa eddiemu@gmail.com 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-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Mohammad Ullah

Technical Advisor - HIS
Priority Area - Health

Deutsche Gesellschaft fĂĽr Internationale Zusammenarbeit (GIZ) GmbH
House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

**
Office location:**
Room # 304, Shahid Dr. Milan Bhavan,

Management Information System (MIS)
Directorate General of Health Services of MoHFW, Mohakhali,
Dhaka-1212, Bangladesh
T. +880 (0) 8816459, 8816412 Ext:118

M. +88 0196 3156 988
Web. http://lnkd.in/gQrxXz

E mohammad.ullah@giz.de , munnabcis@gmail.com
Skype : mohammad_ullah_giz

11

Hi Christine,

I am starting to try this process. In the documentation, I see that its stated that I need an XML file containing the report definition . How do I generate this?

Edwin

···

On Wed, Jan 29, 2014 at 8:54 AM, Edwin Mulwa eddiemu@gmail.com wrote:

Thanks Christine,

I will certainly try this during the week and give you feedback on whether it worked for us.

Thanks!

Edwin

On Tue, Jan 28, 2014 at 6:50 PM, christine ceblano hakuna21@gmail.com wrote:

Hi Edwin,

Attached is the updated documentation of the steps (almost similar to the doc that Mohammad Ullah shared with you, although more organized I think). It uses the DHIS2 Reporting Module of Bob Jolliffe (+Saptarshi). It’s more of mysql query inside the xml that you’ll need to customize.

As Pascal mentioned, there is also an OpenMRS-DHIS2 Integration module made by Srimaurya that employs another approach (Cohort instead of mysql queries). You may also wish to check that out if doing the cohort is more suited in your case.

Just let us know how we can help. Thanks.

On Tue, Jan 28, 2014 at 8:38 PM, Edwin Mulwa eddiemu@gmail.com wrote:

Thanks Mohammad,

I will take a look and let you know if it was helpful.

Eddie

–
Christine A. CEBLANO

Research Associate

Health Infomatics

NATIONAL TELEHEALTH CENTER

University of the Philippines Manila

3rd Floor IT Complex, Philippine General Hospital

Taft Ave., Ermita, Manila, Philippines 1000

Email: admin@info.telehealth.ph

Telefax: +63 2 525 6501

Website: http://www.telehealth.ph

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law. If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

On Tue, Jan 28, 2014 at 8:15 AM, Mohammad Ullah munnabcis@gmail.com wrote:

Hi Edwin,

Follow the document attached here which describes how to transfer data from openmrs to dhis2 using the DHIS2 reporting module. This is an example from Community Health Information Tracking System (CHITS). Christine ceblano is an expert on this topics as she has done this for Philippine.

On Mon, Jan 27, 2014 at 12:27 PM, Edwin Mulwa eddiemu@gmail.com 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-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Mohammad Ullah

Technical Advisor - HIS
Priority Area - Health

Deutsche Gesellschaft fĂĽr Internationale Zusammenarbeit (GIZ) GmbH
House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

**
Office location:**
Room # 304, Shahid Dr. Milan Bhavan,

Management Information System (MIS)
Directorate General of Health Services of MoHFW, Mohakhali,
Dhaka-1212, Bangladesh
T. +880 (0) 8816459, 8816412 Ext:118

M. +88 0196 3156 988
Web. http://lnkd.in/gQrxXz

E mohammad.ullah@giz.de , munnabcis@gmail.com
Skype : mohammad_ullah_giz

12

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@gmail.com 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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Jan 28, 2014 at 7:11 AM, awanth sen wnthksnrth@gmail.com 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@gmail.com 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@lists.launchpad.net

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

–

13

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@gmail.com 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@gmail.com 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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Jan 28, 2014 at 7:11 AM, awanth sen wnthksnrth@gmail.com 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@gmail.com 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@lists.launchpad.net

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

–

14

Hi Edwin

···

On 11 February 2014 13:19, Edwin Mulwa eddiemu@gmail.com 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@gmail.com 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@gmail.com 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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Jan 28, 2014 at 7:11 AM, awanth sen wnthksnrth@gmail.com 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@gmail.com 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@lists.launchpad.net

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

–

15

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@gmail.com wrote:

Hi Edwin

On 11 February 2014 13:19, Edwin Mulwa eddiemu@gmail.com 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@gmail.com 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@gmail.com 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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Jan 28, 2014 at 7:11 AM, awanth sen wnthksnrth@gmail.com 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@gmail.com 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@lists.launchpad.net

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

–