Re: [Dhis2-users] Require help on installation and management of DHIS2

[Paulo Grácio]

I have added support for version 2.30 using docker.

https://github.com/pgracio/dhis2-docker

On Sun, Sep 2, 2018 at 7:58 PM Knut Staring  wrote:

> Hi Imran,
>
> I forward this to the users list, which is the main free support channel.
> Others will be in a better position to guide you, but can you supply more
> details on what find confusing? Most of the server guidance exists for
> Ubuntu (though it is fine to run on Windows + XAMPP (or just Tomcat or
> DHIS2 Live) locally.
>
> With the latest versions of DHIS2, you can no longer use Mysql but need
> Postgres 10 (with PostGIS).
>
> There is actually a training on server management given a couple of times
> a year, though not sure when the next one will be:
> https://www.dhis2.org/previous-academies
>
> There are also resources like dhis2-tools and Docker:
> https://docs.dhis2.org/2.29/en/implementer/html/ch20.html
> https://github.com/pgracio/dhis2-docker
> https://hub.docker.com/r/dhis2/dhis2-web/
>
> Knut
>
> On Sun, Sep 2, 2018 at 6:37 PM A N M AL IMRAN  wrote:
>
>> Hello DHIS2 Experts,
>>
>> I am new to DHIS2 and need to learn about server configuration and
>> installation process for one of the projects I am working for. I need to
>> learn both the installation process on localhost and on cloud hostings,
>> such as Google or Bluehost (not Amazon). I already tried both backed with
>> PostgreSQL and backed with MySQL on xampp. Next step is quite confusing
>> even in the documentation. Help will be highly appreciated. The project
>> will not allow any external involvement in configuring the hosting. All the
>> courses offered by DHIS2 is on data management and using DHIS2, not for
>> server configuration and management.
>>
>> Your support will be highly appreciated.
>>
>> Thanks,
>> Imran
>> A N M AL IMRAN (Imran)
>> Brossard, QC
>> Canada
>> Cell: +1 (438) 501 3576 <(438)%20501-3576>
>>
>
>
> --
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype: knutstar
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Installation of dhis2 on docker

[Paulo Grácio]

Hi Geral, with the current docker setup you can generate your own docker
image and use that one instead of sierra-leone.

All you need to do is:

1. comment this line
https://github.com/pgracio/dhis2-docker/blob/master/database/docker-build.sh#L60
2. have a file named *dhis2-db.sql.gz* that contains your database dump.
3. run ./docker-build.sh -v 2.30 -d my-database
4. update docker-compose do use the nee image.

give it a try.


On Tue, Aug 28, 2018 at 12:16 PM gerald thomas 
wrote:

> Hi all,
> I got it docker using postgresql is fixed now but i need to drop the
> current database and import another database. Please can anyone help?
>
> On Mon, Aug 27, 2018 at 2:55 PM gerald thomas 
> wrote:
>
>> Dan,
>> I am using my laptop which is mac pro where i had already installed
>> docker and now i want to install an Ubuntu DHIS2 instance on it.
>>
>> On Mon, Aug 27, 2018 at 2:32 PM Dan Cocos  wrote:
>>
>>> Hi Gerald,
>>>
>>> You can also try this for local dev.
>>> https://github.com/baosystems/dhis2-centos
>>>
>>> Cheers,
>>> Dan
>>>
>>>
>>> Dan Cocos
>>> Principal, BAO Systems
>>> dco...@baosystems.com | http://www.baosystems.com |  2900 K Street,
>>> Suite 507, Washington D.C. 20007
>>> <https://maps.google.com/?q=2900+K+Street,+Suite+507,+Washington+D.C.+20007=gmail=g>
>>>
>>>
>>> On Aug 27, 2018, at 3:52 AM, Gerald Thomas 
>>> wrote:
>>>
>>> Dear Paulo,
>>> Can i only have mysql database for this instance?
>>>
>>> On Aug 27, 2018, at 5:58 AM, Paulo Grácio  wrote:
>>>
>>> https://github.com/pgracio/dhis2-docker
>>>
>>> Hasn’t been updated for a while so not sure if there is a better way.
>>>
>>> On 27 Aug 2018, at 00:35, gerald thomas  wrote:
>>>
>>> Dear all,
>>> I am trying to do a dhis2 instance using docker on my laptop. Please can
>>> anyone help with the procedures; this is my first time to do it on docker
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
> --
> Regards,
>
> Gerald
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Installation of dhis2 on docker

[Paulo Grácio]

https://github.com/pgracio/dhis2-docker

Hasn’t been updated for a while so not sure if there is a better way.

> On 27 Aug 2018, at 00:35, gerald thomas  wrote:
> 
> Dear all,
> I am trying to do a dhis2 instance using docker on my laptop. Please can 
> anyone help with the procedures; this is my first time to do it on docker
> 
> -- 
> Regards,
>  
> Gerald
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Tomcat 8.5

[Paulo Grácio]

Hi Edward,

I have done some tests with docker using
`dhis2/dhis2-web:2.26-tomcat8.5-jre8-latest` and it seems to work fine.
Anyhow was just some basic tests...

Br,
- Paulo



On Thu, Sep 14, 2017 at 2:59 PM Edward Robinson <
erobin...@projectbalance.com> wrote:

> Is there any reason I shouldn’t use Tomcat 8.x with DHIS 2.26 or higher
> DHIS2?
>
> I see even the 2.27 setup instructions specify Tomcat 7.
>
> Thanks
>
> Ed
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] dhis 2.25 upgrade

[Paulo Grácio]

disregard my question... looking at the wrong container ;)

On Fri, Oct 21, 2016 at 10:49 AM Paulo Grácio <paulogra...@gmail.com> wrote:

> Hi,
>
> when starting version 2.25 it logs
>
> INFO  2016-10-21 08:42:25,118 Environment variable DHIS2_HOME points to
> /opt/dhis2/config (DefaultLocationManager.java [localhost-startStop-1])
> INFO  2016-10-21 08:42:25,144 File /opt/dhis2/config/dhis.conf does not
> exist (DefaultLocationManager.java [localhost-startStop-1])
>
> root@2f72d3f3ea13:/opt/dhis2/config# ls -la
> total 16
> drwxr-xr-x 2 root root 4096 Oct 21 08:41 .
> drwxr-xr-x 4 root root 4096 Oct 21 08:41 ..
> -rw-r--r-- 1 root root  488 Oct 21 08:24 dhis.conf
> -rw-r--r-- 1 root root  282 Dec  4  2015 hibernate.properties
>
> any idea why this might be happening?
>
> BR,
> -- Paulo
>
>
>
>
> On Fri, Oct 14, 2016 at 8:21 PM Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
> Hi all,
>
> please take care to read the upgrade notes for DHIS version 2.25:
>
> https://www.dhis2.org/225-upgrade
>
> Some highlights:
>
> - A new column "deleted" is introduced for the datavalue table. For large
> databases it is recommended to run the upgrade script
> <https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-225.sql>.
> This will be taken care of by DHIS 2 itself if not run but the upgrade
> script is faster as it drops / creates constraints around the upgrade
> statements. The upgrade might take a few minutes on large database so the
> upgrade process should be planned for.
>
> - There is a breaking API change around the data set to data element
> association, so app developers should evaluate this.
>
> - Support for the *hibernate.properties* config file is removed after
> being deprecated for a year. Use *dhis.conf* as filename. Note that the
> config properties is updated. Install docs here
> <https://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_server_setup.html#install_database_configuration>
> .
>
>
>
>
> Lars
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] dhis 2.25 upgrade

[Paulo Grácio]

Hi,

when starting version 2.25 it logs

INFO  2016-10-21 08:42:25,118 Environment variable DHIS2_HOME points to
/opt/dhis2/config (DefaultLocationManager.java [localhost-startStop-1])
INFO  2016-10-21 08:42:25,144 File /opt/dhis2/config/dhis.conf does not
exist (DefaultLocationManager.java [localhost-startStop-1])

root@2f72d3f3ea13:/opt/dhis2/config# ls -la
total 16
drwxr-xr-x 2 root root 4096 Oct 21 08:41 .
drwxr-xr-x 4 root root 4096 Oct 21 08:41 ..
-rw-r--r-- 1 root root  488 Oct 21 08:24 dhis.conf
-rw-r--r-- 1 root root  282 Dec  4  2015 hibernate.properties

any idea why this might be happening?

BR,
-- Paulo




On Fri, Oct 14, 2016 at 8:21 PM Lars Helge Øverland  wrote:

> Hi all,
>
> please take care to read the upgrade notes for DHIS version 2.25:
>
> https://www.dhis2.org/225-upgrade
>
> Some highlights:
>
> - A new column "deleted" is introduced for the datavalue table. For large
> databases it is recommended to run the upgrade script
> .
> This will be taken care of by DHIS 2 itself if not run but the upgrade
> script is faster as it drops / creates constraints around the upgrade
> statements. The upgrade might take a few minutes on large database so the
> upgrade process should be planned for.
>
> - There is a breaking API change around the data set to data element
> association, so app developers should evaluate this.
>
> - Support for the *hibernate.properties* config file is removed after
> being deprecated for a year. Use *dhis.conf* as filename. Note that the
> config properties is updated. Install docs here
> 
> .
>
>
>
>
> Lars
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Reg: DHIS2 docker instance.

[Paulo Grácio]

Hi Nalinikanth,

is there any reason to keep a separate repo with these tests? It would be
nice to have the tests as part of https://github.com/dhis2/api-tests
There is also a pipeline to execute the tests in Travis
https://travis-ci.org/dhis2/api-tests

Docker image build is also automated, runs once per day, and is publishing
images to Docker Hub https://hub.docker.com/r/dhis2/dhis2-web/tags/

Best regards,
Paulo

On Tue, Sep 27, 2016 at 2:41 PM Nalinikanth Meesala <
nali...@thoughtworks.com> wrote:

> Hi Jason & Paulo,
>
> Hope you are doing good.
>
> It has been a long time! We are writing tests for metadata sync. All the
> tests are added to the repo here <https://github.com/msf-oca-his/API_Test>
> .
>
> In the above repository navigate to the
> path API_Test/testcases/metadatasync/integration/
>
> there is a generic test “ImportMetadataTest" which we wrote for testing
> how various types of metadata entities will sync from HQ/central instance
> to local/field.
>
> There are two ways of running the test
>
> 1. To run this test without any database on HQ and Local.
>
> To test how sync is behaving with respect to various metadata entities on
> two new instances without any data model on it. All we need is to have
> metadata versions in this folder -
> API_Test/testdata/metadatasync/versiondata
>
> We can have any number of versions in the folder. It depends on how user
> wants metadata sync to happen or what all metadata associations or
> disassociations user wants to test. For now I kept two version files.
>
> To run the test for Version_1 run this should be run using "env
> version="Version_2" mocha ImportMetadataTest.js --timeout 2” which is
> can be added to a shell script to run version one after the other like it
> is in integrationTestsWithoutDB.sh file. This will first import data on
> HQ/Central instance using import api and then Local/field instance will
> sync the version from HQ.
>
> Once the version is synced to Local/Field then we are doing two tests.
> One is asserting the data in
>
> http://*local*/api/metadata/version/Version_1/data with 
> http://*HQ*/api/metadata/version/Version_1/data
> by comparing them.
>
> Later it will compare all the entities(which are present in that version)
> individually say we have a array of data elements then it will pick all the
> data elements and compare one by one and continues for other entities as
> well.
>
> e.g: It will compare http://*local*/api/dataElements/id with http://*HQ*
> /api/dataElements/id
>
> 2. To test how sync is behaving with respect to various metadata entities
> on two instances where HQ already have n versions[Pre defined database]. We
> are using the same script to import version by version. It will also do a
> couple of assertions on top of the metadata when synced. The first
> assertion being same as above it will compare the data in 
> http://*local*/api/metadata/version/Version_1/data
> with http://*HQ*/api/metadata/version/Version_1/data.
>
> But the next level comparison is a bit different it will compare the
> entities by fetching the entity data which is present in
>
> http://*local*/api/metadata/version/Version_1/data with http://*local*
> /api/dataElements/id
>
> Here there won’t be entire json for any entity on 
> http://*local*/api/metadata/version/Version_1/data
> this will contain very limited details we are just comparing the minimal
> entities getting them from Local/Field using jsonfilters in api call.
>
> We had this kind of assertions because say user has Version_1 and has a
> data element abcd1234 and the name might have changed in Version_2
>  abcd12345 as HQ has got n versions in it so if we want to compare json of
> it on both HQ and Local we have different names so we took this approach.
>
> Can you please have a look at this and let me know if any changes are
> required.
>
> Thanks & Regards,
>
> Nalinikanth M
>
>
> On Thu, Aug 18, 2016 at 11:32 AM, Nalinikanth Meesala <
> nali...@thoughtworks.com> wrote:
>
>> Hey All,
>>
>> I am Nalinikanth, QA on the MSF-OCA project and we are using DHIS2. We
>> are building  API automation suites as a part of our project. We are
>> working along with Jason. P and Paulo. We have been discussing on how to
>> take this forward and you can find our discussions thread in this mail.
>>
>> Please do comment or provide feedback if you have any ideas or thoughts
>> around the same.
>> I am attaching the repos as well for your reference.
>>
>> https://github.com/msf-oca-his/API_Test
>>
>> https://github.com/dhis2/api-tests
>>
>> Feedback from the community would be well a

Re: [Dhis2-users] dhis2 2.20 War file fail to be executed:SEVERE: Error configuring application listener of class org.hisp.dhis.system.startup.StartupListener

[Paulo Grácio]

Hi Adolphe,

another option is to use Docker to start the training environments. You can
find some more information here
https://github.com/pgracio/dhis2-docker

docker images
https://hub.docker.com/r/pgracio/dhis2-web/tags/
https://hub.docker.com/r/pgracio/dhis2-db/tags/

Regards,
Paulo

On Fri, May 27, 2016 at 11:59 AM Kamugunga Adolphe  wrote:

> Thank you very much dear team
> It ok now.
>
> Regards,
>
>
> *Adolphe Kamugunga*
> *MIS Technical Advisor*
> *Knowledge Management, Data Use and Research*
> Rwanda Health System Strengthening Activity
> Management Sciences for Health
> Rwanda-Kigali
> Mobile: +250 788 740 578
> Email:kaa...@gmail.com
> Skype: ka.adolphe
> 
> Stronger health systems. Greater health impact.
>
>
> On 26 May 2016 at 20:03, Craig A  wrote:
>
>> Hi,
>>
>> There's a mismatch with your java version. The default Java version for
>> Ubuntu 14.04 is Java 7. You'll have to autoremove Java 7 and install Java
>> 8. The instructions for installing Java 8 can be found near the bottom of 
>> this
>> page
>> 
>> .
>>
>> Sincerely,
>> Craig
>>
>> On Thu, May 26, 2016 at 10:57 AM, Kamugunga Adolphe 
>> wrote:
>>
>>> Hi there,
>>>
>>> I am trying to install a training server on ubuntu 14.04  with a recent
>>>  2.20 war file on a laptop. When i browser the nginx works fine but when i
>>> include the full path to my test instance it fails to run.
>>>
>>> Checking from the catalina logs file i realize that the system had
>>> severe error.Can someone guide me how to deal with it? Here is the log
>>> details
>>>
>>> May 26, 2016 6:25:04 PM org.apache.coyote.AbstractProtocol init
>>>
>>> INFO: Initializing ProtocolHandler ["http-bio-127.0.0.1-8081"]
>>>
>>> May 26, 2016 6:25:04 PM org.apache.catalina.startup.Catalina load
>>>
>>> INFO: Initialization processed in 616 ms
>>>
>>> May 26, 2016 6:25:04 PM org.apache.catalina.core.StandardService
>>> startInternal
>>>
>>> INFO: Starting service Catalina
>>>
>>> May 26, 2016 6:25:04 PM org.apache.catalina.core.StandardEngine
>>> startInternal
>>>
>>> INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
>>>
>>> May 26, 2016 6:25:04 PM org.apache.catalina.startup.HostConfig deployWAR
>>>
>>> INFO: Deploying web application archive
>>> /var/lib/dhis2/test/webapps/test.war
>>>
>>> May 26, 2016 6:25:18 PM org.apache.catalina.core.ApplicationContext log
>>>
>>> INFO: No Spring WebApplicationInitializer types detected on classpath
>>>
>>> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
>>> listenerStart
>>>
>>> SEVERE: Error configuring application listener of class
>>> org.hisp.dhis.system.startup.StartupListener
>>>
>>> java.lang.UnsupportedClassVersionError:
>>> org/hisp/dhis/system/startup/StartupListener : Unsupported major.minor
>>> version 52.0 (unable to load class
>>> org.hisp.dhis.system.startup.StartupListener)
>>>
>>> at
>>> org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2948)
>>>
>>> at
>>> org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1208)
>>>
>>> at
>>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1688)
>>>
>>> at
>>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1569)
>>>
>>> at
>>> org.apache.catalina.core.DefaultInstanceManager.loadClass(DefaultInstanceManager.java:529)
>>>
>>> at
>>> org.apache.catalina.core.DefaultInstanceManager.loadClassMaybePrivileged(DefaultInstanceManager.java:511)
>>>
>>> at
>>> org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:139)
>>>
>>> at
>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4888)
>>>
>>> at
>>> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
>>>
>>> at
>>> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>>>
>>> at
>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
>>>
>>> at
>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>>>
>>> at
>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
>>>
>>> at
>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
>>>
>>> at
>>> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
>>>
>>> at
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>>>
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>>
>>> at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>>
>>> at
>>> 

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

[Paulo Grácio]

Why not use
https://docs.oracle.com/javase/tutorial/i18n/format/numberFormat.html where
the default format depends on user/setup locale?
On Wed, 4 May 2016 at 00:32, Antonia - Pro  wrote:

> At the start of voting I felt in total minority.
> But according to the SI/ISO 31-0 standard
>  he space is
> the only neutral separator. The space is appropriate also because in some
> countries the comma is the decimal separator (not always the democratic
> vote is the best choice.)
>
> Regards,
> Antonia
>
>  www.informa.pro - *Seguici su *LinkedIn
>  [image: In]
> 
> INFORMAPRO S.r.l. - via Luigi Rava 43,  Roma 00149 , Italy
> tel. +39 06 5758926, fax +39  06 62207168
> Skype: informa_antonia.bezenchek
> Eng. Antonia Bezenchek - CIO - ICT Engineer
>
> 2016-05-03 21:34 GMT+02:00 Bob Jolliffe :
>
>> https://en.wikipedia.org/wiki/Decimal_mark#Digit_grouping
>>
>> seems to support Jim's suggestion of space as default.
>>
> On 3 May 2016 at 21:32, Ola Hodne Titlestad  wrote:
>>
> Supporting Jim's suggestion on a system/implementation setting to
>>> configure a default system-wide separator in addition to the possibility of
>>> overriding this for each pivot table or other type of report with display
>>> options. I guess the result of the vote could still be what the default
>>> value for this system setting should be
>>>
>>> Ola
>>> --
>>>
>>
>>> --
>>> Ola Hodne Titlestad (Mr)
>>> HISP
>>> Department of Informatics
>>> University of Oslo
>>>
>>> Mobile: +47 48069736
>>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>>> 
>>>
>>> On 3 May 2016 at 21:12, Jim Grace  wrote:
>>>
>> To me the most important way to address this is to allow an
 implementation-wide default. The space character is in many ways the
 "correct" separator according to international norms, and is even making
 inroads into countries such as the US that traditionally use the comma. I
 think the space is probably the best "factory" default for DHIS 2, so that
 large numbers are readable on demonstration systems, and so we follow
 international and emerging standards.

 However, an implementation should be able to override this with an
 implementation-wide default of comma, where a preponderance of users for
 that implementation are more used to this, and/or where exporting to Excel
 is a concern.

 Expecting users to override the default every time they create a pivot
 table is not very user-friendly.


 On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:

> I vote for having none as default (1432) then one can choose what
> they want in options
>
>
> On Tue, May 3, 2016 at 7:36 PM, Lars Helge Øverland 
> wrote:
>
>> Hi there,
>>
>> we are getting many (conflicting) requests for what the default value
>> should be for the "digit group separator" in the pivot table app.
>>
>> So lets decide with a poll.. Cast your vote here before Friday 6th!
>>
>> http://doodle.com/poll/vtyzgts226aqihev
>>
>>
>> The digit group separator controls how large numbers are being split
>> up, e.g.
>>
>> 1 432
>> 1,432
>> 1432
>>
>> The digit group separator can be controlled from Options.
>>
>> [image: Inline image 1]
>>
>> regards,
>>
>> Lars
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org 
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global HISP| University Of Oslo/HISP Uganda
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


 --
 Jim Grace
 Core developer, DHIS 2
 HISP US Inc.
 

Re: [Dhis2-users] Open ID configuration in DHIS2

[Paulo Grácio]

Hi Chameera,

you can find more information here.

"*Set the OpenID identifier on the user*: For every user that should be
able to login with his OpenID identifier, you will need to set this on the
user itself. This can be done in user management, under the email field,
there is not a field called OpenID which can be used to fill in the OpenID
identifier."

http://dhis2.github.io/dhis2-docs/2.23/en/user/html/ch07.html#d0e2575

On Sat, Apr 30, 2016 at 11:08 AM Chameera Mirihella 
wrote:

> hello All,
>
> Can some one please explain how openID identifier on each user is related
> to the authentication process, after setting up the openID provider and
> the label.
>
> Thanks,
> Chameera.
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] dhis version 2.22 is released

[Paulo Grácio]

+1 Well done.

For those who want to try this new version using docker, I have just pushed
a new image for version 2..22.
https://github.com/pgracio/dhis2-docker

Have fun!
Paulo Grácio

On 17 January 2016 at 11:55, Alex Tumwesigye <atumwesi...@gmail.com> wrote:

> Lars,
>
> Thanks for all the efforts.
> Indeed, 2.22 has great features mostly on tracker/SMS.
>
> Alex
>
> On Sat, Jan 16, 2016 at 6:36 PM, Nami Ghadri <nami_gha...@hotmail.com>
> wrote:
>
>> Great News
>>
>>
>>
>> I was waiting for that
>>
>>
>>
>> Thanks for all effort of the development team
>>
>>
>>
>> Regards,
>>
>>
>>
>>
>>
>> *From:* Dhis2-users [mailto:dhis2-users-bounces+nami_ghadri=
>> hotmail@lists.launchpad.net] *On Behalf Of *Lars Helge ?verland
>> *Sent:* Saturday, January 16, 2016 12:03 AM
>> *To:* DHIS 2 Users list <dhis2-users@lists.launchpad.net>; DHIS 2
>> Developers list <dhis2-d...@lists.launchpad.net>
>> *Subject:* [Dhis2-users] dhis version 2.22 is released
>>
>>
>>
>> Hi all,
>>
>>
>> DHIS version 2.22 is out with a lot of great new features and
>> improvements.
>>
>>
>>
>> Log in with admin/district on the demo <http://play.dhis2.org/demo/>
>> system.
>>
>>
>>
>> *Data elements and indicators app:* A completely new app for data
>> elements and indicators maintenance features a much slicker user
>> experience, with on-the-fly search, “access” and “last updated” visible in
>> the lists, a new group editor, and much better looks.
>>
>>
>>
>> Demo <https://play.dhis2.org/demo/dhis-web-maintenance/#/> | Screenshot 1
>> <https://www.dhis2.org/images/222/data-elements-indicators-1.png> | 2
>> <https://www.dhis2.org/images/222/data-elements-indicators-2.png> | 3
>> <https://www.dhis2.org/images/222/data-elements-indicators-3.png>
>>
>>
>>
>> *Integrated tracker analytics:* Tracker-type data elements, attributes
>> and program indicators can now be included in aggregate indicators. This
>> allows for creating integrated analysis through indicators where e.g. the
>> numerator is being collected in a program while the numerator is collected
>> in an aggregate form. This means that you can produce integrated analysis
>> without caring about whether the data comes from routine forms, anonymous
>> events or tracking.
>>
>>
>>
>> Demo 1
>> <https://play.dhis2.org/demo/dhis-web-pivot/index.html?id=Lcwp2jPNWIc> |
>> 2 <https://play.dhis2.org/demo/dhis-web-pivot/index.html?id=RCUE6hAisQN>
>> | Screenshot 1
>> <https://www.dhis2.org/images/222/programs-in-indicator-expression-editor.png>
>> | 2 <https://www.dhis2.org/images/222/program-indicator-pivot.png>
>>
>>
>>
>> *Multiple programs in favorites:* Data elements and attributes from any
>> number of programs can now be included in the same pivot table or chart
>> favorite.
>>
>>
>>
>> Demo
>> <https://play.dhis2.org/demo/dhis-web-pivot/index.html?id=hmhX7X8knJF> |
>> Screenshot
>> <https://www.dhis2.org/images/222/pivot-multiple-program-indicators.png>
>>
>>
>>
>> *File cloud storage in tracker:* The tracker capture and event capture
>> apps now support file storage for data elements of type file. This allows
>> you to use tracker as a document repository, and to upload documentation
>> and files related to events or people. Files can be stored either on the
>> Web server or sent directly to AWS S3 <https://aws.amazon.com/s3/> cloud
>> storage.
>>
>>
>>
>> Screenshot 1
>> <https://www.dhis2.org/images/222/tracker-capture-file-storage.png> | 2
>> <https://www.dhis2.org/images/222/event-capture-file-storage.png>
>>
>>
>>
>> *Tracker data audit:* Tracker capture and event capture now store the
>> audit trail of changes to data and make it readily available by clicking on
>> the audit icon next to each input field in the form. This is useful to view
>> historical changes to information and a requirement in many settings where
>> sensitive data is being stored.
>>
>>
>>
>> Screenshot <https://www.dhis2.org/images/222/tracker-capture-audit.png>
>>
>>
>>
>> *Improved tracker capture:* The tracker capture app has received a range
>> of improvements.
>>
>>
>>
>> - Yes/No fields are rendered as radio-buttons instead of drop-downs for
>> faster 

Re: [Dhis2-users] DHIS2, Docker and Cloud Deployment in a few steps... and free of charge

[Paulo Grácio]

Hi all,

new version is available.

https://github.com/pgracio/dhis2-docker
http://haproxy-af009260.pgracio.svc.tutum.io/

Have fun!

/ Paulo

On 2 May 2015 at 19:10, Paulo Grácio <paulogra...@gmail.com> wrote:

> Hi all,
>
> Today I have added a new section "Using tutum for DHIS2 containers cloud
> deployment" if it's somehow interesting to you please have a look.
>
> https://github.com/pgracio/dhis2-docker
>
> Final result is available here:
>
> http://web.dhis2.pgracio.svc.tutum.io:8080/
>
> This is still a draft version that can improve a lot and isn't, yet,
> recommended for production deployments. Have fun and share your thoughts...
>
> Regards,
> Paulo Grácio
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] server specification

[Paulo Grácio]

Really don't get your point Bob, just asked Nami a question... is there a
problem with that?

/Paulo

On 5 May 2015 at 10:01, Bob Jolliffe bobjolli...@gmail.com wrote:

 My goodness this seems to have pressed so many buttons for the cloud
 fetshists.  Would you ever just answer the question. There can be any
 number of good reasons why someone might be buying hardware.

 Nami, if you are buying/renting a virtual server I'd try out pretty
 small and see what you can get away with.  So something like 4G RAM
 and 2 cpus might well handle the load.  (Having 50 users is one thing
 but its also pretty variable depending on what those users are
 actually doing).   If you find yourself struggling you are going to
 need to increase but that is generally painless enough.  Thats a real
 benefit of cloud provisioning.

 If you are investing in physical hardware then do be sure to think a
 lot about some of Jason's points.  You need to think beyond a single
 machine and think about the environment, redundancy, off site backups
 etc.   All of which are perfectly possible to think about and manage
 Generally you will take the opposite approach from above and budget
 for more than you need to take into account growth etc, and just that
 you really don't want to be left short on what might be a long and
 arduous procurement process.  A possible sensible approach many
 organisations take is to invest big in hardware and then virtualize
 within it.

 After all that, a thumbsuck for a 50 user system . Quad core cpu
 with 32G RAM and 1TB of storage of which maybe 100G ssd.   Backup
 server with a big disk (and not much else).  Depending a lot really on
 where you are, maybe a tape drive for archive.

 On 5 May 2015 at 08:21, Paulo Grácio paulogra...@gmail.com wrote:
  Hi, why buy hardware and not go with cloud?
 
  Sent from my iPhone
 
  On 04 May 2015, at 15:32, Nami Ghadri nami_gha...@hotmail.com wrote:
 
  Hello,
 
 
 
  Thanks I saw that ,
 
 
 
  If I could have specification server that has been used in real world
 direct
  from users
 
 
 
  I am now In the stage of buying hardware so any advice would greater
 
 
 
  Thanks very much
 
 
 
  From: ronald munjoma [mailto:simb...@gmail.com]
  Sent: Monday, May 4, 2015 3:31 PM
  To: Nami Ghadri
  Cc: dhis2-users@lists.launchpad.net
  Subject: Re: [Dhis2-users] server specification
 
 
 
  Hi Nami,
 
 
 
  On 4 May 2015 at 13:19, Nami Ghadri nami_gha...@hotmail.com wrote:
 
  Hello,
 
 
 
  Could anyone give guidance about DHIS2/postgresql server hardware
  specification for about 50 user
 
 
 
  https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08.html#d5e413
 
 
 
  Best and Regards
 
  Ronald Munjoma
 
 
 
 
 
  Best regards,
 
 
 
 
  ___
  Mailing list: https://launchpad.net/~dhis2-users
  Post to : dhis2-users@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-users
  More help   : https://help.launchpad.net/ListHelp
 
 
 
 
 
  --
 
  Best and Regards
 
  Ronald Munjoma
 
  +263 775 625 283, +263 776 444 309
 
  ___
  Mailing list: https://launchpad.net/~dhis2-users
  Post to : dhis2-users@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-users
  More help   : https://help.launchpad.net/ListHelp
 
 
  ___
  Mailing list: https://launchpad.net/~dhis2-users
  Post to : dhis2-users@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-users
  More help   : https://help.launchpad.net/ListHelp
 




-- 
Paulo Grácio
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] server specification

[Paulo Grácio]

Hi, why buy hardware and not go with cloud?

Sent from my iPhone

 On 04 May 2015, at 15:32, Nami Ghadri nami_gha...@hotmail.com wrote:
 
 Hello,
  
 Thanks I saw that ,
  
 If I could have specification server that has been used in real world direct 
 from users
  
 I am now In the stage of buying hardware so any advice would greater
  
 Thanks very much
  
 From: ronald munjoma [mailto:simb...@gmail.com] 
 Sent: Monday, May 4, 2015 3:31 PM
 To: Nami Ghadri
 Cc: dhis2-users@lists.launchpad.net
 Subject: Re: [Dhis2-users] server specification
  
 Hi Nami,
  
 On 4 May 2015 at 13:19, Nami Ghadri nami_gha...@hotmail.com wrote:
 Hello,
  
 Could anyone give guidance about DHIS2/postgresql server hardware 
 specification for about 50 user
  
 ​https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08.html#d5e413
  
 Best and Regards
 Ronald Munjoma​
  
  
 Best regards,
  
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp
 
 
 
  
 --
 Best and Regards
 Ronald Munjoma
 +263 775 625 283, +263 776 444 309
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] DHIS2, Docker and Cloud Deployment in a few steps... and free of charge

[Paulo Grácio]

Hi all,

Today I have added a new section Using tutum for DHIS2 containers cloud
deployment if it's somehow interesting to you please have a look.

https://github.com/pgracio/dhis2-docker

Final result is available here:

http://web.dhis2.pgracio.svc.tutum.io:8080/

This is still a draft version that can improve a lot and isn't, yet,
recommended for production deployments. Have fun and share your thoughts...

Regards,
Paulo Grácio
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Getting exception when opening Tracker Capture

[Paulo Grácio]

postgres=# \c dhis2
You are now connected to database dhis2 as user postgres.
dhis2=# select * from version;
 versionid |versionkey| versionvalue
---+--+--
69 | organisationUnit | 1d366d70-3f79-49d1-9cb0-ab2959445f86
70 | organisationUnit | 562762ec-cee7-43aa-b29d-19ad52afb53a
(2 rows)

/Paulo Grácio


On 26 April 2015 at 03:38, Morten Olav Hansen morte...@gmail.com wrote:

 Ok, can you just verify that there are two rows in your version table?

 --
 Morten

 On Sat, Apr 25, 2015 at 8:29 PM, Paulo Grácio paulogra...@gmail.com
 wrote:

 Hi Morten,

 no metadata was created or imported. It's a complete clean installation
 that if you want you can easily try with Docker.

 https://github.com/pgracio/dhis2-docker

 Regards,
 Paulo


 On 25 April 2015 at 13:47, Morten Olav Hansen morte...@gmail.com wrote:

 How did you create the metadata, did you use any kind of import
 mechanism? I have seen this before, but haven't been able to reproduce it.

 --
 Morten

 On Sat, Apr 25, 2015 at 3:48 PM, Paulo Grácio paulogra...@gmail.com
 wrote:

 Hi Morten,

 this is a clean installation. shouldn't it be fixed on the application
 side?

 /Paulo

 On 25 April 2015 at 05:29, Morten Olav Hansen morte...@gmail.com
 wrote:

 Hi

 Go to your version table, and remove one (or both) of the entries with
 versionkey organisationUnit.

 --
 Morten

 On Sat, Apr 25, 2015 at 12:03 AM, Paulo Grácio paulogra...@gmail.com
 wrote:

 web_1 | * INFO  2015-04-24 17:00:55,890 Login success for user:
 'admin', ip: '192.168.59.3' (DefaultUserAuditService.java
 [http-bio-8080-exec-5])
 web_1 | * ERROR 2015-04-24 17:01:22,826 Error while executing action
 (ExceptionInterceptor.java [http-bio-8080-exec-4])
 web_1 | org.hibernate.NonUniqueResultException: query did not return
 a unique result: 2
 web_1 | at
 org.hibernate.internal.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:914)
 web_1 | at
 org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:396)
 web_1 | at
 org.hisp.dhis.version.hibernate.HibernateVersionStore.getVersionByKey(HibernateVersionStore.java:43)
 web_1 | at
 org.hisp.dhis.version.DefaultVersionService.getVersionByKey(DefaultVersionService.java:108)
 web_1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
 Method)
 web_1 | at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 web_1 | at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 web_1 | at java.lang.reflect.Method.invoke(Method.java:606)
 web_1 | at
 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
 web_1 | at
 org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
 web_1 | at
 org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
 web_1 | at
 org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
 web_1 | at
 org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)


 --
 Paulo Grácio

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





 --
 Paulo Grácio





-- 
Paulo Grácio
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Getting exception when opening Tracker Capture

[Paulo Grácio]

Thanks Lars, I did remove both, truncate table, and created a root
Oorganization Unit, also fixed the problem.
Once this is to create a docker image that users can use for demo/testing I
will update the image with the new build.

Regards,
/Paulo

On 26 April 2015 at 21:36, Lars Helge Øverland larshe...@gmail.com wrote:

 Hi Paulo,

 I suggest that you first clean it so that you have only unique versionkey
 values, then run these SQL statement to ensure that this problem does not
 come back:


 ALTER TABLE version ALTER COLUMN versionkey SET NOT NULL;
 ALTER TABLE version ADD CONSTRAINT version_versionkey_key
 UNIQUE(versionkey);


 I have also included this in the application startup routine.

 regards,

 Lars

 On Sun, Apr 26, 2015 at 1:11 PM, Paulo Grácio paulogra...@gmail.com
 wrote:

 postgres=# \c dhis2
 You are now connected to database dhis2 as user postgres.
 dhis2=# select * from version;
  versionid |versionkey| versionvalue
 ---+--+--
 69 | organisationUnit | 1d366d70-3f79-49d1-9cb0-ab2959445f86
 70 | organisationUnit | 562762ec-cee7-43aa-b29d-19ad52afb53a
 (2 rows)

 /Paulo Grácio


 On 26 April 2015 at 03:38, Morten Olav Hansen morte...@gmail.com wrote:

 Ok, can you just verify that there are two rows in your version table?

 --
 Morten

 On Sat, Apr 25, 2015 at 8:29 PM, Paulo Grácio paulogra...@gmail.com
 wrote:

 Hi Morten,

 no metadata was created or imported. It's a complete clean installation
 that if you want you can easily try with Docker.

 https://github.com/pgracio/dhis2-docker

 Regards,
 Paulo


 On 25 April 2015 at 13:47, Morten Olav Hansen morte...@gmail.com
 wrote:

 How did you create the metadata, did you use any kind of import
 mechanism? I have seen this before, but haven't been able to reproduce it.

 --
 Morten

 On Sat, Apr 25, 2015 at 3:48 PM, Paulo Grácio paulogra...@gmail.com
 wrote:

 Hi Morten,

 this is a clean installation. shouldn't it be fixed on the
 application side?

 /Paulo

 On 25 April 2015 at 05:29, Morten Olav Hansen morte...@gmail.com
 wrote:

 Hi

 Go to your version table, and remove one (or both) of the entries
 with versionkey organisationUnit.

 --
 Morten

 On Sat, Apr 25, 2015 at 12:03 AM, Paulo Grácio 
 paulogra...@gmail.com wrote:

 web_1 | * INFO  2015-04-24 17:00:55,890 Login success for user:
 'admin', ip: '192.168.59.3' (DefaultUserAuditService.java
 [http-bio-8080-exec-5])
 web_1 | * ERROR 2015-04-24 17:01:22,826 Error while executing
 action (ExceptionInterceptor.java [http-bio-8080-exec-4])
 web_1 | org.hibernate.NonUniqueResultException: query did not
 return a unique result: 2
 web_1 | at
 org.hibernate.internal.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:914)
 web_1 | at
 org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:396)
 web_1 | at
 org.hisp.dhis.version.hibernate.HibernateVersionStore.getVersionByKey(HibernateVersionStore.java:43)
 web_1 | at
 org.hisp.dhis.version.DefaultVersionService.getVersionByKey(DefaultVersionService.java:108)
 web_1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
 Method)
 web_1 | at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 web_1 | at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 web_1 | at java.lang.reflect.Method.invoke(Method.java:606)
 web_1 | at
 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
 web_1 | at
 org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
 web_1 | at
 org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
 web_1 | at
 org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
 web_1 | at
 org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)


 --
 Paulo Grácio

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





 --
 Paulo Grácio





 --
 Paulo Grácio

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


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

[Dhis2-users] Avoid database errors during first bootstrap

[Paulo Grácio]

Hi,

does anyone know the best way to get rid of the following errors during the
first bootstrap?

db_1  | 2015-02-25 23:43:37 UTC [728-1] dhis@dhis2 ERROR:  column
bounds of relation mapview does not exist
db_1  | 2015-02-25 23:43:37 UTC [728-2] dhis@dhis2 STATEMENT:  alter
table mapview drop column bounds
db_1  | 2015-02-25 23:43:37 UTC [729-1] dhis@dhis2 ERROR:  column
code of relation mapview does not exist
db_1  | 2015-02-25 23:43:37 UTC [729-2] dhis@dhis2 STATEMENT:  alter
table mapview drop column code
db_1  | 2015-02-25 23:43:37 UTC [730-1] dhis@dhis2 ERROR:  column
periodtypeid of relation mapview does not exist
db_1  | 2015-02-25 23:43:37 UTC [730-2] dhis@dhis2 STATEMENT:  alter
table mapview drop column periodtypeid
db_1  | 2015-02-25 23:43:37 UTC [732-1] dhis@dhis2 ERROR:  column
valuetype does not exist at character 50
db_1  | 2015-02-25 23:43:37 UTC [732-2] dhis@dhis2 STATEMENT:  update
mapview set valuetype='dataElement' where valuetype='dataelement'
db_1  | 2015-02-25 23:43:37 UTC [735-1] dhis@dhis2 ERROR:  column
name does not exist at character 19
db_1  | 2015-02-25 23:43:37 UTC [735-2] dhis@dhis2 STATEMENT:  select
mapviewid, name, userid, longitude, latitude, zoom from mapview where
mapviewid not in (select mapviewid from mapmapviews)


Regards,
-- 
Paulo Grácio
https://github.com/pgracio/dhis2-docker
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Getting exception when opening Tracker Capture

[Paulo Grácio]

Hi Morten,

no metadata was created or imported. It's a complete clean installation
that if you want you can easily try with Docker.

https://github.com/pgracio/dhis2-docker

Regards,
Paulo


On 25 April 2015 at 13:47, Morten Olav Hansen morte...@gmail.com wrote:

 How did you create the metadata, did you use any kind of import mechanism?
 I have seen this before, but haven't been able to reproduce it.

 --
 Morten

 On Sat, Apr 25, 2015 at 3:48 PM, Paulo Grácio paulogra...@gmail.com
 wrote:

 Hi Morten,

 this is a clean installation. shouldn't it be fixed on the application
 side?

 /Paulo

 On 25 April 2015 at 05:29, Morten Olav Hansen morte...@gmail.com wrote:

 Hi

 Go to your version table, and remove one (or both) of the entries with
 versionkey organisationUnit.

 --
 Morten

 On Sat, Apr 25, 2015 at 12:03 AM, Paulo Grácio paulogra...@gmail.com
 wrote:

 web_1 | * INFO  2015-04-24 17:00:55,890 Login success for user:
 'admin', ip: '192.168.59.3' (DefaultUserAuditService.java
 [http-bio-8080-exec-5])
 web_1 | * ERROR 2015-04-24 17:01:22,826 Error while executing action
 (ExceptionInterceptor.java [http-bio-8080-exec-4])
 web_1 | org.hibernate.NonUniqueResultException: query did not return a
 unique result: 2
 web_1 | at
 org.hibernate.internal.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:914)
 web_1 | at
 org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:396)
 web_1 | at
 org.hisp.dhis.version.hibernate.HibernateVersionStore.getVersionByKey(HibernateVersionStore.java:43)
 web_1 | at
 org.hisp.dhis.version.DefaultVersionService.getVersionByKey(DefaultVersionService.java:108)
 web_1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
 Method)
 web_1 | at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 web_1 | at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 web_1 | at java.lang.reflect.Method.invoke(Method.java:606)
 web_1 | at
 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
 web_1 | at
 org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
 web_1 | at
 org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
 web_1 | at
 org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
 web_1 | at
 org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)


 --
 Paulo Grácio

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





 --
 Paulo Grácio


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

[Dhis2-users] Getting exception when opening Tracker Capture

[Paulo Grácio]

web_1 | * INFO  2015-04-24 17:00:55,890 Login success for user: 'admin',
ip: '192.168.59.3' (DefaultUserAuditService.java [http-bio-8080-exec-5])
web_1 | * ERROR 2015-04-24 17:01:22,826 Error while executing action
(ExceptionInterceptor.java [http-bio-8080-exec-4])
web_1 | org.hibernate.NonUniqueResultException: query did not return a
unique result: 2
web_1 | at
org.hibernate.internal.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:914)
web_1 | at
org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:396)
web_1 | at
org.hisp.dhis.version.hibernate.HibernateVersionStore.getVersionByKey(HibernateVersionStore.java:43)
web_1 | at
org.hisp.dhis.version.DefaultVersionService.getVersionByKey(DefaultVersionService.java:108)
web_1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
web_1 | at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
web_1 | at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
web_1 | at java.lang.reflect.Method.invoke(Method.java:606)
web_1 | at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
web_1 | at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
web_1 | at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
web_1 | at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
web_1 | at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)


-- 
Paulo Grácio
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Can't run dhis2 from .war file

[Paulo Grácio]

 of computer viruses, we
 cannot guarantee that this email and any files transmitted with it are free
 from them.*N : Think before print do you really need this on paper.
 thanks




 --
 Knut Staring
 Dept. of Informatics, University of Oslo
 Norway: +4791880522
 Skype: knutstar
 http://dhis2.org

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



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




-- 
Paulo Grácio
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Fwd: DHIS2 and Docker

[Paulo Grácio]

Hi,

is anyone working on a Docker image(s) to create containers running DHIS2?
I'm starting doing some work on this subject, if you have any thought about
this let me know.

Regards,
-- 
Paulo Grácio
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Generating Analytics in Live version

[Paulo Grácio]

I’m also getting a similar problem…

 

* INFO  10:29:50,023 [Level: ERROR, category: DATAMART, time: Fri Dec 13 
10:29:50 GMT 2013, message: Process failed:

er-2])

* ERROR 10:29:50,123 Unexpected error occurred in scheduled task. 
(TaskUtils.java [taskScheduler-2])

java.lang.RuntimeException: Exception during execution

at 
org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)

at 
org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.ja

at 
org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:113)

at 
org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:95)

at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

at 
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl

at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecut

at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java

at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

at java.lang.Thread.run(Thread.java:662)

 

Regards,

Paulo Grácio

 

From: Dhis2-users 
[mailto:dhis2-users-bounces+pgracio=criticalsoftware@lists.launchpad.net] 
On Behalf Of Marta Vila
Sent: quinta-feira, 12 de Dezembro de 2013 11:55
To: Busoye Anifalaje
Cc: dhis2-users
Subject: Re: [Dhis2-users] Generating Analytics in Live version

 

Hi Busoye,

 

I followed your instructions but data was not there... :( 

 

Thanks!

 

On 11 December 2013 13:06, Busoye Anifalaje bus...@hisp.org wrote:

Hi Marta,

 

It is likely that there is no problem with your analytics generating and the 
error is actually related to the Data Mart (your error log also implies this is 
the case). I also found this error confusing the first time I saw it. Check 
your pivot table to confirm if your data is updated. You will be surprised that 
it's actually all there. 

 

 

Best 

 

Busoye

 

On 11 December 2013 11:01, Marta Vila martav...@gmail.com wrote:

Hi all,

 

I´m running a live version with data and metadata imported and it all works 
fine but I don´t find the way to generate the Analytic tables. 

 

If I run them manually I get this Process failed: Exception during execution   
(log attached). 

 

If I remember well it expects the tables to be generated by the automatic 
process so i scheduled the task yesterday to be executed daily and left the 
laptop on... but nothing changes... 

Maybe it got suspended and the task was never executed... (will change that now 
and lets see tomorrow) but anyway, if that is my problem, I suggest it may be 
useful to generate the tables even if the task is triggered manually for the 
first time. 

 

 

Version:

2.13

Build revision:

12908

Build date:

2013-12-04 16:24

 

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

 

 

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

Re: [Dhis2-users] using DHIS live with Demo database webserver doesn't start

[Paulo Grácio]

I did a merge to our branch a few minutes ago and create a new build. Going
to try with your build from last night.

 

Regards,

Paulo Grácio

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: quinta-feira, 5 de Dezembro de 2013 10:57
To: Paulo Grácio
Cc: Aad van Geldermalsen; DHIS 2 Users list
Subject: Re: [Dhis2-users] using DHIS live with Demo database webserver
doesn't start

 

Okay - did you try the Live download from dhis2.org from last night?

 

On Thu, Dec 5, 2013 at 11:56 AM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hi Lars,

 

I’m also facing a similar problem. The first time I start the service it
starts ok and I’m able to authentication with default admin user. If I
restart the service although I get a success message on log, trying to
access the application I get 

 

HTTP ERROR: 503

Problem accessing /. Reason:

SERVICE_UNAVAILABLE

Powered by Jetty://

 

Regards,

Paulo Grácio

 

From: Dhis2-users [mailto:dhis2-users-bounces+pgracio
mailto:dhis2-users-bounces%2Bpgracio
=criticalsoftware@lists.launchpad.net] On Behalf Of Lars Helge Øverland
Sent: quarta-feira, 4 de Dezembro de 2013 18:36
To: Aad van Geldermalsen
Cc: DHIS 2 Users list
Subject: Re: [Dhis2-users] using DHIS live with Demo database webserver
doesn't start

 

Hi Aad,

 

we have just made a fix to DHIS version 2.13 which solves an issue for
starting up on Live. Could you please download the latest one from here and
try again: http://www.dhis2.org/downloads

 

Re the database I suspect that you have not connected to Postgres but are
still running on H2.

 

regards,


Lars

 

 

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

Re: [Dhis2-users] using DHIS live with Demo database webserver doesn't start

[Paulo Grácio]

With yours is working fine… I have missed something during the merge or
build process … L

 

From: Dhis2-users
[mailto:dhis2-users-bounces+pgracio=criticalsoftware@lists.launchpad.net
] On Behalf Of Paulo Grácio
Sent: quinta-feira, 5 de Dezembro de 2013 11:00
To: 'Lars Helge Øverland'
Cc: 'DHIS 2 Users list'
Subject: Re: [Dhis2-users] using DHIS live with Demo database webserver
doesn't start

 

I did a merge to our branch a few minutes ago and create a new build. Going
to try with your build from last night.

 

Regards,

Paulo Grácio

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: quinta-feira, 5 de Dezembro de 2013 10:57
To: Paulo Grácio
Cc: Aad van Geldermalsen; DHIS 2 Users list
Subject: Re: [Dhis2-users] using DHIS live with Demo database webserver
doesn't start

 

Okay - did you try the Live download from dhis2.org from last night?

 

On Thu, Dec 5, 2013 at 11:56 AM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hi Lars,

 

I’m also facing a similar problem. The first time I start the service it
starts ok and I’m able to authentication with default admin user. If I
restart the service although I get a success message on log, trying to
access the application I get 

 

HTTP ERROR: 503

Problem accessing /. Reason:

SERVICE_UNAVAILABLE

Powered by Jetty://

 

Regards,

Paulo Grácio

 

From: Dhis2-users [mailto:dhis2-users-bounces+pgracio
mailto:dhis2-users-bounces%2Bpgracio
=criticalsoftware@lists.launchpad.net] On Behalf Of Lars Helge Øverland
Sent: quarta-feira, 4 de Dezembro de 2013 18:36
To: Aad van Geldermalsen
Cc: DHIS 2 Users list
Subject: Re: [Dhis2-users] using DHIS live with Demo database webserver
doesn't start

 

Hi Aad,

 

we have just made a fix to DHIS version 2.13 which solves an issue for
starting up on Live. Could you please download the latest one from here and
try again: http://www.dhis2.org/downloads

 

Re the database I suspect that you have not connected to Postgres but are
still running on H2.

 

regards,


Lars

 

 

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

[Dhis2-users] Homologous periods for indicators

[Paulo Grácio]

Hi,

 

One of the challenges that I have at the moment is the creation of an
indicator based on homologous period to have evolution. Any idea/suggestion?


 

For instance get Malaria deaths for period (2013) and Malaria deaths for
period-1 (2012).

 

Regards

 mailto:*%20your-email%20* Paulo Grácio

 

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

[Dhis2-users] Encoding problem

[Paulo Grácio]

Hi all,

 

Any idea of what might be causing this problem, please see attach. 

 

Regards,

Paulo Grácio

attachment: encoding.png___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] DHIS version 2.13 is released

[Paulo Grácio]

Hi,

 

Congratulations for this amazing achievement. We already have our team
playing around with it.

 

Great work!

 

Regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 

Skype: paulojrgracio

 http://www.criticalsoftware.co.uk/ Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45
Fax: (+258) 214 951 46

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

 

 

 

From: Dhis2-devs
[mailto:dhis2-devs-bounces+pgracio=criticalsoftware@lists.launchpad.net]
On Behalf Of Lars Helge Øverland
Sent: quinta-feira, 17 de Outubro de 2013 13:51
To: DHIS 2 Developers list; DHIS 2 Users list
Subject: [Dhis2-devs] DHIS version 2.13 is released

 

Hi all,

 

DHIS 2 version 2.13 is out. This release brings some great new features and
a much improved Web API. 

 

(Demo login is admin/district)

 

 

- Dashboard: We have a completely new dashboard which brings lots of new
features. It is focused around search - you can use the search area at the
top to look for and include maps, charts, pivot tables, users, reports by
clicking on Add in the search result. You can now have any number of
personal dashboards - for instance can create one for each subject you find
interesting and easily switch between them. You can put any number of items
on each dashboard and drag-and-drop to arrange them in your preferred order.
Maps and pivot tables can now be embedded directly (previously they appeared
as links). Dashboards can be shared with other users or group of users, just
like you do with charts and pivot tables. 

 

Check it out here
http://apps.dhis2.org/demo/dhis-web-dashboard-integration/index.action .

 

 

- Touch-device optimized data visualizer App
http://www.dhis2.org/doc/snapshot/en/user/html/ch26.html : We have a new
App which lets you do advanced analysis and visualize your data as a wide
range of charts, including bar, column, line, pie, area. It works similar to
current data visualizer module, only optimized for smartphones and tablets.
You can load any predefined chart and create new charts which later can be
saved as favorites. The app is web-based and therefore completely integrated
with the charts you create in the current visualizer module on the web. It
is pretty cool - try it out on your smartphone or tablet by pointing it to
http://apps.dhis2.org/demo
http://apps.dhis2.org/demo/dhis-web-dashboard-integration/index.action
and select smartphone as the log in option, or directly on the web.

 

- Apps are now completely integrated in the menu system, both in services
menu and in the system overview page
http://apps.dhis2.org/demo/dhis-web-commons-about/modules.action , and are
now first-class components in DHIS 2. On the demo you can check it out by
looking for Mobile visualizer. Apps are light-weight web applications
which can be uploaded through the user interface in the App management
module under maintenance. Read more about the app concept
https://developer.mozilla.org/en-US/Apps/Quickstart/Build/Intro_to_open_web
_apps  and apps http://www.dhis2.org/doc/snapshot/en/user/html/ch26.html
in DHIS 2. 

 

The mobile visualizer app can be downloaded from http://appstore.dhis2.org

 

 

- The analysis tools - GIS, visualizer (charts) and pivot table - now
feature more flexible selection of organisation units through three modes.
Select the mode by clicking the gear icon under organisation units. You
can select organisation units by levels, for instance you easily select all
facilities in a province by first selecting the province from the tree, then
the facility level in the level drop-down. You can select organisation units
by groups, for instance you can select a province and then all public
facilities inside it. You can also select multiple organisation units as
boundaries in GIS. This has been harmonized and works similarly across all
modules.

 

Screenshot select by level
http://www.dhis2.org/download/misc/ou-level-selection.png  | select by
group http://www.dhis2.org/download/misc/ou-group-selection.png 

 

 

- Data surveillance and alerts: We now have a new component for data
monitoring / surveillance and user alerts. It lets you monitor data, look
for outbreaks and send alerts to users for notifiable conditions like
measles, cholera and yellow fever outbreaks

[Dhis2-users] DHIS2 Use Cases

[Paulo Grácio]

Hi,

 

We all know that DHIS2 was developed having in mind Health Data Management.
Individual data records/Tracker are very specific to Health Data, but what
about Aggregated Data Collection Why not use DHIS2 to collect, aggregate and
visualize data from other areas. It’s just numbers right. What’s your
opinion about it? Do you know any successful use cases? 

 

Kind regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 

Skype: paulojrgracio

 http://www.criticalsoftware.co.uk/ Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45
Fax: (+258) 214 951 46

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

 

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

Re: [Dhis2-users] Setting Data Element number type

[Paulo Grácio]

Hi Lars,

We have already submitted our implementation for merging.
https://code.launchpad.net/~sis-ma/dhis2/SISMA-362

Any question let us know.

Regards,
Paulo Grácio

-Original Message-
From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: quinta-feira, 5 de Setembro de 2013 18:02
To: Gulam Khan
Cc: dhis2-users@lists.launchpad.net; Paulo Gracio; Fábio Ramos
Subject: Re: [Dhis2-users] Setting Data Element number type

Okay. So then I assume that you want integers, not decimal numbers.

I have written up a blueprint here, with some implementation notes under
whiteboard:

https://blueprints.launchpad.net/dhis2/+spec/zero-positive-int-dataelement-t
ype

Is this something that you / critical feel like taking on?

cheers

Lars




On Thu, Sep 5, 2013 at 5:16 PM, Gulam Khan gm-k...@criticalsoftware.com
wrote:
 Thanks for your answer Lars.

 Yes, is my requirement have the possibility to configure data elements 
 with positive numbers including 0.

 When setting up data elements, I tried number type: positive integer 
 and store zero data value Yes , but does not allow the use of zero. 
 (which make sense to use, I think).
 Gulam Khan
 Thanks

 Gulam Khan


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




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

[Dhis2-users] Std Dev Outlier Analysis

[Paulo Grácio]

Hi all,

 

I’m trying to use Std Dev Outlier Analysis using demo installation without
success. Depending on the filter selection I’m getting

 

-  Analysing data, please wait , and never ends;

-  No values found.

 

Do you have a filter sample where you succeed to have results?

 

Regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 

Skype: paulojrgracio

 http://www.criticalsoftware.co.uk/ Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45
Fax: (+258) 214 951 46

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

 

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

Re: [Dhis2-users] Complete DataSets after bulk data values import

[Paulo Grácio]

Hi thanks for the advice.

 

This SQL solution works for me once I’m importing historical data and all
datasets will be marked as complete for past periods.

 

Regards,

Paulo Grácio

 

From: Dhis2-users
[mailto:dhis2-users-bounces+pgracio=criticalsoftware@lists.launchpad.net
] On Behalf Of Jason Pickering
Sent: quinta-feira, 8 de Agosto de 2013 07:45
To: Ola Hodne Titlestad
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Complete DataSets after bulk data values import

 

I think you will also need the date which the dataset was completed.
Again, this is fairly subjective about when the data would have been
completed, but you could set it to some date after the end date of the
period. 

 

Here is some SQL for Postgres which  I have used for this type of operation
which may help you get started. This will delete all existing records for a
given dataset, which you may or may not want. 

 

 

--Change this to the datasetID you wish to update. 

DELETE FROM completedatasetregistration where datasetid = 3438;

--Set to 15 days after the end date of the period

 INSERT INTO completedatasetregistration

 SELECT DISTINCT 3438::integer as datasetid,a.periodid, a.sourceid,
(b.enddate+'15 days'::interval)::date as date,'admin'::character
varying(255) as storedby  from datavalue a

INNER JOIN period b on a.periodid = b.periodid

 where a.dataelementid

IN (SELECT DISTINCT dataelementid from datasetmembers where datasetid
=3438);

 

Of course, you could create some procedural code/SQL to loop over a number
of datasets if you need to. 

 

Regards,

Jason

 

 

On Wed, Aug 7, 2013 at 9:50 PM, Ola Hodne Titlestad ol...@ifi.uio.no
wrote:

While waiting for the new feature a workaround would be to do some sql
statements directly on the database and insert new records into the
completedatasetregistration table for the orgunit, period, dataset
combinations where you have complete data. How you define complete would
then be an objective evaluation based on the data values you have imported,
e.g. where a specific data element is present or where there is at least one
value for any of the data elements in the dataset.

Ola
--

On 7 Aug 2013 20:41, Lars Helge Øverland larshe...@gmail.com wrote:

Hello Paulo,

 

sorry to say we don't support bulk complete data set registrations yet. 

 

We plan to fix this by including it directly in the XML/JSON export files.
Its on the plan for 2.13:

 

https://blueprints.launchpad.net/dhis2/+spec/complete-registrations-datavalu
e-exchange

 

regards,

 

Lars

 

 

On Mon, Aug 5, 2013 at 8:15 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hi all,

After Sending large bulks of data values how do you think is the best way to
mark data sets as complete?

Regards,

Paulo Grácio

 


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

 


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


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

 

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

Re: [Dhis2-users] Is it possible to have a Pivot Table with Data Elements associated with different Combination of Categories?

[Paulo Grácio]

Thanks Lars, I’ll give it a try with the snapshot version!

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: segunda-feira, 22 de Julho de 2013 22:40
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Is it possible to have a Pivot Table with Data
Elements associated with different Combination of Categories?

 

Ops that feature is in latest development version but not in 2.12 I can see
now. Sorry about that. You might want to run latest version if you are in
prototyping phase and not in production.

 

http://apps.dhis2.org/dev/dhis-web-pivot/app/index.html

 

 

 

On Mon, Jul 22, 2013 at 10:34 PM, Paulo Grácio
pgra...@criticalsoftware.com wrote:

Hi Lars,

 

Where do I switch from Totals to Details, I can’t find that option.

 

Regards,

Paulo Grácio

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: segunda-feira, 22 de Julho de 2013 21:48
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Is it possible to have a Pivot Table with Data
Elements associated with different Combination of Categories?

 

Hi Paulo,

 

one solution would be, in data elements section, to switch from Totals to
Details. Now you can select freely from data element + category option
combinations and insert them into your table, irrespective of which category
combination they belong to.

 

Lars

 

On Mon, Jul 22, 2013 at 9:33 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hi all,

 

Is it possible to have a Pivot Table with Data Elements associated with
different Combination of Categories? If not, is there a way to create a
single report with multiple Report Tables?

 

Regards,

Paulo Grácio

 


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

 

 

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

Re: [Dhis2-users] FRED API

[Paulo Grácio]

Hi, you are absolutely right, thanks for the tip.

 

Regards,

Paulo Grácio

 

From: Morten Olav Hansen [mailto:morte...@gmail.com] 
Sent: quinta-feira, 18 de Julho de 2013 12:29
To: Paulo Grácio
Cc: DHIS 2 developers; dhis2-users
Subject: Re: [Dhis2-users] FRED API

 

When you get these 400 errors, ot might be a good idea to use jsonlint.org to 
check your json

On Jul 18, 2013 5:26 PM, Morten Olav Hansen morte...@gmail.com wrote:

Hi, json requires properly quoted key. So you need to use name: 

On Jul 17, 2013 6:04 PM, Paulo Grácio pgra...@criticalsoftware.com wrote:

Hi there,

 

I was trying to get started with FRED API following the documentation that can 
be found here

 

 http://www.dhis2.org/doc/snapshot/en/user/html/ch25s21.html 
http://www.dhis2.org/doc/snapshot/en/user/html/ch25s21.html

 

Get all facilities or Get a specific facility based on either UID or UUID I 
already can do, but I'm struggling to create a new Facility.  The example has

 

curl -u username:password -X POST -d @new_facility.json  -H Content-Type: 
application/json http:// http://%3cserver-url%3e/api-fred/v1/facilities.json 
server-url/api-fred/v1/facilities.json

 

but I couldn’t find the content of the file new_facility.json.  Based on 
specification,  http://facilityregistry.org/#create-facility 
http://facilityregistry.org/#create-facility, we only need to specify facility 
name like this:

 

{

name: Kakamega HC

}

 

Running 

curl -u admin:district -X POST -d @demo.json -H Content-Type: 
application/json http://localhost:8081/api-fred/v1/facilities.json 

 

I’m getting always Error 400 - the request sent by the client was syntactically 
incorrect.

 

Kind regards,

Paulo Grácio


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

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

[Dhis2-users] FRED API

[Paulo Grácio]

Hi there,

 

I was trying to get started with FRED API following the documentation that
can be found here

 

 http://www.dhis2.org/doc/snapshot/en/user/html/ch25s21.html
http://www.dhis2.org/doc/snapshot/en/user/html/ch25s21.html

 

Get all facilities or Get a specific facility based on either UID or UUID I
already can do, but I'm struggling to create a new Facility.  The example
has

 

curl -u username:password -X POST -d @new_facility.json  -H Content-Type:
application/json http://
http://%3cserver-url%3e/api-fred/v1/facilities.json
server-url/api-fred/v1/facilities.json

 

but I couldn’t find the content of the file new_facility.json.  Based on
specification,  http://facilityregistry.org/#create-facility
http://facilityregistry.org/#create-facility, we only need to specify
facility name like this:

 

{

name: Kakamega HC

}

 

Running 

curl -u admin:district -X POST -d @demo.json -H Content-Type:
application/json http://localhost:8081/api-fred/v1/facilities.json 

 

I’m getting always Error 400 - the request sent by the client was
syntactically incorrect.

 

Kind regards,

Paulo Grácio

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

[Dhis2-users] Bandwidth

[Paulo Grácio]

Hi,

 

Based on your experience what do you consider to be a reasonable Bandwidth
value for 300 concurrent users?

 

Regards,

Paulo Grácio

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

[Dhis2-users] Define week start day for Weekly periods

[Paulo Grácio]

Hi, 

 

Is there a way to define week start day for Weekly periods?

 

Regards,

Paulo Grácio

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

Re: [Dhis2-users] NULL error when trying to set Min-Max values (extra fields in db table)

[Paulo Grácio]

Hello,

 

TableAlteror.java

executeSql( ALTER TABLE minmaxdataelement RENAME minvalue TO minimumvalue );

executeSql( ALTER TABLE minmaxdataelement RENAME maxvalue TO maximumvalue );

 

It looks like minvalue and maxvalue are no longer used. Maybe dropping those 
columns will solve your problem.

 

Regards,

Paulo Grácio

From: Dhis2-users 
[mailto:dhis2-users-bounces+pgracio=criticalsoftware@lists.launchpad.net] 
On Behalf Of Knut Staring
Sent: quinta-feira, 18 de Abril de 2013 14:01
To: dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] NULL error when trying to set Min-Max values (extra 
fields in db table)

 

Using 2.11 with a recent Chrome:

 

Manually setting Min-Max values for a particular data element/catcombo field in 
the data entry seems to work fine in the online demo. It also works fine in my 
local installation which uses the demo db - but on the machines of many of my 
colleagues the values are not saved (the fields become red instead of green).

 

There seems to be a problem with my minmaxdataelement table - it contains *both*

minvalue, maxvalue *and* minimumvalue, maximumvalue

 

I suppose there is some SQL that should be run to fix this?

 

The log says the following:

 

 ERROR 12:51:54,297 Error while executing action (ExceptionInterceptor.java 
[9426007@qtp-30488988-48])

org.springframework.dao.DataIntegrityViolationException: ERROR: null value in 
column minvalue violates not-null constraint

  Detail: Failing row contains (1921, 371, 44, 15, null, null, f, 10, 20).; SQL 
[n/a]; constraint [minvalue]; nested exception is 
org.hibernate.exception.ConstraintViolationException: ERROR: null value in 
column minvalue violates not-null constraint

  Detail: Failing row contains (1921, 371, 44, 15, null, null, f, 10, 20).

at 
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:138)

at 
org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:594)

at 
org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:476)

at 
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)

at 
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)

at 
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:387)

at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)

at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at 
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)

at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy59.addMinMaxDataElement(Unknown Source)

at 
org.hisp.dhis.de.action.SaveMinMaxLimitsAction.execute(SaveMinMaxLimitsAction.java:153)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

 

-- 

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org 

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

Re: [Dhis2-users] Metadata Export - Metada Import in DHIS2 Live

[Paulo Grácio]

Hello Augusto,

 

We were just trying the import/export new functionality. But thanks for the
help.

 

As I can see you have 1782 Organization Units, including national, provinces
and districts, are these all the existent in the country? Is this an
official list?

How were the codes defined for each Organisation Unit?

 

Many thanks for your help.

 

Regards,

Paulo

 

From: Orvalho Augusto [mailto:orvaq...@gmail.com] 
Sent: quinta-feira, 18 de Abril de 2013 08:21
To: Paulo Grácio
Cc: Morten Olav Hansen; dhis2-users; David Mendes
Subject: Re: [Dhis2-users] Metadata Export - Metada Import in DHIS2 Live

 

Hello Paulo!

Sorry for my intrusion. Do you want the organization unities from
Mozambique? 

I have them as metadata you can try to use them.

Orvalho

 

On Wed, Apr 17, 2013 at 4:31 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hi, Morten, comments in-line. 

 

Thanks,

Paulo

 

From: Morten Olav Hansen [mailto:morte...@gmail.com] 
Sent: quarta-feira, 17 de Abril de 2013 16:09
To: Paulo Grácio
Cc: dhis2-users; David Mendes


Subject: Re: [Dhis2-users] Metadata Export - Metada Import in DHIS2 Live

 

 

On Wed, Apr 17, 2013 at 9:03 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

-  Users are not created;

-  Organization Unit levels broken;


User import is  not supported in 2.11, hoping to have it in 2.12.

[Paulo Grácio] Ok, I was assuming that if you have export you would also
have import J.

What do you mean broken? Remember that you have to go into maintenance -
organisation units - organisation units levels after doing the import, to
be sure that all levels are updated.

[Paulo Grácio] We did run the import a second time, using same file, and
levels are now ok, maybe we did something wrong the first time.


--
Morten


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

 

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

Re: [Dhis2-users] Metadata Export - Metada Import in DHIS2 Live

[Paulo Grácio]

Hi, Morten, comments in-line. 

 

Thanks,

Paulo

 

From: Morten Olav Hansen [mailto:morte...@gmail.com] 
Sent: quarta-feira, 17 de Abril de 2013 16:09
To: Paulo Grácio
Cc: dhis2-users; David Mendes
Subject: Re: [Dhis2-users] Metadata Export - Metada Import in DHIS2 Live

 

 

On Wed, Apr 17, 2013 at 9:03 PM, Paulo Grácio pgra...@criticalsoftware.com 
wrote:

-  Users are not created;

-  Organization Unit levels broken;


User import is  not supported in 2.11, hoping to have it in 2.12.

[Paulo Grácio] Ok, I was assuming that if you have export you would also have 
import J.



What do you mean broken? Remember that you have to go into maintenance - 
organisation units - organisation units levels after doing the import, to be 
sure that all levels are updated.

[Paulo Grácio] We did run the import a second time, using same file, and levels 
are now ok, maybe we did something wrong the first time.


--
Morten

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

Re: [Dhis2-users] Fwd: Improving Tomcat memory parameters

[Paulo Grácio]

Hi,

 

“We've experienced the pain of tomcat crashing on an OpenMRS 1.9.3
production server with this memory error:  Java.lang.OutOfMemoryError:
PermGen

· The server has 32GB of RAM.  

· tomcat is  using JAVA_OPTS = -Xmx512m -Xms512m -XX:PermSize=256m
-XX:MaxPermSize=256m -XX:NewSize=128m”

 

The JVM has a lot of optimization and intelligence for dynamic memory
allocation, so doing things like making -Xms equal to -Xmx or-XX:PermSize
equal to -XX:MaxPermSize  will remove some of the optimizations the JVM can
apply to its allocation strategies and therefor reduce your application
performance instead of improving it.

 

Note that these parameters always depend on your application. So the best
way is to monitor memory consumption of your app to perform some tuning.
Jconsole can be your best friend.

 
http://docs.oracle.com/javase/6/docs/technotes/guides/management/jconsole.h
tml
http://docs.oracle.com/javase/6/docs/technotes/guides/management/jconsole.ht
ml

 

Regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 

 http://www.criticalsoftware.co.uk Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45
Fax: (+258) 214 951 46

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

 

 

 

From: Dhis2-users
[mailto:dhis2-users-bounces+pgracio=criticalsoftware@lists.launchpad.net
] On Behalf Of Orvalho Augusto
Sent: segunda-feira, 15 de Abril de 2013 09:48
To: Knut Staring
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Fwd: Improving Tomcat memory parameters

 

Great!!!

Needless to say on a 64bit machine. And are you usinge an enterprise kernel
(from Red Hat Enterprise or CentOS one)?

Thank you

Caveman

 

On Mon, Apr 15, 2013 at 9:38 AM, Knut Staring knu...@gmail.com wrote:

This discussion can be of interest to DHIS2 administrators as well.

-- Forwarded message --
From: James Arbaugh jarba...@hashaiti.org
Date: Sun, Apr 14, 2013 at 10:25 PM
Subject: RE: Improving Tomcat memory parameters
To: implement...@openmrs.org



Hi Ellen,

 

We ran into those painful problems in the past too.  One thing we did was
added a crontab job to restart tomcat automatically during the night twice a
week as “preventative” maintenance.

 

FYI: our production server (with 46GB physical memory) runs stable with the
following tomcat configuration…

CATALINA_OPTS=-Xms10240m -XX:PermSize=6144m -XX:MaxPermSize=6144m
-XX:NewSize=4096m

 

Thanks,

James

 

From: implement...@openmrs.org [mailto:implement...@openmrs.org] On Behalf
Of Ellen Ball
Sent: Thursday, April 11, 2013 5:33 PM
To: implement...@openmrs.org
Subject: Improving Tomcat memory parameters
Importance: Low

 

We've experienced the pain of tomcat crashing on an OpenMRS 1.9.3 production
server with this memory error:  Java.lang.OutOfMemoryError:  PermGen

*   The server has 32GB of RAM.  
*   tomcat is  using JAVA_OPTS = -Xmx512m -Xms512m -XX:PermSize=256m
-XX:MaxPermSize=256m -XX:NewSize=128m

Has anyone else seen this error?  Has anyone experimented with increased
memory parameter values?  It seems that the Xmx and Xms values should be the
same for a server (In a server environment, you normally want Xms and Xmx
set to the same value to avoid heap thrashing.).  The heap space shouldn't
be too high, but if anyone know the optimal size that would be helpful.

 

Thanks,

 

Ellen Ball

Partners In Health

 

 

-- 
OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implement...@openmrs.org
Unsubscribe: implementers+unsubscr...@openmrs.org
Manage your OpenMRS subscriptions at https://id.openmrs.org/
 
 

-- 
OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implement...@openmrs.org
Unsubscribe: implementers+unsubscr...@openmrs.org
mailto:implementers%2bunsubscr...@openmrs.org 
Manage your OpenMRS subscriptions at https://id.openmrs.org/
 
 





 

-- 

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522 tel:%2B4791880522 

http://dhis2.org 


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

 

___
Mailing

Re: [Dhis2-users] Looking for detailed documentation

[Paulo Grácio]

Hi,

 

In fact, as far as I know, all the existent documentation is here

 

 http://www.dhis2.org/documentation http://www.dhis2.org/documentation

 

“We are trying to find documentation that explains the behavior in the
custom data entry form depending on the data element’s data type selected.”

From my experience the best way is to play around with the different data
types, not that many, and see how it works.

 

“text with set option (should this display a select box?)”

Depends on the domain type of your data element, there is a feature request
for next version.

 https://blueprints.launchpad.net/dhis2/+spec/option-set-aggregate
https://blueprints.launchpad.net/dhis2/+spec/option-set-aggregate

 

Kind regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 

 http://www.criticalsoftware.co.uk Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45
Fax: (+258) 214 951 46

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

 

 

From: Dhis2-users
[mailto:dhis2-users-bounces+pgracio=criticalsoftware@lists.launchpad.net
] On Behalf Of PIEVAROLI, Liliana Marcela
Sent: terça-feira, 16 de Abril de 2013 17:38
To: dhis2-users@lists.launchpad.net
Cc: SCHNITZLER, Johannes Christof
Subject: [Dhis2-users] Looking for detailed documentation

 

Hi there,

 

We are trying to build a custom data entry form for case-based data (for a
single-event without registration program).

We encounter some issues, we tried to look for the answers in the existing
DHIS2.org documentation but the information we found is not detailed enough.

 

We are trying to find documentation that explains the behavior in the custom
data entry form depending on the data element’s data type selected.

Yes only (will this be a checkbox in the form?); text with set option
(should this display a select box?)

 

Looking forward to any documentation that can help us!

 

Thanks, 

Liliana and Johannes

 

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

[Dhis2-users] Metadata Export - Metada Import in DHIS2 Live

[Paulo Grácio]

Hello folks,

 

At this moment we are trying to simulate the procedure to copy meta-data
configuration from central server to off-line instances.

-  Step 1: Using Metadata Export we select all options and generate
a zipped xml file.

-  Step 2: When running import it removes all authorities associated
to user admin(default one), even when you use dry run. Is this expected? 

 

To overcome this problem we created a new system user in the off-line
installation and executed again step 2. This executes import without errors
but no users are created although they are in the xml file. 

 

Version: 2.11

Build revision: 10426

Build date: 2013-03-30 13:56

 

Regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 

 http://www.criticalsoftware.co.uk Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45
Fax: (+258) 214 951 46

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

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

Re: [Dhis2-users] Custom forms - Pagination/Section

[Paulo Grácio]

Thanks Lars, up and running.

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: segunda-feira, 8 de Abril de 2013 17:02
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Custom forms - Pagination/Section

 

Hi Paolo,

 

I tested on the demo and it worked well.. Note that I have only tested on
version 2.11. You can view a full example from EPI stock data set at the
demo now. 

 

http://apps.dhis2.org/demo/dhis-web-dataentry/index.action

 

http://apps.dhis2.org/demo/dhis-web-maintenance-dataset/viewDataEntryForm.ac
tion?dataSetId=1149441

 

 

You need to hurry as the database is reset nightly ;)

 

 

 

cheers

 

Lars

 

 

On Wed, Apr 3, 2013 at 11:40 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

L not getting there. If for instance you have a complete html custom form
definition with a sample working I would appreciate.

 

Regards,

Paulo Grácio

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: quarta-feira, 3 de Abril de 2013 19:19


To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Custom forms - Pagination/Section

 

Sorry seems I was a bit quick. You need to add another div with class cent
and an h3 as well. So like this:

 

 

div class=formSection

div class=centh3Name of section goes here/h3/div

 

// section html here

 

/div

 

 

 

 

On Wed, Apr 3, 2013 at 6:54 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hi Lars,

 

Is this a specific functionality of version 2.11? 

 

Inspecting the code generated when displaying a Section Form we have

 

table style=margin-bottom: 20px; display: table; class=formSection

(…)

/table

 

So what I didn’t figure out is how just adding  div class=formSection
will make parameter “Filter on section” appear… doing what you said just
added a new border to my tables according to css 

 

.formSection {

border: 1px solid #C0C0C0;

border-radius: 3px 3px 3px 3px;

padding: 10px;

}

 

Is this a sign that I’m not a developer J?!

 

Kind regards,

Paulo Grácio

 

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: quarta-feira, 3 de Abril de 2013 18:03
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Custom forms - Pagination/Section

 

Hi Paulo,

 

there is way for developers. Don't try this at home.

 

In custom form editor, view the source. Wrap the HTML contents that you want
to appear as a section in a div and add a class formSection to it,
something like:

 

div class=formSection

 

// Stuff that makes up a section here

 

/div

 

You should now be able to use the section drop-down that appears for section
forms in data entry.

 

Lars

 

 

 

 

 

 

On Wed, Apr 3, 2013 at 5:24 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hello there,

 

Is there a simple way to add sections or pagination to a custom form? The
goal is to avoid scroll when dealing with long forms.

 

Kind regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 tel:%28%2B258%29%20822%20544%20603  

 http://www.criticalsoftware.co.uk Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45 tel:%28%2B258%29%20214%20951%2045 
Fax: (+258) 214 951 46 tel:%28%2B258%29%20214%20951%2046 

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

 


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

 

 

 

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

Re: [Dhis2-users] Custom forms - Pagination/Section

[Paulo Grácio]

Hi Lars,

 

Is this a specific functionality of version 2.11? 

 

Inspecting the code generated when displaying a Section Form we have

 

table style=margin-bottom: 20px; display: table; class=formSection

(…)

/table

 

So what I didn’t figure out is how just adding  div class=formSection
will make parameter “Filter on section” appear… doing what you said just
added a new border to my tables according to css 

 

.formSection {

border: 1px solid #C0C0C0;

border-radius: 3px 3px 3px 3px;

padding: 10px;

}

 

Is this a sign that I’m not a developer J?!

 

Kind regards,

Paulo Grácio

 

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: quarta-feira, 3 de Abril de 2013 18:03
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Custom forms - Pagination/Section

 

Hi Paulo,

 

there is way for developers. Don't try this at home.

 

In custom form editor, view the source. Wrap the HTML contents that you want
to appear as a section in a div and add a class formSection to it,
something like:

 

div class=formSection

 

// Stuff that makes up a section here

 

/div

 

You should now be able to use the section drop-down that appears for section
forms in data entry.

 

Lars

 

 

 

 

 

 

On Wed, Apr 3, 2013 at 5:24 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hello there,

 

Is there a simple way to add sections or pagination to a custom form? The
goal is to avoid scroll when dealing with long forms.

 

Kind regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 tel:%28%2B258%29%20822%20544%20603  

 http://www.criticalsoftware.co.uk Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45 tel:%28%2B258%29%20214%20951%2045 
Fax: (+258) 214 951 46 tel:%28%2B258%29%20214%20951%2046 

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

 


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

 

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

Re: [Dhis2-users] Custom forms - Pagination/Section

[Paulo Grácio]

L not getting there. If for instance you have a complete html custom form
definition with a sample working I would appreciate.

 

Regards,

Paulo Grácio

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: quarta-feira, 3 de Abril de 2013 19:19
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Custom forms - Pagination/Section

 

Sorry seems I was a bit quick. You need to add another div with class cent
and an h3 as well. So like this:

 

 

div class=formSection

div class=centh3Name of section goes here/h3/div

 

// section html here

 

/div

 

 

 

 

On Wed, Apr 3, 2013 at 6:54 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hi Lars,

 

Is this a specific functionality of version 2.11? 

 

Inspecting the code generated when displaying a Section Form we have

 

table style=margin-bottom: 20px; display: table; class=formSection

(…)

/table

 

So what I didn’t figure out is how just adding  div class=formSection
will make parameter “Filter on section” appear… doing what you said just
added a new border to my tables according to css 

 

.formSection {

border: 1px solid #C0C0C0;

border-radius: 3px 3px 3px 3px;

padding: 10px;

}

 

Is this a sign that I’m not a developer J?!

 

Kind regards,

Paulo Grácio

 

 

From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
Sent: quarta-feira, 3 de Abril de 2013 18:03
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Custom forms - Pagination/Section

 

Hi Paulo,

 

there is way for developers. Don't try this at home.

 

In custom form editor, view the source. Wrap the HTML contents that you want
to appear as a section in a div and add a class formSection to it,
something like:

 

div class=formSection

 

// Stuff that makes up a section here

 

/div

 

You should now be able to use the section drop-down that appears for section
forms in data entry.

 

Lars

 

 

 

 

 

 

On Wed, Apr 3, 2013 at 5:24 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hello there,

 

Is there a simple way to add sections or pagination to a custom form? The
goal is to avoid scroll when dealing with long forms.

 

Kind regards,

 mailto:*%20your-email%20* Paulo Grácio
Technical Manager
(+258) 822 544 603 tel:%28%2B258%29%20822%20544%20603  

 http://www.criticalsoftware.co.uk Critical Software Mozambique
Dependable Technologies for Critical Systems

Critical Software Mozambique is a subsidiary of  http://cmmiinstitute.com/
Critical Software, a CMMI® Level 5 rated Company
CMMI® is registered in the USPTO by  http://www.cmu.edu/ CMU

Rua Pereira Marinho, 179
Bairro de Sommerchield
Maputo
Moçambique
Phone: (+258) 214 951 45 tel:%28%2B258%29%20214%20951%2045 
Fax: (+258) 214 951 46 tel:%28%2B258%29%20214%20951%2046 

DISCLAIMER: This message is confidential and may contain privileged
information. It is for use only by the people or entities to whom it is
addressed. If you are not an intended recipient, you should not disclose,
distribute, copy, print, rely on or otherwise make use of this message. If
an addressing or transmission error has misdirected it to you we would be
grateful if you would please notify the sender by return, before deleting it
from your system.

 


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

 

 

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

[Dhis2-users] Population Definition

[Paulo Grácio]

Hello,

 

I’m trying to figure out the best way to define population in a way that it
can be used to calculate indicators. We have population values, lowest level
is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female)
and area(rural, urban).

 

Based on you experience what do you consider to be the best approach for
this?

 

Kind regards,

Paulo Grácio

 

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

Re: [Dhis2-users] Population Definition

[Paulo Grácio]

@Randy, your solutions seems to be easiest once it reduces the amount of
data to upload, but at the moment our requirement is to have population data
structured as defined by National Institute of Statistics - NIS. 

@Rodolfo, I guess we are at the same step. We are trying to setup an initial
version of dhis2 for some Workshops, and your approach is in the way of what
we need. Now I just need to create a procedure to automatically load all the
data from the source, NIS excel files.

 

Kind regards,

Paulo Grácio 

 

From: Wilson,Randy [mailto:rwil...@msh.org] 
Sent: terça-feira, 26 de Março de 2013 18:24
To: Rodolfo Melia; Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Population Definition

 

In Rwanda, we have tried to keep things simple by entering only total
population figures for province, district, sector and health facility levels
for each year.

 

We have then created indicators for each of the major target population
groups by using census breakdowns and multiplying the total population by
the following factors (we’re still waiting for results of 2012 census to
update some of these): 

 


Children 0 - 11 months

4.10%


Children 1 - 4 years

12.10%


Children 5 - 14 years

27.50%


Children  15 years

43.70%


Population = 15 years

56.30%


Children under 5 years

16.20%


Expected Pregnancies

4.10%


Women of reproductive age

23.60%

 

If your administrative units are very diverse this approach might not work,
but it certainly simplifies analysis and people are less inclined to use
smaller denominators to make their performance look better.

 

Randy

 

From: dhis2-users-bounces+rwilson=msh@lists.launchpad.net
[mailto:dhis2-users-bounces+rwilson=msh@lists.launchpad.net] On Behalf
Of Rodolfo Melia
Sent: Tuesday, March 26, 2013 6:11 PM
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Population Definition

 

So far (I'm only doing tests, no yet in production), I have imported
population data using a dataset with annual data collection, populating
2012, 13 and 14 with the same data, so I can do indicator calculations on
those years.

 

For your case, I will create 3 data elements, each one associated to a
category combination for Age, Gender and Area.

 

Rodolfo

On Tue, Mar 26, 2013 at 3:53 PM, Paulo Grácio pgra...@criticalsoftware.com
wrote:

Hello,

 

I’m trying to figure out the best way to define population in a way that it
can be used to calculate indicators. We have population values, lowest level
is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female)
and area(rural, urban).

 

Based on you experience what do you consider to be the best approach for
this?

 

Kind regards,

Paulo Grácio

 


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





 

-- 

Rodolfo Meliá

Principal

rme...@knowming.com

www.knowming.com

+1 708 872 7636

+44 777 576 4090

Skype: rod.melia

Twitter: @RodolfoMelia https://twitter.com/RodolfoMelia 

 

Note: Please note my new email address, which I will be using for PSI
related work: rme...@knowming.com

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

[Dhis2-users] Search mailing list archive

[Paulo Grácio]

Is there a way to do a search on dhis2-users team mailing list archive? What
am I missing L

 

 https://lists.launchpad.net/dhis2-users/
https://lists.launchpad.net/dhis2-users/

 

Regards,

Paulo Grácio

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

Re: [Dhis2-users] DHIS version 2.11 is released

[Paulo Grácio]

Congratulations for the achivement!

Is there any information about how to upgrade from version 2.10 to 2.11?

Kind regards,
Paulo Grácio

On 22 March 2013 19:05, Lars Helge Øverland larshe...@gmail.com wrote:

 Hi all,

 DHIS version 2.11 is out and we have some great features for you:


 - Web-based pivot table: Allows you to create pivot tables with data
 aggregated along all data dimensions, including data element/organisation
 unit group sets. Data dimensions can be arranged freely on columns, rows and
 as filters. You can include totals and subtotals on all axis and control the
 table density and font size under options. Your pivots can be saved as
 favorites and downloaded to your local computer. This design goal is to
 allow users to create their own reports with the data they need without any
 involvement of super-users.

 A pivot table with immunization indicators for last 4 quarters by facility
 ownership, type and location can be made like this (log in with
 admin/district):

 http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html?id=XWXTmFUffng

 A pivot table with number of diagnosis by facility ownership and type with
 totals and subtotals looks like this (notice that diagnosis are data element
 groups):

 http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html?id=vlnZeGhgw1T

 A pivot table for vaccines, broken down on categories, age group and point
 of service, last 12 months:

 http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html?id=z31v4RMNqnu

 A pivot table with reporting rates, major forms for public facilities by
 location and type, last 12 months:

 http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html?id=VHewKMjyLnR

 We encourage you to play around - select dimension items for the left menu
 and arrange dimensions from Layout in the top menu. Documentation can be
 found here:

 http://dhis2.org/doc/snapshot/en/user/html/ch15.html



 - Data analytics Web-API resource: A flexible API for retrieving aggregated,
 analytical data for all data dimensions using a simple query syntax. The
 pivot table module is built on top of this API. It allows developers of
 third-party apps and web portals to connect to DHIS 2 and query for any type
 of aggregated data, where any number of dimensions and filters can be
 specified. Data can be retrieved in json, jsonp, xml, csv, html and xls
 (Excel) format and responses can be constrained with criteria like greater
 than, equals and so on.

 A query for retrieving data for certain data elements, periods and
 organisation units might look like this:

 http://apps.dhis2.org/demo/api/analytics?dimension=dx:fbfJHSPpUQD;cYeuwXTCPkUdimension=pe:2012Q1;2012Q2dimension=ou:O6uvpzGd5pu;lc3eMKXaEfw

 Documentation can be found here:

 http://dhis2.org/doc/snapshot/en/user/html/ch25s18.html



 - Sharing: Several objects including chart, pivot table, map, indicator and
 data set can now be shared and have fine-grained access control. An object
 can be made private to yourself, shared with any number of user groups or be
 made available for all. You can grant edit or view-only rights to other
 people. You can create user groups directly from the dashboard. Who should
 be allowed to create public objects can be controlled through user roles.

 This functionality is useful for example in a scenario where entities like
 health programs and implementing partners need to create indicators and
 reports which should be available only for members of their organisation. In
 this case, an organisation can create a user group for their staff, then
 develop charts and maps which could be made available for that organisation
 only. General reports made by the ministry could still be shared with all
 and made publicly available.

 Another use-case is that of an international NGO with operations in multiple
 countries. Here, user groups could be set up for each country and
 indicators, resources, charts and reports which are country-specific could
 be made available for staff working in that country only, without appearing
 in lists for staff working in other countries. Indicators and reports which
 are applicable for all counties could be made accessible for all. The
 sharing solution also opens up for great possibilities when combined with
 the self-registration of user account feature.

 Documentation here:

 http://dhis2.org/doc/snapshot/en/user/html/ch07.html



 - DXF 2 meta-data exchange: You can now import and export a complete set of
 objects in the aggregate part of the system, including data sets, custom
 data entry forms, maps, charts and option sets. Import/export of meta-data
 objects now uses the new DXF 2 format. Import/export can also be done
 through the meta-data Web API resource. This greatly improves the ability
 for meta-data exchange between DHIS 2 instances and third-party systems.

 Documentation here:

 http://dhis2.org/doc/snapshot/en/user/html/ch19.html


 - HTML-based standard reports: You can now develop standard reports in pure
 HTML

Re: [Dhis2-users] DHIS version 2.11 is released

[Paulo Grácio]

Thanks. I missed that email, sorry for  the spam.

Regards,
Paulo Grácio

On 25 March 2013 15:32, David Muturi dnmut...@gmail.com wrote:
 Hi Paulo,
 Here it is...
 this update is intended for server administrators looking to upgrade
 to DHIS 2.11.

 In version 2.11, DHIS is performing on-the-fly data aggregation as
 part of the new analytics API. This is in contrast to the datamart API
 where data is been pre-aggregated for a set of dimensions. The
 analytics tables contain indexed columns for each data dimension
 together with a column for the raw data values. The tables are
 partitioned for each year of data. Partition means a part of a table
 which has been split horizontally on rows - you will find tables like
 analytics_2011, analytics_2012, analytics_2013 in the database. This
 has some consequences for server configuration:


 1) It is strongly recommended to set up a cache server to reduce the
 pressure on your web servers. First, caching must be enabled in DHIS
 from System general settings by setting Cache strategy to Cache
 until 6 am tomorrow. The simplest way to set up a server-side cache
 if you already have a reverse proxy like nginx and apache running is
 to configure it directly in the proxy. Enabling caching for nginx is
 documented here:

 http://dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e580

 Apache caching can be done through the mod_cache module:
 http://httpd.apache.org/docs/2.2/mod/mod_cache.html

 Otherwise, dedicated caches like varnish
 (https://www.varnish-cache.org/) and squid
 (http://www.squid-cache.org/) could be set up in front of your web
 servers.



 2) Run latest version of PostgreSQL which is 9.2. It has some nice
 performance improvements over earlier versions.



 3) Make sure a lot of memory is available to the database /
 PostgreSQL. If the analytics tables for the last 2-3 years can fit in
 the memory cache then on-the-fly aggregation will perform much better.
 You can see the size of the analytics tables and indexes using this
 SQL on PostgreSQL:

 select pg_size_pretty( pg_total_relation_size( 'analytics_2013' ) );

 The more memory you have the better. Documentation has been updated,
 have a look at the values for shared_buffers and effective_cache_size
 settings and update your configurations adjusted for your available
 memory:

 http://dhis2.org/doc/snapshot/en/implementer/html/ch08.html#d5e413



 4) Make sure you have enough disk space as t
 he size of the database will increase with the analytics tables. Also,
 when doing database backups it's not required to include the analytics
 nor the datamart tables. An efficient command for creating backups
 which omits these tables and compresses the output in one go (replace
 db-name and db-user) is:

 pg_dump db-name -U db-user -T aggregated* -T analytics* -T
 completeness* | gzip  dhis-pgdump.gz


 5) Optional. Use a fast hard disk type/drive. It will help performance
 both on analytics table generation and read queries if you have a fast
 disk type, ideally SSD.


 rgds
 David

 2013/3/25 Paulo Grácio paulogra...@gmail.com:
 Congratulations for the achivement!

 Is there any information about how to upgrade from version 2.10 to 2.11?

 Kind regards,
 Paulo Grácio

 On 22 March 2013 19:05, Lars Helge Øverland larshe...@gmail.com wrote:

 Hi all,

 DHIS version 2.11 is out and we have some great features for you:


 - Web-based pivot table: Allows you to create pivot tables with data
 aggregated along all data dimensions, including data element/organisation
 unit group sets. Data dimensions can be arranged freely on columns, rows and
 as filters. You can include totals and subtotals on all axis and control the
 table density and font size under options. Your pivots can be saved as
 favorites and downloaded to your local computer. This design goal is to
 allow users to create their own reports with the data they need without any
 involvement of super-users.

 A pivot table with immunization indicators for last 4 quarters by facility
 ownership, type and location can be made like this (log in with
 admin/district):

 http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html?id=XWXTmFUffng

 A pivot table with number of diagnosis by facility ownership and type with
 totals and subtotals looks like this (notice that diagnosis are data element
 groups):

 http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html?id=vlnZeGhgw1T

 A pivot table for vaccines, broken down on categories, age group and point
 of service, last 12 months:

 http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html?id=z31v4RMNqnu

 A pivot table with reporting rates, major forms for public facilities by
 location and type, last 12 months:

 http://apps.dhis2.org/demo/dhis-web-pivot/app/index.html?id=VHewKMjyLnR

 We encourage you to play around - select dimension items for the left menu
 and arrange dimensions from Layout in the top menu. Documentation can be
 found here:

 http://dhis2.org/doc/snapshot/en/user/html/ch15.html

[Dhis2-users] Setting up GIS

[Paulo Grácio]

Hello,

I have been following Chapter 16. Setting up GIS of DHIS User Manual.
After download Spatial Data from http://www.diva-gis.org

Country: Mozambique
Subject: Administrative areas (GADM)

I used MapShaper to simplify geographical data according to the
described, but on Step 2 - Convert the shapefile to GML, I got stuck.
Running ogrinfo -al -so MOZ_adm1-polygons-ms1.shp the output is

INFO: Open of `MOZ_adm1-polygons-ms1.shp'
  using driver `ESRI Shapefile' successful.

Layer name: MOZ_adm1-polygons-ms1
Geometry: Polygon
Feature Count: 10
Extent: (30.217328, -26.868695) - (40.839361, -10.471250)
Layer SRS WKT:
(unknown)

Having this as an output what's the correct way to create the GML file?


Kind regards,
Paulo Grácio

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

Re: [Dhis2-users] Setting up GIS

[Paulo Grácio]

Hello Jan,

thanks for the reply.

Executing the command you suggested I'm having the following error:

Can't transform coordinates, source layer has no
coordinate system.  Use -s_srs to set one.

Regards,
Paulo Grácio


On 26 February 2013 12:53, Jan Henrik Øverland
janhenrik.overl...@gmail.com wrote:
 Hi, please try

 ogr2ogr -t_srs EPSG:4326 -f GML MOZ_adm1-polygons-ms1.gml
 MOZ_adm1-polygons-ms1.shp


 On Tue, Feb 26, 2013 at 1:31 PM, Paulo Grácio paulogra...@gmail.com wrote:

 Hello,

 I have been following Chapter 16. Setting up GIS of DHIS User Manual.
 After download Spatial Data from http://www.diva-gis.org

 Country: Mozambique
 Subject: Administrative areas (GADM)

 I used MapShaper to simplify geographical data according to the
 described, but on Step 2 - Convert the shapefile to GML, I got stuck.
 Running ogrinfo -al -so MOZ_adm1-polygons-ms1.shp the output is

 INFO: Open of `MOZ_adm1-polygons-ms1.shp'
   using driver `ESRI Shapefile' successful.

 Layer name: MOZ_adm1-polygons-ms1
 Geometry: Polygon
 Feature Count: 10
 Extent: (30.217328, -26.868695) - (40.839361, -10.471250)
 Layer SRS WKT:
 (unknown)

 Having this as an output what's the correct way to create the GML file?


 Kind regards,
 Paulo Grácio

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



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

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

Re: [Dhis2-users] Setting up GIS

[Paulo Grácio]

@Jan, thanks for the help, you were right, Kudos to you!

@Jason, thanks for the tip.

Kind regards,
Paulo Grácio

On 26 February 2013 17:25, Jason Pickering jason.p.picker...@gmail.com wrote:
 It looks like it may have worked, but you should be careful to ensure that
 if you do not have a .prj file (which defines the projection information for
 the shape file) that you tell ogr2ogr what projection system the file is
 actually in. In your case,  it looks like you did not need to tell ogr2ogr
 what the projection system was (it guess for you) , but you cannot always be
 sure with shape files what the projection system actually is without a bit
 of prior knowledge of the nature of the file, or having its metadata.

 From the ogr2ogr manual..


 This option controls the output projection.

 -t_srs srs_def:Reproject/transform to this SRS on output

 This option controls the input spatial reference system, which ogr2ogr will
 attempt to read from the .prj file if it is present.
 If not, you may get an error like the one you say above.

 -s_srs srs_def:Override source SRS

 Regards,
 Jason



 On Tue, Feb 26, 2013 at 5:19 PM, Paulo Grácio paulogra...@gmail.com wrote:

 I just get the following warning message

 Warning 1: Layer name 'MOZ_adm1-polygons-ms1' adjusted to
 'MOZ_adm1_polygons_ms1' for XML validity. Output attached.

 Nevertheless, I was expecting something similar to this structure
 (...)
 gml:featureMember
 ogr:admin2 fid=F0
 ogr:geometryProperty
 (...)
 /ogr:geometryProperty
 ogr:ADMINID6940101/ogr:ADMINID
 ogr:ADM1_NAMESouthern/ogr:ADM1_NAME
 ogr:NameBo/ogr:Name
 ogr:ISO_CTRYSL/ogr:ISO_CTRY
 ogr:POPDENS9037/ogr:POPDENS90
 ogr:TOT_POP90213/ogr:TOT_POP90
 ogr:ADM1CODE69401/ogr:ADM1CODE
 ogr:LVLIDSLP002004/ogr:LVLID
 ogr:OLDLVLIDSLP002001/ogr:OLDLVLID
 /ogr:admin2
 /gml:featureMember
 (...)

 this is based on the test resources for dhis-service-importexport.

 Paulo

 On 26 February 2013 15:04, Jan Henrik Øverland
 janhenrik.overl...@gmail.com wrote:
  Ok, then try the same command, just replace -t_srs with -s_srs.
 
 
  On Tue, Feb 26, 2013 at 3:59 PM, Paulo Grácio paulogra...@gmail.com
  wrote:
 
  Hello Jan,
 
  thanks for the reply.
 
  Executing the command you suggested I'm having the following error:
 
  Can't transform coordinates, source layer has no
  coordinate system.  Use -s_srs to set one.
 
  Regards,
  Paulo Grácio
 
 
  On 26 February 2013 12:53, Jan Henrik Øverland
  janhenrik.overl...@gmail.com wrote:
   Hi, please try
  
   ogr2ogr -t_srs EPSG:4326 -f GML MOZ_adm1-polygons-ms1.gml
   MOZ_adm1-polygons-ms1.shp
  
  
   On Tue, Feb 26, 2013 at 1:31 PM, Paulo Grácio paulogra...@gmail.com
   wrote:
  
   Hello,
  
   I have been following Chapter 16. Setting up GIS of DHIS User
   Manual.
   After download Spatial Data from http://www.diva-gis.org
  
   Country: Mozambique
   Subject: Administrative areas (GADM)
  
   I used MapShaper to simplify geographical data according to the
   described, but on Step 2 - Convert the shapefile to GML, I got
   stuck.
   Running ogrinfo -al -so MOZ_adm1-polygons-ms1.shp the output is
  
   INFO: Open of `MOZ_adm1-polygons-ms1.shp'
 using driver `ESRI Shapefile' successful.
  
   Layer name: MOZ_adm1-polygons-ms1
   Geometry: Polygon
   Feature Count: 10
   Extent: (30.217328, -26.868695) - (40.839361, -10.471250)
   Layer SRS WKT:
   (unknown)
  
   Having this as an output what's the correct way to create the GML
   file?
  
  
   Kind regards,
   Paulo Grácio
  
   ___
   Mailing list: https://launchpad.net/~dhis2-users
   Post to : dhis2-users@lists.launchpad.net
   Unsubscribe : https://launchpad.net/~dhis2-users
   More help   : https://help.launchpad.net/ListHelp

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

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