Required from customer
- "ap_inventory.csv" - an inventory file of customer's APs, with (at min.) the following columns:
- "ap_number"
- "mac_address"
Customers often provide a spreadsheet with AP mac addresses in various formats.
The Cisco AireOS WLC works with Expanded Unix format, which is colon-delimited between bytes.
There are two parts to this Python 'app'; 'sanimacs.py' can be used by itself to parse
any mac format, from customer file named 'ap_inventory.csv'. It strips delimiters
and outputs bare mac-addresses.
'Sanimacs.py' also removes any rows with empty fields or invalid mac-addrs based on
length (too short / long) or some typos (invalid characters).
The script, 'AireOS_MACfan.py' uses output from previous script (sanimacs.py) to format macs for AireOS and create AP naming commands, which are output to text file, 'ap_naming.txt'. The naming convention here is just a site code and AP number. Can be adapted to fit your customer's naming convention.
Save customer's spreadsheet to CSV format, ensuring that the AP name/number and
mac-address columns are named "ap_number" and "mac_address", respectively.
"requirements.txt" PIP file is included for necessary modules.