FmPro Migrator

.com Solutions Inc.

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.