[Dhis2-devs] [GSOC] Automated test scripts (WebDriver)

2014-03-04 Thread Ankur Sial
Hi all, I am Ankur Sial, third year undergraduate student pursuing my B.Tech. in Computer Science & Engineering at IIIT-Delhi. I have a keen interest in web development and have already worked on many projects in related fields in the past. For my full profile, please visit: http://www.linkedin.co

Re: [Dhis2-devs] Interest in GSOC project JSON enabled storage API

2014-03-04 Thread Peder Andreas Nergaard
Hi Tharindu, Welcome to the DHIS2 community! As you can see from our ideas page, we are quite open for different contributions. A good starting point is downloading, installing and playing around with DHIS2 to familiarize yourself with the system, concepts and data models. You can also find a

Re: [Dhis2-devs] Web GUI for Query Development

2014-03-04 Thread Bob Jolliffe
Here is an example of some pg_hba.conf settings with comments which people might find useful. The database in this case is on a separate server. The application server (with tomcat and all) is on a machine called appserver on 192.168.1.102. Other machines we want to allow to connect from the off

Re: [Dhis2-devs] Web GUI for Query Development

2014-03-04 Thread Jason Pickering
We have used OpenVPN/IPSec to allow direct access to the database for those users who need it. Therefore users do not need shell access and strong certificates can be used. This was viewed as a lower security risk than having PHP on the server or by opening up the database itself directly. Might al

Re: [Dhis2-devs] Web GUI for Query Development

2014-03-04 Thread Bob Jolliffe
yes people talk highly of phpPgAdmin. It has some small benefit over pgadminIII that you don't have to explicitly open up your pg_hba.conf settings to the full range of user/hosts which might connect. I guess it would be a simple enough app to embed phpPgAdmin into some sort of iframe for integra

Re: [Dhis2-devs] [Bug 1286687] [NEW] selecting attributes for tracked entity throws exception

2014-03-04 Thread Adebusoye Anifalaje
Hi Tran, Actually both were present in the table so I just dropped the programattributeid column. It is now working as expected. Should I be concerned about the error message on tomcat start up? * ERROR 2014-03-04 16:47:12,593 HHH000388: Unsuccessful: alter table program_attributes add constra

Re: [Dhis2-devs] [Bug 1286687] [NEW] selecting attributes for tracked entity throws exception

2014-03-04 Thread Tran Chau
Hi Busoye, As your log, I find out the bug in here ERROR 2014-03-03 13:06:24,859 ERROR: null value in column " programattributeid" violates not-null constraint But the system doesn't have column called *programattributeid*. It should be *programtrackedentityattributeid*. Can you look at into you

Re: [Dhis2-devs] Web GUI for Query Development

2014-03-04 Thread Jason Pickering
Hi Greg, You may want to check out phpPgAdmin. PgAdminIII could also of course be used by directly connecting to the database with an ODBC connection. Regards, Jason --Sent from my mobile On Mar 4, 2014 12:26 PM, "Greg Rowles" wrote: > Hi Devs > > Is anyone aware of a web-based query gui-tools

[Dhis2-devs] Interest in GSOC project JSON enabled storage API

2014-03-04 Thread Tharindu Amila Perera
Hi all, I'm a third year Computer Science & Engineering undergraduate at University of Moratuwa. I'm familiar with web services and JSON. It would be a pleasure to contribute to this project which will help others and help myself. Can you please point me in the direction I need to go in order to s

[Dhis2-devs] [Bug 1287670] [NEW] Trunk 2.15Tracker error when adding indicator to program stage

2014-03-04 Thread Adebusoye Anifalaje
Public bug reported: >From Programs -> Manage Program Indicators -> Fill required fields and then choose Program stage. There are no data elements available for selection. In the log I get a warning (see below): * WARN 2014-03-04 09:42:49,843 Could not find action or result: /dhis-web-maintenan

Re: [Dhis2-devs] DHIS2 'datadictionary' tables

2014-03-04 Thread greg.row...@gmail.com
Sorry, UN = in... Sent from my HTC - Reply message - From: "greg.row...@gmail.com" To: "DHIS 2 developers" Cc: "Farai Mutero" Subject: DHIS2 'datadictionary' tables Date: Wed, Feb 26, 2014 10:18 Hi Devs Are the set of tables relating to 'datadictionary' currently used in any rollout

[Dhis2-devs] Web GUI for Query Development

2014-03-04 Thread Greg Rowles
Hi Devs Is anyone aware of a web-based query gui-toolset? We have an 'IE' designed tool here: http://hispsa.org/staging_timesheets/tablerels/viewtables.asp It only works on IE (sometimes) but at least allows users to see table designs and edit SQL syntax. We're looking at something that we can p

[Dhis2-devs] DHIS2 'datadictionary' tables

2014-03-04 Thread greg.row...@gmail.com
Hi Devs Are the set of tables relating to 'datadictionary' currently used in any rollouts? Farai and I will be working on a major piece of work in SA that will require use of these terms within a DHIS2 database. I realize the table names are case sensitive (in PostGRE) so we can bypass the issu