Dear Friends,
Microsoft Teams has been integrated with our CUCM. In Remote Destination Profile, I manually added 90 users and it works. I would like to add 1750 users as bulk administrators. I tried it with two users, but it gave the following error.
Please advice.
Accepted Solutions
This bugged me so much so I decided to build my own import file to verify that it worked. Eventually after a few tries and errors I got it to work with these files and a RDP template that you use for the import.
On the template you'll have to set a few mandatory things, like a user name, device pool and a line. See the screenshot for an example. Don't worry about what you set on the template as these values are then overwritten by the values in the CSV file.
Then when you run the import you select both a file and a template.
After you have got the RDP imported you run the RD import and it will tie to the RDP.
Please do note that these files are not using any of your data, these contain data that matches what I needed to get it imported on one of our systems.
Happy to hear that. Please do use the option to give Helpful votes on the posts that you think deserves that and if applicable please mark your question as solved.
Can you please share the file that your using for this so that we can validate the content? Most likely there is a mistake in the content or format of it as that is by far the most common cause of issues with bulk imports.
It might also help you out if you where to do an export of your current RDPs/RDs from bulk admin and use that as a template for how the import file should be formed. But please be warned that just because the file looks a certain way when exported it does not necessary mean that the import file will be crafted the same. This is one of the many small quirks with BAT that you just have to come to terms with. Only the BU at Cisco knows what the <bleep> goes into the mind of the developers of this fine tool.
I only checked the RDP file so far, didn't find a suitable RD file to compare with. If I compare it to a file that I have at hand for RDP it would look something along with this with the data from your first line.
| Remote Destination Profile Name | Description | User ID | Device Pool | CSS | User Hold MOH Audio Source | Network Hold MOH Audio Source | Privacy | Rerouting CSS | Use Device Pool Calling Party Transformation CSS | User Locale | Ignore Presentaion Indicators | DND Option | Do Not Disturb | Directory Number 1 | Route Partition 1 | Line Description 1 | Alerting Name 1 | ASCII Alerting Name 1 | Voice Mail Profile 1 | Line CSS 1 | Line Presence Group 1 | Line User Hold MOH Audio Source 1 | Line Network Hold MOH Audio Source 1 | AAR Voice Mail 1 | AAR Destination Mask 1 | AAR Group(Line) 1 | Retain this destination in call forwarding history 1 | Calling Search Space Activation Policy 1 | Forward All Voice Mail 1 | Forward All Destination 1 | Forward All CSS 1 | Secondary CSS for Forward All 1 | Forward Busy Internal Voice Mail 1 | Forward Busy Internal Destination 1 | Forward Busy Internal CSS 1 | Forward Busy External Voice Mail 1 | Forward Busy External Destination 1 | Forward Busy External CSS 1 | Forward No Answer Internal Voice Mail 1 | Forward No Answer Internal Destination 1 | Forward No Answer Internal CSS 1 | Forward No Answer External Voice Mail 1 | Forward No Answer External Destination 1 | Forward No Answer External CSS 1 | Forward No Coverage Internal Voice Mail 1 | Forward No Coverage Internal Destination 1 | Forward No Coverage Internal CSS 1 | Forward No Coverage External Voice Mail 1 | Forward No Coverage External Destination 1 | Forward No Coverage External CSS 1 | Forward on CTI Failure Voice Mail 1 | Forward on CTI Failure Destination 1 | Forward on CTI Failure CSS 1 | Forward Unregistered Internal Voice Mail 1 | Forward Unregistered Internal Destination 1 | Forward Unregistered Internal CSS 1 | Forward Unregistered External Voice Mail 1 | Forward Unregistered External Destination 1 | Forward Unregistered External CSS 1 | Forward No Answer Ring Duration 1 | Call Pickup Group 1 | MLPP Target 1 | MLPP CSS 1 | MLPP No Answer Ring Duration 1 | Hold Reversion Ring Duration 1 | Hold Reversion Notification Interval 1 | Display 1 | ASCII Display 1 | External Phone Number Mask 1 | Maximum Number of Calls 1 | Busy Trigger 1 | Caller Name 1 | Caller Number 1 | Redirected Number 1 | Dialed Number 1 | Park Monitor Forward No Retrieve Ext Destination 1 | Park Monitor Forward No Retrieve Int Destination 1 | Park Monitor Forward No Retrieve Int Voice Mail 1 | Park Monitor Forward No Retrieve Ext Voice Mail 1 | Park Monitor Forward No Retrieve Ext CSS 1 | Park Monitoring Reversion Timer 1 | Park Monitor Forward No Retrieve Int CSS 1 | Party Entrance Tone 1 | Directory Number 2 | Route Partition 2 | Line Description 2 | Alerting Name 2 | ASCII Alerting Name 2 | Voice Mail Profile 2 | Line CSS 2 | Line Presence Group 2 | Line User Hold MOH Audio Source 2 | Line Network Hold MOH Audio Source 2 | AAR Voice Mail 2 | AAR Destination Mask 2 | AAR Group(Line) 2 | Retain this destination in call forwarding history 2 | Calling Search Space Activation Policy 2 | Forward All Voice Mail 2 | Forward All Destination 2 | Forward All CSS 2 | Secondary CSS for Forward All 2 | Forward Busy Internal Voice Mail 2 | Forward Busy Internal Destination 2 | Forward Busy Internal CSS 2 | Forward Busy External Voice Mail 2 | Forward Busy External Destination 2 | Forward Busy External CSS 2 | Forward No Answer Internal Voice Mail 2 | Forward No Answer Internal Destination 2 | Forward No Answer Internal CSS 2 | Forward No Answer External Voice Mail 2 | Forward No Answer External Destination 2 | Forward No Answer External CSS 2 | Forward No Coverage Internal Voice Mail 2 | Forward No Coverage Internal Destination 2 | Forward No Coverage Internal CSS 2 | Forward No Coverage External Voice Mail 2 | Forward No Coverage External Destination 2 | Forward No Coverage External CSS 2 | Forward on CTI Failure Voice Mail 2 | Forward on CTI Failure Destination 2 | Forward on CTI Failure CSS 2 | Forward Unregistered Internal Voice Mail 2 | Forward Unregistered Internal Destination 2 | Forward Unregistered Internal CSS 2 | Forward Unregistered External Voice Mail 2 | Forward Unregistered External Destination 2 | Forward Unregistered External CSS 2 | Forward No Answer Ring Duration 2 | Call Pickup Group 2 | MLPP Target 2 | MLPP CSS 2 | MLPP No Answer Ring Duration 2 | Hold Reversion Ring Duration 2 | Hold Reversion Notification Interval 2 | Display 2 | ASCII Display 2 | External Phone Number Mask 2 | Maximum Number of Calls 2 | Busy Trigger 2 | Caller Name 2 | Caller Number 2 | Redirected Number 2 | Dialed Number 2 | Park Monitor Forward No Retrieve Ext Destination 2 | Park Monitor Forward No Retrieve Int Destination 2 | Park Monitor Forward No Retrieve Int Voice Mail 2 | Park Monitor Forward No Retrieve Ext Voice Mail 2 | Park Monitor Forward No Retrieve Ext CSS 2 | Park Monitoring Reversion Timer 2 | Park Monitor Forward No Retrieve Int CSS 2 | Party Entrance Tone 2 | Directory Number 3 | Route Partition 3 | Line Description 3 | Alerting Name 3 | ASCII Alerting Name 3 | Voice Mail Profile 3 | Line CSS 3 | Line Presence Group 3 | Line User Hold MOH Audio Source 3 | Line Network Hold MOH Audio Source 3 | AAR Voice Mail 3 | AAR Destination Mask 3 | AAR Group(Line) 3 | Retain this destination in call forwarding history 3 | Calling Search Space Activation Policy 3 | Forward All Voice Mail 3 | Forward All Destination 3 | Forward All CSS 3 | Secondary CSS for Forward All 3 | Forward Busy Internal Voice Mail 3 | Forward Busy Internal Destination 3 | Forward Busy Internal CSS 3 | Forward Busy External Voice Mail 3 | Forward Busy External Destination 3 | Forward Busy External CSS 3 | Forward No Answer Internal Voice Mail 3 | Forward No Answer Internal Destination 3 | Forward No Answer Internal CSS 3 | Forward No Answer External Voice Mail 3 | Forward No Answer External Destination 3 | Forward No Answer External CSS 3 | Forward No Coverage Internal Voice Mail 3 | Forward No Coverage Internal Destination 3 | Forward No Coverage Internal CSS 3 | Forward No Coverage External Voice Mail 3 | Forward No Coverage External Destination 3 | Forward No Coverage External CSS 3 | Forward on CTI Failure Voice Mail 3 | Forward on CTI Failure Destination 3 | Forward on CTI Failure CSS 3 | Forward Unregistered Internal Voice Mail 3 | Forward Unregistered Internal Destination 3 | Forward Unregistered Internal CSS 3 | Forward Unregistered External Voice Mail 3 | Forward Unregistered External Destination 3 | Forward Unregistered External CSS 3 | Forward No Answer Ring Duration 3 | Call Pickup Group 3 | MLPP Target 3 | MLPP CSS 3 | MLPP No Answer Ring Duration 3 | Hold Reversion Ring Duration 3 | Hold Reversion Notification Interval 3 | Display 3 | ASCII Display 3 | External Phone Number Mask 3 | Maximum Number of Calls 3 | Busy Trigger 3 | Caller Name 3 | Caller Number 3 | Redirected Number 3 | Dialed Number 3 | Park Monitor Forward No Retrieve Ext Destination 3 | Park Monitor Forward No Retrieve Int Destination 3 | Park Monitor Forward No Retrieve Int Voice Mail 3 | Park Monitor Forward No Retrieve Ext Voice Mail 3 | Park Monitor Forward No Retrieve Ext CSS 3 | Park Monitoring Reversion Timer 3 | Park Monitor Forward No Retrieve Int CSS 3 | Party Entrance Tone 3 | Directory Number 4 | Route Partition 4 | Line Description 4 | Alerting Name 4 | ASCII Alerting Name 4 | Voice Mail Profile 4 | Line CSS 4 | Line Presence Group 4 | Line User Hold MOH Audio Source 4 | Line Network Hold MOH Audio Source 4 | AAR Voice Mail 4 | AAR Destination Mask 4 | AAR Group(Line) 4 | Retain this destination in call forwarding history 4 | Calling Search Space Activation Policy 4 | Forward All Voice Mail 4 | Forward All Destination 4 | Forward All CSS 4 | Secondary CSS for Forward All 4 | Forward Busy Internal Voice Mail 4 | Forward Busy Internal Destination 4 | Forward Busy Internal CSS 4 | Forward Busy External Voice Mail 4 | Forward Busy External Destination 4 | Forward Busy External CSS 4 | Forward No Answer Internal Voice Mail 4 | Forward No Answer Internal Destination 4 | Forward No Answer Internal CSS 4 | Forward No Answer External Voice Mail 4 | Forward No Answer External Destination 4 | Forward No Answer External CSS 4 | Forward No Coverage Internal Voice Mail 4 | Forward No Coverage Internal Destination 4 | Forward No Coverage Internal CSS 4 | Forward No Coverage External Voice Mail 4 | Forward No Coverage External Destination 4 | Forward No Coverage External CSS 4 | Forward on CTI Failure Voice Mail 4 | Forward on CTI Failure Destination 4 | Forward on CTI Failure CSS 4 | Forward Unregistered Internal Voice Mail 4 | Forward Unregistered Internal Destination 4 | Forward Unregistered Internal CSS 4 | Forward Unregistered External Voice Mail 4 | Forward Unregistered External Destination 4 | Forward Unregistered External CSS 4 | Forward No Answer Ring Duration 4 | Call Pickup Group 4 | MLPP Target 4 | MLPP CSS 4 | MLPP No Answer Ring Duration 4 | Hold Reversion Ring Duration 4 | Hold Reversion Notification Interval 4 | Display 4 | ASCII Display 4 | External Phone Number Mask 4 | Maximum Number of Calls 4 | Busy Trigger 4 | Caller Name 4 | Caller Number 4 | Redirected Number 4 | Dialed Number 4 | Park Monitor Forward No Retrieve Ext Destination 4 | Park Monitor Forward No Retrieve Int Destination 4 | Park Monitor Forward No Retrieve Int Voice Mail 4 | Park Monitor Forward No Retrieve Ext Voice Mail 4 | Park Monitor Forward No Retrieve Ext CSS 4 | Park Monitoring Reversion Timer 4 | Park Monitor Forward No Retrieve Int CSS 4 | Party Entrance Tone 4 |
| RDP-Raja | Naga Raju Lingam Guntla | n.guntla | hardnet-SALM-DP | hardnet-LCL-CSS | 1 | 1 | Default | CW_Mobility_Reroute_CSS | t | f | Call Reject | f | 99501 | hardnet-USRS-PT | Naga Raju Lingam Guntla | Naga Raju Lingam Guntla | Standard Presence group | f | t | f | f | f | f | f | f | f | f | f | f | Naga Raju Lingam Guntla | 2 | 2 | Default | Default | Default | Default | f | f | Default |
For simplicity I removed all your call forward information, if you need that please make sure you add it back.
One comment on your file, you should not use the same CSS for Rerouting CSS as for calls from the RDP. These are two distinct different use cases. The Reroute CSS is used to make calls to the number defined on the RD and the CSS is used for call made from the RDP, ie when you get a call in reverse and the calling number matches the number set as the destination on the RD.
Also please remember that the ASCII fields have a limited length for what they can contain, as do some other fields as well. Best is to verify this in the webUI per field so that you don't use longer values than what is possible.
Found a RD file to do the same check. This is how I would have put the RD file based on your first line of data.
| NAME | DELAY BEFORE RINGING TIMER | REMOTE DESTINATION PROFILE | TIME ZONE | DUAL MODE DEVICE | MOBILE SMART CLIENT | CTI REMOTE DEVICE | DESTINATION | ANSWER TOO SOON TIMER | ANSWER TOO LATE TIMER | IS MOBILE PHONE | ENABLE MOBILE CONNECT 1 | ASSOCIATED LINE NUMBER 1 | ROUTE PARTITION 1 | MOBILITY PROFILE | SINGLE NUMBER REACH VOICEMAIL POLICY | DIAL-VIA-OFFICE REVERSE VOICEMAIL POLICY |
| RD-Raja | 4000 | RDP-Raja | Etc/GMT | NULL | 899501 | 1500 | 19000 | t | t | 99501 | hardnet-USRS-PT | Use System Default | Use System Default |
Sorry I forgot that saving CSV in Excel with the regional settings that we have in Sweden will put the delimiter as semicolon instead of a comma. Open the files in Notepad++, or whatever text editor you use, and do a replace of all ; with ,
What version of CM do you use? The error states that the name of the column "mobility user id" is wrong, likely it is called something else in your version of CM.
Try renaming the column "Mobility User ID" to "User ID" and run the import again. This is what I meant by that the content of an export file might not always match up with what is required in an import file. You simply need to do tries and correct what it complains about until you get it right.
Also try with this file for the RD part, I have reformatted it after a better example file that I dug up from my old bat files.
