Solved: Bulk edit "Call Forward and Call Pickup Settings"

Chris Penny · ‎07-24-2015

I'm trying to edit the CFUR destination for each 4 digit DN to the DNs full 7 digit DID number so when I have a WAN failure, calls will route out Local Gateways through the PSTN.

I can edit them each manually (which honestly I'd be done with by now), but I'd really like to figure out how to bulk edit them.

I've tried several different ways using BAT, but it either fails or I can only change the field to the same destination for all the DNs.

Has anyone every successfully attempted to do this?

Thanks!

Jaime Valencia · ‎07-24-2015

You need to bulk export, modify the csv, then bulk import.

HTH

java

if this helps, please rate

View solution in original post

Richard Simmons · ‎07-24-2015

Have you tried setting the CFUR with a wildcard i.e 9123XXXX ?

Chris Penny · ‎07-24-2015

I did try that under the "Update Lines" function in BAT. Didn't work, but I'm not completely sure I was able to test it accurately in my test environment.

Marnus van der Nest · ‎05-16-2017

I cant upload the .tar file it is not allowing me to do that. I go to Upload/Download files and then I can only attached CSV files not .tar files? why is this

Chris Penny · ‎05-18-2017

Not sure.

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/bat/10_0_1/CUCM_BK_CDB9A6A4_00_cucm-bulk-administration-guide-100/CUCM_BK_CDB9A6A4_00_cucm-bulk-administration-guide-100_chapter_0111110.html

If you are following the guide, I don't see why it won't work. Maybe the .tar is missing the header??

Jaime Valencia · ‎07-24-2015

You need to bulk export, modify the csv, then bulk import.

HTH

java

if this helps, please rate

Chris Penny · ‎07-24-2015

I'm going to give this a try Jaime. Thx.

Chris Penny · ‎07-24-2015

Worked beautifully Jaime. Thanks for pointing me in the right direction. I had never used the export/import before so it was definitely a little scary, but it worked exactly how I needed it to.

Thanks!

Marnus van der Nest · ‎05-10-2017

Hi, Can you perhaps send me the steps you took to get this working?

Chris Penny · ‎05-10-2017

Sure Marnus.

So in the CUCM admin page, I went to Bulk Administration, Import/Export, Export. I selected the items I wanted exported and submitted the job.

The output was a .tar file which I opened up in Excel. I was able to edit my Forward Unregistered Destination and CSS for each DN. I then saved that as a .tar and uploaded it into the CUCM.

Went back to the Import/Export in CUCM Admin and imported the .tar.

Marnus van der Nest · ‎05-11-2017

thanks which items did you export.

Chris Penny · ‎05-11-2017

Under Device Data I selected Phone.

Marnus van der Nest · ‎05-16-2017

Hi Chris.

I have another question. So i got the .tar file from CUCM and ex extrated it using 7zip. Changed the device profile call forwarding number and saved and then re-tar'd the file to same name. But now according to the Bulk Admin Guide I need to upload the file and then import. But CUCM is only allowing to upload CSV files not tar files. How do I upload the modified .tar file that has all the new config files (csv) files in it. ?

Chris Penny · ‎05-16-2017

In the CUCM Admin page, I went to Bulk Administration, Upload/Download files. Clicked on Add New.

Select the .tar file for upload, Target was Import/Export, and Transaction type was Import Configuration.