Re: [Dhis2-devs] [Dhis2-users] DHIS2 users list from SQL View

2017-04-11 Thread Harivola RANDRIANJAFY
Tantely,



Below the SQL View :



SELECT

"public".users.username,

"public".userinfo.surname,

"public".userinfo.firstname,

"public".userinfo.email,

"public".userinfo.phonenumber,

"public".users.lastlogin,

"public".users.created,

"public".users.disabled,

"public".userrole."name",

"public".users.uid

FROM

"public".users

INNER JOIN "public".userinfo ON "public".users.userid = 
"public".userinfo.userinfoid

INNER JOIN "public".userrole ON "public".userrole.userid = 
"public".userinfo.userinfoid





Thanks,

Harivola



De : Dhis2-users 
[mailto:dhis2-users-bounces+harivolar=psi...@lists.launchpad.net] De la part de 
Raminosoa Rabemanantsoa, Tantely
Envoyé : lundi 10 avril 2017 17:19
À : DHIS 2 Users list ; DHIS 2 Developers list 

Objet : [Dhis2-users] DHIS2 users list from SQL View



Dear Community,



I would like to output from SQL View a list of all DHIS2 users by using headers 
like the information listed by the users details information, like illustrated 
by the image below (inside red ellipse).




​



I am using DHIS2 2.24. I would like to check the users table fields but I could 
not output any information from the following query



select * from users;



as trhere are some protected info.



My question is in which fields should I base the SQL query to output such 
information?



Thank you for your support,



Regards,



Tantely

​








This message and its attachments are confidential and solely for the intended 
recipients. If received in error, please delete them and notify the sender via 
reply e-mail immediately.



---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released

2015-10-27 Thread Harivola RANDRIANJAFY
Please find attached the actually catalina.out log file.



This gives the white screen webpage



Harivola



De : Morten Olav Hansen [mailto:morte...@gmail.com]
Envoyé : mardi 27 octobre 2015 11:22
À : Harivola RANDRIANJAFY <harivo...@psi.mg <mailto:harivo...@psi.mg> >
Cc : Shurajit Dutta <shurajitdu...@gmail.com <mailto:shurajitdu...@gmail.com> 
>; DHIS 2 Users list <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; dhis2-devs 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >; Lars 
Helge Øverland <larshe...@gmail.com <mailto:larshe...@gmail.com> >
Objet : Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released



Ok, thats great.



There must be something in catalina.out that gives you a hint? probably 
something happen during our startup routines that make dhis not start up (seems 
very likely since it works on a new database)




--
Morten



On Tue, Oct 27, 2015 at 4:08 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Hi Morten,



Java – version gives

java version "1.8.0_66"

Java(TM) SE Runtime Environment (build 1.8.0_66-b17)

Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode)



And java 8 is the active jre

After restarting server and creating a new database in postgres, it WORKS 
PERFECTLY J but the old database (backup from 2.20) could not be restored and 
could not accessed with 2.21 through pg_restore - or working with the old 
database (2.20),  it gives white webpage.



Your suggestions ?



Harivola



De : Morten Olav Hansen [mailto:morte...@gmail.com <mailto:morte...@gmail.com> ]
Envoyé : lundi 26 octobre 2015 16:33
À : Harivola RANDRIANJAFY <harivo...@psi.mg <mailto:harivo...@psi.mg> >
Cc : Shurajit Dutta <shurajitdu...@gmail.com <mailto:shurajitdu...@gmail.com> 
>; DHIS 2 Users list <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; dhis2-devs 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >; Lars 
Helge Øverland <larshe...@gmail.com <mailto:larshe...@gmail.com> >
Objet : Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released



Hi



There is nothing too useful in that log. Please make sure that you also 
restartet your server (it can be required sometimes), and make sure to properly 
clean out you webapps directory.



Also, please do java -version and verify that you have java 8 as the active jre




--
Morten



On Mon, Oct 26, 2015 at 9:21 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Please find attached the catalina log file after starting tomcat in 2.21 
version.



Harivola







De : Harivola RANDRIANJAFY [mailto:harivo...@psi.mg <mailto:harivo...@psi.mg> ]
Envoyé : lundi 26 octobre 2015 15:36
À : 'Shurajit Dutta' <shurajitdu...@gmail.com <mailto:shurajitdu...@gmail.com> >
Cc : 'Lars Helge Øverland' <larshe...@gmail.com <mailto:larshe...@gmail.com> >; 
'DHIS 2 Users list' <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; 'dhis2-devs' 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >
Objet : RE: [Dhis2-users] dhis version 2.21 is released



Hi Nick



Yes, I am using both, java 8 version is 1.8.0_60 and tomcat 7



Harivola



De : Shurajit Dutta [ <mailto:shurajitdu...@gmail.com> 
mailto:shurajitdu...@gmail.com]
Envoyé : lundi 26 octobre 2015 12:18
À : Harivola RANDRIANJAFY < <mailto:harivo...@psi.mg> harivo...@psi.mg>
Cc : Lars Helge Øverland < <mailto:larshe...@gmail.com> larshe...@gmail.com>; 
DHIS 2 Users list < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; dhis2-devs < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Objet : Re: [Dhis2-users] dhis version 2.21 is released



Hi Harivola,



When using 2.21 are you also using java 8 and tomcat 7?



Nick



On Mon, Oct 26, 2015 at 4:55 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Hi Lars,



Thank you for this great work, I am using now 2.20 (build 19960) in test 
server. Upgrading this into 2.21, I am facing with blank screen (no login 
action). Downgrading into 2.20, the tracked entity instance in Individual 
records could not be accessed -  likewise in Tracker Capture, all tracked 
entity already registered could not be accessed in dashboard Tracker.



Please, could you help on this ?



Sincerely,



Harivola



De : Dhis2-users 
[mailto:dhis2-users-bounces+harivolar=psi...@lists.launchpad.net] De la part de 
Lars Helge Øverland
Envoyé : mercredi 21 octobre 2015 23:03
À : DHIS 2 Users list <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; DHIS 2 Developers li

Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released

2015-10-27 Thread Harivola RANDRIANJAFY
Hi Morten,



Java – version gives

java version "1.8.0_66"

Java(TM) SE Runtime Environment (build 1.8.0_66-b17)

Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode)



And java 8 is the active jre

After restarting server and creating a new database in postgres, it WORKS 
PERFECTLY J but the old database (backup from 2.20) could not be restored and 
could not accessed with 2.21 through pg_restore - or working with the old 
database (2.20),  it gives white webpage.



Your suggestions ?



Harivola



De : Morten Olav Hansen [mailto:morte...@gmail.com]
Envoyé : lundi 26 octobre 2015 16:33
À : Harivola RANDRIANJAFY <harivo...@psi.mg>
Cc : Shurajit Dutta <shurajitdu...@gmail.com>; DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net>; dhis2-devs <dhis2-devs@lists.launchpad.net>; 
Lars Helge Øverland <larshe...@gmail.com>
Objet : Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released



Hi



There is nothing too useful in that log. Please make sure that you also 
restartet your server (it can be required sometimes), and make sure to properly 
clean out you webapps directory.



Also, please do java -version and verify that you have java 8 as the active jre




--
Morten



On Mon, Oct 26, 2015 at 9:21 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Please find attached the catalina log file after starting tomcat in 2.21 
version.



Harivola







De : Harivola RANDRIANJAFY [mailto:harivo...@psi.mg <mailto:harivo...@psi.mg> ]
Envoyé : lundi 26 octobre 2015 15:36
À : 'Shurajit Dutta' <shurajitdu...@gmail.com <mailto:shurajitdu...@gmail.com> >
Cc : 'Lars Helge Øverland' <larshe...@gmail.com <mailto:larshe...@gmail.com> >; 
'DHIS 2 Users list' <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; 'dhis2-devs' 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >
Objet : RE: [Dhis2-users] dhis version 2.21 is released



Hi Nick



Yes, I am using both, java 8 version is 1.8.0_60 and tomcat 7



Harivola



De : Shurajit Dutta [ <mailto:shurajitdu...@gmail.com> 
mailto:shurajitdu...@gmail.com]
Envoyé : lundi 26 octobre 2015 12:18
À : Harivola RANDRIANJAFY < <mailto:harivo...@psi.mg> harivo...@psi.mg>
Cc : Lars Helge Øverland < <mailto:larshe...@gmail.com> larshe...@gmail.com>; 
DHIS 2 Users list < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; dhis2-devs < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Objet : Re: [Dhis2-users] dhis version 2.21 is released



Hi Harivola,



When using 2.21 are you also using java 8 and tomcat 7?



Nick



On Mon, Oct 26, 2015 at 4:55 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Hi Lars,



Thank you for this great work, I am using now 2.20 (build 19960) in test 
server. Upgrading this into 2.21, I am facing with blank screen (no login 
action). Downgrading into 2.20, the tracked entity instance in Individual 
records could not be accessed -  likewise in Tracker Capture, all tracked 
entity already registered could not be accessed in dashboard Tracker.



Please, could you help on this ?



Sincerely,



Harivola



De : Dhis2-users 
[mailto:dhis2-users-bounces+harivolar=psi...@lists.launchpad.net] De la part de 
Lars Helge Øverland
Envoyé : mercredi 21 octobre 2015 23:03
À : DHIS 2 Users list <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >
Objet : [Dhis2-users] dhis version 2.21 is released



Hi all,



DHIS version 2.21 is out with a lot of great new features and improvements.



Log in with admin/district on the  <http://play.dhis2.org/demo/> demo system.



File cloud storage: You can now upload and store large files directly from data 
entry forms. Data elements can have a file value type and render as file upload 
widgets in forms. Files can be stored either on the Web server or sent directly 
to  <https://aws.amazon.com/s3/> AWS S3 cloud storage, which in practice 
provides unlimited storage capacity. This capability allows you to use DHIS 2 
as a general document repository which can be utilized for project management, 
documentation, CMS and many other purposes.



File storage currently works for aggregate data entry forms - tracker coming 
up. Have a look at the “Project management” data set in data entry on the demo:



 <http://play.dhis2.org/demo/dhis-web-dataentry/index.action> Demo |  
<https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s03.html#d5e517> 
Docs |  <https://www.dhis2.org/images/221/file-store.png> Screenshot



Settings app: The settings front-end has been re-written as a true app. It 
features real-ti

Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released

2015-10-27 Thread Harivola RANDRIANJAFY
Morten,



Great, all works perfectly with 2.21 after reinstalling to latest tomcat7 J



BIG THANKS,



Harivola



De : Morten Olav Hansen [mailto:morte...@gmail.com]
Envoyé : mardi 27 octobre 2015 11:59
À : Harivola RANDRIANJAFY <harivo...@psi.mg>
Cc : Shurajit Dutta <shurajitdu...@gmail.com>; DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net>; dhis2-devs <dhis2-devs@lists.launchpad.net>; 
Lars Helge Øverland <larshe...@gmail.com>
Objet : Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released



You sure you are running this with the same tomcat? (as when you tried with 
empty database)



GRAVE: Unable to process Jar entry 
[jdk/nashorn/internal/objects/NativeSyntaxError$Prototype.class] from Jar 
[jar:file:/usr/lib/jvm/java-8-oracle/jre/lib/ext/nashorn.jar!/] for annotations

org.apache.tomcat.util.bcel.classfile.ClassFormatException: Invalid byte tag in 
constant pool: 15



http://stackoverflow.com/questions/23484098/invalid-byte-tag-in-constant-pool-tomcat7-war-jdk-incompatibilty



Try and upgrade to the latest tomcat 7 (or tomcat 8) and see if it works for 
you, not sure why you wouldn't see this with an empty database though..






--
Morten



On Tue, Oct 27, 2015 at 4:49 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Please find attached the actually catalina.out log file.



This gives the white screen webpage



Harivola



De : Morten Olav Hansen [mailto:morte...@gmail.com <mailto:morte...@gmail.com> ]
Envoyé : mardi 27 octobre 2015 11:22


À : Harivola RANDRIANJAFY <harivo...@psi.mg <mailto:harivo...@psi.mg> >
Cc : Shurajit Dutta <shurajitdu...@gmail.com <mailto:shurajitdu...@gmail.com> 
>; DHIS 2 Users list <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; dhis2-devs 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >; Lars 
Helge Øverland <larshe...@gmail.com <mailto:larshe...@gmail.com> >
Objet : Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released



Ok, thats great.



There must be something in catalina.out that gives you a hint? probably 
something happen during our startup routines that make dhis not start up (seems 
very likely since it works on a new database)




--
Morten



On Tue, Oct 27, 2015 at 4:08 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Hi Morten,



Java – version gives

java version "1.8.0_66"

Java(TM) SE Runtime Environment (build 1.8.0_66-b17)

Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode)



And java 8 is the active jre

After restarting server and creating a new database in postgres, it WORKS 
PERFECTLY J but the old database (backup from 2.20) could not be restored and 
could not accessed with 2.21 through pg_restore - or working with the old 
database (2.20),  it gives white webpage.



Your suggestions ?



Harivola



De : Morten Olav Hansen [mailto:morte...@gmail.com <mailto:morte...@gmail.com> ]
Envoyé : lundi 26 octobre 2015 16:33
À : Harivola RANDRIANJAFY <harivo...@psi.mg <mailto:harivo...@psi.mg> >
Cc : Shurajit Dutta <shurajitdu...@gmail.com <mailto:shurajitdu...@gmail.com> 
>; DHIS 2 Users list <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; dhis2-devs 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >; Lars 
Helge Øverland <larshe...@gmail.com <mailto:larshe...@gmail.com> >
Objet : Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released



Hi



There is nothing too useful in that log. Please make sure that you also 
restartet your server (it can be required sometimes), and make sure to properly 
clean out you webapps directory.



Also, please do java -version and verify that you have java 8 as the active jre




--
Morten



On Mon, Oct 26, 2015 at 9:21 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Please find attached the catalina log file after starting tomcat in 2.21 
version.



Harivola







De : Harivola RANDRIANJAFY [mailto:harivo...@psi.mg <mailto:harivo...@psi.mg> ]
Envoyé : lundi 26 octobre 2015 15:36
À : 'Shurajit Dutta' <shurajitdu...@gmail.com <mailto:shurajitdu...@gmail.com> >
Cc : 'Lars Helge Øverland' <larshe...@gmail.com <mailto:larshe...@gmail.com> >; 
'DHIS 2 Users list' <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; 'dhis2-devs' 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >
Objet : RE: [Dhis2-users] dhis version 2.21 is released



Hi Nick



Yes, I am using both, java 8 version is 1.8.0_60 and tomcat 7



Harivola



De : Shurajit Dutta [ <mailto:shurajitdu...@gmail.com> 
mailto:shurajitdu...@gmail.com]
Envoyé : lundi 26 octobre 2015 12:18
À : Harivol

Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released

2015-10-26 Thread Harivola RANDRIANJAFY
Hi Lars,



Thank you for this great work, I am using now 2.20 (build 19960) in test 
server. Upgrading this into 2.21, I am facing with blank screen (no login 
action). Downgrading into 2.20, the tracked entity instance in Individual 
records could not be accessed -  likewise in Tracker Capture, all tracked 
entity already registered could not be accessed in dashboard Tracker.



Please, could you help on this ?



Sincerely,



Harivola



De : Dhis2-users 
[mailto:dhis2-users-bounces+harivolar=psi...@lists.launchpad.net] De la part de 
Lars Helge Øverland
Envoyé : mercredi 21 octobre 2015 23:03
À : DHIS 2 Users list  >; DHIS 2 Developers list 
 >
Objet : [Dhis2-users] dhis version 2.21 is released



Hi all,



DHIS version 2.21 is out with a lot of great new features and improvements.



Log in with admin/district on the   demo system.



File cloud storage: You can now upload and store large files directly from data 
entry forms. Data elements can have a file value type and render as file upload 
widgets in forms. Files can be stored either on the Web server or sent directly 
to   AWS S3 cloud storage, which in practice 
provides unlimited storage capacity. This capability allows you to use DHIS 2 
as a general document repository which can be utilized for project management, 
documentation, CMS and many other purposes.



File storage currently works for aggregate data entry forms - tracker coming 
up. Have a look at the “Project management” data set in data entry on the demo:



  Demo |  
 
Docs |   Screenshot



Settings app: The settings front-end has been re-written as a true app. It 
features real-time saving, search for settings and a fresh new look.



  Demo |  
 Docs |  
 Screenshot



Data import constraints: Several optional constraints for data import can be 
enabled to provide stricter control of the data being imported. These include 
require period to be of same type as data set, data element to be assigned to 
data set through org units, and more. The import constraints can be enabled in 
settings app under “data import”.



  Docs



ANALYTICS FEATURES

---



Functions and variables in program indicators: Program indicators support a 
range of functions and variables. Functions allows for conditional statements, 
calculation of number of days between dates and more. Variables allows you to 
insert e.g. event date, enrollment date and value count into expressions. This 
is useful for example to calculate “inpatient bed days” and complex scores.



  Docs |  
 Demo 1 |  
 2 |  
 Screenshot 1 
|   2 | 
  3 |  
 4 |



Custom aggregation types: A program indicator now has an aggregation type 
property with the standard options such as sum, avg, count, std dev min, max. 
When set to custom, the indicator expression can contain inline aggregation 
types, allowing for greater control over aggregation.



  Docs |  

 Screenshot



