FileMaker

From Wikipedia, the free encyclopedia - View original article

FileMaker
FileMaker Inc.png
Developer(s)FileMaker Inc. (formerly Claris)
Stable release13.0 / December 3, 2013; 35 days ago (2013-12-03)
Operating systemMac OS X, Windows XP, Windows Vista, Windows 7, iOS
TypeDatabase management system
LicenseProprietary
Websitewww.filemaker.com
 
Jump to: navigation, search
FileMaker
FileMaker Inc.png
Developer(s)FileMaker Inc. (formerly Claris)
Stable release13.0 / December 3, 2013; 35 days ago (2013-12-03)
Operating systemMac OS X, Windows XP, Windows Vista, Windows 7, iOS
TypeDatabase management system
LicenseProprietary
Websitewww.filemaker.com

FileMaker Pro is a cross-platform relational database application from FileMaker Inc., formerly Claris, a subsidiary of Apple Inc. It integrates a database engine with a GUI-based interface, allowing users to modify the database by dragging new elements into layouts, screens, or forms. Current versions are: FileMaker Pro 13, FileMaker Pro Advanced 13, FileMaker Server 13, and FileMaker Go 13 for iPhone and iPad.

FileMaker evolved from a DOS application, but was then developed primarily for the Apple Macintosh. Since 1992 it has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment. FileMaker server briefly ran on Linux, but Linux support was abandoned with FileMaker 7, and the server currently runs only on Windows or OS X servers. It is available in desktop, server, iOS and web-delivery configurations.

History[edit]

The box art for FileMaker Pro 12

The file above is proposed for deletion. See files for deletion to help reach a consensus on what to do.

FileMaker began as an MS-DOS-based computer program named Nutshell - developed by Nashoba Systems of Concord, Massachusetts, in the early 1980s. Nutshell was distributed by Leading Edge, an electronics marketer that had recently started selling IBM PC-compatible computers.[1][2]

With the introduction of the Macintosh, Nashoba combined the basic data engine with a new forms-based graphical user interface (GUI). Leading Edge was not interested in newer versions, preferring to remain a DOS-only vendor, and kept the Nutshell name. Nashoba found another distributor, Forethought Inc., and introduced the program on the Macintosh platform as FileMaker. When Apple introduced the Macintosh Plus in 1986 the next version of FileMaker was named FileMaker Plus to reflect the new model's name.

Forethought was purchased by Microsoft, which was then introducing their PowerPoint product that became part of Microsoft Office. Microsoft had introduced its own database application, Microsoft File, shortly before FileMaker, but it was outsold by FileMaker and Microsoft discontinued it. Microsoft negotiated with Nashoba for the right to publish FileMaker, but Nashoba decided to self-publish the next version, FileMaker 4.[1]

Shortly thereafter, Apple Computer formed Claris, a wholly owned subsidiary, to market software. Claris purchased Nashoba to round out its software suite. By then, 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 product's name to FileMaker II to conform to its naming scheme for other products, such as MacWrite II, but the product changed little from the last Nashoba version. Several minor versions followed, and things finally settled down with the release of FileMaker Pro 1.0 in 1990.

In September 1992, Claris released a multi-platform version for both the Mac and Windows; except for few platform-specific functions, the program's features and user interface were the same. To this point FileMaker had no real relational feature; it limited to automatically looking up and importing values from other files. It also had only the ability to save a state—a filter and a sort, and a layout for the data. Version 3.0, released around 1995, introduced 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 changed Claris's name to FileMaker, Inc., to concentrate on that product.

Major updates[edit]

Version 4.0, introduced in 1997, added a plug-in architecture much like that of Adobe Photoshop, which enabled third-party developers to add features to FileMaker. A bundled plug-in, the Web Companion, allowed the database to act as a web server. Other "plugs" added features to the interface and enabled FileMaker to serve as an FTP client, perform external file operations, and send messages to remote FileMaker files over the Internet or an intranet.

