# Importing RXNORM **URL:** \ **Category:** Support\ **Created:** [February 11, 2023, 6:55am UTC](https://community.open-emr.org/t/importing-rxnorm/19973 "2023-02-11T06:55:37Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 11, 2023, 6:55am UTC](https://community.open-emr.org/t/importing-rxnorm/19973/1 "2023-02-11T06:55:37Z")
**Situation** I downloaded RxNorm latest edition, it has many folders and I do not know which one to zip and put under the Contrib/RxNorm folder The downloaded RxNorm has: Readme scripts rrf Prescribe …folders under script folder there is: oracle Mysql Under rrf: 9 files under prescribe: RRF Script…folders I zipped the original folder it was not accepted under loading external data From loading internal data I did not know which one to browse to ? ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [February 11, 2023, 2:25pm UTC](https://community.open-emr.org/t/importing-rxnorm/19973/2 "2023-02-11T14:25:42Z")
[https://www.open-emr.org/wiki/index.php/Import\_RxNorm\_and\_SNOMED\_Tables#OpenEMR\_4.2.0\_onwards](https://www.open-emr.org/wiki/index.php/Import_RxNorm_and_SNOMED_Tables#OpenEMR_4.2.0_onwards) ---
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 11, 2023, 5:31pm UTC](https://community.open-emr.org/t/importing-rxnorm/19973/3 "2023-02-11T17:31:46Z")
I did and I got this error, I attached a screenshot. ![Screen Shot 2023-02-11 at 12.31.07 PM](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/3X/e/a/ea87dc17b97516d8d2380f878f4815c412055f76.png) ---
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 11, 2023, 6:12pm UTC](https://community.open-emr.org/t/importing-rxnorm/19973/4 "2023-02-11T18:12:49Z")
mysql\> SET GLOBAL local\_infile = ‘ON’;………did it. I do not know why it was OFF although in my /etc/php/7.2/apache2/php.ini ….I set mysqli.allow\_local\_infile = On and I removed “;” at the beginning of the line to be executable? when I checked: mysql\> SHOW GLOBAL VARIABLES LIKE ‘local\_infile’; It was off. turned it on with:mysql\> SET GLOBAL local\_infile = ‘ON’; and now RxNorm is installing I will let it run and see if it installs properly, it is a large file. ---
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 11, 2023, 6:58pm UTC](https://community.open-emr.org/t/importing-rxnorm/19973/5 "2023-02-11T18:58:00Z")
Still spinning , no error….something is wrong. will give it another half hour or so. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [February 11, 2023, 7:40pm UTC](https://community.open-emr.org/t/importing-rxnorm/19973/6 "2023-02-11T19:40:15Z")
> [@RxNorm on web server](https://community.open-emr.org/t/rxnorm-on-web-server/18416/3): > > Thank you. For those who encounter same problem, available documentation not up to date so here’s what you should do: change post max and upload max to 80M (otherwise, you might get the “loading successful, 0 new, 0 updates” message after uploading RXnorm in open emr, admin\forms\lists manage lists drop down field, choose code types change RXCUI to active (otherwise, you’ll get “no active code set” message when trying to upload RXnorm) download monthly zip as instructed admin\coding\native dat… ---
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 11, 2023, 8:26pm UTC](https://community.open-emr.org/t/importing-rxnorm/19973/7 "2023-02-11T20:26:47Z")
Thank you , I got: LOAD SUCCESSFUL. Codes inserted: 144692, replaced: 0 ---
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 11, 2023, 8:32pm UTC](https://community.open-emr.org/t/importing-rxnorm/19973/8 "2023-02-11T20:32:21Z")
I know RxNorm is a full suite of drug names drug drug interaction and not only codes? How to check functionality if the installation is correct? ---
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 11, 2023, 9:28pm UTC](https://community.open-emr.org/t/importing-rxnorm/19973/9 "2023-02-11T21:28:27Z")
When I am using when prescribing RxCUI I get data of meds names: ![Screen Shot 2023-02-11 at 4.25.13 PM](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/3X/7/2/728f86ca58562909a830e9d906b638d3f4049e6e.png) However when I choose RxNorm I get nothing: ![Screen Shot 2023-02-11 at 4.25.52 PM](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/3X/8/a/8a057465e07bf2e18f4b76ba284127030d6a2584.png) What does that mean? is RxNorm installed and RxCUI is handling the database of meds or it is not installed? ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [February 12, 2023, 12:03am UTC](https://community.open-emr.org/t/importing-rxnorm/19973/10 "2023-02-12T00:03:28Z")
For the full rxnorm, now that you have local infile on, try loading from external data loads again but it may take 10 to 20 minutes and having the full rxnorm searchable from prescriptions might not be working currently. Remember to turn off local infile for security once completed loading. ---
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 12, 2023, 3:42am UTC](https://community.open-emr.org/t/importing-rxnorm/19973/11 "2023-02-12T03:42:16Z")
Thank you, it has been spinning for an hour, I do not think anything was installed… 🤔 ---
**Author:** ![Mohammad](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@Mohammad](https://community.open-emr.org/u/Mohammad)\ **Post date:** [February 13, 2023, 1:43am UTC](https://community.open-emr.org/t/importing-rxnorm/19973/12 "2023-02-13T01:43:49Z")
after 3 hours it says staged data are same as copied data, I can see rxnorm version in the left box in external data , but still when clicking on RxNorm radio button in prescriptions does not pull anything? rxCUI does….what is the difference between those 2 options, and why still Rx norm does not pull list of meds when entered?