[cisco-voip] bulk set UM account and LDAP

[Erick Wellnitz]

This worked perfect. A whole lot better than tryng to update 90+ users
manually. Thanks!

On Mon, Dec 10, 2012 at 12:47 PM, Mike Wilusz (miwilusz) <miwilusz at cisco.com
> wrote:

>   *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"*
>
>
>
>
>
>
>
> *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
> *
>
>
>
>
>
>
>
> *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*
>
>
>
>
>    From: Erick <ewellnitzvoip at gmail.com>
> Date: Monday, December 10, 2012 12:58 PM
> To: "cisco-voip at puck.nether.net" <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/fb330d8f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: BD5AE290-22A4-4CA8-8648-FC7063A04572.png
Type: image/png
Size: 15157 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20121210/fb330d8f/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 811E0653-494D-4799-994A-A7B167D3E0BF.png
Type: image/png
Size: 10126 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20121210/fb330d8f/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 87642CF4-DD0A-451B-BBF6-D4C047F2CD74.png
Type: image/png
Size: 17849 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20121210/fb330d8f/attachment-0002.png>