tmccormi wrote on Friday, June 24, 2011:
Chris,
regarding:Code review tracker ID: 3316006 Patches for inclusion of RxNorm and SNOMED Codes.
I just tried to test your patches (added 6/21) and the still don’t work. Please post your patch on a publicly accessible github fork of openemr so that it can be reviewed by the team. And please test them on a clean branch of openemr 4.1-dev before submitting them.
Thanks
Tony
tmccormi wrote on Thursday, June 30, 2011:
Chris … any updates on this?
-Tony
bradymiller wrote on Saturday, July 02, 2011:
Tony (and everybody else),
Was able to pull out the RXNORM code from Phyauras original github branch (was a pain). I’ve fixed up most the code, but I need the rxnorm download for further testing/implementation. I’ve requested access to rxnorm downloads today, but takes at least 3 business days to get it. Do you (or anybody else) happen to have a rxnorm download ( http://www.nlm.nih.gov/research/umls/rxnorm/docs/rxnormfiles.html ).
Here’s the github branch that the rxnorm work is on:
http://github.com/bradymiller/openemr/commits/rxnorm_1
-brady
yehster wrote on Saturday, July 02, 2011:
Brady,
Sending you a private message to help you get rxnorm files quicker.
bradymiller wrote on Wednesday, July 06, 2011:
hey,
Here’s interim work on RXNORM codes: http://github.com/bradymiller/openemr/commits/rxnorm_2
(note if follow instructions within the commit comments can get the rxnorm tables/data loaded into Openemr)
Still some path issues to clean up, a windows issue, and then need to figure out how to integrate into OpenEMR.
-brady
bradymiller wrote on Friday, July 08, 2011:
Hi,
Posted review request for code that imports RxNorm and SNOMED tables here:
http://sourceforge.net/projects/openemr/forums/forum/202506/topic/4599543
-brady
bradymiller wrote on Tuesday, July 12, 2011:
Hi,
Just committed the code to robustly import rxnorm/snomed data. Now awaiting code that begins to incorporate the rxnorm/snomed data into OpenEMR.
Note that integrating rxnorm is high priority since this is required for certification; Phyaura, can your group give an approximate timeframe on rxnorm code integration?
thanks,
-brady
phyaura-clucena wrote on Tuesday, July 12, 2011:
Brady,
I will get a patch ready for you as soon as one is provided. Let me check with the developers on it and I will get back to you.
-Chris
penguin8r wrote on Monday, August 29, 2011:
Has anybody else tested this one recently?
The SNOMED import ran perfectly as advertised.
The RxNorm import reported success, but doesn’t seem to have actually worked, since none of the tables (RXNCONSO, RXNREL, RXNSAB, RXNSAT) seem to have showed up in the database.
I guess it’s not a big deal for now since there’s no code in place yet to reference those tables?
Just curious…
TIA
bradymiller wrote on Tuesday, August 30, 2011:
Hi,
This was working fine. Suspect it has to do with the recent windows path fix:
http://github.com/openemr/openemr/commit/f47e3907da05de77937822ff5d5239a061be33b0
-brady
bradymiller wrote on Tuesday, August 30, 2011:
Placed this bug back in list of bugs to be fixed before release:
http://www.oemr.org/wiki/QA/Release_Process#Bugs_Pending
penguin8r wrote on Tuesday, August 30, 2011:
Brady,
FYI, I renamed the RxNorm downloaded zip file to fool the importer into thinking it was a newer version, & ran the import routine again. It took awhile, but eventually it finished & actually pulled in the data this time. Same success message when the process was done as last time, but now there’s tables in the database to prove it. Maybe not necessarily a bug? The only concern would be that it reportedly worked both times, but no data the first time around. I will try to do another test this week & see if there are any irregularities. Could be variance in MySQL versions that causes problems too, might not have anything to do with OpenEMR code. Have to wait & see if this kind of glitch happens to anyone else when importing.
Thanks!