[Dhis2-users] Get Date Values

Hello, We recently implemented DHIS2 for our data collection needs and are currently looking at the first data submitted. Am just getting used to the table structure and need help on where the Data Set data entry dates/periods are saved. In the datavalue table I have a field periodid but cant seem

Re: [Dhis2-users] Get Date Values

n the data point value was last update). > > Best, > Vlad > > On Thu, Aug 16, 2018 at 2:54 AM Walusiku Muyunda > wrote: > >> Hello, >> >> We recently implemented DHIS2 for our data collection needs and are >> currently looking at the first data subm

Re: [Dhis2-users] Get Date Values

join categoryoptioncombo cat ON cat.categoryoptioncomboid = > dv.categoryoptioncomboid > > WHERE ps.iso='201801' AND org.uid='oBI1EjCjKgq' AND de.name='IPD_Death' > > ...... > Regards > > Sele > On Thursday, August 16, 2018, 9

[Dhis2-users] Minimum Analytics Time

Hello, Am back with another question. Is there a reason why the minimum analytics period is capped at Daily which results to 24 hours. Is there a way of reducing to say 5 hours and if there is where else, since settings only has the last option as daily. Kind regards. *Walusiku J. Muyunda* *"

[Dhis2-users] PIVOTS WEEK NUMBERS WRONG

Dear All, I need help understanding why our DHIS2 instance shows the same week number for consecutive weeks when you run pivots? This is making it difficult for users to understand the data. We are still using 2.28. *Walusiku J. Muyunda* *Cell: +260967006614Cell: +260971000614* *Cell: +260953

Re: [Dhis2-users] PIVOTS WEEK NUMBERS WRONG

or > > Ain el Remmaneh, Beirut, Lebanon > > *E-mail:* lib@pu-ami.org > > *Cell:* +961 71 004 881 (208) > > *Skype:* imapuami > > *Website:* https://www.pu-ami.org > > > > > > *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima= > pu-ami

Re: [Dhis2-users] PIVOTS WEEK NUMBERS WRONG

version of 2.28, since bugs like this are getting fixed all the time. > > Regards, > Knut > > On Thu, Sep 6, 2018 at 10:25 AM Walusiku Muyunda > wrote: > >> Exactly the same issue. Thank you for the guide. We just recently >> deployed our very first DHIS2 2.28 and st

Re: [Dhis2-users] PIVOTS WEEK NUMBERS WRONG

d Sadaka* > > *Information Management Advisor* > > Première Urgence - Aide Médicale Internationale > > Nehmeh Building, Sanine Street, Chiyah, 3rd Floor > > Ain el Remmaneh, Beirut, Lebanon > > *E-mail:* lib@pu-ami.org > > *Cell:* +961 71 004 881 (208) &

Re: [Dhis2-users] PIVOTS WEEK NUMBERS WRONG

The last war file on https://www.dhis2.org/downloads was released on 11.10.2017 which is before I downloaded the version we are currently using. Do I just re-download it or there is a different location for the updated war file? Thank you. On Thu, Sep 6, 2018 at 12:05 PM Walusiku Muyunda

[Dhis2-users] Tracker Program Stages order

*Dear All,* *I have a program with about 12 scheduled visits(stages). I have ordered them in the **sequence** they should appear but for some reason they seem to have their own order as they are appearing not according to the ordering I shuffled them to. Is there something I am missing. I used the

[Dhis2-users] View Expression Value Output

If i have an expression like d2:substring(A{client_id_rv}, 0, 2) != 'RV2', is there a way I can view the output which is being compared to my validation string? *Walusiku J. Muyunda* *"We have heaven to win and hell to shun, our lives testify better!" * __

Re: [Dhis2-users] Tracker Program Stages order

tenance app? Can you also submit the deftails of the DHIS2 version you > are testing on? You can get this in the "About DHIS 2" option in the > profile menu. > > Markus > > 11. sep. 2018 kl. 10:03 skrev Walusiku Muyunda : > > *Dear All,* > > *I have a program wit

Re: [Dhis2-users] Tracker Program Stages order

ram stage > the event date of the individual events is used for sorting. I presume that > your events are being generated upon enrollment - can you provide a > screenshot of the jumbled events in the timeline entry? > > 13. sep. 2018 kl. 15:30 skrev Walusiku Muyunda : > > Thank

