Overview

This page provides guidance for deploying a configured or customized Case Management Studio application from a source environment such as development to a target environment. If Case Management Studio is not configured or customized, follow the standard Case Management Studio installation steps.

These guidelines include procedures for deploying your Case Management Studio application. The guidelines may vary based on your Case Management Studio configurations, customizations, or your organization's deployment practices.

There are 7 steps in the deployment process.

1. Prepare the platform
2. Set up service accounts and API keys
3. Run database scripts
4. Prepare Appian applications
5. Deploy Appian applications
6. Adjust environment-specific IDs
7. Complete public portal configuration

Step 1: Prepare the target environment and verify plugins

• Make sure the target environment meets the minimum platform version specified in the Case Management Studio installation guide and any deployed modules. If it doesn't, contact Appian Support to upgrade the platform.
• Ensure the target environment has the necessary plugins, as specified in the Case Management Studio installation guide and any modules you are deploying.
• Confirm with Appian Support that your platform version is correctly configured for your needs.

Step 2: Set up service accounts and API keys

Deploying the public portal for the first time

1. Set up the service account and API Key in the target environment by creating the API Key and a new service account in the Admin Console.
   • Use the username: portalServiceAccount.
   • Add the portalServiceAccount service account to the Service Accounts group.
2. Save the API Key and copy its value for use later in the import customization file (ICF) for both the CMGT Portal connected system and CMGT CB Portal connected system. You'll modify the ICF later when you deploy your application.

Deploying the Public Self-Registration module for the first time

1. Set up the service account and API Key in the target environment by creating the API Key and a new service account in the Admin Console.
   • Use the username: claimCase
   • Add the claimCase service account to the CMGT Service Accounts and Service Accounts groups.
2. Save the API Key and copy the value for use later in the import customization file (ICF) for the LA connected system. You'll modify the ICF later when you deploy your application.

Step 3: Run database scripts

Create a combined SQL script with the following components and execute it in the target environment to set up and migrate the database with the required data and structure.

• Initial Database Scripts: Use these scripts only for first-time deployments. They are included with the base application and module applications in the original download package.
• Customization SQL Scripts: Include these scripts in every deployment. Ensure they are re-runnable so you can resolve any issues that might arise after deployment.
• Studio configuration SQL Scripts: Use these scripts to migrate Studio configurations (e.g., case types, tasks, task blocks, workflow, studio custom fields). You can export the structure and data of these scripts from phpMyAdmin. Make sure to include the necessary key constraints and ensure these scripts are re-runnable in case you need to re-deploy the package to resolve issues.

Script types and names

Replace {Specific_Category_Tables} and {Specific_Case_Tables} with the appropriate table names relevant to your configuration.

Script Type	Scripts
INSERT table	CMGT_WFL_CFG_CASE_TYPE_WORKFLOW_TASK CMGT_WFL_CFG_CASE_TYPE_WORKFLOW_TASK_BRANCH CMGT_WFL_CFG_REFERENCE_MILESTONE CMGT_WFL_CFG_REFERENCE_TASK CMGT_WFL_CFG_TASK_BLOCK CMGT_WFL_CFG_TASK_BLOCK_TASK CMGT_WFL_CFG_TASK_RESPONSE_OPTION CMGT_CFG_CASE_TYPE
CREATE table	CMGT_CATEGORY__{Specific_Category_Tables} CMGT_CFG_CATEGORY__{Specific_Category_Tables} CMGT_CFG_CB_ALL_CASES_DATA_{Specific_Case_Tables}
ALTER table	CMGT_CB_CASE_LEVEL_DATA
INSERT scripts for tables	CMGT_CB_CASE_LEVEL_DATA CMGT_CATEGORY_{Specific_Category_Tables} CMGT_CFG_CATEGORY_{Specific_Category_Tables} CMGT_CFG_CB_ALL_CASES_DATA_{Specific_Category_Tables}

Step 4: Prepare Appian applications

• Ensure the applications include all configurations from the source environment that you want to deploy to the target environment.
• Add any case category images to the CMGT Studio Generated Objects application before deployment. These images won't appear in the missing precedents check because they are only referenced by an ID entry in the database.
• Ensure the Case Management Custom Objects application contains the branding files and corresponding images uploaded via the Solutions Hub.

Step 5: Deploy Appian applications

Deploy the following Appian applications to your target environment:

