Manage tables

Upload a new table

Upload an updated table

Download a table

Publish a table

Rename a table

Delete a table

Note

  • The Tables icon is only visible in the navigation pane after you open a workspace. You manage the tables for that workspace on the Tables page.
  • To change a table's contents, you must download it from the database as a text file, edit the text file, and then upload it to the database again. You then need to republish it.
  • You select these tables in the Table Name property of a Table or Table Lookup block.
  • When going to the Tables page from a snapshot tab, the Tables page is locked and the only available action is Download.
  1. Open the workspace that contains the tables. See Open a workspace.
  2. On the navigation pane, click Tables. The Tables for [workspace] list appears. For navigation information, see List view.
  3. To see the action buttons for a particular table, hover your mouse over that row.

The columns are:

  1. Name
  2. Source file
  3. Version — the version of the source file.
  4. Rows
  5. Last modified time — this is currently the UTC time at which the table was saved in the database.
  6. Last modified by
  7. Last publish time — this is currently the UTC time at which the table was published in the tenant’s IVR root path, configured in CCaaS Admin.

Upload a new table

Note

  • The table file you upload to the database can be an .xml file or a tab-delimited text file.
  • Do not give columns in your tables names with embedded blanks, for example, "Phone number". Column names must start with an alphabetic character. Subsequent characters in a column name must contain alpha/or numeric characters.
  • If you need to leave a table cell empty, enter a non-printing alphanumeric character, for example, a space, in the cell. Empty cells may cause the table to be corrupted.
  1. On the Tables page, click Add. The Upload Table dialog appears.

  1. Click Browse and select the text file to upload.
  2. Enter the table name.
  3. Click Upload.
  4. The message Table successfully uploaded appears. Click OK.

Upload an updated table

  1. In the Tables list, hover your mouse over the table to upload and click Upload.

  1. Click Browse and select the text file to upload.
  2. You cannot change the table name.
  3. Click Upload.
  4. The message Table successfully uploaded appears. Click OK.

Download a table

  1. In the Tables list, hover your mouse over the table to download and click Download. The Download Table [name] dialog appears.

  1. Select whether to download the file as a tab-delimited text file or an .xml file.
  2. Click Download. The text file appears in your Downloads folder.

Publish a table

Note

  • If an error message appears saying that the IVR root path cannot be found, or CCaaS Admin cannot be contacted, click Publish again. If there is still a problem, see the configuration information in Publish a workspace.
  • Publishing an individual table does not create a backup version of it. You must publish a whole workspace to create a backup version of its scripts, tables, and files. For more information, see Publish a workspace.
  1. In the Tables list, hover your mouse over the table to publish and click Publish. The Publish [name] Table dialog appears.

  1. Enter the Location to publish to. You can use the default workspace location or change the name to publish to a different workspace folder.
  2. Click Publish.
  3. The message Table successfully published appears. Click OK.

Rename a table

  1. In the Tables list, hover your mouse over the table to rename and click Rename. The Rename [name] ? dialog appears.

  1. Enter the new name.
  2. Click Rename.

Delete a table

  1. In the Tables list, select the check box in front of the table to delete.
  2. Click Delete.
  3. Confirm the deletion.