FileMaker and Microsoft Access to Servoy Migration Graphic

The AI Accelerated version of FmPro Migrator Platinum Edition 10.01 - Includes improvements to the FMPro Code Conversion Workbench feature, providing for the automated conversion of FileMaker scripts into Servoy JavaScript, and the addition of the OpenAI gpt4 model.

FileMaker Pro to Servoy JavaScript Conversion with the VFP Code Conversion Workbench

The FmPro Code Conversion Workbench enables developers to manage the automated conversion of hundreds of FileMaker Pro scripts within an entire FileMaker solution 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.

FmPro Code Conversion Workbench - FileMaker to Servoy JavaScript Conversion

Top 10 Features - FmPro Code Conversion Workbench

Converts FileMaker Pro, Visual FoxPro and Microsoft Access code to Servoy JavaScript.
Up to 500,000 daily AI Tokens included.
Efficient workflow manages importing, processing, naming and saving of all scripts.
To-Do list checklist shows project status at a glance.
Finely tuned system messages and properties are built in and sent automatically.
Higher capacity machine learning models are included for converting larger scripts.
Flexible GUI provides full control of AI model, source text, prompt text and output filename.
Benefit from continuous ongoing improvements to machine learning models.
Included with the AI Accelerated version of FmPro Migrator Platinum Edition.
FileMaker Pro scripts are converted into executable Servoy JavaScript code (including various options and setup parameters).

FmPro Migrator Servoy Migration Spec Sheet (979K pdf)
FmPro Migrator Automated Migration Whitepaper (455K pdf)

FmPro Migrator Platinum Edition 9.00 - Improves UUID generation for better cross platform compatibility.

Note: The layout/forms conversion feature is not currently compatible with the new FileMaker 12 file format.

Top 10 Features - FmPro Migrator

Included with FmPro Migrator Platinum Edition, keeps your FileMaker Pro, Microsoft Access, Visual FoxPro to Servoy migration project affordable.
Process your files locally, using FmPro Migrator Platinum Edition.
Automated conversion of Layouts/ Forms/Reports to Servoy Eclipse Forms.
FileMaker Pro scripts are converted into executable JavaScript.
Global fields are added to the globals.js file.
Database relationships are added to the Servoy relations file.
Custom Value Lists are added to Servoy ValueLists.
Layout/Form/Report embedded images are added to each generated Servoy Form.
Converts Tab Controls and PageFrames into Servoy TabPanels including embedded objects and background color.
Saves many hours of manual work converting each Layout/Form.

For more info please send email or call.

FmPro to Servoy Migration screenshot

Description

The Servoy Migration Service built into FmPro Migrator Platinum Edition provides an automated conversion feature for FileMaker Pro, Microsoft Access and Visual FoxPro projects into Servoy Eclipse project files. This service includes the conversion of layouts/forms/reports, scripts, relationships, and value lists within a predefined budget. This service leverages the automated layout and relationship importing features of FmPro Migrator Platinum Edition.

Servoy Migration Service Pricing
The Servoy Migration Service License key is included with FmPro Migrator Platinum Edition.

Servoy Migration Feature Set OverView Diagram

Servoy Migration OverView Diagram

Servoy Automated Migration Process Diagram Using FmPro Migrator

The features and benefits of using the Servoy Migration Service include:

Save Time, Get Up and Running Quickly - It can be a tedious and time consuming process to manually re-create each FileMaker Pro layout object into any other development environment. Rather than spending days or even weeks of valuable time manually converting hundreds of layouts/forms/reports, Servoy developers can utilize the Servoy Migration Service as an economical alternative. FmPro Migrator Platinum Edition typically processes each layout within less than 1 second - much faster than you could perform the task manually!

The ability to efficiently perform FileMaker Pro to Servoy migrations makes it possible to quickly show prototypes to prospective customers. An automated migration process represents the ultimate in rapid application development, which can't be matched by any other development environment. Being able to show customers a rapid prototype may make the difference in getting approval for a new client project.

Script Conversion - Each FileMaker Pro script captured by FmPro Migrator, is converted into executable JavaScript code within the globals.js file. These scripts are intended to be used as a template for the writing of new JavaScript code which will be used to replace the original FileMaker Pro script functionality by the Servoy developer. FileMaker Pro script instructions are parsed and replaced with one or more equivalent Servoy JavaScript commands. The script conversion process can be customized by editing the table of conversion records within the FmigScriptConversion.db3 SQLite mapping file.