Program indicators and data elements in GIS: The GIS app lets you analyse 
program indicators, attributes and data elements on maps.



  Demo | 
  Screenshot 1 |  
 2



Program indicators in event reports: The individual event overview supports 
program indicators, which allows you to display calculations per event directly 
in the overview.



  
Demo |  
 
Screenshot



Download data dump: Pivot table lets you download data in CSV format directly 
without first rendering the data in the Web 

Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released

2015-10-26 Thread Harivola RANDRIANJAFY
Hi Nick



Yes, I am using both, java 8 version is 1.8.0_60 and tomcat 7



Harivola



De : Shurajit Dutta [mailto:shurajitdu...@gmail.com]
Envoyé : lundi 26 octobre 2015 12:18
À : Harivola RANDRIANJAFY <harivo...@psi.mg>
Cc : Lars Helge Øverland <larshe...@gmail.com>; DHIS 2 Users list 
<dhis2-us...@lists.launchpad.net>; dhis2-devs <dhis2-devs@lists.launchpad.net>
Objet : Re: [Dhis2-users] dhis version 2.21 is released



Hi Harivola,



When using 2.21 are you also using java 8 and tomcat 7?



Nick



On Mon, Oct 26, 2015 at 4:55 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Hi Lars,



Thank you for this great work, I am using now 2.20 (build 19960) in test 
server. Upgrading this into 2.21, I am facing with blank screen (no login 
action). Downgrading into 2.20, the tracked entity instance in Individual 
records could not be accessed -  likewise in Tracker Capture, all tracked 
entity already registered could not be accessed in dashboard Tracker.



Please, could you help on this ?



Sincerely,



Harivola



De : Dhis2-users 
[mailto:dhis2-users-bounces+harivolar=psi...@lists.launchpad.net] De la part de 
Lars Helge Øverland
Envoyé : mercredi 21 octobre 2015 23:03
À : DHIS 2 Users list <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >
Objet : [Dhis2-users] dhis version 2.21 is released



Hi all,



DHIS version 2.21 is out with a lot of great new features and improvements.



Log in with admin/district on the  <http://play.dhis2.org/demo/> demo system.



File cloud storage: You can now upload and store large files directly from data 
entry forms. Data elements can have a file value type and render as file upload 
widgets in forms. Files can be stored either on the Web server or sent directly 
to  <https://aws.amazon.com/s3/> AWS S3 cloud storage, which in practice 
provides unlimited storage capacity. This capability allows you to use DHIS 2 
as a general document repository which can be utilized for project management, 
documentation, CMS and many other purposes.



File storage currently works for aggregate data entry forms - tracker coming 
up. Have a look at the “Project management” data set in data entry on the demo:



 <http://play.dhis2.org/demo/dhis-web-dataentry/index.action> Demo |  
<https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s03.html#d5e517> 
Docs |  <https://www.dhis2.org/images/221/file-store.png> Screenshot



Settings app: The settings front-end has been re-written as a true app. It 
features real-time saving, search for settings and a fresh new look.



 <http://play.dhis2.org/demo/dhis-web-settings/index.html> Demo |  
<https://www.dhis2.org/doc/snapshot/en/user/html/ch23.html> Docs |  
<https://www.dhis2.org/images/221/settings.png> Screenshot



Data import constraints: Several optional constraints for data import can be 
enabled to provide stricter control of the data being imported. These include 
require period to be of same type as data set, data element to be assigned to 
data set through org units, and more. The import constraints can be enabled in 
settings app under “data import”.



 <https://www.dhis2.org/doc/snapshot/en/user/html/ch23.html#d5e4456> Docs



ANALYTICS FEATURES

---



Functions and variables in program indicators: Program indicators support a 
range of functions and variables. Functions allows for conditional statements, 
calculation of number of days between dates and more. Variables allows you to 
insert e.g. event date, enrollment date and value count into expressions. This 
is useful for example to calculate “inpatient bed days” and complex scores.



 <https://www.dhis2.org/doc/snapshot/en/user/html/ch30s03.html> Docs |  
<http://play.dhis2.org/demo/dhis-web-pivot/index.html?id=c9qrFDGxy8o> Demo 1 |  
<http://play.dhis2.org/demo/dhis-web-pivot/index.html?id=T7Nx1tEqG2f> 2 |  
<https://www.dhis2.org/images/221/program-indicator-condition.png> Screenshot 1 
|  <https://www.dhis2.org/images/221/pivot-program-indicator-condition.png> 2 | 
 <https://www.dhis2.org/images/221/program-indicator-daysbetween.png> 3 |  
