Excel macro to bulk update directory numbers

[awrabek]

I m new to both AXL and VBS, but need to update the external number mask several directory numbers.

The idea is to put the numbers into column A in \+12123332222 format, and the script copies the actual DN into the external number mask filed if it is empty, otherwise no modification is done. Avoiding mask overriding is essential.

Does anyone have a predefined script that takes the number in the current cell, checks if it exists, checks its external number mask, and updates if empty?

[Roger Kallberg]

Not an answer to your question as such but normally you would not want to set the external number mask to the actual directory number. It would usually be set with a wild card match so that you can use regular bulk update functionality with a query per number range.

On your question, I do not think that you would be able to do this with Excel alone. Likely you’d be looking at using something like Python to consume the AXL API.

[awrabek]

Yepp, in this way numbers can be bulk updated. Thank you for the advice.

I ve seen some deployments intentionally populated external number mask field with the directory number. Is there any benefit to do so? Leaving it blank means using the DN itself for outbound calls.

[Roger Kallberg]

IMHO it’s pure lack of understanding how this setting operates if it’s set to the individual number as there would be no benefit to do that. One word of advice, just because you set the EPNM it won’t necessarily mean that it is what is used for calling number presentation. That depends on if you have set the transition or route pattern(s) to use the EPNM. Otherwise it would always use the directory number.

[techguy150]

Excel has a built-in tool for writing macros called the Visual Basic Editor—or VBA Editor for short. To open that, open a spreadsheet and use the shortcut Alt + F11 (for Mac: Fn + Shift + F11).

The new window that pops up is called the VBA Editor. It's where you'll edit and store all of your macros. Its layout may look a bit different from this screenshot, but you can move the windows around to the order you want. Just be sure to keep the Project Explorer pane open so you can easily edit your macros.

Your macros will be made up of "Modules," or files with your VBA code. You'll add a new module or open an existing one in the VBA Editor, then type in the code you want. To insert a module, click "Insert" and then click "Module". You'll then see the blank space to write your code on the right.

Regards,
TG