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
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
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
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
–
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
–
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
–
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
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
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
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
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
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
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
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
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
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
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
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
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
–
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
–
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
–
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
–