Setting up a User Acceptance Test and Training (UAT) environment

Setting up a User Acceptance Test and Training (UAT) environment

The audience for this page is IT 

EAP Expert strongly recommends that all clients have a UAT(User Acceptance Testing) environment.  Use it to preview updates to the application and test without affecting your production (live) environment.

We offer secure HIPAA compliant hosting on Amazon Web Servers (AWS).  For hosted clients, please submit a ticket to our support site https://support.eapexpert.com to request your UAT environment.

If you are hosting EAP Expert onsite, a UAT environment is something your IT department will setup.

To set up a UAT environment this can be done one of two ways:

  1. On the same computers as your production environment. Not recommended. This has some risks, as you may use your UAT environment while you mean to use your production environment, and you utilize the same resources as your production environment.

  2. On a separate computer apart from your production environment. This is ideal, as it separates the two environments so they will not affect one another.

In both cases, your UAT will consist of a separate instance of the EAP Expert application, and a copy of your production database.

The Database

To create a UAT database, you will create a backup of the EAP Expert database that you are currently using for production. You will then take that backup and restore it to your SQL Server you want to run the UAT database. If this is the same database as your production database, you will need to give the database a new name.  You can also request a starter database from us.

After restoring the database, you must run the following SQL commands to disable external synchronizations that have been set up. If you do not do this you will run the risk that data intended for the production environment will instead be brought into your UAT database.

Update Clinical set PortalAccess = 0, MyFaxUserId = null Update OrganizationContact set PortalAccess = 0 Update ImportOptions SET ImportCallCenterCalls = 0, ImportLifeAdvantagesData = 0, ImportMobileData = 0, ImportOnlineIntakes = 0 Update SurveyOptions SET ImportOnlineSurveys = 0 Update SurveyOptions SET ImportWOS = 0 Update Organization SET ImportEligibilityFromFTP = 0


The Application


To setup a UAT on a computer separate from your production environment refer to Installation Guide

To create a UAT on the same computer as your production environment:

  1. Under C:\Program Files(x86)\EAP Expert Inc create a UATExpert folder

  2. Copy the EAP Expert Update v#.#.exe file from the Update Email into that directory

  3. Download and extract an unencrypted config file from http://eapexpertsoftware.com/Downloads/Updates/UAT/EAPExpert.Win.exe.zip

  4. Run the EAP Expert Update v#.#.exe and let it extract the files into the default location

  5. Follow the Step 2 instructions in the Update Guide to update the application.

*Please Note* - Ensure you are using a new copy of the config file mentioned above. This file will disable connections to external products such as PROVIDERFiles, Customer Portal, etc, and will prevent data from production systems being imported into the UAT database instead