CUCM 12 Bulk insert directory numbers without device

[rwesel]

Hi,

I want to insert DNs via BAT but without assign them to a device. I want to use the DNs later in Remote Destination Profiles and Remote Destinations.

Is it possible?

For RDPs and RDs I found it under Bulk Administration => Mobility... But where I can find it for Directory Numbers?

Thanks

[Nithin Eluvathingal]

You can create directory number from call routing>> Directory Number >>Add new

[rwesel]

Hi Nithin,

thanks, but this only work for consecutive numbers.

I have a bunch of numbers with different descriptions, alerting names etc. I thought I could insert them from a CSV file.

[lior look]

1. add one or two directory numbers manually on CUCM

2. go to bulk>import/export then export

3. check the directory number checkbox, give a name and run the job

4. go to file download page and download that file.

5. open the .tar on special folder and open the .csv by excel

6. add filters to remove all records except the unassigned dn as u configured before.

7. add new records with more directory numbers but validate that you set the same values on the other columns, of course you can change the descriptions, alternate names and so on. don't remove any of the columns

8. save the file.

because u have opened the file as csv, the Excel will ask u if to svme as csv and if u accept any lost of design settings like filters, colors, etc.. so click yes.

9. open the csv file again as text an check if that file is a valid csv file, it should contains many commas.

10. take the csv and the header file and package them to a new tar file.

11. upload the file to cucm as import/export object

12. go to bulk>import/export and then import

13. select the file that you upload and run the job

[rwesel]

Thanks, I'll give it a try.

[rwesel]

Unfortunately it doesn't work.

I created a CSV file, left the header.txt untouched and packed it to a tar.

tar cvf import-dn.tar header.txt directorynumber.csv

Then I uploaded it to CUCM and validated the file => succcess

==> Bulk Administration => Import/Export => Validate File
=========================================================
Validate Configuration Items
Begin Time : 10/13/2020 09:37:47
Failure Details :
FileName Error Code Error Description
-----------------------------------------------------------------------------------------
******** NO ERROR FOUND ********
Result Summary :
VALIDATE for 20 Records passed.
VALIDATE for 0 Records failed.
End Time : 10/13/2020 09:37:47

But the import failed:

==> Bulk Administration => Import/Export => Import
=========================================================
Import Configuration
Call Routing Data
Directory Number (Unassigned) = checked 
Override the existing configuration = checked

==> Bulk Administration => Job Scheduler
=========================================================
Import Configuration
Begin Time : 10/13/2020 09:39:26
Query :
IMPORT Directory Number (Unassigned) IN directorynumber.csv
Failure Details :
directorynumber Error Code Error Description
-----------------------------------------------------------------------------------------
directory number is not a supported field.
java.lang.NullPointerException

What do I miss?

[Roger Kallberg]

What is the use case for this? What’s your end goal for these numbers? If you’re going to use these later on RDPs why not just add the number together with the RDP?

[rwesel]

My goal is to configure a HuntPilot. Our problem is that we have to operate a CUCM and our old PBX
in parallel, so we have in the Line Group a mix of numbers already in CUCM directory and some numbers still in PBX.
The numbers of both systems are in the same numbering scheme, let's say +49301111-XXX.

My approach was to create the PBX number as DN. (+49301111-123)

Then create a Remote Destination Profile and assign the DN as Line.

Then assign a Remote Destination 9123 to the Line +49301111-123.

And a Route Pattern 9.XXX which directs the call from CUCM to the PBX.

This works and I could enter all the numbers and profiles etc manually.
But I want to do this via Bulk. So I thought I should do this in the same
order I would do it in the GUI (DN then RDP then RD).

If I can do it in another way I would do it.

[Roger Kallberg]

I see. For what you try to do I would recommend you to create it via the bulk import option for RDP, it will create the line also, and then import RDs that you assign a to the RDPs. The order you create configuration in the UI is not directly applicable to how bulk works. There are sample files in the system that should help you with how to format the files.

Best of luck with this.