| 00:22:12 | *** Echidna has quit IRC |
| 01:23:43 | *** r0bby has joined #openmrs |
| 01:23:43 | *** ChanServ sets mode: +v r0bby |
| 02:23:12 | *** Gretchie has quit IRC |
| 03:20:03 | *** deadpool_ has quit IRC |
| 03:32:31 | *** r0bby has quit IRC |
| 03:47:25 | *** r0bby has joined #openmrs |
| 03:47:25 | *** ChanServ sets mode: +v r0bby |
| 03:47:36 | *** r0bby has quit IRC |
| 03:56:06 | *** r0bby has joined #openmrs |
| 03:56:06 | *** ChanServ sets mode: +v r0bby |
| 04:08:09 | <OpenMRSBot> Recent updates in the world of openmrs: Developer ML: HL7 Output Messages <https://listserv.iupui.edu/cgi-bin/wa-iupui.exe?A2=ind1110&L=openmrs-devel-l&P=190140> || OpenMRS Modules: Form Entry 4.5.9.4 uploaded to OpenMRS Module Repository <https://dev.openmrs.org/modules/view.jsp?module=formentry&version=&4.5.9.4> |
| 05:02:30 | *** r0bby__ has joined #openmrs |
| 05:02:30 | *** ChanServ sets mode: +v r0bby__ |
| 05:06:23 | *** r0bby has quit IRC |
| 05:06:56 | *** r0bby__ has quit IRC |
| 05:26:45 | *** nribeka has joined #openmrs |
| 05:26:45 | *** ChanServ sets mode: +v nribeka |
| 06:45:39 | *** lh_ has quit IRC |
| 06:56:18 | *** djazayeri has quit IRC |
| 07:56:37 | *** djazayeri has joined #openmrs |
| 07:56:37 | *** ChanServ sets mode: +o djazayeri |
| 10:37:14 | *** r0bby has joined #openmrs |
| 10:37:14 | *** ChanServ sets mode: +v r0bby |
| 10:42:41 | *** bwolfe has joined #openmrs |
| 10:42:41 | *** ChanServ sets mode: +o bwolfe |
| 11:04:39 | *** r0bby has quit IRC |
| 11:15:39 | *** Echidna has joined #openmrs |
| 11:15:39 | *** ChanServ sets mode: +v Echidna |
| 11:20:55 | *** bwolfe has quit IRC |
| 11:24:34 | *** Gretchie has joined #openmrs |
| 11:27:46 | *** bwolfe has joined #openmrs |
| 11:27:46 | *** ChanServ sets mode: +o bwolfe |
| 11:33:21 | *** bwolfe has quit IRC |
| 11:45:55 | *** bwolfe has joined #openmrs |
| 11:45:55 | *** ChanServ sets mode: +o bwolfe |
| 11:51:04 | *** bryq has joined #openmrs |
| 11:51:04 | *** ChanServ sets mode: +v bryq |
| 11:54:05 | *** bwolfe has quit IRC |
| 11:58:35 | *** r0bby has joined #openmrs |
| 11:58:35 | *** ChanServ sets mode: +v r0bby |
| 12:06:05 | *** bwolfe has joined #openmrs |
| 12:06:05 | *** ChanServ sets mode: +o bwolfe |
| 12:12:44 | *** bryq has quit IRC |
| 12:15:23 | *** bwolfe has quit IRC |
| 12:28:55 | *** bryq has joined #openmrs |
| 12:28:55 | *** ChanServ sets mode: +v bryq |
| 12:58:58 | *** Suho has joined #openmrs |
| 13:02:40 | *** Suho_ has joined #openmrs |
| 13:04:00 | <Suho> Hi anybody worked with OpenMRS Standalone in windows? |
| 13:12:18 | *** bwolfe has joined #openmrs |
| 13:12:18 | *** ChanServ sets mode: +o bwolfe |
| 13:15:43 | <Suho> Hi anybody worked with OpenMRS Standalone in windows? |
| 13:16:17 | <Suho> I'm getting [MysqldResource] launching mysqld (driver_launched_mysqld_2) |
| 13:16:17 | <Suho> 111029 18:28:35 [Note] Plugin 'FEDERATED' is disabled. |
| 13:16:17 | <Suho> 111029 18:28:36 InnoDB: Operating system error number 87 in a file operation. |
| 13:16:35 | <Suho> please help |
| 13:31:35 | *** lh_ has joined #openmrs |
| 13:33:25 | *** kishoreyekkanti has joined #openmrs |
| 13:50:16 | *** nribeka has quit IRC |
| 13:51:03 | *** lh_ has quit IRC |
| 13:53:30 | *** bwolfe has quit IRC |
| 14:03:03 | *** r0bby has quit IRC |
| 14:03:36 | *** kishoreyekkanti has quit IRC |
| 14:31:19 | *** Suho has quit IRC |
| 14:39:45 | *** Suho has joined #openmrs |
| 14:52:21 | *** kishoreyekkanti has joined #openmrs |
| 15:17:30 | <kishoreyekkanti> djazayeri: Hi Darius you there? |
| 15:24:29 | *** Suho_ has joined #openmrs |
| 15:26:39 | *** Suho has quit IRC |
| 15:39:14 | *** Suho_ has quit IRC |
| 17:26:13 | <djazayeri> hi kishoreyekkanti |
| 17:27:29 | <kishoreyekkanti> djazayeri: Hi Darius. Good morning :) I have a question on upgrading concept tables from 1.6 to 1.7 |
| 17:27:29 | <kishoreyekkanti> d |
| 17:27:37 | <djazayeri> yes |
| 17:27:38 | <djazayeri> ? |
| 17:28:12 | <kishoreyekkanti> djazayeri: Does this migration always clean the 1.7 concept tables and insert fresh every time or it should be additive |
| 17:28:41 | <djazayeri> Concepts should not be deleted and recreated |
| 17:28:49 | <djazayeri> kishoreyekkanti: the existing ones should be upgraded |
| 17:28:55 | <djazayeri> (is that what you're asking?) |
| 17:29:25 | <kishoreyekkanti> djazayeri: Oh yeah i was asking about that only |
| 17:30:00 | <djazayeri> okay |
| 17:30:01 | <kishoreyekkanti> djazayeri: Sql dump recieved from andrew have queries which will insert into concept tables after checking whether the concept tables exists |
| 17:30:13 | <djazayeri> hmm, let me look at that attachment |
| 17:32:02 | <djazayeri> kishoreyekkanti: the attachment he sent is a dump of his 1.6.3 database |
| 17:32:13 | <djazayeri> i.e. it's the input that needs to be upgraded to 1.7 format |
| 17:33:14 | <djazayeri> The key thing is that, given this input, you should be able to produce a .sql dump of a 1.7 database |
| 17:33:56 | <djazayeri> I would assume that the way to do that is to run his sql file as input (thus loading it into the db), then run another sql script (to be written) and/or some java, thus upgrading the db in mysql |
| 17:34:10 | <djazayeri> and finally let andy dump that to a file using the standard mysqldump tool. |
| 17:36:13 | <kishoreyekkanti> yeah! Say I already have 1.7 db with some set of concepts. and say i've generate a 1.7 compatible mysql dump from 1.6.sql. I'm thinking of any conflicts between already existing db and the generated mysql dump |
| 17:36:14 | <djazayeri> kishoreyekkanti: make sense? |
| 17:36:32 | <djazayeri> kishoreyekkanti: ah, no, we're ignoring that case |
| 17:36:51 | <djazayeri> the ultimate consumer of the 1.7 MVP dictionary db is not allowed to keep their own concepts |
| 17:37:07 | <djazayeri> we expect that they'll do some (ugly) splicing together of databases |
| 17:37:25 | <djazayeri> Currently the subscribe/update process is a manual mess |
| 17:37:44 | <djazayeri> (incidentally I'd like to talk about that as a pre-TW-U projects) |
| 17:37:56 | <kishoreyekkanti> ohh ok :) |
| 17:38:12 | <kishoreyekkanti> i think i understand this better now! |
| 17:38:19 | <djazayeri> but the goal here is just that the dictionary being published by MVP should be available in 1.6 *and* 1.7, thus making the splicing job much easier |
| 17:39:04 | <kishoreyekkanti> okay |
| 17:40:22 | <kishoreyekkanti> djazayeri: Did you met Roy yesterday? |
| 17:40:37 | <djazayeri> kishoreyekkanti: no, he stopped by indianapolis and met with paul |
| 17:40:44 | <djazayeri> I hear the conversations were very productive |
| 17:41:00 | <kishoreyekkanti> djazayeri: Yeah :) me too heard the same from jeff |
| 17:43:35 | <djazayeri> kishoreyekkanti: I'm talking with Jeff on Tuesday, so we'll figure out more then. |
| 17:43:46 | <djazayeri> okay, gotta run |
| 17:43:55 | <djazayeri> email if you have more questions |
| 17:44:04 | <kishoreyekkanti> djazayeri: Sure! talk to you later |
| 17:44:32 | <djazayeri> (oh, by the way, of all those too-long projects I emailed you, the SQL upgrade one is the really important one. |
| 17:45:10 | <djazayeri> If that can be done, and the rest are just little bugfix tickets, that'd be a win.) |
| 17:45:15 | <djazayeri> okay, gotta run |
| 17:45:37 | <kishoreyekkanti> djazayeri: Sure will do that as priority. |
| 17:49:06 | *** bwolfe has joined #openmrs |
| 17:49:06 | *** ChanServ sets mode: +o bwolfe |
| 17:58:44 | *** lh_ has joined #openmrs |
| 17:59:00 | *** lh has quit IRC |
| 17:59:00 | *** lh_ is now known as lh |
| 17:59:23 | *** lh_ has joined #openmrs |
| 18:10:43 | *** lh has quit IRC |
| 18:10:43 | *** lh_ is now known as lh |
| 18:20:25 | *** lh_ has joined #openmrs |
| 18:20:36 | *** lh_ has joined #openmrs |
| 18:59:10 | <kishoreyekkanti> where can i find the utility which will give us a .sql of db structural changes between two releases say 1.6 and 1.7 based on liquibase-update-to-latest |
| 19:06:16 | *** lh_ has quit IRC |
| 19:13:14 | <kishoreyekkanti> bwolfe: any idea? |
| 19:15:06 | <bwolfe> burke wrote a groovy script for it at one point |
| 19:15:22 | <bwolfe> and the liquibase-build.xml file used to have a way to generate .sql files |
| 19:15:31 | <bwolfe> (not sure it works after the maven conversion in 1.8) |
| 19:15:38 | <bwolfe> kishoreyekkanti ^^ |
| 19:16:37 | <kishoreyekkanti> bwolfe: Yeah i've seen a ant target -diffDatabase but not sure whether that does it? |
| 19:18:37 | *** robbyoconnor has quit IRC |
| 19:31:36 | <bwolfe> kishoreyekkanti, perhaps. its been a while since I used it |
| 19:32:16 | <kishoreyekkanti> bwolfe: no problem i've found a way to do it. There's a intellij plugin for liquibase which will generate migration script |
| 19:49:12 | *** thothathri has joined #openmrs |
| 19:50:49 | <thothathri> @ben wolfe aobut the HL7Output Project, can we use hl7_messagestate to maintain the status, or should there be a status field in the db other than this? |
| 19:55:43 | *** shishirmk has joined #openmrs |
| 19:58:10 | *** sri_desktop has joined #openmrs |
| 19:59:18 | <sri_desktop> hi |
| 20:00:52 | <bwolfe> kishoreyekkanti, very cool |
| 20:01:06 | <bwolfe> thothathri, where is that? is that a table? |
| 20:01:12 | <bwolfe> or a column? |
| 20:02:41 | <thothathri> @bwolfe its the colum in the HL7_OutQueue |
| 20:02:49 | <thothathri> table |
| 20:05:19 | <thothathri> @bwolfe so we thought we'd just have columns similar to those in HL7_InQueue except for HL7_source and hL7_source_key. And that we could have the same hl7_messagestate which would save our status, as initially we are doing it without a destination |
| 20:05:51 | *** sri_desktop has quit IRC |
| 20:08:27 | *** shishirmk has joined #openmrs |
| 20:10:24 | <bwolfe> thothathri, sounds right |
| 20:10:37 | *** lh_ has joined #openmrs |
| 20:11:06 | <thothathri> @bwolfe cool, ill try to implement this then |
| 20:11:17 | *** lh_ has quit IRC |
| 20:26:24 | *** bwolfe has quit IRC |
| 20:27:40 | *** kishoreyekkanti has quit IRC |
| 21:14:02 | *** lh_ has joined #openmrs |
| 21:34:30 | *** bryq has quit IRC |
| 23:09:14 | *** Sri_ has joined #openmrs |
| 23:14:26 | <Sri_> djazayeri: Hi. I am working on the HL7 message output and to create a table I added modifications to liquibase_update_to_latest file. I also added a mapping in hibernate.cfg.xml and created the corresponding file with the details. |
| 23:15:21 | <Sri_> djazayeri: Is this the right approach to create a table? I think I'm missing out on some step as the table is not yet created. |
| 23:26:58 | <djazayeri> Sri_: to create the table you just need the thing in liquibase-update-to-latest |
| 23:27:26 | <djazayeri> to make it work you also need the domain object java class, the hbm.xml mapping file, and one line in hibernate.cfg.xml |
| 23:27:53 | <Sri_> djazayeri: We did that. but it doesnt create the table on build |
| 23:29:46 | <Sri_> djazayeri: We did create a hbm.xml file for the new table and also the mapping in hibernate.cfg.xml |
| 23:31:58 | <djazayeri> look in your liquibasechangelog table |
| 23:32:06 | <djazayeri> see if the changeset was actually run |
| 23:32:36 | <djazayeri> actually, did you restart the webapp, and get the update wizard? |
| 23:32:43 | <djazayeri> Sri_: that's how the liquibase updates get run |
| 23:32:49 | <djazayeri> (I have to run now, good luck) |
| 23:33:28 | <Sri_> djazayeri: Thank you. Will try |