Re: [Dhis2-devs] Switching databases almost "runtime" using dhis2 live system tray UI

2010-03-05 Thread Jason Pickering
Sorry, but I suspect this is my fault for not changing the read me. Try mvn package and everything should be build. Regards, Jason On Fri, Mar 5, 2010 at 10:54 PM, Saptarshi Purkayastha wrote: > Hi Bob, > > On 4 March 2010 16:26, Bob Jolliffe wrote: > >> Does that help? I suspect your probl

Re: [Dhis2-devs] Switching databases almost "runtime" using dhis2 live system tray UI

2010-03-05 Thread Jason Pickering
Purkayastha wrote: > > On 5 March 2010 20:53, Jason Pickering wrote: > >> Sorry, but I suspect this is my fault for not changing the read me. >> >> Try mvn package >> >> and everything should be build. >> > > Even then it builds th

Re: [Dhis2-devs] [Branch ~dhis2-documenters/dhis2/dhis2-docbook-docs] Rev 125: vietnamese document - Reorgasized

2010-03-11 Thread Jason Pickering
A big congrats to the Vietnamese team for what looks like the first translation of the DHIS user manual! The documentation has exploded over the past few months, and this is a great development for the project. I would have figured that Norwegian would have been the first language to translate, but

Re: [Dhis2-devs] [Branch ~dhis2-documenters/dhis2/dhis2-docbook-docs] Rev 125: vietnamese document - Reorgasized

2010-03-11 Thread Jason Pickering
Sounds like a blueprint. :) 2010/3/11 Lars Helge Øverland : > > > On Thu, Mar 11, 2010 at 3:29 PM, Jason Pickering > wrote: >> >> A big congrats to the Vietnamese team for what looks like the first >> translation of the DHIS user manual! The documentation has explod

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 1661: Removed number constraint on phone number validation, eg + should be allowed

2010-03-17 Thread Jason Pickering
This again highlights the need for flexible field level validation. I hope there will be some time to discuss this important issue. Regards jason On 3/17/10, nore...@launchpad.net wrote: > > revno: 1661 > committer: Lars Helge Oeverland

Re: [Dhis2-devs] [Branch ~dhis2-documenters/dhis2/dhis2-docbook-docs] Rev 143: - Create new document for DHIS child tphcm Vietnam

2010-03-22 Thread Jason Pickering
Hi Dao, Great to see you starting to translate the documentation. This is really a great step forward. A few comments here regarding the document. I am not 100% sure of the content of course, as I do not read Vietnamese, but here are a few tips.. This looks like a section.. 1.1.0.1 I am not

Re: [Dhis2-devs] [Branch ~dhis2-documenters/dhis2/dhis2-docbook-docs] Rev 143: - Create new document for DHIS child tphcm Vietnam

2010-03-23 Thread Jason Pickering
n format > text. > > Please help me check out this trouble. > > Again thanks a lot ! > > 2010/3/23 Jason Pickering >> >> Hi Dao, >> Great to see you starting to translate the documentation. This is >> really a great step forward. >> >>

Re: [Dhis2-devs] [Branch ~dhis2-documenters/dhis2/dhis2-docbook-docs] Rev 143: - Create new document for DHIS child tphcm Vietnam

2010-03-23 Thread Jason Pickering
"escaped" characters in XML for proper rendering of Vietnamese characters, but I think Google will know more than me. Regards, Jason 2010/3/23 Đào Văn Sâm : > Dear Jason, > > I send an attached file > > 2010/3/23 Jason Pickering >> >> Hi Sam, >> >

[Dhis2-devs] Weird periods after a DHIS 1.4 file import

2010-03-23 Thread Jason Pickering
Just did another import from DHIS 1.4. I keep hoping this is the last one, but we are still making a lot of changes. Anyway, any idea what may be causing this? Look carefully at the periods and their types. There are multiple year periods, although this should definitely not be the case . It woul

Re: [Dhis2-devs] Hudson doc build

2010-03-24 Thread Jason Pickering
I strongly suspect this is an encoding issue as mentioned yesterday. Also, I do not really understand where the list of complete artifacts are. Basically, Doxbkx will only build what needs to be built. I think since the Vietnamese documents have been altered, then they will be rebuilt. Otherwise,

Re: [Dhis2-devs] Hudson doc build

2010-03-24 Thread Jason Pickering
on http://dhis2.org, i.e. a link to Hudson. >> The PDF that is there now is very outdated. >> Knut >> >> >> On Wed, Mar 24, 2010 at 9:04 AM, Jason Pickering >> wrote: >>> >>> I strongly suspect this is an encoding issue as mentioned yesterday.

Re: [Dhis2-devs] Hudson doc build

