IRC Chat : 2013-04-14 - OpenMRS

00:11:00 *** kraluk has quit IRC
00:20:07 *** robbyoconnor has quit IRC
00:35:58 *** jenn_ has quit IRC
00:54:55 *** dkayiwa has left #openmrs
01:01:16 *** NameFILIP has joined #openmrs
01:05:40 *** jenn_ has joined #openmrs
01:08:30 *** h3llborn has quit IRC
01:12:08 *** harsz89 has joined #openmrs
01:14:01 *** NameFILIP has quit IRC
01:15:05 *** NameFILIP has joined #openmrs
01:30:41 *** NameFILIP has quit IRC
01:31:37 *** portablejim has joined #openmrs
01:31:37 *** portablejim has joined #openmrs
03:51:27 *** Botha has joined #openmrs
03:51:27 <Botha> Hello World !
03:51:28 <Botha> My name is TrivialBot, i am apparently a trivial bot !
03:51:29 <Botha> Type !help for a list of available commands
03:55:05 *** Botha has quit IRC
04:59:51 *** nimby has joined #openmrs
05:15:53 *** k-joseph has joined #openmrs
05:31:37 *** sara has joined #openmrs
05:47:15 *** NameFILIP has joined #openmrs
05:49:52 *** robbyoconnor has joined #openmrs
05:49:52 *** ChanServ sets mode: +v robbyoconnor
05:56:29 *** Anuruddha has joined #openmrs
06:27:19 *** h3llborn has joined #openmrs
06:31:53 *** didymo has quit IRC
06:47:59 *** nimby has quit IRC
06:49:43 *** h3llborn has quit IRC
07:19:51 *** harshadura has quit IRC
07:20:55 *** sara has quit IRC
07:31:57 *** harshadura has joined #openmrs
07:31:57 *** ChanServ sets mode: +v harshadura
07:43:03 *** jb360 has quit IRC
07:43:57 *** portablejim has quit IRC
08:10:54 *** jenn_ has quit IRC
08:12:42 *** k-joseph has quit IRC
08:16:22 *** portablejim has joined #openmrs
08:16:22 *** portablejim has joined #openmrs
08:18:53 *** jenn_ has joined #openmrs
08:43:40 *** NameFILIP has quit IRC
08:56:49 *** dkayiwa has joined #openmrs
09:06:08 *** DraggonZ has joined #openmrs
09:16:55 *** moin has joined #openmrs
09:17:27 <moin> whois moin
09:32:49 *** khayamuddin31 has joined #openmrs
09:33:05 *** khayamuddin31 is now known as khayam
09:40:02 <khayam> Hi-dkayiwa, can you tell where i can see the description of database table in openmrs standalone. Please
09:40:39 <dkayiwa> khayam: do you mean looking at the actual tables?
09:42:42 *** NameFILIP has joined #openmrs
09:44:13 *** khayam has quit IRC
09:45:53 *** k-joseph has joined #openmrs
09:51:23 *** khayamuddin31 has joined #openmrs
09:51:27 *** khayamuddin31 is now known as khayam
09:52:07 <khayam> dkayiwa-no i'm getting db errors ERROR - HibernateForm2ProgramDAO.applyForm2ProgramMap(188) |2013-04-14 15:19:54,878| Column 'uuid' cannot be null
09:54:03 <dkayiwa> khayam: which object is that?
09:55:21 <khayam> dkayiwa-actually it is just a query- this.sessionFactory.getCurrentSession().connection().prepareStatement(query).executeUpdate();
09:57:08 <dkayiwa> khayam: which object is expected to have the uuid?
09:58:25 <khayam> dkayiwa-patient_program
09:58:42 <dkayiwa> khayam: does it have a uuid property?
09:59:07 <khayam> dkayiwa-yes
09:59:20 <dkayiwa> khayam: did you give it a value?
10:00:26 <khayam> dkayiwa-i don't have it that's why i am entering null but it is not accepting it
10:00:51 <dkayiwa> khayam: what is the base class of that object?
10:02:13 <khayam> dkayiwa-It is a form2program module i'm using HibernateForm2ProgramDAO.java
10:02:47 <dkayiwa> khayam: what is the object that you are trying to save to the database?
10:05:03 <khayam> dkayiwa-i'm not saving an object i'm executing query-rows = this.sessionFactory.getCurrentSession().connection().prepareStatement(query).executeUpdate();
10:05:46 <dkayiwa> khayam: can you create a unit test to reproduce that problem?
10:07:26 <khayam> dkayiwa-see this class http://pastebin.com/hLd48ZE1
10:09:12 <dkayiwa> khayam: is that a unit test?
10:10:27 *** moin has quit IRC
10:12:09 <khayam> dkayiwa-no applyForm2ProgramMap() giving me this exceptions
10:12:36 <dkayiwa> khayam: yes you can create a unit test which calls that method to reproduce the exception :)
10:13:05 *** NameFILIP has quit IRC
10:13:05 *** NameFILI_ has joined #openmrs
10:14:26 <khayam> dkayiwa-can you know how to open .frm files
10:14:29 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Modules: XForms 4.2.0.0 uploaded to OpenMRS Module Repository <https://modules.openmrs.org/modules/view.jsp?module=xforms&ampversion=&amp4.2.0.0>
10:14:57 <dkayiwa> khayam: where are they?
10:15:42 <khayam> dkayiwa-\openmrs-standalone-1.9.2\database\data\openmrs
10:16:37 <dkayiwa> khayam: what do you want to do with them?
10:17:49 <khayam> dkayiwa-i'm checking whether this patient_program table have a constraint that uuid cannot be a null
10:19:49 *** NameFILIP has joined #openmrs
10:20:13 *** NameFILI_ has quit IRC
10:21:55 <dkayiwa> khayam: ok
10:27:11 <khayam> dkayiwa-can you tell what uuid field contains, please
10:28:25 <dkayiwa> khayam: it contains a globally unique identifier
10:29:04 <khayam> dkayiwa-from where we can get this (class name)
10:29:22 <dkayiwa> khayam: you can generate one
10:30:08 <dkayiwa> khayam: e.g: this.setUuid(UUID.randomUUID().toString());
10:34:22 <khayam> dkayiwa-but their is no such method exist setuuid on my class and parent class
10:34:38 <dkayiwa> khayam: which class?
10:36:50 <khayam> dkayiwa-hibernateform2programdao here it is http://pastebin.com/hLd48ZE1
10:37:14 <dkayiwa> khayam: what object is that class trying to save to or retrieve from the database?
10:39:47 <khayam> dkayiwa-this class using query to save the object(patient_program), did you see that query?
10:40:12 <dkayiwa> khayam: what is the class of the object you are trying to save?
10:40:24 *** portablejim has quit IRC
10:42:52 *** portablejim has joined #openmrs
10:45:15 <khayam> dkayiwa-i'm inserting values into database by using query, i'm not passing any objects.
10:45:44 <dkayiwa> khayam: how does your sql insert statement look like?
10:46:44 <khayam> dkayiwa="INSERT INTO patient_program " + "(patient_id, program_id, date_enrolled, creator, date_created, changed_by, date_changed,uuid) " + "SELECT DISTINCT encounter.patient_id, " + program.getProgramId() + ", encounter.encounter_datetime, " + user.getUserId() + ", '" + df.format(day) + "', " + user.getUserId() + ", '" + df.format(day) + "','"+UUID.randomUUID().toString()+"' FROM encounter WHERE encounter.enco
10:47:14 <dkayiwa> khayam: are you also inserting in a uuid?
10:48:24 <khayam> dkayiwa-i have just now written it but it is not working
10:48:33 *** portablejim has quit IRC
10:48:42 <dkayiwa> khayam: what error?
10:49:18 <khayam> dkayiwa-Duplicate entry '17398bdf-138d-4bcf-b756-f30738a0d271' for key 'patient_program_uuid_index'
10:52:56 <dkayiwa> khayam: thats because you inserting a duplicate value (one that already exists)
10:55:55 *** portablejim has joined #openmrs
10:57:34 <khayam> dkayiwa-As you can see i'm inserting 2 different values http://pastebin.com/BkREcvLr
10:58:25 <dkayiwa> khayam: why don't you insert one value?
11:03:42 *** portablejim has quit IRC
11:05:11 *** portablejim has joined #openmrs
11:05:11 *** portablejim has joined #openmrs
11:10:44 *** portablejim has quit IRC
11:13:09 *** portablejim has joined #openmrs
11:13:23 *** khayam has quit IRC
11:16:03 *** harsz89 has quit IRC
11:18:33 *** portablejim has quit IRC
11:25:44 *** Ovidiu has joined #openmrs
11:27:49 *** harsz89 has joined #openmrs
11:33:11 *** NameFILIP has quit IRC
11:33:49 *** NameFILIP has joined #openmrs
11:34:44 *** NameFILIP has quit IRC
11:36:53 *** portablejim has joined #openmrs
11:36:53 *** portablejim has joined #openmrs
11:42:40 *** Ovidiu has quit IRC
11:43:52 *** portablejim has quit IRC
11:44:22 *** portablejim has joined #openmrs
11:45:20 *** dkayiwa has left #openmrs
11:46:52 *** NameFILIP has joined #openmrs
11:54:48 *** portablejim has quit IRC
12:01:24 *** portablejim has joined #openmrs
12:01:24 *** portablejim has joined #openmrs
12:04:12 *** k-joseph has quit IRC
12:10:13 *** portablejim has quit IRC
12:33:54 *** Anuruddha has quit IRC
12:51:36 *** NameFILIP has quit IRC
13:44:36 *** dkayiwa has joined #openmrs
14:16:53 *** k-joseph has joined #openmrs
14:24:38 *** k-joseph has quit IRC
14:25:33 *** k-joseph has joined #openmrs
15:04:03 *** NameFILIP has joined #openmrs
15:22:03 *** Anuruddha has joined #openmrs
15:35:19 *** DraggonZ has quit IRC
15:37:05 *** k-joseph has quit IRC
15:54:20 *** femilawal has joined #openmrs
15:58:45 <femilawal> Hello everyone, my name's Femi, 3rd year computer student applying for GSOC 2013. I chose to apply for OpenMRS because i believe in what they are doing, and have personally experienced cases where lack of proper data organisation has lead to delays and inconveniencing of patients. I also really like coding in java and database management. This is my first time applying for gsoc and its nice to be here!
16:04:50 *** wyclif has joined #openmrs
16:04:50 *** wyclif_ has quit IRC
16:05:20 *** wyclif has quit IRC
16:05:40 *** wyclif has joined #openmrs
16:18:49 *** lh has quit IRC
16:23:18 *** femilawal has quit IRC
16:26:43 *** Anuruddha has quit IRC
16:31:08 *** DraggonZ has joined #openmrs
17:05:17 *** nimby has joined #openmrs
17:10:45 *** jenn_ has quit IRC
17:11:30 *** jenn_ has joined #openmrs
17:20:12 *** harshadura has quit IRC
17:29:48 *** jenn_ has quit IRC
17:30:13 *** jenn_ has joined #openmrs
17:32:52 *** harshadura has joined #openmrs
17:32:52 *** ChanServ sets mode: +v harshadura
17:57:05 *** k-joseph has joined #openmrs
18:00:45 *** lauren has joined #openmrs
18:01:01 <lauren> @dkayiwa Hi! :)
18:01:08 *** lauren is now known as Guest75350
18:01:12 <dkayiwa> lauren: hey :)
18:01:37 <dkayiwa> arent you resting at home? :)
18:02:05 <Guest75350> haha, yes.
18:02:10 <Guest75350> oops they changed my alias.
18:02:18 <dkayiwa> Guest75350: :D
18:02:43 <Guest75350> haha
18:04:12 <Guest75350> do you want to work on the xform question?
18:04:24 <dkayiwa> Guest75350: am looking at your email. what is the name of the field with the problem?
18:04:49 <Guest75350> ok, which issue are we looking at?
18:05:08 <dkayiwa> Guest75350: am just looking at your email
18:06:50 <Guest75350> Ah, okay, it's a concept set. named: PATIENT REPORTED PROBLEM ADDED, DETAILED (id=2287)
18:07:16 <Guest75350> it has two child concepts, PATIENT REPORTED PROBLEM ADDED (id=2072) and DURATION OF ILLNESS IN DAYS (id=2286)
18:07:34 <dkayiwa> Guest75350: looking at it now
18:12:57 <Guest75350> thanks :)
18:16:32 <dkayiwa> Guest75350: so PATIENT REPORTED PROBLEM ADDED, DETAILED is the set. right?
18:16:38 <Guest75350> correct
18:16:47 <dkayiwa> Guest75350: with how many members?
18:17:07 <Guest75350> 2 set members (patient reported problem added & duration of illness in days)
18:18:13 <dkayiwa> Guest75350: so problem is that one of the two is missing. correct?
18:18:45 <Guest75350> That's right
18:18:56 <dkayiwa> Guest75350: which of the two?
18:19:38 <Guest75350> let me double check
18:20:47 <Guest75350> it's 'patient reported problem"
18:20:55 <Guest75350> which shows up separately from the set
18:22:08 <dkayiwa> Guest75350: do you think you can add on the ticket a screenshot of the concept set as it appears on the concept dictionary page?
18:22:40 <Guest75350> sure!
18:22:49 <dkayiwa> Guest75350: thanks
18:27:04 <Guest75350> here is the ticket, with the image: https://tickets.openmrs.org/browse/XFRM-149
18:27:35 <dkayiwa> Guest75350: looking at it now
18:28:36 <dkayiwa> Guest75350: so even number of weeks/months/years are all missing on the form?
18:29:13 <Guest75350> yes
18:29:43 <dkayiwa> Guest75350: ok let me look into that now
18:29:50 <Guest75350> thanks daniel :)
18:36:35 <dkayiwa> Guest75350: hi
18:36:43 <Guest75350> hey
18:36:54 <dkayiwa> Guest75350: did you get this error message?
18:36:56 <dkayiwa> Guest75350: Please ensure that this concept's class and datatype are correct. (class=Question should typically not be datatype=N/A.)
18:37:38 <Guest75350> Yeah
18:37:50 <dkayiwa> Guest75350: did you intentionally ignore it?
18:38:21 <Guest75350> Yes, this is an old concept and it has worked fine. It's a question set, so it should have n/a datatype. I don't know why the creator chose class=question, but that should be fine.
18:38:46 <dkayiwa> Guest75350: ok
18:38:55 *** robbyoconnor has quit IRC
18:39:01 <dkayiwa> Guest75350: can you cross check and tell me which version of the module you are using?
18:39:22 *** robbyoconnor has joined #openmrs
18:39:22 *** ChanServ sets mode: +v robbyoconnor
18:40:08 <Guest75350> dkayiwa: it is 4.1.1.0
18:40:38 <dkayiwa> Guest75350: can i have a screen shot of how the PATIENT REPORTED PROBLEM ADDED (2072) looks like?
18:40:56 <dkayiwa> Guest75350: that is in the concept dictionary
18:41:02 <Guest75350> sure!
18:42:33 <Guest75350> i added it to the ticket
18:42:42 <dkayiwa> Guest75350: ok checking
18:59:11 *** Guest75350 is now known as lauren
18:59:26 <jenn_> Hi, I am trying to get the source for the Advanced Concept Management Module and I found information that said it can be located in http://svn.openmrs.org/openmrs-modules/conceptmanagement/trunk/ - I have not been able to get this code successfully imported into my project. Is there anyone available for pointers and questions?
18:59:40 *** lauren is now known as Guest80997
19:08:40 *** lh has joined #openmrs
19:14:44 *** DraggonZ has left #openmrs
19:32:29 <dkayiwa> Guest80997: hi
19:39:24 <Guest80997> hey daniel
19:39:31 <dkayiwa> Guest80997: hey
19:39:43 <dkayiwa> Guest80997: seen my response on ticket
19:40:40 <Guest80997> ah, i see. will try this new version of the module now.
19:41:16 <dkayiwa> Guest80997: cool
19:41:36 <Guest80997> thanks!!
19:48:49 <Guest80997> dkayiwa: just posted my feedback to the ticket, I got an error
19:49:14 <dkayiwa> Guest80997: looking at it now
19:49:28 <dkayiwa> Guest80997: which openmrs version?
19:49:48 *** VishwaA_ has joined #openmrs
19:50:11 <Guest80997> we are using version 1.8.2
19:50:12 *** VishwaA_ has left #openmrs
20:02:17 *** kraluk has joined #openmrs
20:02:18 *** harsz89 has quit IRC
20:12:09 <dkayiwa> Guest80997: sent you another version on the ticket :)
20:17:20 *** k-joseph has quit IRC
20:19:02 *** k-joseph has joined #openmrs
20:19:19 <Guest80997> dkayiwa: i have to leave for now, but I will try the new module tonight. will stay in touch. thank you!!
20:19:34 <dkayiwa> Guest80997: sure thanks and keep me posted :)
20:25:44 *** jb360 has joined #openmrs
20:28:00 *** Guest80997 has quit IRC
20:46:48 *** wyclif has quit IRC
20:48:01 *** wyclif has joined #openmrs
20:54:47 *** lh has quit IRC
21:02:13 *** lh has joined #openmrs
21:02:13 *** lh has joined #openmrs
21:08:19 *** davwise has joined #openmrs
21:09:42 *** davwise has quit IRC
21:09:49 *** lh has quit IRC
21:09:50 <OpenMRSBot> Recent updates in the world of openmrs: Malte Friese: Look back <http://maltef.wordpress.com/2013/04/14/look-back/>
21:14:01 *** kraluk has quit IRC
21:17:46 *** h3llborn has joined #openmrs
21:27:59 *** nimby has quit IRC
21:35:01 *** jb360 has quit IRC
21:36:09 *** nimby has joined #openmrs
21:41:26 *** lh has joined #openmrs
21:41:26 *** lh has joined #openmrs
21:49:52 *** h3llborn has quit IRC
22:10:27 *** jb360 has joined #openmrs
22:22:21 *** k-joseph has quit IRC
22:27:57 *** h3llborn has joined #openmrs
22:33:25 *** nimby has quit IRC
23:15:19 *** dkayiwa has quit IRC
23:20:08 *** areke has joined #openmrs
23:20:18 *** areke has left #openmrs
23:25:05 *** Metalan has joined #openmrs
23:25:27 <Metalan> I'm having an issue trying to create a valid HL7 encounter/observation message
23:25:58 <Metalan> I can get it to the OpenMRS HL7 queue through the REST API, but I'm getting this error: Missing patient identifier in PID segment
23:26:13 <Metalan> I'm sending this message
23:26:14 <Metalan> MSH|^~\&||LOCAL|||20130414181557.696-0600||ORU^R01^ORU_R01|37|T|2.5
23:26:14 <Metalan> PID||7279MP-4
23:26:16 <Metalan> OBR|1||1234^LAB|88304
23:26:16 <Metalan> OBX|1|NM|5089^WEIGHT (KG)^DCT||80|kg
23:26:37 <Metalan> Second line has PID, but I can't figure out what segment I'm missing
23:27:19 *** NameFILIP has quit IRC
23:36:16 *** ShinyAnna has joined #openmrs
23:51:04 *** Metalan has quit IRC