A Microsoft Access Database was designed to provide a simple reporting solution with customer market penetration information for Affiliate Management Personnel, the American Registry for Internet Numbers (ARIN), and Road Runner Corporate Offices. These reports analyzed a series of relational tables including a full customer table, cable node information, and general hub-site information. Once this information was analyzed reports would be produced by area, cable modem equipment, cable cards, and individual ports.
As the affiliated cable companies aggressive deployments continued, the tracking of IP Address utilization became increasing more difficult. For this purpose IP Address information was entered into the Microsoft Access Database. Additional scripts utilizing the technology from DOCSIS Cable Modem Information Tool collected customer PC and modem information. This information was then analyzed and e-mailed to Network Engineers every four hours.

The central Florida District was the 2nd Road Runner Service Corporation site to launch a DOCSIS only environment utilizing all Cisco and Compaq / NT based systems. During the initial launch, and up to a year later, no tools were available to help trouble shoot customer modem issues. The DOCSIS Cable Modem Information Tool allowed Affiliate Cable Technicians and Affiliate Road Runner Customer Support Representatives to view real-time information, historical cable plant information, and DOCSIS Cable Modem health statistics quickly and with the ability to isolate problems with enhanced filtering methods.
One of the major key points in designing this tool was to assist all varieties of affiliate technicians no matter their computer related experience. For this purpose specialized error handling was included to assist the affiliate when additional information is required or when the results of a search do not produce any data. A fully interactive web based manual and glossary was included. Due to its compatibility under most environments this script was distributed to the entire SE Region and later Nationally to other Road Runner Service Co affiliates.

Due to an aggressive deployment from the affiliated cable company it became necessary to renumber the IP Address ranges on each of the hub sites frequently. With every renumber the DNS for the associated IP Address ranges had to be updated. For this purpose a web based DNS Generation Script was implemented.
The DNS Generation Form allowed a person to enter a record name and set the associated begin and end IP Address range. Along with the ability to set up to four DNS records simultaneously a zone name and associated sub-domain information could be entered for creating Primary or Secondary zone information. The end results would be displayed on a web page, which could be saved as a text file and later imported into the Cisco Network Registrar DNS program.

Sending binary executable messages to customers was not feasible with the current mailing system provided by the Netscape Mail server. In order to work around this problem an additional Perl script was implemented into the existing account creation shell scripts on the UNIX servers.
These scripts would read a message from a configuration file, a text file, and a primary binary file that the marketing team could FTP to a given directory. Once the files were in place, the marketing script retrieved the message subject heading and file names of the programs to be attached from the configuration file. The body of the message would be formulated from an info file (plain text or html). The binary file would be read into plain text and converted to MIME Version 1.0 format.

Collecting clear and concise data had been a problem for many of the Managers for the Customer Support Representatives and those on the Engineering Team. A simple script was designed to collect all the required data necessary to escalate issues to a Level 4 Engineering Team. This provided Customer Support Representatives a simple guide for collecting data and acted as a secondary means for troubleshooting customer problems. Once the initial Customer Contact information and problem was entered, the script would determine if additional information was required or it would complete the escalation process. Copies of this request would be e-mailed to the Engineering Team, The Ticket Creator, and any additional Supervisors requested.

A backend Microsoft Access Database was designed to house basic MLS information for listing and selling real estate, homes, houses, commercial and investment properties. Relationships for realtors' profiles and images of the MLS properties were also implemented.
A front end website was designed utilizing HTML and Cold Fusion to interact with all of the data in the Microsoft Access Database. Basic templates were utilized to display information on the properties and/or realtors. Several form based queries allowed website viewers to search information by the most important MLS features including location, price range, size, and realtor.

Many of the commercial customers were requested the ability to control which users were allowed access to their web servers. In order to prevent these commercial customers from being able to access other administrative areas of the web server, an additional security script was required.
A web based script allowed individual web server administrators to view, update, and add usernames and passwords to a PWD file used by Netscape Web servers for security administration. The password information would be encrypted in a format acceptable to the Netscape Web Server.

Designed and implemented a Microsoft Access Database for recording Internet customers' information, with billing and technical support functions. Relations and sub forms were implemented to track several user names, registered domains, and ISDN services. These sub forms served for tracking All Calls from the first contact with the customer, technical support history, and all billing inquires. Special queries added compatibility to MYOB and via importing and exporting data. Other features included the ability to update customer information on several operating systems for Mail and Login Access.