topic Use excel and create a in Wireless

Importing MAC address to 1602I-A-K9 series AP

Eric Kemsley — Mon, 05 Jul 2021 12:56:52 GMT

I have 5 1602I-A-K9 series AP's that I need to add 40 MAC addresses to. What is the best way to add the MAC addressees? I know how to do it one at a time, just looking for a more efficient way to do this.

System Software Filename:	ap1g2-k9w7-tar.152-2.JB2
System Software Version:	15.2(2)JB2

TIA,

Eric

Use excel and create a

Andrew MacTaggart — Mon, 10 Oct 2016 18:42:33 GMT

Use excel and create a formula to merge your mac + config so you can copy and paste the output to all your APs. paste the merged fields to a text file to make sure no funky stuff gets carried along.

https://support.office.com/en-us/article/Combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6

Will it add the password part

Eric Kemsley — Mon, 10 Oct 2016 19:06:45 GMT

Will it add the password part automatically?

it looks like this now:

username 00226966522d password 7 075F711E1C5F40534147595E00
username 00226966522d autocommand exit

try using 0 in the excel

Andrew MacTaggart — Mon, 10 Oct 2016 19:20:55 GMT

try using 0 in the excel

username 111122223333 password 0 111122223333

=(B1&" "&A1&" "&C1&" "&A1)