Re: [Dhis2-devs] DHIS2 setup problem

2010-07-12 Thread Jason Pickering
Hi Roger, I am not 100% sure why you would need both Postgres and MySQL? Is this only for the benefit of the implementation team? I would recommend that a decision be made which one to use, and stick with either Postgres or MySQL. I myself would recommend Postgres, but there are others out there t

Re: [Dhis2-devs] Aggregating values

2010-07-12 Thread Jason Pickering
gusto wrote: >> Thanks!!! >> >> Caveman >> >> >> On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering >> wrote: >>> >>> A very common mistake is not having generated the resource tables, >>> namely "orgunitstructure". Cons

Re: [Dhis2-devs] Old BIRT reports not seen on DHIS2.05

2010-07-13 Thread Jason Pickering
Can you access the BIRT reports directly ? Each report will have a URL and you should be able to access the report directly, irrespective of whether DHIS2 is running. This is really just to check to be sure that BIRT is functioning properly. Also, you must have the exact same BIRT run time that you

Re: [Dhis2-devs] Aggregating values

2010-07-14 Thread Jason Pickering
e a dataelement for DHIS. >>> >>> So what we were doing is: >>> 1. Migrate the data from anywhere (EpiInfo, MSAccess and DBF) to MySQL. >>> >>> 2. On MySQL we have tables where the columns names of those tables >>> mapping to the dataelementid (whic

Re: [Dhis2-devs] Aggregating values

2010-07-14 Thread Jason Pickering
14, 2010 at 4:40 PM, Orvalho Augusto wrote: > There is nothing being logged. > > There are no views. > > Caveman > > > > On Wed, Jul 14, 2010 at 9:03 AM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Caveman, >> >> C

Re: [Dhis2-devs] Aggregating values

2010-07-14 Thread Jason Pickering
cess: 'admin' > (DefaultUserAuditService.java [http-8081-3]) > Jul 14, 2010 4:31:50 PM org.apache.velocity.runtime.log.JdkLogChute log > SEVERE: #parse() null argument > > Caveman > > > > On Wed, Jul 14, 2010 at 5:35 PM, Jason Pickering < > jason.p.picker...@gmail.com>

Re: [Dhis2-devs] Aggregating values

2010-07-14 Thread Jason Pickering
g=null > Jul 14, 2010 6:42:13 PM org.apache.catalina.startup.Catalina start > INFO: Server startup in 58789 ms > * INFO 18:43:45,108 User login success: 'admin' > (DefaultUserAuditService.java [http-6080-2]) > * INFO 18:56:39,905 User login success: 'admin'

Re: [Dhis2-devs] Aggregating values

2010-07-14 Thread Jason Pickering
ing a very long INSERT > query. Last time I left it from 12 hours and nothing happened. > > Thanks > > Caveman > > > > On Wed, Jul 14, 2010 at 8:03 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> No need for medical help. I have had many of

Re: [Dhis2-devs] dhis14 import

2010-07-24 Thread Jason Pickering
Hi Bob, I think this is indeed interesting, but is it really worth spending any time on? We currently have something that works, and for our 10 million row database in Zambia it took a few hours to import. OK, fine, it took time, but it was a one off deal. Is there much to be gained from a full r

Re: [Dhis2-devs] Info on GIS development

2010-07-24 Thread Jason Pickering
Not sure really where this is headed, but I am not 100% sure I am comfortable with the direction of the conversation. Let me intervene. We need to think about a few things here. We are currently only supporting EPSG 4326. This is likely only because we have really not needed any other projection

Re: [Dhis2-devs] Info on GIS development

2010-07-25 Thread Jason Pickering
Hi Knut, > It may be that we want to use DHIS as both a repository with full > precision (though not ridiculously artifical ones like 15 decimal > lat/lon) and have a faster way of renderin. But for a repo, I think > something like PostGIS is in order. Or we could just store things as > GML... We

Re: [Dhis2-devs] Info on GIS development

2010-07-26 Thread Jason Pickering
sage- > From: dhis2-devs-bounces+lemarchandjo=who@lists.launchpad.net > [mailto:dhis2-devs-bounces+lemarchandjo=who@lists.launchpad.net] On > Behalf Of Knut Staring > Sent: 26 July 2010 10:17 > To: Bob Jolliffe > Cc: dhis2-devs@lists.launchpad.net > Subject: Re: [Dhis

Re: [Dhis2-devs] Info on GIS development

2010-07-26 Thread Jason Pickering
about topological > relationships or scale when the original layers are generalized with the > currently specified tolerance. > > Johan > > > -Original Message- > From: Jason Pickering [mailto:jason.p.picker...@gmail.com] > Sent: 26 July 2010 11:53 > To: Lema

Re: [Dhis2-devs] Update of gml2dxf.xsl

2010-08-24 Thread Jason Pickering
I am fine with this for presentation purposes, whatever works, speeds up the map, and does not unduly degrade any presentation. 10 m precision seems more than enough for most purposes as Knut mentions. The issue of a repository is something entirely different. I would suggest this be an entirely

Re: [Dhis2-devs] [Blueprint regex-validation] Validate data value fields with regular expressions

2010-08-24 Thread Jason Pickering
Dear Lars and Hieu, I have updated the blueprint https://blueprints.launchpad.net/dhis2/+spec/regex-validation Some things are clearer in my head than in the whiteboard, but perhaps this will serve as a better guide to the desired functionality. Let me know what you think. Best regards, Jason

Re: [Dhis2-devs] Uniqueness of Orgunit names - once again

2010-08-25 Thread Jason Pickering
Not sure why they should be unique. There are lots of places with the same name (McDonalds, BP, etc) within a given administrative district. They have other unique properties of course such as ownership, address, telephone number, lat/long, etc, but this seems to be another one of those strange res

Re: [Dhis2-devs] Uniqueness of Orgunit names - once again

2010-08-27 Thread Jason Pickering
Probably all good options, but likely we will need some flexibility to match on different properties, and even combinations of properties. For instance, there are two clinics in lusaka named "Pearl of Health". Both in the same parent organisationunit, but with different physical locations. So if yo

Re: [Dhis2-devs] Documentation source moving

2010-09-06 Thread Jason Pickering
Hi Knut, Thanks for your efforts on this. I am reluctant to move the source just yet. I think we need to think through the translation workflow a bit better, and not introduce too many changes at once. We have seen a few more commits from others, which is a good thing, but of course, getting involv

Re: [Dhis2-devs] Documentation source moving

2010-09-07 Thread Jason Pickering
omments below. > > On Tue, Sep 7, 2010 at 6:32 AM, Jason Pickering > wrote: >> Hi Knut, >> Thanks for your efforts on this. I am reluctant to move the source >> just yet. I think we need to think through the translation workflow a >> bit better, and not introduce t

Re: [Dhis2-devs] Translation workflow

2010-09-15 Thread Jason Pickering
Hi Romain, This is part of the reason that we created the workflow using Serna, brz and Launchpad. We have a set of distributed individuals that are making changes, potentially at the same time, to the same document. Version control systems are very good at handling and merging these types of cha

Re: [Dhis2-devs] [Bug 727779] Re: latest-2.1snapshot-fails-to-start

2011-03-02 Thread Jason Pickering
Well, in our case I had some potential security issues about this, especially as it relates to a custom audit procedure which was put in place in a separate schema, which DHIS2 has insert privileges for, but which it has no SELECT privileges for. I may have been overly paranoid about the segregatio

Re: [Dhis2-devs] DHIS version 2.1 released

2011-03-03 Thread Jason Pickering
Great work Lars and team. I have also just committed to trunk an updated DHIS 2 Live Postgresql installer. Bjørnar and I did some testing today, and it seems to work, under controlled circumstances. Some more testing from others would be useful. We will update the docs on how to build and customiz

Re: [Dhis2-devs] Proposal for new DXF format

2011-03-10 Thread Jason Pickering
Hi Murod, I think you raise some really good points, but being more towards the implementers side than the developers side, it would be very useful to see what you describe in action. Is the "local copy" which you refer to available on Launchpad so that maybe those of us that are interested could t

[Dhis2-devs] Amazon EC2 AMI

2011-03-12 Thread Jason Pickering
Hi Everyone, For those of you may be interested, I have setup and configured an Amazon EC2 instance of DHIS2 2.1 /Tomcat/Apache/Postgres. If you would like to utilize the instance for your own purposes, let me know, and I can give you more details of how you can get the image. Regards, Jason --

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-12 Thread Jason Pickering
ances? I have essentially no experience with this stuff ,so it would be good to get others feedback. Let me clean the AMI up a bit and i can provide details. Regards, Jason On Sat, Mar 12, 2011 at 6:00 PM, Jo Størset wrote: > > Den 12. mars 2011 kl. 12.09 skrev Jason Pickering: >

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-13 Thread Jason Pickering
Amazon WS customer ID, and I will make the AMI available to you. Regards, Jason On Sat, Mar 12, 2011 at 6:11 PM, Jason Pickering wrote: > I really have no idea about costs. I need to figure this out as part > of a budgeting exercise, and compare against Linode > > Linode are priced

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-13 Thread Jason Pickering
On Sun, Mar 13, 2011 at 2:18 PM, Jo Størset wrote: > Took it off-list, but maybe others are also interested? Oops. > Den 13. mars 2011 kl. 10.54 skrev Jason Pickering: > >> Looking more into costs, it seems to be quite significant. Costs are >> calculated based on insta

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-15 Thread Jason Pickering
heard rumors about Selenium or Jmeter, but not really sure if there is anything out there. Regards, Jason On Sun, Mar 13, 2011 at 2:43 PM, Jason Pickering wrote: > On Sun, Mar 13, 2011 at 2:18 PM, Jo Størset wrote: >> Took it off-list, but maybe others are also interested? > > >

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-15 Thread Jason Pickering
ar 15, 2011 at 10:14 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Another experiment I conducted over the weekend was a hybrid approach. > Linnode seems to be quite good at being persistent and is relatively > cheap. I think the draw back is of it is not at all as eas

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-15 Thread Jason Pickering
5, 2011 at 4:58 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> More cool stuff with Amazon Web Services. In my last experiment with AWS, >> I have utilized the "Elastic Beanstalk". A little bit strange to get your >> head around but he

Re: [Dhis2-devs] Once a categorycombo is created there is no way to add/remove a category/option into/from it.

2011-03-16 Thread Jason Pickering
I hate to flog a dead horse, but here I go again. What about at least being able eto add new category options to existing categories? I can sort of understand why it should not be possible to delete category options (since they may have data attached to them) but there would seem to be little harm

Re: [Dhis2-devs] Partial restore using PgAdmin?

2011-03-22 Thread Jason Pickering
Very likely could be foreign key references. I think MySQL may drop the foreign key references and then recreate them, but postgres does not. I am not sure this is exactly the same as a partial restore as they mention that they drop the db and then recreate it, which should not be possible with a

Re: [Dhis2-devs] GIS: Polygon layer under points

2011-03-23 Thread Jason Pickering
I suppose this is akin to "communities" as well, where community health workers may have a certain area which they work in, but then report data to a facility. I agree, it is a valid use case. Not to distract too much from this thread, but I think it point to the need for a blueprint on how

[Dhis2-devs] Proposal to move a few modules

2011-03-28 Thread Jason Pickering
Hi Devs, I would like to suggest that a few modules be moved around. 1) That the "Scheduling management" be moved to the Maintenance module. It seems more like an administrative function. 2) That the "Data browser" module be moved from the Maintenance module to the reporting module. It seems mor

