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 →

#powershell

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 ProEHR User Account Unlock

This article was posted more than 1 year ago. Please keep in mind that the information on this page may be outdated, insecure, or just plain wrong today.

A utility I wrote to show locked user accounts in the Allscripts Professional EHR database and allow the user to unlock selected accounts.

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 →