Cisco Cisco Unified Contact Center Enterprise 9.0(1)

•

All column names must be on a single line and are separated by Tab characters.

The following rules apply to the data in the files:

–

One row of table data per line.

–

Column values must be in the same order in all rows. If columns are specified in the header,
the columns in the data rows must be in the same order.

–

Column values are separated by a single Tab character.

–

Fields intentionally left blank must be represented by two adjacent Tab characters or a
Tab character at the end of a line. On import, the default value is used for such a value.

–

String values may include spaces.

–

An error occurs on import if a line contains too few or too many values.

Note: A simple way to create the import file with a valid format is to use Excel and save it
as Text (Tab delimited) (*.TXT).

Exporting Data

The export function saves the selected records or field(s) to a tab-delimited text file that you
can import into the Unified ICM database or into a database tool such as Microsoft Excel. If
any error occurs during the export process, the process is cancelled.

How to Export Data

To export data, follow these steps:

Select the rows with fields you want to export.

• If you intend to import this data into the Edit window, you must export a primary key field

along with any other fields. The primary key field has the same column name as the database
table name.

• All rows selected (including records marked for deletion) are exported.

Click Export.

Select the Header option if you want to include a header containing the table name and column
names in the output file. Including the header clarifies the content of the file.

In the Export dialog, select the column(s) you want to export and click Add or AddAll.

Configuration Guide for Cisco Unified ICM/Contact Center Enterprise and Hosted Release 8.0(2)