[Dhis2-devs] Issues with deleted values and data mart exports

2011-04-01 Thread Jason Pickering
Hi Devs, I have a situation where data has been exported to the datamart, but has subsequently been "deleted" from the datavalue table. In fact, the data has not been deleted as you know, but has had its value attribute set to NULL. When I rerun the datmart (at the same level as the data entry)

Re: [Dhis2-devs] DHIS2 error

2011-04-05 Thread Jason Pickering
Hi Subodha, As was reported the other day on this mailing list, downgrades are not supported. Any time you upgrade you should always make a backup copy of your database. Your log looks a bit strange to me. Are you sure you deleted the /dhis directory and replaced it with the dhis.war file? As an

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3346: Make I18nFormat::formatPeriod() use getIsoDate() for weekly periods

2011-04-11 Thread Jason Pickering
Hi Bob, Thanks for this. I guess this is better than it was before, but I still think it is only a partial fix. The format patters... format.Weekly.startDate = 'Week' w' ' format.Weekly.endDate = in i18n_*.properties are going to be effectively ignored of course, which me

[Dhis2-devs] Jasper reports/Passing the JDBC connection

2011-04-15 Thread Jason Pickering
Hi there. I am in the midst of developing a series of reports with Jasper, and not surprisingly, I am using SQL for most of the development of the results sets which will feed the data to the report. One thing I am not certain on is how to pass the JDBC connection to the report. I assume this woul

Re: [Dhis2-devs] Jasper reports/Passing the JDBC connection

2011-04-15 Thread Jason Pickering
ort engine with the jdbc connection to > the current database. > > > Lars > > > > On Fri, Apr 15, 2011 at 4:13 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi there. I am in the midst of developing a series of reports with Jasper, >>

Re: [Dhis2-devs] Jasper reports/Passing the JDBC connection

2011-04-15 Thread Jason Pickering
eport. Regards, Jason > > 2011/4/15 Jason Pickering > >> Cool. Thanks makes this much easier. >> >> I tried that and got this from rev 2977 (2.1). Missing JAR perhaps? >> >> >> Regards, >> Jason >> >> >> * ERROR

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3466: Removed CalculatedDataElement

2011-04-25 Thread Jason Pickering
pe, null, null, de.aggregationtype, null, > de.url, de.lastupdated > from dataelement de, calculateddataelement cde, expression e > where (de.dataelementid = cde.calculateddataelementid) and > (cde.expressionid = e.expressionid > )); > > How to you think ? >

Re: [Dhis2-devs] [Dhis2-users] Database changes

2011-04-25 Thread Jason Pickering
Hi Randy, You can just go to the URL described in the message, put in the URL of your server (apparently hmis.moh.gov.rw) and Google will generate an API key for you. You can then paste this into the Administrator module of the GIS, and this message will disappear. This process should be described

Re: [Dhis2-devs] Alternative names

2011-04-27 Thread Jason Pickering
+1 from me as well, assuming that we can migrate the existing alternative names to whatever object replaces it. Also, if you can look into how we can match on these names during import, similar to DHIS 1.4, this would be very useful in hetereogeneous, data warehousing situations where multiple dat

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3466: Removed CalculatedDataElement

2011-04-28 Thread Jason Pickering
right here.. > > Lars > > > On Mon, Apr 25, 2011 at 9:19 AM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Hieu, >> >> Yes, this is along the same lines of what I was thinking, but was not as >> quick as you about coming up with t

Re: [Dhis2-devs] Postgres restore problem

2011-05-04 Thread Jason Pickering
What is the file format? Is it a plain text Postgres dump or has it been created using pg_dump as a compressed dump? You are right, as you will not be able to (easily) restore a version of the database created with Postgres 9 to postgres 8.4. You should be able to restore from a plain text dump ho

Re: [Dhis2-devs] Postgres restore problem

2011-05-04 Thread Jason Pickering
restore >> - should *not* be called .backup, but .pgdump or .pgplain etc >> >> >> > Thanks Jan Henrik. > > Ola > - > > > >> On Wed, May 4, 2011 at 14:33, Knut Staring wrote: >> >>> On Wed, May 4, 2011 at 2:21 PM, Ola Hodne T

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3603: Removed silly validation rule

2011-05-12 Thread Jason Pickering
I tend to agree with Saptarshi on this. What the devs may consider as silly, may be actually be useful and good practice. I think this again comes back to https://blueprints.launchpad.net/dhis2/+spec/regex-validation, which basically outlines a way to allow implementers to define what is "silly" an

Re: [Dhis2-devs] dxf2

2011-05-16 Thread Jason Pickering
Hi Ime, I think Bob is the one who can answer this authoritatively, but there are some schemas here in the documentation branch. \dhis2-docbook-docs\src\schemas Regards, Jason On Mon, May 16, 2011 at 10:45 PM, Ime Asangansi wrote: > Hi devs, > > I'm helping to migrate user-specified aggregate

Re: [Dhis2-devs] DHIS2 in the clouds

2011-05-23 Thread Jason Pickering
Looks great, and seems like the way to go. I guess the big difference of course is someone is paying for the platform. If we can figure this out, it should make things much easier for DHIS 2 to be deployed automatically. Of course, the deployment itself is really only a very small technical issue,

[Dhis2-devs] Sorting sections in dataset section forms?

2011-05-26 Thread Jason Pickering
This does not seem to be working on rev 3643. Perhaps I picked a bad revision. I select a dataset, and then "Sort section" but the sections do not appear. Perhaps a UI issue or something else? Regards, Jason ___ Mailing list: https://launchpad.net/~dh

Re: [Dhis2-devs] Sorting sections in dataset section forms?

2011-05-26 Thread Jason Pickering
Interesting that this seems to require a reboot to work properly? On Thu, May 26, 2011 at 4:14 PM, Jason Pickering wrote: > This does not seem to be working on rev 3643. Perhaps I picked a bad revision. > > I select a dataset, and then "Sort section" but the sections do not

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3800: Fix bug: Integers-values-do-not-allow-negative-numbers.

2011-05-30 Thread Jason Pickering
I guess this is one way of doing without a regex. I think this regex is a bit better than the one I provided earlier, but I see you have done it a different way anyway. ^(0|-?[1-9]\d*)$ On Tue, May 31, 2011 at 7:16 AM, wrote: > > r

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3841: Data mart: caching aggregated data values in a denormalized in-memory db table during dataelement...

2011-06-05 Thread Jason Pickering
Sounds good. Going forward it might make sense to offer this as part of the aggregation strategy, namely whether to use an in-memory DB (if you have plenty of memory) or disk (if you do not). On Sun, Jun 5, 2011 at 6:47 PM, wrote: > Merge authors: >  Lars Helge Øverland (larshelge) > ---

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3841: Data mart: caching aggregated data values in a denormalized in-memory db table during dataelement...

2011-06-05 Thread Jason Pickering
Or, cloud based systems, which tend to have plenty of disk, but little memory. 2011/6/6 Lars Helge Øverland : > > > On Mon, Jun 6, 2011 at 7:22 AM, Jason Pickering > wrote: >> >> Sounds good. Going forward it might make sense to offer this as part >> of the aggreg

[Dhis2-devs] S's seemed to be squashed

2011-06-06 Thread Jason Pickering
Yeah, a bit of a kooky title for an email, and a very small issue, but the latest trunk version seems all "s" seemed to be somewhat smaller. Is this just a browser thing with Chrome? Any body else seen this? See attached screen shot. Regards, Jason <>___

Re: [Dhis2-devs] S's seemed to be squashed

2011-06-06 Thread Jason Pickering
; On Mon, Jun 6, 2011 at 11:01 AM, Jason Pickering > wrote: >> >> Yeah, a bit of a kooky title for an email, and a very small issue, but >> the latest trunk version seems all "s" seemed to be somewhat smaller. >> Is this just a browser thing with Chrome?

Re: [Dhis2-devs] S's seemed to be squashed

2011-06-06 Thread Jason Pickering
.  Or see if you can figure out > what chrome is substituting. > > Now I've just read your mail.  Weird.  Doesn't make sense that the browser > would be messing with a font that is installed in the OS.  Can you use > firebug and play with the font setting?  Try Helvetica. >

Re: [Dhis2-devs] S's seemed to be squashed

2011-06-06 Thread Jason Pickering
nd not LiberationSansRegular / > LiberationSansBold? The font pack is created > by http://www.fontsquirrel.com/ . It shouldn't really matter whether you > have Liberation Sans installed or not. I have no idea why this happens on > Windows and not Ubuntu. > > On Mon, Jun 6, 2011 at 11

Re: [Dhis2-devs] adding categoryoption

2011-06-06 Thread Jason Pickering
Yeah, well, there is no easy way out here. One only need to review this http://www.mail-archive.com/dhis2-devs@lists.launchpad.net/msg02059.html I had a situation recently when implementing a logistics dataset, which would have worked great with categories. The problem was that categories are har

Re: [Dhis2-devs] Senegal DHIS2

2011-06-14 Thread Jason Pickering
ssible pointers for the moment. Copying to devs > list .. perhaps you or someone else might take it forward. > > On 14 June 2011 03:09, Jason Pickering > wrote: > > Hi Bob, > > Two files here. The facilities file, which contains coordinates and a > parent > &

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3903: Applied patch from Hieu. 1. Changes the data element value types to number, integer, positive int...

2011-06-15 Thread Jason Pickering
Dear Lars and Hieu, I would like to suggest a few more improvements to this commit. Please find attached a suggested patch. One thing I am a little unsure of is how to handle the situation when the number is a zero and should be stored. The problem is here.. return isNumber( value ) && parseFl

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 3903: Applied patch from Hieu. 1. Changes the data element value types to number, integer, positive int...

2011-06-15 Thread Jason Pickering
regex = /^(0(?:\.0*)?|[-]?[1-9]\d*\.?[0-9]*)$/; > > This is my modified : var regex = /^(0(?:\.0*)?|[-]?[1-9]\d*\.?[0-9].+)$/; > > One more thing, perhaps, you forget to place this isValidZeroNumber to some > where ;) please review then let me know. > > Thank you. > > > 2011/

Re: [Dhis2-devs] Troubles when generate a report in DHIS 2

2011-06-17 Thread Jason Pickering
Welcome to the DHIS hackers club. This bug has been discussed several times. Search the email archives (which is always a good thing to do) and you will see my name there on this topic... probably a few times. :) Thankfully, this object has been deleted in the latest version, which making hacking

