Re: [Dhis2-devs] FiscalYear Period type?

2011-10-14 Thread Jason Pickering
Hi Dave, There are currently three fiscal period types (April, July and October). If you have patch or bug, please submit a bug report on launchpad and attach the patch with the bug report. The current release is 2.5, released today available from http://dhis2.org/downloads and may be work

Re: [Dhis2-devs] FiscalYear Period type?

2011-10-14 Thread Jason Pickering
Hi Dave, Its a bug for sure. I was able to reproduce it in data entry. You can track it here (or submit a patch) :) https://bugs.launchpad.net/dhis2/+bug/874772 On Fri, Oct 14, 2011 at 10:18 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Dave, There are currently three fiscal

Re: [Dhis2-devs] Still having troubles after upgrade

2011-10-11 Thread Jason Pickering
Be sure tomcat is dead as well before you clean out the webapps directory. On Oct 11, 2011 11:53 AM, Morten Olav Hansen morte...@gmail.com wrote: Could it be that your DHIS 2.4 download was interrupted during download, and was corrupted? I would try and clean out webapps, and delete your war,

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4866: Impl methods for getting latitude and longitude from coordinate string

2011-10-07 Thread Jason Pickering
the comma is allowed. Signs are optional. Decimals are optional, but require at least a single digit if the decimal exists. Hope this helps. Regards, Jason 2011/10/6 Jason Pickering jason.p.picker...@gmail.com: Hi Lars, Small suggested change. Not really sure if the square brackets

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4866: Impl methods for getting latitude and longitude from coordinate string

2011-10-07 Thread Jason Pickering
...@gmail.com wrote: 2011/10/7 Jason Pickering jason.p.picker...@gmail.com: Hi Lars, Again, another suggestion for the coordinate format, which is slightly more restrictive (perhaps overly so). ^\[[+-]?([0-9]|[1-9][0-9]|1[0-7][0-9])(\.\d{1,})?,(\s)?[+-]?([0-9]|[1-8][0-9])(\.\d{1,})?\]$ I guess

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4866: Impl methods for getting latitude and longitude from coordinate string

2011-10-06 Thread Jason Pickering
Hi Lars, Small suggested change. Not really sure if the square brackets [] should be part of the validation or not. You may need to double the slashes as well. \[[+-]?\d{1,3}(\.\d*)?,[+-]?\d{1,3}(\.\d*)?\] Decimal points should be optional. Only single +- signs should be allowed. Not sure

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4838: Put code uniqueness check back in import module

2011-10-05 Thread Jason Pickering
Is there going to be a way for the system to autogenerate a code if 1) there is a collision during import 2) if the user does not enter one (I suppose it will be enforced through the UI), but does not know what the code should be? On Wed, Oct 5, 2011 at 1:51 PM, nore...@launchpad.net wrote:

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4838: Put code uniqueness check back in import module

2011-10-05 Thread Jason Pickering
correctly, this could have been one of the reasons (at my insistence) that we relaxed the uniqueness constraint some time back, as it made imports from 1.4 databases impossible where there were uniqueness violations. Regards, Jason 2011/10/5 Bob Jolliffe bobjolli...@gmail.com: 2011/10/5 Jason

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4838: Put code uniqueness check back in import module

2011-10-05 Thread Jason Pickering
On Oct 5, 2011 4:33 PM, Bob Jolliffe bobjolli...@gmail.com wrote: 2011/10/5 Jason Pickering jason.p.picker...@gmail.com: Sounds good. I remember at some point in time, the code was required from the UI (but not the DB). As long as NULL values are acceptable, but a constraint is placed

Re: [Dhis2-devs] attributes

2011-09-29 Thread Jason Pickering
I think I agree with most of what you are saying Bob, but it will take some time for me to grok it. ;) The issue of attributes for users is I think not compelling.  There isn't really an immediate strong demand, other than a half hearted wish from Jason.  Of course I think we all agree having

Re: [Dhis2-devs] java on ubuntu

2011-09-25 Thread Jason Pickering
It seems to work okay for me but causes problems with jasper reports due to missing fonts. I couldn't be bothered to resolve it and followed 2 instead. By far the easiest route i have found. On Sep 25, 2011 8:06 AM, Bob Jolliffe bobjolli...@gmail.com wrote: Quick question. There seems to be at

Re: [Dhis2-devs] Fwd: [OPENMRS-DEV] Current state of attributes

2011-09-25 Thread Jason Pickering
I like it. A lot. I come back to this, which I have been ranting about for some time https://blueprints.launchpad.net/dhis2/+spec/regex-validation Seeing that they are more or less following this route to some degree (it would at least seem from the discussion) with regex validation of

