IRC Chat : 2012-12-08 - OpenMRS

00:14:58 *** wyclif_ has joined #openmrs
00:22:26 *** andreapat has quit IRC
01:46:18 *** jkeiper has quit IRC
02:17:08 *** jkeiper has joined #openmrs
02:17:08 *** ChanServ sets mode: +v jkeiper
06:44:31 *** djazayeri has quit IRC
07:12:46 *** kishoreyekkanti has joined #openmrs
07:28:53 *** kishoreyekkanti has quit IRC
11:28:08 *** rafa has joined #openmrs
11:28:08 *** ChanServ sets mode: +v rafa
12:36:32 *** rafa has quit IRC
12:37:00 *** rafa has joined #openmrs
12:37:00 *** ChanServ sets mode: +v rafa
12:50:00 *** robbyoconnor has quit IRC
13:19:38 *** rafa has quit IRC
15:01:24 *** sgithens has joined #openmrs
17:01:11 *** dkayiwa has joined #openmrs
17:04:35 *** rafa has joined #openmrs
17:04:35 *** ChanServ sets mode: +v rafa
17:18:37 *** rafa has quit IRC
17:20:12 *** rafa has joined #openmrs
17:20:12 *** ChanServ sets mode: +v rafa
17:35:27 *** k-joseph has joined #openmrs
17:35:50 <k-joseph> dkayiwa: good evening
17:35:59 <dkayiwa> hi k-joseph
17:37:18 <k-joseph> dkayiwa: please am requesting you to help me and take me through the dropping and setting up of an openmrs database
17:39:46 *** dkayiwa_ has joined #openmrs
17:40:03 <dkayiwa_> k-joseph: first step is to do an mvn clean install
17:40:08 <dkayiwa_> k-joseph: can you do that?
17:40:48 <dkayiwa_> k-joseph: are you there?
17:41:07 <k-joseph> dkayiwa: is it to be done in the previous directory where i have openmrs- core
17:41:31 *** dkayiwa has quit IRC
17:41:32 *** dkayiwa_ is now known as dkayiwa
17:41:36 <dkayiwa> k-joseph: can you look at the getting started page again to get an answer for that?
17:41:52 <k-joseph> dkayiwa: ok
17:49:52 *** rafa has quit IRC
17:52:21 *** k-joseph has quit IRC
17:53:29 *** k-joseph has joined #openmrs
18:01:08 *** djazayeri has joined #openmrs
18:01:08 *** ChanServ sets mode: +o djazayeri
18:09:24 <k-joseph> dkayiwa: i have done mvn clean install
18:09:42 <dkayiwa> k-joseph: was it successful?
18:09:54 <k-joseph> dkayiwa: yes
18:10:05 <dkayiwa> k-joseph: can you now run the app?
18:10:42 <k-joseph> dkayiwa: should now cd into webapp and run mvn jetty:run
18:11:00 <dkayiwa> k-joseph: can you get the answer from the wiki page?
18:12:02 <k-joseph> dkayiwa: it should be my next step but am not sure how i can increasing memory for Maven
18:13:08 <dkayiwa> k-joseph: https://wiki.openmrs.org/display/docs/Using+the+M2Eclipse+Maven+Plugin+in+Eclipse
18:14:44 <dkayiwa> k-joseph: under section: How to Run Web Application
18:40:04 *** k-joseph has quit IRC
18:45:11 *** k-joseph has joined #openmrs
19:10:29 *** k-joseph has quit IRC
19:22:59 *** k-joseph has joined #openmrs
19:23:50 *** tobin_g has joined #openmrs
19:30:21 <k-joseph> dkayiwa: i have gone through the steps of installing opennmrs through a browser, and this is the error at: http://pastebin.com/7CANteRH
19:31:36 <dkayiwa> k-joseph: can i look at the entire tomcat log?
19:32:17 <k-joseph> dkayiwa: do you mean the files in the logs folder?
19:33:22 <dkayiwa> k-joseph: do you know where you installed tomcat?
19:33:32 <dkayiwa> k-joseph: as in the folder where you installed tomcat
19:33:48 <k-joseph> dkayiwa: yes
19:34:02 <dkayiwa> k-joseph: in there you will see a logs folder
19:34:27 <k-joseph> dkayiwa: i have the folder open already
19:36:10 <dkayiwa> k-joseph: send the log file
19:42:34 <k-joseph> dkayiwa: localhost_access_log.2012-12-08 is empty
19:42:55 <dkayiwa> k-joseph: is it the only file there
19:43:25 <k-joseph> dkayiwa: no, let me then send others
19:47:52 <k-joseph> dkayiwa: the logs file: http://pastebin.com/nzc5R6hS
19:49:57 <dkayiwa> k-joseph: and the other
19:50:32 <k-joseph> dkayiwa: all other files are empty
19:50:54 <dkayiwa> k-joseph: at what step had your reached in the browser?
19:52:28 <k-joseph> dkayiwa: i falled up the procedures using advanced as the other time
19:53:00 <dkayiwa> k-joseph: can you stop and then i direct you
19:53:22 <k-joseph> dkayiwa: okay please, am ready
19:53:24 <dkayiwa> k-joseph: tell me when you have the browser setup is ready
19:53:43 <k-joseph> dkayiwa: i have it ready again now
19:53:58 <dkayiwa> k-joseph: what is it showing
19:54:31 <k-joseph> dkayiwa: Which type of installation do you want? and three options given
19:54:45 <dkayiwa> k-joseph: advanced
19:54:52 *** k-joseph has quit IRC
19:55:45 *** k-joseph has joined #openmrs
19:57:00 <k-joseph> dkayiwa: Do you currently have an OpenMRS database installed that you would like to connect to?
19:57:35 <dkayiwa> k-joseph: can you pause there and check your mysql installation
19:58:04 <dkayiwa> k-joseph: check if you have an openmrs database
20:02:39 <k-joseph> dkayiwa: is'nt that supposed to be via checking in navicat for openmrs!!! am not yet having a regestered version for navicat, otherwise if other way please lecture me through that one
20:03:52 <dkayiwa> k-joseph: can you download this? http://www.sqlmanager.net/products/mysql/manager/
20:03:56 <OpenMRSBot> <http://ln-s.net/+FR6> (at www.sqlmanager.net)
20:04:26 <dkayiwa> k-joseph: but do not
20:04:37 <dkayiwa> k-joseph: it will take your modem credit
20:04:49 <dkayiwa> k-joseph: can you run the mysql commandlone prompt
20:05:06 <dkayiwa> k-joseph: then i will tell you what commands to execute
20:06:19 <k-joseph> dkayiwa: i have opened it
20:06:31 <dkayiwa> k-joseph: have you logged in?
20:06:43 <k-joseph> dkayiwa: yes
20:06:53 <dkayiwa> execute this:
20:07:01 <dkayiwa> k-joseph: show databases;
20:07:18 <dkayiwa> k-joseph: then copy and pastebin for me what it returns
20:07:21 <k-joseph> dkayiwa: what
20:08:38 <k-joseph> dkayiwa: sorry, openmrs is inclusive
20:08:39 <k-joseph> mysql> show databases;
20:08:39 <k-joseph> +--------------------+
20:08:39 <k-joseph>
20:08:39 <k-joseph> +--------------------+
20:08:39 <k-joseph>
20:08:39 <k-joseph>
20:08:39 <k-joseph>
20:08:40 <k-joseph>
20:08:40 <k-joseph>
20:08:41 <k-joseph> +--------------------+
20:08:41 <k-joseph> 5 rows in set (0.12 sec)
20:08:42 <k-joseph> mysql>
20:09:17 <dkayiwa> k-joseph: we use pastein for that in order not not clutter IRC
20:09:39 <dkayiwa> k-joseph: can you execute this:
20:09:42 <k-joseph> dkayiwa: ok please
20:09:50 <dkayiwa> k-joseph: drop database openmrs
20:09:51 <dkayiwa> ;
20:10:02 <dkayiwa> drop database openmrs;
20:10:46 <dkayiwa> k-joseph: after that execute the show databases again to confirm that the database was surely deleted
20:12:02 *** yony258 has joined #openmrs
20:12:19 <k-joseph> dkayiwa: it was successfull,
20:12:35 <dkayiwa> k-joseph: now exit the command prompt
20:12:49 <k-joseph> dkayiwa: done
20:12:51 <dkayiwa> k-joseph: and got to the browser to continue with the setup
20:13:10 <yony258> dkayiwa: Hi :)
20:13:32 <dkayiwa> yony258: hi :)
20:14:08 <yony258> dkayiwa: Whats up?
20:14:14 <dkayiwa> k-joseph: but i will tell you what to enter
20:14:23 <dkayiwa> yony258: nothing much :)
20:14:58 <k-joseph> dkayiwa: am there,
20:15:07 <yony258> dkayiwa: Let me know when you have like 15 minutes free, I wanted to update you on my progress and talk about what I need from you to continue, sounds ok?
20:15:50 <dkayiwa> yony258: when am on IRC, am ever ready :)
20:16:39 <yony258> dkayiwa: Ok so I made some progress on the form I need you to pull, but take into consideration that I added the "reason" property to Appointment so you'll need a fresh version.
20:19:20 <dkayiwa> yony258: ok
20:19:34 <yony258> dkayiwa: Let me push the most recent changes
20:19:40 <dkayiwa> yony258: ok
20:20:42 <yony258> dkayiwa: pushed :)
20:20:52 <dkayiwa> yony258: ok
20:24:51 <dkayiwa> yony258: did you run mvn install before pusing?
20:25:12 <yony258> dkayiwa: Yea, why? its not working?
20:25:38 <dkayiwa> yony258: it is doing some formatting here in my IDE
20:26:16 <yony258> dkayiwa: Oh maybe I added a file that didn't got formatted
20:26:47 <dkayiwa> yony258: if you did an mvn install before committing, then all should be formatted
20:27:32 <yony258> dkayiwa: Yes I added this file after doing mvn install
20:27:48 <dkayiwa> yony258: which file
20:29:23 <yony258> dkayiwa: I don't remember did it on 4am~
20:29:57 <dkayiwa> yony258: ok
20:30:51 <yony258> dkayiwa: i'll mvn install and push again
20:31:05 <dkayiwa> yony258: ok
20:31:46 <yony258> dkayiwa: By the way I did that HQL query, it was simpler than I though. Just my idea of join in HQL was incorrect.
20:32:03 <yony258> *thought
20:32:07 <dkayiwa> yony258: oh excellent!!! :D
20:35:35 <k-joseph> dkayiwa: how a bout this: A core module failed to start. The following modules are marked as 'core' by OpenMRS but were unable to start: logic v0.5.2,
20:36:08 <dkayiwa> yony258: so you needed not join with time slot table
20:36:31 <yony258> dkayiwa: Sorry, what?
20:36:43 <dkayiwa> yony258: for the HQL
20:36:50 <yony258> dkayiwa: yes?
20:37:08 <dkayiwa> k-joseph: can you check in your eclipse under bundled modules if you have the logic module there
20:37:20 <dkayiwa> k-joseph: that is in the webapp project
20:37:33 <yony258> dkayiwa: There is an inner join with appointment.timeSlot
20:38:06 <dkayiwa> k-joseph: WEB-INF\bundledModules
20:38:25 <dkayiwa> yony258: for the method? getAppointmentBlocks
20:38:51 <yony258> dkayiwa: getLastAppointment
20:39:05 <yony258> dkayiwa: HibernateAppointmentDAO
20:39:07 <dkayiwa> yony258: ok
20:43:25 <dkayiwa> yony258: can select max(...) return more than one row?
20:43:50 <k-joseph> dkayiwa: the file: logic-0.5.2.omod is there in eclipse
20:44:04 <yony258> dkayiwa: Don't think so, I'll change in->'='
20:44:11 <dkayiwa> yony258: ok
20:45:13 <dkayiwa> k-joseph: k-joseph can you stop the webapp and try run it again?
20:46:48 <dkayiwa> yony258: you seem to have good SQL skills :)
20:49:28 *** k-joseph has quit IRC
20:49:34 <yony258> dkayiwa: lol, why are you saying that?
20:50:02 <dkayiwa> yony258: your sql so far is good :)
20:50:29 <yony258> dkayiwa: Thank you, I thought you ment that this isn't the HQL way to do that :D
20:50:40 <yony258> *meant
20:51:14 <dkayiwa> yony258: there is still another more HQL way. But that will be for latter :)
20:51:25 <dkayiwa> yony258: let us first have some working module
20:51:33 <yony258> dkayiwa: ok
20:58:38 <dkayiwa> yony258: your UI is looking much better :)
21:04:44 <yony258> dkayiwa: lol
21:05:27 <dkayiwa> yony258: does this form save?
21:05:34 <yony258> dkayiwa: Nope
21:05:43 <yony258> dkayiwa: That is what I wanted to talk about
21:05:47 <dkayiwa> yony258: ok
21:06:15 <yony258> dkayiwa: I need to understand how the following topics works:
21:06:39 <yony258> dkayiwa: 1. Saving the object (take into consideration that the times table isn't exactly the timeSlot object).
21:07:16 <yony258> dkayiwa: 2. Keeping the fields values after post (now: the combo box are being erased)
21:08:01 <yony258> dkayiwa: I can understand that it will take too much time to explain this, but if you could direct me to a good reading sources on those topics so that I'll understand what im trying to do and how to do that
21:09:08 <dkayiwa> yony258: 1) saving is automatically done one you make the hibernate call
21:09:17 <dkayiwa> one = once
21:09:43 <yony258> dkayiwa: Yes but we need to first handle this in the controller
21:10:09 <dkayiwa> yony258: meaning?
21:10:58 <yony258> dkayiwa: How do you save this form if you dont have the timeSlot property of the Appointment? (you have a selected table line)
21:11:37 <dkayiwa> yony258: oh i see!!!
21:12:42 <yony258> dkayiwa: The mock-up in AM-4 shows an example
21:12:47 <yony258> !ticket AM-4
21:12:49 <OpenMRSBot> yony258: [#AM-4] Create new Appointment - OpenMRS JIRA - https://tickets.openmrs.org/browse/AM-4
21:12:52 <dkayiwa> yony258: ok
21:14:03 <dkayiwa> yony258: first step is having available time slots that come from real database
21:14:29 <yony258> dkayiwa: Yes correct
21:14:44 <dkayiwa> yony258: can you work on that
21:15:42 <yony258> dkayiwa: So my next target is: populate the times table with the correct available times, right?
21:16:00 <dkayiwa> yony258: perfect!!!
21:16:13 <yony258> dkayiwa: Ok, one issue that I can think about right now
21:17:09 <yony258> dkayiwa: What will the query return? (only the fields needed for the times table? or just the Time Slot object?)
21:17:53 <yony258> (to be more accurate - List of TimeSlots)
21:18:04 <dkayiwa> yony258: yes
21:18:21 <yony258> dkayiwa: ok
21:19:22 <yony258> dkayiwa: Ok, can you tell me why are the combo box erased on post?
21:19:40 <dkayiwa> yony258: ok
21:21:00 <dkayiwa> yony258: because they are not in <spring:bind
21:21:19 <yony258> dkayiwa: And 1 more thing :), can you send me a link/links that explains how the values of the form are sent to the controller? (for example: the selected clinician, the selected appointment type). So that I'll have a better understanding of what im doing.
21:22:22 <dkayiwa> yony258: when you enclose those fields in <spring:bind, it will be automatic
21:23:13 <yony258> dkayiwa: ok but what about selected clinician, which is optional, which says that it have another <option that isn't a real provider
21:23:50 <dkayiwa> yony258: they all have to be providers
21:24:15 <dkayiwa> yony258: oh i get you
21:24:22 <yony258> dkayiwa: So the "Not Specified" option should be a null provider?
21:24:37 <dkayiwa> yony258: yes will result into null
21:25:11 <yony258> dkayiwa: Ok so what I need to write for the first to be null?
21:25:20 <yony258> dkayiwa: a js function?
21:25:42 <dkayiwa> yony258: just leave that for later :)
21:25:51 <yony258> dkayiwa: ok I agree
21:26:26 <yony258> dkayiwa: Also, I wanted to ask if you can send me some links that explain how its done "behind the scenes" so that i'll have a better understanding of what im doing
21:27:05 <dkayiwa> yony258: http://levelup.lishman.com/spring/getting-started/index.php
21:27:11 <OpenMRSBot> <http://ln-s.net/+FS_> (at levelup.lishman.com)
21:27:25 <yony258> dkayiwa: Should I read everything in there?
21:27:40 <dkayiwa> yony258: yes
21:27:47 <yony258> dkayiwa: Ok great! thanks
21:28:08 <yony258> dkayiwa: So i'll be in touch and update you. Thank you Daniel
21:28:21 <dkayiwa> yony258: 8)
21:28:26 <tobin_g> dkayiwa: yony258 thanks guys :-)
21:28:34 <tobin_g> dkayiwa: yony258 i've just been lurking :P
21:28:55 <dkayiwa> tobin_g: thought you were sleeping here :O
21:29:25 <tobin_g> dkayiwa: glad you guys decided to say all those mean things about me via private message
21:30:08 <dkayiwa> tobin_g: :D
21:31:24 <tobin_g> dkayiwa: but now i'm off to bed! goodnight
21:31:36 <tobin_g> dkayiwa: adam told me he's hoping to finish up AM-3 tomorrow so keep your eyes out
21:31:38 <dkayiwa> tobin_g: goog night
21:31:46 <dkayiwa> tobin_g: ok
21:34:25 *** robbyoconnor has joined #openmrs
21:34:25 *** ChanServ sets mode: +v robbyoconnor
21:35:33 *** yony258 has quit IRC
21:37:09 *** tobin_g has quit IRC
21:38:11 *** djazayeri1 has joined #openmrs
21:40:55 *** djazayeri has quit IRC
22:15:20 *** dkayiwa has quit IRC
23:22:04 *** Mkop has quit IRC
23:23:22 *** Mkop has joined #openmrs
23:23:22 *** ChanServ sets mode: +v Mkop
23:38:31 *** Mkop has quit IRC
23:44:18 *** Mkop has joined #openmrs
23:44:18 *** ChanServ sets mode: +v Mkop
23:50:04 *** Mkop has quit IRC