|
0:00:14
|
Let's go ahead and take a little bit of a deeper look at BAT (Bulk Administration Tool)
|
|
0:00:19
|
Throughout the rest of the videos and modules,
|
|
0:00:20
|
you'll see us do a lot of utilization of BAT for things
|
|
0:00:25
|
such as updating entities that have similar characteristics like phones and particularly lines.
|
|
0:00:35
|
But right now, let's go ahead and take a look actually creating
|
|
0:00:40
|
some new phones in lines and possibly users.
|
|
0:00:45
|
So really this would be used on an original deployment
|
|
0:00:51
|
whether a green field deployment or whether a migration
|
|
0:00:54
|
and we would gather information from the N customer,
|
|
0:00:58
|
the client unless that, you know, for a consultant if our client happens
|
|
0:01:03
|
to be our in-house firm then that's fine, we could still view them as our client.
|
|
0:01:07
|
But we're gonna gather a number, a bit of information
|
|
0:01:10
|
and I typically actually provide my clients with a spreadsheet.
|
|
0:01:15
|
Now there is a spreadsheet associated with BAT,
|
|
0:01:17
|
we’ll take a look at that in just a moment if we go to Bulk Administration upload/download files
|
|
0:01:24
|
and we see the included with every CUCM installation the BAT.xlt.
|
|
0:01:30
|
So it’s an Excel template and it is used to generate the CSV files
|
|
0:01:37
|
that are then used in BAT to import new entities but that tool,
|
|
0:01:43
|
that spreadsheet can be a little bit, little bit overwhelming
|
|
0:01:51
|
for a new customer not to mention the fact that they could mess up some of the Macros possibly.
|
|
0:01:56
|
So we don’t really typically give that tool out to the users or that spreadsheet.
|
|
0:02:00
|
I typically come up with my own spreadsheet.
|
|
0:02:03
|
By the way, I already have this BAT.xlt downloaded.
|
|
0:02:08
|
So once we had done that and open it up
|
|
0:02:10
|
and I might add that you need to use Microsoft Windows-based Excel
|
|
0:02:18
|
and even if you can enable Macros on a Mac-based version of Excel,
|
|
0:02:23
|
they’re not gonna work in the same way.
|
|
0:02:25
|
These are specifically written in visual basic
|
|
0:02:28
|
and they have to be run on a Windows platform.
|
|
0:02:31
|
But I’ve got this open actually on Windows here and I actually hand out,
|
|
0:02:38
|
so this is the BAT tool or actually this is the BAT template, the xlt template.
|
|
0:02:43
|
I actually hand out a, sort of a pared down version that I’ve come up with myself
|
|
0:02:47
|
and I go ahead and lock certain fields.
|
|
0:02:50
|
So if you, if it’s a ‘Do not modify this column’ formula is used,
|
|
0:02:56
|
then I go ahead and if you try to modify it, I’ve protected the worksheet.
|
|
0:03:00
|
Not that they couldn’t break that but it just keeps honest people
|
|
0:03:03
|
from making a mistake in doing something.
|
|
0:03:05
|
But it takes, the required fields and optional fields that they might wish to fill in
|
|
0:03:12
|
and this is just one template that I use.
|
|
0:03:15
|
I have various modified versions and we start by stating what the E164 prefix is,
|
|
0:03:24
|
whether it has dashes or not, etc.
|
|
0:03:27
|
For instance 440-250- and this assuming that the user
|
|
0:03:34
|
or the phones are gonna have 4-digit extensions
|
|
0:03:42
|
and they have actually match with the DID’s that we have and if not,
|
|
0:03:48
|
how many DID digits are not included in the DN, etc.
|
|
0:04:01
|
You can take and use the various formulas in Excel to create fairly enhanced text or strings.
|
|
0:04:13
|
And so I used this along with the extensions that the user inputs and then from that,
|
|
0:04:20
|
I automatically create Concatenations in terms of a Line Text Label
|
|
0:04:22
|
if they want the display to show the extension as well as things like
|
|
0:04:28
|
external number for external Phone Number Mask, things of that nature.
|
|
0:04:35
|
Maybe I don’t want the dashes in there, etc.
|
|
0:04:38
|
But I use these various Concatenate and ‘If’ statements
|
|
0:04:42
|
to basically create the spreadsheet in the fields
|
|
0:04:49
|
that I’m gonna end up using in the BAT tool.
|
|
0:04:53
|
We’ll take a look here in just a moment in the BAT.xlt template how the user fields
|
|
0:04:58
|
or how the phone device fields are laid out
|
|
0:05:02
|
and there’s really a couple different ways that you can do things,
|
|
0:05:05
|
you can import just phones or you can import just users.
|
|
0:05:13
|
You would probably do both but you can do those separately
|
|
0:05:17
|
or you can import Phone-Users and the advantage,
|
|
0:05:23
|
there’s a little bit more complexity in terms of what you have
|
|
0:05:25
|
to take into account when you do Phone and Users all in the same page
|
|
0:05:29
|
but the obvious advantage or possibly not so obvious advantage
|
|
0:05:34
|
is the fact that we can import not only User Information
|
|
0:05:39
|
but also phone information, lines, phones, so the device of the phone, the line
|
|
0:05:45
|
or lines if there are multiple lines and the user all tied together and upon bulk import,
|
|
0:05:54
|
once it actually validates and imports, then everything is actually there provisioned
|
|
0:06:01
|
and they’re tied together.
|
|
0:06:02
|
So the device association is tied into the phone,
|
|
0:06:06
|
so the user has the phone as associated device primary line optionally you can set that.
|
|
0:06:12
|
The ability to have the phone associated with the user so by means of the owner user ID
|
|
0:06:22
|
as well as the associated with the user by means of the end of a line page
|
|
0:06:27
|
with a associate with this line.
|
|
0:06:29
|
So there’s a lot of advantages to handing out basically a Excel template
|
|
0:06:36
|
to a customer allowing them to fill in certain things and formulas fill in the rest
|
|
0:06:42
|
and then going ahead and copying just the actual data portion
|
|
0:06:48
|
over to your actual BAT template
|
|
0:06:50
|
and just make sure that you create your templates
|
|
0:06:54
|
that you’re handing out to your customers
|
|
0:06:55
|
to fill out unless they’re making you to do all the data entry
|
|
0:06:59
|
in which case as long as they provide you with existing user
|
|
0:07:05
|
or company list and extension, truly not that hard if you can get very creative.
|
|
0:07:12
|
I should say you can get very creative.
|
|
0:07:15
|
If you aren’t proficient with this,
|
|
0:07:17
|
and you’re gonna be doing a lot of Unified Communication rollouts,
|
|
0:07:21
|
it will very much benefit you to become really familiar with Excel
|
|
0:07:24
|
and the formulas or even just with the GREP
|
|
0:07:28
|
or SED serial editor abilities in many text editing tools
|
|
0:07:35
|
to manipulate data and position it in a proper way.
|
|
0:07:39
|
But anyway you would put this in a format that is consistent with
|
|
0:07:42
|
how you’re gonna import your user fields so that you can copy everything
|
|
0:07:46
|
and then paste it directly over in your BAT.xlt template.
|
|
0:07:55
|
So, let’s just take a look at this very briefly
|
|
0:07:58
|
because the first thing that the BAT.xlt Excel template that Cisco gives you to download,
|
|
0:08:05
|
the first page it opens up to is this tab-along at the bottom
|
|
0:08:08
|
and note all the tabs, there are many many more but the first one it opens up to
|
|
0:08:14
|
is the ‘Help’ they want you to read this and understand that the BAT.xlt is a very light tool
|
|
0:08:20
|
which won’t have any database return trips on the background to enforce rules.
|
|
0:08:24
|
So what this is saying is when you go to import data into BAT (Bulk Administration Tool),
|
|
0:08:33
|
whether you’re importing, let’s say Remote Destination Profiles
|
|
0:08:39
|
for use with Single Number Reach or Unified Connect,
|
|
0:08:45
|
whether you’re importing a bunch of bulk VG224’s and information,
|
|
0:08:49
|
Call Pick-up Groups, Client Matter Codes, Feature Access Codes
|
|
0:08:55
|
or Force Authorization Codes rather,
|
|
0:08:57
|
Intercom Information, Lines, Phones and Users together,
|
|
0:09:03
|
just Users, User Device Profiles for Extension Mobility, Phones,
|
|
0:09:08
|
all of these different things have very specific requirements
|
|
0:09:11
|
in terms of how can they be formatted.
|
|
0:09:13
|
And there’s a couple stages to deal with making sure
|
|
0:09:17
|
that you put them in the format ultimately that the CUCM database will properly accept
|
|
0:09:24
|
and it won’t cause any problem with the database.
|
|
0:09:26
|
In fact it won’t let you import anything that would cause problems with the database.
|
|
0:09:31
|
And they do this by a few different methods.
|
|
0:09:33
|
The first is this xlt template which is locked so you can only access,
|
|
0:09:41
|
just like you would create and give to your customers a version
|
|
0:09:44
|
that wouldn’t only give them a pared down versions of this
|
|
0:09:46
|
but give them certain fields that they could populate
|
|
0:09:51
|
and they couldn’t then mess with the fields that
|
|
0:09:55
|
or changes the fields that you had formulas in to create the information
|
|
0:10:00
|
the way you wanted it shown or displayed.
|
|
0:10:03
|
But Cisco locks you out of this in terms of editing certain fields
|
|
0:10:08
|
so that or editing the Macro so that it preserves the integrity of ensuring
|
|
0:10:15
|
that certain information is in the proper format.
|
|
0:10:19
|
Now it doesn’t, what’s it saying here that is that
|
|
0:10:21
|
it doesn’t actually go out to the CUCM database in the background
|
|
0:10:26
|
to actually enforce any additional rules in terms of other things that are important.
|
|
0:10:38
|
I can’t come up with any example right now but as we begin to look through it
|
|
0:10:41
|
maybe I’ll be able to point something out quickly.
|
|
0:10:44
|
So there is something that we do once we gone ahead
|
|
0:10:47
|
and import our data in this Excel template,
|
|
0:10:50
|
we’ll go ahead and input a little bit of data and that is to,
|
|
0:10:54
|
first of all, back in CUCM and the Bulk Administration Tool,
|
|
0:11:00
|
depending on what type of information we want to input,
|
|
0:11:03
|
so let’s say we are gonna input Phones,
|
|
0:11:07
|
we have to create a phone template with which to apply this import against.
|
|
0:11:14
|
So that certain things are all kept in a synonymous information entering
|
|
0:11:22
|
and so we’ll usually create multiple phone templates.
|
|
0:11:25
|
In fact let’s go take a look at a phone template real briefly.
|
|
0:11:28
|
We see that there are none so we have to create our own.
|
|
0:11:31
|
So the first thing is, we have to create a phone template
|
|
0:11:33
|
for each type of phone that we’re gonna import.
|
|
0:11:38
|
And so this is one of the things you know once I get my information from my user,
|
|
0:11:45
|
one of the things that I have on here I believe on this particular one,
|
|
0:11:50
|
I’ve got a few different templates that I hand out.
|
|
0:11:52
|
This is the one that I grabbed real quickly.
|
|
0:11:54
|
And you could see this is just an example that I hand out.
|
|
0:11:58
|
So rather all the examples, I’ve got 40’s and 60’s still on here but is the phone type.
|
|
0:12:04
|
So once the user has gone ahead and input all of their information
|
|
0:12:09
|
as well as the actual phones that their gonna be deploying for that particular user,
|
|
0:12:13
|
class of service, everything, I go ahead and then rearrange,
|
|
0:12:18
|
so you can see I have data sort fields here.
|
|
0:12:21
|
Let me go back to the phone type, I’ll rearrange the types by
|
|
0:12:29
|
It’s not clicking down right now.
|
|
0:12:30
|
I might have that protected right now.
|
|
0:12:32
|
In fact I believe I do so the user can’t change that
|
|
0:12:36
|
but it will rearrange it by the actual type of phone and then I’ll go ahead
|
|
0:12:41
|
and sort, well that is the sort but then I'll go ahead
|
|
0:12:44
|
and extract all the same types of phones,
|
|
0:12:47
|
all the data or all the rows for the same types of phones
|
|
0:12:52
|
and put them in the BAT tool to create my first CSV file
|
|
0:12:57
|
with which I will then import into the Bulk Administration Tool
|
|
0:13:05
|
against the template of that particular
|
|
0:13:14
|
Against that particular phone type that I just created a template for.
|
|
0:13:19
|
So I’ll have maybe a template for all my 7961’s
|
|
0:13:23
|
and I’ll have a template for all of my 9971’s or my 8961’s or whatever.
|
|
0:13:32
|
And I’ll have different templates and in fact we have to,
|
|
0:13:34
|
Let’s just go ahead and take a look at the template here.
|
|
0:13:36
|
Let’s just open up the 7961 for instance.
|
|
0:13:41
|
And we also have to have them per protocol and per phone.
|
|
0:13:47
|
Usually all the phones within an installation are single protocol.
|
|
0:13:50
|
Obviously there are certain ones if I go back
|
|
0:13:53
|
and create a new template against let say the phone type of 9971.
|
|
0:14:01
|
Then don’t ask me about that protocol because SIP is the only protocol
|
|
0:14:05
|
that the 9971’s run currently.
|
|
0:14:08
|
So given the name, all the information that’s gonna be common.
|
|
0:14:12
|
Now I might have additional information in terms of,
|
|
0:14:17
|
I might have a number of 9971’s that are slated for the Corporate Headquarter Office
|
|
0:14:25
|
and a number more that are slated for one of the branch offices
|
|
0:14:30
|
and a few more that are slated for a different branch office.
|
|
0:14:33
|
So I need a different template per phone and protocol and per common device information.
|
|
0:14:42
|
Of course I can use things like the common device configuration,
|
|
0:14:45
|
common phone profile, things of that nature.
|
|
0:14:48
|
Just getting a little bit more granular in what we can setup before we go ahead
|
|
0:14:52
|
and even setup the template and reference that.
|
|
0:14:56
|
But again I’m gonna need to have one per Device Pool
|
|
0:15:00
|
which would almost always most likely be per geographical location
|
|
0:15:06
|
and many times even multiple Device Pools per geographical location
|
|
0:15:10
|
if it’s really a large installation, etc.
|
|
0:15:13
|
So there’s gonna be a number of things.
|
|
0:15:14
|
I’m also gonna need to have per class of restriction.
|
|
0:15:17
|
So what you might begin to say is, wait a minute,
|
|
0:15:21
|
this sounds like a lot of work, first of all we’re studying it
|
|
0:15:26
|
for a certification exam so we pretty much need to know at least
|
|
0:15:31
|
how the functionality works even if we haven’t use BAT too many times
|
|
0:15:38
|
but at least what it can do and how it works and how we have to set everything up.
|
|
0:15:40
|
So that’s the first thing.
|
|
0:15:46
|
But beyond that, you might at some point in actually trying to use BAT
|
|
0:15:48
|
whether just studying for your exams or whether actually wanting to use it
|
|
0:15:55
|
or thinking it might be a good idea for your real life installations.
|
|
0:16:01
|
And then you might begin to say wait a minute this is a lot of work.
|
|
0:16:04
|
I have to create a separate template and input my information in this BAT Excel spreadsheet,
|
|
0:16:16
|
you know, let’s say I am creating my Phone-Users,
|
|
0:16:19
|
I have to put all these information in just for one phone type
|
|
0:16:24
|
and for one location and for one class of service each at a separate time
|
|
0:16:32
|
and that’s true in fact, that’s one of the reasons why I have sort of a more
|
|
0:16:37
|
or an all aggregating spreadsheet that I keep separated
|
|
0:16:40
|
that I use to create all the information and then sort it primary, secondary, by phone type
|
|
0:16:47
|
and then by class of service and then by, actually by phone type
|
|
0:16:51
|
and then by location then by class of service
|
|
0:16:55
|
or however you want do that primary, secondary, tertiary sorting
|
|
0:17:00
|
and without deleting any of the rest of the data,
|
|
0:17:03
|
I can just grab that subset and then copy it into the xlt file or BAT template rather
|
|
0:17:14
|
and then from that, what you’ll see as tool is then we will
|
|
0:17:19
|
after we create the file format we’ll actually export to the BAT format.
|
|
0:17:22
|
So export to a CSV file.
|
|
0:17:26
|
If you want, you can just put things directly into text in CSV.
|
|
0:17:31
|
That might be faster for you, I’ve not found that it is especially
|
|
0:17:34
|
because this prevents you from making mistakes
|
|
0:17:37
|
that ultimately won’t work when importing.
|
|
0:17:41
|
But you might begin to say this sounds like a lot of work.
|
|
0:17:44
|
And it is a lot of work, I’m not going to say that it’s not.
|
|
0:17:48
|
However if you’ve ever done any installation over a hundred phones
|
|
0:17:53
|
or you’re going to and especially when you get into 1000, 5000,
|
|
0:18:02
|
even larger, 10000 phones installations which I’ve certainly been a team lead on.
|
|
0:18:08
|
You will quickly even just a hundred phones
|
|
0:18:11
|
you’ll begin to see inputting a hundred phones
|
|
0:18:15
|
and again with a hundred phones you’ll probably have a lot less locations
|
|
0:18:19
|
and a lot less classes of services or just a few classes of services
|
|
0:18:23
|
I should say maybe 3 or 4 probably 4 is fairly common
|
|
0:18:29
|
and one or two or three or four possibly tops locations and only a few phone types.
|
|
0:18:34
|
So it really begins to dwindle the amount of work that it is.
|
|
0:18:38
|
But even doing that if you go and try to manually add into CUCM 100 phones
|
|
0:18:46
|
and then 100 users and then do device association for each user to each phone
|
|
0:18:52
|
and then go back to each phone and update each phone with the owner ID
|
|
0:18:56
|
and the lines with the associated owner.
|
|
0:18:58
|
You will be very quickly begin to see how much work it is
|
|
0:19:02
|
and how much room there is for human error.
|
|
0:19:06
|
Just tediously doing the same thing over and over
|
|
0:19:09
|
and acts as only putting the wrong class of service on someone’s call forward all,
|
|
0:19:16
|
restriction or even just their primary dialing or spelling someone’s name wrong.
|
|
0:19:21
|
or whatever that might be.
|
|
0:19:24
|
So it will really quickly begin to seem attractive to use BAT
|
|
0:19:30
|
even if it still is a good amount of work.
|
|
0:19:32
|
I mean on larger installations, let’s just say a 200 phone installation,
|
|
0:19:38
|
I might spend 2 full days on the Bulk Administration Tool
|
|
0:19:42
|
and I could maybe only about 1 day actually formatting and inputting everything.
|
|
0:19:48
|
You know maybe a day gathering information from the customer
|
|
0:19:50
|
and a day inputting everything into the database.
|
|
0:19:53
|
You might say 2 days is a lot, I could probably very quickly input 200 phones in two days
|
|
0:20:00
|
or hundred phones a day.
|
|
0:20:00
|
It’s true but it will not only become so mundane that,
|
|
0:20:07
|
maybe just find a separate data entry person and really navigate everything in CUCM well
|
|
0:20:13
|
and do it a lower level tap but it will also just begin
|
|
0:20:21
|
to that mundane monotony will begin to
|
|
0:20:27
|
almost always inherently generate errors, just human errors.
|
|
0:20:32
|
So the BAT tool can really be quite useful.
|
|
0:20:35
|
Breaks up the monotony and it can make things go really well.
|
|
0:20:37
|
If you have a thousand or more phones,
|
|
0:20:39
|
I’ve done five thousand phones multiple times
|
|
0:20:42
|
and a few 10000 phones installs I’ve worked with
|
|
0:20:46
|
and you will very quickly become in love with the BAT tool.
|
|
0:20:52
|
But anyhow, so it tells you it mainly kept as light as possible
|
|
0:20:56
|
so that CSV creation can be quick.
|
|
0:20:59
|
And then validations will kept at a minimum here in this Excel template
|
|
0:21:02
|
and it’s up to the user to provide the proper data for the CSV creation.
|
|
0:21:07
|
Once we’ve actually created our templates with which to import this phones
|
|
0:21:13
|
or Phone-User combos against, we also have to, after we’ve uploaded the CSV files
|
|
0:21:20
|
that we need, we’ll add new and we’ll choose
|
|
0:21:25
|
from our local files system where we store those files.
|
|
0:21:31
|
Select whether there, the target of those files are gonna be placed in the phone area,
|
|
0:21:37
|
the users area or the phone users area or anything else.
|
|
0:21:42
|
Gateways, a great thing to import, plenty of other things.
|
|
0:21:46
|
By the way, import/export, that’s for importing and exporting
|
|
0:21:50
|
all the information in the database.
|
|
0:21:51
|
You typically don’t want to use that area
|
|
0:21:53
|
unless of course you’re just trying to do just that.
|
|
0:21:57
|
Import or export the entire configuration of the system.
|
|
0:22:02
|
And then let’s say we’re doing phone-users,
|
|
0:22:06
|
this is for an insert into the database of the Phones and Users.
|
|
0:22:10
|
And we’ll add that information.
|
|
0:22:13
|
What we’ll do next is we will do, a validate the information.
|
|
0:22:20
|
So actually we’ll probably come to Phones and Users
|
|
0:22:24
|
and validate these Phones and Users.
|
|
0:22:26
|
Before we do that, we’re actually going to create what’s called a file format.
|
|
0:22:31
|
So let me just back up and we’ve kind of just touched on
|
|
0:22:35
|
really quickly a number different things.
|
|
0:22:37
|
Let me back up and state the order that we would use
|
|
0:22:40
|
for inserting new records into the database for Phones and Users.
|
|
0:22:45
|
First we’d come to file upload/download and we would download for the version of CUCM
|
|
0:22:57
|
that you’re on if you’ve even updated any maintenance release or anything,
|
|
0:23:02
|
make sure you update your BAT template because there could be a change there.
|
|
0:23:15
|
There could be a change to the template so download a new format
|
|
0:23:19
|
then we’re going to, of course we’re going to gather the information from our customers
|
|
0:23:25
|
so really that might be, actually that wouldn’t necessarily be step one
|
|
0:23:30
|
because they might want different fields more or less than
|
|
0:23:34
|
what you currently have in your information gathering template.
|
|
0:23:40
|
So we’ll download the BAT template, we’ll ask the customer and meet with them
|
|
0:23:44
|
and find out what it is, what type of information
|
|
0:23:48
|
they want inputted to the system right away.
|
|
0:23:52
|
They may only want lines put in and users are gonna add their speed dials later.
|
|
0:23:58
|
Or they may want you to go ahead and input the speed dials now.
|
|
0:24:01
|
All that information is important.
|
|
0:24:04
|
Then we’re gonna come over to Bulk Administration Tool,
|
|
0:24:05
|
let’s just say Phones and Users and come to the Phones-Users file format
|
|
0:24:10
|
and add a file format.
|
|
0:24:13
|
So we’re going to, first of all
|
|
0:24:22
|
We have a file format name here.
|
|
0:24:24
|
Let’s actually go take a look at these two file formats.
|
|
0:24:28
|
So default phone and simple phone.
|
|
0:24:30
|
The file name is actually the BAT file that we are going to be importing.
|
|
0:24:38
|
But we’ll come over to Phones and then to file format rather than to Phones and Users.
|
|
0:24:47
|
But come to phones, phone file format and create file format
|
|
0:24:52
|
and we can take a look and see that there are already two defaults
|
|
0:24:55
|
and we can add new ones or we can even copy these existing ones
|
|
0:24:59
|
to utilize what they already have.
|
|
0:25:01
|
But let’s just take a look at one of these.
|
|
0:25:03
|
And so what we have are for the device, the line and then intercom DN’s
|
|
0:25:14
|
and then as well as certain things specific to the phone like the maximum number of lines
|
|
0:25:20
|
or maximum number of Speed Dials, BLF, Speed Dials,
|
|
0:25:23
|
Directed Call Parks, Phone Services, etc.
|
|
0:25:27
|
And for each of these main sections,
|
|
0:25:30
|
we have basically the available fields and then what fields we’ve selected
|
|
0:25:34
|
that we’re actually to input information against.
|
|
0:25:38
|
So we may not and probably will not have information for every single feature.
|
|
0:25:45
|
We can obviously scroll down here and see, there’s things like Built in Bridge.
|
|
0:25:50
|
Unless we’re gonna change that to True or False for every single phone
|
|
0:25:55
|
that we’re gonna import against these particular file format
|
|
0:25:57
|
and maybe that’s something we desire to do, maybe not.
|
|
0:26:00
|
Then we’ll probably leave this to the default which is Default
|
|
0:26:05
|
and that therefore goes back to the CUCM service parameters
|
|
0:26:13
|
and says what is the default for all phones in the case of built in bridge.
|
|
0:26:17
|
By default it’s off.
|
|
0:26:19
|
But we can change that in service parameters for all phones.
|
|
0:26:23
|
Unless we just want a certain subset of phones to be on
|
|
0:26:26
|
and not necessarily all of it.
|
|
0:26:28
|
So because of that, they don’t force you to use every single available field
|
|
0:26:33
|
which could obviously be a great deal more data entry work for you.
|
|
0:26:38
|
Because for each field, we might need to have data.
|
|
0:26:42
|
It depends on whether the xlt template when we go back to the template.
|
|
0:26:47
|
It well tell us some fields are mandatory as we see there
|
|
0:26:54
|
and some fields are optional. So some fields we have to put in and some fields we don’t.
|
|
0:27:01
|
And what this is doing the phone file format here, let’s say we have device description
|
|
0:27:07
|
and location and back in the BAT template,
|
|
0:27:10
|
let's actually just look at Phones here for a moment
|
|
0:27:13
|
and here we only see two columns.
|
|
0:27:16
|
MAC address which is mandatory and description which is optional.
|
|
0:27:20
|
Well we have to have more information than that just to input the device into CUCM.
|
|
0:27:24
|
We have to have Calling Search Space, things of that nature, right?
|
|
0:27:29
|
Well but that’s we’re we can create templates, right?
|
|
0:27:32
|
We can create a template we took a look at, the phone template.
|
|
0:27:38
|
And the phone template again
|
|
0:27:41
|
let's just say 9971 for instance
|
|
0:27:46
|
might have information like a Calling Search Space.
|
|
0:27:50
|
It also might have things like AAR Calling Search Space.
|
|
0:27:55
|
But we don’t have to provision this here.
|
|
0:27:58
|
Anything with an asterisk we have to provision.
|
|
0:28:00
|
It’s a require field. Anything else, we don’t have to provision in the template.
|
|
0:28:06
|
We can provision it in the BAT tool.
|
|
0:28:11
|
So it gives us the option if we want to create a template
|
|
0:28:13
|
that is common to all class of restrictions, we can do it there
|
|
0:28:18
|
or we can actually state that information specific per the actual CSV file
|
|
0:28:25
|
that we’re creating from this xlt template.
|
|
0:28:28
|
Now we do have to still have at the minimum one template per device type and protocol.
|
|
0:28:38
|
But for locations and class of service that I talked about earlier,
|
|
0:28:42
|
so things like let's say Device Pool and Calling Search Space.
|
|
0:28:57
|
There’s certain information that we’ll be able to override from here in the template
|
|
0:29:00
|
but we have to add those columns.
|
|
0:29:03
|
So we’re going to populate this information here
|
|
0:29:09
|
and we’re going to export the CSV file and then when we import it back to CUCM,
|
|
0:29:16
|
we must import it against a particular template and against a particular file format.
|
|
0:29:25
|
And we have to, we don’t have to but we’d be very fooling not to validate it
|
|
0:29:31
|
and that’s one of the other steps that we’ll talk about.
|
|
0:29:35
|
Before we actually import, we’ll do a validate Phones
|
|
0:29:39
|
or validate Users or validate Phones and Users together
|
|
0:29:43
|
and that would validate it against the file format and against the CSV file,
|
|
0:29:48
|
the actual data file that we’ve input.
|
|
0:29:50
|
So here let's say we have Device Name, Description, Location.
|
|
0:29:54
|
We also want to have AAR CSS and AAR Group
|
|
0:30:00
|
and we won’t get too crazy here but just Calling Search Space.
|
|
0:30:04
|
Maybe also calling party transformation search space.
|
|
0:30:07
|
Now maybe we want a lot of other information, that’s fine.
|
|
0:30:10
|
Device Pool, let's go ahead and add that.
|
|
0:30:12
|
But I can have this information and it is in a certain order.
|
|
0:30:18
|
So Device Name is first, the order of the selected fields.
|
|
0:30:23
|
Well first of all let me just say whatever selected fields I have here in my file format
|
|
0:30:28
|
need to match the file fields that I have here in my xlt template.
|
|
0:30:34
|
And I don’t see anymore, how do I add them?
|
|
0:30:36
|
I go to create file format and this looks fairly similar, right?
|
|
0:30:41
|
AAR CSS and AAR Group.
|
|
0:30:45
|
So we’ve added this information here.
|
|
0:30:48
|
It was also here.
|
|
0:30:49
|
Location was here and these orders need to match.
|
|
0:30:52
|
So this Device Name is first, Description second, Location third,
|
|
0:30:56
|
AAR CSS then AAR group.
|
|
0:30:59
|
Here I have MAC address or Device Name first, Description second.
|
|
0:31:03
|
I need location in the middle there then AAR CSS, then AAR Group.
|
|
0:31:09
|
So let's find location and it’s in not the order that you would find it on the phone page
|
|
0:31:16
|
but rather it’s in an alphabetical order.
|
|
0:31:18
|
But I need to put location in between Description and AAR CSS
|
|
0:31:22
|
so I just have to move it up.
|
|
0:31:24
|
Or I could have gone over here to this webpage and simply move location down.
|
|
0:31:31
|
Either one works but they need to match.
|
|
0:31:35
|
So that’s what my device fields, my line fields
|
|
0:31:38
|
and my intercom fields need to match my device fields for the file format.
|
|
0:31:44
|
My line fields which we can see we have a number of things here.
|
|
0:31:50
|
I need to make sure at least all of those unless I want to remove something,
|
|
0:31:54
|
maybe I don’t want Display I can remove that in the available
|
|
0:31:57
|
but not in the selected line fields.
|
|
0:32:00
|
But I need to make sure whatever I have selected
|
|
0:32:03
|
is also present here in these selected line fields and again in the same order
|
|
0:32:09
|
and then again I have my intercom DN fields.
|
|
0:32:12
|
And then I just need to make sure that this IP phone maximums,
|
|
0:32:16
|
this information matches up not with what we find here,
|
|
0:32:20
|
and by the way since I went ahead and added,
|
|
0:32:23
|
we can see behind me MAC and Description were all that were there.
|
|
0:32:26
|
I added location, AAR CSS and AAR Group.
|
|
0:32:29
|
But if I hit create, what we’ll see, yes I wish to override it.
|
|
0:32:34
|
Is it’s performing the visual basic Macro in the background to this additional columns.
|
|
0:32:41
|
But then I also have this information here.
|
|
0:32:45
|
Maximum number of phone lines, intercom lines, speed dial, etc.
|
|
0:32:50
|
that’s what I see over here, down here in my IP phone maximum area.
|
|
0:32:56
|
So all these needs to match.
|
|
0:33:00
|
Maximum number of lines.
|
|
0:33:02
|
I have one as soon as I tab away from this.
|
|
0:33:08
|
It says 'Please add the intercom line fields before selecting the number of lines.'
|
|
0:33:13
|
Well maybe I don’t want any intercom lines, so I’m gonna say 0.
|
|
0:33:25
|
Sorry, it’s saying for the file format, I need to specify which line fields are there.
|
|
0:33:32
|
So let's put at least Directory Number and display and Line Text Label.
|
|
0:33:42
|
So Directory Number, Display and let's just grab Line Text Label here very briefly
|
|
0:33:54
|
and from here we’ll go ahead and remove.
|
|
0:33:57
|
Actually we can’t really modify anything here.
|
|
0:33:59
|
We need to do a copy first and save it as new test phone format.
|
|
0:34:07
|
So device name, description, location, what else did I have?
|
|
0:34:13
|
There’s actually no problem here.
|
|
0:34:15
|
It always default back to its default so we really want to come in here
|
|
0:34:18
|
and add this information the first time.
|
|
0:34:20
|
It doesn’t read what’s currently laid out which is device name
|
|
0:34:26
|
then description, location, AAR CSS, AAR Group.
|
|
0:34:29
|
It just has the default every time which is just these two and nothing else.
|
|
0:34:34
|
So we wanted these two as well and location.
|
|
0:34:39
|
This will be enough for us and we’re gonna have Directory Number Line Text Label
|
|
0:34:45
|
and that will be all that we want.
|
|
0:34:47
|
We’ll override it.
|
|
0:34:54
|
And so here we’ll have this information, device name,
|
|
0:34:57
|
description, location, AAR CSS and Group
|
|
0:35:02
|
and then Directory Number Line Text Label and everything else here.
|
|
0:35:06
|
Everything else were simply going to get rid of.
|
|
0:35:10
|
So we only have these three selected.
|
|
0:35:12
|
Nothing for intercom will have one line and
|
|
0:35:16
|
let's say two BLF speed dials and we’ll say save.
|
|
0:35:19
|
So this is the new phone file format that we’re gonna use when we then go back to
|
|
0:35:27
|
Phones and Users, add file format, after we’ve imported the file
|
|
0:35:32
|
that we’ve exported from the xlt template.
|
|
0:35:36
|
We’ve imported it to the CUCM through the upload/download.
|
|
0:35:40
|
That file will appear and we’ll have our new test phone format.
|
|
0:35:46
|
So we’re just gonna do phones right now.
|
|
0:35:48
|
We’re not gonna look at Phones and Users
|
|
0:35:50
|
because there are few differences obviously user specific information.
|
|
0:35:55
|
So we’ll state maximum number of phone lines as one
|
|
0:35:58
|
and maximum number of BLF speed dials.
|
|
0:36:01
|
So every time we click away from something, it’s going to update that
|
|
0:36:15
|
and maximum BLF speed dials is going to be two I think we had said.
|
|
0:36:29
|
So we’ll go ahead and enter our MAC address and for the Bulk Administration Tool,
|
|
0:36:38
|
one of the best for MAC address entry is,
|
|
0:36:42
|
First of all when this imports into the database,
|
|
0:36:45
|
it’s not gonna import everything as SEP MAC address,
|
|
0:36:50
|
that’s the actual device name.
|
|
0:36:52
|
It’s gonna import everything as BAT MAC address.
|
|
0:36:56
|
Well actually I should say we have the option on this template.
|
|
0:37:00
|
Do we want to create dummy MAC addresses or do we want to use the real one?
|
|
0:37:05
|
So if we don’t tic this box, it will import everything as actual SEP MAC address.
|
|
0:37:12
|
But if use dummy MAC address, then we don’t have to necessarily import anything.
|
|
0:37:25
|
We put in the MAC addresses but it actually imports everything
|
|
0:37:28
|
as I was saying in the BAT MAC address format for the device name
|
|
0:37:33
|
rather than the SEP MAC address format.
|
|
0:37:36
|
And the benefit of this is we already scanned,
|
|
0:37:40
|
we've got all of our boxes of phones that were delivered
|
|
0:37:44
|
and hopefully we’ll have a USB barcode scanner or some sort of scanner
|
|
0:37:49
|
and we’ll grab all of the MAC addresses in the order that we want them,
|
|
0:37:54
|
we probably gone ahead and put them in our own formatting field.
|
|
0:38:00
|
Leave blank for admin, they’ll put the MAC addresses in here
|
|
0:38:04
|
and we’ll scan those according to device type but in terms of the MAC address just random
|
|
0:38:10
|
but then we’ll mark the name of the user that this phone is going to be deployed to
|
|
0:38:20
|
so that then when our team of field engineers goes out and actually deploys the phones,
|
|
0:38:27
|
takes them out of their box at the users’ desk and set it up and connects it,
|
|
0:38:31
|
the phone will try to auto-register with the CUCM,
|
|
0:38:37
|
with its device name which is its SEP MAC address.
|
|
0:38:41
|
Now if we’ve already input that into the database, then that’s fine.
|
|
0:38:45
|
But it’s also possible that we can also use dummy MAC addresses
|
|
0:38:49
|
in this Bulk Administration Tool.
|
|
0:38:53
|
and if we use the dummy MAC address, then what we’re actually going to do,
|
|
0:39:00
|
is it will import this BAT dummy MAC addresses
|
|
0:39:06
|
and the things is there would be a line associated
|
|
0:39:10
|
and the users that are deploying, not really the users
|
|
0:39:13
|
but actually the field engineers that are deploying
|
|
0:39:15
|
these actual physical phone units to the user's desk,
|
|
0:39:20
|
the phone will auto-register as an unknown phone to CUCM and will begin to use TAPS.
|
|
0:39:28
|
TAPS is the tool for auto phone registration or setup or support.
|
|
0:39:36
|
So BAT and TAPS work together.
|
|
0:39:38
|
Bulk Administration Tool and TAPS, the tool for auto phone registration support.
|
|
0:39:44
|
And what TAPS is, is basically a .aef Unified Contact Center Express (UCCX) scripting file
|
|
0:39:56
|
that we do have to have a UCCX server that we then use
|
|
0:40:02
|
and there’s actually a very very pared down versions of UCCX
|
|
0:40:07
|
called CRS (Customer Response Solutions)
|
|
0:40:09
|
for those of your clients that haven’t purchase UCCX,
|
|
0:40:14
|
you can still use a very pared down version that really only runs a couple applications,
|
|
0:40:20
|
auto attendant and this TAPS tool has very limited number of ports.
|
|
0:40:25
|
And you’ll obviously have a lot of auto-registration,
|
|
0:40:30
|
you’ll have auto-registration turned on which we’ll go over
|
|
0:40:33
|
but you’ll also have a lot of available DN’s for which to allow this phone to auto-register.
|
|
0:40:40
|
And hopefully they don’t overlap with any other ranges
|
|
0:40:44
|
not the ranges that your phones will ultimately be using.
|
|
0:40:49
|
And you’ll maybe wait so that you’ll have enough available of DN’s,
|
|
0:40:53
|
you’ll wait to provision all your auxiliary services like call park
|
|
0:40:56
|
and meet me and things like that might take DN’s that would overlap.
|
|
0:41:01
|
But they'll have these auto-registered phones in the system auto assigned DN’s
|
|
0:41:09
|
and then you’ll each phone once its auto-register, will be able to dial in assuming
|
|
0:41:14
|
that you’ve provisioned Calling Search Space for auto-registration properly
|
|
0:41:20
|
to be able to see the partition for the contact center application.
|
|
0:41:26
|
All things that we’ll talk about as we go on.
|
|
0:41:28
|
So if you’re getting a little lost in terms of CSS or Calling Search Space
|
|
0:41:32
|
and partition don’t worry we’ll go over that in great detail.
|
|
0:41:36
|
But they’ll be able to call this TAPS, UCCX, IVR application
|
|
0:41:45
|
and what it will ask them for is there extension and you’ll plug in
|
|
0:41:51
|
there DTMF through the keypad.
|
|
0:41:52
|
You’ll type in the extension that the phone should be not that it currently is
|
|
0:41:56
|
and it will ask you to confirm that so you’ll type it in again
|
|
0:41:59
|
and there’s a way to secure this TAPS as well
|
|
0:42:03
|
but we’re just getting into the basic operation at this point.
|
|
0:42:05
|
And then what will happen is that UCCX or IVR script
|
|
0:42:10
|
will then automatically in the background basically go
|
|
0:42:14
|
and temporarily pull the registration to CUCM out
|
|
0:42:19
|
and dynamically overwrite the Bulk Administration
|
|
0:42:24
|
particular Bulk Administration imported record for that phone
|
|
0:42:28
|
based on the appropriate Directory Number
|
|
0:42:32
|
and then the phone will obviously go through a reboot because its registration,
|
|
0:42:39
|
its phone has been removed from CUCM and after goes through a reboot
|
|
0:42:43
|
or possibly just a restart, the new registration will be in there.
|
|
0:42:47
|
So whether you want to go ahead and put the MAC addresses in now,
|
|
0:42:53
|
which a lot of times I prefer to do or you want to you use TAPS
|
|
0:42:56
|
which is actually a very effective way of doing things.
|
|
0:42:59
|
Just depends, if you’re gonna use TAPS, you’ll use this dummy MAC address.
|
|
0:43:03
|
If you’re not gonna use TAPS then you won’t have this
|
|
0:43:06
|
and you’ll just scan all of your phones with you USB scanner.
|
|
0:43:10
|
Either way you want to go, there are certainly options there
|
|
0:43:14
|
and both things are important to know in terms of exam type.
|
|
0:43:19
|
So anyway, let's go ahead and we’ll just say
|
|
0:43:22
|
we’re not really putting in a real MAC address here
|
|
0:43:26
|
because we don’t really have a phone that we’re importing.
|
|
0:43:28
|
So let's just say FFFFDDDDAAAA.
|
|
0:43:34
|
So that’s 12 characters.
|
|
0:43:36
|
My description, Test Phone.
|
|
0:43:39
|
Location, let's say location is we’ll just leave this blank.
|
|
0:43:44
|
We’ll use the phone template that we’re gonna import against to do this.
|
|
0:43:52
|
AAR CSS, we’ll leave the phone template to do that
|
|
0:43:56
|
because otherwise you need to make sure that these are spelled exactly correctly.
|
|
0:44:00
|
Exactly the way that the Calling Search Space for AAR or AAR Group or etc. is spelled,
|
|
0:44:07
|
the location for instance, is spelled in CUCM.
|
|
0:44:12
|
Directory Number, let's say 1008.
|
|
0:44:16
|
Display for that Directory Number, so this is going to be the Calling Party Identification,
|
|
0:44:24
|
not the what shows on the display that’s the Line Text Label.
|
|
0:44:28
|
So maybe this is Test Phone x1008 however your user wants to see it
|
|
0:44:37
|
and this is Test Phone Calling Party Information.
|
|
0:44:42
|
So we’re going to click ‘Export to BAT’.
|
|
0:44:46
|
It’s going to go through and if there was a problem,
|
|
0:44:49
|
so let's say for instance if I had not put in 12 characters there.
|
|
0:44:53
|
Let’s take this out and we would just have 11 now.
|
|
0:44:56
|
I say ‘Export to BAT’, it actually didn’t come up with the problem there
|
|
0:45:01
|
so again this is doing minimal checking.
|
|
0:45:05
|
It is doing checking to make sure let's say a mandatory field is actually there.
|
|
0:45:10
|
So if I do ‘Export to BAT’ now, it should come back,
|
|
0:45:13
|
there we go and say ‘MAC address cannot be blank’.
|
|
0:45:18
|
So we put that back in, FFFFDDDDAAAA and we’ll say ‘Export to BAT’,
|
|
0:45:29
|
we will export this information somewhere on our system, we’ll say OK.
|
|
0:45:36
|
The data will successfully exported it tells us.
|
|
0:45:40
|
So now I need to go and grab that file and upload it.
|
|
0:45:48
|
And so what we’ll do is we’ll go over to CUCM
|
|
0:45:53
|
and we will do a upload/download and we’ll add the new file.
|
|
0:46:00
|
We will grab the xlt file from wherever we deposited it.
|
|
0:46:05
|
Choose the target, in this case we’re just gonna upload Phones
|
|
0:46:09
|
and then the Select the Transaction Type.
|
|
0:46:11
|
Do we wanna insert Phones with All Details, Specific Details,
|
|
0:46:16
|
Add or Delete Phones using Custom File, just Add Phone Lines.
|
|
0:46:22
|
So there’s a lot of information, lots of things that we can do.
|
|
0:46:26
|
Phone Migration, from one protocol to another,
|
|
0:46:28
|
maybe from Skinny to SIP or vice versa if the phone supports both.
|
|
0:46:31
|
There ‘s a lot of information we can do.
|
|
0:46:35
|
In this case, we’re gonna do Insert Phone Specific Details
|
|
0:46:40
|
because we just have specific details and press save.
|
|
0:46:45
|
So now this phone if we go back to just the Find List,
|
|
0:46:50
|
we see that it’s not only uploaded but it's specifically uploaded per a function.
|
|
0:46:56
|
So if I went to for instance Gateways and Insert Gateways
|
|
0:47:01
|
and choose whatever Gateway.
|
|
0:47:04
|
Not that we're gonna insert this, there are no files here,
|
|
0:47:08
|
however if we go to Phones and Insert Phones,
|
|
0:47:11
|
not that we should do this just yet, there is an actual phone here.
|
|
0:47:17
|
So next what we wanna do is come up to Phones
|
|
0:47:21
|
and let's go over to Phone File Format and we’ve already created one.
|
|
0:47:25
|
Let's add the file format.
|
|
0:47:27
|
And actually I think I’m realizing that we have the file,
|
|
0:47:30
|
you can see that we had it uploaded.
|
|
0:47:32
|
This is the Phones along with the Unix based time stamps, date time stamp.
|
|
0:47:38
|
And so the file format is the New Test Phone Format that we just created.
|
|
0:47:42
|
What this does, we’re gonna go ahead click ‘Submit’ here
|
|
0:47:45
|
but what we’ll see is that this added this to the Job Scheduler.
|
|
0:47:48
|
So almost everything in BAT says use the Job Scheduler to see the status of your job.
|
|
0:47:53
|
that's Bulk Administration Tool down to the bottom Job Scheduler and here’s our job.
|
|
0:47:59
|
We’re gonna click on it.
|
|
0:48:00
|
It says that it was complete over here.
|
|
0:48:03
|
And zero records, failed, processed, all was 0
|
|
0:48:08
|
but there was an error and the reason is if click on this file name to see the specifics,
|
|
0:48:13
|
it tells me that adding the file format failed
|
|
0:48:17
|
and the reason is, the file already has the format.
|
|
0:48:20
|
So I spoke a little bit too soon when saying that we have to create and add the file format.
|
|
0:48:27
|
What that does, what the function of that does
|
|
0:48:31
|
is that if we just use a regular CSV file but we didn’t have the headers added.
|
|
0:48:38
|
So we didn’t use this xlt Excel template to do the creation or create that CSV file,
|
|
0:48:46
|
then there aren’t the proper headers at the top of the file
|
|
0:48:50
|
and so that’s where we need to add that file format.
|
|
0:48:57
|
So we’re adding the CSV headers to the top of an existing file.
|
|
0:49:02
|
First we create it in a very similar fashion to how we did in the BAT tool
|
|
0:49:06
|
and then we add that those headers to the top of each of the files.
|
|
0:49:11
|
So we don’t really have to that if we use the Excel template tool.
|
|
0:49:18
|
What we do need to do is,
|
|
0:49:21
|
So that failed, that’s fine, we can delete that information
|
|
0:49:24
|
or we can just leave in the scheduler for future information.
|
|
0:49:33
|
First come the phone template, and then once we create a template
|
|
0:49:35
|
then we’re going to validate the file using the template
|
|
0:49:40
|
to see if everything will work properly or should work properly on the import.
|
|
0:49:44
|
So let's create a new phone template,
|
|
0:49:46
|
as we’ve started doing times now based on our 9971 SIP phone
|
|
0:49:52
|
and we’ll give it a 9971 SIP Test Template
|
|
0:49:59
|
maybe with 1 line and we’ll give it a Device Pool.
|
|
0:50:07
|
I probably put all that information in the description
|
|
0:50:09
|
or name in terms of what Device Pool if I wasn’t doing the Device Pool in the BAT tool
|
|
0:50:16
|
which as I mentioned I would typically do all that in BAT.
|
|
0:50:19
|
That way I can use and just import a lot of different phones for different sites
|
|
0:50:26
|
and different class of restrictions against the few phone types that I have
|
|
0:50:32
|
but again I would go into CUCM and provision everything first
|
|
0:50:35
|
and then copy the names of those Device Pools into the BAT template
|
|
0:50:40
|
rather than trying to key them in manually.
|
|
0:50:43
|
So maybe I’ll assign a CSS and then AAR CSS,
|
|
0:50:46
|
all things that we’ll go over in later modules.
|
|
0:50:49
|
Maybe in AAR Group, not a known or user ID
|
|
0:50:53
|
because they’re not gonna belong to the same user.
|
|
0:50:57
|
Maybe a Calling Party Transformation CSS
|
|
0:51:00
|
and tell it not to use Device Pool, whatever.
|
|
0:51:03
|
Although in real deployment I probably would use Device Pool.
|
|
0:51:06
|
There’s some things that I have to do, the required field
|
|
0:51:09
|
and some of them are already filled in,
|
|
0:51:11
|
some of them are not even if there’s only one so I need to choose those.
|
|
0:51:16
|
Want to be common to my phones.
|
|
0:51:18
|
Save and it says, ‘Phone Button Template’, forgot to select that.
|
|
0:51:25
|
And of course if I wanted the phones to have different Button Templates
|
|
0:51:28
|
I would have created those first.
|
|
0:51:31
|
And I have to come over here to add new DN and you might say,
|
|
0:51:34
|
“Wait a minutes, why are we adding a specific DN
|
|
0:51:38
|
to a template, well it’s not really a specific DN.”
|
|
0:51:40
|
“Instead of a number, it’s got a name.”
|
|
0:51:43
|
So this is a 9971 line 1 test template.
|
|
0:51:50
|
And the route partition, let's put everything in an internal,
|
|
0:51:53
|
whatever we would want to be common across all of our phones.
|
|
0:51:57
|
Maybe I want all busy and external or no answer to go to voicemail
|
|
0:52:10
|
and the particular class of restriction that it needed to be able to get there, whatever.
|
|
0:52:17
|
Maybe I want a call forward all that’s only able to dial
|
|
0:52:22
|
and forward to national, forward all numbers to national
|
|
0:52:26
|
versus forwarding them all to international which is the rest of the phone’s dialling rights.
|
|
0:52:32
|
Things that we’ll talk about in the dial plan
|
|
0:52:35
|
but whatever I want, that’s what I would,
|
|
0:52:39
|
let's say with configured CSS that we just put here,
|
|
0:52:41
|
that’s what I’m gonna put in here and say save.
|
|
0:52:44
|
So again it’s not a particular number,
|
|
0:52:45
|
I’ll go back to the device which is really just a template.
|
|
0:52:50
|
And I got this 9971 line 1 test template in the particular DN.
|
|
0:52:55
|
So now I have created my template,
|
|
0:52:57
|
now I actually wanna go back to Bulk Administration Tool phone validate
|
|
0:53:02
|
before I do the insert.
|
|
0:53:05
|
So I’m gonna say validate the file that I imported from the Excel template
|
|
0:53:14
|
and then against the phone template validate this information,
|
|
0:53:18
|
might give it a more specific description for the job,
|
|
0:53:22
|
say submit and then go to the Job Scheduler to see the status.
|
|
0:53:26
|
So I’m going to come to the Job Scheduler here.
|
|
0:53:31
|
By the way some jobs you’ve imported into BAT,
|
|
0:53:34
|
I think we’ve already said on the actual job.
|
|
0:53:36
|
You have the option of saying run immediately or schedule.
|
|
0:53:41
|
In which case that you didn’t check run immediately,
|
|
0:53:44
|
you forgot to or chose not to, you can come back here,
|
|
0:53:47
|
tic the box and say activate that selected job if it says that status is pending.
|
|
0:53:53
|
So I’ll click on the job ID.
|
|
0:53:55
|
I see that I have a total of one records and none of them failed.
|
|
0:54:00
|
So one was processed, typically all the records will be processed
|
|
0:54:05
|
but this will tell you how many failed.
|
|
0:54:08
|
And that was a success let's click on the log file
|
|
0:54:12
|
to actually see that there was no errors found.
|
|
0:54:15
|
Validate for 1 phone is passed.
|
|
0:54:18
|
Validate for 0 phone is failed.
|
|
0:54:20
|
So it look like according to the Excel template which did one level of verification
|
|
0:54:27
|
and then the upload, creation of the phone template
|
|
0:54:33
|
and then the validation of the phone against the template,
|
|
0:54:36
|
it looks like this should work.
|
|
0:54:39
|
So we downloaded the xlt template, populated our information,
|
|
0:54:44
|
exported the CSV file, came back to CUCM, uploaded that CSV file to the right location.
|
|
0:54:52
|
Phones, specific details, created the template, validated the information
|
|
0:55:00
|
against the template, now we’re gonna go to ‘Insert Phone’,
|
|
0:55:04
|
so the file that we wanted against the template that we created.
|
|
0:55:08
|
Do we wanna create dummy MAC addresses, again if we’re gonna use TAPS,
|
|
0:55:15
|
we did not use all details.
|
|
0:55:17
|
If we would have inserted phones with all details
|
|
0:55:20
|
we would have done the insert phones to the specific function type
|
|
0:55:24
|
or location of all details but we can see there’s no file present there.
|
|
0:55:28
|
Do we wanna override certain information?
|
|
0:55:31
|
Do we want to do things like delete all existing speed dials before adding new?
|
|
0:55:36
|
If for some reasons these records exist, all that information.
|
|
0:55:40
|
Insert the phones, let's not run later, let's run immediately.
|
|
0:55:44
|
Click submit, look at the Job Scheduler.
|
|
0:55:52
|
We see that the insert of the phones has completed.
|
|
0:55:56
|
Let's click on the job.
|
|
0:55:58
|
We see that there was one record and no failures.
|
|
0:56:03
|
We had a success.
|
|
0:56:04
|
We could look at the log but it should tell us the same information
|
|
0:56:07
|
so let us go to the phone.
|
|
0:56:10
|
Page, and we’ll see that we have our test phone which is a 9971,
|
|
0:56:15
|
SEPFFFFDDDDAAAA, all the information in the template that we had put in is there
|
|
0:56:24
|
and the line 1008 that we had put there with our,
|
|
0:56:29
|
Now remember we didn’t have Alerting name in our BAT template,
|
|
0:56:32
|
we could have added that field, no problem as well as ASCII Alerting.
|
|
0:56:38
|
We also only had Display, we never put in ASCII Display.
|
|
0:56:42
|
So I would either need to copy this here if I want to use the ASCII function for display
|
|
0:56:46
|
or I could have put that in BAT and I have the Line Text Label.
|
|
0:56:51
|
Everything that I gave it was imported properly.
|
|
0:56:55
|
And again, this was just a demonstration.
|
|
0:56:57
|
In real life, I would have put a lot more information
|
|
0:56:59
|
and I would put all the ASCII Information and External Phone Number Mask.
|
|
0:57:03
|
I would have keyed all the Calling Search Spaces, AAR Destination Mask.
|
|
0:57:08
|
There would have been a lot more information.
|
|
0:57:10
|
I would have spend a lot of time on BAT
|
|
0:57:13
|
making sure every bit of information I wanted was there,
|
|
0:57:16
|
formatted properly so that when I imported, I basically did it once.
|
|
0:57:21
|
And it’s actually a really good idea when using the BAT tool
|
|
0:57:24
|
to import a single record against each one of your templates,
|
|
0:57:30
|
probably one template for each type
|
|
0:57:32
|
just to make sure that it’s gonna import properly
|
|
0:57:34
|
and then delete that one phone for each of the templates
|
|
0:57:37
|
and phone types and then go back and import all of the rest of your phones.
|
|
0:57:42
|
And here’s the reason, especially if you’re adding new phones to an existing system,
|
|
0:57:49
|
So maybe I have 200 new employees starting and I’ve already got 1200 in my system.
|
|
0:57:56
|
If I go and add all 200 phones and there was a problem with importing all of them
|
|
0:58:01
|
and I know need to go delete them,
|
|
0:58:03
|
well, if there were no phones in the system I could just go look for phone,
|
|
0:58:08
|
all the phones, select all and delete them all.
|
|
0:58:11
|
And I could do up to 250 records so 250 phones per page.
|
|
0:58:16
|
So it would be hard to delete all 200 phones. But if I had already 1200 phones
|
|
0:58:21
|
and I import 200 and I made a mistake and I need to delete them along with their lines,
|
|
0:58:26
|
and if I delete the phone I probably have to go back call routing,
|
|
0:58:29
|
route plan report, unassigned DN’s, find those and delete those as well
|
|
0:58:37
|
unless I have dummy phantom DN’s and I might actually run
|
|
0:58:41
|
into the issue of accidentally deleting DN’s that were there for a reason
|
|
0:58:46
|
that were there for Call Forward All type purposes or whatever.
|
|
0:58:49
|
But I would have to find those phones within 1200.
|
|
0:58:54
|
And so it could be a real big headache.
|
|
0:58:56
|
So it’s always a good idea to import a single dummy test record
|
|
0:59:01
|
against each of the templates
|
|
0:59:02
|
that you’re going to be using before going ahead
|
|
0:59:07
|
and just making sure it imports, not just that it validated properly
|
|
0:59:10
|
but just make sure everything’s right before you actually do your large
|
|
0:59:16
|
and hopefully final bulk import.
|
|
0:59:21
|
Also another thing about this Find and List Route Plan Report and Unassigned DN,
|
|
0:59:25
|
when you’re using the auto-registration, which we’ll talk about a little bit later,
|
|
0:59:31
|
and we’ve turned on auto-registration at the Unified CM,
|
|
0:59:34
|
turned the auto-registration group or have an auto assigned at the Unified CM group
|
|
0:59:39
|
and on the Device Pool have the auto-registration Calling Search Space.
|
|
0:59:45
|
When we go and do that, we’re gonna define at our,
|
|
0:59:51
|
let's just go here real briefly, that our Unified CM were going to
|
|
0:59:56
|
for whichever ever CPE is the primary CPE in the group,
|
|
1:00:02
|
in our default Device Pool actually,
|
|
1:00:06
|
whatever is use under the device, device settings, device defaults.
|
|
1:00:12
|
here is, if I have multiple Device Pools,
|
|
1:00:16
|
here is the Device Pool with which auto-registration will process against.
|
|
1:00:21
|
So if I go to Device Pool and I had, it was Corporate Headquarter Gateway and Devices
|
|
1:00:31
|
rather than Corporate Headquarter Phones.
|
|
1:00:33
|
It doesn’t matter that this is the auto-registration Device Pool
|
|
1:00:36
|
because your Bulk Administration Tool will overwrite the Device Pool
|
|
1:00:42
|
for a given phone as it’s actually being imported.
|
|
1:00:48
|
But I can, I have my Calling Search Space for auto-registration
|
|
1:00:54
|
as well as the Unified Communication Manager group.
|
|
1:00:56
|
So if I have Sub-Pub and that’s the group that I have.
|
|
1:01:01
|
In this case I only have 1 group, in a larger installation I would have more.
|
|
1:01:06
|
Per the deployment models.
|
|
1:01:09
|
And I have the Sub first then that is where I’m going to up to Cisco Unified CM
|
|
1:01:15
|
and that will be the server that will process against the auto-registration assuming
|
|
1:01:18
|
that it’s on running and the Call Manager Service is running on that server.
|
|
1:01:23
|
So here I’ll have my starting Directory Number.
|
|
1:01:25
|
By default, this is set like this.
|
|
1:01:28
|
So auto-registration is disabled and if I un-tic this box, it will say
|
|
1:01:34
|
“to enable to it, change the starting and ending Directory Number
|
|
1:01:36
|
and they have to have a valid range.”
|
|
1:01:38
|
So we’ll just go right back on.
|
|
1:01:40
|
So I’ll take the starting range and let’s say 8000
|
|
1:01:45
|
and it gives me an error that’s fine and I change the ending number to if it’s only 8010,
|
|
1:01:51
|
I'm only going to be able to import 10 phones at a time
|
|
1:01:56
|
and then if I had 200 phones, then all of the remaining phones
|
|
1:02:01
|
are going to get registration rejected even for auto-registration.
|
|
1:02:06
|
Because there are only 10 DN’s to utilize to create this auto-registered phones
|
|
1:02:12
|
and associated lines and DN’s which they have to have.
|
|
1:02:16
|
So I need to have, either have to have a large enough ranges
|
|
1:02:21
|
to accommodate all the phones
|
|
1:02:23
|
that I'm going to connect at the network at the same time if they’re going to auto-register
|
|
1:02:26
|
and I haven’t already imported the Bulk Administration Tool
|
|
1:02:30
|
with their proper MAC address.
|
|
1:02:32
|
The nice thing about the dummy MAC address
|
|
1:02:35
|
and just using auto-registration to allow them to come online
|
|
1:02:38
|
is that all I have to do is deploy the right type of phone to a user’s desk
|
|
1:02:42
|
and I don’t have to go through that process that I mentioned
|
|
1:02:45
|
where I scan the particular MAC address and write the name of the user on the phone
|
|
1:02:52
|
and then everyone has to sort a search through.
|
|
1:02:54
|
“OK which phone was that this desk?”
|
|
1:02:57
|
You just have to deploy the right type.
|
|
1:02:59
|
The 9971, the 9961 or whatever model to the phone or to the desk.
|
|
1:03:05
|
It auto-registers with the SEP MAC address.
|
|
1:03:08
|
The dummy MAC addresses used for the BAT import and then TAPS,
|
|
1:03:13
|
the tool for auto-registered phones, is the UCCX application that’s dialled
|
|
1:03:18
|
and then put in the DN, authenticate again, optionally with a username
|
|
1:03:23
|
and password if you want it secure and then it will automatically delete the old record
|
|
1:03:29
|
and take on, overwrite the existing BAT dummy MAC address
|
|
1:03:33
|
with the associated DN along with proper MAC address.
|
|
1:03:38
|
Now there is one caveat to that if you have shared lines for your primary DN
|
|
1:03:42
|
that could be an issue.
|
|
1:03:43
|
But that’s not typically too many phones.
|
|
1:03:45
|
Maybe a manager, an assistant pair so maybe 10 out of 200 or something like that.
|
|
1:03:51
|
But anyhow, if have a small range, if I use a large range like let’s say 8999,
|
|
1:03:58
|
by the way as soon as I tic off this or tab off this,
|
|
1:04:01
|
auto-registration disabled automatically goes away.
|
|
1:04:04
|
I could use a common External Phone Number Mask
|
|
1:04:07
|
or a common partition if I wanna go ahead and set that up.
|
|
1:04:10
|
But if I don’t have a large enough range,
|
|
1:04:12
|
let's say I have only 200 phones to work with, so 8099.
|
|
1:04:18
|
So 8000 to 8099 is a hundred DN’s and I press save
|
|
1:04:24
|
and I connect all my, I’ve got 200 phones I'm deploying, I connect 100 of them.
|
|
1:04:32
|
The 100 first phone, even I’ve gone ahead and connected the first 100
|
|
1:04:36
|
and used TAPS to go ahead and change over the DN,
|
|
1:04:41
|
the problem is that the old DN, the 8000-8099 temporary DN
|
|
1:04:47
|
that was used for auto-registration, each phone now has their proper DN.
|
|
1:04:51
|
1001-1099 but these temporary DN’s are still in the system
|
|
1:05:01
|
as under Route Plan Report as Unassigned DN’s.
|
|
1:05:06
|
So it’s important if you don’t have a large enough auto-registration range,
|
|
1:05:10
|
and even if you do if you ever going to import more
|
|
1:05:13
|
to comeback to your Route Plan Report,
|
|
1:05:16
|
change Find all patterns to Unassigned and once I click find,
|
|
1:05:22
|
it will give me the number of records.
|
|
1:05:24
|
One of the nice things that’s unique to Unassigned DN’s,
|
|
1:05:28
|
you don’t see any here is that,
|
|
1:05:30
|
in fact I’ll just go create one just for the sake of showing you real briefly.
|
|
1:05:36
|
Create one, let's say 8088.
|
|
1:05:42
|
That’s all I want just to create the DN.
|
|
1:05:44
|
Comeback to call Routing, Route Plan Report.
|
|
1:05:47
|
Unassigned DN finds one.
|
|
1:05:50
|
Even if it found more than I have on the page,
|
|
1:05:53
|
normally with an all pattern type thing, at the bottom, I can choose
|
|
1:06:01
|
Sorry, that’s a bad example.
|
|
1:06:07
|
Actually I can’t do that here.
|
|
1:06:08
|
Unassigned DN, it not only has the ability to delete certain records
|
|
1:06:14
|
which is very useful if I have, as I briefly eluded to earlier specific DN’s
|
|
1:06:21
|
that are unassigned intentionally for things like phantom DN’s.
|
|
1:06:25
|
Maybe a DN that someone hits and all it does forward all somewhere else.
|
|
1:06:30
|
So deleted selected can be useful in that particular case.
|
|
1:06:34
|
But if all of my unassigned DN’s are simply auto-register range,
|
|
1:06:39
|
then I can simply click delete all found items
|
|
1:06:42
|
and it will simply delete all of those ranges, all of those DN’s
|
|
1:06:46
|
and free up that entire 100 range for the next 100 phones.
|
|
1:06:51
|
And then one other thing, as soon as you have actually deployed all the phones
|
|
1:06:58
|
that you want to deploy, it is always a good idea
|
|
1:07:02
|
And I'm not going to do this right now because this is my lab environment
|
|
1:07:05
|
and I frequently bring new phones online.
|
|
1:07:07
|
But it’s always a good idea to comeback and turn auto-registration to disabled
|
|
1:07:12
|
and check all of your Cisco Unified CM's in order to make sure
|
|
1:07:17
|
that rogue phones don’t accidentally make their way on the network.
|
|
1:07:22
|
Somebody just realized that when their phone was auto-registered it had,
|
|
1:07:29
|
maybe even one of the field technicians deploying it in house realize
|
|
1:07:33
|
that the Calling Search Space that you gave was actually able to dial international
|
|
1:07:37
|
and everywhere and their regular desk phone can’t do that,
|
|
1:07:41
|
it can only dial national and they wanna dial, they wanna basically do toll fraud
|
|
1:07:44
|
and dial someone that’s international, one of their friends.
|
|
1:07:53
|
Of course it’s not a good idea to use a Calling Search Space as your auto-registration CSS
|
|
1:07:58
|
that can dial international but that’s beside the point.
|
|
1:08:01
|
Another example would just be, somebody that walks in
|
|
1:08:06
|
and has malicious intent or whatever, whatever the malicious intent is
|
|
1:08:11
|
or whatever the accident is or non-intent but just accidental thing that might happen,
|
|
1:08:17
|
you don't want rogue phones,
|
|
1:08:19
|
phones that you don’t know about or control on your network.
|
|
1:08:22
|
So it’s always a good idea to disable auto-registration.
|
|
1:08:26
|
And the last thing I'm gonna say is back on the BAT tool,
|
|
1:08:30
|
under the xlt help, in terms of the ability to actually import large number of records,
|
|
1:08:39
|
it states here that it’s recommended to create CSV files with equal to
|
|
1:08:47
|
or less than 12000 records per import.
|
|
1:08:52
|
You can create multiple CSV files but each of them should have less than 12000 phones
|
|
1:09:00
|
or users or phone user or Gateways or whatever.
|
|
1:09:03
|
Basically what I'm trying to point out is this becomes a very scalable,
|
|
1:09:09
|
very large scalable way
|
|
1:09:13
|
or means of importing data into your system.
|
|
1:09:17
|
So the Bulk Administration Tool and the Excel BAT template,
|
|
1:09:22
|
a very good thing to use and certainly something that you need to be familiar with
|
|
1:09:27
|
at least in terms of the basic function of it for your exams.
|
