Read about OpenEMR's Response to the COVID-19 Pandemic at https://www.open-emr.org/covid19/

Does RxNorm work?

Does RxNorm integration work?

In OpenEMR 5.0.2 (patch 3) on Debian I copied RxNorm_full_07062020.zip to contrib/rxnorm/ and installed

In the Apache log I see the following, don’t know if these are an issue or not:

PHP Warning: file_get_contents(/tmp/RXNORM/scripts/mysql/Table_scripts_mysql_rxn.sql): failed to open stream: No such file or directory in …/library/standard_tables_capture.inc on line 93, referer: …/interface/code_systems/dataloads_ajax.php

PHP Warning: file_get_contents(/tmp/RXNORM/scripts/mysql/Load_scripts_mysql_rxn_unix.sql): failed to open stream: No such file or directory in …/library/standard_tables_capture.inc on line 97, referer: …/interface/code_systems/dataloads_ajax.php

PHP Warning: file_get_contents(/tmp/RXNORM/scripts/mysql/Indexes_mysql_rxn.sql): failed to open stream: No such file or directory in …/public_html/library/standard_tables_capture.inc on line 100, referer: …/interface/code_systems/dataloads_ajax.php

It appears to install OK

In Administration > Lists > Code Types > RXCUI I made it active and enabled for Drug

No medications can be found when using:
Patient demographics > Edit Medications > Add Medications > Coding > RXCUI Medication > Search.

I see mention of RxNorm integration being worked on but not completed back in 2013 but anything could have happened in the intervening years so wanted to check:

Thanks

Thanks for the bug report @PeteBoyd, there’s something up with the handling of the zip archive and will fix it up.

hi @PeteBoyd, the fix will be in the next patch

Many thanks @stephenwaite

@stephenwaite rather than continue to wait for the next release of OpenEMR, is it possible to get this RxNorm fix sooner by deploying the changed files – is that just a case of downloading library/standard_tables_capture.inc from github and deploying that?

yes, the above link is for v5.0.2

Thanks @stephenwaite I deployed that file in OpenEMR 5.0.2 (patch 3) on Debian; cleared the entry in standardized_tables_track; did Administration > Other > External Data Loads > RxNorm > Install and appeared to install OK:

“Installed Release
Name: RXNORM
Revision: Standard
Release Date: 2020-07-06”

Administration > Lists > Code Types: RXCUI is automatically enabled for “Drug”

Administration > Lists > Code Types: RXCUI says “External: No” and there is no Rx to choose from in the drop-down list.

However I cannot find anything from RxNorm using:
Patient demographics > Edit Medications > Add Medications > Coding > RXCUI Medication > Search for: Salbutamol

I see nothing in the Apache error log.
Is there anything else I need to do or does this look like a continuation of the bug?
Thanks

hi @PeteBoyd, there’s prob another issue related to the script reading the now loaded table.

If I can be of help in troubleshooting this further then please let me know. We’re eager to get RxNorm integrated. Thanks

I tested this again but with OpenEMR 5.0.2 Patch 4 and got the same results as above.