Posts tagged ‘Filemaker’

FmPro Migrator Update Adds FileMaker 18 Table Consolidation on Catalina

.com Solutions Inc. announces FmPro Migrator Developer Edition 8.87, a maintenance update adding support for FileMaker 18 table consolidation projects on macOS Catalina. This supports FileMaker Pro Advanced 11 – 18 on macOS.


Improvements in FmPro Migrator 8.87 includes:

  • Added compatibility with macOS 10.15 Catalina when creating TOs and Relationships
  • Fixed an issue updating TO base table names having Unicode characters
  • Improved the data import scripts by specifying the source database filename; Scripts will still need to be slightly modified to map the fields from the correct source table to the destination table in situations where there are multiple tables in a source file
  • Added a new feature to the layout creation Pass #2 processing to allow restarting layout processing starting at the currently selected layout when holding the Shift key while clicking this button
  • The individual Custom Functions creation feature for FileMaker databases checks for whether FileMaker 15 versions are being used and prompts for using the newer and improved Clipboard XML creation feature instead
  • Added a new Table Consolidation Layout Troubleshooter app; This tool uses the new FileMaker 18 XML file to help troubleshoot issues with missing layouts during the automated Pass#1 layout creation process



  • Fixed an issue with Field IDs = 0 being created within FileMaker databases from VFP DBF files. This problem resulted in the fields being “invisible” to the FileMaker database and not allowing importing or deletion of the fields.
  • Fixed an issue with VFP PRG code script steps not being properly commented when pasting into FileMaker.


PHP: Fixed the database connection info for PostgreSQL database connections in the app/Config/database.php file.


FmPro Migrator is now notarized by Apple to prevent warnings when launching the app on macOS 10.15 Catalina.


FmPro Migrator Developer Edition is priced at $199 (USD) per developer, FmPro Migrator Platinum Edition is priced at $599 per developer, and both versions are available immediately. A functional demo version of FmPro Migrator may be downloaded online.

360Works Scribe 4 Released For FileMaker OCR

360Works announces 360Works plug-in, introducing Scribe 4! 360Works Scribe is the ultimate document automation plug-in for FileMaker; it allows integration with Word, Excel, and PDF documents.



We are taking it to the next level by adding in the ability to read your scanned documents, such as receipts, forms, or contract PDF files, with OCR (Optical Character Recognition) functionality. Additionally, we added features to allow you to merge PDFs and get meta-data from them, plus multiple fixes for existing functionality in Scribe.


Scribe 4 ships with new OCR functionality to read your scanned documents and extract text to be added into FileMaker. As an example, a law firm can scan in loads of paper legal contracts and have the text extracted and imported into the appropriate FileMaker records!Scribe leverages the technology of Amazon Textract which goes beyond simple OCR by not only extracting text but also identifying key information like the contents of fields in forms.


We added two new functions to merge and manipulate PDFs with Scribe. As an example, if you have a couple of PDFs stored in container fields, the new function ScribePDFMerge allows the two PDFs to be merged together. The new ScribePDFSplice function allows a multi-page PDF to be split up into smaller PDFs. This is beneficial if you have containers with multi-page PDFs, and only need to utilize a specific part of the entire PDF file.


Now get meta-data about a PDF, such as the name of the author and page count. The new ScribeGetPDFAttributes function will return various meta-data about a PDF. This can be helpful if you want to have FileMaker manage PDF files according to the author or number of pages specified in the meta-data.


We also made upgrades to the existing Scribe functionality. When using Excel with Scribe, the Excel cell reading and writing images to Excel cells has been greatly improved. We also made fixes for the ScribeDocSubstitute function for replacing a value.


Scribe 4 is available now.  For new license purchases, we have several license types available based on number of users, client-side or server-side usage, and a solution bundle license for developers with a vertical market solution. A free, fully functional demo is available to test Scribe. While in demo mode, Scribe will run for 2 hours every time you launch FileMaker (or FileMaker Server, for server deployment). Full pricing, license type information, and the demo version can be accessed at the Scribe product page.

24U Software announces Bridge for Arduino for Mac

24U Software introduces Bridge for Arduino, extending the range of hardware modules that can be integrated with the FileMaker platform by adding support the popular open-source hardware platform Arduino. The successful Phidgets Plug-In becomes Bridge to reflect the growing range of supported hardware platforms.



24U Bridge is a module that acts as a bridge between software apps, developed on the FileMaker platform, and physical devices to allow them to be controlled by the software or to control the software.


Bridge has been known as 24U Phidgets Plug-In for over 10 years since 2008 as a plug-in enabling the FileMaker platform to integrate with physical devices provided by Phidgets, Inc. Today, 24U has extended its support to the world of Arduino, another popular sort of physical devices, commonly used for electronics prototyping projects, changing its name to Bridge to reflect the fact that it’s no longer limited to a single technology. Support for more device technologies is expected to be added to the product in the future, depending on actual demand.


The Arduino project started in 2005 as a program for students at the Interaction Design Institute Ivrea in Ivrea, Italy, aiming to provide a low-cost and easy way for novices and professionals to create devices that interact with their environment using sensors and actuators. Since then in became popular not only for students and hobbyists, but also for technology professionals looking for cost-effective way to build custom hardware solutions addressing specific, often new or unique, business needs.


Bridge for Arduino enables FileMaker Pro to interact with custom hardware devices based on the popular open-source Arduino platform while maintaining the ease of use typical for FileMaker development.


By default, Arduino boards come free of any software and developers have to write their own code to make them do something. Bridge for Arduino comes with a ready-to-use firmware that saves FileMaker developers from having to write a single line of programming language code, letting them to focus on their use cases and easily control their devices directly from FileMaker Pro.



  • Read from Arduino pins to process digital signals and sensor values
  • Write directly to Arduino pins to control various electrical devices
  • Control servo and stepper motors to automate moving parts of robots and machines
  • Display text on an LCD display to provide custom user interface such as cashbox
  • Connect Arduino boards over network to control and monitor distant devices
  • Install 24U’s firmware to Arduino to avoid having to write your own C code


The first version of Bridge for Arduino supports Arduino UNO board and its 100% compatible clones, Arduino Starter Kit, Arduino Ethernet shield, and the ESP-01 wi-fi module. Support for other boards and modules will be added in the future based on actual demand, support for specific setup can be also added upon request as a custom modification.


Licenses for Bridge for Arduino start at $79 (USD) per user and device or $249 per user with unlimited devices. Volume discounts are available for 5 or more users.

360Works MirrorSync 6 Makes FileMaker Synchronization Easy

360Works announces MirrorSync 6, the easy-to-use FileMaker data replication tool can quickly and seamlessly sync an offline database running on FileMaker Go or FileMaker Pro with a database hosted by FileMaker Server. It can sync various configurations of SQL databases, such as MySQL, Salesforce, Amazon DynamoDB or Redshift, and WordPress with FileMaker. This new version also makes it very easy to synchronize two FileMaker Servers to handle mission critical tasks like server clustering for load balancing and data disaster recovery.



Jesse Barnum, President of 360Works, says “MirrorSync 6 is the most major change since version 3. One of the biggest features is that MirrorSync can now automatically detect all new fields and tables.” In version 6, there is no need to re-configure or re-paste script steps when you have solution changes (for client-to-server sync, as well as server-to-server).


Overall, the MirrorSync configuration client and sync management has been greatly improved. Creating and editing configurations is much faster, especially for many tables. Sync status updates are more responsive, and configuration changes can be made without canceling active syncs. New fields and layouts are automatically detected and added to the sync. Auto-detection of primary keys, creation / modification timestamps, and writebacks has been greatly improved. In addition, the configuration client no longers requires Java to be pre-installed, and is signed and notarized for compatibility with the latest versions of Mac OS X without annoying security pop-ups.


Automatic File Transfers Between Servers:
When setting up a server-to-server sync for the first time, you no longer need to manually download, copy, and upload the databases between the servers. Just install MirrorSync 6 on both servers and click the ‘sync now’ button. MirrorSync will transfer the files (even for multi-file solutions) and run the initial sync.


Automatic Version Update Between Servers:
If you’ve used MirrorSync 4 or 5, you’re familiar with the automatic update feature, which automatically sends database updates to users in the field. MirrorSync 6 now uses the same approach for server-to-server syncs. Just modify a single calculation field, and MirrorSync will replace the database on the spoke server with a new version after the next successful sync. You can even schedule this feature, so that it runs overnight without disrupting connected users.


MirrorSync 6 Makes Syncs Safer:
Deletion scanning now runs two separate checks to ensure a record has been deleted before deleting on the other side of the sync. Checks have been added to make sure that no client record exists in the MirrorSync table before downloading a copy for the spoke to sync. Recover mode is now more discerning about which records to re-write after a previous failed sync which helps to prevent situations where recovery could cause a large number of records to be modified. Lastly, there have been multithreading improvements for storing and accessing the internal sync database for better reliability.


