Outputs all values of a MT130U Cable Modem accessible over the LAN and echos the values in csv format for later analysis.

example_output.csv

get_signal_data.sh

#!/bin/sh
  
# Execute using screen so the connection is maintained
# ssh server-name, screen -S signal, ./get_signal_data.sh, ctrl+a+d, exit
  
# Captures modem signal data every 2 minutes
while [ true ]
do
    python2 /usr/local/bin/model_signal_to_csv.py >> signal_data.csv
    sleep 2m
done

modem_signal_to_csv.py

#!/usr/bin/env python

"""
Outputs all values of a MT130U Cable Modem accessible over the LAN and echos
the values in csv format for later analysis.

Example cron job:
#!/bin/bash
modem_signal_to_csv.py >> /var/log/modem_signal.log.csv

"""

"""
# To install dependency in OSX
sudo easy_install pip
sudo pip install beautifulsoup4

# To install dependency in ArchLinux
sudo pacman -S community/python2-beautifulsoup4
"""

import time
import urllib2
from bs4 import BeautifulSoup

modem_connection_html = "http://192.168.100.1/RgConnect.asp"
csvDelimiter = ','


# Converts an html table into a single row csv string
def html_table_to_csv(html_table):
    output = ""
    for row in html_table.findAll("tr"):
        for column in row.findAll("td"):
            output += column.text + csvDelimiter
    return output

# Download the modem connection information and find all table elements
soup = BeautifulSoup(urllib2.urlopen(modem_connection_html).read())
tables = soup.findAll("table", {"class": "tbl_connection"})

# Tables have content in the same order every time
# Simplify script and do not use the header name to determine column

# Output epoch timestamp
output_row = str(int(time.time())) + csvDelimiter

# Extract each table to a csv file
# Downstream information
output_row += html_table_to_csv(tables[1])

# Downstream correctable/uncorrectable total
output_row += html_table_to_csv(tables[2])

# Upstream information
output_row += html_table_to_csv(tables[3])

# Output the row to be consumed by a pipe.
print output_row,