Version 7, released in 2004, introduced a new file format (file extension .fp7) supporting file sizes up to 8 terabytes (an increase from the 2 gigabytes in previous versions). Individual fields could hold up to 4 gigabytes of binary data (container fields) or 2 gigabytes of 2-byte Unicode text per record (up from 64 kilobytes in previous versions). FileMaker’s relational model was enriched, offering multiple tables per file and a graphical relationship editor that displayed and allowed manipulation of related tables in a manner that resembled the entity-relationship diagram format. Accompanying these foundational changes, FileMaker Inc. also introduced a developer certification program.

In 2005 FileMaker Inc. announced the FileMaker 8 product family, which offered the developer an expanded feature set. These included a tabbed interface, script variables, tooltips, enhanced debugging, custom menus, and the ability to copy and paste entire tables and field definitions, scripts, and script steps within and between files. Version 8.5, released in 2006, added an integrated web viewer (the ability to view such things as shipment tracking information from FedEx and Wikipedia entries) and named layout objects.

FileMaker 9, released on July 10, 2007, introduced a quick-start screen, conditional formatting, fluid layout auto-resizing, hyperlinked pointers into databases, and external SQL links. FileMaker 10 was released on January 5, 2009, before that year's Macworld Conference & Expo, and offered scripts to be triggered by user actions and a redesigned user interface similar to that of Mac OS X Leopard applications.

FileMaker 11, released on March 9, 2010, introduced charting, which was further streamlined in FileMaker 12, released April 4, 2012. That version also added themes, more database templates (so-called starter solutions) and simplified creation of iOS databases. FileMaker Go 11 (July 20, 2010) and FileMaker Go 12 for iPhone and iPad (April 4, 2012) allow only the creation, modification, and deletion of records on these handheld devices. Design and schema changes must be made within the full FileMaker Pro application. FileMaker Go 12 offers multitasking, improved media integration, export of data to multiple formats and enhanced container fields.

FileMaker 13, released after the launches of iOS 7 and Mac OS X Mavericks (10.9), first shipped in December 2013. The client and server products were enhanced to support many mobile and web methods of data access. FileMaker Go 13, the parallel iPad-iPhone product, has now become a single client for both these handhelds, and the Server Admin tool now runs in HTML5, no longer requiring a Java app.

Version history[edit]

DateVersionComment[3]
Apr 1985FileMaker v1.0Published by Forethought Inc.
Jun 1988FileMaker 4Published by Nashoba Systems
Aug 1988FileMaker IIFirst version to be published by Claris Corporation
Oct 1990FileMaker Pro
Oct 1992FileMaker Pro 2Windows version added
Aug 1993FileMaker Pro 2.1
Jul 1994FileMaker Pro Server 2
Dec 1995FileMaker Pro 3Relational architecture, TCP/IP networking introduced
Jan 1996FileMaker Pro Server 3
Sep 1997FileMaker Pro 4Plug-in architecture introduced
May 1998FileMaker Pro 4 Developer EditionLast version to be published by Claris. Aimed at expert/professional FileMaker user.
Jun 1999FileMaker Pro 4.1v2First version to be published by FileMaker, Inc.[4]
Sep 1999FileMaker Pro 5
Nov 1999FileMaker Server 5
Apr 2001FileMaker Pro 5.5Native support for Mac OS X
Sep 2002FileMaker Pro 6*Last version to support Mac OS 9 and 8
Mar 2004FileMaker Pro 7Multiple tables/file architecture introduced;
multiple windows; relationships graph; calc variables;
Improved security with individual accounts and passwords
introduced new file format .fp7; Mac version requires OS X.
Aug 2005FileMaker Pro 8*Scriptable creation of PDF reports;[5] script variables; tabs on layouts
Jan 2006FileMaker Mobile 8FileMaker Mobile line was discontinued
Jul 2006FileMaker Pro 8.5*Mac OS X Universal Binary support, embedded browser (Web Viewer), object names
Jul 2007FileMaker Pro/Server 9*Native support for the SQL databases MS SQL Server, MySQL and Oracle.
Jan 2009FileMaker Pro/Server 10*Status area now horizontal; script triggering
Mar 2010FileMaker Pro/Server 11*Charts, snapshot link, filtered portals, and recurring imports
Jul 2010FileMaker Go 1.0FileMaker for iOS (iPad, iPhone, iPod Touch)
Sep 2010FileMaker Go 1.1PDF creation, photo support, import from FileMaker Pro
Apr 2011FileMaker Go 1.2Printing, signature capture, charts, enhanced PDF creation
Sep 2011FileMaker Pro/Advanced 11.0v4*Lion compatibility, fully implemented by October 2011
Apr 2012FileMaker Pro/Advanced 12Integrated themes (Pro/iOS); floating and modal windows;
execute SQL; enhanced container field; improved charting
Apr 2012FileMaker Server 1264 bit, faster WAN, progressive backups, rewritten web publishing engine
Dec 2013FileMaker Pro/Advanced 13WebDirect and HTML5 features; better mobile app development;
enhanced GUI design tools, themes and behaviors; more dynamic data refreshing
Dec 2013FileMaker Go 13Free universal client for iPhones and iPads supports iOS 6 & iOS 7. Supports barcode scanning from camera.
Dec 2013FileMaker Server 13FileMaker WebDirect, Platform Security; new HTML5 Admin Console replaced need for Java

