bb2013 wrote on Thursday, January 16, 2014:
Can anyone please elaborate on how we can get these codes into OpenEMR? We are using 4.1.2. I can find the codes on the FDA website. I checked and Rx Norm doesn’t have anything in its files to suggest that these codes are in there. I even looked at previous thread discussions and checked pharma tables. Please someone help! Thanks,
fsgl wrote on Thursday, January 16, 2014:
The NDC numbers are entered manually in the Dispensary Module.
Administration/Globals/Features, choose Inventory And Sell Drugs only.
Inventory (left navigation bar)/Management, click Add Drug and enter NDC.
.
bb2013 wrote on Friday, January 17, 2014:
Thanks fsgl !
fsgl wrote on Saturday, January 18, 2014:
Glad to help.
Harley Tuck’s article on the Dispensary Module, for more information.
fsgl wrote on Saturday, January 18, 2014:
NDC data set can be downloaded from here.
This will tell you how to add a code type.
This gives instructions how to import the data set with phpMyAdmin.
The end result should look like the set of CPT codes in Administration/Codes.
Alternatively the data set can be imported into the drugs table.
bb2013 wrote on Saturday, January 18, 2014:
FSGL any comments on which method is easier or may lead to less errors/bugs will loading? Thanks
fsgl wrote on Sunday, January 19, 2014:
It’s not a matter of complexity (both involve creating a .csv file from the data set and then import), but where you want the NDC to reside.
It would be more efficient to search in the Dispensary Module than in Codes, therefore I would suggest that you import into the drugs table instead of the codes table. If you are working on a production copy, it’s a good idea to backup first.
The 4.1.2 and 4.1.3 Demo’s won’t import. The 4.1.1 Demo works but phpMyAdmin is erratic. Another way to experiment is to have a test copy of OpenEMR.