Project Showreel

Some of the projects in which Scott has been involved through the years

Lab Assistant ca. 1986

Lab Assistant Screen

Developed at California State University Northridge's Center for Public Archaeology with Dr. L. Mark Raab, Lab Assistant was designed for use in archaeology and anthropology labs to automate the cataloging of artifacts and skeletal remains using digital instruments such as electronic calipers and balances (scales). Lab Assistant included a pre-configured menu system which matched the UCSB taxonomy and catalog system of the day. Lab Assistant was a tool designed specifically for laboratory data entry at a reasonable cost.

Originally developed for MS DOS, Lab Assistant was written in Nantucket's Clipper Compiler programming language, versions "August 86" and "Summary 87".

From marketing material in ArchaeoMation's 1990 catalog...

A Data Entry, Editing, and Reporting Tool

Lab Assistant is a data entry and editing program designed to aid the researcher in the task of accurately entering large and small amounts of laboratory data into a computerized database system. While providing easy and intuitive access to data files, the program offers the data-entry features missing from most database, spreadsheet, and statistical packages.

What it does ...

Lab Assistant combines a menu-assisted text entry system with a direct instrument-to-computer link to a variety of laboratory instruments for fast, efficient, and error-free data entry. The program produces dBASE III+ compatible databases or ASCII text files for compatibility with a wide range of commercially available analytical packages. Data recorded or edited with Lab Assistant is accessible by packages such as dBASE, Reflex, Paradox, Lotus 1-2-3, Symphony, Systat, and many others.

ArchaeoMation Business ca. 1990

ArchaeoMation Logo

Started circa 1990, ArchaeoMation was a business in which we sold Lab Assistant and COMLink software and electronic instrument packages for use in university labs, museums, cultural resource management firms, and government agencies across the United States. The software was developed by Scott as a compatible but affordable alternative to the costly database packages of the day such as dBASE and Paradox. In addition, the software supported any RS-232C serial interface instrument and provided a direct link between the data entry form and the instrument.

See the ArchaeoMation Client List, circa 1999.

A copy of the original business website is available in the ArchaeoMation Archive. Warning: pages are straight from 1990!

Mission Registers / Early California Population Project ca. 1994

Mission Register sample

The Mission Registers program was developed with Dr. John Johnson at the Santa Barbara Museum of Natural History. The application was designed to record baptism, marriage, and burial records taken from various missions in the California Mission System. The orignal census registers, Padrones, were compiled by Spanish mission workers from 1769 to 1850.

Within the baptism, marriage, and burial records of each of the California missions sits an extraordinary wealth of unique information on the Indians, soldiers, and settlers of Alta California.

Work on the Mission Registers program contributed to the beginning of the Early California Population Project at the Huntington Library in San Marino, California.

The Mission Registers application was first developed in the xBASE language, made popular by Ashton-Tate's dBASE database management system, and Nantucket's Clipper Compiler. The application was later ported to Microsoft Access and COM components written in Microsoft's Visual Basic.

HR Horizons ca. 1996

HR Horizons People Screen

HR Horizons, produced by Advanced Information Management in Santa Barbara, California, was a market leader in the Talent Management and Incentive Compensation industry. It was used extensively by Fortune 1000 companies throughout the United States, Canada and the UK.

HR Horizons started as a desktop application written in Microsoft's Access database. From there it grew to a client-server version, and finally to an n-Tier web-based application suitable for enterprise deployment to tens of thousands of users. The client-server version used a Microsoft Access front-end to relational database backends including SQL Server, Oracle, and DB2. The n-Tier version was implemented in Microsoft’s .NET Framework and included an “Enterprise Services Broker” middleware service based on Microsoft’s Component Object Model (COM) technology. After being sold to Authoria in the early 2000’s, the application was ported to a Java-based implementation.

CINSF Super System ca. 2005

CINSF Super System

The Super System was designed to accurately collect electronic return information for the Cook Islands National Superannuation Office. The Super System provides a simple database of employees and a worksheet for recording monthly superannuation contributions. The resulting 'electronic returns' are communicated to the CINSF office via email. The Super System is a free tool to aid employers who do not have other software to manage their staff.

