FileMaker sample databases for developers
On this page you will find an overview of all FileMaker-sample files that have been published as part of our instructions and tips. Unless otherwise stated, all sample databases are in .fmp12 format for FileMaker Pro (Advanced) version 12 and higher. Some solutions require an additional FileMaker plugin such as the MBS or BaseElements plugin.
Many current tips and instructions as well as interfaces to other systems for FileMaker and gFM-Business can be found in our separate section Tips & instructions.
Tips, instructions and interfaces for FileMaker and gFM-Business ERP
Tips & instructions
Interface from WooCommerce online stores to FileMaker
In a technical article, we present a method of using FileMaker and the MBS FileMaker plugin to establish a connection to a WooCommerce online store via the REST API interface. With this FileMaker sample solution, orders and customer addresses can be transferred from a WooCommerce online store to a FileMaker database. The data is imported via the WooCommerce RESTful API and includes all order data, all linked order items and the billing and delivery address specified by the customer.
In our Tips & Instructions section, you will find a more recent article that explains the general login with FileMaker to a REST API with OAuth Authentication without plugin.
Everything included in the gFM-Business ERP software
Our gFM-Business ERP software includes an online store interface from the Basic version (Professional as a multi-channel interface) and currently supports WooCommerce, Shopware, Gambio and Modified Shopsoftware. gFM-Business is available in four expansion stages and can also be purchased in all versions as an open license for customization and expansion.
All ERP platforms at a glance:
Free FileMaker ERP platform, includes CRM with address management, article and warehouse management (1 warehouse), invoices and credit notes, developer module with documentation of all standards, tables, fields and scripts with full-text search to support customization and expansion.
Open license, fully customizable with Claris FileMaker Pro.
| More information |
gFM-Business Open Source Plus is the extended open source version and also includes time recording and invoicing of services in the CRM and quotations, order confirmations, delivery bills and reminders in the invoicing module. The software contains all the automatic functions for converting orders into delivery bills, delivery bills into invoices, etc. gFM-Business Open Source Plus is available in our online store for a one-off purchase price of 499 euros plus 19% VAT.
Open license, fully customizable with Claris FileMaker Pro.
| Buy now |
CRM additionally with contact persons, action chronicle and resubmissions, services and time recording, correspondence module with document templates and integrated e-mail client, cash book with automatic bookings and DATEV export, article management with suppliers, project management module, logbook management, customer and company-related statistics, online store interface for an online shop (Shopware, WooCommerce, Gambio or Modified Shopsoftware).
Available as standard, custom and open license for Claris FileMaker Pro
| More information |
Support for multiple clients, storage locations and languages (system-wide), CRM with additional route planning and ticket system, supplier inquiries, orders and returns, cash book with posting list, journal and any number of tills, item management for multiple storage locations, product variants, price-relevant product properties, parts list and batch management, extended project management, task and personnel management, inventory management, support for multiple parallel online stores (also in mixed operation of multiple store systems).
Available as standard, custom and open license for Claris FileMaker Pro
| More information |
Automate processes in FileMaker with a process engine
In certain circumstances, it can be useful to have processes executed by a process machine that is located in the local network. This allows WebDirect users, for example, to create PDF files that are saved on a drive in the local network and then automatically sent by email. A process engine can also be used to execute scheduled cron jobs automatically and recurrently.
In this article, we present a way in which freely definable processes in FileMaker can be executed automatically and in real time by a process engine. For this purpose, we provide a free FileMaker sample file in .fmp12 format, which also contains the option of automatically executing time-controlled cron jobs at definable intervals.
Instructions: Accessing data from gFM-Business from external FileMaker databases.
gFM-Business Light and Professional allow access to all data tables used from external databases, so that data from gFM-Business can be easily reused in real time in other systems or in self-developed databases. The databases can either be located on a drive or shared from a FileMaker Server or FileMaker Pro on the network. In this article we explain how you can import your address data from the CRM module of gFM-Business into an external database and process it from there.
Interface from WordPress and Contact Form 7 to FileMaker
With this FileMaker sample solution, form entries from WordPress can be transferred to a FileMaker database using the "Contact Form 7" and "Flamingo" plugins. The MBS FileMaker plugin and a MySQL library are required to run the sample solution because the database accesses the MySQL server of a WordPress installation directly. Flamingo saves all form entries in the "wp_posts" table and does not create its own table in the WordPress database. The sample solution automatically imports all data records with the post type "flamingo-inbound" and extracts all entered values into its own fields.
Diagrams in FileMaker with JavaScript and HTML5.
The diagrams contained in FileMaker have the disadvantage of not working in FileMaker Runtime solutions, as FileMaker has blocked this function in Runtime solutions. In addition, the native diagrams from FileMaker only allow rudimentary interactions with a diagram. A much more flexible solution for creating charts in a FileMaker database is the open source solution "Chart.js", which can be easily integrated into a FileMaker database thanks to a web viewer. In this article, we will show you how you can integrate beautiful and animated charts into your FileMaker solution using the JavaScript and HTML5-based "Chart.js" solution.
Database-driven navigation in FileMaker (Go)
This sample file shows a simple way of navigating between different layouts in a FileMaker database. All selection points are displayed in a navigation bar. This sample file can be used with FileMaker up to version 11 and is in .fp7 format. With FileMaker 12 and higher, the file must first be converted to the new format.
Recording events in FileMaker databases.
Problems with field changes in FileMaker can be handled easily if the change to a field value is recorded (or "tracked") directly. In earlier versions of FileMaker, this could be realized using input dialogs, for example, by clicking on the [OK] button and a Scriptwas called to record the process. With the newer FileMaker versions, the whole thing is possible thanks to Script trigger has become much easier. This article shows how to do this with a corresponding example file.
FileMaker Crash Course
Fast and effective FileMaker
learning in 20 chapters.
Participate free of charge
Check IBAN online with FileMaker and the MBS plugin.
There are already a number of custom functions available on the Internet for calculating an IBAN from a bank sort code and account number. However, due to not insignificant special cases when calculating an IBAN, you cannot always be sure that the IBAN has actually been calculated correctly with a pure formula. For this reason, it can be useful to check the plausibility of the calculated IBAN online in order to avoid calculating and saving an incorrect IBAN. In this article, we show how an IBAN can be checked online directly in FileMaker using the iban-test.de service and the API provided.
Send SMS with FileMaker and the MBS plugin.
In this technical article we explain how you can send SMS messages directly from your FileMaker database using the MBS plugin. We will create a subscript that can send any SMS messages to any recipient by calling it with five parameters. In this example, we use the German provider smstrade as the gateway for sending SMS messages.
Solution tip: Automatic updates with FileMaker
To avoid having to manually export and re-import all data every time a FileMaker solution is updated, a routine can be developed using the Base Elements plugin, for example, which automates this process. In this article, we will show you how to do this and how handling FileMaker and system paths becomes child's play. The sample file can be downloaded at the end of the article. The archive contains a sample file in FileMaker 12 format.
Introduction to FileMaker - Part 3
In the third part of the FileMaker tutorial, we will now breathe some life into the database we have created and make it easy to use. We will now look at layouts and add some new functions to the database. At the end of this introduction, our database will have basic navigation, and as the icing on the cake, the database can generate a digital vCard and a corresponding QR code from an address, which can be scanned at the touch of a button using an iPhone or other smartphone and inserted into the device's address book.
Backups with history in FileMaker
In the FileMaker Magazine FMM_201701 we have published a programming guide on how to create a backup function in FileMaker with history. The solution works with single and multi-file solutions and automatically creates a definable number of backups of the databases.