Re: [Dhis2-devs] Negative Data Values

2011-06-20 Thread Jason Pickering
Hi Juma, We are planing to document this in detail soon, as we have made some changes here. Briefly however, if you want to restrict your data entry values to ONLY negative integers you should choose the "Negative integer". If your values can potentially include zero as well, you should as Hieu p

Re: [Dhis2-devs] Sql view does not excute my SQL

2011-06-27 Thread Jason Pickering
It is important to keep in mind conceptually why this SQL view functionality is there. DHIS2 destroys certain tables during some processes, such as the resource table generation process. If you have any tables which the a particular view depends on, the database will prevent DHIS2 from dropping the

Re: [Dhis2-devs] [Bug 745473] Re: validation-rules-NULL-operands

2011-07-04 Thread Jason Pickering
I sort of understand what is being discussed now, I think. Basically, we need a way whether to determine whether the validation rule is valid to validate at all. If the right hand or left hand side are not valid (i.e. a NULL operator) it may not make any sense to begin to validate the rule at all.

Re: [Dhis2-devs] Fwd: Greeting from the Gambia

2011-07-21 Thread Jason Pickering
Hi there. Could you also provide the build revision you are using (Available from the "Help->About" menu under Build revision). I know Lars has made some changes lately which may correct this issue, but it seems to be something to do with some metadata element being NULL when it should not be. Ha

Re: [Dhis2-devs] Fwd: Greeting from the Gambia

2011-07-21 Thread Jason Pickering
integrity check, can you show me > how to do that. > We have 6 regions in the Gambia and all the other regions will be imported > in the system expect two regions which doubt me. > > On Thu, Jul 21, 2011 at 10:08 AM, Jason Pickering > wrote: >> >> Hi there. >>

Re: [Dhis2-devs] Fwd: Greeting from the Gambia

2011-07-21 Thread Jason Pickering
stad (Mr) > HISP > Department of Informatics > University of Oslo > > Mobile: +47 48069736 > Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link > > > On 21 July 2011 15:54, Jason Pickering wrote: >> >> Hi Lamin, >> I suspect this is due to

Re: [Dhis2-devs] OrgUit groups and group sets

2011-08-10 Thread Jason Pickering
In fact, it is possible to assign an orgunit to two separate members of an orgunit group set. If you create a group set "Services" you can add the facility to multiple groups, but only through the Organisation unit group management function, and not through the UI for the organisation unit itself.

Re: [Dhis2-devs] Re-use of category options