* (*) indicates both FileMaker Pro / FileMaker Pro Advanced (Developer Edition in v4-6) or FileMaker Server / FileMaker Server Advanced

FileMaker files are compatible between Mac and Windows. File type extensions are

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

Internationalization and localization[edit]

FileMaker is available in worldwide English, Chinese (both simplified and traditional), Czech, Dutch, French, German, Italian, Japanese, Polish, Portuguese, Spanish, Swedish, and Turkish.

There are also specific versions of FileMaker for users of Central European, Indian and Middle Eastern languages. The custom versions offer spell checking, data entry, sorting and printing options for languages of the respective region. They also contain localized templates and localized instant web publishing.

The Central European version FileMaker 12 includes English, Russian, Polish, Czech and Turkish interfaces. There are customized templates for Polish, Czech, Turkish. In addition Russian, Greek, Estonian, Lithuanian, Latvian, Serbian, Bulgarian and Hungarian are supported to varying degrees.

The version intended for Southeast Asian languages has only an English user interface, but supports Indic-language data entry, sorting and indexing in Hindi, Marathi, Bengali, Panjabi, Gujarati, Tamil, Telugu, Kannada and Malayalam.

Similarly, the Middle Eastern version has only English and French user interfaces, but with its option to change the text direction to right-to-left, it does support Arabic and Hebrew data entry,

Scripting[edit]

FileMaker Pro and FileMaker Pro Advanced include scripting capabilities and a variety of built-in functions for automation of common tasks and complex calculations. Numerous steps are available for navigation, conditional execution of script steps, editing records, and other utilities. FileMaker Pro Advanced provides a script debugger which allows the developer to set break points, monitor data values and step through script lines.

FileMaker 13 introduces a useful script that more deeply queries container field document meta data.

SQL and ODBC Support[edit]

FileMaker, since version 9, includes the ability to connect to a number of SQL databases without resorting to using SQL, including MySQL, SQL Server, and Oracle. This requires installation of the SQL database ODBC driver to connect to a SQL database. SQL databases can 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. It is a cross platform relational database application.

Versions from FileMaker Pro 5.5 onwards also have an ODBC interface.

FileMaker 12 introduced a new function, ExecuteSQL, which allows a query against SQL databases (but not edits or deletes, or schema changes).[6]

See also[edit]

References[edit]

  1. ^ a b Glenn Koenig (April 2, 2004). "FileMaker Early History". Retrieved October 5, 2007. 
  2. ^ "Nashoba Systems and the Early Days of FileMaker Pro". Briandunning.com. Retrieved October 10, 2011. 
  3. ^ "Mike Weber, The Low End Mac, FileMaker History". Lowendmac.com. September 15, 2008. Retrieved October 10, 2011. 
  4. ^ "Custhelp.com". Filemaker.custhelp.com. November 19, 2010. Retrieved October 10, 2011. 
  5. ^ Cohen, Dennis R. (2006). FileMaker Pro 8.5 Bible. John Wiley & Sons. p. 354. ISBN 9780470109618. 
  6. ^ "ExecuteSQL". Filemaker.com. Retrieved 2013-12-13. 

External links[edit]