09-20-2016 08:14 AM - edited 03-17-2019 08:08 AM
My name is Scott,
I download a phones file from the Call Manager 10.5.1.11006-1 in the Bulk Administration tab. I then alter the phone.csv file to reflect changes in the phone description field. I delete many columns that are not necessary. Then I upload the altered phone.csv file in the bulk administration tab then apply it in insert phones. Job Scheduler shows the job as ran. I check the .txt file and it shows success.
When I then go to the device tab/phone I see the description has not changed but the job shows success? How can I change the phone description in a bulk .csv format?
Insert Phones - All Details
Begin Time : 09/19/2016 14:11:21
Query :
Insert Phones in /common/bps/csvfiles/phones/insert/all/TestDecriptionNameChange9-19.csv
Failure Details :
MAC Address/Device Name Error Code Error Description
-----------------------------------------------------------------------------------------
SEPD867C97739CE null
SEPE4D7226487DE null
SEPD867C977C2C7 null
SEPE4D722649F74 null
SEPC067BF582A2A null
SEPD867C974C0D9 null
SEPD867C973966C null
******** NO ERROR FOUND ********
Result Summary :
INSERT for 7 PHONES passed.
INSERT for 0 PHONES failed.
End Time : 09/19/2016 14:11:22
Solved! Go to Solution.
10-10-2016 09:06 AM
okay great thanks. So I can use existing templates that I see already built in the Call Manager?
10-10-2016 09:24 AM
device template is not built-in, if you are seeing one there, it was been created by someone. You can create new one and specify all fields (device pool; CSS) based on need.
10-17-2016 08:52 AM
Can't create a generic template that would cover all device types?
10-17-2016 09:04 AM
No, you need template for each device type.
Thanks,
Mosh.
10-20-2016 09:27 AM
i find that i can create the phone template for an EX90. And, i can create the .csv modified file to upload but then when i do the upload and choose specific field/correct template, the field I want to alter is indeed changed.
The problem is that it wipes out all the Association line info - except the phone number. And most of the info in the Device Information block is gone.
The only field i want to change on many devices is the description. This is important because it is the field that TMS looks at when scheduling for a particular Telepresence room.
included is my upload .csv (xlsx) file. If i knew how i would send you my EX90 template.
10-28-2016 10:33 AM
any update?
09-20-2016 10:40 AM
Are you choosing "Insert Phones Specific Details" along with Phone Template?
Looks like you have selected "Insert Phones All Details"
If you have phone template created, you do not need SEP in device name.
I am at work now, I will run this in my home lab after going home, Then I will be able to tell you exactly what you are missing.
Mosh
02-10-2021 01:58 PM
Cisco Really does not know how to build a bulk tool that works. There BAT and import really stinks.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide