FileMaker

Infobox Software
name = FileMaker



caption = FileMaker Pro 9 screenshot showing a company database page
collapsible =
author =
developer = FileMaker Inc.
released =
latest release version = Version 9.0v3
latest release date = release date and age|2007|07|10
latest preview version =
latest preview date =
frequently updated =
programming language =
operating system = Mac OS X, Windows XP, Windows Vista
platform =
size =
language =
status =
genre = Database management system
license = Proprietary
website = [http://www.filemaker.com/ FileMaker Inc.]

FileMaker Pro is a cross-platform relational database application from FileMaker Inc. (a subsidiary of Apple Inc.). It is noted for the integration of the database engine with the GUI-based interface, which allows users to modify the database by dragging new elements into the layouts/screens/forms that provide the user interface. This results in a "quasi-object" development environment that sets it apart from other commercial databases.

FileMaker was one of a handful of database applications released for the Apple Macintosh in the 1980s.

FileMaker is available for both the Mac OS X and Microsoft Windows operating systems and can be networked simultaneously to a mixed Windows and Mac OS X user base. FileMaker is also scalable, being offered in desktop, server, and web-delivery configurations.

History

FileMaker began as a DOS-based product known as “Nutshell,” developed by Nashoba Systems of Concord, Massachusetts around 1982 or 1983. Nutshell was distributed by Leading Edge, an electronics marketer that had recently started selling PC-compatible computers and software.

With the introduction of the Macintosh, Nashoba combined the basic data engine with a new forms-based GUI, creating a program that was dramatically easier to use. Leading Edge was not interested in the product, preferring to remain a DOS-only vendor, and kept the Nutshell name. Nashoba found another distributor, Forethought Inc., and introduced it to the Mac market as “FileMaker.” When the Macintosh Plus was introduced, the next version of FileMaker was named “FileMaker Plus” to reflect the computer’s name.

Forethought Inc. was purchased by Microsoft, which was then introducing a series of products that are today the core of Microsoft Office. Microsoft had introduced its own database application, Microsoft File, shortly before FileMaker but it was outsold by FileMaker and was withdrawn from the market. Microsoft negotiated with Nashoba for the right to publish FileMaker, but Nashoba decided to self-publish “FileMaker 4”. [cite web
author = Glenn Koenig
title = FileMaker Early History
url = http://www.dancing-data.com/filemakerhist.html
date = 2 April 2004
accessdate = 2007-10-05]

Shortly thereafter, Apple Computer formed Claris, a wholly owned subsidiary, to market software. Within months they had purchased Nashoba to round out their software suite. By that time, Leading Edge and Nutshell had faded from the marketplace because of competition from other DOS and later Windows platform database products. FileMaker, however, continued to succeed on the Macintosh platform.

Claris changed the name to “FileMaker II” in order to be compatible with the naming of their other products, such as MacWrite II, but the product was changed little from the last Nashoba version. Several seemingly randomly numbered minor versions followed, and things finally settled down with the release of “FileMaker Pro” 1.0 in 1990. At this point, FileMaker was still a Mac OS–only application.

A significant milestone in FileMaker’s history came with the release in September 1992 of a multiplatform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) looks and feels the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features.

By 1995 FileMaker was the only strong-selling product in Claris’s lineup. In 1998, Apple moved development of some of the other Claris products in house, dropped most of the rest, and renamed Claris to “FileMaker, Inc.” to further develop and market FileMaker.

Version 4.0, introduced in 1997, added a plug-in architecture much like Photoshop, which provided for third-party developers to add various non-native functionalities to FileMaker. A bundled plug-in was the Web Companion, which allowed the database to act as a web server; other “plugs” add new features to the interface or allow FileMaker to act as an FTP client, perform external file operations, and send messages to remote FileMaker files over internet or intranet.