2011-08-10 Thread Jason Pickering
ards, Jason On Wed, Aug 10, 2011 at 10:13 AM, Bob Jolliffe wrote: > Hi > > On 10 August 2011 08:40, Jason Pickering wrote: >> Dear DHIS2 devs, >> While considering the email sent to the users list this morning (which >> is a problem I have come up against seve

Re: [Dhis2-devs] Re-use of category options

2011-08-10 Thread Jason Pickering
Jason On Wed, Aug 10, 2011 at 12:07 PM, Bob Jolliffe wrote: > On 10 August 2011 10:28, Jason Pickering wrote: >> I think what you are implying here is that category options should >> actually be derived from concepts. >> >> We would start off be defining a concep

Re: [Dhis2-devs] OrgUit groups and group sets

2011-08-11 Thread Jason Pickering
Hi Ola, I have been mulling this issue for a few days, and would like to respond to a few things. > The approach suggested by Jason is a hack and a workaround, and is not > recommended practice (except maybe for a few experts like Jason who know > exactly what they are doing, and my experience i

Re: [Dhis2-devs] OrgUit groups and group sets

2011-08-12 Thread Jason Pickering
t; > -Original Message- > From: dhis2-devs-bounces+shin461=gmail@lists.launchpad.net > [mailto:dhis2-devs-bounces+shin461=gmail@lists.launchpad.net] On Behalf > Of Jason Pickering > Sent: Friday, August 12, 2011 10:00 AM > To: Ola Hodne Titlestad > Cc: dhis2-devs@

Re: [Dhis2-devs] OrgUit groups and group sets

2011-08-12 Thread Jason Pickering
Hi Bob, I agree with your next point, to some extent. > But we also want to be able to categorize orgunits in non-binary terms > - the ownership example being a good one.  We have successfully > mobilized the groupset idea to implement this - perhaps this could in > fact be implemented independent

Re: [Dhis2-devs] Offline DHIS2 Demo

2011-08-15 Thread Jason Pickering
Hi Chet, The sample database is available here http://dhis2.org/download/dhis2-demo-2.3.zip You will need to download the file, install Postgresql, restore the database file, and change your hibernate.setting file in order to utilize the sample database. Your hibernate properties file needs to

[Dhis2-devs] Conversion of calculated data elements to indicators

2011-08-18 Thread Jason Pickering
Dear Devs, In one of the deployments in Nigeria, we have some 800 calculated data elements. I plan to upgrade this instance soon to either 2.3 or 2.4 (depending on the release schedule). I understand from Lars that the deprecated CDEs are not automatically converted when upgrading. I think it shoul

Re: [Dhis2-devs] Multiple DHIS2 instances on Windows

2011-08-18 Thread Jason Pickering
In Nigeria, we have two completely separate instance of Tomcat with two environment variables DHIS2_HOME="/var/lib/tomcat6/conf/dhis2_conf" DHIS2_HOME_NG="/var/lib/tomcat6/conf/dhis2_conf_ng" The reason for the separate instances was really just to be able to allocate more CPU resources to a

Re: [Dhis2-devs] DHIS 2 Live

2011-08-18 Thread Jason Pickering
One strong reason not to use it is the relative lack of testing. In theory, it should work, but just as with MySQL, much more testing has occurred with Postgres than with the other database systems. We have some beta-level Windows installers, which might be of interest to you, which work pretty we

Re: [Dhis2-devs] DHIS 2 Live

2011-08-18 Thread Jason Pickering
) > HISP > Department of Informatics > University of Oslo > > Mobile: +47 48069736 > Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps > link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway> >

Re: [Dhis2-devs] DHIS 2 Live

2011-08-18 Thread Jason Pickering
As for those districts that *are* in fact offline, is the live package >> with H2 sufficient? Keeping postgres out of the picture would likely reduce >> the amount of support required quite a lot. >> >> Olav >> >> >> Den 18. aug. 2011 kl. 13:32 skrev Jason Pickering:

Re: [Dhis2-devs] DHIS 2 Live

2011-08-18 Thread Jason Pickering
te: > What would be the main benefits of this versus just using the H2 database > in DHIS live, except the documentation? > > Den 18. aug. 2011 kl. 14:12 skrev Jason Pickering: > > We have also created an H2 installer, which is considerably easier than the > Postgres installer.

Re: [Dhis2-devs] Conflicts merging databases

2011-08-19 Thread Jason Pickering
I suspect, but at not 100% sure this may because of the dodgy workaround some people (including yours truly) have used to get around the restriction of the same category option in different categories. "Male" and "Male " which appear in two different categories will be accepted by DHIS2, but duri

Re: [Dhis2-devs] Conflicts merging databases

2011-08-19 Thread Jason Pickering
Yes, this query will give you category options, which I think should not be possible, but does seem to happen. The specific issue I was referring to can be checked with this.. SELECT trim(name), count(*) from dataelementcategoryoption GROUP BY trim(name) HAVING COUNT(*) >1 Again, I have not chec

Re: [Dhis2-devs] Conflicts merging databases

2011-08-19 Thread Jason Pickering
Trimming is certainly the least that we should do. I have recently come up against a problem with some sort of tick marks (UNICODE 0x92) which look like apostrophes (which are bad enough) but are not. These seem to get inserted from copy/paste from Excel or Word who conveniently changes normal apos

[Dhis2-devs] User by organisation unit issue

2011-08-25 Thread Jason Pickering
Hi Devs, I am having a hard time understanding why I cannot unassign all organisational units for a given user through the Users->Users by organisation unit-> Edit button (Under a specific user). I want to unassign all organisational units for a given user, but leave the user active in the system.

Re: [Dhis2-devs] User by organisation unit issue

2011-08-27 Thread Jason Pickering
. I guess the "root orgunit" property should really be an attribute of the user and should be set to NOT NULL? What are the implications if a user is associated with multiple facilities (lowest orgunit level) which exist in multiple districts but has no true "root"? Thanks

Re: [Dhis2-devs] DHIS 2 version 2.4 BETA available

2011-08-29 Thread Jason Pickering
Hi Brajesh, I agree ( I think ) , but what exactly are you saying? Have you tested it in such environments? Do you have any concrete information to share with us, as I would be interested to know what the performance of 2.4 under such circumstances as you outline are. We are considering using 2.4

Re: [Dhis2-devs] [Dhis2-users] DHIS 2 version 2.4 released

2011-08-29 Thread Jason Pickering
Hi John, I am running 2.4 and have no issues with the custom data entry form modules, including editing of forms which were created in previous versions. What browser are you using? Be sure you are using the absolute latest version of Firefox or Chrome. If this does not work, please post some logs

Re: [Dhis2-devs] [Dhis2-users] DHIS 2 version 2.4 released

2011-08-29 Thread Jason Pickering
gt; Thank you for the quick response. > > I am currently using Google Chrome version 13.0.782.215 on a Windows Xp > platform. > I'm also using Firefox version 7.0. Please see attached screenshots. > > > Thank you. > John. > > > > > >

Re: [Dhis2-devs] DHIS 2 version 2.4 released

2011-08-30 Thread Jason Pickering
I did experience this during the initial upgrade, but seemed to be a browser issue. Be sure to clean your cache really well. Be sure to use the latest version of Chrome and FireFox. Knut has sent some detailed messages in this thread about how to do this. If not, you need to see what is going on w

Re: [Dhis2-devs] DHIS 2 version 2.4 released

2011-08-30 Thread Jason Pickering
ing using Knut's instructions, but no improvement. > Everything should be up to date. I've sent Morten the login details, so he is > going to take a look. > > Olav > > Den 30. aug. 2011 kl. 10:03 skrev Jason Pickering: > >> I did experience this during the initia

Re: [Dhis2-devs] unique codes

2011-09-06 Thread Jason Pickering
Not sure, but it may have something to do with 1.4 https://bugs.launchpad.net/dhis2/+bug/517047 which includes an exchange between ourselves. It does not seem to make a lot of sense, other than to facilitate imports from 1.4 where a (unique) code is not required. Regards, Jason On Tue, Sep 6,

Re: [Dhis2-devs] unique codes

2011-09-06 Thread Jason Pickering
: > On 6 September 2011 17:29, Knut Staring wrote: >> On Tue, Sep 6, 2011 at 6:26 PM, Bob Jolliffe wrote: >>> >>> On 6 September 2011 17:01, Jason Pickering >>> wrote: >>> > Not sure, but it may have something to do with 1.4 >>> > >>

Re: [Dhis2-devs] Dear Dhis2 users how can i delete?

2011-09-12 Thread Jason Pickering
It is best practice in all cases to ensure to you make a backup of your database. Even with SELECT and DELETE, you may unknowingly make a typing mistake. Anytime you start messing around with the database directly, ensure you first make a backup, so that you can easily restore the database in case

Re: [Dhis2-devs] help me on how to use replace syntax

2011-09-12 Thread Jason Pickering
ce next time i get error message for > the unreplaced id when i open the form. > waiting for your help dear team! > > > > > > -- > > > *Muhire Andrew > * > *HMIS/Ministry of Health* > *andrew.muh...@moh.gov.rw* > *God is my prov

Re: [Dhis2-devs] [Dhis2-users] How is it running in other countries?

2011-09-14 Thread Jason Pickering
Hi there. We have been using the GPRS client here in Zambia for about 6 months now. We currently have about 200+ mobiles (and growing) in the field reporting about 20 data elements (only) on a weekly basis. In general, we have had very few problems technical problems. We have worked very closely

Re: [Dhis2-devs] [Dhis2-users] How is it running in other countries?

2011-09-14 Thread Jason Pickering
n vietnam? > > Alvin > > > Sent from my BlackBerry® wireless handheld > > -Original Message- > From: Muhire Andrew > Sender: dhis2-users-bounces+alvin.marcelo=gmail@lists.launchpad.net > Date: Wed, 14 Sep 2011 11:09:51 > To: Jason Pickering

Re: [Dhis2-devs] Dynamic attributes

2011-09-16 Thread Jason Pickering
Could we also add "users" to the objects with dynamic attributes? We need some more fields for alternative telephone numbers, fax, etc etc. Thanks, Jason On Fri, Sep 16, 2011 at 12:23 PM, Morten Olav Hansen wrote: >> A decent recap, Bob and Morten? > > Yes, that seems to be a good recap. Its go

Re: [Dhis2-devs] Dynamic attributes

2011-09-16 Thread Jason Pickering
Fine with me if you want to integrate LDAP while you are at it. :) On Fri, Sep 16, 2011 at 1:40 PM, Bob Jolliffe wrote: > On 16 September 2011 11:54, Jason Pickering > wrote: >> Could we also add "users" to the objects with dynamic attributes? We >> need some

<    3   4   5   6   7   8   9   10   11   12   >