Personal Code

This is in no way a showcase of my code, but rather, a publicly available repository for my own reference.


IBM OnDemand ACEPMD50 Invoice Converter

Purpose: To convert IBM OnDemand generated text files which
are created in an inconsistent format into a standard tab delimited
format which can be imported into Excel or Access. This allows the
CFM department to send electronic invoices to Fully Insured accounts
where the current method is paper based.

You can download a single group’s invoice by using IBM OnDemand.
Open folder ACEPMD50 and enter the appropriate information. This converter
specifically converts that file type only.

How It Works: The main method parses the input file one line at a time
and sends it to TestLine. If the line is a valid record, the fields
are parsed and put into a Record object. It's toString method returns
the line to append to the output file.
The UpdateGroup method retrieves the group number for the records
being parsed. It updates the group number being given to the records
whenever it's changed in the source file.
The TestLine function parses for a valid line via a series of while
loops and if statements. It's a very iterative process. Ideally it
would be replaced by applying a general expression to the line of text.

Requisites: This application requires Java 5 (JRE 1.5). It is used for
things like String.replaceAll().



Automated Drupal website statistics sent via text message.
Full article


This PERL script parses an iTunes managed folder and generates HTML output directly to a web browser. It creates links to each song in the music collection. You simply give it the absolute server path of the iTunes folder where each sub-folder is an artist name folder. I found this helpful in accessing my music collection from work without having to copy over a hard drive full of data.

This script generates a 3 columned table from images in a given directory. It dynamically generates thumbnails for each of those images to display, and allows the user to click on them to view the full size. The advantage of dynamically generating thumbnails is that you don't have to create them yourself and setup the links in the html. This script uses the PERL module Image Magick. Because it displays the thumbnails in the table and not the full sized images simply resized using the 'img' tag's height and width attributes, the table loads a lot faster. The disadvantage is that depending on the amount of images and the hardware running the script, this may take a significant time. The advantage is that to post images, you simply upload a whole folder of raw images and create the thumbnail directory. The script generates the html output to the browser.

Sample link of this script in action (may take a short while to load)


An SQL script to create the CAP database from UMB CS630 in a MySQL 5 database.