any idea how can we map dialed numbers to call types in bulk?
Thanks in advance,
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"