Update an Existing Table Control

The Table control is commonly used to for adding a list of contact numbers into a call flow.

This topic covers how to update a Table control.

Editing a Control

To open a control for editing, refer to the Edit a Routing Control topic.

Updating a Table Control

To update a Table control:

  1. Edit the Control Name and Control Description fields as needed.

NOTE:

The Control Code field can no longer be edited after initially adding the control.

  1. Enable or disable the Replicate table to external DB option by setting it to the ON or OFF position.

NOTE:

With the Replicate table to external DB option set to YES, the routing control table is created on an external database instead of the Humanify Portal database. This allows the table control to function quicker in some cases.

When enabled, a Manual Data Sync button displays for Routing Control Administrator users. Clicking this button will sync the table control data to the internal database.

  1. Create the table and add any data needed for the table control. Refer to the Creating a Table or Using Bulk Load to Create a Table sections below for assistance with creating a table.
  2. Click the Save button to save any changes made to the control or click the Cancel button to cancel the operation.

NOTE:

If canceling the operation, click the Continue button to confirm.

A success confirmation displays in the upper right corner upon successfully updating a control. The message disappears after a few seconds.

Creating a Table

This section shows how to create/edit a table and add data to it.

NOTE:

By default, the table consists of a single column named Key Column. This column is only a placeholder and can be renamed.

  1. Click the Edit Header button to add and update names for the table's column headers.

  1. Name, configure, and activate each column needed for the table by doing the following:
    1. Enter a name for each column under the Column Name column.
    2. Choose the type of data to be entered in each column by clicking the drop-menus under Column Data Type and select one of the following:
    • BOOLEAN – Allows for a Yes or No selection.
    • DATE – Allows for the selection of a date.
    • NUMERIC – Allows for the entry or selection of any number. (40 characters maximum.)
    • STRING – Allows for the entry of any character. (40 characters maximum.)
    1. Remove the check from the boxes under the Nullable? column for any fields that require data to be entered. Leave the box checked if the table can accept empty fields
    2. Choose which columns are active by placing a check in the boxes under the Active column. Remove or leave the box unchecked to deactivate a column.
    3. Click the Save button to save any changes made to the table or click the Cancel button to cancel the operation.

NOTE:

Each table control can have a maximum of 10 columns.

NOTE:

If canceling the operation, click the Continue button to confirm.

A success confirmation displays in the upper right corner upon successfully configuring the header. The message disappears after a few seconds.

  1. Delete an existing row by clicking the Delete Row icon.

  1. Edit an existing row by clicking the Edit Row icon.

  1. Click the Add Row button to begin entering table data in a new row.

  1. Enter or update the data for this row, and then click the Save button to continue or click the Cancel button to cancel the operation.

NOTE:

If canceling the operation, click the Continue button to confirm.

A success confirmation displays in the upper right corner upon successfully saving the row. The message disappears after a few seconds.

  1. Click the Save button to save any changes made to the control or click the Cancel button to cancel the operation.

NOTE:

If canceling the operation, click the Continue button to confirm.

A success confirmation displays in the upper right corner upon successfully creating a new control. The message disappears after a few seconds.

Using Bulk Load to Create a Table

This section shows how to create or edit a table using the Bulk Load feature.

  1. Click the Bulk Load button.

  1. Click the Download empty template button to download an empty Comma Separated Values (CSV) file for creating a new table, or click the Download template with data button to download a copy of the current table for editing.

  1. Choose a location to save the template and click the Save button.
NOTE:
This step may vary depending on the web browser used, as each have a different download interface. Some web browsers may save the file directly to the default Downloads folder, or the most recently selected download location.

  1. Locate and open the downloaded template file. It will open in Microsoft Excel or any other similar spreadsheet editing software.
  2. Enter or update the names for each column in the top row. These are the Column Headers for the table.
  3. Enter or update the data for each column in the rows below the headers. This is called the Row Data.
  4. When finished, save the CSV document.

  1. Click the Upload file button.

  1. Locate and select the CSV file, and then click the Open button.

  1. Prepare the file for processing by doing the following:
  1. Click the Delete button to remove the file, if the wrong file was selected.
  2. Select the best action for processing the file.

NOTE:

Each action changes how the file is processed:

  • Append - Adds new records, from the template, to the existing table. It skips any records where the key field already exists. Skipped records show up when performing an audit.
  • Update - Updates records in the current table for every record where the key field exists. Skipped records show up when performing an audit.
  • Replace - Replaces all records in the current table where the key field already exists. Skipped records show up when performing an audit.
  1. Click the Process button to begin processing the template file, or click the Cancel button to cancel the operation.

NOTE:

If canceling the operation, click the Continue button to confirm.

  1. Click the OK button to confirm the selected action for processing. Click the Cancel button to cancel the operation.

A progress bar displays as the template file processes.

  1. When the has finished processing, two additional options are provided:
    1. Original File – Click this to download the original template file before changes were made.
    2. Log file – Click this to download a log of the changes that were processed.
    3. Click the Close button to close the Bulk load dialog.

  1. Click the Save button to save any changes made to the control or click the Cancel button to cancel the operation.

NOTE:

If canceling the operation, click the Continue button to confirm.

A success confirmation displays in the upper right corner upon successfully updating a control. The message disappears after a few seconds.

See Also