2010-03-24 Thread Jason Pickering
some time. Regards, Jason On Wed, Mar 24, 2010 at 10:21 AM, Jason Pickering wrote: > I am not sure what the issue here is. HTML builds fine for the English > version, but the PDF looks like something is happening. I will take a > look at it. > > > > On Wed, Mar 24, 2010 at

Re: [Dhis2-devs] Hudson doc build

2010-03-24 Thread Jason Pickering
OK. I think this should be fixed. Lets see what Hudson does. On Wed, Mar 24, 2010 at 10:40 AM, Jason Pickering wrote: > Yes, it would appear that the pom is a bit screwed up at the moment. I > do not have time to look at this at the moment, but I can confirm that > the English version

Re: [Dhis2-devs] Hudson doc build

2010-03-24 Thread Jason Pickering
Yeah, I just assumed no one would do it, so I took 10 minutes I did not have, and fixed it. Anyway, I guess it is working now? On Wed, Mar 24, 2010 at 1:07 PM, Jo Størset wrote: > > Den 24. mars 2010 kl. 10.48 skrev Jason Pickering: > >> OK. I think this should be fixed. Lets

Re: [Dhis2-devs] [Bug 546686] [NEW] Pie chart type is needed

2010-03-25 Thread Jason Pickering
Sounds more like a blueprint than a bug? On Thu, Mar 25, 2010 at 9:06 AM, Kim Anh Vo wrote: > Public bug reported: > > The current chart (under REPORTs) just includes: Line and Bar chart. > There is a need of pie chart for analysing the propotional indicators, for > example: malnutrition level 1

[Dhis2-devs] Multilingual documentation

2010-03-25 Thread Jason Pickering
Just sitting here talking to Knut, and it would seem that Google translation may be good enough for a first pass of the translation. Now, a few issues arise from this. Management of the pom to generate the documentation, may become a major problem. Currently, we need quite a bit of XML for each l

Re: [Dhis2-devs] [Bug 547086] [NEW] dhis14-import-datasets-20 characters

2010-03-25 Thread Jason Pickering
Yes, indeed, it was both the shortname and the code field. Thanks for looking at this, but hopefully, I will never have to do this painful process again! Regards, Jason On Thu, Mar 25, 2010 at 7:05 PM, Viet Nguyen wrote: > > > On Thu, Mar 25, 2010 at 11:01 PM, jason.p.pickering < > jason.p.pi

[Dhis2-devs] Fwd: About Regex-Validation blueprint

2010-03-26 Thread Jason Pickering
-- From: Jason Pickering Date: Fri, Mar 26, 2010 at 10:31 AM Subject: Re: About Regex-Validation blueprint To: Hieu Dang Duy Hi Hieu, Well, we can always start simple, and go from there, but it is important that we architect everything properly. So, I suggest that for everything out of the

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 1706: Made the get objective complete registrations sql query rely on operands rather than dataelements.

2010-03-27 Thread Jason Pickering
Lars Livingroom? :) It would be very useful to persist this in the form of a data element in the datavalue table. I created a data element, Data elements submitted (HIA2) where HIA2 was the dataset. I then inserted the number of data element submitted for this dataset directly into the datavalue

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 1706: Made the get objective complete registrations sql query rely on operands rather than dataelements.

2010-03-28 Thread Jason Pickering
2010/3/28 Jason Pickering > >> Lars Livingroom? :) >> >> Yeah my laptop crashed.. again.. > > > >> It would be very useful to persist this in the form of a data element in >> the datavalue table. >> >> I created a data element, Data elements

Re: [Dhis2-devs] About Regex-Validation blueprint

2010-03-28 Thread Jason Pickering
o make in generic to execute arbitrary SELECT statements. I will not address this in this thread, but perhaps a separate blueprint. Thoughts? Regards, Jason On Fri, Mar 26, 2010 at 3:24 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > I thought I should forward this conv

Re: [Dhis2-devs] About Regex-Validation blueprint

2010-03-28 Thread Jason Pickering
xpression and then a field/property to match it against. Hope this makes this more clear? Regards, Jason On Mon, Mar 29, 2010 at 6:37 AM, Hieu Dang Duy wrote: > > > On Mon, Mar 29, 2010 at 3:08 AM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> I have been

Re: [Dhis2-devs] About Regex-Validation blueprint

2010-03-29 Thread Jason Pickering
is the same of "Data integrity" in > DHIS2.0 ? > > On Mon, Mar 29, 2010 at 1:45 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> OK, let me try and explain. Remember, I think in terms of databases, you >> think in terms of Java, so I think w

Re: [Dhis2-devs] About Regex-Validation blueprint

