FileMaker Upgrade Shares More Data

 
 
By Michael Caton  |  Posted 2005-10-24
 
 
 

FileMaker Upgrade Shares More Data


In the latest release of its namesake database application, FileMaker Inc. has included improvements that make it easier for end users to work with and share data.



Click here to read the full review of FileMaker Pro 8.

2


In the latest release of its namesake database application, FileMaker Inc. has included improvements that make it easier for end users to work with and share data.

Released at the end of August, FileMaker Pro 8 and FileMaker Pro 8 Advanced are priced at $299 and $499, respectively, with FileMaker Pro 8 Advanced replacing the FileMaker Pro Developer version.

In eWEEK Labs tests of both editions, we found enhancements that bolster FileMakers standing as a good solution for small teams that must quickly deploy an application for organizing and sharing data.

Not only are many of the updates handy for current FileMaker users, but they also make FileMaker an appealing choice for new users facing ever more options for workgroup and personal database development.

FileMakers competition has expanded beyond Microsoft Corp.s Excel and Access: Alpha Software Inc. has introduced Version 6 of its Alpha Five database application, and Intuit Inc. has improved its hosted QuickBase application. In addition, the OpenOffice.org Foundations OpenOffice.org 2.0 productivity suite has a personal database application, Base, that can be considered a free alternative to FileMaker.

Click here to read more about OpenOffice.org 2.0 and its cousin, StarOffice 8.

For client-based workgroup database applications shared via the Web, FileMakers primary rivals are still Alpha Five and 4D Inc.s 4th Dimension 2004.2. A key client-side advantage for FileMaker is its ability to build and deploy database applications for Pocket PC- and Palm-based mobile devices.

Both FileMaker and QuickBase bundle a good variety of prebuilt applications. FileMakers 30 included applications cover basic CRM (customer relationship management), defect tracking and task management applications. FileMaker sells vertically oriented add-ons for FileMaker Pro as well.

FileMaker Pro 8 has made strong progress in the area of data sharing, particularly in the way Adobe Systems Inc.s PDF has been incorporated as a way to generate reports. We could create PDF-based reports from any record view, thereby creating single-record reports as well as reports based on multiple records.

In addition, the PDF library used to build the reports supports PDF document, security and view data. FileMaker Pro 8 enabled us to directly export data to Excel, saving external users the step of importing structured text into Excel.

We used FileMaker Pro 8s new integrated e-mail client to send reports in PDF and Excel format and to create mass mailings directly within the application. We could define the recipients and message content based on record set. This allowed us, with a couple of clicks, to send recipient-specific data, such as a customer ID, to individuals based on the e-mail address stored in the database.

Although this is a handy feature, wed like to see FileMaker Pro 8 pass relevant information to Outlook and other e-mail clients. This would allow communications to function in the structure of an enterprise messaging environment, with a record of outbound e-mail saved on the e-mail server.

Next Page: Databases made easier.

3


This release enables database developers to more easily create, customize and manage databases. Using FileMaker Pro 8 Advanced, we added tooltips within a database at the field and layout object level, and the tooltips were then present both within the native FileMaker database and in the database if we published it on the Web. The tooltips feature supports basic calculations, such as presenting a sum or conversion as well as basic text.

FileMaker Pro boasts stronger data management, allowing us, for example, to import a table into an existing database. In addition, FileMaker Pro 8 finally includes an auto-complete feature, which works based on previous records, as well as spell-checking.

The custom menu features in FileMaker Pro 8 Advanced, unlike those in FileMaker 7 Developer, fully support scripting, so shortcut keys will now execute scripts as well.

Both FileMaker Pro 8 and FileMaker Pro 8 Advanced support sharing a database with as many as five users. The dedicated server applications, FileMaker Server 8 and FileMaker Server 8 Advanced, will be available later this fall, as will a mobile version for Pocket PC- and Palm-based devices, FileMaker officials said.

Technical Analyst Michael Caton can be reached at michael_caton@ziffdavis.com.

Check out eWEEK.coms for the latest database news, reviews and analysis.

Next page: Evaluation Shortlist: Related Products.

Page 4


Evaluation Shortlist

Alpha Softwares Alpha Five Version 6 Windows-based database system for building Web-based workgroup applications (www.alphafive.com)

4Ds 4th Dimension 2004.2 Windows- and Mac OS-based database application (www.4d.com)

Intuits QuickBase Database-driven Web-based service for quickly building workflow applications (www.quickbase.com)

Microsofts Access 2003 Personal database application available in the Office suite (www.microsoft.com)

Rocket Fuel