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] 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/

[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] 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

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
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] 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] 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-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

[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] 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

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

[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] 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

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] [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] 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] 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] 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] 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] 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] 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] 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] 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] 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-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-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] 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
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] 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] 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] 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] 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
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-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] 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] 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] 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
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] 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] [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] [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] 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] 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] 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.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] 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] 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] [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] [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
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] 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] 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-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&#

[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] 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

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] 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] Need Some Help.

2014-10-14 Thread Bob Jolliffe
Anthony this sounds like it could be related to cache issues. Did you try "really clearing" browser cache as per this tutorial https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache? And clearing the nginx cache? On 14 October 2014 10:04, Anthony Danso wrote: > Dear all, > Am using

Re: [Dhis2-users] Need Some Help.

2014-10-15 Thread Bob Jolliffe
On Oct 14, 2014, at 9:43 AM, Bob Jolliffe wrote: > > Anthony this sounds like it could be related to cache issues. > > Did you try "really clearing" browser cache as per this tutorial > https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache? > > And clea

Re: [Dhis2-users] Need Some Help.

2014-10-15 Thread Bob Jolliffe
te any of the integrity issues listed and see if it is then usable. Bob On 15 October 2014 14:54, Anthony Danso wrote: > Hi Bob. > yes i did check all the elements in question,they are all aggregate yet > its still not displaying in the indicator creation area. > On Oct 15, 2014, at

Re: [Dhis2-users] Encrypt the hibernate.properties file in dhis-live

2014-10-22 Thread Bob Jolliffe
Hi Guy I am not sure if it really practical to encrypt the hibernate.properties file. Though certainly it is very important to protect it which should be done by placing access control restrictions on it. Essentially only the user which is running the tomcat process should have read access to th

Re: [Dhis2-users] [Dhis2-devs] Mydatamart import metadata problem.

2014-10-29 Thread Bob Jolliffe
Hi Rin Work on mydatamart has discontinued since about dhis version 2.14. The interfaces and data formats to dhis2 have changed a lot and mydatamart would have to be completely rewritten to keep up. Given that users can create datasets using the pivot table module and download as excel, there is

Re: [Dhis2-users] [Dhis2-devs] Confusing Use license on dhis2 website

2014-11-01 Thread Bob Jolliffe
Agree this is a bit confusing. I am assuming you read this here: http://hisp.org/html/policies.htm#terms This is actually the HISP South Africa web site and it looks like these are conditions which they are applying to the dhis 1.4 software. Given that they now also support v2 they should really

Re: [Dhis2-users] [Dhis2-devs] Confusing Use license on dhis2 website

2014-11-02 Thread Bob Jolliffe
ose with e.g. PostgreSQL, for instance. And we don't have a > problem with that. > > Regards > Calle > > > > On 1 November 2014 18:41, Bob Jolliffe wrote: > >> Agree this is a bit confusing. I am assuming you read this here: >> http://hisp.org/html/polici

Re: [Dhis2-users] [Dhis2-devs] Confusing Use license on dhis2 website

2014-11-02 Thread Bob Jolliffe
oftware/materials is OUR copyright because we have developed them - and we >> choose to allow anybody to download them, use them, re-distribute them, and >> use them for further development" >> >> Conceptually very similar to the historic standards for any scientific >> publ

[Dhis2-users] Fwd: FW: HIS Success Story in Bangladesh recognized as Be st Practice

2014-11-27 Thread Bob Jolliffe
Sorry for cross-posting from openmrs list in case you are on that too. Seems we are a "best practice" in Bangladesh. -- Forwarded message -- From: Hannan, Terry J (DHHS) Date: 27 November 2014 at 15:20 Subject: FW: HIS Success Story in Bangladesh recognized as Be st Practice To:

Re: [Dhis2-users] [Dhis2-devs] Help with DSH2 config.

2014-12-06 Thread Bob Jolliffe
The dhis2-tools manual is now in a chapter of the implementers guide. Agree it is not generally necessary or even desirable to be compiling your own war file with maven unless there is a very serious customisation requirement which can not be adequately addressed through web api and/or apps. On

[Dhis2-users] Managing metadata in a distributed setting