2010-03-29 Thread Jason Pickering
oupSet.Name > > HAVING Count(OrgUnitGroupSet.OrgUnitGroupSetID) > 1 > ORDER BY OrgUnit.Name; > > * > On Mon, Mar 29, 2010 at 2:44 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi again, >> >> If you want, you can download a copy

[Dhis2-devs] New blueprint on passthrough SQL queries

2010-03-29 Thread Jason Pickering
After a lot of chewing on this subject, I have written another blueprint which think actually supercedes the previous blueprint on a related subject (https://blueprints.launchpad.net/dhis2/+spec/regex-validation). The blueprint is available here https://blueprints.launchpad.net/dhis2/+spec/passthr

[Dhis2-devs] Strange error during data mart

2010-03-30 Thread Jason Pickering
Any idea what may be causing this? * INFO 10:18:17,709 Trimmed crosstab table: 0:01:26.830 (DefaultDataMartEngine.java [Thread-423]) * ERROR 10:25:37,046 The process threw exception (ProcessExecutor.java [Thread-423]) java.lang.IllegalStateException: Stopwatch is not running. at org.apach

[Dhis2-devs] Content type not allowed during DHIS 1.4 file import

2010-03-30 Thread Jason Pickering
I got this message while trying to import a DHIS 1.4 file.. * WARN 13:37:02,027 Content type not allowed: application/octet-stream (ImportAction.java [http-8080-5]) I suspect this might be a Tomcat security issue, but at least we should document it. Suggestions? -- -- Jason P. Pickering e

Re: [Dhis2-devs] Content type not allowed during DHIS 1.4 file import

2010-03-30 Thread Jason Pickering
, Jo Størset wrote: > > Den 30. mars 2010 kl. 13.42 skrev Jason Pickering: > > > I got this message while trying to import a DHIS 1.4 file.. > > > > * WARN 13:37:02,027 Content type not allowed: application/octet-stream > (ImportAction.java [http-8080-5]) > > &

Re: [Dhis2-devs] Content type not allowed during DHIS 1.4 file import

2010-03-30 Thread Jason Pickering
tomorrow and see. This function has previously worked, so it looks like it may be just a browser issue. Strange.. On Tue, Mar 30, 2010 at 4:33 PM, Jo Størset wrote: > > Den 30. mars 2010 kl. 15.47 skrev Jason Pickering: > > > Hi Jo, > > Well, it it just a zip file. That is what d

Re: [Dhis2-devs] Custom data entry form for hospital patient registers

2010-03-30 Thread Jason Pickering
Just a note of caution here. It is not so straightforward as a simple count aggregation (although I have written a blueprint for a count aggregator in the normal datamart operation as well). In some cases, it may be a combination of a count and a sum. For instance, you may have multiple patient lev

Re: [Dhis2-devs] Content type not allowed during DHIS 1.4 file import

2010-03-30 Thread Jason Pickering
applet might be a way to accomplish 1 and 2. 3 seems pretty dubious. :) I mean, if the file is bogus, DHIS2 should simply just ignore it and trash the file right? On Tue, Mar 30, 2010 at 5:55 PM, Jo Størset wrote: > > Den 30. mars 2010 kl. 16.43 skrev Jason Pickering: > > > T

Re: [Dhis2-devs] Content type not allowed during DHIS 1.4 file import

2010-03-30 Thread Jason Pickering
Størset wrote: > > Den 30. mars 2010 kl. 21.22 skrev Jason Pickering: > > Yeah, I figured this out actually after I had done it. Oh well, it was > worth a try. > > This seems like a major limitation really, well, at least when it comes to > importing DHIS 1.4 XML zip fil

Re: [Dhis2-devs] Custom data entry form for hospital patient registers

2010-03-31 Thread Jason Pickering
. like i need to > > display some form fields/controls if i select yes or no. I know this > > involves real programming. > > > > May be this can be done using CustomScreenDesign with Javascript > > Methods > > 3.I need to aggregate the register into the summary form.

Re: [Dhis2-devs] Custom data entry form for hospital patient registers

2010-03-31 Thread Jason Pickering
i achieve a predefined type for data element? I need the > following Date, predefined as pointed out by kumar in addtion to the > Yes/No,Number and Text. > I appreciate your urgent response to this. > > Thanks > > > .damilola > GMD > > On Wed 31/03/10 12:52 PM , Jaso

Re: [Dhis2-devs] Content type not allowed during DHIS 1.4 file import

2010-04-06 Thread Jason Pickering
ld be missing something important >>> ... >>> >>> Regards >>> Bob >>> >>> 2010/4/3 Lars Helge Øverland : >>>> I have added application/octet-stream to the allowed content types as a >>>> work-around for now. >>>>

Re: [Dhis2-devs] World maps now feasible!

