Category Archives: Allscripts

Allscripts Vision User Reporting

A quick Powershell script I hacked together that will enumerate all Active Directory users, and build an XML file for an application I wrote that generates user reports for a specific application. The output file format is similar to: <quickreports> <report name=Organizational Unit> <database name=v001/> <usrlogin name=jdoe01/> </report> <quickreports> $ErrorActionPreference= 'silentlycontinue' $arr=@{} foreach ($usr in Get-ADUser -Filter * | select Continue reading →

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 →

Misys Vision Encounter Templates

Misys Vision Encounter (Superbill) Templates SQL Query: select tmpname,tmpdesc from formtmphdr where allow_edit = 'N' and tmptype = 7 tmpname tmpdesc CODESCAN1S MICROSCAN ENCOUNTER 1 (8 LPI - STYLE 2) CODESCAN3S MICROSCAN ENCOUNTER 3 (8 LPI - STYLE 2) ENC09 MEDIC ENCOUNTER FORM #9 ENC09LASER MEDIC #9 LASER ENCOUNT (60 LPP STYLE 3) ENC10 MEDIC ENCOUNTER FORM #10 ENC10LABEL MEDIC LABEL ENCOUNTER FORM #10 (STYLE 3) ENC10LASER MEDIC #10 LASER ENCOUNT (60 Continue reading →