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.
09-28-2016 09:48 AM
I am sorry, I didn't see your last message. There is no impact as long as you know what you are doing. Yes, I have done that in my lab, it worked.
09-20-2016 09:14 AM
Hi Scott,
While you insert phone, did you check the option "Override the existing configuration"?
Can you please attach your CSV file?
Will be happy to assist.
Regards,
Mosh
Please mark as correct if applicable.
09-20-2016 09:40 AM
09-20-2016 09:48 AM
Remove SEP from Device name
SEPD867D97739DE should be D867D97739DE.
Regards,
Mosh
09-20-2016 09:55 AM
I already did that and it error out. I just did it again with no success and got this for each one:
MAC Address/Device Name Error Code Error Description
-----------------------------------------------------------------------------------------
D867D97739DE DEVICE :: Error : 407 The Model type for the specified Product type was not found
09-20-2016 10:13 AM
Sorry to know that.
If you are using phone template, you do not need below things in CSV file
Device pool; Phone Button Template; CSS; MTP Required; Digest User and Device Type
Please try to remove them from CSV file and add those filed into Phone Templates.
Do not use SEP in device name. Please try one more time. Sometimes if the description contain syntex which CUCM doesen't like, change will not be applied. I would try to make the description simple for test purpose.
Regards,
Mosh
09-20-2016 10:33 AM
I stripped it down to where it only has the MAC address and the new description field. Only those two fields.
I got the same exact error:
D867D97739DE DEVICE :: Error : 407 The Model type for the specified Product type was not found
I do appreciate you helping.
09-20-2016 10:41 AM
09-20-2016 10:46 AM
I did select Insert Phones All Details
09-20-2016 11:00 AM
Please try below,
Bulk Administration ---> Phone ----> Phone Template
Add new and select phone type "Cisco Telepresence SX20"
Define below things in template
Device pool; Phone Button Template; CSS; MTP Required; Digest User and Device Type and other mandatory filed.
Create CSV file with below filed
DEVICE NAME | Description | LOCATION | DIRECTORY NUMBER 1 |
Then "Insert Phones Specific Details, and use the template that you have created earlier.
mosh
09-23-2016 06:31 AM
a couple of questions. Will creating this template impact the production environment? this small amount I am using are in production. And, did you try this at home to see if it worked for you?
09-28-2016 09:44 AM
any response?
09-28-2016 09:48 AM
I am sorry, I didn't see your last message. There is no impact as long as you know what you are doing. Yes, I have done that in my lab, it worked.
10-10-2016 08:52 AM
I am doing this testing now. So, it looks like that by using your method I must load only like type devices. I have many different types of devices. Is this the only way to go?
Thanks
10-10-2016 08:58 AM
With this method, you will have to use device template where you can define the device type. You need different csv file for different device template (device type).
Regards,
Mosh
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
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