Change Allscripts ProEHR HMScan Path

Follow the steps below against correct EHR database in SQL Management Studio if you want to change the pointers yourself. select * from HPSITE.SCAN_DOCUMENTPAGEUpdate the Document Page from the old Server to the new Server: UPDATE HPSITE.SCAN_DOCUMENTPAGE SET FILELOCATION = REPLACE(FILELOCATION,'\OLDserver\Hmscan','\NEWserver\hmscan') Update the Scan Job from the old Server to the new Server: UPDATE HPSITE.SCAN_JOB SET DIRECTORY= REPLACE(DIRECTORY,'\OLDserver\Hmscan','\NEWserver\hmscan') Update Continue reading →

Allscripts Project

Last week I worked on one of my projects for Allscripts Vision accounting to add a few enhancements. The major enhancement was the ability to export a detailed report for all users to Excel and create a Pivot table with chart of users' logins over the report's timeline. You can read more on my project page for this project. Allscripts ProEHR 9.10.3 database table and column extended properties text:  ProEHR 9.10.3 - Table and Column Extended Properties Continue reading →