IRC Chat : 2011-03-27 - OpenMRS

01:19:52 <bwolfe> emeka: you can make it work a little easier if you change the tomcat settings
01:19:57 <bwolfe> and/or the mysql settings
01:20:21 <bwolfe> that "server" should be fine for up to at least 10000 patients and 20 simultaneous users
01:21:05 <emeka> okay cool, i'm actually finding it's running much faster with a less priveleged provider user
01:21:28 <emeka> and it the time it really slowed down was during the installation of xforms, but now it's back up
01:23:05 *** Mkop has joined #openmrs
01:23:05 *** ChanServ sets mode: +v Mkop
01:23:50 <emeka> alright i'm gonna head out, but thanks for all the help guys, i'll be back soon
01:29:21 *** emeka has quit IRC
02:09:05 *** gauravpaliwal has joined #openmrs
02:18:10 <gauravpaliwal> Hi , if I need to access the newly created relation in the openmrs database by my module , then do i have to any way to acces the database without modifying the core openmrs API
02:18:11 <gauravpaliwal> ??
02:28:57 <bwolfe> yes, create a service and dao and read it via your module
02:29:27 <gauravpaliwal> @bwolfe : thanks for the pointer
02:41:25 <efes> guys, I have DB table with parametrers, ID, name, lastname, age, percentage, height
02:41:42 <efes> What's proper SQL query to select the tallest and the oldest guy?
02:43:31 <bwolfe> efes: is this a homework assignment?
02:43:38 <efes> not at all
02:43:55 <efes> I did my SQL course long time ago
02:44:04 <efes> maybe too long
02:44:10 <bwolfe> whats this for then? :-)
02:44:39 <efes> I don't want use 'limit'
02:45:10 <bwolfe> ha, no limit?
02:45:11 <efes> SELECT * from TABLE where AGE=(SELECT MAX(AGE) FROM TABLE) AND HEIGHT=(SELECT MAX(HEIGHT) FROM TABLE);
02:45:30 <efes> I'm lookin' for something prettier ;]
02:45:41 <bwolfe> what will only give you a row if the person is BOTH the oldest and the tallest
02:45:51 <efes> yesss
02:45:52 <bwolfe> you will get no hits if the oldest person is not the tallest person
02:46:00 <efes> yesss
02:46:06 <efes> that's what i'm asking about
02:46:24 <bwolfe> so you want two rows back?
02:46:30 <efes> No.
02:47:00 <efes> I want get name of the tallest from the oldest.
02:47:28 <efes> bwolfe: I cannot figure out how to "pass a table as an argument" to another table.
02:47:29 <bwolfe> ok
02:47:42 <bwolfe> ha, no idea what you mean. and sql doesn't have parameters
02:47:54 <bwolfe> as far as sql for the other question:
02:48:08 <efes> e.g. "Select max(height) from table " generates one table. If I could assign it to ... variable V, then I could do
02:48:22 <efes> select name, max (age) from V;
02:48:44 <bwolfe> um, you're not making sense
02:48:49 <bwolfe> do you have multiple heights?
02:48:51 <bwolfe> or multiple tables?
02:49:14 <bwolfe> random question: anyone here a tmobile customer? I need some unlock codes for phones I just got...
02:49:17 <efes> In fact an example I asked you about is much simplified. My "real" example is a little bigger :D
02:49:29 <bwolfe> efes: I can tell
02:50:00 <efes> One client has One height and One age.
02:50:12 <efes> I want select the tallest from the oldest
02:50:29 <efes> Isn't it just about doing double sorting + "limit 1" ?
02:51:08 <efes> select name from table order by height desc, age desc limit 1; ?
02:51:42 <bwolfe> please explain "I want select the tallest from the oldest"
02:52:35 <bwolfe> that sql you posted will get the tallest person, and if there are two tallest people, then the older one is returned
02:53:05 <efes> and that's what I was searching for :)
02:53:07 <efes> Thanks :)
02:53:28 <bwolfe> ok
02:53:29 <bwolfe> great!
02:53:31 <efes> Sometimes just talking helps. Even, if such talking is not about tech stuff.
02:59:55 <bwolfe> hmm
03:00:01 <bwolfe> so no T-Mobile people in here?
03:00:33 <gauravpaliwal> @bwolfe : need ur reviews on this patch that I submitted : https://tickets.openmrs.org/browse/TRUNK-1838
03:03:09 <efes> bwolfe: Sorry.... :| I thought it's # #programming :/
03:12:17 *** megaman has joined #openmrs
03:13:40 <megaman> Hello
03:13:58 *** gauravpaliwal has left #openmrs
03:18:25 <bwolfe> hi megaman
03:20:17 <megaman> bwolfe: Hi! I have a question
03:21:08 <megaman> Do I need the Oblivion to open an omod file???
03:21:28 <bwolfe> I don't know what the oblivion is
03:21:38 <bwolfe> see the creating modules page for what an omod is
03:21:44 <bwolfe> *the creating modules wiki page
03:21:54 <bwolfe> its just a jar file with a diff extension to make it unique
03:21:58 <bwolfe> and a jar is just a zip file
03:22:20 <megaman> I read that an omod file is a jar, is that right??
03:23:26 <bwolfe> yes, see what I said two lines up. :-p
03:25:01 <megaman> So... Can I change the extention of the omod??
03:34:27 *** Mkop has quit IRC
03:41:12 *** harsha has joined #openmrs
03:41:44 <harsha> hi Ben
03:41:52 <harsha> you around ?
03:43:47 <bwolfe> megaman: you can change it if you want. why do you need to? I can't remember if openmrs expect the extension to be omod or not
03:43:51 <bwolfe> harsha: for a few more minutes
03:44:17 *** gbastien has joined #openmrs
03:44:22 <harsha> bwolfe: great,
03:45:50 <harsha> bwolfe: regarding the Universal Search Box project, would it better to start this as a separate module or along with a existing module
03:46:20 <bwolfe> separate
03:46:31 *** efes has quit IRC
03:47:20 <megaman> bwolfe: I need to do a module, but I can't, I installed everything and I don't get it
03:47:23 <harsha> would not it better do this along with the logic module as ultimately this should retain along with all the modules
03:47:49 <bwolfe> megaman: did you see the "creating my first module" ?
03:48:02 <bwolfe> harsha: no, its a separate thing
03:48:13 <harsha> bwolfe: okay
03:49:01 <megaman> bwolfe: Yes, I'm reading it right now
03:51:23 <megaman> bwolfe: I have Eclipse Helios and I got this message http://pastebin.com/z4QJGHe2
03:57:11 <bwolfe> megaman: make sure your eclipse instance is loaded with the jdk, not the jre
03:57:32 <bwolfe> there are a few QAs on how to fix this (but not on the openmrs wiki that I know of)
03:57:56 <bwolfe> ...and with that I'm off to bed. sorry I can't see you through it.
04:02:14 <megaman> bwolfe: Thanks, I'm searching the solution
04:02:39 <harsha> bwolfe: have a nice sleep, bye
04:02:39 *** bwolfe has quit IRC
04:05:18 *** nad88 has joined #openmrs
04:14:03 *** megaman has quit IRC
04:16:07 *** gbastien has quit IRC
04:30:34 *** mjohnst has quit IRC
04:41:20 * nad88 test
04:51:29 *** nad88 has quit IRC
04:52:58 *** nad88 has joined #openmrs
04:54:17 *** aja has joined #openmrs
04:55:24 *** aja has quit IRC
05:14:04 *** Chaitalishah has joined #openmrs
05:15:31 *** Chaitalishah has quit IRC
05:17:08 *** suho has joined #openmrs
05:30:38 *** deadpool has quit IRC
05:32:56 *** Chaitalishah has joined #openmrs
05:38:22 *** arthur_sribeiro has joined #openmrs
05:39:03 *** arthur_sribeiro has quit IRC
05:40:37 *** arthursribeiro has quit IRC
06:24:33 *** harsha has left #openmrs
06:28:17 *** dhanushka has joined #openmrs
06:28:39 *** dhanushka has left #openmrs
06:51:38 *** nad88 has left #openmrs
07:20:05 *** ashishmittal has joined #openmrs
08:02:22 *** bryq has joined #openmrs
08:03:25 *** Chaitalishah has quit IRC
08:07:17 *** ashishmittal has quit IRC
08:22:16 *** ashishmittal has joined #openmrs
09:09:33 *** Chaitalishah has joined #openmrs
09:37:41 *** suhothayan has joined #openmrs
09:41:00 *** suho has quit IRC
09:44:49 *** suhothayan has quit IRC
09:54:42 *** rafa has joined #openmrs
09:54:42 *** ChanServ sets mode: +v rafa
10:15:43 *** pascal` has joined #openmrs
10:17:05 <bryq> Hi rafa, I've decited to create a wiki page instead of sending you an email with questions. It will be better for both of us and for the other people interested in Metadata Sharing. If you have some spare time look at it: https://wiki.openmrs.org/display/~bryq/GSoC+2011+-+Metadata+Sharing+project+draft
10:17:09 <OpenMRSBot> <http://ln-s.net/8f1z> (at wiki.openmrs.org)
10:25:20 *** suho has joined #openmrs
10:27:16 <rafa> Hi bryq, I'll try to find time to review your patch/page and give you feedback by tomorrow. We'll be in touch.
10:27:45 <bryq> rafa: Ok
10:28:03 <rafa> bryq: I need to go know. Have a nice day! ttyl
10:28:16 <bryq> rafa: See you!
10:29:46 *** rafa has quit IRC
10:31:43 *** Chaitalishah has quit IRC
10:35:20 *** Chaitalishah has joined #openmrs
10:38:25 *** suho has quit IRC
11:09:25 *** aja has joined #openmrs
11:24:47 *** ashishmittal has quit IRC
11:58:25 *** ashishmittal has joined #openmrs
13:06:11 *** pascal` has quit IRC
13:18:19 *** pascal` has joined #openmrs
13:32:33 *** bryq has quit IRC
13:43:24 *** aja has quit IRC
13:45:09 *** gbastien has joined #openmrs
13:46:17 *** bwolfe has joined #openmrs
13:46:17 *** ChanServ sets mode: +o bwolfe
13:46:17 *** OpenMRSBot sets mode: +o bwolfe
13:49:29 *** Mkop has joined #openmrs
13:49:29 *** ChanServ sets mode: +v Mkop
13:50:49 *** bwolfe has quit IRC
14:04:21 *** bwolfe has joined #openmrs
14:04:21 *** ChanServ sets mode: +o bwolfe
14:05:36 *** nad88 has joined #openmrs
14:27:22 *** bwolfe has quit IRC
14:45:03 *** ashishmittal has quit IRC
14:55:10 *** bwolfe has joined #openmrs
14:55:10 *** ChanServ sets mode: +o bwolfe
14:55:10 *** OpenMRSBot sets mode: +o bwolfe
15:02:54 *** suho has joined #openmrs
15:03:12 <suho> hi bwolfe
15:25:08 *** nribeka has quit IRC
15:29:16 *** rafa has joined #openmrs
15:29:16 *** ChanServ sets mode: +v rafa
15:51:28 *** rafa has quit IRC
15:56:49 *** mjohnst has joined #openmrs
16:06:57 *** dkayiwa has joined #openmrs
16:17:10 *** arthursribeiro has joined #openmrs
16:30:20 *** Chaitali_ has joined #openmrs
16:34:20 *** Chaitalishah has quit IRC
16:42:10 *** nad88 is now known as nad
16:43:41 *** nad has quit IRC
16:47:53 *** pulasthi has joined #openmrs
16:57:36 <suho> hi bwolfe
16:58:12 <arthursribeiro> hey everybody, I'm trying to run openmrs via Maven but I'm getting the following error: http://pastebin.com/2Keaqfbb - Can anyone help me?
17:05:38 *** ashishmittal has joined #openmrs
17:06:31 *** nadh has joined #openmrs
17:07:49 *** nadh has left #openmrs
17:09:25 *** nadh has joined #openmrs
17:12:32 <suho> hi arthursribeiro
17:12:51 <arthursribeiro> hi suho
17:13:21 <suho> delete the .jar form C:\Documents and Settings\Administrador\.m2\repository\javax\mail\mail\1.4.1\mail-1.4.1.jar
17:13:30 <suho> and try again
17:14:29 <arthursribeiro> suho, ok, I'm going to do this.
17:28:09 <suho> arthursribeiro, how did it go ?
17:28:30 <arthursribeiro> it's downloading so many files right now...
17:28:41 <arthursribeiro> aparently the error is not going to appear...
17:28:58 <suho> great :)
17:30:20 *** aja has joined #openmrs
17:31:17 *** suho has quit IRC
17:38:47 *** rafa has joined #openmrs
17:38:48 *** ChanServ sets mode: +v rafa
17:42:05 *** suho has joined #openmrs
17:56:02 *** nadh has quit IRC
17:56:57 *** emeka has joined #openmrs
18:07:47 *** emeka_ has joined #openmrs
18:11:05 *** emeka has quit IRC
18:11:05 *** emeka_ is now known as emeka
18:13:19 *** Chaitali_ has quit IRC
18:13:45 *** Chaitalishah has joined #openmrs
18:15:03 *** pascal` has quit IRC
18:31:03 *** ashishm has joined #openmrs
18:31:28 *** ashishm has quit IRC
18:34:06 *** ashishmittal has quit IRC
18:43:32 *** deadpool has joined #openmrs
18:52:36 *** aja has quit IRC
18:53:10 *** pulasthi1 has joined #openmrs
18:54:45 *** rafa has quit IRC
18:55:09 *** pulasthi has quit IRC
19:01:06 *** ashishmittal has joined #openmrs
19:14:32 *** Chaitali_ has joined #openmrs
19:15:44 *** Chaitalishah has quit IRC
19:22:23 *** dkayiwa has quit IRC
19:29:14 *** dkayiwa has joined #openmrs
19:45:38 *** emeka has left #openmrs
19:46:06 *** emeka has joined #openmrs
20:00:21 *** pulasthi1 has quit IRC
20:04:59 *** downeym has joined #openmrs
20:04:59 *** ChanServ sets mode: +o downeym
20:05:13 *** downeym has quit IRC
20:09:29 *** emeka has quit IRC
20:13:22 *** efes has joined #openmrs
20:27:02 *** Chaitali_ has quit IRC
20:29:09 <mjohnst> i checked out the OpenMRS trunk using Maven, but I didn't get a simple openmrs project like the tutorial said. I did get a openmrs-tools which it didn't mention though. do i need openmrs to work on the project?
20:41:03 *** Echidna has quit IRC
20:45:07 *** Echidna has joined #openmrs
20:45:07 *** ChanServ sets mode: +v Echidna
20:54:47 *** cta has joined #openmrs
20:56:42 <cta> /msg bwolfe Hello, mr. Ben Wolfe. I still have a question))
20:57:35 <efes> Hi folks :)
20:57:54 <efes> Do you share OpenMRS's code in WAR files?
21:00:15 *** ashishmittal has quit IRC
21:09:01 *** bwolfe has quit IRC
21:10:53 *** cta has quit IRC
21:17:20 *** dkayiwa has quit IRC
21:20:27 <arthursribeiro> suho, thank you so much... sucess in everything...
21:30:10 *** robbyoconnor has quit IRC
21:30:30 *** robbyoconnor has joined #openmrs
21:30:30 *** ChanServ sets mode: +v robbyoconnor
21:40:00 *** bwolfe has joined #openmrs
21:40:00 *** ChanServ sets mode: +o bwolfe
21:54:36 *** robbyoconnor has quit IRC
22:01:43 *** suho has quit IRC
22:05:25 *** robbyoconnor has joined #openmrs
22:05:25 *** ChanServ sets mode: +v robbyoconnor
22:32:28 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Modules: Growth Chart 1.6 uploaded to OpenMRS Module Repository <https://dev.openmrs.org/modules/view.jsp?module=growthchart&version=&1.6>
22:48:00 *** Mkop has quit IRC
23:10:54 *** emeka has joined #openmrs
23:21:36 *** emeka has quit IRC
23:38:53 <efes> What IDE you mostly use with openmrs?
23:50:37 <mjohnst> eclipse