2014-12-10 Thread Bob Jolliffe
Hi I have been helping out in Rwanda with their dhis2 setup(s) and I want to share a couple of issues to see whether some of these have been experienced by others and whether we can put our collective heads together on the trickier ones. The setting is relatively complex in that they have a numbe

Re: [Dhis2-users] [Dhis2-devs] Managing metadata in a distributed setting

2014-12-10 Thread Bob Jolliffe
ion tool for this data > dictionary with major coding support coming from the HISP India developers. > Maybe they have scripts that can assist? > > Best, > Greg > > p.s. Gartner research group sometimes make sense (see attachment) > > > On Wed, Dec 10, 2014 at 7:41 PM,

Re: [Dhis2-users] [Dhis2-devs] Managing metadata in a distributed setting

2014-12-11 Thread Bob Jolliffe
h functionality have progressed, it seems obvious to > me that at least the basic categories and options should be contained in > the NDD (and pushed onto all systems using them). I'm less sure about > categoryoptionCOMBOS - that's might be a construct exclusive to DHIS2. > TBD

Re: [Dhis2-users] [Dhis2-devs] Creating Sync between Linode(External Server) and Local Server

2014-12-18 Thread Bob Jolliffe
Hi Gerald We tested this when I was in Sierra Leone and we were finding serious problems with bandwidth getting the data back to Sierra Leone. So you are going to have to think carefully about when and how often to synch. Currently your database files are very small as you don't have much data o

Re: [Dhis2-users] [Dhis2-devs] Creating Sync between Linode(External Server) and Local Server

2014-12-18 Thread Bob Jolliffe
it is crude but that help for now. > What is your take Bob. > > On 12/18/14, Bob Jolliffe wrote: > > Hi Gerald > > > > We tested this when I was in Sierra Leone and we were finding serious > > problems with bandwidth getting the data back to Sierra Leone. > &g

Re: [Dhis2-users] [Dhis2-devs] Creating Sync between Linode(External Server) and Local Server

2014-12-18 Thread Bob Jolliffe
5 war file then we create a SFTP > account on cloud server then we can use filezilla from the local > server to download the backup from the cloud server. > I know it is crude but that help for now. > What is your take Bob. > > On 12/18/14, Bob Jolliffe wrote: > > Hi Gerald >

Re: [Dhis2-users] About Users in the DHIS2

2014-12-18 Thread Bob Jolliffe
Hi Carlos I just added a few small snippets to a tutorial https://www.dhis2.org/node/58 which answers a similar if not identical question. To find the users who have never logged in you would probably want a script which (i) extracted all the users and (ii) searched the logs for any login or atte

Re: [Dhis2-users] [Dhis2-devs] Creating Sync between Linode(External Server) and Local Server

2014-12-18 Thread Bob Jolliffe
cript for that would > not be very complicated. > > Steffen > > On Dec 18, 2014, at 7:47 AM, gerald thomas wrote: > > Bob, > My Suggestion: > All local servers must be on 2.15 war file then we create a SFTP > account on cloud server then we can use filezilla from the

[Dhis2-users] On dhis2 as a terminology server ...

2014-12-22 Thread Bob Jolliffe
Just a brief note to capture some points of discussion between Jim Grace and myself last week lest they are forgotten forever. Three relatively minor enhancements to our model which would allow dhis2 to operate as a reasonable terminology service: 1. Extend the hard wired single "code" attribute

Re: [Dhis2-users] On dhis2 as a terminology server ...

2014-12-22 Thread Bob Jolliffe
, > -carl > On Dec 22, 2014 5:23 AM, Bob Jolliffe wrote: > > Just a brief note to capture some points of discussion between Jim Grace > and myself last week lest they are forgotten forever. > > Three relatively minor enhancements to our model which would allow dhis2 > to o

Re: [Dhis2-users] [Dhis2-devs] On dhis2 as a terminology server ...

2014-12-22 Thread Bob Jolliffe
not picturing the > need for a third field containing a UID for every code in the code table. > > We also need to find a way to make this backwards compatible with existing > systems. ;) > > Cheers, > Jim > > > On Mon, Dec 22, 2014 at 9:55 AM, Bob Jolliffe > wrote: >

