Alan’s OC Mod-Blog

Ramblings of a dot-com mogul

Applications

 

ClaimTrak
ClaimTrak is an application that replaced a legacy mainframe-based application for Safeco’s Surety business. There were many pieces to this project. Mainframe data was pulled using several COM objects to populate a SQL database. Users could create or modify existing claims, which shared data with the existing SuretyNet application.

Mainframe data is not available on this site, and therefore the page does not pull updated information. The main interesting aspect is the design and menu system.


 

OneCoast Intranet
OneCoast is a company that coordinates and distributes items for the gift industry. They host several trade shows to allow their clients a forum to display their wares to wholesale customers. OneCoast had a need for an internal intranet, as well as several other applications. Being an intranet application allowed tighter control of the browser, which allowed use of IE specific objects. This site was also designed to function as a Human Resources tool, with employee information stored in a SQL database that was eaily maintained through web forms. Heiarchial security was implemented that allowed users to update their own personal information. One of the neater aspects of this application wsa the use of an ASP-based calendar, which pulled event information from SQL and displayed a calendar using visual filters.

The initial page is the user login, which has been pre-filled. Just click “login” to continue to the main page.


 

Brian Valentine’s Direct Reports
This simple site was a common repository for executives in the Windows division to share files. Authorized users could upload files through a form, which was handled by a COM object. Information about the file was stored in a SQL database for organizational purposes. This site used a reusable template with a text-based menu system. I used the FileSystem object to open and parse the text file to display the menu. This method of menu creation allows quick changes without having to weed through HTML code.

This template was used for 3 other internal Microsoft applications, Windows 2000 Post Mortem, Windows Appliances, and Windows 3-year Plan. Actual document downloads have been removed for confidentiality purposes.


 

DHTML Content Management Tool
This tool was originally created for a suite of turnkey websites as a way for users to easily modify inner content. This uses IE specific objects to dynamically write HTML code as a user visually enters text in a familiar, Word-like interface. The code is then uploaded to a SQL server, along with other form information to organize the data. Since the code has special characters, it must be heavily filtered before insertion into SQL, and then unfiltered before display. This tool has gone through several revisions, the latest modification used as a content management system for Randy’s Ring & Pinion.


 

Windows Partners
The Windows operating system has many different components that coordinate together to make a complete package. The Windows Partners website was a central site that helped centralize these different departments. Management could easily view the status and other information about each piece, which assisted with project planning. The project manager saw the OneCoast design and wanted this site implemented with the same look.