[cisco-voip] bulk set UM account and LDAP

Mon Dec 10 13:47:26 EST 2012

Pulled from a doc I found:

This can only be accomplished in bulk using the Bulk Administration Tool (BAT).

Where it can get a bit confusing is which section of the doc to use.  Since the users exist already without a UM account assigned to them, we need to actually use the CREATE option in BAT to give the users Unified Messaging.  We're basically going to use the configuration for existing Unified Messaging users as a template for our new users, which will give them all the same features.

1. Get a list of all of the subscribers' aliases on the system by doing a BAT export of "Users with Mailbox"

  [cid:87642CF4-DD0A-451B-BBF6-D4C047F2CD74]

The resulting CSV should look similar to (download from article for better readability):

Alias,Address,AltFirstNames,AltLastNames,BillingId,Building,City,Country,Department,DisplayName,EmailAddress,MailName,EmployeeId,EnhancedSecurityAlias,FirstName,Initials,Language,LastName,Manager,PostalCode,State,TimeZone,Title,CosDisplayName,Extension,ClientMatterCode,TransferType,TransferRings,TransferExtension,TransferAction,RnaAction,StandardTransferType,StandardTransferRings,StandardTransferExtension,StandardTransferAction,StandardRnaAction,ClosedTransferType,ClosedTransferRings,ClosedTransferExtension,ClosedTransferAction,ClosedRnaAction,MWIExtension,MWIMediaSwitchDisplayName,MaxMsgLen,playPostGreetingRecording,postGreetingRecordingDisplayName,ForcedAuthorizationCode,ListInDirectory,CreateSmtpProxyFromCorp,MediaSwitchDisplayName,PhoneNumber_HomePhone,Active_HomePhone,DisplayName_HomePhone,PhoneNumber_WorkPhone,Active_WorkPhone,DisplayName_WorkPhone,PhoneNumber_MobilePhone,Active_MobilePhone,DisplayName_MobilePhone,PhoneNumber_Pager,AfterDialDigits_Pager,Active_Pager,DisplayName_Pager,PhoneNumber_TextPager1,SmtpAddress_TextPager1,Active_TextPager1,DisplayName_TextPager1,Extension_Alt1,Extension_Alt1_Partition,Extension_Alt2,Extension_Alt2_Partition,Extension_Alt3,Extension_Alt3_Partition,Extension_Alt4,Extension_Alt4_Partition,Extension_Alt5,Extension_Alt5_Partition,Extension_Alt6,Extension_Alt6_Partition,Extension_Alt7,Extension_Alt7_Partition,Extension_Alt8,Extension_Alt8_Partition,Extension_Alt9,Extension_Alt9_Partition,CcmId,EmailAction,VoicemailAction,FaxAction,DeliveryReceiptAction,RelayAddress,SmtpProxyAddresses,LdapCcmUserId,CorporatePhoneNumber
userA,,,,,,,,,user A,,usera,,,user,,1033,A,,,,20,,Voice Mail User COS,123456123456,,0,4,123456123456,1,1,0,4,123456123456,1,1,0,4,123456123456,1,1,123456123456,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,
userB,,,,,,,,,user A,,usera,,,user,,1033,B,,,,20,,Voice Mail User COS,123456123457,,0,4,123456123457,1,1,0,4,123456123457,1,1,0,4,123456123457,1,1,123456123457,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,
userC,,,,,,,,,user A,,usera,,,user,,1033,C,,,,20,,Voice Mail User COS,123456123458,,0,4,123456123458,1,1,0,4,123456123458,1,1,0,4,123456123458,1,1,123456123458,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,
userD,,,,,,,,,user A,,usera,,,user,,1033,D,,,,20,,Voice Mail User COS,123456123459,,0,4,123456123459,1,1,0,4,123456123459,1,1,0,4,123456123459,1,1,123456123459,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,
userE,,,,,,,,,user A,,usera,,,user,,1033,E,,,,20,,Voice Mail User COS,123456123450,,0,4,123456123450,1,1,0,4,123456123450,1,1,0,4,123456123450,1,1,123456123450,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,

2.  Now get a list of all of the "Unified Messaging Accounts" that already exist on the system so we can use it as a template for our final CSV

[cid:811E0653-494D-4799-994A-A7B167D3E0BF]

3. Copy the alias value only (green)from the first "Users with Mailbox" CSV export who you want to enable for Unified Messaging and paste them in the "SubscriberAlias" column of the second "Unified Messaging Accounts" CSV export.  It will look something like this (download from article for better readability):

SubscriberAlias,ServiceDisplayName,OptionalServiceAccountID,UMEmailAddress,EmailAddressUseCorp,EnableCalendar,EnableMeeting,EnableMbxSynch,enableTTS,IsPrimaryMeetingService,LoginType,UserId,UserProfileNumber
userD,Exchange 2010,3194886a-d72b-4893-bbd6-15b4fe02e644,userD at corp.com,1,0,0,1,1,0,0,,
userE,Exchange 2010,3194886a-d72b-4893-bbd6-15b4fe02e644,userE at corp.com,1,0,0,1,1,0,0,,

Since we know userA, userB, userC already had UM configured months ago, we only want to give the feature to userD and userE.  This also assumes that userD and userE are going to be assigned the same Unified Messaging account and features (all of the columns) as existing userA, userB, userC.  These can be manually modified too but this article just covers how to get everyone enabled for the same features in a hurry.

4.  Create the Unified Messaging feature for your two users by providing your newly created CSV

[cid:BD5AE290-22A4-4CA8-8648-FC7063A04572]

From: Erick <ewellnitzvoip at gmail.com<mailto:ewellnitzvoip at gmail.com>>
Date: Monday, December 10, 2012 12:58 PM
To: "cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>" <cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>>
Subject: [cisco-voip] bulk set UM account and LDAP

Is there a way to bulk update LDAP integration and UM Account for connection users?  I didn't see anything obvious in the guide with the csv fields for bulk import and COBRAS doesn't seem to have an option for either one.

Thanks in advance!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20121210/c216b592/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 87642CF4-DD0A-451B-BBF6-D4C047F2CD74.png
Type: image/png
Size: 17849 bytes
Desc: 87642CF4-DD0A-451B-BBF6-D4C047F2CD74.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20121210/c216b592/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 811E0653-494D-4799-994A-A7B167D3E0BF.png
Type: image/png
Size: 10126 bytes
Desc: 811E0653-494D-4799-994A-A7B167D3E0BF.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20121210/c216b592/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BD5AE290-22A4-4CA8-8648-FC7063A04572.png
Type: image/png
Size: 15157 bytes
Desc: BD5AE290-22A4-4CA8-8648-FC7063A04572.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20121210/c216b592/attachment-0002.png>