Re: [Dhis2-users] Metadata export and category option combos

2015-01-06 Thread Bob Jolliffe
Hi Olav I hit the same problem last month and I think it is a bug - see https://bugs.launchpad.net/dhis2/+bug/1400085 As a workaround I made a set of xslt transforms which starts from the full metadata export and "prunes" it down to all metadata associated with, in my case, a dataelementgroup but

Re: [Dhis2-users] Metadata export and category option combos

2015-01-06 Thread Bob Jolliffe
Excellent. If its a small fix I wonder would it be easy to backport to 2.16? I can check. Then I can throw those xslt transforms away ... On 6 January 2015 at 12:37, Lars Helge Øverland wrote: > Hi Olav, > > this was actually fixed in trunk and 2.17 two days ago. You can now use > the meta-da

Re: [Dhis2-users] Metadata export and category option combos

2015-01-06 Thread Bob Jolliffe
os when exporting category combos with dependencies - it gives >> me categories, categoryOptions and categoryCombos only. >> >> Olav >> >> >> 6. jan. 2015 kl. 13.39 skrev Bob Jolliffe : >> >> Excellent. If its a small fix I wonder would it be easy to bac

Re: [Dhis2-users] dhis 2.17 Password Algorithm

2015-01-12 Thread Bob Jolliffe
Hi Jason Expanding yet further - and clearing up terminology - dhis2 does not encrypt the password and store it. If it did, and you had the key, then you could decrypt it. What dhis2 stores is a hash which is something calculated from the password. These hash algorithms are designed to be as ir

Re: [Dhis2-users] dhis 2.17 Password Algorithm

2015-01-12 Thread Bob Jolliffe
t; > > I hope that clarifies? Any suggestions would greatly appreciated. > > > > Kind regards, > > Jason. > > > > *From:* Dhis2-users [mailto:dhis2-users-bounces+jason= > hisp@lists.launchpad.net] *On Behalf Of *Bob Jolliffe > *Sent:* 12 January 2015 02:15 PM

Re: [Dhis2-users] Version Determination - in Db?

2015-02-05 Thread Bob Jolliffe
But it is a very good idea. Might be particularly useful, for example, to see it in the metadata export. Make a blueprint ... On 5 February 2015 at 13:04, Jason Pickering wrote: > No, not in the DB, but it is available through the API > > https://www.dhis2.org/doc/snapshot/en/developer/html/ch

Re: [Dhis2-users] Fwd: DHIS2 and Docker

2015-02-13 Thread Bob Jolliffe
Hi Paulo I've given some thought to running dhis2 as a docker container but in the end reached the conclusion that lxc provides a much more straightforward container technology for running dhis2. So for example in Rwanda they run a number of lightweight lxc containers : one for the nginx proxy, o

Re: [Dhis2-users] [Dhis2-devs] DHIS ARCHITECTURE

2015-03-03 Thread Bob Jolliffe
Hi Gerald I think only you have the answers to 2 and 4. 4 could of course be complicated or simple, depending on what exactly you hope to achieve with the Data integration Project. One (of the many possible) workflows I would suggest is nominating your HMIS system as the authoritative source of

Re: [Dhis2-users] Restore a large PostgreSQL dump

2015-03-11 Thread Bob Jolliffe
Knut and Jason are both right. There is no point dumping tables which can be recreated. But that in itself shouldn't cause an error restoring a dump and 16G is far from huge (of course too big for notepad++ but that's a different issue). What was the error message? On 11 March 2015 at 16:39, Knu

Re: [Dhis2-users] Restore a large PostgreSQL dump

2015-03-11 Thread Bob Jolliffe
gt; > Ngonidzashe Manika > > Data Officer > > +263 772 789673, nman...@hotmail.com, skype: ngoni.manika > > Ministry of Health and Child Care, AIDS and TB Unit, 2nd Floor, Library, Mkwati Building > > > > From: Bob Jolliffe [mailto:bobjolli...@gmail.com] > Sent:

Re: [Dhis2-users] [Dhis2-devs] How to change the financial year from a default (OctYYYY-SepYYYY) to another one

