Centricity Practice Solutions

Items related to the SQL server / Practice management version of the Centricity product.

MU Activity Log

Published on by tygh

ADD_MUACTIVITY_LOG() is another undocumented symbol that can come in handy. At Blackbird, we use this when we want to record that a handout has been printed. It would be natural to store it in an OBS, but because the CQR reporting system looks in the activity log to see whether or not to count these events, it is best to record them there.

The function signature looks like this:
{ADD_MUACTIVITY_LOG(<ID>,<user>,<handout name or path>)}

Example:
{ADD_MUACTIVITY_LOG(12,USER.LOGINNAME,"Handouts\BBS\Weight Reduction Diet")}

Below is a list of acceptable TypeIDs

Getting a List of All Users

Published on by tygh

The MEL function to get lists of users takes, as a parameter, a list of locations of care.  However, what if you are writing code where you want all the users and don’t know what locations are in the system where the code will be running?

The answer is that you can get the root location and pass that into the function.

{GET_USER_LIST(find('AllLocation', 'ABBREVNAME', 'LOCID', 0),"","Delimited",true)}

Note! the last parameter above is undocumented. It filters out the roles for each user in the result list.

HTML | MEL dll registration

Published on by tygh

Occasionally, installing CPS or EMR will result in a key ActiveX control not being correctly registered on the workstation. This generally manifests itself with the Blackbird Framework appearing to have no content in the HTML window.

Usually, this can be fixed with a one-time command line procedure.

Recipe to register DLL for Single User Training:

  1. First run cmd as administrator
    runcmd
  2. Then cd into the Centrcity client folder:
    clientfolder
  3. Identify the name of the DLL to be registered. The name should end with .if.dll
    CPS and EMR typically have different file names to be registered.
    findfile
  4. Register the control using regsvr32
    c:\windows\syswow64\regsvr32 ge.emr.cps.msg.if.dll
  5. reboot and try again.

asdf

Published on by tygh

In case you haven’t noticed, the CPS and EMR demo systems have pretty easy default passwords. Oddly, if an account gets locked or the password expires, there isn’t an easy way to get a password less than 6 characters into the user management system.

You don’t have to be able to decode the passwords in the DoctorFacility table to set the password of a user. The following statement will set hwinston’s password to ‘asdf’

update DoctorFacility set LoginAttempts = 0, password = 'ZjBlNGMyZjc2YzU4OTE2ZWMyNThmMjQ2ODUxYmVhMDkxZDE0ZDQyNDdhMmZjM2UxODY5NDQ2MWIxODE2ZTEzYg==' 
where LoginUser = 'hwinston'

Compatibility View and CPS

Published on by tygh

The Blackbird Content Framework works best when using the latest version of IE on your workstation.

Meanwhile, CPS requires version 9 or greater to run.  Unfortunately, the CPS application doesn’t seem to know that 11 is greater than 9.

As a result, you may see this message when starting CPS:

CPS-IE-VersionThe workaround, is to tell CPS that the version of IE it is using is older than IE 11. To do so, click on the gear icon in the IE address bar; select “Compatibility View settings”.

CompatibilitySettingsAfter opening the Compatibility View Settings Dialog, add localhost, or the host name or IP address of the server that you are using to launch CPS.

CompatibilitySites

Unfortunately, this must be done on a per-user basis. At any rate, after updating this setting, all should be well.