Preface this by saying that this solution is not supported and you're going to get a warning banner.
You'll need to run some SQL queries and get a blank page ready. Essentially, what we're trying to do is mimic the Call_Type_Map table. If you run SELECT * FROM Call_Type_Map, you'll see the information that you need.
- CallTypeID
- Item
- MasterScriptID
- ScriptSchedule
- Description
| CallTypeID | Item | MasterScriptID | ScriptSchedule | Description |
You can open an Excel spreadsheet and put those five column headers into the first five columns in the spreadsheet. What we want is a tab delimited TXT file and using Excel is the most effective way because you don't want to screw this up.
CallTypeID
First thing you want are all the CallTypeIDs that you want to schedule to your script. If all your Call Types have something in common, then the query can be easy. It can be something like this SELECT * FROM Call_Type WHERE EnterpriseName LIKE '%.DN.%' If you can make the WHERE clause more granular, that'll be helpful, otherwise, copy and paste your results in a spreadsheet and remove what you don't need. Once you have your final list, take all your CallTypeIDs and copy/paste them in the CallTypeID column of your first spreadsheet (Call_Type_Map).
Item
Use 0 for all your rows. All this does is position your scheduled entry within the list of all entries.
MasterScriptID
You mentioned that you wanted to consolidate into one script, so this should be easy. If you know what your script name is, you can simply run this query SELECT * FROM Master_Script WHERE EnterpriseName = 'your_routing_script_name' You should be returned one row, and the primary key is the MasterScriptID, copy that four digit ID into your first spreadsheet (Call_Type_Map) and paste it for all the rows.
ScriptSchedule
This is the tricky one. The number you'll find in the Call_Type_Map table is a couple letters with a bunch of numbers - makes no sense to us really, but obviously it's system generated. You're only going to find this column in the Call_Type_Map table. So hopefully you already have number(s) scheduled to this script, otherwise, I advise that you do that first so that the system can generated a ScriptSchedule value for you. If a number is already scheduled, then either scroll through the table to find your MasterScriptID or run a query SELECT * FROM Call_Type_Map WHERE MasterScriptID = 'your_master_script_id' You should see the ScriptSchedule value the same. Copy that value into your first spreadsheet (Call_Type_Map) and paste it for all the rows.
Description
Leave this blank. This will have a NULL value in the table
It should all look something like this. Your values are obviously going to be different
| CallTypeID | Item | MasterScriptID | ScriptSchedule | Description |
| 5010 | 0 | 5003 | E207020B00000000000000000000010000070000 |
Once you're done, save the spreadsheet as a CSV file. Once you've exited Excel, rename the file extension as TXT open the file in Notepad and remove the headers so that all you have are the values. Failure to do so will make this bomb out. And make sure there's no return carriage at the top or bottom rows. Row 1 should immediately start with your values.
Once you're done, place that TXT file somewhere accessible on the AW, like on the root of C:\
Open a command prompt window as administrator and go to C:\icm\bin. Type in BulkLoadConfig.exe Call_Type_Map C:\<your_file_name.txt>.
Here's why it's not supported:
