This topic is a chance to clarify your questions about Cisco Unified Communications Manager (Unified CM) Bulk Administration Tool (BAT) and the best practices to solve its common issues.
This session will help CUCM administrators with using BAT to solve day-to-day administrative tasks. If you've ever thought "I wish I could…” bulk edit the description field for all of your phones; find a way to make the Home Cluster checkbox consistent in multiple clusters; migrate a single phone to a new model; modify the Voice Mail Profile field on lines in bulk; deploy Access Lists for Single Number Reach users in bulk; deploy a set of Abbreviated Dials across multiple phones, or work with CSV and TAR files for editing the database.
To participate in this event, please use the button below to ask your questions
Ask questions from Tuesday 14th to Friday 17th of January, 2020
Maren might not be able to answer each question due to the volume expected during this event. Remember that you can continue the conversation on the Unified Communications Infrastructure community.
**Helpful votes Encourage Participation! **
Please be sure to rate the Answers to Questions
We didn't get to this in the webex, can you give the steps for:
Another example (time permitting): Add a set of speed dials or abbreviated dials
to a set of phones (with or without a KEM)
There is two ways.
First is use API.
Second - Export Phone - All Details - Edit in Excell columns with SD - Save - Import as Phone All Details.
I would like to ask regarding Phone Templates.
For example I am going insert phones using BAT --> Phones --> Insert phones.
What is purpose of Phone template ? Does it mean that data in CSV file have priority and all other options (which are not in CSV file) will be configured according to phone template ?
Thank you in advance
You can think of the phone template (and the line templates that you build into the phone template) as the 'common settings for all phones/lines built on that template'. The rules of the interaction between the CSV file and the template are:
So, essentially, you are correct in saying that the CSV file has priority over the template during imports.
Let me know if you have further questions.
I recently came across an issue when trying to import calling party transformation patterns using an export file. I'm getting the following unmapped exception, 'Unmapped Exception bad header in block 0 record 3, header magic is not 'ustar' or unix-style zeros, it is '76737871328065', or (dec) 76, 73, 78, 71, 32, 80, 65'
Are there additional files required as part of the upload? The export contains a header.txt text file. Is that required to be uploaded as part of the .tar file containing the CSV?
Let me answer your second question first. Yes, the header file is required as part of the import TAR file. The header file tells the Import function which files are available for import. (Via: BAT > Import/Export > Import) If you use the same header file from the export TAR in the import TAR file, you should be fine.
As for that specific exception, let me say that I have imported called and calling transformation patterns without a problem in the past. So the problem is either the TAR file itself or the CSV inside the TAR file.
If you are editing the CSV file, it is possible the text is not formatted correctly. After finishing your edits and saving, open the CSV file in Notepad++. First, make sure that carriage returns, numbering (like E164) and such look okay. Second, do a "save as" and ensure that the file is saved as UTF-8 (rather than ANSI) text. UTF-8 is common in CUCM for text formatting. As but one example, the jabber-config.xml file must be UTF-8 formatted to be correctly read by CUCM.
And for the TAR file, use 7-Zip rather than WinZip or Microsoft's native compression function.
Let me know how this goes. If you do all of the above and it still doesn't work, I'll ask you to upload your TAR file (or send it to me privately) and I'll take a look.
Hi @Maren Mahoney thank you for the amazing session, we have learned lots.
Please help to answer some remaining questions from the live session
In one of the last scenarios Maren presented, what will happen to the delated phone? Would the phone profile will be completely removed, or would it be still available when you search it in the DN or MAC address?
When editing, Maren used the csv to make edits but changed it back to text to upload. Is this a standard to upload the text file or leave it as a csv?
What would be the steps/process if we would like to unsubscribe VisualVoiceMail?
Can we run a search to find out External Phone Mask on all the lines and devices?
Both, the reports Maren downloaded and the files she uploaded. Do they stay in the hard drive forever? Thinking about large deployments, you probably don’t want 10+ 50mb files taking space for no reason, right? Could you please provide some comments?