Bulk dialed number to call type mapping

Answered Question
Aug 19th, 2010
User Badges:

Hi all,


any idea how can we map dialed numbers to call types in bulk?


Thanks in advance,

Correct Answer by gall00004 about 6 years 9 months ago

I will forewarn this post by saying Cisco states upfront that screwing this up may corrupt your database and that it shouldn't be done in production systems.  I have done this in the past for 10,000 dialed number mappings at one time, but would advise if you are going to do this, load a sample file first with a test Dialed Number ID and Call Type ID to ensure you have your process down pat.  While the tool is running, it skips bad records and while show you what errors you have, but still can be quite intimidating to run especially for the first time.


First, open excel and create a tab delimited text file (SampleImport.txt) with the following format:

DialedNumberID Item CallTypeID RegionID CEDWildCard ANIWildCard ANIWildCardType Description


**I have attached a sample file with a header row to give you an example, when importing I always remove the header row.  If you are unsure of what to put for each column, just do a SELECT * FROM Dialed_Number_Map in Query Analyzer and you'll see what the table currently contains.  In the columns that contain NULL, simply leave them blank in your spreadsheet, don't type NULL.**


Once you have your file set, go to command prompt, navigate to icm/bin and type -> BulkLoadConfig.exe Dialed_Number_Map "\SampleImport.txt"

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (3 ratings)
Loading.

No can do.


The easiest way to do this is as follows. Change the name of the call type you are going to map to the DNs to AAAA_calltype so it's at the top of the call type list. Open the Dialed Number/Script Selector tool and set up a search filter that just retrieves the ones to map to said call type. Then go to the tab for the call type mapping and press "Add". The AAAA_calltype will be at the top, so just press Enter, and Enter again. select the next dialed number - repeat.


Once you have done them all, go back and reset the name of the call type.


I always do this for mass changes - it saves a ton of time in the silly call type drop down.


For small numbers of changes, remember that once you pop the combo box open, typing a letter will drive it down to the first call type that starts with said letter. Depending on your naming convention, this can also save much time.


Regards,

Geoff

david.macias Thu, 08/19/2010 - 06:18
User Badges:
  • Blue, 1500 points or more

No way of doing it from what I have seen, you'll have to do this the old fashion way.


david

Correct Answer
gall00004 Thu, 08/19/2010 - 07:59
User Badges:

I will forewarn this post by saying Cisco states upfront that screwing this up may corrupt your database and that it shouldn't be done in production systems.  I have done this in the past for 10,000 dialed number mappings at one time, but would advise if you are going to do this, load a sample file first with a test Dialed Number ID and Call Type ID to ensure you have your process down pat.  While the tool is running, it skips bad records and while show you what errors you have, but still can be quite intimidating to run especially for the first time.


First, open excel and create a tab delimited text file (SampleImport.txt) with the following format:

DialedNumberID Item CallTypeID RegionID CEDWildCard ANIWildCard ANIWildCardType Description


**I have attached a sample file with a header row to give you an example, when importing I always remove the header row.  If you are unsure of what to put for each column, just do a SELECT * FROM Dialed_Number_Map in Query Analyzer and you'll see what the table currently contains.  In the columns that contain NULL, simply leave them blank in your spreadsheet, don't type NULL.**


Once you have your file set, go to command prompt, navigate to icm/bin and type -> BulkLoadConfig.exe Dialed_Number_Map "\SampleImport.txt"

Actions

This Discussion

Related Content