[Dhis2-users] Web API Not Allowing Bulk Data Values Transfer on Demo Site
301 Moved Permanently Moved Permanently The document has moved https://apps.dhis2.org/demo/api/dataValueSets";>here. 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: http://dhis2.org/schema/dxf/2.0";> Below is the result I get (I have also attached a screenshot of what is fully returned): 301 Moved Permanently Moved Permanently The document has moved https://apps.dhis2.org/demo/api/dataValueSets";>here. Any help to get this working will be highly appreciated. Regards, Edwin [image: Inline image 1] ___ 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
Re: [Dhis2-users] [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 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 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-d...@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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] 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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [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 wrote: > Hi Edwin > > On 11 February 2014 13:19, Edwin Mulwa 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 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 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 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 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-d...@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-d...@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-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [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 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 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 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 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-d...@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-d...@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-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [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 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 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 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 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 wrote: >>>> >>>>> Hi All, >>>>> >>>>> Is there a tool/module that automates data transfer from OpenMRS to >>>>> DHIS2? I need such a tool for some work that I am doing. >>>>> >>>>> Thanks. >>>>> >>>>> Edwin >>>>> >>>>> >>>>> ___ >>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>> Post to : dhis2-users@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>>> >>>> -- >>>> *Mohammad Ullah* >>>> >>>> *Technical Advisor - HIS* >>>> Priority Area - Health >>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH >>>> House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh >>>> >>>> *Office location:* >>>> Room # 304, Shahid Dr. Milan Bhavan, >>>> Management Information System (MIS) >>>> Directorate General of Health Services of MoHFW, Mohakhali, >>>> Dhaka-1212, Bangladesh >>>> T. +880 (0) 8816459, 8816412 Ext:118 >>>> M. +88 0196 3156 988 >>>> Web. http://lnkd.in/gQrxXz >>>> E >>>> mohammad.ul...@giz.de<https://owa.giz.de/owa/redir.aspx?C=661025cce79c464e8b9012e928442ab5&URL=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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [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 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 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 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 wrote: >>> >>>> Hi All, >>>> >>>> Is there a tool/module that automates data transfer from OpenMRS to >>>> DHIS2? I need such a tool for some work that I am doing. >>>> >>>> Thanks. >>>> >>>> Edwin >>>> >>>> >>>> ___ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-users@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> >>> -- >>> *Mohammad Ullah* >>> >>> *Technical Advisor - HIS* >>> Priority Area - Health >>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH >>> House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh >>> >>> *Office location:* >>> Room # 304, Shahid Dr. Milan Bhavan, >>> Management Information System (MIS) >>> Directorate General of Health Services of MoHFW, Mohakhali, >>> Dhaka-1212, Bangladesh >>> T. +880 (0) 8816459, 8816412 Ext:118 >>> M. +88 0196 3156 988 >>> Web. http://lnkd.in/gQrxXz >>> E >>> mohammad.ul...@giz.de<https://owa.giz.de/owa/redir.aspx?C=661025cce79c464e8b9012e928442ab5&URL=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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [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 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 wrote: > >> Hi All, >> >> Is there a tool/module that automates data transfer from OpenMRS to >> DHIS2? I need such a tool for some work that I am doing. >> >> Thanks. >> >> Edwin >> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > *Mohammad Ullah* > > *Technical Advisor - HIS* > Priority Area - Health > Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH > House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh > > *Office location:* > Room # 304, Shahid Dr. Milan Bhavan, > Management Information System (MIS) > Directorate General of Health Services of MoHFW, Mohakhali, > Dhaka-1212, Bangladesh > T. +880 (0) 8816459, 8816412 Ext:118 > M. +88 0196 3156 988 > Web. http://lnkd.in/gQrxXz > E > mohammad.ul...@giz.de<https://owa.giz.de/owa/redir.aspx?C=661025cce79c464e8b9012e928442ab5&URL=mailto%3amohammad.ullah%40giz.de>, > munnab...@gmail.com > > *Skype : mohammad_ullah_giz* > ___ 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
Re: [Dhis2-users] [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 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 > > 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 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-d...@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-d...@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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [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 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 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-d...@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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] 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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Cumulative Reporting?
Hi Jason, Happy New Year! Wishing you the best in 2014. I'm following up on your email below. I'm thinking of going the PL/R route because I would like to display my cumulative-based report in DHIS rather than generate it outside of DHIS. I presume that using PL/R, I can write custom functions within the DHIS database and use them to update a custom report table that I can use for generating my report from within DHIS. Does this make sense? Is there any data dictionary documentation available publicly that describes all the tables in the DHIS database that I can reference while writing my custom functions? Thanks! Edwin On Wed, Dec 11, 2013 at 9:54 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Eddie, > > You certainly could, but there is no way to do this directly with DHIS2 I > think . You could use windowing functions of Postgresql [0] to calculate > the cumulative sum, or create your own function with a custom function with > PL/R which has been described in the documentation outlined here [1]. There > are various ways to do this in R, either with the base "cumsum" function or > with more advanced methods in the "timeSeries" package depending on your > exact needs. > > The simplest method however might be to use Excel [2] . > > However at the moment, there is no way to do this directly with DHIS2 as > far as I know. But if others know more direct methods, it would be good to > know! > > Regards, > Jason > > > [0] > http://www.postgresonline.com/journal/archives/47-How-to-calculate-Running-Totals-and-Sums-in-SQL.html > [1] http://www.dhis2.org/doc/snapshot/en/user/html/apcs06.html > [2]http://support.microsoft.com/kb/214149 > > > On Wed, Dec 11, 2013 at 1:50 PM, Edwin Mulwa wrote: > >> Hi, >> >> I would like to create a report that has a field(s) which is a cumulative >> total calculation involving multiple data elements. For example, I have >> data elements A and B and I am doing monthly cumulative reporting such that >> the value for element A in Feb will be the value of A in Jan + the new >> value for B in Feb, the value for A in March will be the value of A in Feb >> + the new value for B in March, etc. >> >> Can we create such a report in DHIS? >> >> 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 >> >> > ___ 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
Re: [Dhis2-users] [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 wrote: > 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 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 >> wrote: >> >>> 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 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 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 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-d...@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-d...@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-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] 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 wrote: > On 18 December 2013 13:30, Morten Olav Hansen 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 >>> wrote: >>> >>>> 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 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: &g
Re: [Dhis2-users] [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 wrote: > 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 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-d...@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.dataval
[Dhis2-users] 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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [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 wrote: > 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 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 wrote: >> >>> Ok, thanks. Yes I am... >>> >>> >>> On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen >>> 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 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-d...@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-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [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 wrote: > Ok, thanks. Yes I am... > > > On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen 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 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-d...@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.Sessio
Re: [Dhis2-users] [Dhis2-devs] DHIS Import Log?
Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen 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 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-d...@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-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Cumulative Reporting?
Jason, You described perfectly what I am looking for. The "Running Sum" operator is what would be useful for solving my problem. Edwin On Thu, Dec 12, 2013 at 7:36 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Knut, > This is not quite the same thing. There may be data for time periods > earlier than 2013 of course. > > But as I have implemented this requirement other places in the form of > reports/scripts to generate this data, if the following data is reported > > Dec 2012 9 > Jan 2013 10 > Feb 2013 15 > March 2013 14 > .. > > The cumulative "indicator" for this would be > Dec 2012 9 > Jan 2013 19 > Feb 2013 34 > March 2013 48 > ... > > These sorts of indicators are needed when calculating things like "Number > of people who have ever started ART", where "New ART starts" are reported > each month. So instead of having the facility to calculate "Number of > people who have every started ART", it can be calculated with a > cumulative/running total instead from the new figures reported each month. > I think this arises from the lack of a "RUNNING SUM" operator for the time > dimension in DHIS2, which probably should be there. > > Best regards, > Jason > > > > On Thu, Dec 12, 2013 at 2:53 AM, Knut Staring wrote: > >> I think you could just take the yearly data for 2013. This should add up >> what is available so far this year. >> >> Sent from my mobile >> On 12 Dec 2013 01:55, "Jason Pickering" >> wrote: >> >>> Hi Eddie, >>> >>> You certainly could, but there is no way to do this directly with DHIS2 >>> I think . You could use windowing functions of Postgresql [0] to calculate >>> the cumulative sum, or create your own function with a custom function with >>> PL/R which has been described in the documentation outlined here [1]. There >>> are various ways to do this in R, either with the base "cumsum" function or >>> with more advanced methods in the "timeSeries" package depending on your >>> exact needs. >>> >>> The simplest method however might be to use Excel [2] . >>> >>> However at the moment, there is no way to do this directly with DHIS2 as >>> far as I know. But if others know more direct methods, it would be good to >>> know! >>> >>> Regards, >>> Jason >>> >>> >>> [0] >>> http://www.postgresonline.com/journal/archives/47-How-to-calculate-Running-Totals-and-Sums-in-SQL.html >>> [1] http://www.dhis2.org/doc/snapshot/en/user/html/apcs06.html >>> [2]http://support.microsoft.com/kb/214149 >>> >>> >>> On Wed, Dec 11, 2013 at 1:50 PM, Edwin Mulwa wrote: >>> >>>> Hi, >>>> >>>> I would like to create a report that has a field(s) which is a >>>> cumulative total calculation involving multiple data elements. For example, >>>> I have data elements A and B and I am doing monthly cumulative reporting >>>> such that the value for element A in Feb will be the value of A in Jan + >>>> the new value for B in Feb, the value for A in March will be the value of A >>>> in Feb + the new value for B in March, etc. >>>> >>>> Can we create such a report in DHIS? >>>> >>>> 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 >>>> >>>> >>> >>> ___ >>> 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 >>> >>> > ___ 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
[Dhis2-users] Cumulative Reporting?
Hi, I would like to create a report that has a field(s) which is a cumulative total calculation involving multiple data elements. For example, I have data elements A and B and I am doing monthly cumulative reporting such that the value for element A in Feb will be the value of A in Jan + the new value for B in Feb, the value for A in March will be the value of A in Feb + the new value for B in March, etc. Can we create such a report in DHIS? 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