• CMGT Case Management Studio Base
• CMGT Studio Generated Objects (CMGT)
• CMGT Studio Module (CMGT_WFL)
• CMGT Portal Module (CMGT)
• Case Management Custom Objects
• Solutions Hub (Only required for first time deployment)
• Any other modules you intend to deploy

You can deploy applications manually or use compare and deploy.

Manually deploy an application

To manually deploy an application:

1. Manually export the application as a combined zip file.
2. Download the zip file, as well as the provided ICF and API keys.
3. Modify the ICF to include the correct base URLs and API keys that you saved from the previous step.
4. Check for errors and missing precedents, then import the combined zip file and the modified ICF into the target environment.

Deploy an application using compare and deploy

To deploy using compare and deploy:

1. (Only for first-time application deployments) Create a deployment package for each application without any objects and deploy each application using compare and deploy.

   Note:  This step is required because the combined application approach does not deploy individual applications (such as CMGT Case Management Studio Base). Once all applications are in the target environment, proceed with the next steps to create and deploy the combined application that contains all application objects.

2. Create a new application with the following properties:
   
   • Name: CMGT Combined Application
   • Description: Contains all of the objects for CMGT in one application for ease of deployment with Compare & Deploy. Base application + modules + studio generated objects
   • Prefix: Leave blank. This application is only for deployment, not for development; so, no prefix is needed.
   • Generate groups and folders to secure and organize objects: Uncheck this checkbox.

3. Configure security for the application:

   Group	Permission Level
   Administrators	Administrator
   Users	Viewer

4. Click View Packages and select CMGT Combined Application.
   You'll notice the contents view for the package is empty right now.
5. Click ADD EXISTING > APPLICATION CONTENTS.
   The Add Application Contents window displays.
6. Add the following applications:
   • CMGT Case Management Studio Base
   • CMGT Studio Module (CMGT_WFL)
   • CMGT Studio Generated Objects (CMGT)
   • Any modules you plan to deploy
   • Case Management Custom Objects
   • Solutions Hub (Only required for first time deployment)
7. Identify and add any missing precedents.
8. Click COMPARE AND DEPLOY.
9. Select your target environment then click NEXT.
10. Click DATABASE SCRIPTS and upload all of the following required database scripts in the following order:
    • 01.CaseManagementStudioBasevn.n.n
    • 01.StudioModulevn.n.n
    • 01.PortalModulevn.n.n (any module scripts)
    • Any scripts for table alterations or new tables
    • Any scripts for transferring Studio configuration data
11. In the IMPORT CUSTOMIZATION FILE pane, upload a combined import configuration file to update any configurations across the applications and modules being deployed. Include the base URLs and the API keys as configurations for the Portal Connected System, CB Portal Connected System, and the LA Connected System (if applicable).

Now your package is ready to deploy!

Step 6. Adjust environment-specific IDs

The following Case Management Studio configuration tables contain environment-specific values that can vary, such as group, folder, and document IDs. Update these values post-deployment to match the target environment. After updating the database tables, re-sync the corresponding record types to reflect the changes.

Table	Column(s)	Appian object ID it represents
CMGT_WFL_CFG_CASE_TYPE_WORKFLOW_TASK	DEFAULT_GROUP_ASSIGNEE	Group ID
CMGT_WFL_CFG_REFERENCE_TASK	DEFAULT_GROUP_ASSIGNEE	Group ID
CMGT_WFL_CFG_TASK_BLOCK_TASK	DEFAULT_GROUP_ASSIGNEE	Group ID
CMGT_CFG_CASE_TYPE	APPIAN_IMAGE_ID	Document ID
CMGT_CFG_CASE_TYPE	DEFAULT_GROUP_ASSIGNEE	Group ID

Step 7. Complete public portal configuration

In this step, you'll finalize the setup of the public portal.

Add the service account

1. Open the Object View in the target environment.
2. Find and open the CMGT Service Accounts group.
3. Add the portalServiceAccount service account to the CMGT Service Accounts group.

Adjust portal URL

If you are deploying the Case Management Studio portal to an environment that doesn't use UUIDs for portal URLs:

1. Open the CMGT_UTIL_GetPortalURL expression rule in the target environment.
2. Comment out the cons!CMGT_PORTAL_TXT_URL_UUID line.
3. Click SAVE.
4. Republish the Case Management Studio portal.