Drug Look UP Alternatives

OpenEMR Development
1

mike-h30 wrote on Wednesday, February 06, 2008:

It seems that every time the medications web site changes, it causes an issue with the "drug look up" button.  Our old system ( an Access DB) had a medications table with about 23,000 records and searching capability ( As you typed the letters of the medication, those that matched would display in the list box). All of the scripts thus far written by our physician came out of this table. Would it be better to import this data and keep it in the OpenEMR db rather than relying on the medications website stability?

By the way, what are others doing now for drug look up since the link is broken?  I am in QA testing this week with OpenEMR in our office and hope to go live Monday.  I have not sat down with our physician to show him how to write prescriptions in OpenEMR.  I am pretty sure he will still like our previous system’s internal look up feature.  However, OpenEMR’s functionality is superior by far!

-Mike

2

blankev wrote on Monday, July 21, 2008:

I have no solution whatsoever, but I feel the urge to respond.

Developers, is it an option to have the possibility of finding medications with a LOOK-UP option in (1) personal patient record (what should be the fastest, as far as I understand OpenEMR medications now works with cookies)), than in a (2) computer/server like database (derived from personal preferences and frequently used medications of all patients could use the Drug database) and than if needed (3) in a web based database (or a compilation of several web databases?

All with their own button so you could to choose to take the slowest or the fastest or an increment way to find relevant medication. With an If…, ELSE IF… ELSE statement could give reasonable quick results, while every user can fill their own database at will.

(If optional preference could be skipped of marked in Global.PHP or Config.PHP files could lead to same results as we now have with the different options with  Athletic clinic, weight loss clinic etc.)

i.e. fill the computer database with in Internet available list of medications or do it the slow way with the used medications of all patients (Or mix this database with personal preferences).

I know what HTML together with PHP can accomplish it, but I am not professional enough to solve this problem in a reasonable time span without any serious software support.

When this problem will be solved, we might also think of a comparisons list with interactions an contraindications.

As the good reader might have understood, my favorite choice is to have the medication list available at hand, without the need to make an Internet connection, due to our slow Internet Service providers on our Island setting.

I will start working on a solution and as soon as I have some results I will trow the result in the group for evaluation.

Pimm Blankevoort MD

3

blankev wrote on Monday, July 21, 2008:

Sorry I must correct! but the medications ara now in PRESCRIPTION table… not as coockies.

Pimm

4

sunsetsystems wrote on Monday, July 21, 2008:

There are certainly many possible approaches, and any contributions will be very welcome.

Rod
www.sunsetsystems.com