A couple months ago I decided to write an application to download the FCC database nightly and run table updates. I started writing the script in Perl, but ended up rewriting it in Python…because I’d never written anything in Python before. I also wanted to be able to access the database without a DB server, so I decided to use SQLite3. If you make changes or use my code please let me know, I’ll sleep better at knight knowing my time was not wasted.

#!/usr/bin/python
######################################
#
#
#   Copyright 2009
#   Kris Kirkland
#   K5KRK
#
#   This program is free software: you can redistribute it and/or modify
#   it under the terms of the GNU General Public License as published by
#   the Free Software Foundation, either version 3 of the License, or
#   (at your option) any later version.
#
#   This program is distributed in the hope that it will be useful,
#   but WITHOUT ANY WARRANTY; without even the implied warranty of
#   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#   GNU General Public License for more details.
#
#   You should have received a copy of the GNU General Public License
#   along with this program.  If not, see .
#
#
######################################

import sqlite3
import glob
import os
import cmd
import urllib
import datetime
import zipfile
import os
import sys
import gzip
import string
import logging
import shutil

########## User Config ##############
db_name = "hamdb.sqlite"
db_dir = "/var/www/"
#Must have trailing /
working_dir = "/tmp/hamdb/"
table_deff = "deff.txt"
#####################################

############ URLS ###################
deff_url = "http://wireless.fcc.gov/uls/data/documentation/pa_ddef44.txt"
fcc_zip_full = "http://wireless.fcc.gov/uls/data/complete/l_amat.zip"
fcc_zip_sun = "http://wireless.fcc.gov/uls/data/daily/l_am_sun.zip"
fcc_zip_mon = "http://wireless.fcc.gov/uls/data/daily/l_am_mon.zip"
fcc_zip_tue = "http://wireless.fcc.gov/uls/data/daily/l_am_tue.zip"
fcc_zip_wed = "http://wireless.fcc.gov/uls/data/daily/l_am_wed.zip"
fcc_zip_thu = "http://wireless.fcc.gov/uls/data/daily/l_am_thu.zip"
fcc_zip_fri = "http://wireless.fcc.gov/uls/data/daily/l_am_fri.zip"
fcc_zip_sat = "http://wireless.fcc.gov/uls/data/daily/l_am_sat.zip"
#####################################

########### Logging ################

###################################
#del_file = "rm -rf " +working_dir+
db_loc = os.path.join(db_dir, db_name)
now = datetime.datetime.now()

dow = now.strftime("%a")

#dow = 'Mon'

if dow == "Sun":
	get_url = fcc_zip_full
if dow == "Mon":
	get_url = fcc_zip_mon
if dow == "Tue":
	get_url = fcc_zip_tue
if dow == "Wed":
	get_url = fcc_zip_wed
if dow == "Thu":
	get_url = fcc_zip_thu
if dow == "Fri":
	get_url = fcc_zip_fri
if dow == "Sat":
	get_url = fcc_zip_sat

# Check to see if this is the first run
if not os.path.exists(db_loc):
	print '\nDatabase does not exists - Downloading complete version\n'
	print 'After completion rerun script in order to get the daily updates\n'
	dow = 'Sun'
	get_url = fcc_zip_full

if not os.path.exists(working_dir):
	os.makedirs(working_dir)

if not os.path.exists(db_dir):
	os.makedirs(db_dir)

print now.strftime("%b %d %H:%M:%S" ), 'Starting FCC Download and Import'

if dow == "Sun":
    if os.path.exists(os.path.join(working_dir, 'fcc.zip')):
        rm_fcc = "rm -rf " +working_dir+ "fcc.zip"
        os.system(rm_fcc)
    urllib.urlretrieve(deff_url, os.path.join(working_dir, table_deff))
    urllib.urlretrieve(get_url, os.path.join(working_dir, 'fcc.zip'))
    print now.strftime("%b %d %H:%M:%S" ), 'Download of', get_url, 'completed.'
    unzip = "/usr/bin/unzip " +working_dir+ "fcc.zip -d " +working_dir
    del_db = "rm -rf " +db_loc
    os.system(del_db)
    os.system(unzip)
    data = open(working_dir+table_deff,'r').read()
    data = data.replace('go\n','')
    data = data.replace(')\n',');\n')
    con = sqlite3.connect(db_loc)
    con.execute("attach '%s' AS dbo;" % (db_loc))
    con.executescript(data)
    con.commit()
    con.close()

else:
    if os.path.exists(os.path.join(working_dir, 'fcc.zip')):
        rm_fcc = "rm -rf " +working_dir+ "fcc.zip"
        os.system(rm_fcc)
    urllib.urlretrieve(get_url, os.path.join(working_dir, 'fcc.zip'))
    print now.strftime("%b %d %H:%M:%S" ), 'Download of', get_url, 'completed.'
    unzip = "/usr/bin/unzip " +working_dir+ "fcc.zip -d " +working_dir
    os.system(unzip)

files = glob.glob(working_dir+"*.dat")
for file in files:
    tableNameSuffix = os.path.splitext(os.path.basename(file))[0].upper()
    tableName = 'PUBACC_' + tableNameSuffix
    cmd = "sqlite3 -separator '|' %s '.import %s %s'" % (db_loc,file,tableName)
    print now.strftime("%b %d %H:%M:%S" ), 'File', file, 'imported into Table', tableName
    os.system(cmd)

shutil.rmtree(working_dir)
sys.exit()

Step 1: Tear apart the console, I recommend removing the lower portion of the console (shifting assembly) first.

Step 2: Cut notch into the “cubby” hole portion of the console to allow for the head unit control cable.

Step 3: Route all cables through console to the midsection of the drivers seat. All should then be routed under the seat, make sure the cables aren’t near the seat track.

Step 4: Put it all back together…

I created a “mounting bracket” using a 19 inch piece of flattened tin……stop laughing its all I had laying around.
The tin was wrapped around cardboard in order to create a light weight frame, the FT-7900r separation kit was mounted to the front of the tin frame.

Once its all snugged in, the mic cable is a little tight against the inside of the console.

Here is the final project:

Note: that location is actually my home QTH