2015-03-16 Thread Bob Jolliffe
SDMX 2.1 has the concept of a REPORTING_YEAR_START_DAY. See http://sdmx.org/wp-content/uploads/2011/04/SDMX_2-1_SECTION_6_TechnicalNotes.pdf. Thus you can have PERIOD="2010" REPORTING_YEAR_START_DAY="--07-01" which would indicate the year running from 01-July-2010 to 31 Aug 2011. Not sure if th

Re: [Dhis2-users] Problem with tracker module

2015-03-18 Thread Bob Jolliffe
Hi Abyot I just had a quick look at the tracker app on one of the Rwanda dhis2 instances (it is running 2.17 built on 2015-01-21 02:05 - strange I don't see the build revision) The form has some attributes and the Enrollment date and Reporting date at the bottom. When I try to save I see that t

Re: [Dhis2-users] Problem with tracker module

2015-03-18 Thread Bob Jolliffe
Using google chrome Version 40.0.2214.115 (64-bit) on linux mint. On 18 March 2015 at 12:48, Bob Jolliffe wrote: > Hi Abyot > > I just had a quick look at the tracker app on one of the Rwanda dhis2 > instances (it is running 2.17 built on 2015-01-21 02:05 - strange I > don&

Re: [Dhis2-users] Problem with tracker module

2015-03-18 Thread Bob Jolliffe
e the > tracker app has run - you need to clear cache to that the new meta-data is > cached locally. We don't have a feature to auto-update local-cache. > > > --- > Thank you, > Abyot. > > On Wed, Mar 18, 2015 at 2:53 PM, Bob Jolliffe > wrote: > >> Hi Ab

Re: [Dhis2-users] Problem with tracker module

2015-03-18 Thread Bob Jolliffe
e? > > > --- > Thank you, > Abyot. > > On Wed, Mar 18, 2015 at 3:36 PM, Bob Jolliffe > wrote: > >> Hi Abyot >> >> Thanks for the explanation. That makes sense. So the second post is >> never happening because the registration is not completed. >

Re: [Dhis2-users] Problem with tracker module

2015-03-18 Thread Bob Jolliffe
instance and let you know. >> >> I'm sure it will do the trick. >> >> Randy >> >> On Wed, Mar 18, 2015 at 4:53 PM, Bob Jolliffe >> wrote: >> >>> The table does look exactly like it has many static atteruibutes which >>> shoul

Re: [Dhis2-users] Problem with tracker module

2015-03-18 Thread Bob Jolliffe
I just dropped these columns and it is now working. Thanks Abyot and Alex ... On 18 March 2015 at 15:15, Bob Jolliffe wrote: > Hi Abyot > > Looking at the upgrade script it ends with > > ALTER TABLE patient DROP COLUMN gender; > ALTER TABLE patient DROP COLUMN deathDate; >

Re: [Dhis2-users] [Dhis2-devs] System broken after upgrade to dhis2.18

2015-04-12 Thread Bob Jolliffe
Hi Ese I wonder did you end up with bits of the old and the new after upgrade. Make sure you (i) completely clear out webapps directory before deploying 2.18 war file and (ii) make sure you clear cache completely in browser and also proxy cache if you are using proxy. Bob On 12 April 2015 at 20

Re: [Dhis2-users] Cross database querying for updating data

2015-04-20 Thread Bob Jolliffe
If database B is restored off a backup of database A then it will probably work with some caveats. Clearly they are not exactly the same because you've got extra data in A which you are trying to push into B. So it depends really on what else might have changed in A. If you have made any changes

Re: [Dhis2-users] Cross database querying for updating data

2015-04-21 Thread Bob Jolliffe
;> Indeed Database A has extra data not available in B while B has data >>>>> missing in A. No changes have been made to orgunits, dataelements, >>>>> periods >>>>> or users. The delta is in data-values. I would really want to get views on >>>

Re: [Dhis2-users] [Dhis2-devs] [Bug 1449952] Re: analytics scheduling not working

2015-04-30 Thread Bob Jolliffe
Hi Lawrence I don't think this is a dhis2 bug so am removing from the bug list. I see there was no scheduled process fired between the 28th and 29th in your log. Can you check your 'Scheduling" settings under 'Data Administration' and see that scheduling is configured and started. Bob On 30 Ap

  1   2   3   4   5   >