ToolTips Conversion - Object tooltips from form and report objects are converted into Servoy tooltips for fields, buttons and imbedded form image objects.

Relationship Conversion

Each database relationship imported by FmPro Migrator is converted into two Servoy Eclipse relationships. Both forward and reverse relationships are created within the Servoy Eclipse development environment, to operate in the same manner as the original relationship.

Global Fields

Global fields within FileMaker Pro tables are converted into Servoy Eclipse Global variables within the globals.js file.

The Global Fields conversion process relies on FmPro Migrator's ability to gather accurate table definition info from the original FileMaker Pro database file. The most accurate method for copying the table definition info is via the clipboard, which is a feature only available when using FileMaker Pro Advanced with FmPro Migrator.

Stored & Unstored Calculation Fields

Servoy Field Calculations

FileMaker stored and unstored calculation field calculations are converted into Servoy datasource calculations. Unstored calculation fields are added to the Drop SQL Columns.sql report. By dropping these database columns from the SQL database, the columns become unstored calculation fields in Servoy.

The FileMaker field calculations are converted into commented datasource calculation functions in order to serve as the starting point for further development.

Summary Fields

Servoy Aggregations

FileMaker Summary fields are converted into Servoy aggregations. Summary fields are also added to the Drop SQL Columns.sql report so that the columns will not appear within the SQL database.

Merge Fields

Servoy Merge Fields

FileMaker merge fields are converted into Servoy merge fields having the same functionality as the original. The FileMaker merge field markers are converted into Servoy merge field markers and the data provider name is changed if needed. Data provider names are prefixed with the required relationship name if the fields are located in a related table, otherwise the converted SQL compliant table name is directly used as the dataProvider.

Custom Value Lists

Custom Value Lists are read or synthesized from the original database forms/reports and then added to the Servoy Eclipse ValueLists.
Note: Dynamic Value List names are also added to the list of ValueLists, but the definition of each dynamic Value List will need to be updated manually to the project.

Layout Images

Embedded layout graphic images are saved into the medias folder within the Servoy project and are also placed onto the Servoy Eclipse form. Only unique copies of images are stored within the medias folder, in order to prevent wasting space due to duplicate images. This means that if an image such as a company logo is used on 100 different layouts, only one single copy of that graphic will be saved, as all of the other 99 copies are duplicates of the original image.

Tab Controls

Servoy Tab Panel

Tab Controls and PageFrames are converted into Servoy Tab Panels, including all embedded objects. Each Tab Panel is created as a separate Servoy subForm referenced by the Tab Panel control on the parent form. Embedded Tab Controls are migrated as well as the background color of each Tab Panel.

Each individual Tab Panel object is placed onto the main Tab Control in a staggered manner for easy selection within the Servoy Eclipse IDE. (See Merge Fields image above.)

FileMaker Layout Objects Supported

Field
Field with Value List Menu
Field with Checkbox
Field displayed as Radio Button Set
Field with Calendar Picker
Merge Fields
Text
Button (including non-button objects configured as buttons)
Button (with embedded merge field object)
Portal (including portal objects)
WebViewer (set as Servoy HTML field)
Line
Rectangle
RoundedRectangle
Oval
Embedded Layout Image Graphics
Tab Controls (and embedded Tab Panel & Objects)

Visual FoxPro Objects Supported

TextBox
EditBox
OLEBoundControl
ComboBox (with Value List)
Spinner (with Value List - derived from RangeLow/RangeHigh/Increment properties)
ListBox
Label
Image (.png, .bmp, .jpg, .gif)
Line
Shape (type of shape based upon curvature property)
CommandButton (regular & image buttons)
Checkbox
OptionGroup (created as radio button group with Value List)
CommandGroup (created as radio button group)
Grid (created as Servoy Portal, with fields equally spaced across portal)
PageFrame (created as Servoy Tab Panel supporting embedded Tab Panel & objects)
Container Objects (all of the individual objects are created invidually)
VCX Forms & Objects - (exported during runtime metadata capturing and processed normally)

Visual FoxPro UnSupported Objects
[Unsupported objects are converted into a red rectangle to serve as a placeholder.]

Timer - (recommended replacement: Servoy Scheduler plug-in within a script, using: addJob, removeJob, getCurrentJobNames, getLastRunJobName, addCronJob)
OLEControl - (there are a large variety of Java Bens and plug-ins available from: www.servoycomponents.com and the Servoy MarketPlace)
HyperLink - (no replacement, no object coordinates available)

