Cisco Cisco MeetingPlace Gateway SIM Anleitung Für Quick Setup

Seite von 766
 
Importing Data into Cisco Unified MeetingPlace
How To Import Data
4
 
  •
Create an import file template by exporting a similar file that includes field header names. See one 
of the following sections in the 
 module:
  –
  –
  –
  –
  •
Care should be taken when opening a Cisco Unified MeetingPlace export file using Microsoft Excel, 
which by default removes any leading zeros(0) in the data and results in import errors. For example, 
to preserve leading zeros (0) in the data using Microsoft Excel 2007:
a.
Select Data > From Text.
b.
Open the .CSV export file. This launches the File Import Wizard.
c.
During Step 3 of the File Import Wizard, you can select the Data Format for each column. By 
default, Microsoft Excel uses Generalformatting, which removes all leading zeros (0). Make 
sure you do the following:
  •
Select the column for numbers
  •
Under Column data format, select the Text radio button.
  •
Repeat this procedure for any other columns. When finished make sure to verify data.
Procedure
Step 1
Use a spreadsheet application, such as Excel, to open a previously exported file.
Step 2
In the spreadsheet application, the required headings are listed in the second row, and the data is listed 
in all subsequent rows. Perform one of the following actions:
  •
If you are modifying existing entries, then delete the rows that you do not want to modify. Do not 
delete the first two rows.
  •
If you are adding entirely new entries, then delete all rows except the first two rows.
Step 3
Enter or modify the information in the appropriate fields.
Caution
Make sure that all values in the import file are valid. Invalid entries in the import file may introduce 
incorrect relationships in the database and cause erratic system behavior.
If you are unsure about what to enter in any field, then we recommend that you delete that entire column 
(unless it is a required field). For descriptions of each field, see the following sections of the 
 module:
  •
  •
  •
  •
Step 4
Save and close the file.