I have uploaded the drug information to our database. The drugs we want to use have been made active and the Lot information has been completed and all the information shows up correctly on the Inventory Management page.
When I search for a drug on the prescription pop-up it finds drug names that are not in the data we uploaded.
Where is it finding that information?
A specific example: on the prescription pop-up I search for Acetaminophen. What the search returns are Tylenol (a couple of variants) and some other drugs. None of which are in our data set. In order to do some trouble shooting I completely cleared all the drug related tables and uploaded only the acetaminophen data set. The search pop-up in the prescription pop-up only finds Tylenol and some other drugs. None of these drugs is listed in our data set.
How do I get the search function to look at our in-house inventory for available drugs?
Thanks for your help.
richard
By the way, in the Prescription pop-up in the field labeled in-house the drop down only shows “or select from inventory”. The drop-down has no other selections.
How do I get the drop-down to see our current inventory?
Thanks for your help.
richard
I sure would appreciate some help on this one. I’m kind of stuck at this point. If one of you with more experience could at least point me in the right direction I sure would appreciate it.
Thanks
richard
It appears that you have a cache of drugs earlier uploaded in your system that has not been deleted. You may want to restart Apache and if you have installed memcache or other services, you may want to restart them. In addition, you should use phpmyAdmin (Administrator > Others > Database>) to check the list of drugs in your drug table.
In the prescription pop-up, the top drug search field searches the drug table whilst the lower field for “in-house” searches the drug inventory table for drugs that you have in stock. If it is not behaving this way, you may need to re-install the application (but backup your data before doing this).
By the way, how did you upload the drug information? For each drug in your inventory, re-open the drug entry form by clicking on the name of the drug and make sure that all the relevant fields are filled - form, size, unit, route and at least one template also check “active”.
One other thing to help clarify is that the (click here to search) popup/item searches a third party site. As Kayode points out, the main text field to the left of this will search through the drug table in realtime (it will present options from what you type there).
In addition to what Brady wrote, you need to click on the arrow to the right of the field “select from inventory” to see the list of drugs in your inventory in alphabetic order. Unfortunately, there is no way of searching this list at present. So if you have a long list of drugs in your inventory, this could be a tedious task though typing an alphabet takes you to the list of drugs that start with that alphabet. There is need for “search from inventory” mechanism in the near future to complement what exists now.
Hi guys. Thanks for your responses, this is helpful.
Kayode, I uploaded the drug information using the import button at the top of the drug table in phpAdmin. The import was completed with no errors. In your response you indicated I should select “at least one template”. Could you explain that a bit further? All the other items are filled in for each drug.
Brady, what third party site is it searching? Is there a way to control where it searches?
Is there anything I can do to help get a “Search from Inventory” mechanism in place?
When you open any of the drugs in the drug entry pop-up, the lower section of the page has a section below the word Template. This is useful for prescribing a drug with fixed/regular regime - eg amoxicilin 250mg tid x 5 days. So you give the template a name in the first field e.g. Amoxil-R and complete the rest of the field in that row - 1 capsule by mouth t.id. - total quantity 15, no refill. When you go to prescribe a drug with the prescription pop-up, on the drop down “select from inventory” Amoxi-R, would be one of the options. Once you select it, the appropriate fields would be populated automatically . This saves the doctor the time to fill out the form for a regime he/she uses regularly.
Hope this explanation is useful. As is well known, documentation is a major problem with open source applications and a forum like this allows for sharing of experience.