| 00:36:54 | *** openmrs_1870 has quit IRC |
| 01:25:29 | *** Mario__ has joined #openmrs |
| 01:26:08 | *** pygi has quit IRC |
| 01:26:12 | *** Mario__ is now known as pygi |
| 01:29:28 | *** Mario__ has joined #openmrs |
| 01:30:08 | *** pygi has quit IRC |
| 01:30:16 | *** Mario__ is now known as pygi |
| 01:33:43 | *** pygi has quit IRC |
| 01:33:46 | *** pygi has joined #openmrs |
| 01:54:42 | *** pygi has quit IRC |
| 01:54:49 | *** Mario__ has joined #openmrs |
| 01:58:29 | *** Mario__ is now known as pygi |
| 04:21:40 | *** [m_harrison] has joined #openmrs |
| 04:24:32 | *** pygi has quit IRC |
| 04:41:20 | *** bwolfe has quit IRC |
| 06:24:54 | *** pygi has joined #openmrs |
| 08:53:45 | <OpenMRSBot> Recent updates in the world of openmrs: Sam Ndichu: PatientVisitScheduler status <http://sndichu.blogspot.com/2008/08/patientvisitscheduler-status.html> |
| 09:11:40 | *** pygi has quit IRC |
| 10:17:46 | *** upul has joined #openmrs |
| 11:01:53 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #1165 (task created): can't download form because of velocity error <http://dev.openmrs.org/ticket/1165> |
| 11:14:40 | *** upul has quit IRC |
| 11:28:22 | *** quadelirus has joined #openmrs |
| 11:32:35 | <quadelirus> Hi, I'm working on a form based on the "Complex features for concepts, forms, fields and formentry" wiki page, but I've run into a snag. |
| 11:34:38 | <quadelirus> When I do the first part of the tutorial, everything works fine. |
| 11:36:40 | <quadelirus> Then I decided to switch from using a select box to using the taskPane Widget |
| 11:38:44 | <quadelirus> here everything works except when I try to submit the form. |
| 11:44:57 | *** quadelirus_ has joined #openmrs |
| 11:45:57 | *** quadelirus has quit IRC |
| 12:03:58 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #862 (defect reopened): scheduler fails to schedule task <http://dev.openmrs.org/ticket/862#comment:3> |
| 12:13:29 | *** quadelirus has joined #openmrs |
| 12:14:56 | *** quadelirus_ has quit IRC |
| 12:33:34 | *** james_regen has joined #openmrs |
| 12:33:34 | *** ChanServ sets mode: +v james_regen |
| 13:11:00 | *** pygi has joined #openmrs |
| 13:12:49 | *** bwolfe has joined #openmrs |
| 13:12:49 | *** ChanServ sets mode: +o bwolfe |
| 13:21:12 | *** Mario__ has joined #openmrs |
| 13:21:31 | *** pygi has quit IRC |
| 13:21:51 | *** Mario__ is now known as pygi |
| 13:42:18 | *** Keelhaul has joined #openmrs |
| 13:49:09 | <Keelhaul> bwolfe: i cannot use concepts of the class "diagnosis" in obs |
| 13:49:15 | <Keelhaul> where can i use them at all |
| 13:57:36 | *** quadelirus has quit IRC |
| 14:16:14 | *** pygi has quit IRC |
| 14:39:45 | *** nribeka has joined #openmrs |
| 14:45:22 | *** [m_harrison] has quit IRC |
| 14:58:52 | <Keelhaul> this is so frustrating |
| 14:58:56 | <Keelhaul> half a day's work for nothing |
| 14:59:14 | <Keelhaul> defined a few dozens of patient searches for reports |
| 14:59:20 | <Keelhaul> now i have to do them all again |
| 14:59:26 | <Keelhaul> because it wont let me edit them.. |
| 15:00:09 | <Keelhaul> theres no db software for that mysql so i dont know what the table structure looks like |
| 15:02:44 | *** pygi has joined #openmrs |
| 15:05:03 | <bwolfe> Keelhaul: why can't you use diagnosis' ?? |
| 15:05:09 | <bwolfe> Keelhaul: its all about the datatype I thought... |
| 15:05:37 | <bwolfe> Keelhaul: table structure for what mysql stuff? |
| 15:05:44 | <Keelhaul> reporting framework |
| 15:05:59 | <Keelhaul> i found the table for cohorts |
| 15:06:05 | <Keelhaul> but not for saves searches etc |
| 15:06:57 | <Keelhaul> ok i found how to edit searches from the admin panel |
| 15:07:07 | <Keelhaul> it was jsut being pedantic about java class names |
| 15:07:17 | <Keelhaul> but the diagnosis stuff hmm |
| 15:07:27 | <Keelhaul> basically, how do you express a diagnosis? |
| 15:07:40 | <Keelhaul> i'd say use it as a concept in an obs |
| 15:07:46 | <Keelhaul> but the obs says invalid concept |
| 15:08:10 | <Keelhaul> and the cohort that searches for that obs is always empty |
| 15:12:40 | *** pygi has quit IRC |
| 15:12:57 | *** pygi has joined #openmrs |
| 15:17:05 | <bwolfe> what is the datatype for that concept ? |
| 15:17:20 | <bwolfe> diagnosis' are usually "N/A" because they are actually answers to other concepts |
| 15:17:52 | <bwolfe> so a diagnosis is usually in the value_coded (the 'answer') column. the concept_id (the 'question') column has a concept with a datatype of 'coded' |
| 15:18:30 | <Keelhaul> n/a, yes |
| 15:18:38 | <Keelhaul> ooh |
| 15:18:49 | <Keelhaul> so it's not a standalone concept? |
| 15:18:55 | <Keelhaul> what would the question be then |
| 15:21:18 | <Keelhaul> because the cohort builder wont let me use just the answer |
| 15:21:26 | <Keelhaul> or at least doesnt get any results that way |
| 15:21:42 | <Keelhaul> it's also extra work |
| 15:22:06 | <Keelhaul> you'd have to have a "diagnosis?" question with all the possible diagnoses added to it as answers |
| 15:26:00 | <bwolfe> Keelhaul: with the cohort builder, you would have to search for that diagnosis concept, they say "all obs _answered_ by this concept" |
| 15:26:11 | <bwolfe> (I dont' remember the exact wording) |
| 15:28:47 | <Keelhaul> yea i know |
| 15:29:14 | <Keelhaul> but the problem is, it doesn't show that option when you select a diagnosis concept |
| 15:29:29 | <Keelhaul> only for test concepts |
| 15:29:39 | <bwolfe> the cohort builder doesn't? |
| 15:30:05 | <Keelhaul> in fact, it only lets you select to search for patients who do or do not have the concept, plus the time period |
| 15:30:10 | <Keelhaul> nope |
| 15:30:33 | <Keelhaul> the search definition form you get depends on the concept class |
| 15:31:34 | <Keelhaul> hold on, i'll show |
| 15:34:17 | <Keelhaul> http://img159.imageshack.us/img159/9995/conceptdiagdl8.png |
| 15:34:20 | <OpenMRSBot> <http://ln-s.net/2Ys3> (at img159.imageshack.us) |
| 15:34:28 | <Keelhaul> this is all you get when you select a diagnosis concept |
| 15:35:47 | <Keelhaul> http://img159.imageshack.us/img159/827/concepttestpt1.png |
| 15:35:48 | <OpenMRSBot> <http://ln-s.net/2Ys4> (at img159.imageshack.us) |
| 15:35:53 | *** Mario__ has joined #openmrs |
| 15:35:55 | <Keelhaul> and this if it's a test concept |
| 15:36:40 | *** pygi has quit IRC |
| 15:36:44 | *** Mario__ is now known as pygi |
| 15:37:18 | <bwolfe> Keelhaul: so what is the question you want to answer with "blood sugar" ? |
| 15:37:31 | <Keelhaul> you tell me =P |
| 15:37:46 | <bwolfe> Keelhaul: I mean at a high level. tell me what kind of data you're wanting |
| 15:38:05 | <Keelhaul> i want to save "diabetes" as a diagnosis in an observation |
| 15:38:13 | <Keelhaul> so the patient search can pick that up |
| 15:38:45 | <bwolfe> so you want to add an answer of "diabetes" to the "Problem Added" question |
| 15:38:56 | <Keelhaul> problem added is the question? |
| 15:38:57 | <Keelhaul> ok |
| 15:39:21 | <Keelhaul> hmm, no answers defined |
| 15:39:38 | <bwolfe> problem added can take any answer |
| 15:40:13 | <bwolfe> what kind of patients are you wanting to find? "give me all patients that have been told they have diabetes" ?? |
| 15:40:27 | <Keelhaul> yes |
| 15:40:39 | <bwolfe> then your first screenshot: http://img159.imageshack.us/img159/9995/conceptdiagdl8.png is what you want |
| 15:40:40 | <Keelhaul> and then do a boolean AND with other indicators |
| 15:40:40 | <OpenMRSBot> <http://ln-s.net/2Ys3> (at img159.imageshack.us) |
| 15:41:06 | <Keelhaul> bwolfe: i know, i was just showing you how weird the search is =P |
| 15:41:31 | <Keelhaul> however, as i tried to add answers to the "problem added" concept, i got this again |
| 15:41:32 | <Keelhaul> org.springframework.dao.DataIntegrityViolationException |
| 15:41:43 | <Keelhaul> i wonder why |
| 15:41:51 | *** Mario__ has joined #openmrs |
| 15:41:53 | <Keelhaul> sometihng must have gone wrong when updating concept words or sometihng |
| 15:42:07 | <Keelhaul> because my home db doesnt throw that |
| 15:42:20 | <bwolfe> or you have some bung data |
| 15:42:24 | <bwolfe> :-) |
| 15:42:25 | <Keelhaul> maybe |
| 15:42:29 | <Keelhaul> but i really dont wanna wipe |
| 15:42:33 | *** nribeka has left #openmrs |
| 15:42:42 | <Keelhaul> i spent quite a bit of time looking up normal/critical ranges and saving them |
| 15:42:52 | *** bmckown has joined #openmrs |
| 15:42:52 | *** ChanServ sets mode: +o bmckown |
| 15:42:53 | <bwolfe> by "how weird the search is", do you mean how it shows different suboptions depending on the concept you selected ? |
| 15:43:02 | <Keelhaul> yea |
| 15:43:03 | *** pygi has quit IRC |
| 15:43:16 | <bwolfe> Keelhaul: you need to find which foreign key is being violated |
| 15:43:17 | <Keelhaul> as in, it wont let me search for a diagnosis as an answer |
| 15:43:43 | <Keelhaul> yea, finding out anytihng is kinda hard when all you ahve is the mysql cmd line |
| 15:43:51 | <bwolfe> so do things like "select * from concept c where not exists (select user_id from users where users.user_id = c.creator)" |
| 15:43:51 | <Keelhaul> theres no httpd on that server |
| 15:44:12 | <bwolfe> do it for concept, concept_name |
| 15:44:14 | <Keelhaul> i tried making the db accept connections from the outside, but it didnt work for some reason |
| 15:44:18 | <bwolfe> and for creator, changed_by |
| 15:44:59 | <Keelhaul> Empty set (0.01 sec) |
| 15:45:14 | <Keelhaul> ok its not users.. |
| 15:45:43 | *** Mario__ is now known as pygi |
| 15:57:55 | <Keelhaul> oh heh |
| 15:57:56 | <Keelhaul> select * from concept c where not exists (select user_id from users where users.user_id = c.changed_by); |
| 15:58:09 | <Keelhaul> that one yields 1102 rows |
| 15:59:22 | <Keelhaul> but changed_by can be null |
| 16:01:20 | <bwolfe> right |
| 16:01:48 | <bwolfe> so put add a "and c.changed_by is not null" right before the semi colon |
| 16:03:46 | <Keelhaul> select * from concept c where c.changed_by is not null and not exists (select user_id from users where users.user_id = c.changed_by); |
| 16:03:52 | <Keelhaul> empty set =/ |
| 16:05:16 | <bwolfe> Keelhaul: retired by ? |
| 16:05:20 | <bwolfe> datatype_id ? |
| 16:05:23 | <bwolfe> class_id ? |
| 16:05:36 | <bwolfe> those are all the foreign keys on the concept table |
| 16:06:15 | <bwolfe> but you really only need to look at the "problem added" concept if thats the one throwing the erorr |
| 16:06:58 | <bwolfe> look at foreign keys in concept_name, concept_name_tag, concept_name_tag_map, concept_answer, concept_set (if problem added is using that one) |
| 16:06:59 | <Keelhaul> no, it's basically all the concepts that came with the sample dataset |
| 16:07:04 | <Keelhaul> the ones i added aren't affected |
| 16:07:20 | <Keelhaul> i just wiped changed_by on all concepts |
| 16:07:22 | <Keelhaul> didnt help =/ |
| 16:14:27 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [6240]: formentry module 1.4.x branch: switched velocity calls to use the ⦠<http://dev.openmrs.org/changeset/6240> |
| 16:24:44 | <Keelhaul> there really needs to be a way to make forms, reports etc more portable =/ |
| 16:26:50 | <bwolfe> Keelhaul: yeah, hopefully we can do that with the occ or similar |
| 16:27:14 | <bwolfe> Keelhaul: for now, you can move forms and concepts between two of your own places with the formimportexport module |
| 16:27:27 | <bwolfe> it expects all concepts/forms to be done in one place (at a time) though |
| 16:32:57 | *** pygi has quit IRC |
| 16:33:41 | *** pygi has joined #openmrs |
| 16:36:01 | *** [m_harrison] has joined #openmrs |
| 16:39:14 | <Keelhaul> ic |
| 16:39:17 | <Keelhaul> well |
| 16:39:24 | <Keelhaul> does it support the refactored concepts though |
| 16:39:39 | <Keelhaul> i just wiped the concept_name_tag_map table =/ |
| 16:39:41 | <Keelhaul> great move |
| 16:39:52 | <Keelhaul> actually i "exported" it first |
| 16:40:01 | <Keelhaul> but now i cant locate the file |
| 16:42:08 | <Keelhaul> oh hm |
| 16:42:27 | <Keelhaul> it adds a new preferred_en name tag every time i add a main name to a concept |
| 16:42:32 | <Keelhaul> that cant be right.. |
| 16:42:50 | <Keelhaul> |
| 16:43:01 | <Keelhaul> i think theres only supposed to be one of each kind |
| 16:53:25 | *** Mario__ has joined #openmrs |
| 16:53:54 | *** pygi has quit IRC |
| 16:53:56 | *** Mario__ is now known as pygi |
| 16:54:49 | *** Keelhaul has quit IRC |
| 17:06:04 | *** Mario__ has joined #openmrs |
| 17:06:46 | *** pygi has quit IRC |
| 17:07:40 | *** Mario__ is now known as pygi |
| 17:16:35 | <OpenMRSBot> Recent updates in the world of openmrs: News Blog: Rwandan OpenMRS Training course <http://blog.openmrs.org/?p=93> |
| 17:17:36 | *** [m_harrison] has quit IRC |
| 17:28:56 | *** [m_harrison] has joined #openmrs |
| 17:44:05 | *** pygi has quit IRC |
| 17:51:40 | *** [m-harrison] has joined #openmrs |
| 17:52:09 | *** pygi has joined #openmrs |
| 18:10:02 | *** [m_harrison] has quit IRC |
| 18:15:25 | *** [m-harrison] has quit IRC |
| 18:46:52 | *** nribeka1 has joined #openmrs |
| 18:47:01 | *** bla515215 has joined #openmrs |
| 18:52:14 | *** pygi has quit IRC |
| 18:52:16 | *** bla515215 is now known as pygi |
| 18:52:21 | <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [6245]: -- openmrs logic branch * fixed errors in hibernate criteria creation for ⦠<http://dev.openmrs.org/changeset/6245> || OpenMRS Changesets: Changeset [6244]: -- openmrs logic branch * fixed java translator in arden package to allow ⦠<http://dev.openmrs.org/changeset/6244> || OpenMRS Changesets: Changeset [6243]: -- chica * updated JIT rules * added JIT rules and MLMs for maternal ⦠<http://dev.openmrs.org/changeset/6243> || OpenMRS Changesets: Changeset [6242]: -- atd * fixed lastEncounter rule <http://dev.openmrs.org/changeset/6242> || OpenMRS Changesets: Changeset [6241]: -- sockethl7listener * updated openmrs test jars <http://dev.openmrs.org/changeset/6241> |
| 19:00:52 | <bwolfe> pygi: are you having trouble with your connection today? :-) |
| 19:01:02 | <pygi> bwolfe, with my laptop :( |
| 19:01:05 | <pygi> I need a new one :( |
| 19:05:28 | *** nribeka1 has quit IRC |
| 19:05:37 | *** nribeka has joined #openmrs |
| 19:05:55 | *** nribeka has left #openmrs |
| 19:08:03 | <pygi> bwolfe, it sucks, I cant do any sane development.. |
| 19:08:25 | <bwolfe> pygi: is it just your network card, or is it the entire laptop ? |
| 19:08:36 | <pygi> bwolfe, laptop is overheating |
| 19:08:54 | <bwolfe> pygi: have you thought about working in a freezer? |
| 19:08:59 | <pygi> no |
| 19:11:17 | <pygi> bwolfe, whats the best spring book you can recommend? |
| 19:12:00 | <bwolfe> pygi: I think theres an "in action" book on spring |
| 19:12:15 | <bwolfe> I liked the "hibernate in action" book, so the spring one should be good |
| 20:36:11 | *** james_regen has quit IRC |
| 20:38:57 | *** pygi has quit IRC |
| 21:07:59 | *** [m_harrison] has joined #openmrs |
| 21:08:09 | *** [m_harrison] has quit IRC |
| 21:35:50 | *** pygi has joined #openmrs |
| 22:24:07 | *** bwolfe has quit IRC |
