Re: [cisco-voip] Bulk Admin and Jabber

[Pawlowski, Adam]

I wrote in Ruby, it is a CLI script that just takes a parameter for an input 
CSV.

One of my missions here over the next while is to “learn” Python and migrate 
tooling there. Ruby was pretty easy and I’ve built some library code for 
dealing with users, lines, and phones. Python can’t be too much different than 
Perl, PHP, VB, any of that, it’s not as bad as TCL so I’m sure I can figure it 
out.

We have a number of scripts here for various things that our team can run from 
a jumpbox, but, as my stack gets better I would like to build these things into 
a web front end.

I have a small XMPP interface for some of these functions as well which is 
pretty useful to get information gathered at a glance.



From: Anthony Holloway 
Sent: Monday, September 16, 2019 3:58 PM
To: Pawlowski, Adam 
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] Bulk Admin and Jabber

What programming language did you write it in, and is the interface GUI or CLI 
based?

On Mon, Sep 16, 2019 at 1:04 PM Pawlowski, Adam 
mailto:aj...@buffalo.edu>> wrote:
Catching up on this one since this list stopped sending me daily digests but 
more like whenever it feels like it digests

We use the Quick User/Phone Add here and I put that into the procedures for the 
technicians since it can enforce some level of consistency. It’s not perfect by 
any means but for Jabber at least there is usually not too much farting around 
that needs to be done after the client is setup.

Two sore points for me on it are:


1)  It does not fill in the ASCII Display Name field when it adds line 
appearances. I have no idea why, but CTI applications like CER still use this 
so I have to go open each one and click on it to avoid dispatch getting calls 
from “_”.

2)  Product specific fields are still not available here. On desk sets 
that’s the wireless hookswitch control. On Jabber, that’s the Cisco Support 
Field. Unless something has changed recently, the BOT/TAB/TCT devices’ flavor 
of Cisco Support Field is NOT the same one as in the common phone profile.

I haven’t experimented to see if this works now, but it did not when we set all 
this up for Jabber. Our base jabber-config turns off everything but IM so 
anyone can just pop  open the client, then we change profile on the client to 
turn on the features or for hunt/pickup etc. I still have to touch this by hand 
for BOT, TAB, and TCT.


It is “quick” and it works for 98% of new additions, it’s useless for moving 
resources between people as it re-provisions everything, and when you’re 
building procedures for people so they can avoid hand made changes, it doesn’t 
quite get us there.

That being said I wrote a script to use AXL to bulk insert clients. I read a 
CSV with a userID, the client type, and the profile. I verify the user ID is in 
the system, insert the device, and then stack it on the association list. It 
really wasn’t that hard and comes a … well a bulk import tool I can hand off to 
the team. You can write product-specific configurations back with AXL, you just 
want to look at an example of how it is mashed together, and make sure you 
don’t break it. IIRC it’s a block of XML that comes out of the database, and I 
think this is one of those fields that when you set it back through AXL it gets 
written back exactly as you send it, so it is easy to clear settings.

Best of luck

Adam Pawlowski
SUNYAB
___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Anthony Holloway]

What programming language did you write it in, and is the interface GUI or
CLI based?

On Mon, Sep 16, 2019 at 1:04 PM Pawlowski, Adam  wrote:

> Catching up on this one since this list stopped sending me daily digests
> but more like whenever it feels like it digests
>
>
>
> We use the Quick User/Phone Add here and I put that into the procedures
> for the technicians since it can enforce some level of consistency. It’s
> not perfect by any means but for Jabber at least there is usually not too
> much farting around that needs to be done after the client is setup.
>
>
>
> Two sore points for me on it are:
>
>
>
> 1)  It does not fill in the ASCII Display Name field when it adds
> line appearances. I have no idea why, but CTI applications like CER still
> use this so I have to go open each one and click on it to avoid dispatch
> getting calls from “_”.
>
> 2)  Product specific fields are still not available here. On desk
> sets that’s the wireless hookswitch control. On Jabber, that’s the Cisco
> Support Field. Unless something has changed recently, the BOT/TAB/TCT
> devices’ flavor of Cisco Support Field is NOT the same one as in the common
> phone profile.
>
> I haven’t experimented to see if this works now, but it did not when we
> set all this up for Jabber. Our base jabber-config turns off everything but
> IM so anyone can just pop  open the client, then we change profile on the
> client to turn on the features or for hunt/pickup etc. I still have to
> touch this by hand for BOT, TAB, and TCT.
>
>
>
> It is “quick” and it works for 98% of new additions, it’s useless for
> moving resources between people as it re-provisions everything, and when
> you’re building procedures for people so they can avoid hand made changes,
> it doesn’t quite get us there.
>
>
>
> That being said I wrote a script to use AXL to bulk insert clients. I read
> a CSV with a userID, the client type, and the profile. I verify the user ID
> is in the system, insert the device, and then stack it on the association
> list. It really wasn’t that hard and comes a … well a bulk import tool I
> can hand off to the team. You can write product-specific configurations
> back with AXL, you just want to look at an example of how it is mashed
> together, and make sure you don’t break it. IIRC it’s a block of XML that
> comes out of the database, and I think this is one of those fields that
> when you set it back through AXL it gets written back exactly as you send
> it, so it is easy to clear settings.
>
>
>
> Best of luck
>
>
>
> Adam Pawlowski
>
> SUNYAB
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Pawlowski, Adam]

Catching up on this one since this list stopped sending me daily digests but 
more like whenever it feels like it digests

We use the Quick User/Phone Add here and I put that into the procedures for the 
technicians since it can enforce some level of consistency. It's not perfect by 
any means but for Jabber at least there is usually not too much farting around 
that needs to be done after the client is setup.

Two sore points for me on it are:


1)  It does not fill in the ASCII Display Name field when it adds line 
appearances. I have no idea why, but CTI applications like CER still use this 
so I have to go open each one and click on it to avoid dispatch getting calls 
from "_".

2)  Product specific fields are still not available here. On desk sets 
that's the wireless hookswitch control. On Jabber, that's the Cisco Support 
Field. Unless something has changed recently, the BOT/TAB/TCT devices' flavor 
of Cisco Support Field is NOT the same one as in the common phone profile.

I haven't experimented to see if this works now, but it did not when we set all 
this up for Jabber. Our base jabber-config turns off everything but IM so 
anyone can just pop  open the client, then we change profile on the client to 
turn on the features or for hunt/pickup etc. I still have to touch this by hand 
for BOT, TAB, and TCT.


It is "quick" and it works for 98% of new additions, it's useless for moving 
resources between people as it re-provisions everything, and when you're 
building procedures for people so they can avoid hand made changes, it doesn't 
quite get us there.

That being said I wrote a script to use AXL to bulk insert clients. I read a 
CSV with a userID, the client type, and the profile. I verify the user ID is in 
the system, insert the device, and then stack it on the association list. It 
really wasn't that hard and comes a ... well a bulk import tool I can hand off 
to the team. You can write product-specific configurations back with AXL, you 
just want to look at an example of how it is mashed together, and make sure you 
don't break it. IIRC it's a block of XML that comes out of the database, and I 
think this is one of those fields that when you set it back through AXL it gets 
written back exactly as you send it, so it is easy to clear settings.

Best of luck

Adam Pawlowski
SUNYAB
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Brian Meade]

What's nice is Quick User/Phone Add already puts the prefix and
auto-changes the format of the device name to all caps when saving.  I
usually copy the username and just paste it in there.

On Fri, Sep 13, 2019 at 12:40 PM Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> "... when we know the device name for the softphones needs to be the
> userID"
>
> Just to be clear, it does not.  That was an old CUPC requirement, and the
> new requirements are as follows:
>
> CSF = could be whatever you want, e.g., banana (unless you have QM call
> recording, then it needs to be all caps CSFSOMETHING for QM)
> TCT = must be all caps TCTSOMETHING
> BOT =  must be all caps BOTSOMETHING
> TAB = must be all caps TABSOMETHING
>
> None of them however, need the User ID in the name.  Could be TCTBANANA
> for example.
>
> Maybe that's not what you meant.  Maybe you meant, for your company's
> standard build, but I thought I'd address that, since other people might
> have read that it needed to be that way.
>
> On Fri, Sep 13, 2019 at 10:25 AM Lelio Fulgenzi  wrote:
>
>> This looks like an interesting option. I’ll have to see how much effort
>> it takes to get the templates set up in order for us to use this.
>>
>>
>>
>> I didn’t like the fact that it’s asking me to fill in the device name,
>> when we know the device name for the softphones needs to be the userID. So
>> this is a step that could lead to errors and extra effort.
>>
>>
>>
>> I know this sounds like _*I*_ don’t want to do this stuff, but when
>> you’re preparing instructions for a group of people with varying skill
>> sets, the less work required the better.
>>
>>
>>
>> At least we have some options.
>>
>>
>>
>>
>>
>>
>>
>> ---
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>>
>>
>> *From:* Brian Meade 
>> *Sent:* Friday, September 13, 2019 11:02 AM
>> *To:* Lelio Fulgenzi 
>> *Cc:* Anthony Holloway ; cisco-voip
>> voyp list 
>> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>>
>>
>>
>> Have you tried using the Quick/User Phone Add?  That works pretty well.
>> Just assign device/line templates to user profiles and adding a
>> CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at
>> most.
>>
>>
>>
>> On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi 
>> wrote:
>>
>> I guess it’s a combo of built-in tools and tools people are familiar
>> with.
>>
>>
>>
>> I like the idea, but again, adding extra steps like that might not work.
>> Now, that being said, I wonder if I can modify the order in which the
>> columns are presented to the import tool? If they allow headers, that
>> should be ok, right?
>>
>>
>>
>> I might be stuck with looking for green columns for the first round. ☹
>>
>>
>>
>> ---
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>>
>>
>> *From:* Anthony Holloway 
>> *Sent:* Friday, September 13, 2019 10:31 AM
>> *To:* Lelio Fulgenzi 
>> *Cc:* cisco-voip voyp list 
>> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>>
>>
>>
>> "...I need to use the built-in tools..."
>>
>>
>>
>> So, Excel + BAT is built-in, and Python + AXL is not?
>>
>>
>>
>> I kid, I kid.  I get that there's a common familiarity with Excel and not
>> one with Python.
>>
>>
>>
>> I have a recommendation when working with BAT import files in Excel.
>> Insert a few input columns to the left of the actual data, and then drive
>> your entire spreadsheet with formulas.  This will save you from having t

Re: [cisco-voip] Bulk Admin and Jabber

[Charles Goldsmith]

LOL.  Problem is, if you have a large deployment, even something as small
as 50 users, coming up with unique names is problematic.  For those of us
deploying in bulk, using the AD user-id is perfect, you can concatenate in
Excel quickly to generate the device names (CSFjsnow, TCTJSNOW, BOTJSNOW,
TABJSNOW).

On Fri, Sep 13, 2019 at 1:07 PM Lelio Fulgenzi  wrote:

>
>
> Interesting. I must have simply read it incorrectly. I don’t think I would
> have picked any other formatting in retrospect.
>
>
>
> What are others using?
>
>
>
> Other than Anthony, who’s focused on fruits for some reason.
>
>
>
> I’d like to be AVOCADO.
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Charles Goldsmith 
> *Sent:* Friday, September 13, 2019 1:47 PM
> *To:* Lelio Fulgenzi 
> *Cc:* Anthony Holloway ; cisco-voip voyp
> list 
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> It just has to be unique, the association comes from the End User device
> association as well as the Owner User ID.  Anthony has it correct.
>
>
>
> On Fri, Sep 13, 2019 at 12:41 PM Lelio Fulgenzi  wrote:
>
> Ok. Hold on. Are you sure? I did mean userID. As a Cisco requirement. Not
> company standard.
>
>
>
> I’m almost 100% positive I read in the deployment guide it needs to be the
> userID. And it was the Jabber deployment guide. Which, of course, I didn’t
> save. 
>
>
>
> When asking about it, I was told, it was really the only way you could get
> a Jabber device to associate with a user after logon. How else would you?
>
>
>
> I mean, there’s nothing else I think I’d really want to use, but,
> honestly, I believe(d) it’s a requirement.
>
>
>
> Lelio
>
>
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Anthony Holloway 
> *Sent:* Friday, September 13, 2019 12:40 PM
> *To:* Lelio Fulgenzi 
> *Cc:* Brian Meade ; cisco-voip voyp list <
> cisco-voip@puck.nether.net>
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> "... when we know the device name for the softphones needs to be the
> userID"
>
>
>
> Just to be clear, it does not.  That was an old CUPC requirement, and the
> new requirements are as follows:
>
>
>
> CSF = could be whatever you want, e.g., banana (unless you have QM call
> recording, then it needs to be all caps CSFSOMETHING for QM)
>
> TCT = must be all caps TCTSOMETHING
>
> BOT =  must be all caps BOTSOMETHING
>
> TAB = must be all caps TABSOMETHING
>
>
>
> None of them however, need the User ID in the name.  Could be TCTBANANA
> for example.
>
>
>
> Maybe that's not what you meant.  Maybe you meant, for your company's
> standard build, but I thought I'd address that, since other people might
> have read that it needed to be that way.
>
>
>
> On Fri, Sep 13, 2019 at 10:25 AM Lelio Fulgenzi  wrote:
>
> This looks like an interesting option. I’ll have to see how much effort it
> takes to get the templates set up in order for us to use this.
>
>
>
> I didn’t like the fact that it’s asking me to fill in the device name,
> when we know the device name for the softphones needs to be the userID. So
> this is a step that could lead to errors and extra effort.
>
>
>
> I know this sounds like _*I*_ don’t want to do this stuff, but when
> you’re preparing instructions for a group of people with varying skill
> sets, the less work required the better.
>
>
>
> At least we have some options.
>
>
>
>
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
&

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

Interesting. I must have simply read it incorrectly. I don’t think I would have 
picked any other formatting in retrospect.

What are others using?

Other than Anthony, who’s focused on fruits for some reason.

I’d like to be AVOCADO.

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Charles Goldsmith 
Sent: Friday, September 13, 2019 1:47 PM
To: Lelio Fulgenzi 
Cc: Anthony Holloway ; cisco-voip voyp list 

Subject: Re: [cisco-voip] Bulk Admin and Jabber

It just has to be unique, the association comes from the End User device 
association as well as the Owner User ID.  Anthony has it correct.

On Fri, Sep 13, 2019 at 12:41 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
Ok. Hold on. Are you sure? I did mean userID. As a Cisco requirement. Not 
company standard.

I’m almost 100% positive I read in the deployment guide it needs to be the 
userID. And it was the Jabber deployment guide. Which, of course, I didn’t 
save. 

When asking about it, I was told, it was really the only way you could get a 
Jabber device to associate with a user after logon. How else would you?

I mean, there’s nothing else I think I’d really want to use, but, honestly, I 
believe(d) it’s a requirement.

Lelio


---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>
Sent: Friday, September 13, 2019 12:40 PM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: Brian Meade mailto:bmead...@vt.edu>>; cisco-voip voyp list 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Bulk Admin and Jabber

"... when we know the device name for the softphones needs to be the userID"

Just to be clear, it does not.  That was an old CUPC requirement, and the new 
requirements are as follows:

CSF = could be whatever you want, e.g., banana (unless you have QM call 
recording, then it needs to be all caps CSFSOMETHING for QM)
TCT = must be all caps TCTSOMETHING
BOT =  must be all caps BOTSOMETHING
TAB = must be all caps TABSOMETHING

None of them however, need the User ID in the name.  Could be TCTBANANA for 
example.

Maybe that's not what you meant.  Maybe you meant, for your company's standard 
build, but I thought I'd address that, since other people might have read that 
it needed to be that way.

On Fri, Sep 13, 2019 at 10:25 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
This looks like an interesting option. I’ll have to see how much effort it 
takes to get the templates set up in order for us to use this.

I didn’t like the fact that it’s asking me to fill in the device name, when we 
know the device name for the softphones needs to be the userID. So this is a 
step that could lead to errors and extra effort.

I know this sounds like _I_ don’t want to do this stuff, but when you’re 
preparing instructions for a group of people with varying skill sets, the less 
work required the better.

At least we have some options.



---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Brian Meade mailto:bmead...@vt.edu>>
Sent: Friday, September 13, 2019 11:02 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>; 
cisco-voip voyp list 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Bulk Admin and Jabber

Have you tried using the Quick/User Phone Add?  That works pretty well.  Just 
assign device/line templates to user profiles and adding a 
CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at most.

On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
I guess it’s a combo of built-in tools and tools people are familiar with.

