03-19-2010 07:14 AM - edited 03-15-2019 09:52 PM
Hi,
Our management want to put the user's name on their phones now.
Is there any way I can edit the line text field for 500+ users using BAT and a csv file.
Or should I manually put the name in the line text field for every line.
Thank you very much!!!
Cheers,
Bala.
Solved! Go to Solution.
03-22-2010 05:53 AM
Bala,
You can accomplish this with BAT but you won't be using the Update Lines to do so. Update Lines for bulking the same change to multiple lines. This is a different need than making a custom change to each and every line. I usually do this by using the AXL/SOAP API interface and a custom script I wrote. But I don't think you will need to do this.
I believe you can export your devices from BAT and then edit the line appearances in the exported .csv file. Then you can re-import the records and make sure you check the box that says "overwrite existing". A summary of procedure:
1. Use BAT to Export Phones - All Details (you can do this by phone model or all models)
2. Edit the CSV that is exported. Remove any phone records you aren't planning to update
3. Edit the CSV that is exported. Modify the line appearances on the phones as per your requirement
4. After editing the CSV, upload it to CUCM using BAT>Upload/Download Files (target: phones, transaction-type: phones-all details)
5. Use BAT Phones>Insert to import the All Details record you uploaded. Check the box to overwrite existing record.
I recommend you test this on a small sample of phones before pushing this method to the entire environment. On your test sample you will want to do a thorough review of all phone configurations after insert (check BLF, speed dials, phone services, line configs, etc.). Use your phone as one of the test subjects and monitor the phone behavior during insert. You will see it re-register. You will want to note the impact to the user during the transaction so that you can be prepared for a bulk change to the entire environment.
The BAT admin guide for 6.1: http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/bat/6_1_1/bat611.html
HTH.
Regards,
Bill
Please remember to rate helpful posts.
Please remember to rate helpful responses and identify
03-19-2010 07:20 AM
What CUCM version are you running?
Please remember to rate helpful responses and identify
03-19-2010 07:38 AM
Hi,
We are running CCM version 6.1.4.
Thanks,
Bala.
|
03-22-2010 02:15 AM
Hi Experts,
Is there any way I can update the line text for all 500 users using BAT in our CCM 6.1.4?
We have to complete the task soon.
So, your inputs are much awaited!!!
Thank you very much!!!
Regards,
Bala.
03-22-2010 05:53 AM
Bala,
You can accomplish this with BAT but you won't be using the Update Lines to do so. Update Lines for bulking the same change to multiple lines. This is a different need than making a custom change to each and every line. I usually do this by using the AXL/SOAP API interface and a custom script I wrote. But I don't think you will need to do this.
I believe you can export your devices from BAT and then edit the line appearances in the exported .csv file. Then you can re-import the records and make sure you check the box that says "overwrite existing". A summary of procedure:
1. Use BAT to Export Phones - All Details (you can do this by phone model or all models)
2. Edit the CSV that is exported. Remove any phone records you aren't planning to update
3. Edit the CSV that is exported. Modify the line appearances on the phones as per your requirement
4. After editing the CSV, upload it to CUCM using BAT>Upload/Download Files (target: phones, transaction-type: phones-all details)
5. Use BAT Phones>Insert to import the All Details record you uploaded. Check the box to overwrite existing record.
I recommend you test this on a small sample of phones before pushing this method to the entire environment. On your test sample you will want to do a thorough review of all phone configurations after insert (check BLF, speed dials, phone services, line configs, etc.). Use your phone as one of the test subjects and monitor the phone behavior during insert. You will see it re-register. You will want to note the impact to the user during the transaction so that you can be prepared for a bulk change to the entire environment.
The BAT admin guide for 6.1: http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/bat/6_1_1/bat611.html
HTH.
Regards,
Bill
Please remember to rate helpful posts.
Please remember to rate helpful responses and identify
03-22-2010 06:09 AM
Hi Bill,
Thanks a lot for the very fast and a very detailed reply !!!
I will try this today itself and if the test passes, I will do the update for all users tomorrow.
Just curious to know why you asked me about our CCM Version.
Is there a different way to do it in other CCM versions???
Thanks,
Bala.
03-22-2010 06:19 AM
Each version of CUCM has different features and caveats. The BAT "overwrite" capability came into the feature set around 6.0 or 6.1 I believe (don't quote me on that!). I found that the overwrite capability was flaky on 6.1.1 and 6.1.2 but worked well in 6.1.3b, 6.1.3bSU
In general, it is a good idea to specify the version you are dealing with because feature sets change rapidly and there may be known defects/caveats depending on your particular release.
Regards,
Bill
Please remember to rate helpful responses and identify
03-22-2010 06:10 AM
Hey Bill,
Great answer my friend! +5 points all day long for this
Cheers!
Rob
PS: read some excellent Blogs from you and Hailey over
the weekend...really awesome info!
03-22-2010 06:21 AM
Rob,
Thanks for the points and nod re: our blog! I am grinning ear-to-ear for the rest of the day!
Regards,
Bill
Please remember to rate helpful responses and identify
06-27-2014 04:21 AM
Hi chaps,
How can I update UDPs (line text label) in CUCM10. I've tried the method above but it doesn't work (no overwrite!)
Rich
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