[Dhis2-users] Download event report (individual events) with option set values instead of codes
Hi everyone I am wondering if there is a method to download an event report using the data values of an option set rather then the code. I thought I remember this being possible in previous versions of DHIS2 but perhaps I am mistaken. I tried on play.dhis2.org/demo using this favorite: Inpatient: Inpatient cases last 14 days and converted this into an individual event overview. When I try to download it as a CSV or Excel file, no matter what type of ID scheme I select, it outputs the code of the included options rather then the data values. Is there any method to download these tables with the values instead? Here is an example table and the csv file for reference after selecting "Name" as the ID scheme [image: image.png] Thanks Nick -- Shurajit Dutta (MPH, MHI) Health Information Systems Adviser events.csv Description: MS-Excel spreadsheet ___ 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] Request Help On How To Access Web API in DHIS2
Hello Getachew, http://webaddress/api/{version}/{object} eg https://play.dhi2.org/api/29/organisationUnits You can also use the details option that will help guide you. [image: image.png] Abumere On Mon, Aug 20, 2018 at 2:04 PM Getachew Chala wrote: > Hi all, > I need Help On How To Access Web API in DHIS2. Please put the clear steps > and procedures how to access DHIS2 Web API. > > 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 > ___ 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] Error in event creation ERROR: relation "programstageinstance" does not exist Postion: 22
Forwarding to user list. On Mon, Aug 20, 2018 at 3:19 AM Parveen Panchal wrote: > Hello Everyone, > > I have created a tracker program in DHIS2 2.30. But when I am entering > the data from tracker it is showing the following error. > [image: error.png] > > Enrollment data has been entered but unable to edit it and enter data into > different stages, > > > > -- > > > > > > *Regards* > *Parveen Panchal* > *Contact No. - **+91-7827312972, **+91-9416865938* > -- Knut Staring Department of Information, Evidence and Research World Health Organization, Geneva, Switzerland Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 Skype: knutstar ___ 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] Request Help On How To Access Web API in DHIS2
The API is accessible like this: https://play.dhis2.org/2.30/api/resources It is documented here: https://docs.dhis2.org/master/en/developer/html/webapi.html#webapi_introduction Knut On Mon, Aug 20, 2018 at 9:04 AM Getachew Chala wrote: > Hi all, > I need Help On How To Access Web API in DHIS2. Please put the clear steps > and procedures how to access DHIS2 Web API. > > 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 > -- Knut Staring Department of Information, Evidence and Research World Health Organization, Geneva, Switzerland Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 Skype: knutstar ___ 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] Request Help On How To Access Web API in DHIS2
Hi all, I need Help On How To Access Web API in DHIS2. Please put the clear steps and procedures how to access DHIS2 Web API. 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
[Dhis2-users] Steps to Access Web API in DHIS2
Hi there! Please help me in how to access API in DHIS2. I need a clear steps to do so. Thank you. ___ 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] Delete Validation Rules
Hi I do NOT agree that it should be possible to delete data elements that have datavalue or tracker records - in such cases where there is real DATA, the user must assess and delete such DATA first or else leave the data element no longer in use (with its data) - we typically move such historical data elements to an "inactive" data set. On the other hand, I have found many meta-data objects where deletion is being blocked due to (sometimes random) records in other meta-data tables - meta-data that clearly won't be relevant any more (e.g. various tables called "dimensionitems" is a typical example). It is also a huge problem that when e.g. data elements - even data elements with no actual data - at some stage were included in some favourite, deletion is blocked AND the error message says nothing about WHERE it is used. I always end up spending considerable time tracking those down in the back end and deleting them, before being able to delete the data element itself. Audit trails is another example of "process" data that no longer is useful when e.g. a data element is deleted. Regards Calle On Mon, 20 Aug 2018 at 11:35, Em Le Hong wrote: > Hi, > > I agree with Calle Hedberg that the system should automatically delete any > dependent records related to validation rules. > In DHIS2, this kind of issue is not only happen with Validation rules, but > also with many other objects. > > For example to delete a data element, we need to delete its data value and > audit trail. DHIS2 already provided API to delete data value and audit trail > */api/26/maintenance/dataPruning/dataElement/* > > I hope DHIS2 will support to delete validation rules and other objects > soon. > > On Wed, Aug 8, 2018 at 7:47 PM Calle Hedberg > wrote: > >> Hi >> >> Agree with Morten that it's a bug - it should be obvious that if you >> delete a validation rule, any old validation rule results are no longer of >> interest (with the rule deleted, you would not even know which rule any >> remaining results were referring too). >> >> So the solution here is that when you delete a validation rule, the >> system should automatically first delete any dependent records in the >> following tables, which have validationruleid as a foreign key: >> >> "validationnotificationtemplatevalidationrules" >> "validationresult" >> "validationruleattributevalues" >> "validationrulegroupmembers" >> "validationruleorganisationunitlevels" >> "validationrulesynchstatus" >> "validationruletranslations" >> "validationruleuseraccesses" >> "validationruleusergroupaccesses" >> >> Regards >> Calle >> >> On Wed, 8 Aug 2018 at 07:03, Morten Olav Hansen wrote: >> >>> Hi Em >>> >>> I'm not sure if there is any UI for deleting validation results, but you >>> can do it yourself in the database. >>> >>> The validationresults are located in the table "validationresult", and >>> it has a column called "validationruleid" which links to your validation >>> rules. >>> >>> So you need to find that validation rule in the "validationrule" table, >>> and use that "validationruleid" to delete the correct rows from the >>> "validationresult" table. >>> >>> "DELETE FROM validationresult WHERE validationruleid=??" >>> >>> This does sound like a bug though, so please file one in JIRA >>> >>> -- >>> Morten Olav Hansen >>> Senior Engineer, DHIS 2 >>> Team Integration Lead >>> University of Oslo >>> http://www.dhis2.org >>> >>> On Tue, Aug 7, 2018 at 5:07 PM, Em Le Hong >>> wrote: >>> Dear all, DHIS 2.29 I try to delete a validation rule on my database but the system response a message: Could not delete due to association with another object: ValidationResult This mean we need to delete Validation Result before delete Validation Rule Does anyone know how to delete Validation Result, if you don't mind please share. Thanks, -- *Em Le Hong* DHIS2 Implementation| *HISP Vietnam * em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com ___ 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-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >> >> >> -- >> >> *** >> >> Calle Hedberg >> >> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >> >> Tel/fax (home): +27-21-685-6472 >> >> Cell: +27-82-853-5352 >> >> Iridium SatPhone: +8816-315-19119 >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> *** >> >> > > -- > *Em Le Hong* > DHIS2
Re: [Dhis2-users] [Dhis2-devs] Delete Validation Rules
Hi, I agree with Calle Hedberg that the system should automatically delete any dependent records related to validation rules. In DHIS2, this kind of issue is not only happen with Validation rules, but also with many other objects. For example to delete a data element, we need to delete its data value and audit trail. DHIS2 already provided API to delete data value and audit trail */api/26/maintenance/dataPruning/dataElement/* I hope DHIS2 will support to delete validation rules and other objects soon. On Wed, Aug 8, 2018 at 7:47 PM Calle Hedberg wrote: > Hi > > Agree with Morten that it's a bug - it should be obvious that if you > delete a validation rule, any old validation rule results are no longer of > interest (with the rule deleted, you would not even know which rule any > remaining results were referring too). > > So the solution here is that when you delete a validation rule, the system > should automatically first delete any dependent records in the following > tables, which have validationruleid as a foreign key: > > "validationnotificationtemplatevalidationrules" > "validationresult" > "validationruleattributevalues" > "validationrulegroupmembers" > "validationruleorganisationunitlevels" > "validationrulesynchstatus" > "validationruletranslations" > "validationruleuseraccesses" > "validationruleusergroupaccesses" > > Regards > Calle > > On Wed, 8 Aug 2018 at 07:03, Morten Olav Hansen wrote: > >> Hi Em >> >> I'm not sure if there is any UI for deleting validation results, but you >> can do it yourself in the database. >> >> The validationresults are located in the table "validationresult", and it >> has a column called "validationruleid" which links to your validation rules. >> >> So you need to find that validation rule in the "validationrule" table, >> and use that "validationruleid" to delete the correct rows from the >> "validationresult" table. >> >> "DELETE FROM validationresult WHERE validationruleid=??" >> >> This does sound like a bug though, so please file one in JIRA >> >> -- >> Morten Olav Hansen >> Senior Engineer, DHIS 2 >> Team Integration Lead >> University of Oslo >> http://www.dhis2.org >> >> On Tue, Aug 7, 2018 at 5:07 PM, Em Le Hong >> wrote: >> >>> Dear all, >>> >>> DHIS 2.29 >>> >>> I try to delete a validation rule on my database but the system response >>> a message: >>> Could not delete due to association with another object: ValidationResult >>> >>> This mean we need to delete Validation Result before delete Validation >>> Rule >>> >>> Does anyone know how to delete Validation Result, if you don't mind >>> please share. >>> >>> Thanks, >>> -- >>> *Em Le Hong* >>> DHIS2 Implementation| *HISP Vietnam * >>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >>> >>> >>> >>> >>> >>> >>> ___ >>> 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-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > > > -- > > *** > > Calle Hedberg > > 46D Alma Road, 7700 Rosebank, SOUTH AFRICA > > Tel/fax (home): +27-21-685-6472 > > Cell: +27-82-853-5352 > > Iridium SatPhone: +8816-315-19119 > > Email: calle.hedb...@gmail.com > > Skype: calle_hedberg > > *** > > -- *Em Le Hong* DHIS2 Implementation| *HISP Vietnam * em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com ___ 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] Importing Organisation Unit
Dear Knut, I posted yesterday on dhis2-users but, Lars requested me to post on this group. Thanks & Regards, Nibras Ar Rakib From: Knut Staring [knu...@gmail.com] Sent: Sunday, August 19, 2018 7:46 PM To: Nibras Ar Rakib; DHIS 2 Users list Subject: Re: Importing Organisation Unit Hello Nibras, I am forwarding this to the DHIS 2 Users list mailto:dhis2-users@lists.launchpad.net>>. Please use this address for technical queries Regards, Knut On Sun, Aug 19, 2018 at 1:27 AM Nibras Ar Rakib mailto:nibras.ra...@icddrb.org>> wrote: Dear Sir, My name is Nibras Ar Rakib and currently I am working at icddr, b (International Centre for Diarrhoeal Disease Research, Bangladesh) as programmer and involved in Routine Health Information System (RHIS). We have successfully installed and configured DHIS2 (2.29) for aggregated data collection purpose for different region of Bangladesh. Problem we are currently facing is preparing the csv file for importing organization unit. One particular field I do not understand that in the documentation (https://docs.dhis2.org/2.29/en/developer/html/webapi_csv_metadata_import.html- Table: 1.19) that there is column named UID and Parent UID. During populating the csv, do we need to specify those UIDS and Parent UIDS (I know we should do that otherwise hierarchy wont populate. Also then I need to handle Parent UIDS programmatically)? If that happens, then I need to populate the csv programmatically. I also know, DHIS2 has an API that provide stable identifier. Is there any other way around to develop the hierarchical organization unit? It would be really helpful if you provide your ideas or suggestion regarding this. This is the first time I am posting in this team. If this this team is not appropriate for this question please let me know and delete this message. Thanks & Regards, Nibras Ar Rakib -- This message was sent from Launchpad by Nibras Ar Rakib (https://launchpad.net/~nibras.rakib) 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 -- Knut Staring Department of Information, Evidence and Research World Health Organization, Geneva, Switzerland Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 Skype: knutstar ___ 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