Table Of Contents
Import/ Export
Exporting Configuration
Log Files
Editing the .tar File
Related Topics
Import/ Export
You can use the Import/Export menu in Cisco Unified Communications Manager Bulk Administration Tool (BAT) to export or import parts of the Cisco Unified Communications Manager database to another server, or to the same server with modifications. This reduces the configuration time that is required by importing a preconfigured database to the installed Cisco Unified Communications Manager server.
The following topics provide procedures for carrying out these tasks:
•
Exporting Configuration
•
Editing the .tar File
•
Importing Configuration, page 61-1
Exporting Configuration
To export configuration data from Cisco Unified Communications Manager, use the following procedure.
Procedure
Step 1
Choose Bulk Administration > Import/Export> Export.
The Export Data window displays.
Step 2
In the Job Information section, enter the .tar file name, without the extension, in the Tar File Name field.
BPS uses this filename to export the configuration details.
Note
All files that are exported at the same time get bundled together (.tar) and can be downloaded from the server.
Step 3
In the Select items to Export section, check the appropriate check boxes under System Data from the following options:
•
Cisco Unified Communications Manager
•
Cisco Unified Communications Manager Group
•
Date/Time Group
•
Device Pool
•
Enterprise Parameter
•
Location
•
Phone NTP Reference
•
Region
•
Server
•
Service Parameter
•
SRST
•
Security Profile (Phone & SIP Trunk)
•
Physical Location
•
Device Mobility group
•
Presence Group
•
LDAP System
•
Device Mobility Info
•
DHCP Server
•
DHCP Subnet
•
Application Server
•
LDAP Directory
•
LDAP Authentication
•
MLPP Domain
•
Resource Priority Namespace Network Domain
•
Resource Priority Namespace List
•
CUMA Server Security Profile
Step 4
Check the appropriate check boxes under Call Routing Data from the following options:
•
Application Dial Rules
•
CSS (Class of Control)
•
Partitions (Class of Control)
•
Route Filter
•
Time Period (Class of Control)
•
Time Schedule (Class of Control)
•
Translation Pattern
•
AAR Group
•
Forced Authorization Codes
•
Directory Lookup Dial Rules
•
Client Matter Codes
•
Call Park
•
Call Pickup Group
•
Directory Number
•
MeetMe Number
•
Cisco Attendant Console Pilot Point
•
Directed Call Park
•
SIP Dial Rules
•
Line Group
•
Route Group
•
Hunt List
•
Route List
•
Hunt Pilot
•
Intercom Route Partition
•
Intercom CSS
•
Access List
•
Route Pattern
•
Called Party Transformation Pattern
•
SIP Route Pattern
•
Intercom Directory Number
•
Mobility Configuration
•
Intercom Translation Pattern
•
Calling Party Transformation Pattern
•
Time Of Day Access
Step 5
Check the appropriate check boxes under Media Resources from the following options:
•
Annunciator
•
Conference Bridge
•
Media Resource Group
•
Media Resource Group List
•
Media Termination Point
•
Transcoder
•
MOH Server
•
Mobile Voice Access
Step 6
Check the appropriate check boxes under User Data from the following options:
•
SIP Realm
•
Application User
•
User Group
•
Role
•
Application User CAPF Profile
•
Credential Policy Default
•
Credential Policy
•
End User
•
End User CAPF Profile
•
Cisco Attendant Console User
Step 7
Check the appropriate check boxes under Device Data from the following options:
•
Softkey Template
•
Gate Keeper
•
Trunk
•
SIP Profile
•
Phone Services
•
Phone Button Template
•
Common Phone Profile
•
Gateway
•
Device Defaults
•
Device Profile
•
Common Device Configuration
•
CTI Route Point
•
Phone
•
Recording Profile
•
Remote Destination
•
Remote Destination Profile
Step 8
Check the appropriate check boxes under Voice Mail Data from the following options:
•
Message Waiting Numbers
•
Voice Mail Pilot
•
Voice Mail Profile
•
Voice Mail Port
Step 9
You can use the Select All button to check all the check boxes at once and the Clear All button to clear all the check boxes.
Step 10
In the Job Description field, enter the description that you want to provide for the job. Export Configuration is the default description.
Step 11
You can choose to run the job immediately or later by selecting the corresponding radio button.
Step 12
To check for interdependency of tables to make sure that the related records are also exported, click Check Dependency.
Note
You can de-select any of the check boxes after checking dependency. You also have the option to skip checking dependency.
Step 13
To create a job for exporting the selected data, click Submit.
A message in the Status section lets you know that the job was submitted successfully.
Step 14
Use the Job Scheduler option in the Bulk Administration main menu to schedule and/or activate this job.
For more information on jobs, see the Chapter 66, "Scheduling Jobs."
Log Files
Multiple log files are created for a single export transaction. One for the overall transaction, and one each for the items selected for export. These log files display separate results for each item. The log file name is prepended with the item name, to make it easier to identify the logs.
These files can be accessed from the Job Scheduler page.
Additional Topics
See the "Related Topics" section
Editing the .tar File
The tar file comprises a list of CSV files and a header file. Header file can be used to refer to the details of the server from where the export was carried out and the time when it was carried out. The header file also has details regarding the files in the package.
If you want to make any changes to the configuration after you have exported the required data, you can do so by editing the exported .tar file by using the following procedure.
Procedure
Step 1
Choose Bulk Administration>Upload/Download Files.
The Find and List Files page displays.
Step 2
Download the .tar file that you want to update by using the procedure that mentioned in "Downloading a File" section on page 2-2.
Step 3
Un-tar the .tar file to some location on your machine by using the tar -xvf command.
The .csv file gets extracted to the location that you specified.
Note
The "tar -xvf" command may not work on a Windows server, TAR and UNTAR operations are possible in Windows using 7-Zip, which is a freeware available on the World Wide Web.
Note
The name of the .csv file is always the same as the item name.
Step 4
Use MS Excel to edit the .csv file and save your changes.
Note
You can edit the .csv file by using Notepad/Wordpad also, but Cisco recommends using MS Excel to edit the .csv file.
Always maintain the same filename and file format for the .csv file. If you add a new file to the tar package, ensure that the file has the same name and file format as it would have if it is exported from Cisco Unified Communications Manager. Also make sure that the new filename is added to the Header file.
Tip
If you are expecting to add a new item, always try to export that item from Cisco Unified Communications Manager, even if there are no records for that item. This will create a .csv file with the correct name and file format.
Step 5
Re-tar the files using the tar -cvf command while making sure that the new .tar file is saved in the default common location.
Note
The "tar -cvf" command may not work on a Windows server, TAR and UNTAR operations are possible in Windows using 7-Zip, which is a freeware available on the World Wide Web.
Caution 
The .tar files must maintain the original directory structure when you re-tar the files, because BPS looks for .tar files at the default location only.
Step 6
Upload the .tar file for import by using the procedure that is mentioned in "Uploading a File" section on page 2-3.
Note
Make sure that you select the Target as Import/Export and the Transaction Type as Import.
Note
If you decide to use notepad or wordpad for the edit, make sure that you add a comma for every new entry in the file format.
Related Topics
•
Exporting Configuration
•
Editing the .tar File
•
Finding a File, page 2-1
•
Downloading a File, page 2-2
•
Uploading a File, page 2-3
•
Deleting a File, page 2-3
•
Importing Configuration, page 61-1