Does RxNorm work?

Success!

As per what Stephen says above, there is a completely different method now in OpenEMR 5.0.2 Patch 4 of installing RxNorm. Now we use Administration > Other > Native Data Loads and not Administration > Other > External Data Loads; although the latter is still present.

Also, the instructions within OpenEMR now say to use the “Current Prescribable Content Monthly Release” where previously we used “RxNorm Full Monthly Release”.

The OpenEMR 5.0.2 Patch 4 release documentation only said “RxNorm import fixes”. Also note that the “Import RxNorm and SNOMED Tables” page at https://www.open-emr.org/wiki/index.php/Import_RxNorm_and_SNOMED_Tables still says to “Copy the zipped RxNorm database file into the ‘contrib/rxnorm’ directory … note you’ll need to get an account and that only the Full Monthly Releases currently work … In OpenEMR, go to Administration->Other->RxNorm in order to then install/upgrade the RxNorm database.” None of that now appears to be true.

On first installation using Administration > Other > Native Data Loads, I received this issue:
“POST Content-Length of 70740105 [70 MB] bytes exceeds the limit of 31457280 [30 MB] bytes in Unknown on line 0, referer: …/interface/super/load_codes.php”

I fixed this by increasing php.ini’s “post_max_size” from 30M to 80M.

I then used Administration > Other > Native Data Loads to upload again and got this so-called confirmation of success:
“LOAD SUCCESSFUL. Codes inserted: 0, replaced: 0”
However RxNorm still wasn’t available.

Administration > Other > External Data Loads still lists the prior installation of RxNorm:
“Installed Release
Name: RXNORM
Revision: Standard
Release Date: 2020-07-06”

I removed the record of that old installation using the following:
DELETE FROM standardized_tables_track WHERE name=“RXNORM”;

I installed RxNorm again using Administration > Other > Native Data Loads and got this confirmation of success:
“LOAD SUCCESSFUL. Codes inserted: 139890, replaced: 0”
Which looks more positive. And indeed RxNorm now appears to work fine.

Thank you

1 Like