2010-04-08 Thread Jason Pickering
Maybe you can commit these to the /resources/geojson directory? They would be quite handy for others as well perhaps. Regards, Jason On Thu, Apr 8, 2010 at 2:26 PM, Knut Staring wrote: > Let me also attach geojson versions of overlay files that are needed for > official maps - namely disputed a

[Dhis2-devs] Where does the "Feedback" go?

2010-04-08 Thread Jason Pickering
Hi there, I am wondering where the "Feedback" feature of DHIS2 actually ends up? It would seem that an email or something happens, but I see nothing in the logs. Is it possible to customize this (I suppose in the code someplace?). Regards, Jason Jason P. Pickering email: jason.p.picker...@

Re: [Dhis2-devs] [Dhis2-users] Changing DBs

2010-04-10 Thread Jason Pickering
You should also check to be sure that TCP/IP connections are active. Depending on your flavor of postgres, TCP/IP may not be enabled by default. On Sat, Apr 10, 2010 at 5:34 PM, Knut Staring wrote: > You could also try changing the owner of the database (easy to do in PgAdmin > III) to the dhis u

Re: [Dhis2-devs] can't run with the latest DHIS2 source-code

2010-04-12 Thread Jason Pickering
In fact, the code builds, but will not run. I am testing a fix right now. Regards, Jason On Mon, Apr 12, 2010 at 10:08 AM, Knut Staring wrote: > It is a good rule to check that the code builds before committing. > > Knut > > On Mon, Apr 12, 2010 at 10:06 AM, Bob Jolliffe > wrote: > > Looks li

Re: [Dhis2-devs] Problem with DataMart

2010-04-12 Thread Jason Pickering
Strange error. Maybe you can include this in the questions/answers section of Launchpad. Regards, JP On Mon, Apr 12, 2010 at 12:03 PM, Knut Staring wrote: > Thanks to Ola for catching that the error was that my Source and > Organisationunit tables had become out of sync - I had an extra id in

Re: [Dhis2-devs] [Branch ~dhis2-documenters/dhis2/dhis2-docbook-docs] Rev 184: Put docbook dependency in impl guide back to 4.4, not sure who bumped it

2010-04-13 Thread Jason Pickering
This was me but it was a mistake. Serna uses 4.5 by default but the maven docbook plugin seems not to like this version. I thought this should have been solved with the new version of the plugin but it would seem there are still problems. Regards jason On 4/13/10, nore...@launchpad.net wrote: > -

Re: [Dhis2-devs] [Branch ~dhis2-documenters/dhis2/dhis2-docbook-docs] Rev 184: Put docbook dependency in impl guide back to 4.4, not sure who bumped it

2010-04-13 Thread Jason Pickering
Ah. Forgot that. I will experiment a bit and bump the version up if it works. This will make new document creation somewhat easier. Regards jason On 4/13/10, Lars Helge Øverland wrote: > No prob. We are still using docbook-xm 4.4 in the pom btw. > > On Tue, Apr 13, 2010 at 12:09

[Dhis2-devs] DB /Query optimization

2010-04-14 Thread Jason Pickering
Hi Lars, I am going to spend a bit of time on the optimization blueprint. I have setup my system to log the full queries created by hibernate, but already have some questions.. I selected a single data element (BCG coverage) and aggregated this through a data mart operation. The query looks some

[Dhis2-devs] Question on aggregation periods

2010-04-19 Thread Jason Pickering
Hi Lars, I have been looking at the aggregation process and have a few questions. I chose a range of months (January-December 2009) and aggregated all data from facilities to districts. Monitoring the logs, I saw that a greater number of periods were aggregated during the process for some reason,

Re: [Dhis2-devs] [Bug 567080] [NEW] dataset-section-no-sorting

2010-04-20 Thread Jason Pickering
This may actually be a problem due to the way that the data elements were sorted in DHIS 1.4. 1.4 allows you to specify both a sorting order in the dataelement table, as well as the equivalent of the datasetmembers table. A global (system) setting allows one to chose how they should be displayed in

Re: [Dhis2-devs] [Bug 567080] [NEW] dataset-section-no-sorting

2010-04-20 Thread Jason Pickering
Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: > titlest...@who.int|Tel: > +41 788216897 > Website: www.healthmetricsnetwork.org > > Better Information. Better Decisions. Better Health. > > > On 20 April 2010 10:31, Jason Pickering wrote: > >> This may actua

Re: [Dhis2-devs] [Bug 567080] [NEW] dataset-section-no-sorting

2010-04-20 Thread Jason Pickering
216897 > Website: www.healthmetricsnetwork.org > > Better Information. Better Decisions. Better Health. > > > On 20 April 2010 11:19, Jason Pickering wrote: >> >> Sounds good, but I need to fix this now. Will have a look myself and >> see what can be done in the inter

Re: [Dhis2-devs] Pagination patch

2010-04-20 Thread Jason Pickering
It would seem this was implemented for the patient system. Has there been any effort to move it to a more common place, so it can be used by other modules? I am asking for two reasons. 1) Currently, ALL data elements are loaded when editing data elements. In our case, this results in a lot data

Re: [Dhis2-devs] Pagination patch

2010-04-20 Thread Jason Pickering
Email: > titlest...@who.int|Tel: +41 788216897 > Website: www.healthmetricsnetwork.org > > Better Information. Better Decisions. Better Health. > > > 2010/4/20 Jason Pickering >> >>  It would seem this was implemented for the patient system. Has there >> been any effo

Re: [Dhis2-devs] Pagination patch

2010-04-20 Thread Jason Pickering
Hi Viet, This is good news. So, my suggestion would be as follows. 1) Use the user settings to determine what the initial sorting should be. Retrieve the first block of data based on whatever the user settings are when the user enters the page. At this point there would be no filter. 2) Should

Re: [Dhis2-devs] [Bug 567197] Re: Editing dataset sections does not persist

2010-04-21 Thread Jason Pickering
Thanks Bob. This seems to work for me. The ordering is still not there. There are quite a few differences between the AddSection.java (where sorting is implemented) and the EditSection.java (where it is not implemented). I suppose this is explains why it does not work. Anyway, this bugs is fixed

Re: [Dhis2-devs] Pagination patch

2010-04-21 Thread Jason Pickering
Hi Lars, I will write up the blueprint. It is becoming my specialty. :) Personally, I think the filter button is a good thing to test. The on-the-fly filtering is really causing me a lot of headaches. On Ubuntu, on a relatively slow machine, the browser greys out while performing a filter, sometim

Re: [Dhis2-devs] Edit Data Element Category

2010-04-21 Thread Jason Pickering
Hi Roger, I think this is by design, and not a bug per se. You can read a long discussion about this issue here https://bugs.launchpad.net/dhis2/+bug/463070 It is currently scheduled for 2.0.5. The non-assignment of the UUID could be a bug. I will take a look, otherwise, if you know it is a bug,

Re: [Dhis2-devs] Pagination patch

2010-04-21 Thread Jason Pickering
I have written up a blueprint here. It seems a bit wishy-washy when I read it now. Comments? https://blueprints.launchpad.net/dhis2/+spec/server-side-pagination ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad

Re: [Dhis2-devs] Pagination patch

2010-04-22 Thread Jason Pickering
s this way for approximately 2 minutes, and the comes back to life again. During this period, the CPU usage shoots up to 100%, and the whole OS (Ubuntu on a MacBook) becomes extremely sluggish. It is not pretty. 2010/4/22 Lars Helge Øverland : > > > On Thu, Apr 22, 2010 at 8:20 AM, Jason

Re: [Dhis2-devs] Pagination patch

2010-04-22 Thread Jason Pickering
place. It is clear though that FireFox 3.0.19 is a bit strange. The exact same version on Windows performs quite well. It could simply be the wimpy hardware I am using. 2010/4/22 Jason Pickering : > I actually made a video, of what happens, but lacking bandwidth on > this side of the

Re: [Dhis2-devs] [Bug 537672] Re: Filtering elements in list doesn't work in other browsers, only FF

2010-04-22 Thread Jason Pickering
Yeah, it behaves differently in different parts of the application, and in different browsers. Opera seems to be able to handle in a bit better, but still causes very high CPU loads on my old MacBook. Using the copy/paste trick really helps. It would seem that there needs to be a bit of delay when

Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Live?

2010-04-22 Thread Jason Pickering
I think it should probably be a blueprint and I think it is a good idea. It is certainly a problem on many machines I have encounterd in the field. We need to install FireFox, Chrome, Opera or something, and ideally make it the default browser. This seems to be a good idea to me, but can seem a

Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Live?

2010-04-23 Thread Jason Pickering
I think the advantages outweigh the disadvantages. It is certainly worth testing I think. Regards, Jason On Fri, Apr 23, 2010 at 9:46 AM, Ola Hodne Titlestad wrote: > On 22 April 2010 23:28, Bob Jolliffe wrote: >> >> On 22 April 2010 19:35, Jason Pickering >> wrote: &

Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Live?

2010-04-23 Thread Jason Pickering
s/Mozilla Firefox/" part could reference the enviornment variable that would be set during the install. Otherwise, a configuration file, which could also be written as part of the installer, might not be bad idea if we did not want to set any environment variable. On Fri, Apr 23, 2010 at 10

Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Live?

