Bulk Delete Directory Numbers

[tomanderson669208988]

Hello,

We are removing about 300 directory numbers from use. Is there a way to delete these directory numbers in bulk? They are not in a specific range and not all of them are currently unassigned.

Thank you.

[AbuAkif Riyaz]

Hi Tom Let check this, may help you

[Roger Kallberg]

Use the Custom File option and create a file that has all the directory numbers that you’d want to remove in one column on separate lines without any header. Aka it should just have the DNs, nothing else.

[tomanderson669208988]

I am familiar with creating these custom files. Once I have created the custom file, where within 'Bulk Administration' do I process that file? I have done this with phone configs before, but not with directory numbers only. Thank you for the reply.

[AbuAkif Riyaz]

Hi
Delete Unassigned DN from BAT Menu may help in this condition.

[Roger Kallberg]

First you’d need to upload the file as the correct type, then look at the screen shot provided in the response from Mohamed, it’s shows where in bulk administration you use the custom file.

[Michael Stark]

That doesn't solve the problem "Delete Unassigned DN" just lets you delete all the DNs that are unassigned. That is a risky thing to do, Tom is asking if you can upload a file with specific DNs and delete just those. Is there a way to do that?

[scheived]

I found the easiest way to bulk delete a list of unassociated DN is using a succession of SQL commands,

run sql delete from numplan where dnorpattern ="DN" AND fkroutepartition ="PKID of RoutePattern"