Month: December 2014

Since the first film hit the big screen in 1977, the Star Wars universe has expanded through sequels, prequels, books, video games and all manner of additional merchandise, making it likely the most extensive universe in fiction. Among passionate fans, a continuity error between two different episodes can lead to “Han shot first” levels of controversy. In order to avoid such contradictions, since 2000 Lucasfilm has maintained a vast database of characters, languages, planets, races, vehicles and weapons since the turn of the century.

The Holocron, named after a Force-powered repository of Jedi knowledge, is in fact a FileMaker database operated by Lucasfilm employee Leland Chee. Its full contents are strictly private, since it includes information on works that are in development. It goes into astounding levels of detail, such as providing names to characters who were never named and had but a single line in the films.

“A lot of that information, like naming of background characters, especially from the films, came from that Decipher collectible card game,” said Chee to NPR. “Most of their card sets were pre-Episode I, so it was mostly classic trilogy material, and they were naming every single background character. They were also pulling from the Star Wars Holiday Special as well, because they had image reference for that. But yeah, if someone wasn’t named, they would name them.”

Chee points out that the database is “not that complex,” just extremely comprehensive. Indeed, FileMaker development can provide businesses with similarly detailed looks into their operations. Whether the subject is intergalactic warfare or something more mundane, a relational database can help keep track of essential information.

For 130 years, Akubra has been manufacturing and selling felt slouch hats that have become synonymous with the Australian Outback. In 2014, the hats remain iconic, but until recently the company was operating on a DOS-based system that also belonged in a museum. The system was essentially a computer version of a previous manual reporting method, which required employees to enter information on the hats that were produced.

The system was highly inefficient, and new operations manager Ron Palin set about looking for a replacement. He found that available off-the-shelf solutions were not comprehensive or customizable enough to handle the highly specific needs of a textile manufacturer, and eventually settled on a FileMaker database. Palin says that the new system has made basic operations exponentially faster.

"We're shipping same day, and we've never done that," he told ZDNet. "The supervisor said, 'I can't remember a Christmas where all the orders are out before January or before we went away.' It's not like we're late, but the factory is now so on time that we're delivering faster, and we know where things are."

Palin says the ability to track packages has been a boon to the company and to his own schedule, since he used to spend several hours each week attempting to obtain information that is now available at a click of the mouse. The company has also installed new hardware to match the software upgrade.

Certified FileMaker developers can help companies in all industries create and customize their own relational databases. With this tool, businesses can improve their reporting and obtain valuable insights into their own workflow.

Since May 2013, the Accord on Fire and Building Safety in Bangladesh has sought to prevent tragedies like the building collapse that left more than 1,100 fatalities at a garment factory last year. About one third of the country's textile factories are covered by the agreement, which was signed by labor unions, non-profits and the international retailers that outsource their manufacturing to Bangladesh.

One of the stipulations of the accord was the performance of comprehensive safety inspections to detect construction and fire hazards that may need to be addressed immediately. Baltimore-based Hughes Associates has carried out over 1,000 such audits over the past six months, and it has done so with the help of a FileMaker app developed by fellow Maryland company Anvil Dataworks.

Like Kyo Logic, Anvil is a member of the FileMaker Academy, serving the Baltimore and Washington, D.C., areas and with additional offices in Melbourne, Florida, and Seattle. Their experts created the app for use on iOS mobile devices. It allows inspectors to easily note the condition of the buildings, upload photos and generate reports to send them worldwide.

"We didn't have time to report using handwritten notes and disjointed photos," says Hughes' director for codes and standards, Brian Rhodes. "We needed much more efficiency and consistency to handle a task this large in such a short time frame. I don't believe that we could have completed this critical project on time and within budget without our FileMaker solution."

The seven members of the Academy assist businesses with FileMaker development and training, helping them streamline operations and improve data gathering. A customized relational database can save hours of work and simplify previously complex processes.

Last month, this blog reported the story a Mississippi dentist who used FileMaker to develop a database to make up for the lack of records in developing countries, including Haiti. Now, that country is benefiting from another FileMaker app designed by three IT support consultants at the University of Iowa. The app, called TEBOW as a portmanteau of the names of developers Steve Bowers and Ted Fitzgerald, helps track HIV patients.

The lead developer, Stephen Yagla, began working on TEBOW after a trip to Haiti with Chris Buresh, an associate professor of emergency medicine at Iowa. There, they observed a rudimentary and ineffective system of Microsoft Excel spreadsheets and paper records being used by health workers, often visiting volunteers like Buresh.

TEBOW has the dual aim of being functional and very easy to use by health care workers with limited IT knowledge. Patients are photographed with an iPhone, their name and phone number are recorded and they are assigned a unique ID number. Workers can track specific patients and analyze the data to draw useful conclusions, such as how much medicine to bring on each trip.

“It’s amazing how powerful it is and how much it helps,” said Buresh to The Daily Iowan. “It’s critical that we can prove to ourselves and everyone else that we’re not wasting our time and money. It has definitely changed the way I look at what we do and changed the way I look at people in IT.”

Certified FileMaker consultants can help businesses achieve similarly successful results by building customized databases and teaching employees to maintain and update them over time.

In the corporate aviation industry, operators use safety management systems (SMS) to ensure their compliance with national and international standards. However, the frequent updates made to those standards make the job of cross-referencing an SMS a time-consuming and complicated one. Now, thanks to a former corporate pilot and current auditor who used FileMaker to simplify the process, there's an app for that.

iIS-BAO is designed to the requirements of the International Standard for Business Aircraft Operations (IS-BAO), which is maintained by the International Business Aviation Council (IBAC). It also conforms to the U.S.-based National Business Aviation Association and runs on FileMaker for both Mac and Windows as well as on FileMaker Go for iPad. Operators, SMS services providers and auditors can all use it to check compliance.

"Now IBAC is requiring cross-referencing in all its audits," said Phil Fountain, the app's creator, to Aviation International News. "I've included a place for operators to cross-reference each of their requirements to the manual. They can export it to an Excel file and email it to the auditor. The auditor can [input] all his questions and comments… and when he gets into the audit he can have all his questions prepared."

Connecticut FileMaker developer Kyo Logic helps local companies create their own customized business solutions using this highly versatile software. FileMaker's relational database capabilities simplify the process of cross-referencing large volumes of complex information. With professional instruction, users can easily learn how to manage and update their own apps to ensure that they're always keeping track of their business data.