FmPro Migrator Developer Edition
5.35 - Includes Support for Converting Tab Controls, Z-Order Object Stacking, ToolTips, Stored/Unstored Calculation Fields, Summary Fields and Many Other Improvements.
Top 10 Features
Fixed-price
service, keeps your FileMaker Pro to Servoy migration project
affordable.
Process
your files locally, using FmPro Migrator Developer Edition.
Automated
conversion of FileMaker Pro Layouts and Microsoft Access Forms/Reports to Servoy Eclipse.
FileMaker
Pro scripts are converted into executable JavaScript.
Global
fields are added to the globals.js file.
FileMaker
Pro relationships are added to the Servoy
relations file.
Custom
Value Lists from FileMaker Pro are added to Servoy ValueLists.
Layout
images are added to each generated Servoy Form.
Converts Tab Controls into Servoy TabPanels including embedded objects and background color.
Saves
many hours of manual work converting each Layout.
For more info please send email to Sales
or call 510-490-3482.
Description
The FmPro To Servoy Migration Service built into FmPro
Migrator Developer Editon provides a fixed-price conversion service
for FileMaker Pro database files into Servoy Eclipse project files.
This service includes the conversion of layouts, scripts, relationships,
and value lists within a predefined budget. This service leverages
the automated layout and relationship importing features of FmPro
Migrator Developer Edition, along with FileMaker Pro Advanced.
|
FmPro To Servoy Migration Service Pricing
|
[Please click the quote icon for a customized quote - (no
email required).]
|
The features and benefits of using the FmPro To Servoy
Migration Service include:
Fixed
Price Service - You know up front what the cost will be to convert
the layouts from your FileMaker Pro database solution into a Servoy
Eclipse project file. Pricing for the migration service is based upon
the number of layouts which need to be converted.
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, Servoy
developers can utilize the FmPro to 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.
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 Microsoft Access and FileMaker Pro objects are converted into Servoy tooltips for fields, buttons and imbedded form image objects.
Relationship
Conversion
 |
Each FileMaker Pro 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 FileMaker 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
|
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
|
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
|
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 from
the FileMaker Pro DDR XML file 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.
FileMaker Pro stores GIF, PNG and JPEG images in their
native formats within the layout. All other image types
are also converted and stored in the JPEG file format in
order to guarantee compatibility with Instant Web Publishing.
Therefore the conversion process follows this same compatibility
implementation by extracting GIF, PNG and JPEG images for
use on the Servoy Eclipse form.
Note: Only embedded images can be extracted from
the FileMaker Pro layout. Images stored as a reference to
a file on the file system will show up as a white box on
the Servoy Eclipse form. Also, if the JPEG version of a
non-native image format is corrupted within the layout,
unexpected results can occur. If the image doesn't display
properly within FileMaker Pro Instant Web Publishing, then
it won't be displayed on the Servoy Eclipse form either.
|
Tab Controls
|
|
FileMaker Tab Controls 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.) |
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 Control & Objects)
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 Developer Edition - FmPro Migrator Developer
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 QuicKeys(MacOSX) or WinAutomation(Windows)
software 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 FmPro to Servoy Migration
Service button on the GUI tab. Complete instructions for the FmPro
to Servoy Migration Service are included a detailed PDF file.
In demo mode, FmPro Migrator Developer Edition will convert 5 layouts
and 5 scripts into a Servoy Eclipse project. Buying a license key
for the FmPro to Servoy Migration Service 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 [7 days].
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.
QuicKeys(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 FmPro To Servoy Migration
Service utilizes FmPro Migrator Developer 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. |
