cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
14892
Views
10
Helpful
7
Comments
Brett Fritzsch
Cisco Employee
Cisco Employee

Introduction:
Bulk Administration Tool (BAT) is a tool that can be used to make the editing/adding/removing of multiple phones

quicker and easier.  Although its designed to make things easier for users to add/remove/update administrators

commonly run into issues.  The following is a guide that will show you how to edit multiple phone descriptions

using this tool.


Steps:


1. Bulk Administration ---> Phones --> Export Phones --> All Details
menu.JPG

2. Choose all phone types, give a file name, Run immediately
ExportPage.JPG

3. Monitor the Job and wait for it to show as completed in Job Scheduler
JobSchedMenu.JPGJobSchedulerCompleted.JPG
4. Bulk Administration --> Upload/Download files.... Download the file to your desktop
DownloadMenu.JPG
5. Import into excel using comma delimited
     Office 2003:
2003import.JPGImportWizard.jpg
     Office 2007:
2007import.JPGImportWizard.jpg

6. Find the Description column


7. Saved the file as a CSV


8. Next we need to upload the CSV that we created:
     Bulk Administration --> Upload/download files -->  Add New

     Choose file from your desktop

     Target = Phones

     Transaction Type =  Insert Phones - All Detail

     Save
Upload.JPG
9. Bulk Administration --> Phones --> Insert Phones
Import.JPG
10. Check Insert Phones All Detail --> select file --> Check Override the existing config --> Run Immediately --> Submit
Insert.bmp

11. Confirm that the Job ran with no errors

     Bulk Administration --> Job Scheduler --> Click on the Job Name



12. Check phone page to make sure change took effect.

Comments
jcompiano
Beginner
Beginner

Good tip, i was spinning my wheels trying to use the BAT update process to update my descriptions. Good to know it's actually under install phones to update.

thanks

Gia Reynolds
Beginner
Beginner

I am trying to use the Bulk Administration to setup new users with Extension Mobility. I found the document below but the instructions are unclear. Has anyone used Bulk Administration for  Extension Mobility?

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_configuration_example09186a0080b35d02.shtml#csv

Thanks,

Michael Endler
Beginner
Beginner

Awesome, cutted extremly my research and labtime!

o.artigny
Beginner
Beginner

Hello,

There seems to be a bug with the phone export when the export format contains the owner used ID field.

CSCtb95233

I have to populate that field to cope with the new licences format.

 

How may I proceed ?

Thanks,

Olivier

christianbernal
Beginner
Beginner

When you save the .csv in excel, the archive is separated with (;) is necesary replaze in one notepad for (,) the rest is fine

Thanks is very util :)

KNYC
Beginner
Beginner

Anyone is getting an error that Line Text Label is not a valid field? Even though it is in exported file. 

 

Line Text Label is not updating. 

EYC
Beginner
Beginner

I have a question when we do a export all config from CUCM, we usually use excel to manipulate the csv file. My question is there are times where the user display name field includes a comma, but we know that comma is used as a delimiter, so excel does not know if it is part of the field or as delimiter and the record goes off by a few columns. Anyone knows any way around that? Googling says use double quotation but I do not see if being included in the export csv. Anyone any ideas or recommendation? Thanks.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers
Quick Links