Robust Enough for the Largest of Files:
For users with large databases, MirrorSync now utilizes streaming when reading from FileMaker Server and Pro/Go. This allows fetching data of unlimited size, while reducing RAM requirements.


MirrorSync now supports custom location for temp files. This is particularly important when using the database download feature with very large databases; you can now store these temporary copies on an external volume with more free space than the boot drive.


Easy Migration:
After upgrading your existing MirrorSync 4 or 5 installation, existing offline databases in the field will continue to be able to sync with the new MirrorSync 6 server. You can utilize MirrorSync’s automatic version update feature to update these users to the latest version after completing a sync with their older version.


Notable Features in MirrorSync 6:

  • Automated deployment and version management for server-to-server syncs * Now uses the Data API (instead of XML or xDBC)
  • All new MirrorSync script, re-written to support new features in FileMaker 17 and later
  • Unlimited tables
  • Leverages new FileMaker features for much faster container field syncs
  • Configuration client is now a standalone application that does not require Java to be installed
  • Added support for Get( UUIDNumber ) primary keys
  • Added support for the iPod touch (which is a great and inexpensive option for offline data collection)

MirrorSync 6 is available now. You can download the software instantly from and start syncing with the new improvements. MirrorSync is free for 1 FileMaker Pro/Go device, with additional devices priced at $8-$95 per device depending on quantity. This price is for a single FileMaker solution, with addition solutions priced at $200/each, and server-to-server syncs priced at $1,600 – $2,000 depending on the types of databases. All prices are one-time costs, not annual.

24U PhoneCompanion 3.0 for FileMaker Pro 17 Now Available

24U Software is pleased to announce the release of 24U Phone Companion 3.0, a new version of the company’s popular FileMaker plugin for Mac and Windows.


Offering robust telephony integration, 24U Phone Companion enables your FileMaker solutions to interact directly with your phone system to save you time and let you take better care of your customers.

* Make calls by clicking a button you avoid calling wrong numbers
* Run script on incoming call to lookup caller’s record before answering
* Automate evidence of phone calls so you can focus on the contents of your calls
* Know the number dialed to be able to provide call center service for different companies
* Use raw commands to get the most out of your own PBX


What’s new in version 3.0:
24U Phone Companion 3.0 adds support for SNOM VOIP phones, support for 48 new phone systems and script steps for even easier implementation. Added support for Voice Over IP systems using SNOM phones is successfully tested with RingCentral. When user has SNOM phones and 24U Phone Companion 3.0 he can use hosted IP phone systems.

* Support for SNOM VOIP phones lets you integrate cloud-hosted phone systems, such as RingCentral
* New version of TeamCall which is faster, more stable, and adds support for 48 new phone systems, such as Mitel on macOS
* Script steps for even easier implementation


When FileMaker users have SNOM phones and 24U Phone Companion 3.0 they can use hosted IP phone systems. The better and wider support for new PBX models makes it easier for users to integrate their FileMaker apps with their phone system without being too constrained in their selection of the right platform. By using calculations for processing data and scrip steps to trigger actions, integrating telephony with users custom app is now even easier and more intuitive than ever before.


System Requirements and Compatibility:
24 Phone Companion 3.0 requires OS X El Capitan 10.11 or newer and FileMaker Pro 16 or newer. Recommended is macOS Sierra 10.12 and FileMaker Pro 16 or newer. Windows 7 and FileMaker Pro 16 are minimum requirements for using the plug-in on the Windows platform. Windows 8.1 or newer and FileMaker Pro 16 or newer are recommended.

24U Phone Companion 3.0 is immediately available for download free of charge as a fully functional 14-days trial version, which can be activated after purchasing a license. Licenses for 24U Phone Companion start at $79 per user and $840 (USD) per switch. Volume discounts are available for 5 or more users. Existing customers can upgrade to the new version at 30% off the regular prices. Until 10 December 2018 customers can upgrade at 50 % off the regular prices!

24U Software
24U Phone Companion 3.0
Download for Mac
Download for Windows
Purchase a license

24U Toolbox Plug-In 3.0 for FileMaker 17 Now Available

24U Software has released version 3.0 of 24U Toolbox Plug-In, an update of their popular toolbox of useful external function for daily use in FileMaker Pro 13 thru 17. 24U Toolbox Plug-In 3 can convert rich-text to HTML with CSS, producing much cleared and customizable results than GetAsCSS. By producing clean dynamic HTML content the websites will render faster and rank higher in search engines. The new version adds convert rich-text to HTML with CSS, support for Native iOS FM Go apps and Support for FileMaker Cloud.