2010-04-23 Thread Jason Pickering
ill likely be the case for many production installations) but not always. Otherwise, just fall back and do what is already in the code. On Fri, Apr 23, 2010 at 10:18 AM, Bob Jolliffe wrote: > On 23 April 2010 09:04, Bob Jolliffe wrote: >> On 23 April 2010 08:54, Jason Pickering wr

Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Live?

2010-04-23 Thread Jason Pickering
> > Better Information. Better Decisions. Better Health. > > > On 23 April 2010 10:31, Jason Pickering wrote: >> >> My suggestion would be to keep it very simple. >> >> If the environment variable exists, and is of the form "C:\program >> files\d

Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Live?

2010-04-23 Thread Jason Pickering
2010 09:55, Ola Hodne Titlestad wrote: >> I was more thing of the unzip and run package. >> >> If there is a folder DHIS2Live/firefox-portable/ I thought we could simply >> run DHIS in this specific browser with a command on the form: >> "portable-firefox/firefox.e

Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Live?

2010-04-23 Thread Jason Pickering
; >> Sent from my BlackBerry® >> >> -Original Message- >> From: Jason Pickering >> Date: Fri, 23 Apr 2010 11:37:53 >> To: Bob Jolliffe >> Cc: DHIS 2 developers >> Subject: Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Li

Re: [Dhis2-devs] "Site Specific Browser" included with DHIS2 Live?

2010-04-23 Thread Jason Pickering
These are both quite interesting projects, and really point to a complete rewrite of the GUI, reductio absurdum, meaining a webapp that looks like a Desktop app. Something to keep in mind for future releases. I am pretty much convinced however that packaging a modern browser with the installer and

[Dhis2-devs] Errors with latest version

2010-05-03 Thread Jason Pickering
Hi there. I am having some issues with the latest version. Sorry for the lengthy mail, but I have copied and pasted a bunch of log files. I am using Postgres, Java 1.6.19, Tomcat 6.0.24 on Ubuntu. During startup on a clean DB, only these are the tables that are created. dhis2_tj=# \dt

Re: [Dhis2-devs] Errors with latest version

2010-05-03 Thread Jason Pickering
On Mon, May 3, 2010 at 11:44 AM, Jason Pickering wrote: > Hi there. I am having some issues with the latest version. Sorry for > the lengthy mail, but I have copied and pasted a bunch of log files. > > I am using Postgres, Java 1.6.19, Tomcat 6.0.24 on Ubuntu. > > During startup o

Re: [Dhis2-devs] Errors with latest version

2010-05-03 Thread Jason Pickering
Does this imply that I can remove it in a production instance when the version will not be changed? Regards, Jason 2010/5/3 Lars Helge Øverland : > > > On Mon, May 3, 2010 at 12:44 PM, Jason Pickering > wrote: >> >> Duh, sorry for this. My own mistake, but at le

[Dhis2-devs] Problems with chart creation on Ubutnu

2010-05-05 Thread Jason Pickering
I have not seen this error before, but when I try and create a chart I get this error http://pastebin.com/ZDKDqBWK. If I set the this environment variable export JAVA_OPTS="-Djava.awt.headless=true" I am able to generate charts. Not sure if this has been documented before or not (I probably have

Re: [Dhis2-devs] JQuery table sorter

2010-05-06 Thread Jason Pickering
Wow. datatables.net examples look very slick. Would really like to see this integrated into DHIS2! On Thu, May 6, 2010 at 2:48 PM, Bob Jolliffe wrote: > The jquery table sorter is quite cool but also a bit limited as it is > restricted to using html tables in the dom as its model and doesn't > na

[Dhis2-devs] Errors with latest trunk code with mvn jetty:run-war

2010-05-07 Thread Jason Pickering
I would like to get the mvn jetty:run-war working, but am greeted with this. Any tips? http://pastebin.com/TL7HXW6L Thanks and best regards, Jason --- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+260968395190 ___ Mailing list: https://

Re: [Dhis2-devs] Documentation on DHIS2 reporting and DHIS2 maintenance

2010-05-10 Thread Jason Pickering
I have agreed with Ola to take a look at the DHIS2 reporting manual document, and merge this with what is already in the user manual. If anyone else wants to have a go at the maintenance part, go for it. :) Regards, Jason On Mon, May 10, 2010 at 7:38 PM, Ola Hodne Titlestad wrote: > Hi all, >

Re: [Dhis2-devs] [Bug 579873] [NEW] relative period in dataset frequency

2010-05-13 Thread Jason Pickering
This could be a terminology problem. DHIS 1.4 refers to this as type of data set as "on change", meaning the dataset is essentially static, until a change is made. I believe this is the intended type of this dataset, but I agree with you, the terminology is a bit confusing when compared to the "Rel

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 1887: Added latitude, longitude, polygoncoordinates to dxf

