We're deploying a Cisco Unity VOIP system that pulls user phone #'s from the 'IP Phone' AD User Attribute, and currently do not have that attribute populated. We already have the 'Office Phone' populated for our users, so in principle the DTM job would be a simple AD->AD synch using the OfficePhone as the source and the IPPhone as the target, using the SAMAccount name as the key.
However, our OfficePhone attribute is populated in the "(512) 555-1212" format, and we need the IPPhone to be in a '915125551212' format. That is, we need to prepend all phone #'s with a '91' and then remove all parens, spaces, dashes, and other characters from the source, leaving a simple string of numbers that the Cisco VOIP can recognize and use. We're a nationwide company so we cross MANY area codes.
I imagine that this might be able to be done with a script but it's not my strongest skillset and I think it might be asking alot. Can anyone offer any suggestions?
We're seriously under the gun on this. While I'm easily able to do 1-time jobs using data manipulated in Excel, I'll need to integrate this into my daily automated AD synchs from our HR DB so this will work long term. Any help is appreciated, and if I should just open a case with support please let me know.
Thanks,
El Kabong