Building Sonus Transformation Tables…fast…very fast!!!

If you have been using Sonus Session Border Controllers (Sonus SBC’s 1000/2000) for any amount of time you probably are well aware about the amount of time transformation table entries can consume. Anywhere from few minutes for couple of transformation table entries to few hours or even days if you have got couple of 100 to create. If  you have got 100’s of these transformation table entries to be copied across multiple SBC’s…well you are in for some serious fun!

Needless to say adding creating 100’s of transformation table entries manually via GUI is tedious, error prone and highly inefficient. It certainly doesn’t seem to be sort of thing you should be wasting your or your customers time in this day and age of automation, efficiency & cost cutting!

To take the pain out of building transformation table entries I have created an Excel spreadsheet – SonusSBCTransformationTableBuilder. It allows you to build Transformation table entries offline – anywhere, without access to the SBC.

You can also have base set of transformation rules ( e.g. UK, US, etc) and then re-use them in every deployment rather then manually creating them every time. You would require my SonusUX module to execute cmdlets.

Once you have downloaded the spreadsheet, make sure to read through the Instructions tab

image

The TransformationTableBuilder tab creates the actual transformation table entries. You enter your Input in the Red columns which will generate necessary cmdlets in the Green column.

image

Once you are done all you need to do is copy the generated cmdlets (from the Green column) and paste into the PowerShell session. Make sure before you paste the cmdlets you have imported the SonusUX module and established a connection to the Sonus SBC.

Other then creating new transformation table entries you can grab transformation table entries from existing SBC using get-uxtransformationtableentries cmdlet and export them. You can then import those transformation table entries back into the SBC using this spreadsheet. This is useful if you have got multiple SBC’s which need to have identical set of transformation tables entries.

Download link: The SonusSBCTransformationTableBuilder spreadsheet can be downloaded here.

Vik.

6 Thoughts on “Building Sonus Transformation Tables…fast…very fast!!!

  1. Pingback: Using Powershell 3.0 and REST to access Sonus SBC1000/2000 | CUsoon

  2. Kristof Rutten on 25/07/2014 at 06:41 said:

    Thanks a million for this one – so simple but saved me hours and hours of time.

  3. Albie Mills on 20/08/2014 at 12:50 said:

    Tasked with creating SIP trunks between gateways and registering over 90+ local SIP devices meant I would need to have created 600+ transformation entries! This has dramatically scaled down the time this would have taken and worked an absolute treat.

    My only suggestion would be to add in the Admin State as an option to create as a disabled entry rather than all being enabled as default.

    • Vik Jaswal on 16/09/2014 at 21:28 said:

      Great it was useful Albie!
      I looked at adding an option to Enable/Disable the rule when I initially created the Sonus module sometime ago but it was not straightforward to do. I certainly will have another look now as the REST API for Sonus has been updated to see if this is achievable.
      Thanks,
      Vik

  4. Mike Dickin on 15/09/2014 at 13:26 said:

    This is excellent Vik. Thanks for posting and saving us all loads of time!

    On a related theme I wonder if anyone has a nice solution to transformation of inbound UK ISDN numbers to E164 for Lync – specifically international numbers which don’t present with the 00 prefix code and so could in theory be a UK number without the leading 0?

    Thanks

    Mike

    • Vik Jaswal on 16/09/2014 at 21:25 said:

      Hi Mike,
      I am assuming you mean here CLI? Yes, ISDN providers may not send you 00 so you wouldn’t know if the call is national or International just by looking at the CLI. When this happens you can look at the “Call Numbering Type” field of the ISDN call. This field will have the appropriate tag – National or International. This is configurable in Sonus transformation tables
      Vik

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve this to prove you are not a bot * Time limit is exhausted. Please reload the CAPTCHA.

Post Navigation