FileMaker 18 Certified Developer

Databuzz is pleased to announce that Andrew Duncan recently passed the Developer Essentials for FileMaker 18 Certification Exam and is now FileMaker Certified in v8, 9, 10, 11, 12, 13, 14, 15, 16, 17 and 18. FileMaker 18 Certification is the official credential offered by FileMaker, Inc.

FileMaker Certification is your validation that you are hiring an experienced FileMaker professional who has technical knowledge of the complete FileMaker product line and has passed the “Developer Essentials for FileMaker” certification exam. Being a certified developer demonstrates to clients, peers and management that you’ve achieved an essential level of knowledge, experience and skills in developing on the FileMaker Platform.

JSON Calculation Function Improvements in FileMaker Pro 18 Advanced

As part of the compatibility testing of our products for the FileMaker Pro 18 Advanced release we were keen to test to see if there were any improvements to the performance of time consuming operations, such as downloading large sets of Orders from WooCommerce or Shopify, that involve parsing lots of JSON data.

We had been alerted to some JSON calculation function performance enhancements included with FileMaker Pro 18 Advanced so we set about running some tests with WooCommerce and Shopify and were pleasantly surprised to find out that the promises were true. In scripts such as this example:

where an initial set of JSON data representing a bulk group of Orders is retrieved and stored in a FileMaker variable, then each Order is parsed out in a looping script using the JSONGetElement function we’re seeing improvements of up to 50% from FileMaker Pro v16 and17.

If you’re using any of our products that use native FileMaker functions, such as fmEcommerce Link (WooCommerce Edition) and fmEcommerce Link (Shopify Edition), we recommend using FileMaker Pro 18 Advanced to take advantage of the speed increases when downloading or uploading.

FileMaker Inc. releases FileMaker 18 Platform

 

FileMaker Inc. today released the FileMaker 18 Platform with new versions of FileMaker Pro Advanced, Server, FileMaker Go, FileMaker WebDirect and FileMaker Cloud for AWS. As with previous releases the FileMaker 18 platform has a number of new features for both customers and developers alike. This releases marks the fifth annual release that started with v14 with all new versions shipping in May each year.

Updates in the FileMaker 18 Platform include:

  • New user interface for importing data - More easily map imported source data to FileMaker fields using the new Import Field Mapping dialog box. Use type ahead instead of drag and drop for greater efficiency. And specify custom delimiters when importing certain file types.
  • File-based script steps  – Create scripts that read, write, and manage external data files to write log files or export data in a custom format. Replaces the need for many file-based plug-ins.
  • New managed security access - This new privilege set allows developers to offload account access management to other team members without needing to provide full access to any other parts of the file.
  • Manage Security dialog box - The streamlined Manage Security dialog box allows you to be more efficient in managing access to your custom apps.
  • Startup restoration - FileMaker files are now automatically recoverable after a hardware or software crash. The restoration log in FileMaker Server validates database entries when a file is first opened, before client access, and if the file had not been properly closed.
  • Platform parity - The FileMaker Cloud for AWS 1.18 code base supports all of the new features in the FileMaker 18 Platform.

We’re please to report that all Databuzz products are compatible with the FileMaker 18 Platform:

There is a change related to Plug-in security enhancements with FileMaker 18 to ensure your plug-ins come from a trustworthy source before they are automatically loaded by your FileMaker app. Depending on your version of the plug-in used by some of our products this might be an issue the first time you open one of our products in FileMaker Pro 18 – see our compatibility update for further details on how to resolve this issue.

We’ll be publishing more articles over the coming months looking at some of the new features in the FileMaker 18 Platform in more depth – you can subscribe to our newsletter to be notified when they are released or follow us on Twitter or Facebook.

FileMaker 18 Platform Compatibility Update

The FileMaker 18 Platform was released today and we’re pleased to report that all Databuzz products are compatible with the FileMaker 18 Platform. There is one issue that you may encounter related to the installation of plug-ins in FileMaker Pro 18 Advanced depending on the version of the BaseElements plug-in that you have currently installed.

When opening one of our integration solutions in FileMaker Pro 18 Advanced for the first time you will likely encounter one of the following dialog boxes:

There is a new feature in FileMaker Pro 18 Advanced related to the installation of plug-ins: FileMaker Pro 18 Advanced now notifies you when a plug-in has not been digitally signed by its developer. If Set Error Capture is on when the script runs that attempts to install the plug-in you will see the first dialog box, otherwise you will see the 2nd dialog box.

The Get(LastExternalErrorDetail) function has also changed in FileMaker Pro 18 Advanced and now returns information when plug-ins don’t install or load. For example it will return the following immediately after the Install Plug-In File script step has been performed when attempting to install a plug-in has not been digitally signed by its developer:

Plug-in not digitally signed [filemac:/Macintosh HD/Users/andrewduncan/Library/Application Support/FileMaker/FileMaker Pro Advanced/18.0/Extensions/BaseElements.fmplugin/]

If you see the 2nd dialog box you can simply tick the “Always load this plug-in” checkbox, then click the Load Plug-in button to permanently install the plugin and never receive a warning again each time FileMaker Pro 18 Advanced opens. If you would like to update to a digitally signed version of the plug-in we’ve created a simple FileMaker Pro file that you can download here to install a digitally signed version of the BaseElements plug-in. Just download the file, open with FileMaker Pro 18 Advanced and click the Install button to get the digitally signed version of the BaseElements plug-in.

If you’re already using v4.0.5 or higher of the BaseElements plug-in you will not need to do anything as that version has already been digitally signed.

Apart from the issue installing the plug-in for the first time we haven’t encountered any issues with the following products in our testing with the FileMaker 18 Platform:

fmSMS – we have sent messages from multiple SMS Gateways, received replies, checked Account balances and checked the status of sent Messages successfully.

fmAccounting Link (Xero Edition) – we have been able to authenticate, download from Xero to FileMaker and upload from FileMaker to Xero successfully

fmEcommerce Link (WooCommerce Edition) – we have been able to authenticate, download from WooCommerce to FileMaker and upload from FileMaker to WooCommerce successfully

fmEcommerce Link (Shopify Edition) – we have been able to authenticate, download from Shopify to FileMaker and upload from FileMaker to Shopify successfully

fmAccounting Link (MYOB AccountRight Edition) – we have been able to authenticate, download from AccountRight to FileMaker and upload from FileMaker to AccountRight successfully

fmAccounting Link (MYOB Essentials Edition) – we have been able to authenticate, download from MYOB Essentials to FileMaker and upload from FileMaker to MYOB Essentials successfully

We’ve also noticed a nice speed increase when working with the JSON Calculation Functions in FileMaker Pro 18 Advanced which we’ve written about here.

If you encounter any issues with any of our products and FileMaker 18 Platform please let us know. We’ll be writing more articles about some of the new features in the FileMaker 18 Platform over the coming weeks – you can subscribe to our newsletter to be notified when they are released or follow us on Twitter or Facebook.