Azure Table Storage Configuration

  1. Open Azure Storage explorer on your PC (Download from https://azure.microsoft.com/en-us/features/storage-explorer/) add your PROD account and subscription if required

  2. Open the storage account associated with TCA

  3. Add/Edit rows individualy, or import the default values into table storage

Agents Table

Default Values can be downloaded from here: Agents.typed.csv

Agents Table

Add Entity for each agent that will install Teams Chat Assist. When a user asks a question, all signed in agents in this list (the list is filtered according inst) will receive a Teams message; which an agent can respond to in order to answer the users question.

Note: The agent list is filtered by your instance (App Registration Application ID). Meaning only agents using the specified instance will receive the messages.

Note: You can get an agents AadObjectId by visiting the Azure Portal. Select Azure Active Directory. In the menu on the left, under Manage, select Users. You will be presented with a list of users, find and select the required agent from the list (use the search box is necessary). Under the Identity header, the value in the Object ID field is the AadObjectId.

InstanceConfiguration Table 

Default Values can be downloaded from here: InstanceConfigurations.typed.csv

Instance Configuration Table

NewQuestionEmailTemplate sample:

@Model.InitialQuestion = Initial question asked

<!DOCTYPE html>
<html lang="en">
  <head>
    <style></style>
  </head>
  <body>
    <p>A new Teams Chat Assist message has been posted.</p>
    <p>Question: @Model.InitialQuestion</p>
  </body>
</html>

NewQuestionEmail validation/rules:

If ‘SendEmailOnNewQuestion’ is true and the other email fields are empty or incorrect, the bot will error. This error will not be displayed to the user, but can be viewed in the logs.

Due to limitations of the email client, when ‘SendEmailOnNewQuestion’ is true, ‘NewQuestionEmailRecipients’ must contain at least one email address. The same email address must not appear in more than one of the three recipient fields (NewQuestionEmailRecipients, NewQuestionEmailCcRecipients’ NewQuestionEmailBccRecipients)

WorkingHoursConfig sample:

{
   "Configuration":[
      {
         "Default":true,
         "Name":"Service Desk",
         "WorkingDays":[
            {
               "Day":"Monday",
               "StartHours":"09:00",
               "EndHours":"17:00"
            },
            {
               "Day":"Tuesday",
               "StartHours":"09:00",
               "EndHours":"17:00"
            },
            {
               "Day":"Wednesday",
               "StartHours":"09:00",
               "EndHours":"17:00"
            },
            {
               "Day":"Thursday",
               "StartHours":"09:00",
               "EndHours":"17:35"
            },
            {
               "Day":"Friday",
               "StartHours":"09:00",
               "EndHours":"17:00"
            }
         ],
         "Holiday":[
            {
               "Name":"Christmas Day",
               "Date":"2020-12-25"
            },
            {
               "Name":"New Year's Day",
               "Date":"2020-01-01"
            }
         ]
      }
   ]
}

WorkingHoursConfig validation/rules:

Below are the validations rules that the service abides by for working hours – logs will output if these requirements are not met.

MessageConfigurations Table

Default Values can be downloaded from here: MessageConfigurations.typed.csv

Message Configuration Table

Pattern matching:

The following messages support pattern matching:

Any Message ID starting with:

The following variables are available to be used in MessageText

Note: If the value fails to load for whatever reason, TCA would output an error message in the format of “ERR_MessageId”. For example if the value for “Card_AgentFound_Message_Start” failed to read/write, this would display in the respective area:

Message Configuration Error

QuickReplyButtons Table

Default Values can be downloaded from here: QuickReplyButtons.typed.csv

Quick Reply Buttons Table

Add Entity for each predefined reply button to be displayed in the Agent View. The predefined reply buttons are highlighted in the screenshot below.

Quick Reply Buttons UI

Backup and Restore

  1. Optionally you may want maintain a backup of your table storage settings