Maintaining RADIUS and WiFi list

Anna has requested that we provide a list of user logins (for Cypress Glen Resident) and WiFi passwords.

There are no direct export options for either, unfortunately, so some manual data manipulation is necessary.

Export RADIUS users

Connect to the Cypress Glen Unifi Controller session in ScreenConnect
Open the Unifi Radius Manager web page (it's probably already open in Chrome)
1. if you don't see it, look at Chrome's history to find the most recent access of that page)
2. It's not currently set for a static IP so if you bookmark it, it might change
Login (test/asdf)
Go to the RADIUS tab
Expand the table to show the maximum number of entries per page
Using the table search feature, search for "cg"
Do a simple copy/paste of all the rows - highlight all the rows and CTRL+C then paste them into an empty spreadsheet
Do this for each page of results
Clean up the spreadsheet: Remove all columns except the username, VLAN, and password columns.
Move the cleaned up data into the master spreadsheet linked at the top of this page

Connect to the Cypress Glen Unifi Controller session in ScreenConnect
Open Explorer and go to the C: drive
Open the "Unifi-API-browser-##" folder
Shift+Right click any empty space in this folder and "Open PowerShell Window here"
Run the command php -S localhost:90
An HTTP server will begin running at port 90 and you will get confirmation of this in the console window
In Chrome, go to http://localhost:90
Select Cypress Glen as the Controller and Cypress Glen as the site
Select Collections -> Configuration -> "list wlan configuration"
Use the copy button in the top right of the WLAN list output to copy it all
Paste it into Notepad and save it in the Documents folder as "wlan.json"
Navigate to Documents in Explorer
Shift + Right click any empty space in this folder and "Open PowerShell Window here"
Run python .\wlan_scrape.py
Copy the comma delimited output
Paste it into the WLAN sheet on the spreadsheet linked above
Use the little paste icon that appears immediately after pasting to "split values into columns"