[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-voip at 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 <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
>>
>>
>>
>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>
>> 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
>>>
>>>
>>>
>>> [image: University of Guelph Cornerstone with Improve Life tagline]
>>> _______________________________________________
>>> 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/3ee1d56e/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 10402 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20190913/3ee1d56e/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 9109 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20190913/3ee1d56e/attachment-0001.png>