Since its emergence from the Apple fold, FileMaker Inc. has invested substantially in software development. Version 7 of FileMaker Pro, released in March 2004, supported file sizes of up to 8 terabytes (up from 2 gigabytes in previous versions). Individual fields could hold up to 2 gigabytes (up from 64 kilobytes in previous versions) and FileMaker’s relational model was enriched, offering multiple tables per file and a graphical relationship editor which displayed (and allowed manipulation of) related tables in a form which in some respects resembled the familiar “entity-relationship diagram” format. With this change, FileMaker Inc. also introduced a worldwide developer certification program in recognition of the growing numbers of professional developers working with FileMaker.

On August 29, 2005, FileMaker Inc. announced the FileMaker 8 product family.

FileMaker 8 offered the developer an expanded feature set. One feature is the tabbed interface, which allows the user to easily create a multi-tabbed layout. Script variables, tooltips, enhanced debug features, custom menus, and the ability to copy and paste entire tables and field definitions, scripts, and script steps within and between files all increase FileMaker's reputation as a rapid development environment.

Version 8.5, released July 10, 2006, added an integrated web viewer (the ability to directly view such things as shipment tracking information from Federal Express and Wikipedia entries) and Named Layout Objects.

FileMaker 9 was released on July 10, 2007. This update for Windows and Macintosh brought a quick start screen, conditional formatting, hyperlinked pointers into databases, and external SQL links.

Description

A defining characteristic of FileMaker is that the database engine is integrated with the forms (screen, layouts, reports etc) used to access it. Most database systems separate these tasks, concerning themselves primarily with organization and storage of the data.

Until recently, each table of a FileMaker database system was stored as a separate file (with relational links to other files) and each file had its own built-in interface capabilities. Version 7 introduced the capability to build multiple tables into one document. Compared to other RDBMS products, it is fairly easy to develop quickly and to make changes on the fly as the data structure is altered. More complex systems may introduce some separation between interface and data files and FileMaker provides the flexibility to accommodate this.

A substantial body of professional FileMaker developers has grown up around the product and provides the expertise required for complex systems and implementations. A certification program was introduced by FileMaker Inc. in 2004 to provide differentiation of professionals in the field. FileMaker also provides an interface (API) for integration of third-party tools, making it highly extensible. In addition there are a variety of web publishing options suited to both low-end and larger scale project requirements.

Version history

FileMaker files are compatible between Mac and Windows. File type extensions are
* .fm since FileMaker Pro 2.0
* .fp3 since FileMaker Pro 3.0
* .fp5 since FileMaker Pro 5.0
* .fp7 since FileMaker Pro 7.0, up to FileMaker Pro 9.0

Self running applications ("runtime", "kiosk mode") are platform specific only.

Internationalization and localization

Languages available

FileMaker is available in the following languages:
* World Wide English
* Czech (Central European version)
* Dutch
* French
* German
* Italian
* Japanese
* Polish (Central European version)
* Simplified Chinese
* Spanish
* Swedish
* Traditional Chinese
* Turkish (Central European version)