<https://www.dhis2.org/images/221/pivot-program-indicator-daysbetween.png> 4 |



Custom aggregation types: A program indicator now has an aggregation type 
property with the standard options such as sum, avg, count, std dev min, max. 
When set to custom, the indicator expression can contain inline aggregation 
types, allowing for greater control over aggregation.



 <https://www.dhis2.org/doc/snapshot/en/user/html/ch30s03.html> Docs |  
<https://www.dhis2.org/images/221/program-indicator-custom-aggregation-type.png>
 Screenshot



Program indicators and data elements in GIS: The GIS app lets you an

Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released

2015-10-26 Thread Harivola RANDRIANJAFY
Please find attached the catalina log file after starting tomcat in 2.21 
version.



Harivola







De : Harivola RANDRIANJAFY [mailto:harivo...@psi.mg]
Envoyé : lundi 26 octobre 2015 15:36
À : 'Shurajit Dutta' <shurajitdu...@gmail.com>
Cc : 'Lars Helge Øverland' <larshe...@gmail.com>; 'DHIS 2 Users list' 
<dhis2-us...@lists.launchpad.net>; 'dhis2-devs' <dhis2-devs@lists.launchpad.net>
Objet : RE: [Dhis2-users] dhis version 2.21 is released



Hi Nick



Yes, I am using both, java 8 version is 1.8.0_60 and tomcat 7



Harivola



De : Shurajit Dutta [ <mailto:shurajitdu...@gmail.com> 
mailto:shurajitdu...@gmail.com]
Envoyé : lundi 26 octobre 2015 12:18
À : Harivola RANDRIANJAFY < <mailto:harivo...@psi.mg> harivo...@psi.mg>
Cc : Lars Helge Øverland < <mailto:larshe...@gmail.com> larshe...@gmail.com>; 
DHIS 2 Users list < <mailto:dhis2-us...@lists.launchpad.net> 
dhis2-us...@lists.launchpad.net>; dhis2-devs < 
<mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net>
Objet : Re: [Dhis2-users] dhis version 2.21 is released



Hi Harivola,



When using 2.21 are you also using java 8 and tomcat 7?



Nick



On Mon, Oct 26, 2015 at 4:55 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Hi Lars,



Thank you for this great work, I am using now 2.20 (build 19960) in test 
server. Upgrading this into 2.21, I am facing with blank screen (no login 
action). Downgrading into 2.20, the tracked entity instance in Individual 
records could not be accessed -  likewise in Tracker Capture, all tracked 
entity already registered could not be accessed in dashboard Tracker.



Please, could you help on this ?



Sincerely,



Harivola



De : Dhis2-users 
[mailto:dhis2-users-bounces+harivolar=psi...@lists.launchpad.net] De la part de 
Lars Helge Øverland
Envoyé : mercredi 21 octobre 2015 23:03
À : DHIS 2 Users list <dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net> >; DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> >
Objet : [Dhis2-users] dhis version 2.21 is released



Hi all,



DHIS version 2.21 is out with a lot of great new features and improvements.



Log in with admin/district on the  <http://play.dhis2.org/demo/> demo system.



File cloud storage: You can now upload and store large files directly from data 
entry forms. Data elements can have a file value type and render as file upload 
widgets in forms. Files can be stored either on the Web server or sent directly 
to  <https://aws.amazon.com/s3/> AWS S3 cloud storage, which in practice 
provides unlimited storage capacity. This capability allows you to use DHIS 2 
as a general document repository which can be utilized for project management, 
documentation, CMS and many other purposes.



File storage currently works for aggregate data entry forms - tracker coming 
up. Have a look at the “Project management” data set in data entry on the demo:



 <http://play.dhis2.org/demo/dhis-web-dataentry/index.action> Demo |  
<https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s03.html#d5e517> 
Docs |  <https://www.dhis2.org/images/221/file-store.png> Screenshot



Settings app: The settings front-end has been re-written as a true app. It 
features real-time saving, search for settings and a fresh new look.



 <http://play.dhis2.org/demo/dhis-web-settings/index.html> Demo |  
<https://www.dhis2.org/doc/snapshot/en/user/html/ch23.html> Docs |  
<https://www.dhis2.org/images/221/settings.png> Screenshot



