CUCM 7.1 - Need to bulk associate CUPC Line/DN with Username

[Brian Carlson]

Does anyone know of a way to bulk associate CUPC directory numbers with their usernames?  Right now I have to go one by one and update them manually.

The manual process is as follows;

1. Go to the UPC Device
2. Go into the directory number that I want to associate with CUPC
3. Click "Associate Users"
4. Search for username, click save.

If there was a way to bulk associate a directory number within the UPC device to a username, that would save a lot of time.

If anyone knows how, please share!

Thanks in advance!

[htluo · Accepted solution]

You may go to CUCM > Bulk Administration > Users > Line Appearance > Update Line Appearance.

Click "View Sample File" to see the example.

Michael

http://htluo.blogspot.com

[Brian Carlson]

Michael,

Thanks for your help, that was exactly what I was looking for!

[tbergquist · Accepted solution]

Brian,

The below posting was submitted by another CCO user "htlup"  I am simply re-posting it as It was helpful for me and it works great.

For Line Association,You will need to make a file with the following format:

User ID,Device,Directory Number,Partition

Then, upload it using the BAT file upload tool and select BAT -> Users -> Line Appearance -> Update Line Appearance. Select your file and for CUPC users only. This populates the 'Users Associated with Line' field under the line on the phone.

[Brian Carlson]

tbergquist,

Thanks for your help.  This forum is truly an excellent resource!

[tbergquist]

Looks like everyone beat me to it!  Yes.  I use the forums almost everyday!

[htluo]

Ya, I guess some people (not me) wrote a script to auto-answer those qustions. 

Michael

[vinhnguyen]

Hi

Do you know what to put in the DEVICE column if I have device profile rather than a physical mac address.  I tried with the device profile name but keep getting an error

"bad device name"

Thanks

[Juan Gerardo Hernandez]

Thank you!

Very Helpful.