Using the Bulk Administration Tool to update User Device Profiles
Updating UDPs in BAT involves overwriting certain configuration parameters (as required) using a very similar method to inserting UDPs from scratch.
In the Cisco Unified Communications Manager ccmadmin page, under Bulk Administration Tools, the option is available to add a new CSV file under "Target" UDP ==> "Transaction Type" Update UDPs CSV file. The only catch is that you can't reference this file anywhere; or, at least, you can reference it under Insert UDPs, but it doesn't seem to do anything.
To update existing UDPs, the process which I have followed is:
- Export the current UDP records to CSV
- Download the generated file
- Using Excel (or notepad, for the die-hards), identify the records of interest, and update the fields
- Massage the CSV so that unused fields are not represented in the CSV. Importantly, ensure that single line UDPs do not reference additional directory numbers, as your Input will error ("LINE :: Error : 25140 Cannot have an empty pattern when no Partition is specified"). Note that Busy Lamp Field/Speed Dials are added as Busy Lamp Fields.
- Upload the CSV to ccmadmin with the Transaction Type "Insert UDPs - All Fields". Some sample UDPs are shown below. Don't worry about the "All Fields". If a field is not specified as part of the update, CUCM retains the current value.
- Schedule a new job to insert User Device Profiles. The job is configured to run according to the following parameters:
- Insert User Device Profiles All Details
- CSV file from steps 3 & 4 selected
- Override the existing configuration
- Run Immediately
At this point, the UDPs should be updated, but check the Job Scheduler to ensure there are no errors. A few caveats were resolved in CUCM 7.0 that existed in previous versions of CallManager:
- Speed Dials: Additional speed dials were added to UDPs, not replaced. That means, if you imported the same UDP twice (over the top of each other), speed dials were added to the end of the button assignment.
- Service Subscriptions Similar to speed dials, Services were added to UDPs, not replaced. So, if you had the Extension Mobility service assigned, you ended up with multiple subscriptions.
- Busy Lamp Fields (and Busy Lamp Fields/Speed Dials): Exactly the same as speed dials; new BLF or BLF/SDs were added to UDPs, not replaced.
Replacement of the fields is optional - you can add either Speed Dials, Busy Lamps or Services, or replace the existing subscriptions.
##### SAMPLE CSV Files #####
## Adding a new speed dial ##
Device Profile Name,Speed Dial Number 1,Speed Dial Label 1,Speed Dial Label ASCII 1
ALEXTEST,1234567890,Mobile,Mobile
## Adding a Busy Lamp Field or Busy Lamp Field/Speed Dial ##
Device Profile Name,Busy Lamp Field Destination 2,Busy Lamp Field Directory Number 2,Busy Lamp Field Label 2,Busy Lamp Field Label ASCII 2
ALEXTEST,,55011,Shane,Shane: 55011
Step 1: Export UDP records to CSV
Step 1: Select Export for UDP Records
Step 3: Download file generated by BAT
Step 5: Upload the amended file
Step 6: Run new BAT job to insert UDPs
Verification: Before (take note of button assignment)
Verification: After (Speed Dial is assigned)