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 <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 > > > > www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook > > > > [image: University of Guelph Cornerstone with Improve Life tagline] > > > > *From:* Anthony Holloway <avholloway+cisco-v...@gmail.com> > *Sent:* Friday, September 13, 2019 10:31 AM > *To:* Lelio Fulgenzi <le...@uoguelph.ca> > *Cc:* cisco-voip voyp list <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: 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 > > > > > 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 > > > > _______________________________________________ > 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