Thank you very much Terence and Markus, for your valuable suggestions.
I am not sure whether the first suggestion can be implemented since we have
already migrated 1000's data with these values.
The second suggestion, using the code sounds good for me. Let me check the
design and see what I can
Hey MSP - escaping single quotes is not supported as of now, it would be great
if you create a feature request for it.
As Terence says, there might be workarounds - one suggested below. If "don't
know" is one of the options in an option set, I am guessing that there is a
code for this option
Hi MSP
I am not sure how to rectify the problem directly, but several easy
solutions would be to simply reword the response to: 'Unsure', 'unknown',
'not known' or similar.
Kind regards,
Terence
Terence Scott
Global Alliance for Rabies Control (GARC)
Pan-African Rabies Control Network
Hi all.
Kindly assist me to resolve this issue.
I want to check a single quoted string in a program rule such as "variable
== 'Don't know'". I tried using two single quotes (Don''t know) and escaped
with a backward slash (Don\'t know) but it doesn't work.
Any suggestions? Your help is very much
Glad to hear it!
Terence Scott
Global Alliance for Rabies Control (GARC)
Pan-African Rabies Control Network (PARACON) Steering Committee
terence.sc...@rabiesalliance.org
https://paracon.rabiesalliance.org
Skype: tpscott1987
On Tue, Oct 30, 2018 at 1:03 PM M.Selvaraaj Prabu wrote:
> Thank
Thank you very much Mr.Terence for pointing to the right direction. It
worked.
Thanks and regards
MSP
On Tue, Oct 30, 2018 at 12:39 PM Terence Scott <
terence.sc...@rabiesalliance.org> wrote:
> Dear MSP
>
> I am not sure if you are aware, but see the following documentation for
> the codes
Dear MSP
I am not sure if you are aware, but see the following documentation for the
codes used to create the "current date" in the program rule.
https://docs.dhis2.org/2.30/en/user/html/configure_program_rule.html
Please see *Table 21.14. Standard variables to use in program rule
expressions
Hi all,
I am Selvaraj Muthusamy from PCI, Botswana. We have customised DHIS2 (2.29)
to manage our OVC database. We are using Tracker App to capture the
individual case management.
We have a field (data element) called "Data entered on" and this has to be
the current date and time. I created a
Hi Georgi
We are experiencing the same issues, as we are also working between
multiple countries with data that should not be shared between different
countries. As you mentioned, all of the other permissions restrict other
countries from seeing country-specific data, but the interpretations (and
Hi all,
We are using DHIS2 2.28 and have a small trouble with Interpretations. We have
several parties using DHIS2. All of them have individual reports (pivot tables
and charts) that cannot be seen by the other parties (managed through reports
sharing options).
The report sharing work and we
chpad.net>; DHIS 2 Developers list
<dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] HELP with program indicator/report
Hey again Georgi,
this seems like a bug with the d2:hasValue function. Using enrollment
analytics, the intended outcome for
d2:hasValue(#{programStageWithNo
2017 11:30 AM
To: Georgi Chakarov <geo...@logicaloutcomes.net>
Cc: DHIS Users <dhis2-users@lists.launchpad.net>; DHIS 2 Developers list
<dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] HELP with program indicator/report
Hi there Georgi,
We do not have a function that does
Hi there Georgi,
We do not have a function that does exactly what you asked for, but hopefully
we can find a way if we examine the data elements in your stages. Do the stages
have a data element that is mandatory, or at least so pivotal that you can sue
that data element to determine wether the
Hi there Georgi!
Thanks for the feedback.
It seems you got it almost right except for one little detail on the usage of
the substring function.
To get the fifth character you would have to change your expression to:
d2:substring(A{Client ID}, 5, 6) == '2'
There was an error in the doc, so a
Hi all (again)! :)
I have a challenging task for whoever is interested. I find it quite difficult
working with the functions in program rules expression, especially learning
from the user manual.
I am trying to execute the following rule:
If the fifth character of Client ID (text attribute) is
Dear all,
We have the following use case and your advice would be greatly appreciated.
Our use-case needs to show/hide a previous DE entry based on a current Yes/No
selection. Below are the few requirements that are needed:
1. 1st visit: User enters data.
2. 2nd visit: User enters data.
gi
>>
>>
>>
>> *From:* Knut Staring [mailto:knu...@gmail.com]
>> *Sent:* Monday, June 12, 2017 2:25 PM
>> *To:* Georgi Chakarov <geo...@logicaloutcomes.net>
>> *Cc:* DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>; DHIS
>> Users
>
>
> Georgi
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Monday, June 12, 2017 2:25 PM
> *To:* Georgi Chakarov <geo...@logicaloutcomes.net>
> *Cc:* DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>; DHIS Users
> <dhis2
:25 PM
To: Georgi Chakarov <geo...@logicaloutcomes.net>
Cc: DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>; DHIS Users
<dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] HELP NEEDED: DHIS2 design issue
Thanks for the request Georgi,
How to set up and maintain s
Thanks for the request Georgi,
How to set up and maintain such complex access schemes is still exceedingly
tricky, and I think guidance and probably improved user interfaces to
handle this is one of the key areas that needs strengthening. There should
probably be a task force set up around it -
Hi DHIS 2 community!
We have the following case and your advice will be highly appreciated!
We have a client that works with vulnerable children and vulnerable adults. Our
client has 6 (six) partners that provide a long list of services based on the
needs of the beneficiaries. Among these
;
> *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com]
> *Sent:* 01 December 2016 12:53
>
> *To:* TIMIMI, Hazim Bakir
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Help! What has happened to my data element
> and indicator translations?
>
>
and populate the new tables, or should I just roll my own?
Thanks again!
Hazim
From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 01 December 2016 12:53
To: TIMIMI, Hazim Bakir
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help! What has happened to my data element
on Pickering [mailto:jason.p.picker...@gmail.com]
> *Sent:* 01 December 2016 12:14
> *To:* TIMIMI, Hazim Bakir
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Help! What has happened to my data element
> and indicator translations?
>
>
>
> Hi Ha
]
Mystifying!
Any hints most welcome.
Thanks and best wishes,
Hazim
From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 01 December 2016 12:14
To: TIMIMI, Hazim Bakir
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help! What has happened to my data element
Hi Hazim,
Which version are you running? Depending on the version, the translations
of data elements are no longer in that table.
Does this happen in specific apps or are they not even visible in the
maintenance module when looking at a specific data element?
Regards
Jason
On Thu, Dec 1, 2016
Hi there,
We recently upgraded our DHIS2 server from 2.23 to 2.25. The French
translations we previously had for data elements and indicators no longer
appear if you change language preferences. In the maintenance module clicking
on the translate for those data elements/indicators no longer
Hi All,
We are about to implement DHIS in two level hierarchy one server hosted in
cloud and several other DHIS instances in fields where data is collected
and synced with cloud instance. In this regard, we want to understand on
how each of you are working out with the timezones of server
Hi all
Can anyone please help on this?
I am trying to do design a webportal using this authentification
jQuery(document).ready(function() {
$.post( base + "dhis-web-commons-security/login.action?authOnly=true", {
j_username: "admin", j_password: "district"
}
);
});
I add the
Hi all,
I have an Intel Core i7 Windows 10 64bit computer with 16 Gig of RAM and
can't seem to configure it to run analytics correctly.
I ran analytics just fine on the same computer with the same DHIS-2
instance using 2.21 and postgres 9.4 - it took just over 1 hour to run.
Now it seems to
Hi Norberto,
for that you will need a server which is connected to the internet.
You can read more about server installation here:
https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08.html
You can read more about hosting of DHIS 2 here:
https://www.dhis2.org/hosting
regards,
Lars
Hi guys,
I am new in this group and still learning about dhis2.
I have downloaded and installed Dhis2 and linked it with Postgresql on my
laptop. How can I do to make it available to other users that I have created, I
want them to access the database over the internet.
If anyone can help I
:
[Dhis2-users] Help with DSH2 config. /divdiv
/div
Hi Norberto,
for that you will need a server which is connected to the internet.
You can read more about server installation here:
https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08.html
You can read more about hosting of DHIS 2 here
Hi everyone,
Can somebody PLEASE help me with this error. I am trying to install dhis2.
When I invoked mvn install I got this error
From: norbertoba...@live.com
To: dhis2-users@lists.launchpad.net
Subject: Help with DSH2 config.
Date: Fri, 5 Dec 2014 12:17:15 +0200
Hi
No need to use Maven
On 5 Dec 2014 21:36, Norberto Banze norbertoba...@live.com wrote:
Hi everyone,
Can somebody PLEASE help me with this error. I am trying to install
dhis2. When I invoked mvn install I got this error
--
From: norbertoba...@live.com
To:
How should I proceed
Date: Fri, 5 Dec 2014 21:53:47 +0800
Subject: Re: [Dhis2-users] Help with DSH2 config.
From: knu...@gmail.com
To: norbertoba...@live.com
CC: dhis2-users@lists.launchpad.net
No need to use Maven
On 5 Dec 2014 21:36, Norberto Banze norbertoba...@live.com wrote:
Hi everyone
I am following the steps that come here https://www.dhis2.org/development
From: norbertoba...@live.com
To: knu...@gmail.com
CC: dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Help with DSH2 config.
Date: Fri, 5 Dec 2014 15:56:54 +0200
How should I proceed
Date: Fri, 5 Dec 2014
If you need a server I propose you go with a hosted solution, as described
on our website.
Regards,
Knut
On 5 Dec 2014 21:56, Norberto Banze norbertoba...@live.com wrote:
How should I proceed
--
Date: Fri, 5 Dec 2014 21:53:47 +0800
Subject: Re: [Dhis2-users] Help
:
I am following the steps that come here https://www.dhis2.org/development
--
From: norbertoba...@live.com
To: knu...@gmail.com
CC: dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Help with DSH2 config.
Date: Fri, 5 Dec 2014 15:56:54 +0200
How should I
--
From: norbertoba...@live.com
To: knu...@gmail.com
CC: dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Help with DSH2 config.
Date: Fri, 5 Dec 2014 15:56:54 +0200
How should I proceed
--
Date: Fri, 5 Dec 2014 21:53:47
Could do that, is there a test plan and what is the time frame. I have two
laptops one is running the complete version and would only connect through
the browser to the installed DHIS2 on one laptop.
Yes I could do that, just let me know exactly what areas to look for.
On Thu, Sep 12, 2013 at
Thanks! The basics are most important : you get it to run and it works
with H2 (ie out of the box). I assume that means it will also work with
Postgres.
Den 12. sep. 2013 13:27 skrev Tony Iha tony...@gmail.com følgende:
Could do that, is there a test plan and what is the time frame. I have
Hi all,
I have a problem a problem in terms of rule validation.
I defined the validation rule, but I noticed that she is well respected
when introducing 0 or another value in various input fields. But when the
input fields are empty, the execution of the validation is done with
success, whatever
Hi,
you can choose whether all data elements in the expression is required to have
a value or not for the validation rule to be effective, using the skip for
missing values property in the expression editor. If skip is true, then it
requires all data elements to have values. If false, only one
Hi all,
1) I need to pair with the mobile application DHIS2 Open Data Kit (ODK) ...
What to do??
2) I need to customize DHIS2 using Web API ... Who can help me find a good
resource that talks about??
--
Riddy NDOMA
Software Developer
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
On Wed, Apr 10, 2013 at 5:18 PM, riddy ndoma riddynd...@gmail.com wrote:
2) I need to customize DHIS2 using Web API ... Who can help me find a
good resource that talks about??
Sorry, I can't help you with pt 1, but the documentation for our Web API is
located at:
There has been no translation of the user guide into French yet. The system
itself has been recently translated completely into French, but the
documentation itself has yet to be translated. English and Spanish are
available however.
Best regards,
Jason
On Tue, Apr 2, 2013 at 11:30 AM, riddy
The Google translated version might be helpful:
http://translate.google.no/translate?sl=entl=frjs=nprev=_thl=noie=UTF-8eotf=1u=http%3A%2F%2Fdhis2.org%2Fdoc%2Fsnapshot%2Fen%2Fuser%2Fhtml%2Fdhis2_user_manual_en.html
On Tue, Apr 2, 2013 at 2:38 PM, Jason Pickering jason.p.picker...@gmail.com
Dear all,
I want to display the following charts on the frontpage:
1. how many clinics have accounts in DHIS2
2. how many reports DHIS2 has received from the clinics (reporting rate?)
Can someone teach us how? Thanks...
___
Mailing list:
You can probably use the Web-API and connect to an external portal (drupal
etc)
http://data.hiskenya.org/ - is a good example of that. Another one is -
https://dhis2vn.org/
1. you can use the http://apps.dhis2.org/dev/api/users.json and look at the
pager-total
But this is all the users registered
hi guys
i have managed to import the dhis2 source code in eclipse.
but i can only see java files within eclipse.i cant see the view(.vm files).
how can i run the project from within eclipse using tomcat as my
application server?
thanks in advance
--
Regards
David Nyaika
Software
Hi
The general instructions for building the source code is (and you need to
do this before trying to import into Eclipse):
mvn clean install -DskipTests=true in dhis-2 directory
mvn clean install -DskipTests=true in dhis-web directory
These two commands will make sure that all local
Have you run the datamart?
Den 8. feb. 2013 17:18 skrev Nyaika David davie2...@gmail.com følgende:
Hi guys
i have data captured for my the following datasets as shown
in the image attached but am getting the error below
please ensure that there is data stored in the database and that
data
Have you run the datamart?
Den 8. feb. 2013 17:18 skrev Nyaika David davie2...@gmail.com følgende:
Hi guys
i have data captured for my the following datasets as shown
in the image attached but am getting the error below
please ensure that there is data stored in the database and that
data mart
no i have not yet
On Fri, Feb 8, 2013 at 7:56 PM, Knut Staring knu...@gmail.com wrote:
Have you run the datamart?
Den 8. feb. 2013 17:18 skrev Nyaika David davie2...@gmail.com
følgende:
Hi guys
i have data captured for my the following datasets as shown
in the image attached but am
Hi David,
For custom sql based reports have a look at section 13.4.3 in the user doc:
http://www.dhis2.org/doc/snapshot/en/user/html/ch13s04.html
You can only run DHIS 2 with one unerlying database, the one you specify in
hibernate.properties. But you can then create custom sql against any
Hi Guys
In the dhis-live/conf/hibernate.properties directory, i see there are
settings for connecting to postgres database. can i be able to access the
postgres database entities within DHIS2 for use in report generation
Thanks in advance for your help :)
--
Regards
David Nyaika
Software
Hi guys
am new to DHIS2, i would like to know if DHIS2 can be used hand in h
and with postgres database to generate reports.i would also like to know
if i can acces the reports from my JEE application
thanks for your help in advance :)
--
Regards
David Nyaika
Software Developer(SCJP,SCWCD
Hi David,
DHIS isn't really a pluggable software development library, rather a data
management, capture and analysis system. So you would have to give DHIS
access to your data repository in some way.
It is written entirely in Java, builds with Maven, and has a Web API, so it
should be possible
Hi Randy,
let me see if I get you correctly: The problem is mainly that you cannot
drop your sql views in an arbitrary order since they depend on each
other? Also, your views do not depend on any dhis resource table, and you
completely maintain your views through the cron job.
Assuming this,
Yes, in this context, a materialized view is simply a table which is
produced from an SQL view. The advantage of course is that materialized
views can be indexed, etc and are normally much faster to serve than
dynamic SQL views.
The one thing I did not mention, is the refreshment of the
On Fri, Dec 21, 2012 at 5:47 AM, Jason Pickering
jason.p.picker...@gmail.com wrote:
Yes, in this context, a materialized view is simply a table which is
produced from an SQL view. The advantage of course is that materialized
views can be indexed, etc and are normally much faster to serve than
-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help creating links to download materialized views
Okay. So with materialized view you are referring to a plain db table, right? I
thought you meant creating a view with sql something like create materialized
view but I can see that has not been
, 2012 2:53 PM
*To:* Robert G. Mesleh Jr.
*Cc:* dhis2-users@lists.launchpad.net
*Subject:* Re: [Dhis2-users] Help
** **
Hi Andrew,
I am not sure which version you are using now (2.5 or 2.6?) but you may
want to try this directly on the database
** **
** **
ALTER TABLE
: [Dhis2-users] Help
Hi Andrew,
I am not sure which version you are using now (2.5 or 2.6?) but you may want
to try this directly on the database
ALTER TABLE chart ADD COLUMN targetline boolean NOT NULL DEFAULT false:
ALTER TABLE chart ADD COLUMN hidesubtitle boolean NOT NULL DEFAULT false
Hi,
I am presently working on a new HMIS project in Ethiopia and require some
advice. We recently (2 months ago)installed a DHIS online system using MySQL
and wish to migrate to PostgreSQL,
without losing information on the table structure or data which have just been
entered. How can this
. The data has
been collected for only two months and can easily be re-entered.
Date: Thu, 19 Jan 2012 17:44:38 +0200
Subject: Re: [Dhis2-users] Help Please! Migration from MySQL to PostgreSQL
From: jason.p.picker...@gmail.com
To: felixkay...@hotmail.com
CC: dhis2-users@lists.launchpad.net
Hi
Thanks Jason. I will try this out and provide a feedback to the list
Date: Thu, 19 Jan 2012 18:47:50 +0200
Subject: Re: [Dhis2-users] Help Please! Migration from MySQL to PostgreSQL
From: jason.p.picker...@gmail.com
To: felixkay...@hotmail.com
CC: dhis2-users@lists.launchpad.net
You
Hi All,
I am trying to use the DHIS2 Pivot Tables and encountering some challenges.
The challenge lies with the End-Product i.e. the Excel sheet produced once
I follow the * select Data Pivot Download to Excel* process. While
I successfully select my pivoting parameters and the table produced
Hi Beatrice,
Nice to hear from you again. :)
The better solution would be to use the MyDatamart tool described here
http://dhis2.org/doc/snapshot/en/user/html/apb.html
This tool will provide you with a normal pivot table, which can be
manipulated as per normal by users.
Best regards,
Jason
Hi Beatrice,
I think you might have selected too much data for download. If you are
downloading data for the Kenya orgunit you should not select facility as
the analysis level, it will be way too much to download. Try to use
district or county level instead. Or if you need facility level, first
Hi Zayd,
There is no automatic way to upload an Excel table containing codes into
DHIS2. The simplest way would (I think in your case) be to transform the
Excel sheet to a series of update statements, and then execute this
directly in the DHIS2 database. You can probably use the code field of
Hi,
I get an error when I try to export datamart. I use dhis2 built 5362. Log
is in attached.
thx,
Aymar
* INFO 12:11:01,574 Populated crosstab table: 0:15:38.576 (Clock.java
[Thread-17])
* INFO 12:11:01,589 Created aggregated data cache: 0:15:38.591 (Clock.java
[Thread-17])
* WARN
@lists.launchpad.net; Ocaya Stephen
stepho...@gmail.com
*Subject: *Re: [Dhis2-users] Help Required
Have you properly configured postgres to enable tcp/ip connections from
localhost?
You should not run tomcat with root. If you are using another user to
start tomcat, this user may not be able to read
Oct 2011 05:57:08 +0200
*To: *Ola Hodne Titlestadol...@ifi.uio.no
*Cc: *dhis2-users@lists.launchpad.net; Ocaya Stephen
stepho...@gmail.com
*Subject: *Re: [Dhis2-users] Help Required
Have you properly configured postgres to enable tcp/ip connections from
localhost?
You should not run tomcat
.
From: Jason Pickering jason.p.picker...@gmail.com
Date: Fri, 28 Oct 2011 05:57:08 +0200
To: Ola Hodne Titlestadol...@ifi.uio.no
Cc: dhis2-users@lists.launchpad.net; Ocaya
Stephenstepho...@gmail.com
Subject: Re: [Dhis2-users] Help Required
Have you properly configured
Not trying to confuse people here. But if a reverse proxy is only
what's needed i can recommend using nginx over apache - its
specifically designed to act as one and a lot more light-weight / less
resource intensive than apache. On debian / ubuntu Install with
sudo apt-get install nginx
and then
Caveman, we don't recommend windows for servers.
Regards, Knut (via mobile phone)
On Oct 28, 2011 7:35 PM, Orvalho Augusto orvaq...@gmail.com wrote:
Indeed is ngix is better for reverse proxy and a lot of more people start
to use it. But I think there is not native ngix for windows so apache
Good! Thanks
Caveman
On Fri, Oct 28, 2011 at 7:40 PM, Knut Staring knu...@gmail.com wrote:
Caveman, we don't recommend windows for servers.
Regards, Knut (via mobile phone)
On Oct 28, 2011 7:35 PM, Orvalho Augusto orvaq...@gmail.com wrote:
Indeed is ngix is better for reverse proxy and a
Hullo All,
I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
Outlined on the website (dhis2.org) and the application seems not to be
picking the database connection setting in hibernate.properties.
On Logging, I See the following Message:
The database is currently running
/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether
dhis found your hibernate.properties file or not, and tell you if the
DHIS2_HOME was recognised or not.
Ola
--
--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of
Have you properly configured postgres to enable tcp/ip connections from
localhost?
You should not run tomcat with root. If you are using another user to start
tomcat, this user may not be able to read anything from /home/root.
As knut and ola say however, the log will provide you with the
...@gmail.com
Subject: Re: [Dhis2-users] Help Required
Have you properly configured postgres to enable tcp/ip connections from
localhost?
You should not run tomcat with root. If you are using another user to start
tomcat, this user may not be able to read anything from /home/root.
As knut and ola
Thanks for the quick help,
i have successfully used the select and delete steps(in datavalues and
datavalue_audit) but using replace id is not working on my side may be am not
using it well? please update me again (only replace syntax). i have deleted
data from my data element x and next step
84 matches
Mail list logo