Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

Version 2.31 will not On Wed, 31 Oct 2018, 09:00 moses mwale, wrote: > Sorry just to interject, so dhis2 does not work with Postgres 9.5? > > On Wed, 31 Oct 2018 at 9:58 AM, Bjørn Sandvik wrote: > >> Hi, >> >> PostGIS requirement is 2.2 or later. >> AFAIK, this will still be the case for 2.31.

Re: [Dhis2-devs] Setup DHIS2 in Linux (Debian)

I have made a package of dhis2 management scripts for Ubuntu (dhis2-tools) also described in implementers manual. It would be trivial enough to repackage for Debian in there is particular demand. On Mon, 17 Sep 2018, 11:01 Viktor Varland, wrote: > Hi Nayeem > > I have written down Debian 9

Re: [Dhis2-devs] 2.29/2.30 WARNING - do not use Maintenance->ClearAnalyticsTables & parameter "-T analytics*" for database dumps

his also causes potential >>>>>>> issues with your backups...) >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Morten Olav Hansen >>>>>>> Senior Engineer, DHIS 2 >>>>>>&

Re: [Dhis2-devs] 2.29/2.30 WARNING - do not use Maintenance->ClearAnalyticsTables & parameter "-T analytics*" for database dumps

Thats nasty alright. I guess using "-T anlytics_*" instead would help. But there are so many backup scripts out there broken by this that it will be better to rename the table. On 11 July 2018 at 22:39, Calle Hedberg wrote: > Hi > > For as long as I can remember, we have used the standard

Re: [Dhis2-devs] ADD credentials in DHIS2 url

This is not really a dhis2 thing so much as a change in browser behaviour. In times gone by when you presented a url like "https://admin:distr...@play.dhis2.org/dev/api/me; the browser would take that url and create the basic authentication header that Jason refers to. After a couple of wobbles

Re: [Dhis2-devs] Analytics taking too much time for tracker

Hi Hannan I recall you had a similar request which I responded to back in Jan 11. Maybe worth re-reading that thread as some of it seems still to be relevant. In particular: 1. The first question, as always, is has this suddenly happened or has something recently changed? Back then there had

Re: [Dhis2-devs] API not showing 401 Unauthorized error

Hi Jason I am not sure that this is all fine. It looks to me like this is a bug which has slipped in and that the original 401 response is the correct expected behaviour. API users using pre-emptive basic authentication have no good reason to be redirected to the login page with invalid

Re: [Dhis2-devs] table for Category Options

Sure Calle, I guess postgres must defend itself from the likes of us :-) On 13 February 2018 at 09:48, Calle Hedberg wrote: > Morten > > Thanks for prompt reply, I had actually looked at the properties for that > and all other tables with category/options in the name (in

Re: [Dhis2-devs] merging facilities (org-units) without losing data

If you really must work on your production database directly then at the very least you should shutdown the dhis2 instance while you make changes. Naturally you want to keep that down time to a minimum. So I would suggest a sequence of: (i) make a copy of the database to test these procedures

Re: [Dhis2-devs] [Dhis2-users] Preserving DHIS2 instance (or format for export)?

and you can also have "files". Maybe the best approach is to cleanup the webapps directory (leaving only war file) then zip up all of DHIS2_HOME together with database backup. You need to think about whether you want to also keep old log files. dhis2, but also possibly proxy and postgres. It

[Dhis2-devs] Fwd: 5 USD for PostgreSQL books at PacktPub

Apologies for cross posting. This looks like good value for getting up to speed on the new postgresql 10 features -- Forwarded message -- From: Alexander Farber Date: 2 January 2018 at 15:13 Subject: 5 USD for PostgreSQL books at PacktPub To:

Re: [Dhis2-devs] DHIS 2, PostgreSQL only

Very good Lars! Looking at the move to postgresql 10 (presumably one or two more versions down the line), have you been considering the native partitioning support for dealing with huge datavalue tables? This looks like it might be very suited to our classic problem of large amounts of historic

Re: [Dhis2-devs] Integration of OpenMRS & DHIS2

Hi Gerald My knowledge of that openmrs module is quite old .. I wrote the initial implementation but that is over 5 years ago. I think what you should do is to contact the current maintainers of the module for support on the various errors you might be seeing. I know there was some Google

Re: [Dhis2-devs] Latest Struts exploit - CVE-2017-9805 | impact to DHIS2?

DHIS2 is not vulnerable to this CVE. On 15 September 2017 at 03:52, Greg Wilson wrote: > I asked the core team last week and they said DHIS2 does not use the REST > plugin that CVE-2017-9805 addresses. If this is not correct, I am sure one > of them will correct me in a

Re: [Dhis2-devs] BUG - 2.27 - Logged as different user

If you are getting remnants of SJ's session appearing on your computer it might mean some stuff is being (incorrectly) cached on the server side. Do you have nginx or apache cache enabled. If so try disabling that. On 28 August 2017 at 10:51, Ramón José Jiménez Pomareta

Re: [Dhis2-devs] Server processor use 100%

server will also be decommissioned and will setup > a new server with new cardinals. I will start upgrade work after I return. > > Thank you for your valuable advice and kind concern. > > Best regards > > Hannan > > On Mon, Jul 10, 2017 at 8:21 PM, Bob Jolliffe <bobjolli

Re: [Dhis2-devs] Server processor use 100%

Sorry that should have been 'ls -la /tmp' On 10 July 2017 at 10:50, Bob Jolliffe <bobjolli...@gmail.com> wrote: > Hi Hannan > > There is no circumstance that tomcat user should be running the sshd > command. It could be this machine has been compromised. Unless you have &g

Re: [Dhis2-devs] Server processor use 100%

Hi Hannan There is no circumstance that tomcat user should be running the sshd command. It could be this machine has been compromised. Unless you have some strange setup that you are logging in as tomcat user. Please contact me directly if you want me to check. Meanwhile you might want to

Re: [Dhis2-devs] critical security vulnerability found - immediate dhis upgrade required

Following this announcement by Lars back in March it is really troubling to report that we are still hearing of servers being hacked as a result of this vulnerability. The most recent case brought to my attention just over a week ago (a tomcat server running as root with a dhis2 war file from nov

Re: [Dhis2-devs] [Dhis2-users] Any open source GIS/map database tools other than DHIS2

Adding another voice in favour of qgis. I am no gis expert but even I figured out how to use it :-) @Bjørn, GeoJSON-format will be great. On 21 June 2017 at 17:38, Bjørn Sandvik wrote: > Hi, > > I would highly recommend QGIS, which is the leader among open source GIS - > well

Re: [Dhis2-devs] [Dhis2-users] HELP NEEDED: DHIS2 design issue

Hi Calle Good points. The issue of informed consent and access for clinically relevant time period is certainly important for many EMR use cases. There are of course many more issues relating to handling, storing and sharing patient data. For example transport security and node authentication

Re: [Dhis2-devs] Domain Name for SL Training Server

Hi Gerald There isn't really a "procedure" for this. dhis2.org is a domain owned by the HISP project which we use for our servers. Its not really something which is offered as a service. Regards Bob On 27 May 2017 at 16:30, gerald thomas wrote: > Dear All, > I had

Re: [Dhis2-devs] Announcement of the DHIS2NZ app for DHIS2

h Informatics, >> Indiana University - Purdue University Indianapolis. >> >> On 1 April 2017 at 09:01, J. Paul Mutali <mut...@gmail.com> wrote: >> >>> H, >>> >>> thanks, made my day. >>> >>> >>> JP >>&

Re: [Dhis2-devs] Announcement of the DHIS2NZ app for DHIS2

funky On 31 March 2017 at 23:47, Mark Polak wrote: > Hey All, > > Today we'd like to announce a new app for visualisation of data called > DHIS2NZ. > > The app includes it's own one minute intro video. We have made a demo of > the app available just for today. > > You will be

Re: [Dhis2-devs] System monitoring setting in 2.26

>From the source code I see it is some kind of custom monitoring solution for pushing some key system information info to a central monitoring service - eg time of last analytics build etc. I guess Lars can document. I wonder is there any reason why we don't just use jmx for this kind of thing?

Re: [Dhis2-devs] WAR file cannot deploy in tomcat 8

2.17 to 2.27 on the same platform >>> (java 8 build 121, tomcat 8.0.33 and 36) - no problems. So I agree with Bob >>> - looks like a damaged war file. >>> >>> Regards >>> Calle >>> >>> On 2 March 2017 at 08:09, Bob Jolliffe <bobjolli...@gmail

Re: [Dhis2-devs] WAR file cannot deploy in tomcat 8

gt; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) > at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940) > at org.apache.catalina.startup.HostConfig$DeployWar.run( > HostConfig.java:1816) > at java.util.concurrent.Executors$RunnableAdapter.call(

Re: [Dhis2-devs] UNABLE TO INSTALL DHIS2 ON A LOCAL MACHINE

Take a look in the log file (catalina.out). Your tomcat is running but it seems that the dhis.war file has not been loaded for some reason - which might be clear in the log file. On 22 February 2017 at 09:17, Stanley Kalyati wrote: > Dear Coalleagues, > > I am trying to

Re: [Dhis2-devs] release cycle: from 4 to 3 releases per year

Lars, has there been any recent discussion over adopting an ubuntu-style approach of two types of release? I think a lot of people running large national setups with 1000's of users would be happy to see a long-term-service release maybe once a year with at least guaranteed security related

Re: [Dhis2-devs] [Dhis2-users] heads up on tomcat versions and dhis

asonable to me. We took a temporary route and > used one we knew would work until the upgrade to at least 2.24 is feasible. > > On Wed, Feb 1, 2017, 18:38 Bob Jolliffe <bobjolli...@gmail.com> wrote: > >> Thanks Jason. To make matters more complicated it looks like ubuntu >&g

Re: [Dhis2-devs] [Dhis2-users] heads up on tomcat versions and dhis

e/tomcat70/commit/a3d7be9e35505f85fc01f5f36451c7 > 10f9c9bbcc > > which introduced this, which seems to be Tomcat 7.0.73, so something > earlier than that should work as well. I am not sure which commit this was > in Tomcat 8. > > Hope that helps. > > Regards, > Jason

Re: [Dhis2-devs] [Dhis2-users] heads up on tomcat versions and dhis

Hi Lars and all I can see this is going to cause quite a bit of chaos with large country installations where they are not able to be too agile with upgrading. Do you have more precise info on the exact tomcat version numbers? We just saw in Zim (DHIS 2.22) that the package manager automatically

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

mail.com> wrote: > > Hi Gerald, > > > > You can use the (insert if not exists) query to insert your data. But > > unlike the COPY function which allows bulk insert, you have to write an > > insert statement for each data value you intend to insert. > > > > Reg

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

I am worried where are these errors coming from now. > > On Jan 28, 2017 7:31 PM, "Bob Jolliffe" <bobjolli...@gmail.com> wrote: > > Gerald the clue is in your error message: > > Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid, > attributeo

Re: [Dhis2-devs] [Dhis2-users] Tomcat error

Gerald the clue is in your error message: Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists. This usually means you have duplicates among the datavalues you are trying to import. ie. more than one row with

Re: [Dhis2-devs] Errors in JDBC connection

This seems to be a known problem between mysql, java and c3p0 (the database connection pool). It seems that mysql resets connections which are not used for 8 hours (by default). For some reason these stale connections then get served up from the connection pool giving rise to this error. You

Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

Gerald it sounds like it has got into a bit of a mess and maybe you risk just making it worse. It is really not supposed to be this hard, but tit is next to impossible at a distance to figure out what might have gone wrong. Given that you are not dependent on migrating the cluster, but that you

Re: [Dhis2-devs] Determining DHIS2 version in use from database instance

No I think its a good question. I've often thought that it would be useful for the database to get "marked" in some way once it has been run against a particular build of war file. This can be useful for example when dealing with archived backups. But no I don't think we do this currently. On

Re: [Dhis2-devs] Fwd: 502 Bad Gateway nginx/1.10.0 (Ubuntu

Thanks Lars. Is that cacheMaxSize="10" an arbitrary example or a sensible default? (I am thinking here of setting the default on dhis2-tools instance) On 6 December 2016 at 08:02, Lars Helge Øverland wrote: > Hi Olav, > > this warning comes from a cache-related setting in

Re: [Dhis2-devs] Deployment Advice to Developers

Hi Joe There are a couple of deployment approaches. Most folk are probably doing some sort of variant of the following: 1. There is the step by step approach as described in chap 8 of the implementers manual (and which can be customised to suit) 2. There is the docker build scripts maintained

Re: [Dhis2-devs] [Dhis2-users] API: dataSets.dataElements

The reason why there isn't a backward compatible api is because the underlying model has changed to support overriding the categorycombo per dataset. So a dataset no longer has dataElements, but dataSetElements. The dataSetElement is a compound object consisting of both a dataelement reference

Re: [Dhis2-devs] [Dhis2-users] 25 hours in completing Analytic

Hi Calle I think Lars would probably know better, but given the kinds of cross tabulation that is happening with analytics, I doubt that it will scale linearly. Would be good to get some empirical data but I think you are probably going to have something more approaching n^2 time complexity. On

Re: [Dhis2-devs] [Dhis2-users] 25 hours in completing Analytic

For the benefit of others on this thread, this is the tweaking I shared with Neeraj - He had 3200MB shared_buffers set (as per the online manual). I suggested with his 48G of RAM he tries: shared_buffers = 12GB effective_cache_size = 20GB (remember the manual is based on an exampe machine with

Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

s > though they are offering administrative services and should need > monitoring as well. > > Kayode > > > On 10/8/16, Bob Jolliffe <bobjolli...@gmail.com> wrote: >> Hi Lungo >> >> Not quite what I said. It is early days for the SL shining case study >

Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

ll increase. This is where iHRIS is the best option. > > Best regards, > > Lungo > > > > From: Bob Jolliffe <bobjolli...@gmail.com> > To: Arthur Heywood <arthurheyw...@gmail.com> > Cc: Juma Lungo <jlu...@yahoo.com>; dh

Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

Hi Arthur Carl will probably be able to point you to various cases where this has been done with dhis2 and ihris. I am familiar with examples from Zanzibar, Kenya and Rwanda which sort of worked but none of which could fairly be described as successful in the sense of sustained use as far as I

Re: [Dhis2-devs] error when deploing dhis 2.24 on windows

Bad war file is what it looks like to me too. Guy if you are going to do two things (change war file and change jdk) do them one at a time and test. That way you will learn which was the culprit. On 6 October 2016 at 15:06, Morten Olav Hansen wrote: > Probably a damaged war

Re: [Dhis2-devs] Data import through API in zip format

> wrote: >> >> Wait about 1 hour, and try again with latest 2.21 >> >> -- >> Morten Olav Hansen >> Senior Engineer, DHIS 2 >> University of Oslo >> http://www.dhis2.org >> >> On Thu, Jul 28, 2016 at 2:33 PM, Bob Jolliffe <bobjolli

Re: [Dhis2-devs] Data import through API in zip format

Hi Victor I had a quick look at source code and I am not sure that we do support zip encoded payloads for datavalueset import at all :-( The way that it works auto-magically through the web ui is that we actually peek into the stream header to deduce whether the stream is zipped or gzipped.

[Dhis2-devs] sql error in analytics table name

Hi The folk in ghana are hitting a problem running analytics where an invalid table name is being generated. Specifically the sql which fails is: create table analytics_event_temp_-1_r8cbfnorkzf ( ... instead of something like ... create table analytics_event_temp_2015_r8cbfnorkzf (

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

Gerald I assume that you are going to try this out on a test machine, not the machine on which the users are entering data. On 27 July 2016 at 13:54, gerald thomas wrote: > Thanks Knut, they are currently doing data entry till August 15. I will > start on the 16 or 17 and

Re: [Dhis2-devs] [Dhis2-users] Problem upgrading from 2.20 to 2.21

e = > 'sum'; > > Regards, > > Michael > > > On 22 July 2016 at 09:09, Bob Jolliffe <bobjolli...@gmail.com> wrote: >> >> Hi >> >> After upgrading from 2.20 to 2.21 system is failing to start with: >> >> ERROR 2016-07-22 09:01:36,593 j

Re: [Dhis2-devs] [Dhis2-users] Problem upgrading from 2.20 to 2.21

Jul 22, 2016, at 9:37 AM, Bob Jolliffe <bobjolli...@gmail.com> wrote: >> >> Thanks all. The startup routines should take care of all this stuff >> without the need for running manual queries. And indeed they do >> unless they fail - which as Dan says they do horribly

[Dhis2-devs] Problem upgrading from 2.20 to 2.21

Hi After upgrading from 2.20 to 2.21 system is failing to start with: ERROR 2016-07-22 09:01:36,593 java.lang.IllegalArgumentException: Unknown name value [avg_sum_org_unit] for enum class [org.hisp.dhis.analytics.AggregationType] This looks like one of those new enum upper case restrictions.

Re: [Dhis2-devs] [Dhis2-users] Multiple DHIS2 instances on a Single Server

Hi Gerald What Seth describes is pretty much what dhis2-tools does. It just partially automates some of the setup and takes care of some fiddly things like serving static files through cache, rotating backups etc. And you have dhis2-tools running on sl.dhis2.org. Simon Jespersen has been

Re: [Dhis2-devs] LDAP configuration

Is there anything i am missing, can someone please help..? >> >> [image: ldap-config.png] >> >> Thanks, >> Chameera. >> >> On Wed, Jun 8, 2016 at 6:09 PM Chameera Mirihella <chameera9...@gmail.com> >> wrote: >> >>> Thanks Bob, I u

Re: [Dhis2-devs] LDAP configuration

That ldap.url looks like the http url of your php ldap frontend web application. You need to point it at the running ldap service not the php web interface. On 8 June 2016 at 07:00, Chameera Mirihella wrote: > Hi Team, > > I am trying to configure a dhis instance

Re: [Dhis2-devs] Problem creating the parent org unit through the API

If you have your source data in postgresql, you can also use the following handy function to generate uids directly from the database: CREATE OR REPLACE FUNCTION uid() RETURNS text AS $$ SELECT substring('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ' FROM (random()*51)::int +1 for

Re: [Dhis2-devs] [Dhis2-users] thomas lindsjørn joins as android developer

welcome Thomas On 24 May 2016 at 20:20, Jim Grace wrote: > Hi Thomas, welcome! > > > On Tue, May 24, 2016 at 3:13 PM, Knut Staring wrote: >> >> Welcome Thomas! >> >> Knut >> >> On 24 May 2016 9:09 p.m., "Lars Helge Øverland" wrote: >>> >>> Hi

Re: [Dhis2-devs-core] DHIS2 demo admin password

Could we use nginx to prevent access to the action. Redirect to somewhere punitive :-) On 24 May 2016 03:38, "Morten Olav Hansen" wrote: > I agree that it would be helpful. A couple of issues: > > 1) If using the web-api, it would require it to be a valid password, so >

Re: [Dhis2-devs] [Bug 1582637] Re: DHIS NOT DISPLAYED ON BROWSER WHEN DATA IS RESTORED TO POSTGRESQL

Hi Mohamed Looking at the small snippet of log file, the dhis war file failed to load. You are right that this has likely something to do with the contents of your database, but the picture of your log file doesn't give the required info. Would need to look at what is happening much earlier in

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

ponsible for maintaining the > server. Sadly, I have never had to do this kind of db restore before and > neither has any member of the team. > > > > Any help would be great. > > > > -- Original message-- > > From: Bob Jolliffe > > Date: Thu, 19

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

ating installing pgAdmin on the server then attempt to connect to it > from a Windows pc. Do you think this is a good way to proceed? > > > > Regards, > > Eneja. > > > > -- Original message-- > > From: Bob Jolliffe > > Date: Thu, 19 May 2016 14:3

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

atabase. > > > > Regards. > > > > C Eneja > > > > -- Original message-- > > From: Dr. Ifeanyi Okoye > > Date: Thu, 19 May 2016 13:55 > > To: 'Bob Jolliffe';'Johan Ivar Sæbø'; > > Cc: 'dhis2-devs';CHIKWADO ENEJA; > > Subject:[SUSPEC

Re: [Dhis2-devs] Restoring backup

Hi Ifeany Can you give exact psql command you are using and the output? If it is a plain text format you should be able to see the sql commands in it by running a command like 'less backup.sql' (assuming that is the name of your file). That is always good to verify that what you have is indeed

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

I *think* we discuss the space separator business purely related to display. So when exporting to excel, or any other case where the number is expected to be consumed as a number (including storage in the database), exported via api in json/xml datavalueset etc there should be no spaces, commas

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

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

Re: [Dhis2-devs] dhis 2.23 upgrade

ding to the docs, PostGIS 2.2 works against PostgreSQL 9.1 > and later: > > > http://postgis.net/docs/manual-2.2/postgis_installation.html#install_requirements > > We have of course tested DHIS 2 against PostGIS 2.2, so this should be > safe. > > Lars > > > >

Re: [Dhis2-devs] dhis 2.23 upgrade

Hi Lars I know that a lot of production servers are running postgres 9.3 (default with ubuntu 14.04). The instructions assume postgres 9.4 is used. I know they could upgrade, but I wonder has anybody tested the gis extensions with 9.3? Regards Bob On 25 April 2016 at 18:38, Lars Helge

Re: [Dhis2-devs] "All" authority no longer granting access to programs?

Its an interesting problem. In general Role Based Access Control (RBAC) is known to be an insufficient security mechanism/framework for handling issues of patient confidentiality without some additional parameterization to model things like legitimate relationships, patient consent management

Re: [Dhis2-devs] [Dhis2-users] restore database out of memory

Ah you are on Windoze. I also don't have much real experience of running dhis2 other than on linux, but it strikes me that (i) 4G machine is small but should still "work" (ii) the databse size you are talking about 100m is quite small and the restore operation should not be consuming vast amounts

Re: [Dhis2-devs] [Dhis2-users] restore database out of memory

One other quick thought that is easy to test and eliminate. Postgres out of memory errors on restore can also result from a corrupted dump file. It might be worthwhile to check on another system that your dump is good. On 18 March 2016 at 17:08, Bob Jolliffe <bobjolli...@gmail.com> wrote

Re: [Dhis2-devs] Free SSL with letsencrypt

Thanks David. That's really useful. Removing credit card transactions from the process of getting certs signed is going to be very valuable. Note from here (https://community.letsencrypt.org/t/certificates-for-us-sanctioned-countries/1223) that there might still be some issues in some US

Re: [Dhis2-devs] [Dhis2-users] Free SSL with letsencrypt

And this Chinese supplier might well be the way around any issues arising from US sanctions :-) On 14 March 2016 at 12:30, Steven Uggowitzer wrote: > Thanks David, > > For those of you looking for another (probably less secure) free option, > there is also WoSign

[Dhis2-devs] New openssl vulnerability

Hi In case anyone has noticed and started to panic, there are some new openssl vulnerabilities, which might effect your nginx installations. http://www.infoq.com/news/2016/03/two-new-openssl-flaws?utm_source=infoqWeeklyNewsletter_medium=WeeklyNL_EditorialContent_development_campaign=03082016news

Re: [Dhis2-devs] [Bug 1549378] [NEW] Javascript allowed in OU names, v2.22

Yes firing off arbitrary javascript is not a good thing. It should probably be filtered on input and escaped on output though opinions vary a bit on approaches. I think these sorts of issues were being targeted in the new metadata maintenance app. On 25 February 2016 at 08:51, Knut Staring

Re: [Dhis2-devs] Events API - content length mismatch

Very odd misconfiguration error for nginx though. Did you install through some package manager (apt, yum, ...) or was this manually unpacked and configured? If there is an error in the standard ubuntu install for example, its an important issue to be aware of. On 18 February 2016 at 11:12, Olav

Re: [Dhis2-devs] Metadata API and lastUpdated

I see the code for parsing lastUpdated on the event controller is not the same as on the metadata filtered export. Carl, you are right that currently the format is restricted to the patterns shown in the manual. It would be trivial to add support for ISO8601 timestamp. Can you make a blueprint

Re: [Dhis2-devs] 2.23 Metadata importer rewrite and dryRuns

Calle Here's another take on the problem. Imagine you had a separate "metadata" instance (could variously be called facility registry, data dictionary, indicator registry etc). Basically a dhis2 instance with no data. And a staging instance which contains just a copy of the metadata instance.

Re: [Dhis2-devs] [Dhis2-users] Automatic backup and restoration of Database to Local Server

Gerald, are you asking how to do it or do you want someone to write a script for you? On 14 January 2016 at 11:09, gerald thomas wrote: > Dear All, > Please can someone help as per subject??? > > On 1/8/16, gerald thomas wrote: >> Dear All, >>

Re: [Dhis2-devs] xml for metadata in the web api - anyone using it?

xml metadata (specifically for orgunits) is being used in Rwanda. Technically it could be changed to use json, but some work would be required. There is an xslt which is applied to the metadata to strip some stuff as I recall. On 17 December 2015 at 16:29, Lars Helge Øverland

Re: [Dhis2-devs-core] Audits Web-API

This looks nice. Quick question: is it realistic to think in terms of using this api for doing incremental data backups? On 1 December 2015 at 08:21, Morten Olav Hansen wrote: > http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s21.html > > Basic docs are now

Re: [Dhis2-devs] Generating Facility Codes for a Facility Registry in Sierra Leone

Second approach sounds most painless to me. A 3rd approach (shooting from the hip) is to create a postgres trigger function to generate codes on insert. On 24 November 2015 at 15:27, Carl Leitner wrote: > Hi all, > We are looking at using DHIS2 to manage facilities for a

Re: [Dhis2-devs] New DHIS 2 developer joins HISP US

Welcome Ken! On 19 November 2015 at 20:56, Jim Grace wrote: > Hi All, > > Ken Haase has just joined the team as a DHIS 2 developer, working through > HISP US. Among other things, Ken has a PhD in Artificial Intelligence from > MIT and has taught at the MIT Media Lab. He also

Re: [Dhis2-devs-core] dhis.conf

I am less convinced that YAML would be too much. There are of course different audiences and Lars points us to the lowest common denominator ("how do i open this in word?") who is a troublesome customer alright, but maybe not the most important one. But for db configuration this is fine. The

Re: [Dhis2-devs-core] dhis.conf

For similar (tangentially related) configuration, I have used json. See below. Either yaml or json (or even dreaded xml), I agree with Jason that a bit of structure can be beneficial. Yaml syntax is maybe the most forgiving for user editing by hand. { "dhis2Systems" : { "hmis" : { "type" :

Re: [Dhis2-devs] Removing Organization Units

Gerald you would need to do this with an sql delete command. Before you do you should be 100% sure that you do really want to delete the data - maybe make a backup first. You need to find the primary key (organisationunitid) of the orgunit you want to delete. Say it is 5677 Then: DELETE FROM

[Dhis2-devs] Interesting problem with sql view dependencies

I am not sure if this is an issue which has been fixed in later versions, but we recently chanced upon some odd behaviour in 2.17. On the production system there are a number of views defined (through the sql view interface). A couple of those views depend on other views. When resource tables

Re: [Dhis2-devs] Interesting problem with sql view dependencies

> is alphabetically ordered after it). > > regards, > > Lars > > > > On Mon, Sep 28, 2015 at 1:09 PM, Knut Staring <knu...@gmail.com> wrote: >> >> I have a similar problem in 2.19 where backups are not getting generated >> because of sqlviews.

[Dhis2-devs] [Bug 1498505] [NEW] Adding orgunit allows multiple duplicates

Public bug reported: When you create a new orgunit and press the "Add" button multiple times before the page reloads you end up with multiple orgunits with the same name and different uids. This causes a surprisingly common problem on high latency connections. The user presses "add" and thinks

Re: [Dhis2-devs] error using curl command

thub.com/bmatzelle/gow >>>> >>>> On Thu, Sep 3, 2015 at 12:08 PM, Morten Olav Hansen <morte...@gmail.com >>>> > wrote: >>>> >>>>> I have also seen weird issues on window versions of cURL where -u >>>>>

Re: [Dhis2-devs] error using curl command

Hi Channara The man page for curl indicates that the format of the command is: curl Try moving your url to the end of the line, after the options. Also you might want to add "http://localhost...; On 3 September 2015 at 11:01, channara rin wrote: > Hi DHIS2 friends,

Re: [Dhis2-devs-core] dateOfIncident > incidentDate

Hi Lars Renaming sounds good. Just a minor clarification request/suggestion below ... On 25 August 2015 at 10:31, Lars Helge Øverland wrote: > Hi Tran, Abyot, > > I propose that we rename: > > ProgramInstance.dateOfIncident to incidentDate; +1 > > and > >

Re: [Dhis2-devs] [Dhis2-users] Amazon EC2 memory configuration

Hi David The log file does seem to indicate that the startup was successful. It does look like an orderly shutdown rather than any sign of out-of-memory exceptions. Which happens about 1 minute after the successful startup. Did you shut it down yourself or it just collapsed without you doing

Re: [Dhis2-devs] [Dhis2-users] Data Loss

Hi Gerald Did you check that there is not data missing for Oct, Nov, Dec 2014 for the same districts? I think we had a suspicion some time back that there was maybe a problem with the client PC date settings. So they thought they were entering for Oct 2014 but in fact it was Oct 2015. Hence it

Re: [Dhis2-devs] Meta-Data Import complains of missing shortname and name

to that URL directly in a web browser it pulls the data element in question right up. Timothy Harding RPCV Vanuatu Skype: hardi...@gmail.com +1 (541) 632-6623 On Fri, Aug 7, 2015 at 7:29 AM, Bob Jolliffe bobjolli...@gmail.com wrote: Hi Tim. Are you using PATCH for this update operation

Re: [Dhis2-devs] Meta-Data Import complains of missing shortname and name

Hi Tim. Are you using PATCH for this update operation? This works well if you just need to update a particular set of fields, not the entire dataelment (for which you would use POST and include mandatory fields like name and shortname). For example: curl -X PATCH -d {\code\: \VCCT_6\} -H

Re: [Dhis2-devs] DHIS2 Docs

A few quick thoughts on document storage: 1. once you have a lot of documents it becomes an interesting problem finding them/searching them. People have been doing this for a LONG time and there are a couple of well understood metadata standards for storing metadata about documents (for example

Re: [Dhis2-devs] Schema missing many unique constraints

I know that openmrs makes use of liquibase for managing database diffs : http://www.liquibase.org/ It might be worth considering whether this approach would be useful for us in place of our hibernate ddl + extra sql upgrade script . Student project? On 23 July 2015 at 20:36, Morten Olav Hansen

Re: [Dhis2-devs] Deployable war for previous builds

Hi Mritunjay As Lars says, if the categoryoptioncombos were not exported then that would indeed have caused a problem. And/or if you were using internal primary keys in your reports. But is there a particular reason you need to rely on the import/export functionality to do this? Did you try

  1   2   3   4   5   6   7   8   9   10   >