Cisco Cisco Unified MeetingPlace Audio Server Guide D’Installation Rapide
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
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:
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:
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:
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.
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.
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
(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.