Upating line config using BAT

Answered Question
Mar 19th, 2010
User Badges:

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.

Correct Answer by William Bell about 7 years 3 months ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (5 ratings)
Loading.
William Bell Fri, 03/19/2010 - 07:20
User Badges:
  • Purple, 4500 points or more

What CUCM version are you running?

balasundaram.k_2 Mon, 03/22/2010 - 02:15
User Badges:

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.

Correct Answer
William Bell Mon, 03/22/2010 - 05:53
User Badges:
  • Purple, 4500 points or more

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.

balasundaram.k_2 Mon, 03/22/2010 - 06:09
User Badges:

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.

William Bell Mon, 03/22/2010 - 06:19
User Badges:
  • Purple, 4500 points or more

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, and 7.1.3b.  I haven't had the opportunity to check other versions.


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

Rob Huffman Mon, 03/22/2010 - 06:10
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

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!

William Bell Mon, 03/22/2010 - 06:21
User Badges:
  • Purple, 4500 points or more

Rob,


Thanks for the points and nod re: our blog!  I am grinning ear-to-ear for the rest of the day!


Regards,
Bill

richb1971 Fri, 06/27/2014 - 04:21
User Badges:

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

Actions

This Discussion