FmPro Migrator logo

FmPro Migrator

.com Solutions Inc.


Product Type: Extensions

Price: 198

Last updated: 2/27/2024

Language: English

Product website


Convert Access to FileMaker, and perform database rebuilds

Convert Access MDB/ACCDB files to FileMaker, and automated database rebuilds (table consolidation).

FmPro Migrator Platinum Edition is a stand-alone application [macOS and Windows] which quickly and accurately migrates Microsoft Access and Visual FoxPro apps into FileMaker Pro databases.

The conversion process includes the following features:
* Automated conversion of forms/reports into FileMaker Pro Layouts.
* Visual Basic code is converted with machine learning models into commented FileMaker Pro scripts and linked to layout buttons.
* Grouped radio buttons/checkboxes are converted into FileMaker fields with value lists.
* Database relationships are converted into FileMaker Pro relationships.
* Embedded value lists are de-duped and converted into FileMaker value lists.
* Embedded form/report images are converted directly into embedded FileMaker Layout graphics.
* Microsoft Access MDB/ACCDB data is transferred into FileMaker database tables.
* VFP DBF file data (including memo fields) is transferred into FileMaker database tables.

The AI Accelerated version of FmPro Migrator Platinum Edition enables FileMaker developers to manage the automated conversion of hundreds of Access VBA scripts within an entire Microsoft Access project in a single window. Individual scripts can be selected by name for single-click submission to the selected AI provider and machine learning model. Output files are saved automatically as the results are received into a folder of converted scripts. Machine learning prompts are generated automatically, but the prompt text and source code fields are fully editable. Part of the secret sauce of this tool includes the system prompts and setup parameters which are built into the workbench software.

The machine learning models do a better job of converting scripts from Access VBA into FileMaker Pro scripts compared with previous conversion efforts. The AI models show a deeper understanding of both development environments compared with simple code substiution techniques.

The table consolidation/Database rebuild feature performs the automated copying of tables/fields, table occurrences, relationships, scripts and layouts between FileMaker 11+ database files on macOS.

Consolidating a multi-file solution into a single file improves FileMaker developer productivity because user accounts/privilege sets only need to be updated within a single file instead of dozens of files. Single-file solutions can also be easier to backup/move between computers and even send to users via an email attachment. FmPro Migrator implements automated batch capture and creation features using AppleScript (macOS) and clipboard XML for tables/fields, table occurrences, relationships, value lists, custom functions, layouts and Script Workspace Scripts.

The 2-pass dependency resolution feature makes 2 automated passes through the layout creation process in order to resolve dependencies between scripts and layouts. During pass #1 of the layout creation process the layouts are created in the normal manner. FileMaker scripts are then pasted into the new database, thus resolving dependencies between scripts and layouts. Then during the 2nd pass through the layout creation process, the contents of each layout are deleted and pasted again, resolving dependencies between layout objects and scripts.

Additional features included with FmPro Migrator Platinum Edition include the conversion of databases into full featured, stand-alone, networkable LiveCode applications. LiveCode stacks can be built into stand-alone royalty free apps running on macOS, Windows, Linux, IOS and Android devices.

What's New

FmPro Migrator 10.07 adds support for the latest gpt-4 machine learning models to the Code Conversion Workbench for VBA to FileMaker script conversions. On macOS the data transfer scripts now use a file DSN connection to the Actual Technologies ODBC driver for Access to simplify the setup. A new File menu option "Create Access Import Scripts" has been added to facilitate ODBC data imports from Microsoft Access into FileMaker Pro databases. This release fixes an issue with Access database tables which are seen as reserved words in FileMaker Pro.

Additional resources

Claris product features

See why Claris products are the top choice for developers for their low code needs.

See features

Product resources

Get instant access to helpful resources and start creating custom apps today.

Get resources