Re: [Dhis2-devs] dhis 2.23 upgrade

2016-04-26 Thread Bob Jolliffe
eSQL 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 > > > > > > On Tue, Apr 26, 2016 at 11:35 AM, Bob Jolliffe &

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

2016-05-03 Thread 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

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

2016-05-04 Thread Bob Jolliffe
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 et

Re: [Dhis2-devs] Restoring backup

2016-05-19 Thread Bob Jolliffe
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 a

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

2016-05-19 Thread Bob Jolliffe
> 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:[

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

2016-05-19 Thread Bob Jolliffe
plating 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

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

2016-05-19 Thread Bob Jolliffe
> 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 May 2016 14:52 > >

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

2016-05-19 Thread Bob Jolliffe
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 t

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

2016-05-24 Thread Bob Jolliffe
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 all, >>> >>> Thomas Lindsjørn has joined the DHIS 2

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

2016-05-25 Thread Bob Jolliffe
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 1

Re: [Dhis2-devs] Generating a word document in dhis

2016-06-07 Thread Bob Jolliffe
I think its going to be hard to do this in a generic way which is going to meet the requirements of different users simultaneously. docx is just a document format. The bigger part is the report design and layout which is either going to be off some input template (which will not meet everyone's ne

Re: [Dhis2-devs] LDAP configuration

2016-06-08 Thread Bob Jolliffe
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 against a LDAP server for > aut

Re: [Dhis2-devs] LDAP configuration

2016-07-13 Thread Bob Jolliffe
g i am missing, can someone please help..? >> >> [image: ldap-config.png] >> >> Thanks, >> Chameera. >> >> On Wed, Jun 8, 2016 at 6:09 PM Chameera Mirihella >> wrote: >> >>> Thanks Bob, I understand, I will look into that. >>

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

2016-07-14 Thread Bob Jolliffe
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 working

[Dhis2-devs] Problem upgrading from 2.20 to 2.21

2016-07-22 Thread Bob Jolliffe
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. D

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

2016-07-22 Thread Bob Jolliffe
_dump -s -t '_view*' dhis2 >views.sql' before dropping them. On 22 July 2016 at 14:40, Dan Cocos wrote: > One thing that seems to help is if you drop all of the SQL Views from DHIS 2 > first, if they have a relation to the tables they don't get updated. > >>

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

2016-07-22 Thread Bob Jolliffe
= > 'sum'; > > Regards, > > Michael > > > On 22 July 2016 at 09:09, Bob Jolliffe wrote: >> >> 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.Illegal

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

2016-07-27 Thread Bob Jolliffe
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 i will keep you informed

[Dhis2-devs] sql error in analytics table name

2016-07-28 Thread Bob Jolliffe
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 ( Does

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

2016-07-28 Thread Bob Jolliffe
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. Have

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

2016-07-28 Thread Bob Jolliffe
t 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 >> wrote: >>> >>> Hi Vi

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

2016-10-06 Thread Bob Jolliffe
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 file (java.util.zip.

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

2016-10-07 Thread Bob Jolliffe
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 kn

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

2016-10-08 Thread Bob Jolliffe
s where iHRIS is the best option. > > Best regards, > > Lungo > > > > From: Bob Jolliffe > To: Arthur Heywood > Cc: Juma Lungo ; dhis2-users > ; "calle.hedb...@gmail.com" > ; dhis2-devs > Sent: Saturday, Oct

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

2016-10-08 Thread Bob Jolliffe
ffering administrative services and should need > monitoring as well. > > Kayode > > > On 10/8/16, Bob Jolliffe wrote: >> Hi Lungo >> >> Not quite what I said. It is early days for the SL shining case study >> but well worth watching. >> &g

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

2016-10-24 Thread Bob Jolliffe
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] 25 hours in completing Analytic

2016-10-24 Thread Bob Jolliffe
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] API: dataSets.dataElements

2016-11-03 Thread Bob Jolliffe
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 and

Re: [Dhis2-devs] Deployment Advice to Developers

2016-11-15 Thread Bob Jolliffe
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] Fwd: 502 Bad Gateway nginx/1.10.0 (Ubuntu

2016-12-06 Thread Bob Jolliffe
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 Tomcat 8.5 having

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

2017-01-11 Thread Bob Jolliffe
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 1

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

2017-01-26 Thread Bob Jolliffe
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 a

Re: [Dhis2-devs] Errors in JDBC connection

2017-01-26 Thread Bob Jolliffe
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 can

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

2017-01-26 Thread Bob Jolliffe
what works? you removed it and started again? On 26 January 2017 at 10:14, gerald thomas wrote: > Bob, > Thanks it is works > > > On 1/26/17, Bob Jolliffe wrote: > > Gerald it sounds like it has got into a bit of a mess and maybe you risk > > just making

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

2017-01-26 Thread Bob Jolliffe
from https://github.com/dhis2/dhis2-tools. On 26 January 2017 at 10:30, gerald thomas wrote: > Yes Bob, > But i now i am having a major issue because i can't find the > dhis2-startup, dhis2-stop or dhis2-status but the profile of the > instance is available. > > > > On 1/26/

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

2017-01-28 Thread Bob Jolliffe
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 the

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

2017-01-28 Thread Bob Jolliffe
ming from now. > > On Jan 28, 2017 7:31 PM, "Bob Jolliffe" wrote: > > Gerald the clue is in your error message: > > Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid, > attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists. > >

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

2017-01-30 Thread Bob Jolliffe
> 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. > > > > Regards, > > > > > > Seid, > >

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

2017-02-01 Thread Bob Jolliffe
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] heads up on tomcat versions and dhis

2017-02-01 Thread Bob Jolliffe
5505f85fc01f5f36451c7 > 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 > > > On Wed, Feb 1,

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

2017-02-01 Thread Bob Jolliffe
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 wrote: > >> Thanks Jason. To make matters more complicated it looks like ubuntu >> maintains its own patch release numbering of tomcat.

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

2017-02-03 Thread Bob Jolliffe
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 backpo

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

2017-02-22 Thread Bob Jolliffe
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 install DHIS2 on a local

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

2017-03-01 Thread Bob Jolliffe
Hi Hannan There is not sufficient info in this message to be able to help. We know from your report that it failed to start. You need to look earlier in the logfile for why it failed to start. Also the java version might be helpful. Bob On 2 March 2017 at 11:24, Hannan Khan wrote: > Dear Al

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

2017-03-01 Thread Bob Jolliffe
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(Executors.java:511) > at java.

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

2017-03-03 Thread Bob Jolliffe
t; Regards >> >> Hannan >> >> On Thu, Mar 2, 2017 at 2:57 PM, Calle Hedberg >> wrote: >> >>> Hannan >>> >>> I've been running all versions from 2.17 to 2.27 on the same platform >>> (java 8 build 121, tomcat 8.0.

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

2017-03-29 Thread Bob Jolliffe
>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] Announcement of the DHIS2NZ app for DHIS2

2017-04-01 Thread Bob Jolliffe
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 able to log in with

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

2017-04-02 Thread Bob Jolliffe
- Purdue University Indianapolis. >> >> On 1 April 2017 at 09:01, J. Paul Mutali wrote: >> >>> H, >>> >>> thanks, made my day. >>> >>> >>> JP >>> >>> On Sat, Apr 1, 2017 at 11:48 AM, Bob Jolliffe >>

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

2017-05-27 Thread Bob Jolliffe
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 setup a test server for Si

Re: [Dhis2-devs] patient_dataelement Vs routine_dataelement

2009-06-09 Thread Bob Jolliffe
Saptarshi, 2009/6/9 Saptarshi Purkayastha : >> >> I'm not sure what happened to the BPEL eclipse project >> (http://www.eclipse.org/bpel/) which would give us all this in a >> standard way.  I know the Alfresco DMS uses BPEL as a workflow engine. >>  I'll take a look and see.  Might be too heavy a

[Dhis2-devs] dxf format

2009-06-10 Thread Bob Jolliffe
I've just finished a few crazy hours coding a schema to describe the current dxf format (see attached dxf.rng file). No invention - just describing what's there. I have used the RelaxNG schema language (http://www.relaxng.org/) to do this because it is nicer than W3C XML Schema and easier to writ

Re: [Dhis2-devs] Needed for support with jxl package

2009-06-16 Thread Bob Jolliffe
Hi Hieu I know this doesn't really help you, but out of interest I've pasted the relevant bit of an equivalent openoffice spreadsheet content.xml below. As you can see it is very similar to html. If you can make html tables you can make odf spreadsheets. And you don't need a special library - j

Re: [Dhis2-devs] How to get the calculated value from an input formula string ?

2009-06-29 Thread Bob Jolliffe
Hi I don't know if I have the right understanding of this, but please do remember that POI and JXL are only wrappers around the file format - they do not replace the formula engine in the spreadsheet application. So if you create a spreadsheet using your application (in combination with the JXL or

Re: [Dhis2-devs] How to get the calculated value from an input formula string ?

2009-06-29 Thread Bob Jolliffe
r OpenOffice, than it is not wise. You better to give another formula > from the root for new column value, otherwise you will get something terrible > as Bob explained. > > regards, > murod > > > > - Original Message > From: Bob Jolliffe > To: Hieu Dang Duy

Re: [Dhis2-devs] How to get the calculated value from an input formula string ?

2009-06-29 Thread Bob Jolliffe
y the alfresco document management system to do conversion between file formats, creating pdfs etc. Regards Bob > Thank you, thank you so much. > > On Mon, Jun 29, 2009 at 6:09 PM, Bob Jolliffe wrote: >> >> Hi >> >> I don't know if I have the right understandi

Re: [Dhis2-devs] How to get the calculated value from an input formula string ?

2009-06-29 Thread Bob Jolliffe
tes I earlier pointed you: > http://poi.apache.org/spreadsheet/formula.html. and > http://sc.openoffice.org/excelfileformat.pdf. if you want more information. > > murod > > > > - Original Message > From: Bob Jolliffe > To: Hieu Dang Duy > Cc: Murodullo Latifov ; dhi

Re: [Dhis2-devs] DHIS2-lite on a Mac

2009-07-01 Thread Bob Jolliffe
2009/7/1 Saptarshi Purkayastha : > Seems like Java6 is missing and SystemTray class was added in Java6. Other > than that, dhis2-lite package already deals with platform not support system > tray and it will exit gracefully. > Please install the new Java6 for OSX and it should work fine. Yes this

Re: [Dhis2-devs] DHIS2-lite on a Mac

2009-07-01 Thread Bob Jolliffe
2009/7/1 Knut Staring : > On Wed, Jul 1, 2009 at 5:10 PM, Saptarshi Purkayastha > wrote: >> >> Seems like Java6 is missing and SystemTray class was added in Java6. > > Yes, that is probably the issue. I think we need to make the requirement for > Java 6 explicit on dhis2.com, though, as I had comp

Re: [Dhis2-devs] DHIS OpenMRS integration

2009-07-27 Thread Bob Jolliffe
Hi Murod will present a demo of his ideas tomorrow and we will discuss also with Paul. I think in principle it can work though there are many details to consider. One concern of mine is the need to transfer data element id and combo id. Unless these are unique identifiers this can get messy -

Re: [Dhis2-devs] DHIS OpenMRS integration

2009-08-03 Thread Bob Jolliffe
Hi 2009/8/1 Murodullo Latifov > > Hi, > > > > - Original Message > From: Jo Størset > To: DHIS 2 developers > Sent: Friday, July 31, 2009 3:30:41 PM > Subject: Re: [Dhis2-devs] DHIS OpenMRS integration > > Hi, > > Den 28. juli. 2009 kl. 14.51 skrev Saptarshi Purkayastha: > > > But may

Re: [Dhis2-devs] DHIS OpenMRS integration

2009-08-04 Thread Bob Jolliffe
Hi Murod Do you have an example of the XML you are using? I want to see how far it might be from the DXF we are already using, should it be incorporated or what ... I remember seeing a small snippet but would be good to share a file or two. Regards Bob 2009/8/3 Murodullo Latifov > Hi, > > >>

Re: [Dhis2-devs] DHIS OpenMRS integration

2009-08-04 Thread Bob Jolliffe
er > from implementation to implementation. > > regards, > murod > > ------ > *From:* Bob Jolliffe > *To:* Murodullo Latifov > *Cc:* Jo Størset ; DHIS 2 developers < > dhis2-devs@lists.launchpad.net> > *Sent:* Tuesday, August 4, 2009 5:31:29

Re: [Dhis2-devs] DHIS OpenMRS integration

2009-08-04 Thread Bob Jolliffe
to > look like IXF/DXF or SDMX-HD is not a big issue, we can do it in many levels > before output. > > regards, > murod > > ------ > *From:* Bob Jolliffe > *To:* Murodullo Latifov > *Cc:* Jo Størset ; DHIS 2 developers < > dhis2-devs@lists

Re: [Dhis2-devs] DHIS OpenMRS integration

2009-08-05 Thread Bob Jolliffe
We should just have modules for importing data (and the fewer the better). And perhaps modules which expose services, like for example request for data element definitions. Regards Bob > > > -- > *From:* Bob Jolliffe > *To:* Murodullo Latifov >

Re: [Dhis2-devs] OpenMRS integration

2009-08-05 Thread Bob Jolliffe
Thanks Lars. I will take responsibility for putting together and implementing a plan of action for this. This will have to include absorbing the learning from the various integration efforts which have happened - there is the work Abyot has done, there is work Phumzile and others have done on the

[Dhis2-devs] Sample data

2009-08-05 Thread Bob Jolliffe
Hi Does anybody have some sample data which uses multidimensional data values (ie. datavalues which uses dataCategoryOption combos) which they can share with me. Thanks Bob ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lis

Re: [Dhis2-devs] Sample data

2009-08-06 Thread Bob Jolliffe
Total of > District*) we will assign the combination of categories *Category > Combination BCH4* for this one. > > Finally, you should be have the result as picture.* > > *Just a quick comment, any idea ?* > > * > On Wed, Aug 5, 2009 at 11:02 PM, Bob Jolliffe wrote: &

Re: [Dhis2-devs] Sample data

2009-08-06 Thread Bob Jolliffe
the > latest implementation) use multidimensional. can any one share Bob any of > this DBs? > > Thank you > Abyot. > > > On Thu, Aug 6, 2009 at 12:39 PM, Bob Jolliffe wrote: > >> Thanks Hieu >> >> All these examples are helpful. >> >> Regards >>

Re: [Dhis2-devs] OpenMRS integration

2009-08-06 Thread Bob Jolliffe
Great. I will propose a strategy within next day or two to dhis group. Assuming we have consensus we can move forward with this in our interaction with openmrs, baobab, ihris and others. Regards Bob 2009/8/6 Ola Hodne Titlestad > 2009/8/5 Bob Jolliffe > >> Thanks Lars.

Re: [Dhis2-devs] OpenMRS integration

2009-08-07 Thread Bob Jolliffe
rity. > > > > Bob, include tz and mw in your mandate for dhis integration. We want > > generic approach to mapping and etl w dhis as destination. Note that > > baobab should be thight as openmrs as they are large national project > > w whom we working. Openmrs is

Re: [Dhis2-devs] OpenMRS integration

2009-08-07 Thread Bob Jolliffe
government should mandate an electronic format (just as currently they mandate a paper form) which Care2X, AfyaPro and others should be able to produce and which dhis2 can consume. > > > Juma Lungo > > Original Message > Subject: Re: OpenMRS integration &g

Re: [Dhis2-devs] OpenMRS integration

2009-08-10 Thread Bob Jolliffe
o a lot of relief of manual collation and aggregation at that level. Regards Bob 2009/8/7 Dr. Juma Lungo > > Original Message > Subject: Re: OpenMRS integration > From: Bob Jolliffe > Date: Fri, August 07, 2009 8:57 am > To: "Dr. Juma Lungo" > C

Re: [Dhis2-devs] OpenMRS integration

2009-08-10 Thread Bob Jolliffe
. Cheers Bob > > I hope I have answered most of the questions, > > cheers > > On Fri, Aug 7, 2009 at 8:37 PM, Dr. Juma Lungo wrote: > >> >> Original Message >> Subject: Re: OpenMRS integration >> From: Bob Jolliffe >> Date: Fri, Au

[Dhis2-devs] vmware spring

2009-08-11 Thread Bob Jolliffe
So vmware is acquiring springsource. That's a bit nerve racking ... http://blogs.vmware.com/console/2009/08/vmware-acquires-springsource.html?client=firefox-a&rls=com.ubuntu:en-US:unofficial&hs=ROE&ei=tI6BStuqLpO7jAfA-Mj2CQ&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=springsource%20vmware&spell=1 Ch

Re: [Dhis2-devs] Formalizing a DHIS2 SRS

2009-08-13 Thread Bob Jolliffe
Hi Saptarshi That's an impressive piece of work. What about putting a copy on google docs for people to make their inputs. Regards Bob 2009/8/13 Saptarshi Purkayastha > Please find the attached Software Requirement Specification document that > we have created for the purpose of certifying DH

Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2

2009-08-14 Thread Bob Jolliffe
2009/8/14 Knut Staring > Delighted to see progress on this. > > One thing that I've encountered (and which should become a blueprint), is > that you would like to automatically generate users who only have access to > subtrees (at a certain level). > > The concrete example is that you have all th

Re: [Dhis2-devs] DHIS2 - Struts2 - Spring Security2

2009-08-14 Thread Bob Jolliffe
ality on > security, and every next time from that machine he will be authenticated > automatically. > I think we should consider disabling this feature. Its not a good idea to allow this. Anyway, don't mean to sabotage your call ... you are calling for use cases for user roles. Regar

Re: [Dhis2-devs] DHIS-lite and check for Java

2009-08-18 Thread Bob Jolliffe
2009/8/18 Knut Staring > Here is the current content of startup.bat for DHIS-lite: > > @echo off > > if not "%JAVA_HOME%" == "" goto startup > :abort > echo DHIS 2 requires a Java Runtime Environment to be installed > pause > goto end > :startup > echo Starting DHIS 2... > java -jar dhis2-lite.ja

Re: [Dhis2-devs] DHIS-lite and check for Java

2009-08-18 Thread Bob Jolliffe
given that its an executable jar, do we even need a batch file at all? Assuming java is installed on the host machine won't it just start by double clicking on it? Or should we be trying to catch and report the situation that java is not installed? 2009/8/18 Lars Helge Øverland > OK will fix th

Re: [Dhis2-devs] DHIS-lite and check for Java

2009-08-18 Thread Bob Jolliffe
Mind you ... though we don't need JAVA_HOME there might be a case for setting JAVA_OPTS. Maybe we just need an explanatory note on the website about production-vs-demo and tuning. 2009/8/18 Lars Helge Øverland > 2009/8/18 Bob Jolliffe : > > given that its an executable jar, do

Re: [Dhis2-devs] DHIS-lite and check for Java

2009-08-18 Thread Bob Jolliffe
, I would suggest looking at Netbeans or Vuze. > > --- > Regards, > Saptarshi PURKAYASTHA > Director R & D, HISP India > Health Information Systems Programme > > My Tech Blog: http://sunnytalkstech.blogspot.com > You Live by CHOICE, Not by CHANCE > > > 2009/

[Dhis2-devs] Fwd: DHIS-lite and check for Java

2009-08-18 Thread Bob Jolliffe
oops sorry. forgot the list ... -- Forwarded message -- From: Bob Jolliffe Date: 2009/8/18 Subject: Re: [Dhis2-devs] DHIS-lite and check for Java To: Saptarshi Purkayastha I see there are a number of examples of these jvm wrapper programs - for instance this oldish looking

Re: [Dhis2-devs] Migration to Struts2 complete

2009-08-20 Thread Bob Jolliffe
Well done Lars and Murod! This is a really major commit. Regards Bob 2009/8/20 Lars Helge Øverland > Hi, > > I have merged in Murod's work on the Struts2 upgrade. Thanks to Murod > for good work on this! > > > Additionally the dhis-support-webwork (struts) has been merged with > dhis-web-commo

[Dhis2-devs] [Bug 418534] [NEW] dhis2 lite doesn't launch if there are spaces in the file or foldernames.

2009-08-25 Thread Bob Jolliffe
Public bug reported: When dhis2-lite package is unzipped in folder such as "My Documents" the space in the filename causes the web application contexts (dhis2 and birt) not to be resolved. Behaviour is the same on windows and linux. ** Affects: dhis2 Importance: Undecided Status: N

[Dhis2-devs] [Bug 418534] Re: dhis2 lite doesn't launch if there are spaces in the file or foldernames.

2009-08-25 Thread Bob Jolliffe
** Changed in: dhis2 Status: New => Fix Committed -- dhis2 lite doesn't launch if there are spaces in the file or foldernames. https://bugs.launchpad.net/bugs/418534 You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. Status in DH

Re: [Dhis2-devs] Should we remove the Source object?

2009-08-26 Thread Bob Jolliffe
Lars I think you are right. I think the household/person was the closest I think we got to considering deriving something else from source other than organisation unit. I'd put it on notice - if you don't get any suggested use cases before the weekend (or some other arbitrary point in time) then

Re: [Dhis2-devs] Should we remove the Source object?

2009-08-26 Thread Bob Jolliffe
2009/8/26 Abyot Gizaw > > > 2009/8/26 Lars Helge Øverland > >> 2009/8/26 Abyot Gizaw : >> > >> > >> > 2009/8/26 Lars Helge Øverland >> >> >> >> Hi, >> >> >> >> I have been thinking about removing the Source object from the API. >> >> The abstract Source class was introduced in the model in orde

Re: [Dhis2-devs] DHIS 2 "lite" should be renamed

2009-08-26 Thread Bob Jolliffe
2009/8/26 Jason Pickering > Well, seems like the old Diet Coke vs. Coke Lite debate, coming from a > resident of the home of Coca-Cola. :) > > Even as a rather "advanced" user of DHIS2, I have not seen DHIS2Lite > (or Express) in action. It is not clear to me what the capabilities or > limitation

Re: [Dhis2-devs] Supporting MS Sql Server?

2009-08-27 Thread Bob Jolliffe
2009/8/27 Ola Hodne Titlestad > Hi, > > It shouldn't require that much work though. > Lars? > > I remember we added support for H2 some months back, and it didn't take > that much time, at least that was my impression. As I recall 95% of it is really quick. Then we struggle with the details of

Re: [Dhis2-devs] Problems using Mysql

2009-08-30 Thread Bob Jolliffe
Hi Knut Seems like something schizophrenic is happening. As far as I know MySQL does not support or use sequences. It uses auto-incrementing instead. It looks almost like you're trying to import something from postgres sql to mysql. What are you doing when you get this error? Any chance that

Re: [Dhis2-devs] Strange data value storing problem with a Dhis2 lite installation

2009-09-03 Thread Bob Jolliffe
Hi Ola This sounds weird. I'll have a look. Anyway to browse the database you should download the h2 database engine from http://www.h2database.com/html/main.html When you run h2.sh or h2.bat it should open you a web interface from where you can connect to your database using the jdbc:h2:... ur

[Dhis2-devs] [Bug 424248] [NEW] data entry doesn't persist with h2 database

2009-09-04 Thread Bob Jolliffe
Public bug reported: When entering data through data entry forms the data is not saved. Effects H2 database as used in dhis2-lite. Problem was not present in dhis 2.0.1 ** Affects: dhis2 Importance: Undecided Status: New ** Affects: dhis2/2.0.2 Importance: High Stat

[Dhis2-devs] [Bug 368791] Re: dhis2-lite package does not pick up installation directory on ubuntu gnome

2009-09-04 Thread Bob Jolliffe
** Changed in: dhis2 Status: Fix Committed => Won't Fix -- dhis2-lite package does not pick up installation directory on ubuntu gnome https://bugs.launchpad.net/bugs/368791 You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. Statu

Re: [Dhis2-devs] Strange data value storing problem with a Dhis2 lite installation

2009-09-04 Thread Bob Jolliffe
Hi Ola I have confirmed that its not related to your Armenia database. Data entry works as expected on 2.0.1. Some bug has crept into 2.0.2 - maybe related to transaction management upgrade. Will do a diff and check. Meanwhile filing bug report ... Regards Bob 2009/9/3 Ola Hodne Titlestad

[Dhis2-devs] [Bug 424248] Re: data entry doesn't persist

2009-09-04 Thread Bob Jolliffe
** Summary changed: - data entry doesn't persist with h2 database + data entry doesn't persist ** Description changed: When entering data through data entry forms the data is not saved. Effects H2 database as used in dhis2-lite. Problem was not present in dhis 2.0.1 + + This also seem

Re: [Dhis2-devs] dhis-web-mapping and dhis-openhealth-integration projects relocated

2009-09-04 Thread Bob Jolliffe
Congratulations to Jan and all on the arrival of dhis-web-mapping into trunk! 2009/9/4 Lars Helge Øverland > > Hi, > > I have moved some projects in trunk to reflect what will be included in the > standard release. > > dhis-web-mapping has been moved from /gis to /dhis-2/dhis-web. > > dhis-web-o

[Dhis2-devs] Fwd: DHIS 2 "lite" should be renamed

2009-09-06 Thread Bob Jolliffe
-- Forwarded message -- From: Bob Jolliffe Date: 2009/9/6 Subject: Re: [Dhis2-devs] DHIS 2 "lite" should be renamed To: Jason Pickering +1 I think that's an excellent suggestion. 2009/9/5 Jason Pickering For some reason, perhaps due to good marketing by Micr

Re: [Dhis2-devs] DHIS 2 Documentation

2009-09-10 Thread Bob Jolliffe
I think docbook is a really good choice for DHIS documentation. And the emacs mode works more than fine ... Openoffice will also save as docbook. I haven't checked how clean it is, but it is possibly a good route for first pass conversion from ms word. Cheers Bob 2009/9/10 Jason Pickering >

[Dhis2-devs] openmrs meeting

2009-09-11 Thread Bob Jolliffe
Greetings Just a quick feedback of first half day of openmrs hackathon. There's an ongoing overview here http://openmrs.org/wiki/2009_Hack-a-thon_Thursday. Just got off the plane and was thrown into the hot seat discussing integration. It seems my first thoughts around the reporting module of o

  1   2   3   4   5   6   7   8   9   10   >