Pyramid Hill Sculpture Park
Pyramid Hill is an outdoor museum focusing on monumental pieces of sculpture in an environment of meadows, forests, and various gardens.
They take just a few minutes each day and use the site engine utilities to make certain that site visitors always have the most current information about new sculptures
and special events.
Holiday Auto Theatre
The Holiday is one of the last operating drive-in movie theaters in the United States.
In addition to being able to quickly update their on-line marquee and add links to the movies
currently being shown, they also use the mailing list tool to send email out every Thursday or Friday letting
list members know what movies are being shown that weekend.
The Hamilton Community Foundation
The Hamilton Community Foundation serves as a leader, catalyst, and resource for philanthropy in the area of Hamilton, Ohio.
Site Engine utilities allow them to quickly update web site information about their various programs and services to the community.
Butler County Dept. of Job & Family Services
Of the projects listed on this page, this system has been in place a little longer and is a little bigger than the others listed below. In Butler County alone, this system
is helping 180 workers serve the needs of about 200,000 client while efficiently manageing over four million
single and multiple page documents, consisting of a little over 14 million pages. This system is currently deployed in 17 other Ohio Counties. The system can be deployed using either an Oracle of SQL Server database.
Ohio Dept of Mental Retardation & Developmental Disabilities
This system was designed to the unique requirements of OHMRDD, which included interacting with outside agencies, supporting customer advocates, and meeting several special security requirements including cases where a agency customer is also an employee of that same agency.
System Image Auditor
Built to compliment the various document management solutions, the System Image Auditor verifies the viability of images stored in the database and compares actual results against metadata stored about that image. This utility not only attests to the quality of new entries, but also is used to reverify older items as protection against database instability or other kinds of potential data loss.
Butler County JFS Supervisory Tools
BCDJFS managers wanted a simple way to review 4 essential aspects of agency employee productivity. Because the reports
are based on a manager's own unit, they first confirm the list of employees that report to them, which is
presented in an easy to understand, hierarchal display. The essential reports are created in real-time and have both summary and detailed views
of the information since the last time the manager looked at the report.
The goal of this project was to provide non-technical managers with a way to access
run and modify complex queries on their own without using database-specific stored
procedures. Someone familiar with SQL write the initial query using proprietary keywords
for the replaceable parameters. That query is then held in a database table. The manager can
change the parameters to suit the situation and run the report when they need it, not
when someone else can get around to it.
The Mmole Control
Mmole, which is an acronym for "Mark Down & Mail Our Little Errors", can be installed in programs as an integral part of error-trapping strategy. First, it automatically grabs the error message and logs it to a file. Then, depending on settings, Mmole can do things a few different ways. Maybe you want to set it up to ask the user if they would like to file a report, and then record their response and follow through on their wishes. Or maybe you just want it to automatically and quietly email you a report, along with the entire contents of the log file, the username, and the identifier of the computer where the problem occurred. Because the programming team finds out about the problem quickly, bugs can be addressed in a timely fashion, and users can be satisfied that they are working with system support they can rely on.
And, of course, Mmole can also be used to provide standard outbound email services for other parts of the application.
This is just a cute little web-based ASP utility designed to interact with a database table designed to hold memos or notes.
Written in VBScript, the Paste-It NotePad uses a server DSN and ODBC connectivity to communicate with virtually any SQL-compliant database, such as Oracle or SQL Server.
Another ODBC/SQL Client
This tool has come in quite handy more than once! No more awkward poking around on a client machine trying to locate a simple
SQL client just so you can make certain that the database is online and the statements are correct.
Another ODBC/SQL Client is a field testing tool for checking connectivity and interactions with virtually any SQL-compliant database. Just type in
the connection info and away you go. Past SQL statements are stored in a queue and can be easily recalled.
This is layer 5
Talk About Notebook add-on
Talk about MMole control