Tuesday, July 22, 2014

Cisco Jabber using BAT Bulk Administration to add devices

Add Devices

If you have CUWL licensing, you can add Jabber devices for Windows, iPhone, Android and Tablet for each user without additional licensing, assuming each user will have 10 or fewer devices when your done.

You can put your file together in any fashion you like, but I choose to export users via BAT and use that as my reference material for the rest of the files. In CUCM, navigate to Bulk Administration | Users | Export Users.  With that file output, Excel functions are your friend and it's fairly easy to create the following file.  Use something like ="CSF"&$C2 for device names, something like =&C2&" ,"&D2&" - "$E2 for descriptions, etc.

The format you are looking for is something like:

DEVICE NAME,DESCRIPTION,DIRECTORY NUMBER 1,LINE DESCRIPTION 1,ALERTING NAME 1,ASCII ALERTING NAME 1,DISPLAY 1,ASCII DISPLAY 1,LINE TEXT LABEL 1,ASCII LINE TEXT LABEL 1,EXTERNAL PHONE NUMBER MASK 1,Owner User ID
CSFJONES,"Jones, Jim - JONES",1111,"Jones, Jim - JONES","Jones, Jim - JONES","Jones, Jim - JONES","Jones, Jim - JONES","Jones, Jim - JONES",,,716433XXXX,JONES
CSFSMITH,"Smith, Joe - SMITH",1112,"Smith, Joe - SMITH","Smith, Joe - SMITH","Smith, Joe - SMITH","Smith, Joe - SMITH","Smith, Joe - SMITH",,,716433XXXX,SMITH

Then Bulk Administration | Phones | Insert Phones | Specific Details to add devices of each type.

User / DN association

You need to associate users with DNs to enable phone presence information, and because this association is device specific, you are going to need a row for each device that the DN appears on.  If your user had a phone and now has four Jabber devices, that's five rows per user.  Excel is your friend again. 

Create a pivot table with your user export data. Select USER ID, CONTROLLED DEVICE 1 thru CONTROLLED DEVICE 5 (or whatever you need) and TELEPHONE NUMBER as row labels. Go to the USER ID Field Settings | Layout & Print and remove the Display labels from next field in the same column check.  Now you will be pretty close and need to copy each user down four rows.  Ultimately you are looking for a format like:

User ID,Device,Directory Number,Partition
JONES,SEP00260B5D3D2A,1111, AllLines
JONES,CSFJONES,1111, AllLines
JONES,TCTJONES,1111, AllLines
JONES,BOTJONES,1111, AllLines
JONES,TABJONES,1111, AllLines
SMITH,SEP00260B5E4169,1112, AllLines
SMITH,CSFSMITH,1112, AllLines
SMITH,TCTSMITH,1112, AllLines
SMITH,BOTSMITH,1112, AllLines
SMITH,TABSMITH,1112, AllLines

Upload the file as User Line Appearance, and then Bulk Administration | Users | Line Appearance | Update Line Appearance to associate users to DNs.

User controlled devices

A user needs to have CTI control over the new devices.  Again, use the user export data as your baseline and use some Excel text concatenate functions to populate the CONTROLLED DEVICE 2 through CONTROLLED DEVICE 5.  Use the ="CSF"&$C2 type of function.

Then Bulk Administration | Users | Update Users | Custom File to add control of devices to users.

2 comments:

  1. Very nice, I am trying to understand above and wondering that if you have a small animation of the above , how to achieve that ? i believe above is a good guide to help doing what you stated above , but if you make a small video for that ,. it would be ideal. Thanks again.

    ReplyDelete
  2. If you do a Phone Export > All details, you will see that Column AQ (in Excel import) is called "Owner User ID". If you put the Owner User ID there (as well as column AK, called "User ID 1", you will associate both the device and the user to the same user... sweet!

    ReplyDelete