2010-05-19 Thread Jason Pickering
I think this is a good step in the right direction,but should be considered still, an interim solution. There are limitations (for instance the specification of the coordinate system) which points to a need to a more generic object model. There are some better alternatives (GML for instance) in my

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 1887: Added latitude, longitude, polygoncoordinates to dxf

2010-05-19 Thread Jason Pickering
Without going into the inner guts of GML, which can be terribly complex, let me first elaborate a bit on the use case. In an certain country I have recently been in, a seperate GIS system will be setup for supporting the master MoH plan. They will need to calculate for instance, accessibility of he

Re: [Dhis2-devs] Can we bump organisationunitid from int to bigint?

2010-05-21 Thread Jason Pickering
I do not really have a problem with this, but shouldn't this information go in the "code" field? Or is it a problem with the number of orgunits? It would seem unlikely that we would ever have more than 2,147,483,647 orgunits. Are you inserting the ID as the organisationunitid? This seems this migh

Re: [Dhis2-devs] Can we bump organisationunitid from int to bigint?

2010-05-21 Thread Jason Pickering
e might want to > have a separate table in DHIS2 with the full precision technologies > and a link to the orgunit table. > > Knut > > On Fri, May 21, 2010 at 10:28 AM, Jason Pickering > wrote: >> I do not really have a problem with this, but shouldn't this >> inf

Re: [Dhis2-devs] Can we bump organisationunitid from int to bigint?

2010-05-21 Thread Jason Pickering
de this in the import module > and take care of this hierarchy generation in the java code rather than > manually manipulating the database. > > Ola > ---- > > On 21 May 2010 11:17, Jason Pickering wrote: > >> OK, you are all over the place on this one. Lets take it o

Re: [Dhis2-devs] Can we bump organisationunitid from int to bigint?

2010-05-21 Thread Jason Pickering
structured excel format we recommend for bulk orgunit import. >> >> Ola Hodne Titlestad |Technical Officer| >> Health Metrics Network (HMN) | World Health Organization >> Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: >> titlest...@who.int|Tel: +41 788216897 >>

Re: [Dhis2-devs] Can we bump organisationunitid from int to bigint?

2010-05-21 Thread Jason Pickering
ate orgunit hierarchies off >>>> these, >>>> either directly or we find a way to convert the shapefile info to the >>>> format >>>> of the structured excel format we recommend for bulk orgunit import. >>>> >>>> Ola Hodne Titlestad |T

Re: [Dhis2-devs] Douglas-Peuker and Simplification Program

2010-05-21 Thread Jason Pickering
I think the biggest problem is that the underlying shape files themselves have topological issues. This is a big problem specifically with the WHO dataset, which has been composed of individual submissions of country level data, and then sort of seamed together. The GAUL dataset from FAO is suppose

Re: [Dhis2-devs] mongodb instead of RDMBS

