[cisco-voip] Bulk Admin and Jabber

Charles Goldsmith w at woka.us
Fri Sep 13 10:54:37 EDT 2019


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-voip at 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 <lelio at 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 | lelio at uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>>
>>
>> *From:* Anthony Holloway <avholloway+cisco-voip at gmail.com>
>> *Sent:* Friday, September 13, 2019 10:31 AM
>> *To:* Lelio Fulgenzi <lelio at uoguelph.ca>
>> *Cc:* cisco-voip voyp list <cisco-voip at 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: image.png]
>>
>>
>>
>> Not this:
>>
>>
>>
>> [image: image.png]
>>
>>
>>
>>
>>
>>
>>
>> On Thu, Sep 12, 2019 at 7:24 PM Lelio Fulgenzi <lelio at 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 <519-824-4120;56354> | lelio at uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>>
>> On Sep 12, 2019, at 7:48 PM, Anthony Holloway <
>> avholloway+cisco-voip at 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:
>>
>>
>>
>> <image.png>
>>
>>
>>
>> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi <lelio at 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 <519-824-4120;56354> | lelio at uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20190913/c37b5df5/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1297 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20190913/c37b5df5/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 10402 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20190913/c37b5df5/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 9109 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20190913/c37b5df5/attachment-0002.png>


More information about the cisco-voip mailing list