[Dhis2-devs] ownership of sample database

2014-01-15 Thread Bob Jolliffe
Hi I was just restoring the sample database from http://www.dhis2.org/download/resources/dhis2-demo.zip to a dhis2 instance for testing and I realize that this sql dump has 'ALTER XXX SET OWNER TO dhis' all over the place. I don't know where the script is to generate the sample database, but I pr

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13734: Had to remove not-null constraint on patientattribute.mandatory, caused problems when upgrading db

2014-01-15 Thread noreply
revno: 13734 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Wed 2014-01-15 11:26:26 +0100 message: Had to remove not-null constraint on patientattribute.mandatory, caused problems when upgrading db modified: dhis-2/dh

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13735: Made dataentryformupgrader more robust against no html content

2014-01-15 Thread noreply
revno: 13735 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Wed 2014-01-15 12:11:54 +0100 message: Made dataentryformupgrader more robust against no html content modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/dat

[Dhis2-devs] [Bug 1269350] [NEW] cannot run sql view in 2.14

2014-01-15 Thread Adebusoye Anifalaje
Public bug reported: sql view is able to execute queries but does not show the sql view after the table is created. I have managed to replicate this on the demo server. 1) Create query - fine 2) execute query - fine 3) show sql view - nothing happens (no error in the log) No error or exceptio

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13736: Fixed bug with context menu in sql view

2014-01-15 Thread noreply
revno: 13736 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Wed 2014-01-15 12:29:00 +0100 message: Fixed bug with context menu in sql view modified: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/s

[Dhis2-devs] [Bug 1269350] Re: cannot run sql view in 2.14

2014-01-15 Thread Lars Helge Øverland
Thanks for reporting. Fixed in r 13736 and back-ported to 2.14. ** Changed in: dhis2 Status: New => Confirmed ** Changed in: dhis2 Importance: Undecided => High ** Changed in: dhis2 Assignee: (unassigned) => Morten Olav Hansen (mortenoh) ** Changed in: dhis2 Milestone: None =

Re: [Dhis2-devs] API for pulling Multilingual Labels?

2014-01-15 Thread Rodolfo Melia
Hi Lars - we were about to use the locale values on api/me, but the info is not being returned. We tried Sierra Leone demo as well as dev - somehow is gone. Would it be possible to get this back? Thanks ! *Rodolfo Meliá* *Principal | *rme...@knowming.com Skype: rod.melia | +44 777 576 4090 |

Re: [Dhis2-devs] API for pulling Multilingual Labels?

2014-01-15 Thread Lars Helge Øverland
Its actually this resource URL: api/me/profile On Wed, Jan 15, 2014 at 12:49 PM, Rodolfo Melia wrote: > Hi Lars - we were about to use the locale values on api/me, but the info > is not being returned. We tried Sierra Leone demo as well as dev - somehow > is gone. Would it be possible to get

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13737: PT, filtering fixes.

2014-01-15 Thread noreply
Merge authors: Jan Henrik Øverland (janhenrik-overland) revno: 13737 [merge] committer: Jan Henrik Overland branch nick: dhis2 timestamp: Wed 2014-01-15 13:29:49 +0100 message: PT, filtering fixes. modified: dhis-2/dhis-web/dhis-w

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13738: ohie: rename dhis-web-api-fred module to dhis-web-ohie

2014-01-15 Thread noreply
revno: 13738 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2014-01-15 20:02:27 +0700 message: ohie: rename dhis-web-api-fred module to dhis-web-ohie removed: dhis-2/dhis-web/dhis-web-api-fred/ dhis-2/dhis-web/dhis

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13739: csd: added sample getModificationRequest xml

2014-01-15 Thread noreply
revno: 13739 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2014-01-15 20:05:02 +0700 message: csd: added sample getModificationRequest xml added: dhis-2/dhis-web/dhis-web-ohie/src/test/resources/ dhis-2/dhis-web/

[Dhis2-devs] How to order attribute options of person attribute

2014-01-15 Thread Thái Chương
Dears, I created a person attribute (named client-type) and made a registration form to put it in. Client type attribute has 5 options: 4 By UHN, 2 By staff, 1 Walk-in, 5 Other, 3 By CM The order get change base on the name of attribute options. I used hard code javascript to order those options i

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13740: ohie: moved csd/fred packages to ohie.*

2014-01-15 Thread noreply
revno: 13740 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2014-01-15 20:10:05 +0700 message: ohie: moved csd/fred packages to ohie.* removed: dhis-2/dhis-web/dhis-web-ohie/src/main/java/org/hisp/dhis/web/csd/ dhi

Re: [Dhis2-devs] API for pulling Multilingual Labels?

2014-01-15 Thread Rodolfo Melia
Thanks Lars - I can now see this working on 2.14. Would it be possible to back port it to 2.13? Otherwise we will wait to late march, when we have scheduled our upgrade of the production server. R *Rodolfo Meliá* *Principal | *rme...@knowming.com Skype: rod.melia | +44 777 576 4090 | +1 708

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13741: renamed webapi-fred.xml -> webapi-ohie.xml

2014-01-15 Thread noreply
revno: 13741 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2014-01-15 20:30:51 +0700 message: renamed webapi-fred.xml -> webapi-ohie.xml removed: dhis-2/dhis-web/dhis-web-ohie/src/main/resources/META-INF/dhis/webapi

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Gerald Thomas
Please any help??? I just want to finish with this issue. Please can anyone help me. Sent from Windows Mail From: Gerald Thomas Sent: ‎Tuesday‎, ‎January‎ ‎14‎, ‎2014 ‎9‎:‎36‎ ‎PM To: Morten Olav Hansen, Olav Poppe Cc: dhis2-devs@lists.launchpad.net Hi all, I remotely access the s

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13742: moved fred-api from /api-fred => /ohie/fred, also moved /api-fred/csd => /ohie/csd

2014-01-15 Thread noreply
revno: 13742 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2014-01-15 21:09:56 +0700 message: moved fred-api from /api-fred => /ohie/fred, also moved /api-fred/csd => /ohie/csd modified: dhis-2/dhis-web/dhis-web-o

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13743: DV, download bug fixed.

2014-01-15 Thread noreply
Merge authors: Jan Henrik Øverland (janhenrik-overland) revno: 13743 [merge] committer: Jan Henrik Overland branch nick: dhis2 timestamp: Wed 2014-01-15 16:14:04 +0100 message: DV, download bug fixed. modified: dhis-2/dhis-web/dhi

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Jason Pickering
Hi Gerald, In general, a downgrade is tricky. You would need to really restore to 2.12 from a backup copy. In this case, I do not think it would really be necessary, since 2.13 should work. Are you certain this is not a browser caching issue? Did you try and confirm that no data is appearing in inc

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13745: Column quoting remaining period resource tables. Fixes problem on h2.

2014-01-15 Thread noreply
revno: 13745 committer: Lars Helge Øverland branch nick: dhis2 timestamp: Wed 2014-01-15 17:16:23 +0100 message: Column quoting remaining period resource tables. Fixes problem on h2. modified: dhis-2/dhis-services/dhis-service-admin

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13744: fixes for fred tests

2014-01-15 Thread noreply
revno: 13744 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2014-01-15 23:09:44 +0700 message: fixes for fred tests modified: dhis-2/dhis-web/dhis-web-ohie/src/main/java/org/hisp/dhis/web/ohie/fred/FredSpringWebTest

Re: [Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-15 Thread Lars Helge Øverland
This should be fixed now in trunk, 2.14 and 2.13. Please test. On Tue, Jan 14, 2014 at 12:58 AM, Paulo Grácio wrote: > Hi Busoye, > > We are not using the default OU Levels, please see the attachment. > > Regards, > Paulo Grácio > > -- > You received this bug notification because you are a memb

Re: [Dhis2-devs] "Atomic" data validation rules

2014-01-15 Thread Lars Helge Øverland
Hi Jason, yes I think this makes sense. One could make a special kind of validation rule, with a constraint that all data elements on the left and right side expressions share the same category combination, and then tell the system to validate each and every category option combination. Feel free

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-15 Thread Lars Helge Øverland
** Changed in: dhis2 Status: New => Fix Committed ** Changed in: dhis2 Importance: Undecided => High ** Changed in: dhis2 Assignee: (unassigned) => Lars Helge Øverland (larshelge) ** Changed in: dhis2 Milestone: None => 2.14 -- You received this bug notification because you

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Gerald Thomas
Dear Jason, This is currently one of my worst day using the dhis. I tried everything I could be nothing works. I already backup the postregsql database but the size of the file is too small, approximately 161MB. Secondly, I am trying to uninstall the postregsql on the ubnutu and then install an

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Dan Cocos
Hi Gerald, If you want to completely remove postgres did you try apt-get --purge remove postgresql This should remove it and everything related to it. Dan On Wed, Jan 15, 2014 at 2:26 PM, Gerald Thomas wrote: Dear Jason, This is currently one of my worst day using the dhis. I tried everything

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Gerald Thomas
Dan, I already done that as we but it is saying “can’t find postregsql”. Maybe I will I have to run a new Ubuntu if can’t remove it. Sent from Windows Mail From: Dan Cocos Sent: ‎Wednesday‎, ‎January‎ ‎15‎, ‎2014 ‎7‎:‎59‎ ‎PM To: Gerald Thomas Cc: jason.p.picker...@gmail.com, dhis2-dev

[Dhis2-devs] About dataset completeness

2014-01-15 Thread Seide, Germine
Good Morning All, I am dealing with a big issue on DHIS 2. I have done a data import from another program to DHIS2 by using XML. All data displayed pretty well in data entry forms but the forms are not complete. Is there any way I can mark as complete after importing data from XML file all the d

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Jan Henrik Øverland
Should be "postgresql", not "postregsql". On Wed, Jan 15, 2014 at 9:44 PM, Gerald Thomas wrote: > Dan, > I already done that as we but it is saying “can’t find postregsql”. Maybe > I will I have to run a new Ubuntu if can’t remove it. > > Sent from Windows Mail > > *From:* Dan Cocos > *Sent:*

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Bob Jolliffe
Hi Gerald It sounds like you are now panicking a bit which is when you are most likely to make mistakes. The biggest concern I would have now is that you are in danger of losing data. You say that you have a backup of the database of 161MB but you don't know if it is any good. In which case DO

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Gerald Thomas
I am in Sierra Leone by the way. Yes I know this is not good and I will be loosing a lot which is very detrimental to one of my country’s regional database. Help from this website doesn’t come handy when really need and my job is at stake. I will suggest that this forum have a messenger which m

[Dhis2-devs] [Bug 1268787] Re: Generating Analytics in Live version

2014-01-15 Thread Paulo Grácio
Hi Lars, we are still getting this error on the log: * INFO 00:58:01,539 [Level: ERROR, category: DATAMART, time: Thu Jan 16 00:58:01 GMT 2014, message: Process failed: Exception during execution] (InMemoryNotifier.java [taskSchedul er-3]) * ERROR 00:58:01,610 Unexpected error occurred in sch

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13746: csd: use a jaxbcontext directly instead of jaxb2marshaller (from spring)

2014-01-15 Thread noreply
revno: 13746 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2014-01-16 10:45:34 +0700 message: csd: use a jaxbcontext directly instead of jaxb2marshaller (from spring) modified: dhis-2/dhis-web/dhis-web-ohie/src/mai

Re: [Dhis2-devs] About dataset completeness

2014-01-15 Thread Jason Pickering
Hi Germine, This can be done either with XML or SQL. From the documents, you can see how it can be done with XML during the import process. http://dhis2.org/schema/dxf/2.0"; dataSet="pBOMPrpg1QX" completeDate="2012-02-03" period="201201" orgUnit="DiszpKrYNg8"> If you want to do it wit

[Dhis2-devs] Issues with missing data in the DV

2014-01-15 Thread Jason Pickering
We have an issue with the DV in 2.14, whereby if data is missing for a period, a "NaN" is returned, and nothing is visible on the graph. To reproduce, choose "ANC 1st visit" for Sierra Leone, and then "Last 3 months" and then add the "Decmber 2008" period (where there is no data). You will see a

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13747: Fixed bug - Remove healthworkerid from Automated message reminder function

2014-01-15 Thread noreply
revno: 13747 committer: Tran Chau branch nick: dhis2 timestamp: Thu 2014-01-16 13:21:47 +0700 message: Fixed bug - Remove healthworkerid from Automated message reminder function modified: dhis-2/dhis-services/dhis-service-patient/sr

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Gerald Thomas
Dear when I run the backup the server came with a file which dhis2.sql.gz but I can’t import this database into another postgresql to see if this file was ok. Please is there any way I can extract the file to have the dhis2.sql Please I need help Sent from Windows Mail From: Dan Coc

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Morten Olav Hansen
You can unzip the file with gunzip dhis2.sql.gz, and then import with psql -U -f -- Morten On Thu, Jan 16, 2014 at 1:39 PM, Gerald Thomas wrote: > Dear when I run the backup the server came with a file which dhis2.sql.gz > but I can’t import this database into another postgresql to see if

Re: [Dhis2-devs] Can't see data after upgrade to 2.13

2014-01-15 Thread Knut Staring
Also, if you are on Windows, you can use something like PeaZip to unzip: http://peazip.sourceforge.net/ On Thu, Jan 16, 2014 at 8:01 AM, Morten Olav Hansen wrote: > You can unzip the file with gunzip dhis2.sql.gz, and then import with psql > -U -f > > -- > Morten > > > On Thu, Jan 16, 2014 at

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13748: properly provide xml/json for programPatientAttribute

2014-01-15 Thread noreply
revno: 13748 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2014-01-16 14:34:15 +0700 message: properly provide xml/json for programPatientAttribute modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/program/Prog

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 13749: add new parameter to programController, orgUnit=uid, to filter for assigned orgUnits

2014-01-15 Thread noreply
revno: 13749 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2014-01-16 14:48:44 +0700 message: add new parameter to programController, orgUnit=uid, to filter for assigned orgUnits modified: dhis-2/dhis-web/dhis-web