[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 <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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20190913/6726c7ef/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/6726c7ef/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/6726c7ef/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/6726c7ef/attachment-0002.png>