Visual FoxPro Menu Conversion

The Visual FoxPro Menu Converter included with FmPro Migrator Platinum Edition reads the GENMENU code from FoxPro .MPR files and converts the code into Servoy JavaScript code. Menus can be converted individually, as shown in the demo below, or can be converted for an entire Visual FoxPro project all at once. The Conversion Type menu provides two conversion options. Visual FoxPro menu STYLE parameters for menu items are converted into embedded HTML tags, supporting the style options: Bold, Italic, Underline, and Strikeout.

ON SELECTION statement procedure calls are converted into empty Servoy JavaScript functions to enable quick testing of the generated menu code.

Servoy App Menu JavaScript

A Servoy application menu can only be used within the SmartClient. Each menu appears under the last menu in the list of menu items. Menu items are displayed as submenu items.

Servoy Pop-Up Menu JavaScript

Servoy popup menus are typically attached to form objects, and are useable within SmartClient and WebClient deployed applications. The generated JavaScript code automatically displays the menu above/below the clicked object. PopUp menus can also be displayed at specific coordinate locations on the form canvas, by modifying the generated code.

Visual FoxPro to Servoy Code Conversion

The VFP Code Conversion Workbench is included with the AI Accelerated version of FmPro Migrator reads the contents of .PRG files/Form code and converts the code into Servoy JavaScript code. Individual procedure/functions 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.

Demo Mode

Due to the complexity associated with any database migration project, it is recommended that a small test project be completed prior to starting the full conversion project. By default, FmPro Migrator Platinum Edition processes FmPro to Servoy migration projects in demo mode without a license key. In Demo mode, FmPro Migrator Platinum Edition will process 5 layouts and 5 scripts.

Using the demo mode at no charge, enables Servoy developers to become familiar with the conversion process and see the completed layouts in the Servoy Eclipse project.

Processing Steps & Requirements

Requirements:
FmPro Migrator Platinum Edition - FmPro Migrator Platinum Edition is used for capturing the structure info from the FileMaker Pro database file and generating the Servoy Eclipse project files. FmPro Migrator Platinum Edition utilizes the DDR XML file generated by FileMaker Pro Advanced, along with AppleScript(MacOSX) or a compiled WinAutomation (Windows) job file [provided at no cost] in order to automate the capturing of Tables/Fields, Layouts, Relationships and Scripts. This import process follows the Table Consolidation Process steps, documented in the PDF file on the support page. Once the info has been captured by FmPro Migrator Platinum Edition, click the Servoy Migration Service button on the GUI tab. Complete instructions for the Servoy Migration Service are included a detailed PDF file. In demo mode, FmPro Migrator Platinum Edition will convert 5 layouts and 5 scripts into a Servoy Eclipse project. Buying a license key for FmPro Migrator Platinum Edition provides full-featured migration of the quantity of layouts ordered. This license key enables the processing of the specified quantity of layouts for an unlimited number of FileMaker Pro database files for the duration of the license key.
FmPro Migrator Platinum Edition may also be used by the Servoy developer to perform the conversion of the FileMaker Pro database tables and data into one of the supported SQL database servers.

FileMaker Pro Advanced 8.5+ - FileMaker Pro Advanced is used for creating a DDR XML export file providing the structure of the FileMaker Pro database file. This file is used for importing the relationships and layout display order info associated with the layouts.

AppleScript(MacOSX)/WinAutomation(Windows) Software - FmPro Migrator Platinum Edition utilizes one of these two utilities to drive the FileMaker Pro user interface to automate the capturing of layouts from via the clipboard from FileMaker Pro.

Servoy Eclipse 4.1+ - The version of Servoy Eclipse required must be at least version 4.1, in order to support the reading of project files generated by FmPro Migrator Platinum Edition.

The Servoy Migration Service utilizes FmPro Migrator Platinum Edition along with the other software listed here in order to automate the capturing of layouts, relationships, value list names and scripts from the FileMaker Pro database file. Once the information has been captured, it is stored within FmPro Migrator's MigrationProcess.db3 embedded database file, saved to the output directory. This file serves as the source of info for the FmPro to Servoy Migration process.

Unsupported Layout Objects

Feature	Status
Embedded Page#, Date, Record# Layout objects
Layout Object TAB Order	NOFIX - Info not available in DDR XML
Layout Part Objects	NOFIX - Info not available in DDR XML - A form body part is automatically created for each Servoy Form.