Re: [Dhis2-users] [Dhis2-devs] tabular tracker capture app in appstore

2014-10-10 Thread Bob Jolliffe
Nice that PSI has made their work available. Though I worry a little bit about the way we go with this app business. Specifically: 1. there is no licence 2. there is no pointer to source code 3. the app is in "our" app store on dhis2.org. What does that mean? It is somehow endorsed for qualit

Re: [Dhis2-users] [Dhis2-devs] dhis2 system administration list

2014-10-09 Thread Bob Jolliffe
be a forum > would be a better media for such discussions? > > Regards, > Jason > > > On Thu, Oct 9, 2014 at 12:06 PM, Alex Tumwesigye > wrote: > >> Brilliant idea. >> Let's go for it. >> >> Alex >> >> On Thu, Oct 9, 2014 at

Re: [Dhis2-users] [Dhis2-devs] new tutorial on spdy and dhis

2014-10-09 Thread Bob Jolliffe
That looks good and straightforward to setup. Have you seen any noticeable speedup? On 9 October 2014 08:27, Lars Helge Øverland wrote: > Hi, > > was playing around with nginx and realized how simple it is to set up SPDY > . SPDY is a network protocol that > m

[Dhis2-users] dhis2 system administration list

2014-10-08 Thread Bob Jolliffe
Hi all Steven Uggowitzer recently raised the idea with me to create a system administrators list. Aimed at backend sort of things relating to the operating system, security, database tuning, dhis2-tools, virtual machine images etc. Those geeky sort of things which are not about java development

Re: [Dhis2-users] [Dhis2-devs] configure localhost for emailing

2014-10-01 Thread Bob Jolliffe
> Hi bob, > what could I can do? if the server I hosting is windows. > > thank you > CHANNARA > *From:* Bob Jolliffe > *Sent:* Tuesday, September 30, 2014 6:18 Evening > > *To:* channara rin > *Cc:* DHIS 2 Developers list , DHIS 2 > Users list > > At Lars&#

Re: [Dhis2-users] [Dhis2-devs] configure localhost for emailing

2014-09-30 Thread Bob Jolliffe
At Lars's suggestion I've added those instructions (plus a little extra) to a small tutorial here https://www.dhis2.org/node/48. On 30 September 2014 12:08, wrote: > Great, I will do follow > > thank you > *From:* Bob Jolliffe > *Sent:* Tuesday, September 30

Re: [Dhis2-users] [Dhis2-devs] configure localhost for emailing

2014-09-30 Thread Bob Jolliffe
Hi Rin It is easy enough to setup with either postfix or exim4 to send mail directly from the host. BUT, the most important thing is to have your networking properly setup ie. you must have a fully qualified domain name and make sure that hostname and /etc/hosts is correct. If you don't have thi

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-24 Thread Bob Jolliffe
m > > On Wed, Sep 24, 2014 at 11:03 AM, Bob Jolliffe > wrote: > >> You could install the function into the database through the postgres >> backend. >> >> Then you can include the function into select statements. For example: >> >> select organisation

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-24 Thread Bob Jolliffe
dump the data and post updates though the web api. This seems to be > way too much maintenance and would be better if one could use an sql > statement like yours instead. > > Thanks > > Regards, > Busoye > On 24 Sep 2014, at 10:16, Bob Jolliffe wrote: > > For what its

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-24 Thread Bob Jolliffe
For what its worth the following is the sql I used to extract the latest value of a population dataelement. I am sure it could be generalized and maybe implemented as a getLastValue method on a dataelement. --- -- function returns m

Re: [Dhis2-users] HTML version of API report not available in 2.16

2014-09-15 Thread Bob Jolliffe
Hi Ferdie The issue got some discussion here https://www.mail-archive.com/dhis2-users@lists.launchpad.net/msg04763.html. Some browser extensions were suggested which make navigation via clickable links straightforward. Works for me :-) Cheers Bob On 15 September 2014 11:31, Knut Staring wrote

Re: [Dhis2-users] Any Good Manual HTML Reports??

2014-09-05 Thread Bob Jolliffe
Hi Morina You can see pretty much everything which is available (fonts, css, javascript etc) in the source code repository here: http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/2.16/files/head:/dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/ Though naturally you'd

Re: [Dhis2-users] DHIS2.14 INSTALLATION overwriting database on startup

2014-09-02 Thread Bob Jolliffe
Can you go to the "About DHIS2" page and tell us what you see under database type and database name? The main culprit for it overwriting would be that it is not actually succeeding to connect and so you just have a transient in-memory database which disappears each time you shut down. On 2 Septe

Re: [Dhis2-users] [Dhis2-devs] IMPORTANT: Vulnerability discovered in DHIS2 version 2.16 and some versions of trunk.

2014-09-02 Thread Bob Jolliffe
Thanks JP for the feedback. If you are using dhis2-tools you can upgrade to the latest stable when you get the chance with: dhis2-deploy-war But its always good to have ufw enabled anyway to provide some strength in depth and protect against mistakes, misconfigurations etc On 2 September 2014

Re: [Dhis2-users] [Dhis2-devs] Requirement related to indicators - Target vs achieved

2014-09-02 Thread Bob Jolliffe
Hi Maheed I am sure you will get much more informed feedback on this question because I think its something many folk grapple with. Just a quick observation regarding implementation. > I don't know if anybody have similar issues or requirements like this one. > > I think 2 thinks are missing he

Re: [Dhis2-users] [Dhis2-devs] Email in user account

2014-09-01 Thread Bob Jolliffe
You also do need to configure email under dhis2 system settings so that it can deliver mail to these email addresses. On 1 September 2014 10:23, Jason Pickering wrote: > This needs to be configured for each and every user, as this settting is > specific to each user, if I understand you correct

Re: [Dhis2-users] [Dhis2-devs] API resources navigation

2014-08-25 Thread Bob Jolliffe
Yes that will be nice. I also miss the api navigation ... didn't realize how much I used it till it went :-( On 25 August 2014 15:08, Knut Staring wrote: > Hi Maheed, > This is intentional. We do agree that the previous interface was much > easier to navigate, but it had other issues that nee

Re: [Dhis2-users] [Dhis2-devs] dhis and encryption

2014-08-21 Thread Bob Jolliffe
Hi Lars Quick question. I see a lot of people are happily upgrading to 2.16 but not so sure everyone has read the note as they should. If the system is started without encryption password set and later it is set what will that mean? I'm guessing there will be no problem unless something has alre

Re: [Dhis2-users] Data Visualizer and pivot table not displaying in 2.15

2014-08-16 Thread Bob Jolliffe
I just cleared the nginx cache as well but this does not seem to be the problem. On 16 August 2014 13:16, Anthony Danso wrote: > I have Cleared the Browser cache completely but its still displaying same > page as blank. > On Aug 16, 2014, at 12:10 PM, Anthony Danso wrote: > > After the reload

Re: [Dhis2-users] files

2014-08-07 Thread Bob Jolliffe
erald thomas wrote: >>>> > >>>> >> Dear Knut, >>>> >> I want to know if the dhis2-tool for Ubuntu 12.04 works on a >>>> >> standalone server. I had tried it several times but it doesn't work. >>>> >> Am i doin

Re: [Dhis2-users] files

2014-08-07 Thread Bob Jolliffe
omas > wrote: > >> Dear Knut/Bob, >> I need your help. It will be a good tool to have as it will reduce the >> stress and work load on dhis >> >> On 8/7/14, Bob Jolliffe wrote: >> > Hi Gerald >> > >> > You can certainly install on a

Re: [Dhis2-users] files

2014-08-07 Thread Bob Jolliffe
t;> > >> thanks > >> > >> > >> On Sat, May 31, 2014 at 6:09 PM, Knut Staring wrote: > >> > >>> -- Forwarded message -- > >>> From: "Bob Jolliffe" > >>> Date: May 30, 2014 3:50 PM > >>> Su

Re: [Dhis2-users] ICD10

2014-08-07 Thread Bob Jolliffe
Thanks Nayeem for sharing that experience. I had assumed that Simon was referring to aggregate data, perhaps wrongly. Simon, for individual event capture there is also an example of what Nayeem describes on our demo site https://apps.dhis2.org/demo/dhis-web-event-capture/index.html. Regards Bob

Re: [Dhis2-users] Quick way to add missing ISO weeks going back to 2011?

2014-08-06 Thread Bob Jolliffe
; I suppose I can pretend they are the same for the import process and then >> work out a way to change later. The main issue is that the period selector >> in data entry displays the Week number as well as the start and end dates, >> otherwise users would never not

Re: [Dhis2-users] Quick way to add missing ISO weeks going back to 2011?

2014-08-05 Thread Bob Jolliffe
On 5 August 2014 12:04, Bob Jolliffe wrote: > No nothing better but could rattle something off - in something slightly > less exotic than R :-) > > Two questions mind you (more for developers): > 1. I see we have a period_periodid_seq which doesn't seem to be used. I >

Re: [Dhis2-users] Quick way to add missing ISO weeks going back to 2011?

2014-08-05 Thread Bob Jolliffe
eek.starts),0,8)) > > sql<-paste0("INSERT INTO periods (periodid,periodtypeid,startdate,enddate) > VALUES(nextval('hibernate_sequence'::regclass),2,","'",as.Date(week.starts),"','",as.Date(week.ends),"');") > ca

Re: [Dhis2-users] Quick way to add missing ISO weeks going back to 2011?

2014-08-05 Thread Bob Jolliffe
Randy do you need a script to generate these? On 4 August 2014 17:11, Wilson, Randy wrote: > Hi all, > > I thought I saw a posting on inserting periods into the DHIS-2 for earlier > periods in time, but can't seem to find it any longer. > > I need ISO weekly periods going back to 2011. I also n

Re: [Dhis2-users] Fwd: Upgrade of Customize war file

2014-07-31 Thread Bob Jolliffe
Forwarded message -- > From: gerald thomas > Date: Tue, 29 Jul 2014 17:00:21 + > Subject: Re: [Dhis2-users] Upgrade of Customize war file > To: Bob Jolliffe > Cc: dhis2-users > > Dear All, > Bob, this is a different server from that which is locate

Re: [Dhis2-users] Emails not being sent

2014-07-31 Thread Bob Jolliffe
email. Sorry it is not very helpful to you for me to confirm that it "works here" but that is all I have at the moment. Bob On 31 July 2014 08:18, WILLIAMS, Ryan O'Neil wrote: > Ok, thanks. Please let me know. > > Cheers > > ryan > > > > *From:*

Re: [Dhis2-users] Emails not being sent

2014-07-29 Thread Bob Jolliffe
item 1 works and not 2, leads me to believe that it is not only an > email issue. > > > > I will try to test for communications between the server and the email > server. > > > > Thanks > > ryan > > > > *From:* Bob Jolliffe [mailto:bobjolli...@gmail.c

Re: [Dhis2-users] Upgrade of Customize war file

2014-07-29 Thread Bob Jolliffe
Hi Gerald Is this the server in the national office or one of the district servers (you can respond to me off list)? My understanding is that Romain already went through the process of upgrading the old national database on the linode. So what you are taking about now is something different to w

Re: [Dhis2-users] Emails not being sent

2014-07-29 Thread Bob Jolliffe
e still not being send via the message module, > even though the recipients all have "Enable message email notifications" > checked. > > No lines concerning messages appear in the log. Should message be sent > immediately or is there a scheduler for this? > > > >

Re: [Dhis2-users] Emails not being sent

2014-07-25 Thread Bob Jolliffe
/dhis.war) you will find that the email from_address setting has been added. It might be your other problem is addressed as well. Regards Bob On 25 July 2014 09:56, WILLIAMS, Ryan O'Neil wrote: > I think that is as of 2.16. In 2.15 I don't see it. > > > > *From:* Bob

Re: [Dhis2-users] Emails not being sent

2014-07-24 Thread Bob Jolliffe
gt; > > > I will ask IT check the traffic information between the servers. > > I sent an email through the server from my computer via telnet using the > FROM_ADDRESS:nore...@dhis2.org and it went through fine. > > > > ryan > > > > *From:* Bob Jolliffe [mailto:b

Re: [Dhis2-users] Emails not being sent

2014-07-24 Thread Bob Jolliffe
Hi Ryan >From what I understand of the source code, if the message sending failed there should have been a warning entry in your log saying "Could not send email: ... ". If you are not seeing that then it is strange and not consistent with the documentation of the apache commons email library whi

Re: [Dhis2-users] API shifted from HTML to XML?

2014-07-14 Thread Bob Jolliffe
Much though I have to love json, this does seem to be a case where maintaining an xml stylesheet is the cleanest separation of form and content. What about adding an xml processing instruction to the xml like: /dxf2html.xsl"?> ... This will have no effect on consuming the xml normally (except

Re: [Dhis2-users] Problem retrieving raw data

2014-07-13 Thread Bob Jolliffe
Hi Knut I see the gow tools are distributed as simple binary exe files. Also they are "windows native" so probably compiled against the windows ssl libraries rather than openssl lib. From the curl docs here http://curl.haxx.se/docs/sslcerts.html I am sure your curl simply doesn't have access to

Re: [Dhis2-users] Creating groups and group sets by using the API

2014-07-08 Thread Bob Jolliffe
ataElementGroups. > > -- > Morten > > > On Tue, Jul 8, 2014 at 6:05 PM, Bob Jolliffe > wrote: > >> Hi Morten >> >> Is the 'members' necessary? >> >> I just tried exporting a groupset from demo using the detailed metadata >> ex

Re: [Dhis2-users] Creating groups and group sets by using the API

2014-07-08 Thread Bob Jolliffe
Hi Morten Is the 'members' necessary? I just tried exporting a groupset from demo using the detailed metadata export and I get rendered something like: {"created":"2014-07-08T10:59:37.392+","dataElementGroupSets":[{"name":"Diagnosis","created":"2011-12-24T11:24:25.124+","lastUpdated":"20

Re: [Dhis2-users] Connecting DHIS and Nginx

2014-07-04 Thread Bob Jolliffe
the server. > I was reading and i found out that Nginx can do it. That is my question. > i want to replay the http://localhost:8080/dhis with maybe http://bob > for instance. > Thanks in advance > > On 7/3/14, Bob Jolliffe wrote: > > Hi Gerald > > > > There are t

Re: [Dhis2-users] Connecting DHIS and Nginx

2014-07-03 Thread Bob Jolliffe
Hi Gerald There are three issues here. If you already know what i am on about then maybe it will be helpful to others if I explain anyway: 1. you can't just pick your own ip address unless its for use on an internal network where packets are not being exchanged with the public internet. So ins

Re: [Dhis2-users] Why is the build revision no longer available on the demo?

2014-06-25 Thread Bob Jolliffe
Hi Knut I tend to always download war files from the integration server so I always know for sure what i am getting. So for example, for the 2.15 series, you can see the latest build at: https://apps.dhis2.org/ci/job/dhis-2.15/lastSuccessfulBuild There you can see "changes" which will show you t

Re: [Dhis2-users] [Dhis2-devs] halvdan grelland joins as developer

2014-06-20 Thread Bob Jolliffe
Welcome Halvdan. Lars keep up the good work attracting talent away from the industrial-military complex :-) On 20 June 2014 10:55, Lars Helge Øverland wrote: > Hi all, > > I have the pleasure to announce that Halvdan Grelland has joined the team > as software developer on a 30% basis. > > Halv

Re: [Dhis2-users] Sharing Pivot Table details between DHIS instances

2014-06-20 Thread Bob Jolliffe
ritative source of orgunit information because you know the collection of routine data provides the best governance mechanism for your orgunit data. I see this as a slightly different idea to a registry, though related.. > > Greg > > On Fri, Jun 20, 2014 at 9:40 AM, Bob Jolliffe &g

Re: [Dhis2-users] Sharing Pivot Table details between DHIS instances

2014-06-20 Thread Bob Jolliffe
A multinational organisation should almost certainly maintain a registry of all *their* sites if they are to use dhis2 efficiently. And a standardized metadata repository where possible. For smaller setups this could lean towards a single global instance. For others a separation between registry

[Dhis2-users] new openssl vulnerability

2014-06-06 Thread Bob Jolliffe
For server admins, please check http://www.ubuntu.com/usn/usn-2232-1/ Very critical to update system if packages are not already up to date. Running the command: dpkg-query -l libssl1.0.0 should show that the version installed is 1.0.1-4ubuntu5.14. If not then you should run: sudo apt-get upda

Re: [Dhis2-users] [Dhis2-devs] DHIS quick installation package

2014-05-31 Thread Bob Jolliffe
Hi Jean Paul. I wonder weas the problem just that the last line in install.sh has commented out the instruction to install nginx and postgres? This is maybe confusing but is because it is possible to install dhis on a machine where postgres and nginx are on a different machine. On 31 May 2014 1

Re: [Dhis2-users] Fwd: [FOSSFA Members] Fwd: Call for applications: Infrastructure and Critical Internet Resources

2014-05-14 Thread Bob Jolliffe
reTel: +220 9907404 <%2B220%209907404> / > 7229017 Email: lbjaw...@yahoo.com * > *Web: http://lbjawara.wordpress.com <http://lbjawara.wordpress.com/>* > On Tuesday, May 13, 2014 10:02 PM, Bob Jolliffe > wrote: > Anyone in government departments wanting/needing to beef up the

[Dhis2-users] Fwd: [FOSSFA Members] Fwd: Call for applications: Infrastructure and Critical Internet Resources

2014-05-13 Thread Bob Jolliffe
Anyone in government departments wanting/needing to beef up their internet infrastructure expertise? -- Forwarded message -- From: Judy Okite Date: 13 May 2014 21:16 Subject: [FOSSFA Members] Fwd: Call for applications: Infrastructure and Critical Internet Resources To: members

Re: [Dhis2-users] DHIS-live: NO JSP Support for /,

2014-04-14 Thread Bob Jolliffe
o be much good with analytics/datamart reporting. But good luck. Let us know how you get on. > > > .Mark > > Mark Spohr, MD > mhsp...@gmail.com > +1 530 554 2230 > > > > > On Sun, Apr 13, 2014 at 4:43 PM, Bob Jolliffe wrote: > >> I'm not sure dhis2-live

Re: [Dhis2-users] DHIS-live: NO JSP Support for /,

2014-04-13 Thread Bob Jolliffe
D > mhsp...@gmail.com > +1 530 554 2230 > > > > > On Sun, Apr 13, 2014 at 3:44 PM, Bob Jolliffe wrote: > >> Hi Mark >> >> I also have a raspberry pi but don't ever get the chance to play with it >> :-) >> >> But if I was going t

Re: [Dhis2-users] DHIS-live: NO JSP Support for /,

2014-04-13 Thread Bob Jolliffe
Hi Mark I also have a raspberry pi but don't ever get the chance to play with it :-) But if I was going to get dhis to run on it I don't think I would use dhis2-live. dhis2-live assumes a window manager with shell support (like gnome) which is probably not what you want on your little pi. Are y

Re: [Dhis2-users] DHIS2 - Db Server / Postgresql Max Connections (FATAL: remaining connection slots are reserved...)

2014-04-09 Thread Bob Jolliffe
On 9 April 2014 15:27, Lars Helge Øverland wrote: > >> >> Lars, I haven't looked very recently, but to what extent are we creating >> new jdbc connections outside of the c3p0 pool? If we are only strictly >> using the pool its easier to provision these things. >> > > Like you point about we have

Re: [Dhis2-users] DHIS2 - Db Server / Postgresql Max Connections (FATAL: remaining connection slots are reserved...)

2014-04-09 Thread Bob Jolliffe
Yes Lars makes good warning about increasing max_connections means you need to take into account increased memory use per connection. Which is mostly affected by the work_mem setting. A few things to consider : 1. perhaps you only need to run a training server when training. 2. you might not ne

Re: [Dhis2-users] DHIS2 - Db Server / Postgresql Max Connections (FATAL: remaining connection slots are reserved...)

2014-04-09 Thread Bob Jolliffe
Hi Jason These problems happen under high concurrency conditions which seems to agree with your log snippet (11am would be when the users are thronging). There are 3 limits to consider which have some impact on one another (I think your immediate problem is the last of the 3): 1. From the java

[Dhis2-users] openssl vulnerability

2014-04-09 Thread Bob Jolliffe
Some of you may have seen the news regarding a serious vulnerability in openssl. Please check your systems using http://filippo.io/Heartbleed/ . If you are vulnerable (likely!) then you should ensure that you have updated your openssl package. you may also need to restart nginx. This blog with

Re: [Dhis2-users] openssl vulnerability

2014-04-09 Thread Bob Jolliffe
Clarification: this message is for server administrators rather than all dhis2 users. On 9 April 2014 12:23, Bob Jolliffe wrote: > Some of you may have seen the news regarding a serious vulnerability in > openssl. > > Please check your systems using http://filippo.io/Heartbleed/

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

2014-04-08 Thread Bob Jolliffe
I am not sure but I think this would happen if you try to try to import metadata after an earlier attempt has failed or not completed. What version of dhis2 are you using? mydatamart was well tested with earlier dhis2 versions up to about 2.11 but since the development of the web api and analytic

Re: [Dhis2-users] Benchmarking the speed of Importing Data into DHIS2.14

2014-04-04 Thread Bob Jolliffe
Hi Moses 2G seems like a lot for the OS, but agree that over allocating (and the subsequent swapping and thrashing) would certainly be harmful. Probably 1G for the OS would be sufficient. Bob On 4 April 2014 13:47, Moses Marimo wrote: > Thanks Jason. Problem Solved. "How much memory have you

Re: [Dhis2-users] nginx Reverse Proxy Config for Dedicated Web Server with multiple instances

2014-03-24 Thread Bob Jolliffe
The > "thing" already listening on port 80 was nginx itself, since the original > .conf changes I had tried to duplicate from dhis2.org were still there - > once I removed them, my problem went away - but I will remember the netstat > trick for next time... > > > >

Re: [Dhis2-users] nginx Reverse Proxy Config for Dedicated Web Server with multiple instances

2014-03-24 Thread Bob Jolliffe
Hi Jason You can't fix your problem with nginx config without first addressing your bind error. The error is simple enough - it just means something else is already listening on port 80. So try this: sudo netstat -ntlp |grep ':80' which will show you in the last column what exactly is listening

Re: [Dhis2-users] myDataMart

2014-03-20 Thread Bob Jolliffe
Hi Channara Mydatamart is not being actively maintained currently and I don't think has been tested against current dhis2 version. The current recommended way of getting data out of dhis2 is via the web based analytics api. Regards Bob On 19 March 2014 09:29, channara rin wrote: > Dear All u

Re: [Dhis2-users] Fwd: Dhis2 versão de teste

2014-03-18 Thread Bob Jolliffe
Hi Marcio The errno:150 in mysql usually refers to foreign key violations. Now I don't know enough about what is happening here to say for sure, but it looks like you have created a new blank database, run dhis2 against it (which creates tables) and then attempted your restoration. Can you do th

Re: [Dhis2-users] GPS capture and sync with local health facility registry

2014-03-11 Thread Bob Jolliffe
Hi Alvin I'll let someone else respond to your first question re gps, which seems like a good idea and also seems to be more related to functionality of dhis2 as a facility registry rather than as a routine reporting system, which I guess leads us to your second question .. If you really want to

Re: [Dhis2-users] GIS best practice choice of colours

2014-02-20 Thread Bob Jolliffe
just colour, and include more > symbols because currently it's rather limited. Especially for categorical > values the legend behaviour could be greatly improved. Bar/Pie charts as > symbols on the map would be cool but not a priority as there are more > suitable tools for that. &

[Dhis2-users] GIS best practice choice of colours

2014-02-20 Thread Bob Jolliffe
Hi I am no expert here, but I was talking last week with someone who had just been on a GIS course. She made the interesting observation that when you are displaying numerical data as shaded regions on a map, you should not mix primary colours in the same gradated scale because what you end up wi

Re: [Dhis2-users] the missing of API menu

2014-02-20 Thread Bob Jolliffe
Ah thats where it went! I was wondering ... On 20 February 2014 09:32, Olav Poppe wrote: > Hi, > go to Profile = > About DHIS, and the first item in the list is a link to > the API. > > You can also append /api to the URL of your server: if your server address > is http://apps.dhis2.org/demo

Re: [Dhis2-users] Issue importing CSV with categoryoptioncombos

2014-02-19 Thread Bob Jolliffe
urrently the only thing we could > match on is the categoryoptioncomboname. > > > > I'll try the new detailed metadata export features. Maybe that will help. > > > > Randy > > > > *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com] > *Sent:* Tuesday, Febru

Re: [Dhis2-users] Data visualizer has no data

2014-02-19 Thread Bob Jolliffe
Well spotted Ola. I missed that, which I shouldn't have because I have seen it from time to time. Mind you I can't help thinking that Carl's expectation is actually reasonable enough ... that in the absence of providing level names we should just provide some default. It is maybe a little bit od

Re: [Dhis2-users] Issue importing CSV with categoryoptioncombos

2014-02-18 Thread Bob Jolliffe
Lars what makes this scenario slightly fiddlier than normal (is there a normal!), is that it is only a subset of the datelements of the one system which are of interest in the other system. So its not a wholesale import-export of structural metadata. The orgunits at least should already be synche

Re: [Dhis2-users] Issue importing CSV with categoryoptioncombos

2014-02-18 Thread Bob Jolliffe
Hi Randy On 18 February 2014 13:06, Wilson,Randy wrote: > I'm moving data between instances of DHIS-2 (from the HMIS to the Data > Warehouse with a subset of data elements). > > > > Since the dataelementids and orgunitides are not always the same in the > two systems, I'm using the code fields

Re: [Dhis2-users] Maps of outbreaks

2014-02-15 Thread Bob Jolliffe
Hi Knut At the risk of appearing even more ignorant, doesn't this scenario bear some resemblance to tracked-entity-event, particularly as we have moved to generalize this beyond the scope of tracked persons? Soi event 1, some time in September, is a measles "outbreak" in a district. Event 2, som

Re: [Dhis2-users] [Dhis2-devs] OpenMRS to DHIS2

2014-02-11 Thread Bob Jolliffe
module or something more custom than that? > > > Edwin > > > > On Tue, Feb 11, 2014 at 2:36 PM, Bob Jolliffe wrote: > >> Hi Edwin >> >> This module (for better or for worse) doesn't make use of the openmrs >> reporting framework. It works on the

Re: [Dhis2-users] [Dhis2-devs] OpenMRS to DHIS2

2014-02-11 Thread Bob Jolliffe
Hi Edwin This module (for better or for worse) doesn't make use of the openmrs reporting framework. It works on the basis of reading the metadata for the dhis2 report (the dataelements) and mapping each of those to a SQL query. This make it highly suitable for (i) very customised openmrs deploym

Re: [Dhis2-users] [Dhis2-devs] Bangladesh's main DHIS2 installation hacked and solved

2014-02-06 Thread Bob Jolliffe
Hi Hannan I agree with Lars that what you describe (uploading of malicious files) sounds like an exploitation of the vulnerability in struts fixed around Christmas. I also agree that you don't want to run tomcat on port 80. The recommended configuration is to run a web proxy such as nginx or apa

Re: [Dhis2-users] Re-Direction of links on-line manual

2014-01-21 Thread Bob Jolliffe
Yes it seems ok from here to. It definitely looks like Nick has an old main page in his browser cache. On 21 January 2014 12:50, Lars Helge Øverland wrote: > Hi Nick, > > I think the issue here is that as we add new chapters and sections to the > manual, older links become invalid. In this cas

Re: [Dhis2-users] [Dhis2-devs] Welcome Andreas

2014-01-14 Thread Bob Jolliffe
Welcome Andreas On 14 January 2014 14:14, Abyot Gizaw wrote: > Welcome Andreas ! > > On Tue, Jan 14, 2014 at 12:59 PM, Lars Kristian Roland > wrote: > > Hi all, (sorry for cross-posting) > > > > Andreas Nergaard is joining the DHIS mobile team to coordinate the mobile > > requirements and deve

Re: [Dhis2-users] [Dhis2-devs] DHIS2 Meta-Data and Data Import Issues

2013-12-18 Thread Bob Jolliffe
On 18 December 2013 13:30, Morten Olav Hansen wrote: > I still cannot log in using an imported user. I suspect is it for the >> reason I mentioned in my original post i.e. importation of users was >> disabled? >> > > Did you check to see that the users exists in the system? we do support > import

Re: [Dhis2-users] [Dhis2-devs] DHIS2 Meta-Data and Data Import Issues

2013-12-18 Thread Bob Jolliffe
Hi Edwin Your problem seems to be some bad/duplicate data: Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "datavalue_pkey" Detail: Key (dataelementid, periodid, sourceid, categoryoptioncomboid)=(19243, 28829, 4788, 15) already exists. I have

Re: [Dhis2-users] How to import GML to GIS section in DHIS2

2013-11-08 Thread Bob Jolliffe
yes just looking at source code and I see there is a bug. It is still converting from gml to dxf1.0 which is no longer supported internally within dhis2. Can you report it as a bug or a blueprint or both. I'll try and fix this asap. On 8 November 2013 10:41, Knut Staring wrote: > Looks to m

Re: [Dhis2-users] All data available through DHIS2 API ?

2013-11-07 Thread Bob Jolliffe
Hi Stephane The coordinates are available on the /api/organisationUnits endpoint. So if you went to: /api/organisationUnits/.xml You will find a element which has the coordinates. On 7 November 2013 10:28, Stéphane Delbeke wrote: > Dear all, > > I am new to DHIS2 and just joined the commun

Re: [Dhis2-users] [Dhis2-devs] ireport deprecated

2013-11-06 Thread Bob Jolliffe
Hi Murod That does sound interesting. So you are manipulating the odf xml somehow. But in the end it is linked to what? A jdbc link to a database view? Or are you getting data with the analytics api? My earlier look at openoffice calc showed that it was not so good at manipulating very large a

Re: [Dhis2-users] How to import GML to GIS section in DHIS2

2013-11-06 Thread Bob Jolliffe
is GML file is created by software > like (ArcMap or FWTools) or do manual? > > > > Thank you again J > > Channara > > > > > > *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com] > *Sent:* Wednesday, November 06, 2013 4:25 PM > *To:* Knut Staring > *Cc:*

Re: [Dhis2-users] How to import GML to GIS section in DHIS2

2013-11-06 Thread Bob Jolliffe
Hi Channara This sample gml file from unit tests in the source code might help: http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/view/head:/dhis-2/dhis-services/dhis-service-importexport/src/test/resources/polygon.gml On 6 November 2013 08:23, Knut Staring wrote: > Dear Channara, > >

Re: [Dhis2-users] Dhis2 start up problem

2013-10-30 Thread Bob Jolliffe
ok good. what was it? On 30 October 2013 09:09, Isika Oliver wrote: > Thanks bob I figured it all out . > > > On Mon, Oct 28, 2013 at 9:07 PM, Bob Jolliffe wrote: > >> Hi Isika >> >> It looks to me like the startup error must have occurred earlier in your >

Re: [Dhis2-users] abyot gizaw joins as developer

2013-10-29 Thread Bob Jolliffe
Hey Abyot ... welcome back! On 29 October 2013 16:30, Lars Helge Øverland wrote: > Hi, > > we are happy to announce that Abyot Gizaw joins the DHIS 2 team as > software developer. Abyot has been part of the DHIS community for a long > time and has developed several components of the software. O

Re: [Dhis2-users] Dhis2 start up problem

2013-10-28 Thread Bob Jolliffe
Hi Isika It looks to me like the startup error must have occurred earlier in your log. Can you check? Either that or there is some kind of silent error thrown somewhere between startup task 6 and 7. Bob On 28 October 2013 16:13, Isika Oliver wrote: > Hi all, > Am experiencing the following,

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

2013-10-17 Thread Bob Jolliffe
Absolutely! Enjoyed the live presentation as well. On 17 October 2013 14:28, Marta Vila wrote: > Congratulations team!!! > > This really looks GREAT > > > > On 17 October 2013 13:50, Lars Helge Øverland wrote: > >> Hi all, >> >> DHIS 2 version 2.13 is out. This release brings some great new f

Re: [Dhis2-users] [Dhis2-devs] Analytics history

2013-10-15 Thread Bob Jolliffe
Its an interesting problem. I know the Ghana Health Service has gone through this pain recently enough with substantial district boundary reorganisation. They might want to comment on their experience to date. One observation worth making is that it is more rare for health facilities (points) to

Re: [Dhis2-users] [Dhis2-devs] week periods calculation

2013-10-12 Thread Bob Jolliffe
Hi Paulo You are right this looks like a bug. The week of 2008-12-29 2009-01-04 should be the first week of 2009, not the last week of 2008, because the Thursday in that week falls in January not December. Bob On 12 October 2013 20:55, Paulo Grácio wrote: > Hi all, > > ** ** > > As far a

Re: [Dhis2-users] using a CSV file for visualization

2013-10-11 Thread Bob Jolliffe
ld be in DXF? I was thinking that the DHIS2 > engine might find some data set that is missing during file importing > process. > > Thank you > > > On Fri, Oct 11, 2013 at 6:47 AM, Bob Jolliffe wrote: > >> Hi Alison >> >> XML is not really a better file forma

Re: [Dhis2-users] using a CSV file for visualization

2013-10-10 Thread Bob Jolliffe
Hi Alison XML is not really a better file format. There's nothing really wrong with CSV for tabular data. Whereas we don't always have control over the format of the CSV that we get, sometimes it is possible to process your CSV with a small script to convert it into dxf which can be imported. T

Re: [Dhis2-users] Single click import of CSV data is it possible in DHIS2?

2013-10-04 Thread Bob Jolliffe
Hi Mihayo You can import data values using csv, though the csv must conform to the format described here: http://www.dhis2.org/doc/snapshot/en/user/html/ch19s03.html Maybe more than 1 click but not many. Not sure what you mean by importing orgunits, but this is not straightforward to do with cs

Re: [Dhis2-users] DHIS2_HOME in ubuntu

2013-10-02 Thread Bob Jolliffe
This is one of the issues which we have addressed with the dhis2-tools package. It is a common problem that the tomcat gets started by the wrong system user. In your case it wouldn't start but in many cases I have seen people circumvent the problem by just starting as the root user which is worse

Re: [Dhis2-users] [Dhis2-devs] introducing matthieu pinard

2013-09-26 Thread Bob Jolliffe
Welcome Matthieu. We've been waiting for someone like you ... On 26 September 2013 13:50, Knut Staring wrote: > Warm welcome, Matthieu! You will fill a very important need in our network. > > Cheers, > Knut > > > On Thu, Sep 26, 2013 at 2:36 PM, Lars Helge Øverland > wrote: > >> Hi all, >> >>

[Dhis2-users] Fwd: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 12125: dhis2-tools - minor security issue with tomcat configuration. You need to

2013-09-17 Thread Bob Jolliffe
re/dhis2/trunk] Rev 12125: dhis2-tools - minor security issue with tomcat configuration. You need to To: DHIS 2 developers revno: 12125 committer: Bob Jolliffe branch nick: dhis2 timestamp: Tue 2013-09-17 19:55:30 +0100 message: dhis2-too

Re: [Dhis2-users] ERREUR DHIS2 Live

2013-09-16 Thread Bob Jolliffe
what does it say in the log file? This error seems to indicate that jetty started but somehow didn't start the dhis2 webapp, for which there could be many reasons. On 16 September 2013 14:38, riddy ndoma wrote: > My live DHIS2 worked well today morning I run it, it shows me an error: > HTTP ER

Re: [Dhis2-users] Standard iReports cache problem

2013-09-16 Thread Bob Jolliffe
to http; > #proxy_cache dhis; DONT CACHE! > > } > > Regards, > Jason > > > > On Mon, Sep 16, 2013 at 11:07 AM, Bob Jolliffe wrote: > >> I think the sendfile feature has to do with whether nginx does >> asynchronous i/o using the sendfile() function i

Re: [Dhis2-users] Standard iReports cache problem

2013-09-16 Thread Bob Jolliffe
I think the sendfile feature has to do with whether nginx does asynchronous i/o using the sendfile() function in linux kernel, so I doubt turning it on or off is going to help us here. Agree with Jason that pulling stuff back out of the cache is a hack but trying hard to think of a workaround. La

Re: [Dhis2-users] Standard iReports cache problem

2013-09-15 Thread Bob Jolliffe
The nginx server in Rwanda is caching. Another approach might be to clear specific elements from the nginx cache, rather than to clear the entire cache, though this would require some communication between front end users and back end administrators which would probably be too cumbersome in practi

<    1   2   3   4   5   >