Add DevicesIf 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 associationYou 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
Upload the file as User Line Appearance, and then Bulk Administration | Users | Line Appearance | Update Line Appearance to associate users to DNs.
User controlled devicesA 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.