Originally we used Microsoft Access. We are now testing a php script that front office accesses from the Reports menu to upload the Excel file. After showing the preview of the updates, they update the daily prescriptions in EMR filled by everyone in the office including the responses to the pharmacy originated prescriptions….
1. As I stated earlier, I am sure that this is not a good approach because of the manual downloading + uploading the Excel reports. But we can always share our code may be by early next week after bit of cleanup.
A caveat here - we use the PHPExcel libraries under GNU license. Hope that is not an issue.
2. We did not need anything special from Allscripts since we use a standard report. In the past when we had contacted them for other alternatives, understandably they kept pushing their Allscripts EHR. But if there is anything we can do towards OEMR certification, we would be glad to contribute.
Pushed 4 files to git. If you are already using the free eprescribing solution from Allscripts, this batch interface will import the prescriptions in EMR. Since the exports are in Excel format, you need to install phpExcel libraries for the interface to work.
There doesn’t look like there has been much activity here. Is this still a viable solution? The doctor I work for has a Allscripts ePrescribe (the free version) account. I was wondering if these files that were pushed to get are including with oemr software and if so is it possible to start using it. Thanks in advance for any info John
biller2:
This is not a standard tool. We use it on an interim basis until fully certified openemr is released and stable. In the meanwhile we imported about 2.5 years of prescriptions and medications history in openemr using this. And now the data is updated twice daily without manual data entry errors.
If you decide to give it a try, we can post current revisions.
mdsupport, thank you very much for the quick response. I will wait until the fully certified openemr is released and stable. I was just checking to see if this option with Allscripts ePrescribe was still available. Thanks again for your response and your work on this part. John
I seem to always end up reviving dormant threads. What’s the official status report for ePrescribing with OpenEMR?
Will it be included whenever the 4.1 stable release comes out, or has it been pushed back farther?
What can we do to help with beta testing out in the real world?
Sorry if I am overly confused (being new to OpenEMR). Does this extract from Tony’s status:
MI2/ZHH collaboration - NewCrop - (172 hrs)
Go-live testing happened 7/5/2011, passed with NewCrop, waiting on Sure Scripts to scheduled next phase which is a formality. -Tony - www.mi-squared.com 01:56, 12 July 2011 (UTC)
mean that the NewCrop e-Prescribing module has been certified for effective use?
Not yet. Testing is this Thursday (28th) for the rest of the Meaningful Use modules. If we are lucky we will get ALL the testing done on Thursday night, if not it will be continued until it is. In any case the official OEMR 501c3 version of OpenEMR 4.1 will be a fully certified EHR in the next couple of weeks. Then we have to officially release it….
-Tony
OK, grabbed a fresh copy of 4.1-dev from Github, I see the little box for E-Prescription? in the Add RX interface, but where does that come from? Shouldn’t there be somewhere in the user settings & Globals to configure your connection to your e-prescribing service?
Pardon the stupid question, didn’t see anything in the Wiki or docs about it.
When we are done with the certification(s) we will post information about how to subscribe to eRX through Medical Information Integration (mi-squared) or Z&H Healthcare Services. The basic configuration area in in admin->globals->connectors … before it can be used you will need:
NewCrop eRx Partner Name (Production)
NewCrop eRx Name (Production)
NewCrop eRx Password (Production)
Thanks Tony. I didn’t see any of those options in globals. I guess maybe the code in Github is a little behind what you guys were using for certification. I’ll wait a while & sync from Github again, see if it’s there.