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.

1. select * from HPSITE.SCAN_DOCUMENTPAGE
2. Update the Document Page from the old Server to the new Server:

UPDATE HPSITE.SCAN_DOCUMENTPAGE

SET FILELOCATION = REPLACE(FILELOCATION,'\OLDserver\Hmscan','\NEWserver\hmscan')

3. Update the Scan Job from the old Server to the new Server:

UPDATE HPSITE.SCAN_JOB

SET DIRECTORY= REPLACE(DIRECTORY,'\OLDserver\Hmscan','\NEWserver\hmscan')

4. Update the Locations path for all locations in the Allscripts EHR Administration Module – Locations
   1. If moved just the HMScan folder, change the path for the HMScan ONLY in the:
      1. Temp Storage
      2. Mass Storage
      3. possibly Import Default
5. Verify paths are now correct:

select * from HPSITE.SCAN_DOCUMENTPAGE

select * from HPSITE.SCAN_JOB

6. Test by opening a patient, with an attached image. Go into Allscripts EHR and click on the ‘Pull a Chart’ icon (yellow).