The Super System was written in Microsoft's Visual Basic language. At the time the Super System was developed, .NET was yet to be widely adopted, and we needed a language that offered maximum productivity with a minimal deployment footprint. At the time the Super System was deployed, few businesses had a reliable Internet connection, and computers were relatively low-powered.

The application uses Microsoft's JET Database Engine to store data in MS Access format database files and produces monthly Super returns in .XML files which are emailed to the CINSF Office for processing.

CINSF Tracking System ca. 2005

CINSF Tracking System

The CINSF Tracking System is designed to collect and track voluntary and compulsory Superannuation contributions from Government ministries, State Owned Enterprises (SOEs), and private employers throughout the Cook Islands. The system is used by the CINSF office staff to manage the Superannuation Fund's day-to-day tasks. The Tracking System provides the following major features:

  • Imports and analyses electronic returns from Employers and Government
  • Generates employer payslips and bank deposit information
  • Tracks Fund membership and members' contribution histories
  • Stores member documents and contact history
  • Reporting and Graphing
  • Communicates encrypted Fund data to Registry Managers in New Zealand
  • Provides a Return Workflow for managing return processing

The CINSF Tracking System is a Microsoft Access application which acts as a front-end to a SQL Server 2012 database. In addition, core business logic is implemented in COM components written in Visual Basic 6 and stored procedures written in TransactSQL. Because the CINSF Office uses Microsoft Office, the system is designed to integrate with other Office desktop applications including MS Word, Excel, and Outlook.

CINSF Public Counter ca. 2007

CINSF Tracking System

Public Counter was developed to enable CINSF staff to accept in-office payments of Superannuation returns by employers and members. The payment and receipting functions were implemented in a separate application, separate from other Fund functions in order to keep non-payment related information secure from public visibility. Public Counter provides the following major functions:

  • Lists returns available for payment
  • Records payments
  • Generates receipts to a receipt printer
  • Calculates and applies penalty fees
  • Generates employer statements

Pubic Counter is a Microsoft Access application which acts as a front-end to the SQL Server database used by Tracking System. In addition, core business logic is implemented in COM components shared with Tracking System.

NextMinute Job Management ca. 2007

Next Minute Bookings

NextMinute is a job managment system developed for Greenwood Online. NextMinute includes an administrative Silverlight application with iOS and Android clients. In addition, NextMinute integrates with various other web-based services such as Xero. NextMinute is located at www.nextminute.com

Five years in the making, NextMinute is one of the first large, line-of-business applications developed in Microsoft's Silverlight language. The application is deployed on Microsoft's Azure cloud computing platform and uses a SQL-Azure database backend.

A PowerPoint presentation describing this solution in more details is available here. A Google Slides version is available here.

Google AppsAgent ca. 2007

AppsAgent Email Sample

AppsAgent is a Google AppEngine application designed to process documents bound for GoogleApps for Business’s “Drive”. While AppsAgent has an HTML user interface for configuration, all other communiation with AppsAgent is done through email. Emails received by AppsAgent are parsed and any attachments are processed and stored in pre-selected GoogleApps Drive accounts. AppsAgent’s primary function is to upload documents and images to one’s GoogleApps account via email. AppsAgent supports multiple client GoogleApps destination accounts and differentiates based on the email address used to communicate with it.

AppsAgent is written in Python and deployed on Google’s AppEngine platform. AppsAgent makes extensive use of Google's Data API for Python clients.

GConvert ca. 2008

GConvert Screenshot

GConvert is a Windows service designed to integrate with GoogleApps for Business accounts. GConvert scans a GMail account for document attachments and converts WordXML documents to a .doc format suitable for uploading to Google’s Drive service and Docs application. GConvert assures that uploaded documents are editable in the Docs application. In addition, GConvert communicates RESTfully with a web-based legal office application, LawyerHelp, written in PHP. GConvert was a bespoke creation for an Auckland-area Law Office.

GConvert is written in Microsoft’s .NET Framework using the C# language and Google Data API for .NET clients. GConvert can be deployed on a Windows Workstation or in Microsoft’s Azure cloud platform on a virtual machine.