What’s new in this version:
* Get rich text as HTML to generate crystal clean HTML and CSS
* Support for Native iOS FM Go apps
* Support for FileMaker Cloud


24U Toolbox Plug-In is a robust FileMaker Pro plug-in which allows your FileMaker Pro databases to:
* Execute FileMaker or System shell scripts to automate tasks inside/outside of FileMaker Pro
* Execute SQL commands to develop faster and keep your solution clean
* Match & replace regular expressions to find & replace text fast using patterns
* Merge data values into text while maintaining styling to apply templates quickly and easily
* Lookup DNS name for IP & vice versa to find out who is connecting from where
* Get current public IP to know more about clients and discover potential security attacks
* Define global keyboard shortcuts to avoid unnecessarily excessive use of script triggers
* Obtain precise microsecond timestamps to measure nearly unmeasurable chunks of time
* Get the type of a FileMaker variable to let your scripts make the right decisions
* Share variables between databases to avoid creating too many external data sources

24U Toolbox Plug-In 3.0 is immediately available for download free of charge as a fully functional 14-days trial version, which can be activated after purchasing a license. Licenses for 24U SimpleHasp Plug-In start at $49 (USD) per user, $499 per server. Volume discounts are available for 5 or more users. Existing customers can upgrade to the new version at 30 % off the regular prices. Until 13 November 2018 customers can upgrade at 50% off the regular prices!

24U Software
24U Toolbox Plug-In 3.0
Download for Mac
Download for Windows
Purchase a license

24U Software Releases fmRESTor for FileMaker Data API

24U Software today is proud to announce the release of fmRESTor for FileMaker(R) Data API. fmRESTor is an object-based PHP library developed to interact with databases and custom apps hosted on a FileMaker(R) Server via the new FileMaker Data API from within PHP code.


With fmRESTor, PHP developers don’t have to learn FileMaker Data API in detail, they can just create a new object, passing it necessary parameters to connect to the database, and use fmRESTor’s easy to understand methods to access or modify their data. fmRESTor will take care of authentication, exceptions, logging, and even session preservation in order for the PHP code to be a well-behaving client for the FileMaker Data API without the developer having to worry about these technical details.


Features of fmRESTor:
* One object class conveniently handles everything
* Automatically generates authentication token
* Re-uses existing token to avoid unnecessary additional connections
* Automatically re-generates expired token
* Handles exceptions and provides meaningful error results
* Can handle raw form data for easier container uploads
* Provides customizable debug logging


24U believes that the whole FileMaker developers community will benefit from the FileMaker Platform not only having new powerful RESTful API, but also developers using the API nicely and efficiently, therefore they decided to make this library available as Open Source.


System Requirements:
* PHP 5.5 or greater
* cURL
* FileMaker database hosted on FileMaker Server 17 or FileMaker Cloud 1.17


Pricing and Availability:
fmRESTor is available as open source, licensed under the “GNU LGPLv3” License. 24U greatly appreciates contributions, but cannot provide free support for the library. Developers may hire 24U to help them with their projects, either by purchasing developer-level support or by utilizing 24U’s custom development services.

24U Software Launches New Xgode Online Service

24U Software is proud to announce their launch of 24U Xgode, a new online service lets FileMaker developers easily build a native app for iPhone and iPad from a FileMaker Go(R) app in less than 15 minutes. With this simple service it is possible to turn a custom app based on the FileMaker Platform into a native app without having to learn or use any development tools other than FileMaker Pro Advanced. The only things that are needed are a valid Apple Developer account, a custom FileMaker app, and graphics for the app’s icon.


What this service does:
* Turns a custom FileMaker Go app to a native app for iPhone and iPad
* Does not require to download, learn, and use any developer tools
* Does not require the developer to own a Mac
* Lets the developer use plug-ins in the owner’s app
* Generates a secure web installation page for an in-house distribution


System Requirements:
All that is needed to create native apps with this service is a copy of FileMaker Pro Advanced and an Apple Developer Program membership. Xgode can be tried free of charge in demo mode. Apps built in the demo mode will display a splash screen informing users they were built by demo version of Xgode.


Pricing and Availability:
Xgode is available for $9 (USD) for an individual build, $19 for monthly subscription, and $199 for an annual subscription. Subscriptions allow for unlimited number of builds during the subscription period. A simple Tic Tac Toe game app created with FileMaker Pro Advanced is available as a free download for those who want to try this service out and do not have their own app ready yet.