2010-05-21 Thread Jason Pickering
While on the subject of different db paradigms, I have been playing around with LucidDB, a column based DB, which theoretically should be more efficient for data warehousing operations than a transactional DB like Postgres or MySQL. I have not managed to get it to work yet (there is a Postgresql co

[Dhis2-devs] DHIS2 with R

2010-05-27 Thread Jason Pickering
Hi everyone. I have had a recent question from a user about how DHIS2 can be used with R. I am including a trivial example here about how to use R as as a client to access data and produce a graph in DHIS2. Just get a copy of R and install the DBI and RPostregSQL packages with >install.packages(

Re: [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Jason Pickering
out R to know.  But I sense it ... > > Regards > Bob > > On 27 May 2010 10:08, Jason Pickering wrote: >> Hi everyone. I have had a recent question from a user about how DHIS2 >> can be used with R. I am including a trivial example here about how to >> use R as as a

Re: [Dhis2-devs] DHIS2 with R

2010-05-27 Thread Jason Pickering
ul "canned" dhis R scripts which >>> could take some number crunching load off the jvm and produce canned >>> useful analysis then that would be different. >>> >>> Sadly I don't know sufficient about R to know.  But I sense it ... >>> >>

Re: [Dhis2-devs] [Dhis2-users] DHIS2 with R

2010-05-27 Thread Jason Pickering
the DB. I am not really sure this > is possible with MySQL. This of course reduces the internal overhead > of getting the data out of Postgres, through Java, and into the R > interpreter, but I am not sure really what the impact of this might be > without testing it. > > > > On Th

[Dhis2-devs] Export specifications

2010-05-27 Thread Jason Pickering
Hi there. Perhaps I am missing something very obvious. I wanted to export two data elements, only, from DHIS2, but could not really figure out how to do this. I can export an entire dataset, but this is not really what I need to do. Am I missing something, very obvious or is this functionality just

Re: [Dhis2-devs] Export specifications

2010-05-28 Thread Jason Pickering
this is needed,and wouldn't that just complicate the import >> the other side? I mean it is not given that they would like to import all >> those categories etc. >> >> Ola >> --- >> >> On 28 May 2010 07:58, Jason Pickering wrote: >>>

Re: [Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 1946: Modified DXF, coordinates are now nested within feature, and feature type is an attribute of feat...

2010-06-02 Thread Jason Pickering
Although it (maybe) is a bit overkill to implement GML for our purposes, it would probably be a good idea to at least look at some examples and follow what we can.. http://openlayers.org/dev/examples/gml/ for example It might be a good idea to declare the coordinate system someplace as well (EPS

Re: [Dhis2-devs] [Dhis2-users] Can't roll up

2010-06-03 Thread Jason Pickering
Hi Roger, Ola will probably be able help a bit more with this, but just a few things to check. Have all the resource tables been built? Maintenance->Resource tables Regards, Jason On Thu, Jun 3, 2010 at 10:28 PM, Friedman, Roger (CDC/OID/NCHHSTP) (CTR) wrote: > No matter what I do, I can't

[Dhis2-devs] Unpivot with Postgres

2010-06-03 Thread Jason Pickering
Hi. Just wanted to share a bit of code with everyone, especially report developers. It is quite common to need to "unpivot" data. For instance, you may have a report table presented in one way, but you might need to feed it to a report or Excel pivot table in normalized format. Access/Microsoft SQL

Re: [Dhis2-devs] sectioning a paper form/dataset

2010-06-10 Thread Jason Pickering
I was just about to suggest the "graying" out of certain cells. We have some data elements in Zambia that generally correspond to a catcombo, but for some reasons, are not actually recorded. For instance the data element "Hypertension" is only recorded for the age group "Over 5" although all the ot

Re: [Dhis2-devs] Human Resource System in DHIS2

2010-06-18 Thread Jason Pickering
Have you considered this project instead? http://www.capacityproject.org/hris/suite/ I know there was some talk about integration with DHIS2, but not sure how far it got. Maybe Knut or Ola have more details? Regards, Jason On Fri, Jun 18, 2010 at 8:40 AM, Yusuph Kassim wrote: > Hello Everyone

Re: [Dhis2-devs] Troubles with database communication

2010-06-22 Thread Jason Pickering
Can you send your hibernate.properties file (otherwise privately)? Is you MySQL TCP/IP sockets available on 127.0.0.1 (not Unix pipes)? Regards, Jason On Wed, Jun 23, 2010 at 5:32 AM, Orvalho Augusto wrote: > >From time to time my DHIS stalls and report me this: > =

Re: [Dhis2-devs] [Bug 589776] Re: Data element period not enforced with data set

2010-06-26 Thread Jason Pickering
Hi Lars, This bug has been troubling me since I saw the report but it has taken a few walks in the woods to figure out why. I am not comfortable with it being implemented and let me try and outline my argument. We are planning in Zambia to pilot the DHIS mobile app in certain districts. Community

Re: [Dhis2-devs] [Bug 589776] Re: Data element period not enforced with data set

2010-06-27 Thread Jason Pickering
; > On Sun, Jun 27, 2010 at 7:15 AM, Jason Pickering > wrote: >> >> Hi Lars, >> This bug has been troubling me since I saw the report but it has taken >> a few walks in the woods to figure out why. I am not comfortable with >> it being implemented and let me

Re: [Dhis2-devs] [Bug 589776] Re: Data element period not enforced with data set

2010-06-28 Thread Jason Pickering
model side. Regards, Jason On Mon, Jun 28, 2010 at 12:23 PM, Bob Jolliffe wrote: > 2010/6/27 Jason Pickering : >> Understood, but then this would require a complete overhaul of the >> data model. If you look at the data value table, there are separate >> keys for datae

Re: [Dhis2-devs] APN for Mobile DHIS

2010-06-29 Thread Jason Pickering
This really has nothing to do with DHIS2 itself, but the underlying way in which clients to connect to each other. We have tested the use of OpenVPN in Zambia, and it works fine for remote database connections where a secure line is required. However, there are drawbacks (namely maintenance, setup

Re: [Dhis2-devs] DHIS2 Live USB edition

2010-06-29 Thread Jason Pickering
clude the demo database - and that's fine. We have >> discussed before the desire to augment DHIS Live with functionality to >> easily swap databases - though the manual operation is of course also >> very simple, if we document it well. >> >> 5) The final README

Re: [Dhis2-devs] Aggregating values

2010-07-11 Thread Jason Pickering
A very common mistake is not having generated the resource tables, namely "orgunitstructure". Consult the documentation for more details on how to generate these tables. Regards, Jason On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto wrote: > I have a dataelement collected at a Health Centre le

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