.com Solutions Inc. - Logo  
services header buttons
.
FmPro Migration bullet item 7b FmPro Upgrade bullet item 7b FmPro Development
.
.
.
. .

Email a Friend

Bookmark This Page

 

 

FmPro Migrator Demo Image

 

The following Servoy consultants have experience using FMPro Migrator and can help you with your conversion project:McGilly Information Systems Logo

 

 

 

 


..

. .

...
.

FileMaker and Microsoft Access to Servoy Migration Graphic

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

FmPro Migrator Platinum Edition 7.47 - Adds Support for Servoy 7 File Format.

Note: This feature is not currently compatible with the new FileMaker 12 file format.

Top 10 Features

black bulletIncluded with FmPro Migrator Platinum Edition, keeps your FileMaker Pro, Microsoft Access, Visual FoxPro to Servoy migration project affordable.
black bulletProcess your files locally, using FmPro Migrator Platinum Edition.
black bulletAutomated conversion of Layouts/ Forms/Reports to Servoy Eclipse Forms.
black bulletFileMaker Pro scripts are converted into executable JavaScript.
black bulletGlobal fields are added to the globals.js file.
black bulletDatabase relationships are added to the Servoy relations file.
black bulletCustom Value Lists are added to Servoy ValueLists.
black bulletLayout/Form/Report embedded images are added to each generated Servoy Form.
black bulletConverts Tab Controls and PageFrames into Servoy TabPanels including embedded objects and background color.
black bulletSaves 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

hline image

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

black bulletSave 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 Developer 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.

black bulletScript 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.

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

black bulletRelationship Conversion

Servoy Converted Relations List

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.



black bulletGlobal 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.

black bulletStored & 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.


black bulletSummary 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.

black bulletMerge 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.

black bulletCustom 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.

black bulletLayout 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.

black bulletTab 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 Developer 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
Servcoy App Menu Screenshot

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 Menu Screenshot

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 Menu Converter - Online Demo
You can paste in your own FoxPro menu code into the revLet displayed below and instantly see the results.

Visual FoxPro Code Conversion

The Visual FoxPro Code Converter included with FmPro Migrator Developer Edition reads the contents of .PRG files and converts the code into Servoy JavaScript code. Scripts can be converted individually, as shown in the demo below, or can be converted for an entire Visual FoxPro project all at once. Each line of code is analyzed and re-mapped (if possible) to equivalent JavaScript code which makes calls to Servoy API calls. Semicolons are added to each line and operators are remapped as necessary for JavaScript compatibility. Unsupported keywords are logged and displayed on the Statistics page of the application.

 

 

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 Developer Edition processes FmPro to Servoy migration projects in demo mode without a license key. In Demo mode, FmPro Migrator Developer 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 Developer 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 Developer 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 Developer 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 Developer 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 Developer 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.

hline image

.

 

. .

.

. .

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

email link

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact