Cisco Cisco IPCC Web Option

Importing Data

You can import data from a specified text file into the opened database table. Whole records or
only columns of data can be imported, if the data matches (see Step 3 of the following procedure).
If any error occurs during the import process, the process is cancelled.

How to Import Data

In the Insert or Edit window, click Import.

In the Import dialog, click File.

In the File Open dialog, select the file containing the data you want to import and click Open.
For a description of the required import-file format, see the "

" section following this procedure.

The Import File Data area displays the first few lines of the opened file.

•

When importing data in the Edit mode, the following rules apply:

–

The Bulk Configuration tool reads only those records whose primary key values match
those of records in the Edit window.

If there is a record that does not match the primary key value, the record is considered to
be an error and a message box with the primary key value pops up to ask you to correct
the problem.

–

If any field in the import record is null, the corresponding field value in the grid window
become blank for an edit cell or uses the default value for a drop-down list cell.

–

If any field is missing in the import file, the corresponding field in the Edit window remain
unchanged.

–

If there is a larger number of records in the file to be imported than the number of rows
in the grid, it is considered as an error and a message box pops up asking you to correct
it.

–

If there is a duplicated primary key in the file to be imported, it is considered as an error.
A message box with the duplicated primary key value pops up asking you to correct it.

–

After importing, all records imported (including records marked for deletion in the grid)
are marked as “Changed” regardless whether the value is changed or not.

–

After a importing, the records are displayed in index order (ordered by logical keys). If
you did not sort before importing, the order appears the same after the import.

•

When importing data in the Insert mode, the following rules apply:

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