[Dhis2-devs] Web API Not Allowing Bulk Data Values Transfer on Demo Site
!DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN htmlhead title301 Moved Permanently/title /headbody h1Moved Permanently/h1 pThe document has moved a href= https://apps.dhis2.org/demo/api/dataValueSets;here/a./p /body/html Hi, I was trying to use the DHIS Web API to transfer a bulk of data values to the demo site but it returned an error. This is the XML file I was trying to process: dataValueSet xmlns=http://dhis2.org/schema/dxf/2.0; dataValue dataElement=f7n9E0hX8qk period=201501 orgUnit=DiszpKrYNg8 value=12/ dataValue dataElement=f7n9E0hX8qk period=201501 orgUnit=FNnj3jKGS7i value=14/ dataValue dataElement=f7n9E0hX8qk period=201502 orgUnit=DiszpKrYNg8 value=16/ dataValue dataElement=f7n9E0hX8qk period=201502 orgUnit=FNnj3jKGS7i value=18/ /dataValueSet Below is the result I get (I have also attached a screenshot of what is fully returned): !DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN htmlhead title301 Moved Permanently/title /headbody h1Moved Permanently/h1 pThe document has moved a href= https://apps.dhis2.org/demo/api/dataValueSets;here/a./p /body/html Any help to get this working will be highly appreciated. Regards, Edwin [image: Inline image 1] ___ 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
Re: [Dhis2-devs] HazelCast Instance Is Not Active Error
Thanks Lars, We shall follow up to confirm that the fix is implemented. EM On Fri, Apr 24, 2015 at 11:04 AM, Lars Helge Øverland larshe...@gmail.com wrote: Okay, that was fixed yesterday. Lars On Fri, Apr 24, 2015 at 9:59 AM, Edwin Mulwa eddi...@gmail.com wrote: Hi CK, Please see responses below on the error the team was getting when trying to update data on the National DHIS platform. You could find out from the ministry what version they are using and share this with them to help them alleviate the problem. Thanks. EM On Fri, Apr 24, 2015 at 10:52 AM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Eddie, I actually saw this error yesterday and made a proposed fix. I assume you are running DHIS 2.16. The best option is to upgrade to a later stable version, the second best option is to upgrade to the latest 2.16 from dhis2.org/downloads. Which instance is this? regards, Lars On Fri, Apr 24, 2015 at 9:29 AM, Morten Olav Hansen morte...@gmail.com wrote: Hi Eddie HazelCast was removed a few releases ago, what version of DHIS 2 are you running? could you update to the latest revision of your version (just download same war file again) -- Morten On Thu, Apr 23, 2015 at 8:58 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, We are experiencing this error when entering data into DHIS2 (see screenshot). Any help to resolve this will be highly appreciated. Regards, 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 ___ 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 ___ 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
Re: [Dhis2-devs] HazelCast Instance Is Not Active Error
Hi CK, Please see responses below on the error the team was getting when trying to update data on the National DHIS platform. You could find out from the ministry what version they are using and share this with them to help them alleviate the problem. Thanks. EM On Fri, Apr 24, 2015 at 10:52 AM, Lars Helge Øverland larshe...@gmail.com wrote: Hi Eddie, I actually saw this error yesterday and made a proposed fix. I assume you are running DHIS 2.16. The best option is to upgrade to a later stable version, the second best option is to upgrade to the latest 2.16 from dhis2.org/downloads. Which instance is this? regards, Lars On Fri, Apr 24, 2015 at 9:29 AM, Morten Olav Hansen morte...@gmail.com wrote: Hi Eddie HazelCast was removed a few releases ago, what version of DHIS 2 are you running? could you update to the latest revision of your version (just download same war file again) -- Morten On Thu, Apr 23, 2015 at 8:58 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, We are experiencing this error when entering data into DHIS2 (see screenshot). Any help to resolve this will be highly appreciated. Regards, 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 ___ 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 ___ 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
[Dhis2-devs] Updated Data Not Reflecting On DHIS until after Midnight?
Dear All, An interesting scenario: When users are updating data on DHIS (by updating I mean modifying existing data using the Data Entry screen), it appears that the updated data does not immediately reflect on DHIS but gets reflected after midnight local time. If I go to the Data Set Report screen immediately after updating data, I don't see the changes that were entered in the Data Entry screen. Is this how DHIS has been designed or are the changes supposed to reflect immediately? Thanks! ___ 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
Re: [Dhis2-devs] Updated Data Not Reflecting On DHIS until after Midnight?
Thank you Moses. EM On Fri, Apr 24, 2015 at 4:40 PM, Moses Marimo mar...@ict.co.zw wrote: This is because the Analytics Tables are updated automatically at midnight. You can however, manually update the analytics Tables by going to reports and choosing Analytics and Datamart, then manually run the update. Data entered will only become available in reports after the analytics tables have been updated. Regards, Moses On Fri, Apr 24, 2015 at 3:22 PM, Edwin Mulwa eddi...@gmail.com wrote: Dear All, An interesting scenario: When users are updating data on DHIS (by updating I mean modifying existing data using the Data Entry screen), it appears that the updated data does not immediately reflect on DHIS but gets reflected after midnight local time. If I go to the Data Set Report screen immediately after updating data, I don't see the changes that were entered in the Data Entry screen. Is this how DHIS has been designed or are the changes supposed to reflect immediately? Thanks! ___ 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 -- ICT Warehouse (Pvt) Ltd - The Stockist of *e*-nnovation 7 Chelmsford Belgravia, Harare Tel: +263-8644-102349 Cell: +263-772-268353 Website: *www.ict.co.zw http://www.ict.co.zw* Innovative solutions in Web Design and E-Commerce, Software Engineering, Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT Solutions and Consultancy. ___ 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
Re: [Dhis2-devs] Exclude dataEntryForm Nodes From dataSets
Hi Morten, here is the URL: curl -H Accept: application/xml -u admin:district http://apps.dhis2.org/demo/api/dataSets.xml?viewClass=detailedexclude=dataEntryFormlinks=falsepaging=false I want ALL the dataSets and its associated dataElements but I don't want the dataEntryForm child node included (or any other child nodes for that matter). Edwin On Tue, May 20, 2014 at 1:28 PM, Morten Olav Hansen morte...@gmail.comwrote: Can you give me the URL you are trying? also, it will only work with a list of dataSets, not at the /api/dataSets/ID endpoint -- Morten On Tue, May 20, 2014 at 12:14 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I am extracting a list of dataSets from DHIS using the Web API and I would like to exclude the dataEntryForm node. I have tried using the exclude command as explained here: http://www.dhis2.org/doc/snapshot/en/user/html/ch28s07.html but this is not working. Any pointers on how to make this happen is welcome. 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 ___ 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
Re: [Dhis2-devs] Exclude dataEntryForm Nodes From dataSets
Thanks Morten. I'll give it a try. On Tue, May 20, 2014 at 2:35 PM, Morten Olav Hansen morte...@gmail.comwrote: http://apps.dhis2.org/demo/api/dataSets.json?exclude=dataEntryForm (admin / district) This will return pages output, you can add paging=false if you want to remove it -- Morten On Tue, May 20, 2014 at 1:18 PM, Edwin Mulwa eddi...@gmail.com wrote: Thanks Morten. Could you give me a sample command using JSON that I could use to achieve my goal? On Tue, May 20, 2014 at 2:07 PM, Morten Olav Hansen morte...@gmail.comwrote: Hi Only JSON is supported right now, we hope to have other renderers available in DHIS 2.17. When you add .xml, the include/exclude functionality is bypassed. -- Morten On Tue, May 20, 2014 at 1:03 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi Morten, here is the URL: curl -H Accept: application/xml -u admin:district http://apps.dhis2.org/demo/api/dataSets.xml?viewClass=detailedexclude=dataEntryFormlinks=falsepaging=false I want ALL the dataSets and its associated dataElements but I don't want the dataEntryForm child node included (or any other child nodes for that matter). Edwin On Tue, May 20, 2014 at 1:28 PM, Morten Olav Hansen morte...@gmail.com wrote: Can you give me the URL you are trying? also, it will only work with a list of dataSets, not at the /api/dataSets/ID endpoint -- Morten On Tue, May 20, 2014 at 12:14 PM, Edwin Mulwa eddi...@gmail.comwrote: Hi, I am extracting a list of dataSets from DHIS using the Web API and I would like to exclude the dataEntryForm node. I have tried using the exclude command as explained here: http://www.dhis2.org/doc/snapshot/en/user/html/ch28s07.html but this is not working. Any pointers on how to make this happen is welcome. 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 ___ 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
Re: [Dhis2-devs] [Dhis2-users] OpenMRS to DHIS2
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 eddi...@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 hakun...@gmail.comwrote: 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 eddi...@gmail.com wrote: 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 munnab...@gmail.comwrote: 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 eddi...@gmail.comwrote: 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-us...@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.ul...@giz.dehttps://owa.giz.de/owa/redir.aspx?C=661025cce79c464e8b9012e928442ab5URL=mailto%3amohammad.ullah%40giz.de, munnab...@gmail.com *Skype : mohammad_ullah_giz* -- *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: ad...@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. ___ 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
Re: [Dhis2-devs] OpenMRS to DHIS2
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 bobjolli...@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 eddi...@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 On Tue, Jan 28, 2014 at 7:11 AM, awanth sen wnthksn...@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 eddi...@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* ___ 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 ___ 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
Re: [Dhis2-devs] OpenMRS to DHIS2
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 bobjolli...@gmail.com wrote: Hi Edwin On 11 February 2014 13:19, Edwin Mulwa eddi...@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 bobjolli...@gmail.comwrote: 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 eddi...@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 On Tue, Jan 28, 2014 at 7:11 AM, awanth sen wnthksn...@gmail.comwrote: 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 eddi...@gmail.comwrote: 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* ___ 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 ___ 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
Re: [Dhis2-devs] [Dhis2-users] OpenMRS to DHIS2
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 munnab...@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 eddi...@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-us...@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.ul...@giz.dehttps://owa.giz.de/owa/redir.aspx?C=661025cce79c464e8b9012e928442ab5URL=mailto%3amohammad.ullah%40giz.de, munnab...@gmail.com *Skype : mohammad_ullah_giz* ___ 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
Re: [Dhis2-devs] [Dhis2-users] OpenMRS to DHIS2
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 hakun...@gmail.comwrote: 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 eddi...@gmail.com wrote: 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 munnab...@gmail.comwrote: 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 eddi...@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-us...@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.ul...@giz.dehttps://owa.giz.de/owa/redir.aspx?C=661025cce79c464e8b9012e928442ab5URL=mailto%3amohammad.ullah%40giz.de, munnab...@gmail.com *Skype : mohammad_ullah_giz* -- *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: ad...@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. ___ 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
Re: [Dhis2-devs] OpenMRS to DHIS2
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 wnthksn...@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 eddi...@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* ___ 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
Re: [Dhis2-devs] OpenMRS to DHIS2
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 thaichuong...@gmail.comwrote: 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 wnthksn...@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 On Mon, Jan 27, 2014 at 11:57 AM, Edwin Mulwa eddi...@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* ___ 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: thaichuong...@gmail.com Phone: (+84) 918776134 ___ 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
[Dhis2-devs] OpenMRS to DHIS2
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
Re: [Dhis2-devs] DHIS Import Log?
Hi Lars, That could indeed be the case though the interesting thing is that it was only after I created the resources tables that the import went through - using the same dataset that had failed initially when I did not do the resource tables creation. I tested this multiple times just to be sure. A caveat to that is I haven't tested this process again since I managed to make my DHIS installation use an actual database instead of an in-memory database. Will make time to test that and see what happens. Edwin On Wed, Dec 18, 2013 at 6:23 PM, Lars Helge Øverland larshe...@gmail.comwrote: Hi Edwin, there is no link between resource tables and meta-data import so I don't think that's significant. Since the logs says surname cannot be null I think that was the source of the problem - there might be a problem with the export function not including surnames, or some database integrity issues with the source database. Lars On Tue, Dec 17, 2013 at 11:10 AM, Edwin Mulwa eddi...@gmail.com wrote: Hi All, An interesting update is as follows: I removed ALL the users in the XML file and managed to import everything. This of course didn't really solve my problem because I eventually needed to import users as well. After importation, I encountered a new problem: When I tried to do data entry, the Data Sets combo box was not loading with data. Checking the log, I found the following message: ** ERROR 2013-12-17 01:00:56,744 Resource table _dataelementcategoryoptioncomboname does not exist, please generate it (HibernateDataElementStore.java [http-bio-8080-exec-9])* I found, from checking previous posts, that I needed to create resource tables from Maintenance-Data Administration; which I did. Then I decided to try and import all my metadata afresh, including the users (ensuring that all users have firstname and surname defined) and the import WORKED!! What this means is that the error I was getting telling me that the surname should not be null AFTER I had rectified the source XML file was not an accurately reported error. The error must have been something to do with missing resource tables. I think this is a potential bug in DHIS that should be investigated. Edwin On Mon, Dec 16, 2013 at 5:03 PM, Morten Olav Hansen morte...@gmail.comwrote: Hi Edwin, I'm not really sure.. if you know your way around a text-editor, you can try and remove all user but a few.. and see if it still fails, there might be a few users in there that have some errors -- Morten On Mon, Dec 16, 2013 at 2:52 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi Morten, You pointed me in the right direction. Thanks. Taking a look at the log, it shows that there is a NULL value in surname field when its trying to insert a record in the userinfo table. I checked the source metadata.xml file and ensured that all surname entries have a value. I still get the same error. See attached log snippet. Any thoughts on why this is persisting even in the absence of NULL values? Edwin On Mon, Dec 16, 2013 at 4:59 AM, Edwin Mulwa eddi...@gmail.com wrote: Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen morte...@gmail.com wrote: I would recommend looking at logs/catalina.out (assuming you are running tomcat) -- Morten On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa eddi...@gmail.comwrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing Users section (see attached screenshot). Is there an import log that I can check to see what is happening? 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 ___ 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 ___ 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
[Dhis2-devs] DHIS2 Meta-Data and Data Import Issues
Hi, I have some major problems when I am trying to import meta-data and data from one DHIS2 instance to another. These are as follows: Issue 1: I have a DHIS2 installation running on a VMWare Virtual Machine. Using the Meta-Data Export/Import features in DHIS2, I have imported data from another DHIS2 instance running on a laptop into the VM successfully. Successfully in quotes because the log says it was imported successfully. However, when I shut down the VM and start it again, all the imported data is missing from the VM. That is, it is as if I did not import any data. In the data import screen, Dry Run option is set to No. I did take a snapshot of the VM immediately after importation and reverted to the snapshot after firing up the VM but nothing doing. Any ideas on why the data is not persisting on the VM? Note: Nothing I am doing on the VM persists! For example, I looked at the default user I have been using to access DHIS2 (admin:district) and added all the roles to the user. These additions to the user account were not reflected after restarting the VM. Important Note: I have noticed, by looking at the logs, that every time the DHIS2 instance starts up, it is attempting to run alot of table altering SQL commands, most of which are failing. I suspect that it is these commands that are interfering with my data. If you would like to see a copy of the log file, I will be happy to provide it. Issue 2: After importing the data, I log out of DHIS2 and try logging in using a different user whose info has been imported into the VM. This does not work. This is BEFORE I even shut down the machine. When I log back in using the default admin user, I can see the user accounts in the system. Note: I have seen from an old posting on the forum that importation of users was disabled. I don't know if this is still the case and therefore why I am having this problem? Issue 3: After importing meta-data, I immediately tried to import DATA from the other instance. Data import fails with a message that it was unable to clear the BatchHandler. Any help on the above issues will be appreciated. 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
Re: [Dhis2-devs] DHIS2 Meta-Data and Data Import Issues
Morten, Thank you! The in-memory db was the cause of one of my problems. So Issue 1 is resolved! :) I still cannot log in using an imported user. I suspect is it for the reason I mentioned in my original post i.e. importation of users was disabled? The other remaining problem is the importation of XML data. It is still giving a Failed to flush BatchHandler error when I try to import the data. I have attached the relevant section of the log file so that you check and see if you can make anything of it. Thanks alot Morten! Edwin On Wed, Dec 18, 2013 at 1:23 AM, Morten Olav Hansen morte...@gmail.comwrote: Hi, From what you are saying, it sounds like all these issues are caused by using an in-memory db.. Are you sure that you are connecting to a database, and that the user has the proper privileges? Try to look for dhis2 home references in the log.. it should be early in the startup -- Morten On Wed, Dec 18, 2013 at 10:09 AM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I have some major problems when I am trying to import meta-data and data from one DHIS2 instance to another. These are as follows: Issue 1: I have a DHIS2 installation running on a VMWare Virtual Machine. Using the Meta-Data Export/Import features in DHIS2, I have imported data from another DHIS2 instance running on a laptop into the VM successfully. Successfully in quotes because the log says it was imported successfully. However, when I shut down the VM and start it again, all the imported data is missing from the VM. That is, it is as if I did not import any data. In the data import screen, Dry Run option is set to No. I did take a snapshot of the VM immediately after importation and reverted to the snapshot after firing up the VM but nothing doing. Any ideas on why the data is not persisting on the VM? Note: Nothing I am doing on the VM persists! For example, I looked at the default user I have been using to access DHIS2 (admin:district) and added all the roles to the user. These additions to the user account were not reflected after restarting the VM. Important Note: I have noticed, by looking at the logs, that every time the DHIS2 instance starts up, it is attempting to run alot of table altering SQL commands, most of which are failing. I suspect that it is these commands that are interfering with my data. If you would like to see a copy of the log file, I will be happy to provide it. Issue 2: After importing the data, I log out of DHIS2 and try logging in using a different user whose info has been imported into the VM. This does not work. This is BEFORE I even shut down the machine. When I log back in using the default admin user, I can see the user accounts in the system. Note: I have seen from an old posting on the forum that importation of users was disabled. I don't know if this is still the case and therefore why I am having this problem? Issue 3: After importing meta-data, I immediately tried to import DATA from the other instance. Data import fails with a message that it was unable to clear the BatchHandler. Any help on the above issues will be appreciated. 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 * INFO 2013-12-18 04:05:07,158 [data element id scheme: UID, org unit id scheme: UID, dry run: false, async: false, strategy: NEW_AND_UPDATES, skip check: false] (ImportDataValueAction.java [http-bio-8080-exec-4]) * INFO 2013-12-18 04:05:07,237 [Level: INFO, category: DATAVALUE_IMPORT, time: Wed Dec 18 04:05:07 PST 2013, message: Process started] (InMemoryNotifier.java [taskScheduler-1]) * INFO 2013-12-18 04:05:08,493 [Level: INFO, category: DATAVALUE_IMPORT, time: Wed Dec 18 04:05:08 PST 2013, message: Importing data values] (InMemoryNotifier.java [taskScheduler-1]) * INFO 2013-12-18 04:05:08,493 importing data values (DefaultDataValueSetService.java [taskScheduler-1]) * ERROR 2013-12-18 04:05:08,596 java.lang.RuntimeException: Failed to flush BatchHandler at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:311) at org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.saveDataValueSet(DefaultDataValueSetService.java:447) at org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.saveDataValueSet(DefaultDataValueSetService.java:205) at org.hisp.dhis.importexport.action.util.ImportDataValueTask.run(ImportDataValueTask.java:86) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ScheduledThreadPoolExecutor
Re: [Dhis2-devs] [Dhis2-users] DHIS2 Meta-Data and Data Import Issues
Hi Bob, I will take a look at the data and see where the duplicates may be. The data was generated using Data-Export feature in DHIS so there is certainly a problem with this feature. When I was importing, I had selected New and Updates. The Updates bit of it should have handled the duplicates. To test this, when I selected Updates Only, the import went through successfully. Morten, as for the user, yes I am sure the user exists in the database. I will reset password and see what happens. Thanks! Edwin On Wed, Dec 18, 2013 at 3:34 PM, Bob Jolliffe bobjolli...@gmail.com wrote: On 18 December 2013 13:30, Morten Olav Hansen morte...@gmail.com wrote: I still cannot log in using an imported user. I suspect is it for the reason I mentioned in my original post i.e. importation of users was disabled? Did you check to see that the users exists in the system? we do support import, but we null out the passwords.. for security reasons. So you will need to re-set the passwords. The other remaining problem is the importation of XML data. It is still giving a Failed to flush BatchHandler error when I try to import the data. I have attached the relevant section of the log file so that you check and see if you can make anything of it. I'm not sure about that one.. it says duplicate value, but I guess that should have been treated as an update.. could you file a bug report for it? Yes its definitely a bug or at least an ugly behaviour. I should have reported it earlier - we saw the same importing unclean data from iHRIS in Rwanda. Once we cleaned the data up all was fine. Updates only happen when these are part of separate batches. Duplicates in the same import batch get stuck in the throat. -- Morten Thanks alot Morten! Edwin On Wed, Dec 18, 2013 at 1:23 AM, Morten Olav Hansen morte...@gmail.comwrote: Hi, From what you are saying, it sounds like all these issues are caused by using an in-memory db.. Are you sure that you are connecting to a database, and that the user has the proper privileges? Try to look for dhis2 home references in the log.. it should be early in the startup -- Morten On Wed, Dec 18, 2013 at 10:09 AM, Edwin Mulwa eddi...@gmail.comwrote: Hi, I have some major problems when I am trying to import meta-data and data from one DHIS2 instance to another. These are as follows: Issue 1: I have a DHIS2 installation running on a VMWare Virtual Machine. Using the Meta-Data Export/Import features in DHIS2, I have imported data from another DHIS2 instance running on a laptop into the VM successfully. Successfully in quotes because the log says it was imported successfully. However, when I shut down the VM and start it again, all the imported data is missing from the VM. That is, it is as if I did not import any data. In the data import screen, Dry Run option is set to No. I did take a snapshot of the VM immediately after importation and reverted to the snapshot after firing up the VM but nothing doing. Any ideas on why the data is not persisting on the VM? Note: Nothing I am doing on the VM persists! For example, I looked at the default user I have been using to access DHIS2 (admin:district) and added all the roles to the user. These additions to the user account were not reflected after restarting the VM. Important Note: I have noticed, by looking at the logs, that every time the DHIS2 instance starts up, it is attempting to run alot of table altering SQL commands, most of which are failing. I suspect that it is these commands that are interfering with my data. If you would like to see a copy of the log file, I will be happy to provide it. Issue 2: After importing the data, I log out of DHIS2 and try logging in using a different user whose info has been imported into the VM. This does not work. This is BEFORE I even shut down the machine. When I log back in using the default admin user, I can see the user accounts in the system. Note: I have seen from an old posting on the forum that importation of users was disabled. I don't know if this is still the case and therefore why I am having this problem? Issue 3: After importing meta-data, I immediately tried to import DATA from the other instance. Data import fails with a message that it was unable to clear the BatchHandler. Any help on the above issues will be appreciated. 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 ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-us...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https
Re: [Dhis2-devs] DHIS Import Log?
Hi All, An interesting update is as follows: I removed ALL the users in the XML file and managed to import everything. This of course didn't really solve my problem because I eventually needed to import users as well. After importation, I encountered a new problem: When I tried to do data entry, the Data Sets combo box was not loading with data. Checking the log, I found the following message: ** ERROR 2013-12-17 01:00:56,744 Resource table _dataelementcategoryoptioncomboname does not exist, please generate it (HibernateDataElementStore.java [http-bio-8080-exec-9])* I found, from checking previous posts, that I needed to create resource tables from Maintenance-Data Administration; which I did. Then I decided to try and import all my metadata afresh, including the users (ensuring that all users have firstname and surname defined) and the import WORKED!! What this means is that the error I was getting telling me that the surname should not be null AFTER I had rectified the source XML file was not an accurately reported error. The error must have been something to do with missing resource tables. I think this is a potential bug in DHIS that should be investigated. Edwin On Mon, Dec 16, 2013 at 5:03 PM, Morten Olav Hansen morte...@gmail.comwrote: Hi Edwin, I'm not really sure.. if you know your way around a text-editor, you can try and remove all user but a few.. and see if it still fails, there might be a few users in there that have some errors -- Morten On Mon, Dec 16, 2013 at 2:52 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi Morten, You pointed me in the right direction. Thanks. Taking a look at the log, it shows that there is a NULL value in surname field when its trying to insert a record in the userinfo table. I checked the source metadata.xml file and ensured that all surname entries have a value. I still get the same error. See attached log snippet. Any thoughts on why this is persisting even in the absence of NULL values? Edwin On Mon, Dec 16, 2013 at 4:59 AM, Edwin Mulwa eddi...@gmail.com wrote: Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen morte...@gmail.comwrote: I would recommend looking at logs/catalina.out (assuming you are running tomcat) -- Morten On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing Users section (see attached screenshot). Is there an import log that I can check to see what is happening? 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 ___ 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
[Dhis2-devs] [Bug 1044890] Re: Data import error between 2 DHIS2 systems
** Description changed: When we imported meta data exported from DGHS into dhis2_h1_2_6, I found the following error * WARN 10:24:44,589 SQL Error: 1062, SQLState: 23000 (JDBCExceptionReporter.jav a [Thread-16]) * ERROR 10:24:44,590 Duplicate entry 'HS_27451657073' for key 3 (JDBCExceptionRe porter.java [Thread-16]) * ERROR 10:24:44,623 Internal process failed (AbstractStatementInternalProcess.j ava [Thread-16]) org.hibernate.exception.ConstraintViolationException: Could not execute JDBC bat ch update - at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j + at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:96) - at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp + at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:66) - at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: + at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: 275) - at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) - - at + at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) + + at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) - at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio + at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio ns(AbstractFlushingEventListener.java:321) - at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def + at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(Def aultAutoFlushEventListener.java:64) - at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1 + at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1 185) - at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709) - at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) - at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369) - at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene + at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1709) + at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) + at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369) + at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGene ricStore.java:175) - at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene + at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGene ricStore.java:235) - at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga + at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrga nisationUnitByName(DefaultOrganisationUnitService.java:192) - at sun.reflect.GeneratedMethodAccessor333.invoke(Unknown Source) - at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) - at java.lang.reflect.Method.invoke(Unknown Source) - at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti - on(AopUtils.java:309) - at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo - inpoint(ReflectiveMethodInvocation.java:183) - at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( - ReflectiveMethodInvocation.java:150) - at org.springframework.transaction.interceptor.TransactionInterceptor.in - voke(TransactionInterceptor.java:110) - at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( - ReflectiveMethodInvocation.java:172) - at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok + at sun.reflect.GeneratedMethodAccessor333.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) + at java.lang.reflect.Method.invoke(Unknown Source) + at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti + on(AopUtils.java:309) + at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo + inpoint(ReflectiveMethodInvocation.java:183) + at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( + ReflectiveMethodInvocation.java:150) + at org.springframework.transaction.interceptor.TransactionInterceptor.in + voke(TransactionInterceptor.java:110) + at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( + ReflectiveMethodInvocation.java:172) + at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok e(ExposeInvocationInterceptor.java:90) - at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( - ReflectiveMethodInvocation.java:172) - at
Re: [Dhis2-devs] DHIS Import Log?
Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen morte...@gmail.comwrote: I would recommend looking at logs/catalina.out (assuming you are running tomcat) -- Morten On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing Users section (see attached screenshot). Is there an import log that I can check to see what is happening? 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 ___ 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
Re: [Dhis2-devs] DHIS Import Log?
Hi Morten, You pointed me in the right direction. Thanks. Taking a look at the log, it shows that there is a NULL value in surname field when its trying to insert a record in the userinfo table. I checked the source metadata.xml file and ensured that all surname entries have a value. I still get the same error. See attached log snippet. Any thoughts on why this is persisting even in the absence of NULL values? Edwin On Mon, Dec 16, 2013 at 4:59 AM, Edwin Mulwa eddi...@gmail.com wrote: Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen morte...@gmail.comwrote: I would recommend looking at logs/catalina.out (assuming you are running tomcat) -- Morten On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing Users section (see attached screenshot). Is there an import log that I can check to see what is happening? 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 * INFO 2013-12-16 05:44:53,562 [Level: INFO, category: METADATA_IMPORT, time: Mon Dec 16 05:44:53 PST 2013, message: Importing 6303 Users] (InMemoryNotifier.java [taskScheduler-1]) * WARN 2013-12-16 05:44:53,969 SQL Error: 23502, SQLState: 23502 (SqlExceptionHelper.java [taskScheduler-1]) * ERROR 2013-12-16 05:44:53,969 NULL not allowed for column SURNAME; SQL statement: insert into userinfo (userinfoid, uid, code, lastUpdated, created, surname, firstName, email, phoneNumber, jobTitle, introduction, gender, birthday, nationality, employer, education, interests, languages, lastCheckedInterpretations) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23502-173] (SqlExceptionHelper.java [taskScheduler-1]) * ERROR 2013-12-16 05:44:54,869 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1]) org.hibernate.exception.ConstraintViolationException: could not execute statement at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136) at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2966) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3477) at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81) at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203) at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167) at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321) at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286) at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204) at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189) at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90) at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:763) at org.hibernate.internal.SessionImpl.save(SessionImpl.java:755) at org.hibernate.internal.SessionImpl.save(SessionImpl.java:751) at org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:269) at org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.save
Re: [Dhis2-devs] Compound Data Element
Jason, We have tried using indicators but it has not worked for us. As we see it, in DHIS an Indicator must always have a denominator. For us to fit in that rule and make our element D an indicator, we believe we have an option of dividing it with an element (let's call it F) that must always be =1 so that it doesn't change our value of D. So our indicator D=(A+B-C)/F. How to predefine the indicator F so that it is a constant 1 is a challenge. So it seems we cannot use the indicator method since most of our elements are not normally defined by a denominator but are rather additions and subtractions. Thoughts? Edwin On Wed, Dec 11, 2013 at 4:44 PM, Jason Pickering jason.p.picker...@gmail.com wrote: In DHIS2 terminology, this is referred to as an indicator. You can find them documented in the documentation, such as here http://www.dhis2.org/doc/snapshot/en/user/html/ch12.html#indicator Regards, Jason On Wed, Dec 11, 2013 at 3:19 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I would like to create a data element that is a calculation involving multiple data elements. For example, if I have data elements A, B, C and D, I would like data element D to be a calculation as follows: D = A + B - C. How can I do this in DHIS? Regards, 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 ___ 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
Re: [Dhis2-devs] Compound Data Element
Ok, will give that a shot and see if it works. Thanks! On Sat, Dec 14, 2013 at 10:06 AM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Eddie, You need to create a new indicator type, and be sure that Number is set to True and Factor is set to 1. This will have the affect of not requiring a denominator when you create indicators of this type. If you have Constants as you mention which never change, you can create them in Data administration-Constants and then use them in your indicator formula. Best regards, Jason --Sent from my mobile On Sat, Dec 14, 2013 at 8:56 AM, Edwin Mulwa eddi...@gmail.com wrote: Jason, We have tried using indicators but it has not worked for us. As we see it, in DHIS an Indicator must always have a denominator. For us to fit in that rule and make our element D an indicator, we believe we have an option of dividing it with an element (let's call it F) that must always be =1 so that it doesn't change our value of D. So our indicator D=(A+B-C)/F. How to predefine the indicator F so that it is a constant 1 is a challenge. So it seems we cannot use the indicator method since most of our elements are not normally defined by a denominator but are rather additions and subtractions. Thoughts? Edwin On Wed, Dec 11, 2013 at 4:44 PM, Jason Pickering jason.p.picker...@gmail.com wrote: In DHIS2 terminology, this is referred to as an indicator. You can find them documented in the documentation, such as here http://www.dhis2.org/doc/snapshot/en/user/html/ch12.html#indicator Regards, Jason On Wed, Dec 11, 2013 at 3:19 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I would like to create a data element that is a calculation involving multiple data elements. For example, if I have data elements A, B, C and D, I would like data element D to be a calculation as follows: D = A + B - C. How can I do this in DHIS? Regards, 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 ___ 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
[Dhis2-devs] Compound Data Element
Hi, I would like to create a data element that is a calculation involving multiple data elements. For example, if I have data elements A, B, C and D, I would like data element D to be a calculation as follows: D = A + B - C. How can I do this in DHIS? Regards, 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
Re: [Dhis2-devs] DHIS2 WSDL?
Hi Saptarsh, I have the same thought process as you have described below. I will let the group know how it progresses and/or if I have any questions. Thanks a lot! Edwin On Wed, Nov 27, 2013 at 4:31 PM, Saptarshi Purkayastha sun...@gmail.comwrote: DHIS2 provides a REST or REST-like interface over HTTP. So with just those 4 obvious verbs, I dont see that we really need a WSDL. To send data from an EHR to DHIS2, you should create a report within your EHR to match the reporting frequency, data elements + catcombos and add those as an XML dataValueSet This is documented here - http://www.dhis2.org/doc/snapshot/en/user/html/ch25s09.html You would probably need to exchange metadata before to get the UUIDs for the dataelements etc. If this is fairly fixed, should be fairly easy... if it isn't fixed you should read the metadata using - http://www.dhis2.org/doc/snapshot/en/user/html/ch25s05.html and then read from those and compare them with your EHR. It can be quite challenging to make it work in the first pass... but if you come back with specific questions, once you start integrating, we can help you better. --- Regards, Saptarshi PURKAYASTHA From: eddi...@gmail.com To: sun...@gmail.com Subject: DHIS2 WSDL? Date: Wed, 27 Nov 2013 12:21:24 + Hi, Does DHIS2 have a WSDL that I can use? I want to build a module in our java based EHR system that will automatically upload data into our DHIS2 instance. Eddie -- This message was sent from Launchpad by Edwin Mulwa (https://launchpad.net/~eddiemu) using the Contact this team's admins link on the DHIS 2 Users team page (https://launchpad.net/~dhis2-users). For more information see https://help.launchpad.net/YourAccount/ContactingPeople ___ 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