Edit this text file to include your e-mail instead of asdf@asdf.com. Then paste the whole TXT file contents into a terminal window for your Mikrotik. It will create the script and set it to send daily at 11:50PM.

I recently had a customer of my WISP ask if we could give her a way to log when her employees are working remotely. She doesn't have a huge infrastructure with sophisticated logging abilities. She felt that her employees were claiming to work when they really weren't even logged in.

This is a two part script. One part runs on the Mikrotik, the other as a PHP script running on their server in the office.

Ok... Since it looks like UBNT isn't excited about pulling data from AC1 into AC2, I whipped up a python script that copies the GPS coordinates from AC1 to the device so that it can be used in AC2.

WARNING!!!: THIS MAY BREAK YOUR NETWORK.

Don't say I didn't warn you.

That said, I have run it against my network and it just caused breif outages while devices rebooted.

#
# AC1 -> AC2 Coordinate Pusher 1.0
# Jim Bouse
# 8/13/2013
# jim@mobileitpro.com
#
# This script runs on Python 3.3.2 on Windows.
# I have not tested against any other OS or version
# This script may destroy your network.
# This script may destroy your network.
# This script may destroy your network.
# I really mean it. If this script blows your network up,
# I'm sorry but I did warn you.
#
# The purpose of this script is to query AirControl v1 and populate
# the coordinates from AC1 into the config file in the devices.
# When the coordinates are in the config file, AirControl v2 properly
# places the device after discovery.
#
# NOTE: <------ READ THIS !!!
# This script reboots the devices after the file change.
# This means you will lose connection and it will be a problem if you # do it during a busy time.
# GOOD NEWS is that it only does it on the devices that need it.
# BAD NEWS is that it will have to be run a few times to get all the
# devices in your org,
# because if it reboots an AP, the clients will not be able to be
# connected to until the next pass.
#
#
# Instructions: Place this script and plink into the same directory.
# Open a command prompt and CD to the directory.
# Run this file.
#

About Jim Bouse

I grew up with computers being a part of my life. I set up my first 'network' by 15 (in 1997) and have been exploring innovative ways to make the lives easier for everyday people using tools readibly available.

After working for Texas A&M University as a Senior Systems Administrator designing and maintaining a GIS system that is used by thousands of users daily, I left to launch my Wireless ISP (BrazosWiFi).

We started the ISP in 2012 and have experienced tremendous growth. We have hundreds of wireless customers and a few hard-wire customers near the fiber-optic nodes.