Zis Mac
Alan Zisman on the Mac
FileMaker Developer at the Heart of Environmental Company's Success
- 2010.08.05 - Tip Jar
Follow Alan Zisman on Twitter.
Popularity: 
Short link: http://bit.ly/dsvlsC
Database developers don't get no respect. Over the past 20 years, Steven Barer, of local database development firm Oak Bay Softrends in Vancouver, British Columbia, Canada, has built customized software based on the FileMaker Pro database.
However, he has received little public recognition for this sort of behind-the-scenes work that can change the way small to mid-sized businesses function.
Barer understands that custom database development is "not a glitzy business," but he contends that it can be "an integral part of the success of and, often a competitive edge for, many successful companies."
One of Oak Bay's clients, M&R Environmental in Burnaby, BC, began collecting plastic oil containers for recycling in 1994 with four employees and a single truck. At the time, it tracked customers and scheduled pickups using recipe cards. Now with a staff of 50, the company manages a fleet of 15 trucks.
Quickly outgrowing the recipe cards, it looked for off-the-shelf scheduling software. Finding nothing that seemed to do what it needed, M&R turned to Oak Bay in 1996. What it got started out as "a simple scheduling program," according to company controller Dani Mate, but "it was flexible enough that we could add in new functionality as it became necessary." Now, several rewrites later, she said "everything we do lives in this program."
Along with scheduling pickups and deliveries, it now keeps inventory of what has grown from one to 319 products: recycled antifreeze, plastics, oil, and more. A bridge to M&R's accounting software allows the company to invoice its more than 5,000 customers and to provide Mate with "information at my fingertips" as required.
M&R's FileMaker-based software evolved as the company grew; both Barer and Mate note that this required a close working relationship where Oak Bay had to learn about M&R's business and M&R had to learn about the capabilities of FileMaker. Along the way, Mate became an unofficial co-developer of her company's customized software. Now she feels she "can call and ask for changes and know that they can happen."
Company president George Mate noted that, while the initial costs seemed high for a struggling young business, "from day one, the software has been expandable."
He agreed that the collaboration between Barer and his wife has been "vital" to allowing the software to be customized to meet M&R's needs.
For M&R, the big test in the ability to modify the software came on July 1, 2003, when new regulations for the waste oil collection industry involved paperwork, invoicing and accounting. On that day, it was the only company in BC with processes in place for the change-over.
New releases of the core FileMaker product have brought new capabilities to M&R's custom solution. Now, for instance, it can export from the database to spreadsheets and use colour coding to make it easier to recognize different product types or other data categories.
Also new: sales reps can access product inventory and other information from their iPhones.
In total, 20 M&R employees involved in sales, scheduling, and invoicing have varying levels of access to the database.
George Mate suggests that, compared with his competitors, M&R has more effective software that has been able to evolve with the company's vision.
Added Dani Mate: "There's nobody in the industry that does what we do in terms of our data. Nobody. It's pretty impressive to be able to say to a client, here's a complete report of everything we've done for you, down to how many litres of waste oil we hauled away on Tuesday."
By opting for a customized database and by learning to work with the
software developers, M&R has gotten software that fits its needs
and that evolves as those needs grow and change. Concluded Dani Mate,
"It allows us to be more nimble than our competitors."
First published in Business in Vancouver, April 6 - 12, 2010 issue #1067.
Join us on Facebook. Follow us on Twitter.
Alan Zisman is Mac-using teacher and technology writer based in Vancouver, BC, Canada. Many of his articles are available on his website, www.zisman.ca. If you find Alan's articles helpful, please consider making a donation to his tip jar.
Other articles by Alan Zisman
- LogMeIn: Remote Screen Sharing for the Rest of Us, 2012.02.09. Configuring the Mac's built-in screen sharing to work over the Internet can be difficult or impossible. LogMeIn makes it easy.
- VMware Fusion 4 vs Parallels Desktop 7: The Virtualization Battle Continues, 2012.01.18. Over the years VMware and Parallels have both improved signficantly, but which is better in 2012?
- Tech 2012: Everyone Wants a Piece of Apple or Facebook, 2012.01.10. Just as last year, companies want to steal market share from Apple or create a real competitor for Facebook.
- More in the Zis Mac index.
Links for the Day
- Mac of the Day: Outbound Laptop and Notebook, introduced 1989.09. The best known among the early Mac clones.
- February 11 in LEM history: 98: Disposable modems - 00: Setting up a Mac web server - Small network backup solutions - 02: Flea market Mac Plus - I love this Quadra! - 03: Jaguar revisited - Beige G3 upgrades - 05: The key to Apple's success - Which iPod is best for you? - 08: Could a wireless dock be in the MacBook Air's future? - 2 of Apple's best notebooks ever
- Support Low End Mac
Recent Content on Low End Mac
- Fix Home Button Delay, Tablet the Ultimate Mobile PC, iPad Notebook a Possibility, and More, iOS News Review, 2012.02.10. Also using your iPad at work, two photo editors, a new iPad text editor, Macally's magnetic iPad 2 stand, and more.
- White MacBook Goes End-of-Life, Logitech Touch Mouse Supports Gestures, Firmware Updates, and More, The 'Book Review, 2012.02.10. Also MacBook Air better than any Ultrabook, docks for MacBook Pro models, Intel offers improved SSDs, and more.
- Apple's Support Lead Shipping, Smartphones Outsell PCs, OS X Ported to ARM by Intern, and More, Mac News Review, 2012.02.10. Also the power of Tex-Edit Plus, Google and Twitter are already censoring the Web, Snow Leopard Security Update, and more.
- Mac and iOS Browsers: Options Galore, Freeware Forum, 2012.02.10. Safari is adequate on Mac and great on iOS, but the range of good alternatives is stunning. LEM writers share their favorites.
- 15 Years Ago Motorola Unveiled the PowerPC G3, Low End Mac Round Table, 2012.02.06. The G3 processor was optimized for real world Mac software and made a big leap forward in efficiency.
- Don't Kill Caps Lock, Learning to Love the iOS Keyboard, and an Adaptive iPad Keyboard, Charles W. Moore, Miscellaneous Ramblings, 2012.02.06. The Caps Lock key has a useful function, the iPad's keyboard really is useful, and checking out an adaptive keyboard for the iPad.
- More links in our archive.
Recent Deals
- Best MacBook Air Deals
- Best iBook G4 Deals
- Best iPad Deals
- Best Classic Mac OS Deals
- Best Apple TV Deals
- Best 15" MacBook Pro Deals
- Best Power Mac G4 Deals
- Best Mac OS X 10.6 Deals
- More deals in our archive.
About LEM Support Usage Privacy Contact
Follow
Low End Mac on Twitter
Join Low End Mac
on Facebook
Low End Mac Reader Specials
TypeStyler 11 is now in the Mac App Store!! -- Special Introductory Price of $59.95!! -- To Buy From The Mac App Store Click Here Now!! Or buy direct
from Strider Software.
Don't install Parallels to play poker online! Poker Mac will show you how to download and install a native Mac poker and Mac Casino applications in minutes.
Favorite Sites
MacSurfer
Cult of Mac
Shrine of Apple
MacInTouch
MyAppleMenu
InfoMac
The Mac Observer
Accelerate Your Mac
RetroMacCast
PB Central
MacWindows
The Vintage Mac Museum
DealMac
Deal Brothers
Mac2Sell
Mac Driver Museum
JAG's House
System 6 Heaven
System 7 Today
the pickle's Low-End Mac FAQ
Affiliates
Amazon.com
The Apple Store
The iTunes Store
PC Connection Express
GainSaver
Parallels Desktop for Mac
eBay
