Bulk edit "Call Forward and Call Pickup Settings"

Answered Question
Jul 24th, 2015
User Badges:

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!

Correct Answer by Jaime Valencia about 1 year 10 months ago

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Richard Simmons Fri, 07/24/2015 - 12:38
User Badges:
  • Bronze, 100 points or more

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

Chris Penny Fri, 07/24/2015 - 14:24
User Badges:

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 Tue, 05/16/2017 - 23:05
User Badges:

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

Correct Answer
Jaime Valencia Fri, 07/24/2015 - 12:50
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

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

Chris Penny Fri, 07/24/2015 - 15:28
User Badges:

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!

Chris Penny Wed, 05/10/2017 - 08:26
User Badges:

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 Tue, 05/16/2017 - 02:20
User Badges:

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 Tue, 05/16/2017 - 08:33
User Badges:

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.


Actions

This Discussion