Re: [Dhis2-users] Tracker Program Stages order

e expected. I am however not able to > reproduce the issue in the 2.28 play server. Have you recently changed the > date format settings for your server? What is your current date format > settings? > > Markus > > 13. sep. 2018 kl. 15:56 skrev Walusiku Muyunda : > >

[Dhis2-users] Tracker Capture Authorities 2.28

Am trying to disallow some user authority to delete records after they have entered them. I cant seem to find which role from the below to remove in order to enforce this. Below are the authorities I currently have assigned to these users: Add/Update Enrollment Add/update Tracked entity instance Re

[Dhis2-users] Sample Query for Tracker Program with stages

Dear All, I have started working on a query to pull data from the first 2 stages of one of the tracker programs. Anyone with a sample query structure with tables of where data is stored. Thank you. *Walusiku J. Muyunda* *Cell: +260967006614Cell: +260971000614* *"We have heaven to win and he

[Dhis2-users] Event Report Download

Dear All, Quick help: When I run an event report table and download it, the column names(Data Elements) change to codes, what could be causing this? Thank you in advance. *Walusiku J. Muyunda* *Cell: +260967006614Cell: +260971000614* *Cell: +260953063387* *"We have heaven to win and hell to

Re: [Dhis2-users] Event Report Download

h Information Systems Program > > Tel: 041-367 1027 > > Cell: 082 374 2209 > > E-mail: elma...@hisp.org > > Skype: elmarie.claasen52 > > > > *From:* Dhis2-users hisp@lists.launchpad.net> *On Behalf Of *Walusiku Muyunda > *Sent:* Fri

[Dhis2-users] Upgrade DHIS 2.28 to 2.30

Yet another quick question: Is it okay to upgrade from version 2.28 directly to 2.30. Are there any problems of doing so? Thank you *Walusiku J. Muyunda* *Cell: +260967006614Cell: +260971000614* *"We have heaven to win and hell to shun, our lives testify better!"

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

> > *Elmarie Claasen* > > [image: Hisp logo] > > Project Manager > > Health Information Systems Program > > Tel: 041-367 1027 > > Cell: 082 374 2209 > > E-mail: elma...@hisp.org > > Skype: elmarie.claasen52 > > > > *From:* Dhis2-

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

*John Snow Research and Training Institute | GOFR Connect - Drupal Dev - > DHIS2* > *PHONE : +224 623 909 413 | +224 662 256 106* > *SKYPE : diaodiallo08* > *www.jsi.com <http://www.jsi.com/>* > > > On Wed, Oct 3, 2018 at 7:59 AM Walusiku Muyunda > wrote: > &g

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

Oct 3, 2018, 14:23 Walusiku Muyunda wrote: > >> When I execute the script in postgresql query window I get a result in >> 1sec with only 1 row affected. That does not seem to be good. The >> documentation next to the download only show what has been moved. >> >> Is there a

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

Looks like the upgrade script run just fine, but is there a way to verify that everything upgraded correctly besides waiting for users to report something thats not working? Thank you. On Wed, Oct 3, 2018 at 3:38 PM Walusiku Muyunda wrote: > Using PostgreSQL query window. What am I suppo

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

is not foolproof, but a good start. > > Cheers > Bob > > On Wed, 3 Oct 2018 at 17:55, Walusiku Muyunda wrote: > >> Looks like the upgrade script run just fine, but is there a way to verify >> that everything upgraded correctly besides waiting for users to report >>

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

3 Oct 2018 at 18:09, Walusiku Muyunda wrote: > >> Thank you Bob for the insight. Am currently trying to upgrade from 2.28 >> to 2.29(since its recommended to for the sequential releases) then later >> when am sure the upgrade was successful, I'll upgrade to 2.30 and I'

[Dhis2-users] Data Synchronization

Dear All, I have read the synchronization documentation and very clear on what to do next, however, the documentation does not specify whether this is a one way sync. I have a live server and a clone server, I only want dhis2 live server to send data to my clone server and not the other way round.

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

shun, our lives testify better!" <http://wildvoices.blogspot.com/>* On Wed, Oct 3, 2018 at 7:15 PM Walusiku Muyunda wrote: > Win Server 2016 > > On Wed, Oct 3, 2018, 19:14 Bob Jolliffe wrote: > >> Upgrading from 2.28 to 2.29 should be smooth enough. At least I ha

[Dhis2-users] Password Expiry Alerts

Hello, I checked the "Enable password expiry alerts" box and users start receiving expiry notifications which do not stop even after they have changed their passwords. I checked for similar issues on Jira but couldn't find any. Is there a work around to avoid this? Even after un-checking the optio

Re: [Dhis2-users] Password Expiry Alerts

; Cell: 082 374 2209 > > E-mail: elma...@hisp.org > > Skype: elmarie.claasen52 > > > > *From:* Dhis2-users hisp@lists.launchpad.net> *On Behalf Of *Walusiku Muyunda > *Sent:* Tuesday, October 9, 2018 8:50 AM > *To:* dhis2-users@lists.launchpad.net > *Subject:* [Dhis

[Dhis2-users] Script to disassociate Orgunit with Datavalue

Dear All, Is there there anyone with a script to disassociate an Orgunit from all associated programs or data sets so I can be able to delete it from within DHIS2? Thank you. *Walusiku J. Muyunda* *Cell: +260967006614Cell: +260971000614* *Cell: +260953063387* *"We have heaven to win and hel

Re: [Dhis2-users] Script to disassociate Orgunit with Datavalue

is on a development database first! > > Best regards, > Jason > > > On Thu, Oct 11, 2018 at 10:49 AM Walusiku Muyunda > wrote: > >> Dear All, >> >> Is there there anyone with a script to disassociate an Orgunit from all >> associated programs or da

Re: [Dhis2-users] Script to disassociate Orgunit with Datavalue

Muyunda* *Cell: +260967006614Cell: +260971000614* *Cell: +260953063387* *"We have heaven to win and hell to shun, our lives testify better!" <http://wildvoices.blogspot.com/>* On Thu, Oct 11, 2018 at 1:10 PM Walusiku Muyunda wrote: > Thank you Jason, this will be very help

Re: [Dhis2-users] Script to disassociate Orgunit with Datavalue

> Just load the script in your database and execute it with > > SELECT * FROM delete_site_with_data('tPR9B5xETb'); > > Regards, > Jason > > On Thu, Oct 11, 2018 at 4:08 PM Walusiku Muyunda > wrote: > >> Hi Jason, >> >> Please

[Dhis2-users] Custom Password Expiry Message

Dear All, Yet another quick question. Is there a way to customize the password expiry message? The DHIS2 default is "Dear Username, Please change your password. It will expire in # days", can this be modified and if yes, where/how? Also is there a way to lock out users with expired passwords? Ill

[Dhis2-users] Future Dates Not Allowed in Tracker Sections

Dear All, I have an issue in one of our Tracker programs where a date field in a section is not allowing future dates. I have ticked the Date is Future option in Section management but still its only allowing today or older dates.. Please help. *Walusiku J. Muyunda* *Cell: +260967006614Cell: +

Re: [Dhis2-users] Future Dates Not Allowed in Tracker Sections

I'll try to recreate the program on play. Server is Win Server 2016 and dhis2 ver2.28 On Wed, Oct 17, 2018, 12:40 Markus Bekken wrote: > Hey there, can you try to reproduce on the play.dhis2.org server? > > Which server are you running on? > > 17. okt. 2018 kl. 12:10 sk

Re: [Dhis2-users] Future Dates Not Allowed in Tracker Sections

ekken wrote: > Hey there, can you try to reproduce on the play.dhis2.org server? > > Which server are you running on? > > 17. okt. 2018 kl. 12:10 skrev Walusiku Muyunda : > > Dear All, > > I have an issue in one of our Tracker programs where a date field in a > sect

[Dhis2-users] ORGANIZATION FLAG

Dear All, Quick question again. Where do I send the request to have our Organization Flag added to the dhis2.war file? Thank you. *Walusiku J. Muyunda* *Cell: +260967006614Cell: +260971000614* *Cell: +260953063387* *"We have heaven to win and hell to shun, our lives testify better!"