Data import constraints: Several optional constraints for data import can be 
enabled to provide stricter control of the data being imported. These include 
require period to be of same type as data set, data element to be assigned to 
data set through org units, and more. The import constraints can be enabled in 
settings app under “data import”.



 <https://www.dhis2.org/doc/snapshot/en/user/html/ch23.html#d5e4456> Docs



ANALYTICS FEATURES

---



Functions and variables in program indicators: Program indicators support a 
range of functions and variables. Functions allows for conditional statements, 
calculation of number of days between dates and more. Variables allows you to 
insert e.g. event date, enrollment date and value count into expressions. This 
is useful for example to calculate “inpatient bed days” and complex scores.



 <https://www.dhis2.org/doc/snapshot/en/user/html/ch30s03.html> Docs |  
<http://play.dhis2.org/demo/dhis-web-pivot/index.html?id=c9qrFDGxy8o> Demo 1 |  
<http://play.dhis2.org/demo/dhis-web-pivot/index.html?id=T7Nx1tEqG2f> 2 |  
<https://www.dhis2.org/images/221/program-indicator-condition.png> Screenshot 1 
|  <https://www.dhis2.org/images/221/pivot-program-indicator-condition.png> 2 | 
 <https://

Re: [Dhis2-devs] [Dhis2-users] Attribute value "Patient Code" from his "Name" and his "Year of birth" in Individual Records [2.20]

2015-09-03 Thread Harivola RANDRIANJAFY
Dear Alex,



After customizing program form according to your advise below, attached the 
Source code that I write in the « design program entry form ».



Launching the Tracker Capture, the code fields doesn’t capture my fonction. Is 
there something wrong that i miss ?



Regards,



Harivola



De : Alex Tumwesigye [mailto:atumwesi...@gmail.com]
Envoyé : jeudi 20 août 2015 18:36
À : Harivola RANDRIANJAFY <harivo...@psi.mg>
Cc : DHIS 2 Users list <dhis2-us...@lists.launchpad.net>; dhis2-devs 
<dhis2-devs@lists.launchpad.net>
Objet : Re: [Dhis2-users] Attribute value "Patient Code" from his "Name" and 
his "Year of birth" in Individual Records [2.20]



Dear Harivola,



You will need a custom form with some JQuery/Javascript that splits the name 
and takes the first 3 letters in the name and the last two letters in year of 
birth and inserts into into the patient code fields.



For that to happen, the name and year of birth should be filled first, and on 
focus in the patient code, you need to call the script/function.



Alex



On Thu, Aug 20, 2015 at 1:55 PM, Harivola RANDRIANJAFY <harivo...@psi.mg 
<mailto:harivo...@psi.mg> > wrote:

Hi all,



In our program, we want to register the attribute patient code. Does someone 
know how to obtain automatic value in attribute « Patient Code » from his 
attribute « Name » and « Year of birth » instead of writing the value manually ?

Ex :

Name : SARAH

Year of birth : 1980

*  Patient Code : value should be "SAR80"



Thanks,



Harivola



  _


 <https://www.avast.com/antivirus>

L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.
www.avast.com <https://www.avast.com/antivirus>




___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-us...@lists.launchpad.net 
<mailto:dhis2-us...@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp







--

Alex Tumwesigye



Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - 
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161


"I don't want to be anything other than what I have been - one tree hill "



  _


 <https://www.avast.com/antivirus>

L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.
www.avast.com <https://www.avast.com/antivirus>





---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.
https://www.avast.com/antivirus
Patient register
http://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js&quot</a>;>
  
   
   function code_client(){
var sName = 
$("input[attributeid='YxajNu1UcjP']").val().substr(0,3);
var sFirstName = 
$("input[attributeid='a1uRlZkvPBf']").val().substr(0,2);
var sBirthYear = 
$("input[attributeid='dyvfE1mwpUS']").val().substr(-2);
var sBirthLoc = 
$("input[attributeid='SNDrOhwKPV7']").val().substr(0,2);
var sSex = 
$("input[attributeid='St6mCYb6SQW']").val().substr(0,1);

if (sName == "") { sName = 
"XXX"; }
if (sFirstName == "") { 
sFirstName = "XX"; }
if (sBirthLoc == "") { 
sBirthLoc = "XX"; }

var sCode = sName;
sCode = sCode + sFirstName;
sCode = sCode + sBirthYear;
sCode = sCode + sBirthLoc;
sCode = sCode + sSex;

   
$("input[attributeid='gX08Z7KKeZj']").val(sCode) ;
  
   }
   




Nom



Prenoms



Anne de naissance

 

Re: [Dhis2-devs] [Dhis2-users] How import Tracker information into DHIS2 System

2015-08-25 Thread Harivola RANDRIANJAFY
Hi Jason,



The documentation shows the XML format for importing data value in event 
program but is there a documentation (XML format) for impoting tracker entity 
information where should be stored into the attribute of the person to be 
tracked?





Thank you



De : Dhis2-users 
[mailto:dhis2-users-bounces+harivolar=psi...@lists.launchpad.net] De la part de 
Jason Pickering
Envoyé : mercredi 19 août 2015 12:02
À : channara rin rin.chann...@gmail.com
Cc : DHIS 2 Users list dhis2-us...@lists.launchpad.net; DHIS 2 Developers 
list dhis2-devs@lists.launchpad.net
Objet : Re: [Dhis2-users] [Dhis2-devs] How import Tracker information into 
DHIS2 System



Hi there.



Did you have a look at the documentation? 
https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s13.html



Regards,

Jason





On Wed, Aug 19, 2015 at 10:58 AM, channara rin rin.chann...@gmail.com 
mailto:rin.chann...@gmail.com  wrote:

Hi all DHIS2,

can i use import/export for importing tracker's information like ID, name, sex, 
date of birth,...?

how to do that?



thank you

CHANNARA


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net 
mailto:dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp







--

Jason P. Pickering
email: jason.p.picker...@gmail.com mailto:jason.p.picker...@gmail.com
tel:+46764147049



  _


 https://www.avast.com/antivirus

L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.
www.avast.com https://www.avast.com/antivirus





---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] Attribute value Patient Code from his Name and his Year of birth in Individual Records [2.20]

2015-08-20 Thread Harivola RANDRIANJAFY
Hi all,



In our program, we want to register the attribute patient code. Does someone 
know how to obtain automatic value in attribute « Patient Code » from his 
attribute « Name » and « Year of birth » instead of writing the value manually ?

Ex :

Name : SARAH

Year of birth : 1980

*  Patient Code : value should be SAR80



Thanks,



Harivola



---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] [Bug 1428665] Re: Bugs in interface language (French/English)

2015-03-05 Thread Harivola RANDRIANJAFY
Thx Dan, how to have dhis2 apperance with full text in English ?

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1428665

Title:
  Bugs in interface language (French/English)

Status in DHIS 2:
  Invalid

Bug description:
  All text in web browser (Chrome or Firefox or Internet Explorer) are
  mixed translated with French and English Language. Switching
  appearance settings in English, it's give the same results as shown in
  attached file.

  DHIS2 version: 2.18 installed in local Server Linux Debian 7.4

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1428665/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] [Bug 1428665] [NEW] Bugs in interface language (French/English)

2015-03-05 Thread Harivola RANDRIANJAFY
Public bug reported:

All text in web browser (Chrome or Firefox or Internet Explorer) are
mixed translated with French and English Language. Switching appearance
settings in English, it's give the same results as shown in attached
file.

DHIS2 version: 2.18 installed in local Server Linux Debian 7.4

** Affects: dhis2
 Importance: Undecided
 Status: New

** Attachment added: DataElements.PNG
   
https://bugs.launchpad.net/bugs/1428665/+attachment/4335266/+files/DataElements.PNG

** Description changed:

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1428665

Title:
  Bugs in interface language (French/English)

Status in DHIS 2:
  New

Bug description:
  All text in web browser (Chrome or Firefox or Internet Explorer) are
  mixed translated with French and English Language. Switching
  appearance settings in English, it's give the same results as shown in
  attached file.

  DHIS2 version: 2.18 installed in local Server Linux Debian 7.4

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1428665/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] [Bug 1428665] Re: Bugs in interface language (French/English)

2015-03-05 Thread Harivola RANDRIANJAFY
It's a pleasure to help you and I am interested. How to proceed?

But what if I and all users want to have all terms in english only but
not in french because all users see this mix translation. Thx

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1428665

Title:
  Bugs in interface language (French/English)

Status in DHIS 2:
  Invalid

Bug description:
  All text in web browser (Chrome or Firefox or Internet Explorer) are
  mixed translated with French and English Language. Switching
  appearance settings in English, it's give the same results as shown in
  attached file.

  DHIS2 version: 2.18 installed in local Server Linux Debian 7.4

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1428665/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp