Drug Table National Library of Medicine

juggernautsei wrote on Monday, September 19, 2016:

I need some input about the drug table.
Building out this Weno project and we have to develop a drug table for the program that is populated from a source that is not Weno. They pointed to the NLM.

I found a thread where Rod built a PEARL script some time ago. I am not sure if it was for prescription drugs or not. The link above goes to the daily updates that NLM puts out. Writing a script to download and import this daily using a cron job. The script will parse throught the zip file and grab the xml and import the data into the table.

My question is about the path. Is this the right source and will it be useful to the OpenEMR project?

Any suggestion?

The prescription interface is in need of revamping. I am open to suggestions. The first thing that was done was to increase the size of the modal. So that there will be room to add more stuff. The template layout should change.

Any input will be welcome.

mdsupport wrote on Tuesday, September 20, 2016:

Couple of thoughts :

  1. Daily refresh may be overkill since new drugs take weeks if not months to be available for general prescription after regulatory approval. They do get added to various databases during late clinical trials.
  2. Another option may be to embed the java applet or API (RESTful or SOAP) from nih.gov with local copy as a backup.

juggernautsei wrote on Tuesday, September 20, 2016:

Thanks for the tip. It saved me from two weeks of work ahead getting the other functions work.

After working with this API, it is not as generous as I was hoping it would be. I can find some drugs but not all the drugs that the doc prescribes.

Also, doc has gotten use to the drug suggest as he is typing. It would be really hard to take that away.

The other thing in revamping the interface should I stay with smarty or go a different route?

juggernautsei wrote on Wednesday, September 21, 2016:

In the spirit of sharing, found this tool https://rxterms.nlm.nih.gov/