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 <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 <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: >> >> <image.png> >> >> On Thu, Sep 12, 2019 at 5:22 PM Lelio Fulgenzi <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 <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