FmPro Migrator Platinum Edition 9.00 - Improves UUID generation for better cross platform compatibility.
Note: This feature is not currently compatible with the new FileMaker 12 file format.
Top 10 Features
Included with FmPro Migrator Platinum Edition, keeps your FileMaker Pro, Microsoft Access, Visual FoxPro to Servoy migration project
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.
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 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.
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.
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.
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 are read or synthesized from the original database forms/reports and then added to the Servoy
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 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.
FileMaker Layout Objects Supported
Field with Value List Menu
Field with Checkbox
Field displayed as Radio Button Set
Field with Calendar Picker
Button (including non-button objects configured as buttons)
Button (with embedded merge field object)
Portal (including portal objects)
WebViewer (set as Servoy HTML field)
Embedded Layout Image Graphics
Tab Controls (and embedded Tab Panel & Objects)
Visual FoxPro Objects Supported
ComboBox (with Value List)
Spinner (with Value List - derived from RangeLow/RangeHigh/Increment properties)
Image (.png, .bmp, .jpg, .gif)
Shape (type of shape based upon curvature property)
CommandButton (regular & image buttons)
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)
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.
Visual FoxPro Menu Converter - Online Demo
You can paste in your own FoxPro menu code into the revLet displayed below and instantly see the results.
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
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
|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.|