There are specific versions of FileMaker for Central European, Middle Eastern and Indian users. These versions are available from WinSoft [ [http://www.winsoft.eu/filemaker Winsoft ] ] , FileMaker’s Internationalization and localization partner.

pecific features for Central European languages [ [http://www.winsoft.eu/products_solutions/filemaker-pro-advanced9ce.php FileMaker Pro Advanced- FileMaker Pro 8.5 plus a suite of customization and development tools, enhanced features for Central and East European Users ] ]

The Central European –English, Polish, Czech, Turkish versions are specifically developed for Central European languages.

* Localised user interface: The user interface for these versions is available in Czech, Polish, Turkish and English.
* Localised templates: The templates are available in Czech, Polish and Turkish.
* Instant Web Publishing: The Instant Web Publishing is available in Polish, Czech, Turkish, Russian, Greek and Hungarian.
* Spelling option: Czech, Polish, Turkish, Slovak and Hungarian, as well as the Unicode support of the User dictionary, are included in the spelling option on Windows and Macintosh.

FileMaker Pro 9 also includes the support of “cocoAspell” tool (Mac OS X interface for Aspell) from Mac OS 10.4.x for Czech, Slovak, Hungarian, Polish, Romanian, Slovenian, Croatian, Turkish, Estonian, Lithuanian, Latvian, Serbian, Bulgarian, Ukrainian and Greek.

* Sorting /Indexing options: Czech, Polish, Turkish, Estonian, Lithuanian, Latvian, Serbian, Bulgarian, are included in the sorting and indexing options.
* Greek Mix Sorting: Greek users can choose either "Greek" or "Greek Mix" language sort option. Greek Mix option recognized Latin alphabet and sort it inside the Greek text.
* Migration from previous FileMaker versions (prior to version 7): A specific conversion encoding option allows users of previous FileMaker versions (prior to version 7) to migrate their databases with ease and confidence. Users can work with FileMaker Pro 9Central European versions, with no risk of text incorrectly converted to Unicode.
* Text import and export options: The user can choose to import or export text files in a non-roman text, according to his settings.

pecific features for Middle Eastern languages [ [http://www.winsoft.eu/products_solutions/filemaker-pro-9ME.php FileMaker Pro - The #1-selling easy-to-use database software for Windows and Mac OS, enhanced features for Middle Eastern Users ] ]

The Middle Eastern –English, French versions are specifically developed for Arabic and Hebrew languages.

* Data entry, display and printing: Users can enter and display text in Arabic and Hebrew languages.
* Localised templates: Templates are available in Arabic and Hebrew.
* Instant Web Publishing: The Instant Web Publishing is available in Arabic and Hebrew.
* Sorting /Indexing options: Arabic and Hebrew are included in the sorting and indexing options.
* Mirror Layout: FileMaker Pro Middle Eastern versions propose a specific feature that allows users to switch in one click, the English Layout geometry (Left To Right oriented) to an Arabic or Hebrew one (Right To Left). This feature is directly in the Layout menu.
* Diacritics and Ligatures: For Arabic users, ligatures and diacritics are totally supported when exporting the database in pdf format.

pecific features for Indian languages [ [http://www.winsoft.eu/products_solutions/filemaker-pro-9Asia.php FileMaker Pro - The #1-selling easy-to-use database software for Windows and Mac OS, enhanced features for Middle Eastern Users ] ]

The South East Asia – English version is specifically developed for Indian languages.

* Data entry, display and printing: Users can enter and display text in all Indian languages.
* Sorting /Indexing options: Eight languages Hindi, Marathi, Bengali, Panjabi, Gujarati, Tamil, Telugu, Kannada, Malayalam, are included in the sorting and indexing options.
* Digits: FileMaker allows you to use the right digits according to the language you have selected for a field.

Scripting

FileMaker Pro and FileMaker Pro Advanced allow you to write and edit "script"s for automation of common tasks and complex calculations: Over 130 “script steps” are available for navigation, conditional execution of script steps, editing records, controlling windows, finding specific records, checking spelling and managing user accounts. In addition, many of these script steps can use "built-in function"s for a variety of mathematical calculations, text manipulation and querying your database configuration.

FileMaker and SQL

Older versions

Older versions have also an ODBC interface, at least from FileMaker Pro 5.5 onwards. Here are the files that can be imported or exported from this version:

FileMaker 9 and SQL

FileMaker 9 includes the ability to connect directly to a number of SQL databases, including MySQL, SQL Server, and Oracle. This requires installation of the SQL database ODBC driver and configuration of said ODBC driver (using the operating system’s ODBC manager) to connect to a SQL database. Once this is complete, SQL databases can then be used as data sources in FileMaker’s relationship graph, thus allowing the developer to create new layouts based on the SQL database; create, edit, and delete SQL records via FileMaker layouts and functions; and reference SQL fields in FileMaker calculations and script steps.

References

* [http://www.dancing-data.com/filemakerhist.html Dancing-Data] , detailed history from 1980 to 1989

External links

* [http://www.filemaker.com/ FileMaker Inc. website] , including Technical Knowledge Base
* / CDML, CDML, FDML, html like mark up language for rapid deployment of FileMaker to the web.