Re: [Dhis2-devs] survey of existing concepts

2011-09-22 Thread Jason Pickering
Abyot, I personally find this a bit of an academic discussion. From an implementation standpoint having concepts like Gender pre-defined seems to make a lot of sense to me. This is sort of like saying, we should not have pre-defined periods (which we do), and it would be up to the user to define

Re: [Dhis2-devs] H2 database on AWS

2011-09-21 Thread Jason Pickering
in some way. Let us know if it works. Lars On Tue, Sep 20, 2011 at 8:57 PM, Jason Pickering jason.p.picker...@gmail.com wrote: This seems to be it. Not sure where this came from. Let me try again and get back to you. Thanks Morten. Regards, Jason On Tue, Sep 20, 2011 at 8:46 PM

Re: [Dhis2-devs] H2 database on AWS

2011-09-21 Thread Jason Pickering
Thanks for all the help. In this case, it was a combination of using the old H2 dialect string and not having the username and password to the H2 database. I managed to get a lot of help from Knut, who provided me with some DXF which worked fine. So, I have the Ethiopia database from Knut running

[Dhis2-devs] H2 database on AWS

2011-09-20 Thread Jason Pickering
Hi there. I got a database from Knut, and am trying to get it started on Amazon Web services. Am running the latest 2.4 war. Cannot get the thing to start. Stack trace here.. http://pastebin.com/PAt2UAe7 Any ideas? Bob's souffle is ready, so I need someone else to help me. Regards, Jason

Re: [Dhis2-devs] H2 database on AWS

2011-09-20 Thread Jason Pickering
be org.hibernate.dialect.H2Dialect? (in your hibernate properties) -- Morten On Tue, Sep 20, 2011 at 8:40 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi there. I got a database from Knut, and am trying to get it started on Amazon Web services. Am running the latest 2.4 war. Cannot get

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4611: added proper validation for real/natural numbers (including support for e-notation)

2011-09-19 Thread Jason Pickering
Hi Morten, We currently have four number types. Number. This is any real number, with an option single sign (-), a single decimal point and no thousand separators. Scientific notation is not allowed (but could be if there is a real need for it). Integer: Any whole number, including zero.

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4611: added proper validation for real/natural numbers (including support for e-notation)

2011-09-19 Thread Jason Pickering
We don't really support real numbers.. we support integers, and decimal approximations of rational numbers.. I think the name decimal would be better here. Good point and I support the change in naming. We should have seen this earlier. However, we do also support decimal representation of

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4611: added proper validation for real/natural numbers (including support for e-notation)

2011-09-19 Thread Jason Pickering
This is not a problem, we store them as strings. There are 64 bit value types that can be used, and there are also libraries that would support any number of bits. Yes, this is my point. I am sure (without knowing the details) that there are restrictions on what would be a valid exponent and

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 4611: added proper validation for real/natural numbers (including support for e-notation)

2011-09-19 Thread Jason Pickering
We have sort of wondered away from the original discussion, but of course, you raise a good point Bob. We sometimes get somewhat unexpected results, with particularly low values..i.e. 0.04 which in DHIS is the same as 0.0. So, we maybe can use a factor to present the number as 0.04*1000 but it

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 morte...@gmail.com wrote: A decent recap, Bob and Morten? Yes, that seems to be a good

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 bobjolli...@gmail.com wrote: On 16 September 2011 11:54, Jason Pickering jason.p.picker...@gmail.com wrote: Could we also add users to the objects with dynamic attributes? We

Re: [Dhis2-devs] Dynamic attributes

2011-09-16 Thread Jason Pickering
bobjolli...@gmail.com wrote: On 16 September 2011 13:07, Jason Pickering jason.p.picker...@gmail.com wrote: Fine with me if you want to integrate LDAP while you are at it. :) Yes I see there's even a blueprint for this (I wonder who from?).  I actually did this once - ie setup dhis so you

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
Hi Alvin, I am not 100% sure, but believe so. I think they are also using the patient level tracking module there in Viet Nam. Anyone from the Vietnamese team want to comment? Regards, Jason On Thu, Sep 15, 2011 at 12:40 AM, alvin.marc...@gmail.com wrote: Jason, Is this also the mobile

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 replaceid syntax

2011-09-12 Thread Jason Pickering
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 provider.* -- *From:* Jason Pickering

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

Re: [Dhis2-devs] unique codes

2011-09-06 Thread Jason Pickering
...@gmail.com wrote: On 6 September 2011 17:29, Knut Staring knu...@gmail.com wrote: On Tue, Sep 6, 2011 at 6:26 PM, Bob Jolliffe bobjolli...@gmail.com wrote: On 6 September 2011 17:01, Jason Pickering jason.p.picker...@gmail.com wrote: Not sure, but it may have something to do with 1.4

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

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

2011-08-30 Thread Jason Pickering
clearing everything 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 initial upgrade, but seemed

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

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

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

2011-08-29 Thread Jason Pickering
Jason, 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. From: Jason Pickering jason.p.picker

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

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

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

[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

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

Re: [Dhis2-devs] DHIS 2 Live

2011-08-18 Thread Jason Pickering
: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway On 18 August 2011 15:02, Jason Pickering jason.p.picker...@gmail.comwrote: One strong reason not to use it is the relative lack of testing. In theory

Re: [Dhis2-devs] DHIS 2 Live

2011-08-18 Thread Jason Pickering
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: I agree with both Bob and Ola. We have tried not quite yet succeeded in getting DHIS2 installed with Tomcat/Postgres

Re: [Dhis2-devs] DHIS 2 Live

2011-08-18 Thread Jason Pickering
: 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. This would allow you to install

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

2011-08-12 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 is

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

2011-08-12 Thread Jason Pickering
[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@lists.launchpad.net Subject: Re: [Dhis2-devs] OrgUit groups and group sets Hi Ola, I have been mulling this issue for a few

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
...@gmail.com wrote: Hi On 10 August 2011 08:40, Jason Pickering jason.p.picker...@gmail.com wrote: Dear DHIS2 devs, While considering the email sent to the users list this morning (which is a problem I have come up against several time) I wanted to experiment with the possible re-use of category

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

2011-08-10 Thread Jason Pickering
On Wed, Aug 10, 2011 at 12:07 PM, Bob Jolliffe bobjolli...@gmail.com wrote: On 10 August 2011 10:28, Jason Pickering jason.p.picker...@gmail.com 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 concept

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. Have

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

2011-07-21 Thread Jason Pickering
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 jason.p.picker...@gmail.com wrote: Hi there. Could you also provide the build revision you are using

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

2011-07-21 Thread Jason Pickering
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 jason.p.picker...@gmail.com wrote: Hi Lamin, I suspect this is due to an orgunit which is assigned to a dataset, but which

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

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

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

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
= /^(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/6/15 Jason Pickering jason.p.picker

Re: [Dhis2-devs] Senegal DHIS2

2011-06-14 Thread Jason Pickering
possible 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 jason.p.picker...@gmail.com wrote: Hi Bob, Two files here. The facilities file, which contains coordinates and a parent name, and the Admin2

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

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, nore...@launchpad.net wrote: Merge authors:  Lars Helge Øverland

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

2011-05-31 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, nore...@launchpad.net wrote:

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

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 asanga...@yahoo.com wrote: Hi devs, I'm helping to migrate

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 and

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

Re: [Dhis2-devs] Postgres restore problem

2011-05-04 Thread Jason Pickering
. Ola - On Wed, May 4, 2011 at 14:33, Knut Staring knu...@gmail.com wrote: On Wed, May 4, 2011 at 2:21 PM, Ola Hodne Titlestad ol...@ifi.uio.nowrote: On 4 May 2011 14:12, Knut Staring knu...@gmail.com wrote: On Wed, May 4, 2011 at 2:01 PM, Jason Pickering jason.p.picker...@gmail.com

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

2011-04-28 Thread Jason Pickering
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 the SQL. :) I will try this query out (modified to fit Postgres) and see how it works

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

[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

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

2011-04-15 Thread Jason Pickering
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, and not surprisingly, I am using SQL for most of the development

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

2011-04-15 Thread Jason Pickering
. Regards, Jason 2011/4/15 Jason Pickering jason.p.picker...@gmail.com Cool. Thanks makes this much easier. I tried that and got this from rev 2977 (2.1). Missing JAR perhaps? Regards, Jason * ERROR 14:23:47,140 Error while executing action (ExceptionInterceptor.java [ajp-8009-2

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

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

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

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

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

2011-03-23 Thread Jason Pickering
On Topic 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. /On Topic Off Topic Not to distract too much from this thread, but I think it point to the

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

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] 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 jason.p.picker...@gmail.com wrote: On Sun, Mar 13, 2011 at 2:18 PM, Jo Størset stor...@gmail.com wrote: Took it off-list, but maybe others

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-15 Thread Jason Pickering
, 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 easily scalable as Amazon. I tried a setup

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-15 Thread Jason Pickering
, Mar 15, 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 here it is.. - http://aws.amazon.ancom

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 jason.p.picker...@gmail.com 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

Re: [Dhis2-devs] Amazon EC2 AMI

2011-03-13 Thread Jason Pickering
On Sun, Mar 13, 2011 at 2:18 PM, Jo Størset stor...@gmail.com 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 instance-hour

[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
? 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 stor...@gmail.com wrote: Den 12. mars 2011 kl. 12.09 skrev Jason Pickering: Hi

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

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

[Dhis2-devs] Trouble upgrading to 2.1

2011-03-02 Thread Jason Pickering
Using the latest snapshot from Jenkins, I get this upgrading from 2.0.6 to 2.1 * INFO 13:33:49,514 System property dhis2.home not set (DefaultLocationManager.java [Thread-2]) * INFO 13:33:49,520 Environment variable DHIS2_HOME points to /etc/dhis2/ghain/ (DefaultLocationManager.java [Thread-2])

Re: [Dhis2-devs] Trouble upgrading to 2.1

2011-03-02 Thread Jason Pickering
) dataelement already has a uuid column. Regards, Jason On Wed, Mar 2, 2011 at 2:54 PM, Jo Størset stor...@gmail.com wrote: Hi, Den 2. mars 2011 kl. 18.08 skrev Jason Pickering: Using the latest snapshot from Jenkins, I get this upgrading from 2.0.6 to 2.1 * ERROR 13:35:46,079 ERROR

Re: [Dhis2-devs] Trouble upgrading to 2.1

2011-03-02 Thread Jason Pickering
More ominously categorycombos_optioncombos was nuked. I had to restore from backup. Regards, Jason On Wed, Mar 2, 2011 at 3:03 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Thanks for this Jo, but I think this is not the issue. A bit more detail. 1)  Here is my

Re: [Dhis2-devs] Trouble upgrading to 2.1

2011-03-02 Thread Jason Pickering
) ) WITH ( OIDS=FALSE ); Does not seem to have a uuid property. Is this the right table? On Wed, Mar 2, 2011 at 3:30 PM, Jo Størset stor...@gmail.com wrote: Den 2. mars 2011 kl. 19.33 skrev Jason Pickering: Thanks for this Jo, but I think this is not the issue. A bit more detail. snip

Re: [Dhis2-devs] Trouble upgrading to 2.1

2011-03-02 Thread Jason Pickering
:45 PM, Jason Pickering jason.p.picker...@gmail.com wrote: OK. Not really sure what to do at this point then. I have tried the procedure several times. My categoryoptioncombo table is defined as follows CREATE TABLE categoryoptioncombo (  categoryoptioncomboid integer NOT NULL,  CONSTRAINT

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

Re: [Dhis2-devs] Remote ODBC access to Postgres

2011-02-26 Thread Jason Pickering
Google will be your friend. Be sure that the line listen_address is set your IP number and that TCP/IP connections are enabled (which they must be for DHIS2 to work) Be sure that the pg_hba.conf has the correct permissions to allow the clients network source addresses to connect with the

[Dhis2-devs] Audit log error with Tomcat

2011-02-24 Thread Jason Pickering
Can someone please explain how I can prevent this error from happening? Straight up setup of DHIS2 on Ubuntu. INFO: Deploying web application archive dhis.war log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: audit.log (Permission denied) at

Re: [Dhis2-devs] Audit log error with Tomcat

2011-02-24 Thread Jason Pickering
at 5:09 AM, Jo Størset stor...@gmail.com wrote: Den 24. feb. 2011 kl. 22.50 skrev Jason Pickering: Can someone please explain how I can prevent this error from happening? I think your best bet is to - copy the log4j,properties to somewhere - edit the audit.log path to point to where you

Re: [Dhis2-devs] FiscalYear Period type?

2011-02-23 Thread Jason Pickering
samuelchebu...@gmail.com wrote: Thanks Kenya financial year FY 2010/11 - runs from July 1st 2010 through June 30th 2011. Y 2011/12 -runs from July 1st 2011 through June 30th 2012. Y 2012/13 - runs from July 1st 2012 through June 30th 2013. Regards On Wed, Feb 23, 2011 at 9:11 M, Jason Pickering

Re: [Dhis2-devs] FiscalYear Period type?

2011-02-23 Thread Jason Pickering
Agreed, it is messy but these seem to be the pressing ones. I have a blueprint and a patch for both. I have sent the patch for October, but given Samuels concerns, I made one for July based fiscal years as well. I will send it to you, in yet another email. 2011/2/23 Lars Helge Øverland

<    5   6   7   8   9   10   11   12   13   14   >