Filemaker Consultants Houston, Filemaker Developer 6, filemaker technical support, database cross-platform engine, Texas, TX, Hal Payne, Project Management, Filemaker developers, Filemaker pro, database windows, database mac, filemaker solutions alliance associate, database system management

Filemaker Consultants Houston, Filemaker Developer 6, filemaker technical support, database cross-platform engine, Texas, TX, Hal Payne, Project Management, Filemaker developers, Filemaker pro, database windows, database mac, filemaker solutions alliance associate, database system management

Filemaker Consultants Houston, Filemaker Developer 6, filemaker technical supportFilemaker Consultants Houston, Filemaker Developer 6, filemaker technical support Filemaker Consultants Houston, Filemaker Developer 6, filemaker technical support
 

August 2002 Newsletter
<Previous IssueSubscribeNext Issue>

The Well-Oiled Machine
Pennzoil-Quaker State Company is a worldwide leader in consumer car care and maintenance products.

Their Creative Services Department is responsible for producing the collateral, packaging and point-of-purchase materials for over forty divisions.

Projects range from updating retail packaging to creating decals for the racing team.

Various combinations of fifty people comprising eighteen groups of approvers are included in the routing of layouts.

The old system utilized some handwritten forms and an Access database that evolved over the years on an as-needed basis with help from the IT Department.

We were hired to streamline the systems and processes associated with producing the growing quantity and complexity of projects Creative Services takes on.

Handwritten forms have been eliminated. Project information is input once into the database so that every form printed has the data relevant to that process. There’s even a hyper-formatted Microsoft Word Job Request form that can be emailed to clients around the world. Status exports to Excel are similarly shared.

A Job can have dozens of Components with the same deadline yet different production schedules, so Component listings are automatically sorted by Release Date and printed on Job Jackets.

Once you’ve checked off all the appropriate reviewers on the Master Approval Form, a single click brings up an email pre-addressed to them all, with the Job Number and Name in the Subject line.

We even migrated data from the old system into a new Filemaker Archive file, minimizing the need to switch between systems during the transition.

This system was launched five weeks ago, and has gotten rave reviews from users and management alike. We made a couple of minor adjustments along the way, but nothing that entailed interruption of service.

For us, the perfect client: A relatively small team producing large numbers of projects with multiple elements on tight schedules.

For Pennzoil-Quaker State, we hope our solution lives up to the slogan for their Jiffy Lube franchise: The Well-Oiled Machine.

Personal Fall Arrests
McCrory and Associates is a marketing firm serving the safety industry. They represent a small number of the finest manufacturers of safety products, from fire-retardant clothing to emergency drench showers to (our favorite) personal fall arrest equipment.

They’ve used Filemaker to generate invoice, commission and inventory reports for over a decade.

It started out simple, like most databases developed in-house. The system evolved under the stewardship of various administrators that made changes as sales, product lines and the company expanded.

Certain database conventions were not followed, and keeping the system current was labor-intensive. A true real-time inventory solution was needed. More reporting options were desired.

We couldn’t identify a path to enhance the existing system in a way that would meet current objectives and future expansion possibilities like an online store.

Building a system from the ground up was an option, but we went looking for invoice/inventory templates, and ultimately saved a lot of time and money.

The best templates provide basic features that can be built upon.

This client needed multi-tiered pricing, editable product descriptions at the invoice level and other unique capabilities.

Templates that included these features would seem cluttered if you didn’t need them.

We enhanced them accordingly and imported data from the old system. The client cleaned up the data. We were on the inventory team the Saturday before launch..

And it’s going great. Nearly 400 invoices for 1,100 items were created in the first 3 weeks. We’ve spent a few hours making adjustments and enhancements, with virtually no interruption of service.

Hey, just give us a call when you’re ready to control your world.

Do good work and stay in touch.

<Previous IssueSubscribeNext Issue>


In Greater Houston, dial 713-956-6940

NEWSLETTERS & ARTICLES
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 1819
Project Management in the Relatively New MillenniumChicken Bones

THE COMPANY

Home Screen Shots Case Histories
Ideal ProjectsNonprofit Services
Filemaker Tech Support $25/Call

 

Filemaker Consultants Houston, Filemaker Developer 6, filemaker technical support, database cross-platform engine, Texas, TX, Hal Payne, Project Management, Filemaker developers, Filemaker pro, database windows, database mac, filemaker solutions alliance associate, database system management