I like the idea, but again, adding extra steps like that might not work. Now, 
that being said, I wonder if I can modify the orde

Re: [cisco-voip] Bulk Admin and Jabber

[Charles Goldsmith]

It just has to be unique, the association comes from the End User device
association as well as the Owner User ID.  Anthony has it correct.

On Fri, Sep 13, 2019 at 12:41 PM Lelio Fulgenzi  wrote:

> Ok. Hold on. Are you sure? I did mean userID. As a Cisco requirement. Not
> company standard.
>
>
>
> I’m almost 100% positive I read in the deployment guide it needs to be the
> userID. And it was the Jabber deployment guide. Which, of course, I didn’t
> save. 
>
>
>
> When asking about it, I was told, it was really the only way you could get
> a Jabber device to associate with a user after logon. How else would you?
>
>
>
> I mean, there’s nothing else I think I’d really want to use, but,
> honestly, I believe(d) it’s a requirement.
>
>
>
> Lelio
>
>
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Anthony Holloway 
> *Sent:* Friday, September 13, 2019 12:40 PM
> *To:* Lelio Fulgenzi 
> *Cc:* Brian Meade ; cisco-voip voyp list <
> cisco-voip@puck.nether.net>
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> "... when we know the device name for the softphones needs to be the
> userID"
>
>
>
> Just to be clear, it does not.  That was an old CUPC requirement, and the
> new requirements are as follows:
>
>
>
> CSF = could be whatever you want, e.g., banana (unless you have QM call
> recording, then it needs to be all caps CSFSOMETHING for QM)
>
> TCT = must be all caps TCTSOMETHING
>
> BOT =  must be all caps BOTSOMETHING
>
> TAB = must be all caps TABSOMETHING
>
>
>
> None of them however, need the User ID in the name.  Could be TCTBANANA
> for example.
>
>
>
> Maybe that's not what you meant.  Maybe you meant, for your company's
> standard build, but I thought I'd address that, since other people might
> have read that it needed to be that way.
>
>
>
> On Fri, Sep 13, 2019 at 10:25 AM Lelio Fulgenzi  wrote:
>
> This looks like an interesting option. I’ll have to see how much effort it
> takes to get the templates set up in order for us to use this.
>
>
>
> I didn’t like the fact that it’s asking me to fill in the device name,
> when we know the device name for the softphones needs to be the userID. So
> this is a step that could lead to errors and extra effort.
>
>
>
> I know this sounds like _*I*_ don’t want to do this stuff, but when
> you’re preparing instructions for a group of people with varying skill
> sets, the less work required the better.
>
>
>
> At least we have some options.
>
>
>
>
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Brian Meade 
> *Sent:* Friday, September 13, 2019 11:02 AM
> *To:* Lelio Fulgenzi 
> *Cc:* Anthony Holloway ; cisco-voip voyp
> list 
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> Have you tried using the Quick/User Phone Add?  That works pretty well.
> Just assign device/line templates to user profiles and adding a
> CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at
> most.
>
>
>
> On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi  wrote:
>
> I guess it’s a combo of built-in tools and tools people are familiar with.
>
>
>
> I like the idea, but again, adding extra steps like that might not work.
> Now, that being said, I wonder if I can modify the order in which the
> columns are presented to the import tool? If they allow headers, that
> should be ok, right?
>
>
>
> I might be stuck with looking for green columns for the first round. ☹
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @Uof

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

Ok. Hold on. Are you sure? I did mean userID. As a Cisco requirement. Not 
company standard.

I’m almost 100% positive I read in the deployment guide it needs to be the 
userID. And it was the Jabber deployment guide. Which, of course, I didn’t 
save. 

When asking about it, I was told, it was really the only way you could get a 
Jabber device to associate with a user after logon. How else would you?

I mean, there’s nothing else I think I’d really want to use, but, honestly, I 
believe(d) it’s a requirement.

Lelio


---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
Sent: Friday, September 13, 2019 12:40 PM
To: Lelio Fulgenzi 
Cc: Brian Meade ; cisco-voip voyp list 

Subject: Re: [cisco-voip] Bulk Admin and Jabber

"... when we know the device name for the softphones needs to be the userID"

Just to be clear, it does not.  That was an old CUPC requirement, and the new 
requirements are as follows:

CSF = could be whatever you want, e.g., banana (unless you have QM call 
recording, then it needs to be all caps CSFSOMETHING for QM)
TCT = must be all caps TCTSOMETHING
BOT =  must be all caps BOTSOMETHING
TAB = must be all caps TABSOMETHING

None of them however, need the User ID in the name.  Could be TCTBANANA for 
example.

Maybe that's not what you meant.  Maybe you meant, for your company's standard 
build, but I thought I'd address that, since other people might have read that 
it needed to be that way.

On Fri, Sep 13, 2019 at 10:25 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
This looks like an interesting option. I’ll have to see how much effort it 
takes to get the templates set up in order for us to use this.

I didn’t like the fact that it’s asking me to fill in the device name, when we 
know the device name for the softphones needs to be the userID. So this is a 
step that could lead to errors and extra effort.

I know this sounds like _I_ don’t want to do this stuff, but when you’re 
preparing instructions for a group of people with varying skill sets, the less 
work required the better.

At least we have some options.



---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Brian Meade mailto:bmead...@vt.edu>>
Sent: Friday, September 13, 2019 11:02 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>; 
cisco-voip voyp list 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Bulk Admin and Jabber

Have you tried using the Quick/User Phone Add?  That works pretty well.  Just 
assign device/line templates to user profiles and adding a 
CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at most.

On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
I guess it’s a combo of built-in tools and tools people are familiar with.

I like the idea, but again, adding extra steps like that might not work. Now, 
that being said, I wonder if I can modify the order in which the columns are 
presented to the import tool? If they allow headers, that should be ok, right?

I might be stuck with looking for green columns for the first round. ☹

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>
Sent: Friday, September 13, 2019 10:31 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: cisco-voip voyp list 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Bulk Admin and Jabber

"...I need to use the built-in tools..."

So, Excel + BAT is built-in, and Python + AXL is not?

I kid, I kid.  I get that there's a common familiarity with Excel and not one 
with Python.

I have a recommendation when working with BAT import files in Excel.  Insert a 
few input columns to the left of the actual data, and th

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

{thumbs up}

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
Sent: Friday, September 13, 2019 12:41 PM
To: Brian Meade 
Cc: Lelio Fulgenzi ; cisco-voip voyp list 

Subject: Re: [cisco-voip] Bulk Admin and Jabber

I'd like to upvote this option.

On Fri, Sep 13, 2019 at 10:02 AM Brian Meade 
mailto:bmead...@vt.edu>> wrote:
Have you tried using the Quick/User Phone Add?  That works pretty well.  Just 
assign device/line templates to user profiles and adding a 
CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at most.

On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
I guess it’s a combo of built-in tools and tools people are familiar with.

I like the idea, but again, adding extra steps like that might not work. Now, 
that being said, I wonder if I can modify the order in which the columns are 
presented to the import tool? If they allow headers, that should be ok, right?

I might be stuck with looking for green columns for the first round. ☹

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>
Sent: Friday, September 13, 2019 10:31 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: cisco-voip voyp list 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Bulk Admin and Jabber

"...I need to use the built-in tools..."

So, Excel + BAT is built-in, and Python + AXL is not?

I kid, I kid.  I get that there's a common familiarity with Excel and not one 
with Python.

I have a recommendation when working with BAT import files in Excel.  Insert a 
few input columns to the left of the actual data, and then drive your entire 
spreadsheet with formulas.  This will save you from having to constantly scroll 
left and right look for cells you need to fill in.  You will have to exclude 
them when you export/save as csv.  However, keeping the input columns together 
on the left should make this very easy.  You can duplicate the sheet and delete 
them, you can have two different files: XLSX and CSV, you can copy and paste 
into Notepad++ and CTRL+H replace tabs (\t) with commas (,).  There's a few 
options there.  Anyway, I find it much nicer to input the data this way.  I 
hope it helps you too.

Do this:

[image.png]

Not this:

[image.png]



On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook


On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@

Re: [cisco-voip] Bulk Admin and Jabber

[Anthony Holloway]

I'd like to upvote this option.

On Fri, Sep 13, 2019 at 10:02 AM Brian Meade  wrote:

> Have you tried using the Quick/User Phone Add?  That works pretty well.
> Just assign device/line templates to user profiles and adding a
> CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at
> most.
>
> On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi  wrote:
>
>> I guess it’s a combo of built-in tools and tools people are familiar
>> with.
>>
>>
>>
>> I like the idea, but again, adding extra steps like that might not work.
>> Now, that being said, I wonder if I can modify the order in which the
>> columns are presented to the import tool? If they allow headers, that
>> should be ok, right?
>>
>>
>>
>> I might be stuck with looking for green columns for the first round. ☹
>>
>>
>>
>> ---
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>>
>>
>> *From:* Anthony Holloway 
>> *Sent:* Friday, September 13, 2019 10:31 AM
>> *To:* Lelio Fulgenzi 
>> *Cc:* cisco-voip voyp list 
>> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>>
>>
>>
>> "...I need to use the built-in tools..."
>>
>>
>>
>> So, Excel + BAT is built-in, and Python + AXL is not?
>>
>>
>>
>> I kid, I kid.  I get that there's a common familiarity with Excel and not
>> one with Python.
>>
>>
>>
>> I have a recommendation when working with BAT import files in Excel.
>> Insert a few input columns to the left of the actual data, and then drive
>> your entire spreadsheet with formulas.  This will save you from having to
>> constantly scroll left and right look for cells you need to fill in.  You
>> will have to exclude them when you export/save as csv.  However, keeping
>> the input columns together on the left should make this very easy.  You can
>> duplicate the sheet and delete them, you can have two different files: XLSX
>> and CSV, you can copy and paste into Notepad++ and CTRL+H replace tabs (\t)
>> with commas (,).  There's a few options there.  Anyway, I find it much
>> nicer to input the data this way.  I hope it helps you too.
>>
>>
>>
>> Do this:
>>
>>
>>
>> [image: image.png]
>>
>>
>>
>> Not this:
>>
>>
>>
>> [image: image.png]
>>
>>
>>
>>
>>
>>
>>
>> On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi  wrote:
>>
>>
>>
>> We really need to start to minimize the amount of custom scripts /
>> programming that we use, not increase it.
>>
>>
>>
>> It’s a bit of a long story.
>>
>>
>>
>> So I need to use the built-in tools.
>>
>>
>>
>> :(
>>
>>
>>
>> We might just stick with super copy if bulk admin doesn’t work out.
>>
>>
>>
>> Lelio
>>
>> *-sent from mobile device-*
>>
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>>
>> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>> Why not roll your own build tool in Python?  You can ask questions here,
>> as lots of us have Python and AXL experience, and then more people get to
>> benefit from the collaboration.
>>
>>
>>
>> Just think how cool it would be to build your very own Jarvis:
>>
>>
>>
>> 
>>
>>
>>
>> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>>
>>
>>
>> It’s been a while since I’ve used Bulk Admin Tool.
>>
>>
>>
>> Wondering how it might help with our Jabber deployment.
>>
>>
>>
>> I’m thinking, since our requests will co

Re: [cisco-voip] Bulk Admin and Jabber

[Anthony Holloway]

"... when we know the device name for the softphones needs to be the userID"

Just to be clear, it does not.  That was an old CUPC requirement, and the
new requirements are as follows:

CSF = could be whatever you want, e.g., banana (unless you have QM call
recording, then it needs to be all caps CSFSOMETHING for QM)
TCT = must be all caps TCTSOMETHING
BOT =  must be all caps BOTSOMETHING
TAB = must be all caps TABSOMETHING

None of them however, need the User ID in the name.  Could be TCTBANANA for
example.

Maybe that's not what you meant.  Maybe you meant, for your company's
standard build, but I thought I'd address that, since other people might
have read that it needed to be that way.

On Fri, Sep 13, 2019 at 10:25 AM Lelio Fulgenzi  wrote:

> This looks like an interesting option. I’ll have to see how much effort it
> takes to get the templates set up in order for us to use this.
>
>
>
> I didn’t like the fact that it’s asking me to fill in the device name,
> when we know the device name for the softphones needs to be the userID. So
> this is a step that could lead to errors and extra effort.
>
>
>
> I know this sounds like _*I*_ don’t want to do this stuff, but when
> you’re preparing instructions for a group of people with varying skill
> sets, the less work required the better.
>
>
>
> At least we have some options.
>
>
>
>
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Brian Meade 
> *Sent:* Friday, September 13, 2019 11:02 AM
> *To:* Lelio Fulgenzi 
> *Cc:* Anthony Holloway ; cisco-voip voyp
> list 
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> Have you tried using the Quick/User Phone Add?  That works pretty well.
> Just assign device/line templates to user profiles and adding a
> CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at
> most.
>
>
>
> On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi  wrote:
>
> I guess it’s a combo of built-in tools and tools people are familiar with.
>
>
>
> I like the idea, but again, adding extra steps like that might not work.
> Now, that being said, I wonder if I can modify the order in which the
> columns are presented to the import tool? If they allow headers, that
> should be ok, right?
>
>
>
> I might be stuck with looking for green columns for the first round. ☹
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Anthony Holloway 
> *Sent:* Friday, September 13, 2019 10:31 AM
> *To:* Lelio Fulgenzi 
> *Cc:* cisco-voip voyp list 
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> "...I need to use the built-in tools..."
>
>
>
> So, Excel + BAT is built-in, and Python + AXL is not?
>
>
>
> I kid, I kid.  I get that there's a common familiarity with Excel and not
> one with Python.
>
>
>
> I have a recommendation when working with BAT import files in Excel.
> Insert a few input columns to the left of the actual data, and then drive
> your entire spreadsheet with formulas.  This will save you from having to
> constantly scroll left and right look for cells you need to fill in.  You
> will have to exclude them when you export/save as csv.  However, keeping
> the input columns together on the left should make this very easy.  You can
> duplicate the sheet and delete them, you can have two different files: XLSX
> and CSV, you can copy and paste into Notepad++ and CTRL+H replace tabs (\t)
> with commas (,).  There's a few options there.  Anyway, I find it much
> nicer to input the data this way.  I hope it helps you too.
>
>
>
> Do this:
>
>
>
> [image: image.png]
>
>
>
> Not this:
>
>
>
> [image: image.png]
>
>
>
>
>
>
>
> On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi  wrote:
>
>
>
> We really need to start to minimize the amount of custom scripts /
> programming that we use, not increase i

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

This looks like an interesting option. I’ll have to see how much effort it 
takes to get the templates set up in order for us to use this.

I didn’t like the fact that it’s asking me to fill in the device name, when we 
know the device name for the softphones needs to be the userID. So this is a 
step that could lead to errors and extra effort.

I know this sounds like _I_ don’t want to do this stuff, but when you’re 
preparing instructions for a group of people with varying skill sets, the less 
work required the better.

At least we have some options.



---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Brian Meade 
Sent: Friday, September 13, 2019 11:02 AM
To: Lelio Fulgenzi 
Cc: Anthony Holloway ; cisco-voip voyp list 

Subject: Re: [cisco-voip] Bulk Admin and Jabber

Have you tried using the Quick/User Phone Add?  That works pretty well.  Just 
assign device/line templates to user profiles and adding a 
CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at most.

On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
I guess it’s a combo of built-in tools and tools people are familiar with.

I like the idea, but again, adding extra steps like that might not work. Now, 
that being said, I wonder if I can modify the order in which the columns are 
presented to the import tool? If they allow headers, that should be ok, right?

I might be stuck with looking for green columns for the first round. ☹

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>
Sent: Friday, September 13, 2019 10:31 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: cisco-voip voyp list 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Bulk Admin and Jabber

"...I need to use the built-in tools..."

So, Excel + BAT is built-in, and Python + AXL is not?

I kid, I kid.  I get that there's a common familiarity with Excel and not one 
with Python.

I have a recommendation when working with BAT import files in Excel.  Insert a 
few input columns to the left of the actual data, and then drive your entire 
spreadsheet with formulas.  This will save you from having to constantly scroll 
left and right look for cells you need to fill in.  You will have to exclude 
them when you export/save as csv.  However, keeping the input columns together 
on the left should make this very easy.  You can duplicate the sheet and delete 
them, you can have two different files: XLSX and CSV, you can copy and paste 
into Notepad++ and CTRL+H replace tabs (\t) with commas (,).  There's a few 
options there.  Anyway, I find it much nicer to input the data this way.  I 
hope it helps you too.

Do this:

[image.png]

Not this:

[image.png]



On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook


On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
dec

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

Will try this… thanks.

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Brian Meade 
Sent: Friday, September 13, 2019 11:02 AM
To: Lelio Fulgenzi 
Cc: Anthony Holloway ; cisco-voip voyp list 

Subject: Re: [cisco-voip] Bulk Admin and Jabber

Have you tried using the Quick/User Phone Add?  That works pretty well.  Just 
assign device/line templates to user profiles and adding a 
CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at most.

On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
I guess it’s a combo of built-in tools and tools people are familiar with.

I like the idea, but again, adding extra steps like that might not work. Now, 
that being said, I wonder if I can modify the order in which the columns are 
presented to the import tool? If they allow headers, that should be ok, right?

I might be stuck with looking for green columns for the first round. ☹

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>
Sent: Friday, September 13, 2019 10:31 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: cisco-voip voyp list 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Bulk Admin and Jabber

"...I need to use the built-in tools..."

So, Excel + BAT is built-in, and Python + AXL is not?

I kid, I kid.  I get that there's a common familiarity with Excel and not one 
with Python.

I have a recommendation when working with BAT import files in Excel.  Insert a 
few input columns to the left of the actual data, and then drive your entire 
spreadsheet with formulas.  This will save you from having to constantly scroll 
left and right look for cells you need to fill in.  You will have to exclude 
them when you export/save as csv.  However, keeping the input columns together 
on the left should make this very easy.  You can duplicate the sheet and delete 
them, you can have two different files: XLSX and CSV, you can copy and paste 
into Notepad++ and CTRL+H replace tabs (\t) with commas (,).  There's a few 
options there.  Anyway, I find it much nicer to input the data this way.  I 
hope it helps you too.

Do this:

[image.png]

Not this:

[image.png]



On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook


On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on 

Re: [cisco-voip] Bulk Admin and Jabber

[Brian Meade]

Have you tried using the Quick/User Phone Add?  That works pretty well.
Just assign device/line templates to user profiles and adding a
CSF/TCT/RDP/Deskphone/TAB/BOT device for a user takes all of a minute at
most.

On Fri, Sep 13, 2019 at 10:42 AM Lelio Fulgenzi  wrote:

> I guess it’s a combo of built-in tools and tools people are familiar with.
>
>
>
> I like the idea, but again, adding extra steps like that might not work.
> Now, that being said, I wonder if I can modify the order in which the
> columns are presented to the import tool? If they allow headers, that
> should be ok, right?
>
>
>
> I might be stuck with looking for green columns for the first round. ☹
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Anthony Holloway 
> *Sent:* Friday, September 13, 2019 10:31 AM
> *To:* Lelio Fulgenzi 
> *Cc:* cisco-voip voyp list 
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> "...I need to use the built-in tools..."
>
>
>
> So, Excel + BAT is built-in, and Python + AXL is not?
>
>
>
> I kid, I kid.  I get that there's a common familiarity with Excel and not
> one with Python.
>
>
>
> I have a recommendation when working with BAT import files in Excel.
> Insert a few input columns to the left of the actual data, and then drive
> your entire spreadsheet with formulas.  This will save you from having to
> constantly scroll left and right look for cells you need to fill in.  You
> will have to exclude them when you export/save as csv.  However, keeping
> the input columns together on the left should make this very easy.  You can
> duplicate the sheet and delete them, you can have two different files: XLSX
> and CSV, you can copy and paste into Notepad++ and CTRL+H replace tabs (\t)
> with commas (,).  There's a few options there.  Anyway, I find it much
> nicer to input the data this way.  I hope it helps you too.
>
>
>
> Do this:
>
>
>
> [image: image.png]
>
>
>
> Not this:
>
>
>
> [image: image.png]
>
>
>
>
>
>
>
> On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi  wrote:
>
>
>
> We really need to start to minimize the amount of custom scripts /
> programming that we use, not increase it.
>
>
>
> It’s a bit of a long story.
>
>
>
> So I need to use the built-in tools.
>
>
>
> :(
>
>
>
> We might just stick with super copy if bulk admin doesn’t work out.
>
>
>
> Lelio
>
> *-sent from mobile device-*
>
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
>
> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> Why not roll your own build tool in Python?  You can ask questions here,
> as lots of us have Python and AXL experience, and then more people get to
> benefit from the collaboration.
>
>
>
> Just think how cool it would be to build your very own Jarvis:
>
>
>
> 
>
>
>
> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>
>
>
> It’s been a while since I’ve used Bulk Admin Tool.
>
>
>
> Wondering how it might help with our Jabber deployment.
>
>
>
> I’m thinking, since our requests will come in one at a time, the best
> approach would be to create a BAT file that has a line for each device
> type. We’ve decided to load all types so users can switch devices out/in as
> they wish.
>
>
>
> Can you bulk load _without_ using a template?
>
>
>
> What have others done with respect to Jabber bulk loads?
>
>
>
> Lelio
>
> *-sent from mobile device-*
>
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Charles Goldsmith]

Yeah, Hunt Groups complain, but with phone devices, I've found you can
change things around, at least when doing a partial information import with
templates.  I don't remember if I've tried to move things during an import
all phones type, but I try to steer clear of those types of imports.

Let's not even discuss MGCP gateway migration/imports.  Luckily I haven't
had to deal with them recently, but historically, they were a nightmare.

On Fri, Sep 13, 2019 at 9:50 AM Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> Nope!  I actually just did this a week ago with Hunt Pilots, Hunt Lists
> and Line Groups.  The import failed when I moved the columns around, and I
> had to revert the order.  It's safe to say that the column order matters in
> some instances.  Feel free to play with it though.
>
> On Fri, Sep 13, 2019 at 9:42 AM Lelio Fulgenzi  wrote:
>
>> I guess it’s a combo of built-in tools and tools people are familiar
>> with.
>>
>>
>>
>> I like the idea, but again, adding extra steps like that might not work.
>> Now, that being said, I wonder if I can modify the order in which the
>> columns are presented to the import tool? If they allow headers, that
>> should be ok, right?
>>
>>
>>
>> I might be stuck with looking for green columns for the first round. ☹
>>
>>
>>
>> ---
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>>
>>
>> *From:* Anthony Holloway 
>> *Sent:* Friday, September 13, 2019 10:31 AM
>> *To:* Lelio Fulgenzi 
>> *Cc:* cisco-voip voyp list 
>> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>>
>>
>>
>> "...I need to use the built-in tools..."
>>
>>
>>
>> So, Excel + BAT is built-in, and Python + AXL is not?
>>
>>
>>
>> I kid, I kid.  I get that there's a common familiarity with Excel and not
>> one with Python.
>>
>>
>>
>> I have a recommendation when working with BAT import files in Excel.
>> Insert a few input columns to the left of the actual data, and then drive
>> your entire spreadsheet with formulas.  This will save you from having to
>> constantly scroll left and right look for cells you need to fill in.  You
>> will have to exclude them when you export/save as csv.  However, keeping
>> the input columns together on the left should make this very easy.  You can
>> duplicate the sheet and delete them, you can have two different files: XLSX
>> and CSV, you can copy and paste into Notepad++ and CTRL+H replace tabs (\t)
>> with commas (,).  There's a few options there.  Anyway, I find it much
>> nicer to input the data this way.  I hope it helps you too.
>>
>>
>>
>> Do this:
>>
>>
>>
>> [image: image.png]
>>
>>
>>
>> Not this:
>>
>>
>>
>> [image: image.png]
>>
>>
>>
>>
>>
>>
>>
>> On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi  wrote:
>>
>>
>>
>> We really need to start to minimize the amount of custom scripts /
>> programming that we use, not increase it.
>>
>>
>>
>> It’s a bit of a long story.
>>
>>
>>
>> So I need to use the built-in tools.
>>
>>
>>
>> :(
>>
>>
>>
>> We might just stick with super copy if bulk admin doesn’t work out.
>>
>>
>>
>> Lelio
>>
>> *-sent from mobile device-*
>>
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>>
>> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>> Why not roll your own build tool in Python?  You can ask questions here,
>> as lots of us have Python and AXL experience, and then more people get to
>> benefi

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

Ugh. That’s a drag.

I’ll also have to consider importing devices without DNs (if that’s possible). 
Because our DNs will have different classes of service, forwarding rules, etc. 
Or, seeing which columns are required, like Charles mentioned. If I can simply 
add a DN and it takes the settings from the existing DN, that would be great.



---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
Sent: Friday, September 13, 2019 10:50 AM
To: Lelio Fulgenzi 
Cc: cisco-voip voyp list 
Subject: Re: [cisco-voip] Bulk Admin and Jabber

Nope!  I actually just did this a week ago with Hunt Pilots, Hunt Lists and 
Line Groups.  The import failed when I moved the columns around, and I had to 
revert the order.  It's safe to say that the column order matters in some 
instances.  Feel free to play with it though.

On Fri, Sep 13, 2019 at 9:42 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
I guess it’s a combo of built-in tools and tools people are familiar with.

I like the idea, but again, adding extra steps like that might not work. Now, 
that being said, I wonder if I can modify the order in which the columns are 
presented to the import tool? If they allow headers, that should be ok, right?

I might be stuck with looking for green columns for the first round. ☹

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>>
Sent: Friday, September 13, 2019 10:31 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: cisco-voip voyp list 
mailto:cisco-voip@puck.nether.net>>
Subject: Re: [cisco-voip] Bulk Admin and Jabber

"...I need to use the built-in tools..."

So, Excel + BAT is built-in, and Python + AXL is not?

I kid, I kid.  I get that there's a common familiarity with Excel and not one 
with Python.

I have a recommendation when working with BAT import files in Excel.  Insert a 
few input columns to the left of the actual data, and then drive your entire 
spreadsheet with formulas.  This will save you from having to constantly scroll 
left and right look for cells you need to fill in.  You will have to exclude 
them when you export/save as csv.  However, keeping the input columns together 
on the left should make this very easy.  You can duplicate the sheet and delete 
them, you can have two different files: XLSX and CSV, you can copy and paste 
into Notepad++ and CTRL+H replace tabs (\t) with commas (,).  There's a few 
options there.  Anyway, I find it much nicer to input the data this way.  I 
hope it helps you too.

Do this:

[image.png]

Not this:

[image.png]



On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook


On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Re: [cisco-voip] Bulk Admin and Jabber

[Anthony Holloway]

Nope!  I actually just did this a week ago with Hunt Pilots, Hunt Lists and
Line Groups.  The import failed when I moved the columns around, and I had
to revert the order.  It's safe to say that the column order matters in
some instances.  Feel free to play with it though.

On Fri, Sep 13, 2019 at 9:42 AM Lelio Fulgenzi  wrote:

> I guess it’s a combo of built-in tools and tools people are familiar with.
>
>
>
> I like the idea, but again, adding extra steps like that might not work.
> Now, that being said, I wonder if I can modify the order in which the
> columns are presented to the import tool? If they allow headers, that
> should be ok, right?
>
>
>
> I might be stuck with looking for green columns for the first round. ☹
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Anthony Holloway 
> *Sent:* Friday, September 13, 2019 10:31 AM
> *To:* Lelio Fulgenzi 
> *Cc:* cisco-voip voyp list 
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> "...I need to use the built-in tools..."
>
>
>
> So, Excel + BAT is built-in, and Python + AXL is not?
>
>
>
> I kid, I kid.  I get that there's a common familiarity with Excel and not
> one with Python.
>
>
>
> I have a recommendation when working with BAT import files in Excel.
> Insert a few input columns to the left of the actual data, and then drive
> your entire spreadsheet with formulas.  This will save you from having to
> constantly scroll left and right look for cells you need to fill in.  You
> will have to exclude them when you export/save as csv.  However, keeping
> the input columns together on the left should make this very easy.  You can
> duplicate the sheet and delete them, you can have two different files: XLSX
> and CSV, you can copy and paste into Notepad++ and CTRL+H replace tabs (\t)
> with commas (,).  There's a few options there.  Anyway, I find it much
> nicer to input the data this way.  I hope it helps you too.
>
>
>
> Do this:
>
>
>
> [image: image.png]
>
>
>
> Not this:
>
>
>
> [image: image.png]
>
>
>
>
>
>
>
> On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi  wrote:
>
>
>
> We really need to start to minimize the amount of custom scripts /
> programming that we use, not increase it.
>
>
>
> It’s a bit of a long story.
>
>
>
> So I need to use the built-in tools.
>
>
>
> :(
>
>
>
> We might just stick with super copy if bulk admin doesn’t work out.
>
>
>
> Lelio
>
> *-sent from mobile device-*
>
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
>
> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> Why not roll your own build tool in Python?  You can ask questions here,
> as lots of us have Python and AXL experience, and then more people get to
> benefit from the collaboration.
>
>
>
> Just think how cool it would be to build your very own Jarvis:
>
>
>
> 
>
>
>
> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>
>
>
> It’s been a while since I’ve used Bulk Admin Tool.
>
>
>
> Wondering how it might help with our Jabber deployment.
>
>
>
> I’m thinking, since our requests will come in one at a time, the best
> approach would be to create a BAT file that has a line for each device
> type. We’ve decided to load all types so users can switch devices out/in as
> they wish.
>
>
>
> Can you bulk load _without_ using a template?
>
>
>
> What have others done with respect to Jabber bulk loads?
>
>
>
> Lelio
>
> *-sent from mobile device-*
>
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

I guess it’s a combo of built-in tools and tools people are familiar with.

I like the idea, but again, adding extra steps like that might not work. Now, 
that being said, I wonder if I can modify the order in which the columns are 
presented to the import tool? If they allow headers, that should be ok, right?

I might be stuck with looking for green columns for the first round. ☹

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
Sent: Friday, September 13, 2019 10:31 AM
To: Lelio Fulgenzi 
Cc: cisco-voip voyp list 
Subject: Re: [cisco-voip] Bulk Admin and Jabber

"...I need to use the built-in tools..."

So, Excel + BAT is built-in, and Python + AXL is not?

I kid, I kid.  I get that there's a common familiarity with Excel and not one 
with Python.

I have a recommendation when working with BAT import files in Excel.  Insert a 
few input columns to the left of the actual data, and then drive your entire 
spreadsheet with formulas.  This will save you from having to constantly scroll 
left and right look for cells you need to fill in.  You will have to exclude 
them when you export/save as csv.  However, keeping the input columns together 
on the left should make this very easy.  You can duplicate the sheet and delete 
them, you can have two different files: XLSX and CSV, you can copy and paste 
into Notepad++ and CTRL+H replace tabs (\t) with commas (,).  There's a few 
options there.  Anyway, I find it much nicer to input the data this way.  I 
hope it helps you too.

Do this:

[image.png]

Not this:

[image.png]



On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook


On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Charles Goldsmith]

This goes without saying, but I'll say it anyway for clarification.

It will fail, if it's a required field :)

On Fri, Sep 13, 2019 at 9:38 AM Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> CUCM does not fail because of blank cells, causing lots of consecutive
> commas.  That's normal.  In fact, it's even discussed/shown in the example
> files:
>
> [image: image.png]
>
> [image: image.png]
>
> On Fri, Sep 13, 2019 at 9:28 AM Lelio Fulgenzi  wrote:
>
>> Ok. So I tested exporting CSF and TCT phones. As I suspected, they’re
>> different. There’s a whole bunch of extra columns for the available DNs for
>> CSF.
>>
>>
>>
>> If I want to import both CSF and TCT phones at the same time, I wonder
>> what the strategy is here?
>>
>>
>>
>> I’m fine with just leaving those columns blank, but will CUCM barf at
>> seeing those extra commas for the TCT phones? There’s a validation process
>> I believe – could try that too.
>>
>>
>>
>> Lelio
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ---
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>>
>>
>> *From:* Evgeny Izetov 
>> *Sent:* Thursday, September 12, 2019 10:33 PM
>> *To:* Lelio Fulgenzi 
>> *Cc:* Anthony Holloway ; cisco-voip
>> voyp list 
>> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>>
>>
>>
>> You can use Import/Export configuration with all details. No need for
>> template and can import different types of devices at the same time.
>>
>>
>>
>> On Thu, Sep 12, 2019 at 8:24 PM Lelio Fulgenzi  wrote:
>>
>>
>>
>> We really need to start to minimize the amount of custom scripts /
>> programming that we use, not increase it.
>>
>>
>>
>> It’s a bit of a long story.
>>
>>
>>
>> So I need to use the built-in tools.
>>
>>
>>
>> :(
>>
>>
>>
>> We might just stick with super copy if bulk admin doesn’t work out.
>>
>>
>>
>> Lelio
>>
>> *-sent from mobile device-*
>>
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>>
>> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>> Why not roll your own build tool in Python?  You can ask questions here,
>> as lots of us have Python and AXL experience, and then more people get to
>> benefit from the collaboration.
>>
>>
>>
>> Just think how cool it would be to build your very own Jarvis:
>>
>>
>>
>> 
>>
>>
>>
>> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>>
>>
>>
>> It’s been a while since I’ve used Bulk Admin Tool.
>>
>>
>>
>> Wondering how it might help with our Jabber deployment.
>>
>>
>>
>> I’m thinking, since our requests will come in one at a time, the best
>> approach would be to create a BAT file that has a line for each device
>> type. We’ve decided to load all types so users can switch devices out/in as
>> they wish.
>>
>>
>>
>> Can you bulk load _without_ using a template?
>>
>>
>>
>> What have others done with respect to Jabber bulk loads?
>>
>>
>>
>> Lelio
>>
>> *-sent from mobile device-*
>>
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Charles Goldsmith]

This is really good advice, and how I always build out a system.  You not
only have devices to import, but line association, end-user update (add
device association to the end user) and unity connection imports.  I always
have a master XLSX file with the raw data, columns are linked into another
XLSX for each import type

On Fri, Sep 13, 2019 at 9:31 AM Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> "...I need to use the built-in tools..."
>
> So, Excel + BAT is built-in, and Python + AXL is not?
>
> I kid, I kid.  I get that there's a common familiarity with Excel and not
> one with Python.
>
> I have a recommendation when working with BAT import files in Excel.
> Insert a few input columns to the left of the actual data, and then drive
> your entire spreadsheet with formulas.  This will save you from having to
> constantly scroll left and right look for cells you need to fill in.  You
> will have to exclude them when you export/save as csv.  However, keeping
> the input columns together on the left should make this very easy.  You can
> duplicate the sheet and delete them, you can have two different files: XLSX
> and CSV, you can copy and paste into Notepad++ and CTRL+H replace tabs (\t)
> with commas (,).  There's a few options there.  Anyway, I find it much
> nicer to input the data this way.  I hope it helps you too.
>
> Do this:
>
> [image: image.png]
>
> Not this:
>
> [image: image.png]
>
>
>
> On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi  wrote:
>
>>
>> We really need to start to minimize the amount of custom scripts /
>> programming that we use, not increase it.
>>
>> It’s a bit of a long story.
>>
>> So I need to use the built-in tools.
>>
>> :(
>>
>> We might just stick with super copy if bulk admin doesn’t work out.
>>
>> Lelio
>>
>> *-sent from mobile device-*
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>> Why not roll your own build tool in Python?  You can ask questions here,
>> as lots of us have Python and AXL experience, and then more people get to
>> benefit from the collaboration.
>>
>> Just think how cool it would be to build your very own Jarvis:
>>
>> 
>>
>> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>>
>>>
>>> It’s been a while since I’ve used Bulk Admin Tool.
>>>
>>> Wondering how it might help with our Jabber deployment.
>>>
>>> I’m thinking, since our requests will come in one at a time, the best
>>> approach would be to create a BAT file that has a line for each device
>>> type. We’ve decided to load all types so users can switch devices out/in as
>>> they wish.
>>>
>>> Can you bulk load _without_ using a template?
>>>
>>> What have others done with respect to Jabber bulk loads?
>>>
>>> Lelio
>>>
>>> *-sent from mobile device-*
>>>
>>>
>>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>>
>>> Computing and Communications Services | University of Guelph
>>>
>>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>>> N1G 2W1
>>>
>>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>>
>>>
>>>
>>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>>
>>>
>>>
>>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>> ___
>>> cisco-voip mailing list
>>> cisco-voip@puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Anthony Holloway]

CUCM does not fail because of blank cells, causing lots of consecutive
commas.  That's normal.  In fact, it's even discussed/shown in the example
files:

[image: image.png]

[image: image.png]

On Fri, Sep 13, 2019 at 9:28 AM Lelio Fulgenzi  wrote:

> Ok. So I tested exporting CSF and TCT phones. As I suspected, they’re
> different. There’s a whole bunch of extra columns for the available DNs for
> CSF.
>
>
>
> If I want to import both CSF and TCT phones at the same time, I wonder
> what the strategy is here?
>
>
>
> I’m fine with just leaving those columns blank, but will CUCM barf at
> seeing those extra commas for the TCT phones? There’s a validation process
> I believe – could try that too.
>
>
>
> Lelio
>
>
>
>
>
>
>
>
>
> ---
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* Evgeny Izetov 
> *Sent:* Thursday, September 12, 2019 10:33 PM
> *To:* Lelio Fulgenzi 
> *Cc:* Anthony Holloway ; cisco-voip voyp
> list 
> *Subject:* Re: [cisco-voip] Bulk Admin and Jabber
>
>
>
> You can use Import/Export configuration with all details. No need for
> template and can import different types of devices at the same time.
>
>
>
> On Thu, Sep 12, 2019 at 8:24 PM Lelio Fulgenzi  wrote:
>
>
>
> We really need to start to minimize the amount of custom scripts /
> programming that we use, not increase it.
>
>
>
> It’s a bit of a long story.
>
>
>
> So I need to use the built-in tools.
>
>
>
> :(
>
>
>
> We might just stick with super copy if bulk admin doesn’t work out.
>
>
>
> Lelio
>
> *-sent from mobile device-*
>
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
>
> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> Why not roll your own build tool in Python?  You can ask questions here,
> as lots of us have Python and AXL experience, and then more people get to
> benefit from the collaboration.
>
>
>
> Just think how cool it would be to build your very own Jarvis:
>
>
>
> 
>
>
>
> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>
>
>
> It’s been a while since I’ve used Bulk Admin Tool.
>
>
>
> Wondering how it might help with our Jabber deployment.
>
>
>
> I’m thinking, since our requests will come in one at a time, the best
> approach would be to create a BAT file that has a line for each device
> type. We’ve decided to load all types so users can switch devices out/in as
> they wish.
>
>
>
> Can you bulk load _without_ using a template?
>
>
>
> What have others done with respect to Jabber bulk loads?
>
>
>
> Lelio
>
> *-sent from mobile device-*
>
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Anthony Holloway]

"...I need to use the built-in tools..."

So, Excel + BAT is built-in, and Python + AXL is not?

I kid, I kid.  I get that there's a common familiarity with Excel and not
one with Python.

I have a recommendation when working with BAT import files in Excel.
Insert a few input columns to the left of the actual data, and then drive
your entire spreadsheet with formulas.  This will save you from having to
constantly scroll left and right look for cells you need to fill in.  You
will have to exclude them when you export/save as csv.  However, keeping
the input columns together on the left should make this very easy.  You can
duplicate the sheet and delete them, you can have two different files: XLSX
and CSV, you can copy and paste into Notepad++ and CTRL+H replace tabs (\t)
with commas (,).  There's a few options there.  Anyway, I find it much
nicer to input the data this way.  I hope it helps you too.

Do this:

[image: image.png]

Not this:

[image: image.png]



On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi  wrote:

>
> We really need to start to minimize the amount of custom scripts /
> programming that we use, not increase it.
>
> It’s a bit of a long story.
>
> So I need to use the built-in tools.
>
> :(
>
> We might just stick with super copy if bulk admin doesn’t work out.
>
> Lelio
>
> *-sent from mobile device-*
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> Why not roll your own build tool in Python?  You can ask questions here,
> as lots of us have Python and AXL experience, and then more people get to
> benefit from the collaboration.
>
> Just think how cool it would be to build your very own Jarvis:
>
> 
>
> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>
>>
>> It’s been a while since I’ve used Bulk Admin Tool.
>>
>> Wondering how it might help with our Jabber deployment.
>>
>> I’m thinking, since our requests will come in one at a time, the best
>> approach would be to create a BAT file that has a line for each device
>> type. We’ve decided to load all types so users can switch devices out/in as
>> they wish.
>>
>> Can you bulk load _without_ using a template?
>>
>> What have others done with respect to Jabber bulk loads?
>>
>> Lelio
>>
>> *-sent from mobile device-*
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

Ok. So I tested exporting CSF and TCT phones. As I suspected, they’re 
different. There’s a whole bunch of extra columns for the available DNs for CSF.

If I want to import both CSF and TCT phones at the same time, I wonder what the 
strategy is here?

I’m fine with just leaving those columns blank, but will CUCM barf at seeing 
those extra commas for the TCT phones? There’s a validation process I believe – 
could try that too.

Lelio




---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Evgeny Izetov 
Sent: Thursday, September 12, 2019 10:33 PM
To: Lelio Fulgenzi 
Cc: Anthony Holloway ; cisco-voip voyp list 

Subject: Re: [cisco-voip] Bulk Admin and Jabber

You can use Import/Export configuration with all details. No need for template 
and can import different types of devices at the same time.

On Thu, Sep 12, 2019 at 8:24 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook


On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

I’m good with that. We did something similar with Webex where we exported, then 
I highlighted the columns that needed data and then we exported to CSV and 
imported. I’m thinking the same thing will happen. The team was OK with that.

Just thinking though… there are a few steps we do before actually programming 
the devices, i.e. updating the user’s information to include the correct 
details.

I’m guessing we still do that manually. We could try bulk importing, but 
sometimes, a few manual steps is easier.

Lelio


---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Charles Goldsmith 
Sent: Friday, September 13, 2019 9:38 AM
To: Lelio Fulgenzi 
Cc: Evgeny Izetov ; cisco-voip voyp list 

Subject: Re: [cisco-voip] Bulk Admin and Jabber

Yes sir, you'll find it's VERY large.

On Fri, Sep 13, 2019 at 8:27 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:
Thanks.

I’m wondering, can I do an export first as a starting point?

Will try it.

Thx.
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook


On Sep 12, 2019, at 10:33 PM, Evgeny Izetov 
mailto:eize...@gmail.com>> wrote:
You can use Import/Export configuration with all details. No need for template 
and can import different types of devices at the same time.

On Thu, Sep 12, 2019 at 8:24 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook


On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Lelio
-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Charles Goldsmith]

Yes sir, you'll find it's VERY large.

On Fri, Sep 13, 2019 at 8:27 AM Lelio Fulgenzi  wrote:

> Thanks.
>
> I’m wondering, can I do an export first as a starting point?
>
> Will try it.
>
> Thx.
>
> *-sent from mobile device-*
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
> On Sep 12, 2019, at 10:33 PM, Evgeny Izetov  wrote:
>
> You can use Import/Export configuration with all details. No need for
> template and can import different types of devices at the same time.
>
> On Thu, Sep 12, 2019 at 8:24 PM Lelio Fulgenzi  wrote:
>
>>
>> We really need to start to minimize the amount of custom scripts /
>> programming that we use, not increase it.
>>
>> It’s a bit of a long story.
>>
>> So I need to use the built-in tools.
>>
>> :(
>>
>> We might just stick with super copy if bulk admin doesn’t work out.
>>
>> Lelio
>>
>> *-sent from mobile device-*
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
>> avholloway+cisco-v...@gmail.com> wrote:
>>
>> Why not roll your own build tool in Python?  You can ask questions here,
>> as lots of us have Python and AXL experience, and then more people get to
>> benefit from the collaboration.
>>
>> Just think how cool it would be to build your very own Jarvis:
>>
>> 
>>
>> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>>
>>>
>>> It’s been a while since I’ve used Bulk Admin Tool.
>>>
>>> Wondering how it might help with our Jabber deployment.
>>>
>>> I’m thinking, since our requests will come in one at a time, the best
>>> approach would be to create a BAT file that has a line for each device
>>> type. We’ve decided to load all types so users can switch devices out/in as
>>> they wish.
>>>
>>> Can you bulk load _without_ using a template?
>>>
>>> What have others done with respect to Jabber bulk loads?
>>>
>>> Lelio
>>>
>>> *-sent from mobile device-*
>>>
>>>
>>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>>
>>> Computing and Communications Services | University of Guelph
>>>
>>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>>> N1G 2W1
>>>
>>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>>
>>>
>>>
>>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>>
>>>
>>>
>>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>> ___
>>> cisco-voip mailing list
>>> cisco-voip@puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

Thanks.

I’m wondering, can I do an export first as a starting point?

Will try it.

Thx.

-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 
2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

On Sep 12, 2019, at 10:33 PM, Evgeny Izetov 
mailto:eize...@gmail.com>> wrote:

You can use Import/Export configuration with all details. No need for template 
and can import different types of devices at the same time.

On Thu, Sep 12, 2019 at 8:24 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio

-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:

Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Lelio

-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Evgeny Izetov]

You can use Import/Export configuration with all details. No need for
template and can import different types of devices at the same time.

On Thu, Sep 12, 2019 at 8:24 PM Lelio Fulgenzi  wrote:

>
> We really need to start to minimize the amount of custom scripts /
> programming that we use, not increase it.
>
> It’s a bit of a long story.
>
> So I need to use the built-in tools.
>
> :(
>
> We might just stick with super copy if bulk admin doesn’t work out.
>
> Lelio
>
> *-sent from mobile device-*
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
> avholloway+cisco-v...@gmail.com> wrote:
>
> Why not roll your own build tool in Python?  You can ask questions here,
> as lots of us have Python and AXL experience, and then more people get to
> benefit from the collaboration.
>
> Just think how cool it would be to build your very own Jarvis:
>
> 
>
> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:
>
>>
>> It’s been a while since I’ve used Bulk Admin Tool.
>>
>> Wondering how it might help with our Jabber deployment.
>>
>> I’m thinking, since our requests will come in one at a time, the best
>> approach would be to create a BAT file that has a line for each device
>> type. We’ve decided to load all types so users can switch devices out/in as
>> they wish.
>>
>> Can you bulk load _without_ using a template?
>>
>> What have others done with respect to Jabber bulk loads?
>>
>> Lelio
>>
>> *-sent from mobile device-*
>>
>>
>> *Lelio Fulgenzi, B.A.* | Senior Analyst
>>
>> Computing and Communications Services | University of Guelph
>>
>> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
>> N1G 2W1
>>
>> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>> ___
>> cisco-voip mailing list
>> cisco-voip@puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

We really need to start to minimize the amount of custom scripts / programming 
that we use, not increase it.

It’s a bit of a long story.

So I need to use the built-in tools.

:(

We might just stick with super copy if bulk admin doesn’t work out.

Lelio

-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 
2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

On Sep 12, 2019, at 7:48 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:

Why not roll your own build tool in Python?  You can ask questions here, as 
lots of us have Python and AXL experience, and then more people get to benefit 
from the collaboration.

Just think how cool it would be to build your very own Jarvis:



On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Lelio

-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Anthony Holloway]

Why not roll your own build tool in Python?  You can ask questions here, as
lots of us have Python and AXL experience, and then more people get to
benefit from the collaboration.

Just think how cool it would be to build your very own Jarvis:

[image: image.png]

On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:

>
> It’s been a while since I’ve used Bulk Admin Tool.
>
> Wondering how it might help with our Jabber deployment.
>
> I’m thinking, since our requests will come in one at a time, the best
> approach would be to create a BAT file that has a line for each device
> type. We’ve decided to load all types so users can switch devices out/in as
> they wish.
>
> Can you bulk load _without_ using a template?
>
> What have others done with respect to Jabber bulk loads?
>
> Lelio
>
> *-sent from mobile device-*
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Bulk Admin and Jabber

[Charles Goldsmith]

You can do an Export/Import > Import phones, but it's more complex.  I
always use templates for my deployments.

On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi  wrote:

>
> It’s been a while since I’ve used Bulk Admin Tool.
>
> Wondering how it might help with our Jabber deployment.
>
> I’m thinking, since our requests will come in one at a time, the best
> approach would be to create a BAT file that has a line for each device
> type. We’ve decided to load all types so users can switch devices out/in as
> they wish.
>
> Can you bulk load _without_ using a template?
>
> What have others done with respect to Jabber bulk loads?
>
> Lelio
>
> *-sent from mobile device-*
>
>
> *Lelio Fulgenzi, B.A.* | Senior Analyst
>
> Computing and Communications Services | University of Guelph
>
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
>
> 519-824-4120 Ext. 56354 <519-824-4120;56354> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] Bulk Admin and Jabber

[Lelio Fulgenzi]

It’s been a while since I’ve used Bulk Admin Tool.

Wondering how it might help with our Jabber deployment.

I’m thinking, since our requests will come in one at a time, the best approach 
would be to create a BAT file that has a line for each device type. We’ve 
decided to load all types so users can switch devices out/in as they wish.

Can you bulk load _without_ using a template?

What have others done with respect to Jabber bulk loads?

Lelio

-sent from mobile device-

Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 
2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip