Softpedia >Mac >Utilities >FmPro Migrator >  Changelog

FmPro Migrator Changelog

What's new in FmPro Migrator 8.73

Sep 4, 2018
  • LiveCode Conversion:
  • Quoted table names in gDataCRArray_ references within SaveRecordsAsExcel card scripts, in order to prevent possible errors with variable checking or reserved words.
  • Image Export SQL:
  • Added support for SQL Server databases for the Image Transfer to SQL Database conversion feature.
  • .Net Conversion:
  • Fixed an issue with table names being replaced with the text "placeholder_table" in the CollectionViewSource code within the generated .NET code for the XAML form.
  • Table Consolidation:
  • Fixed an issue with the data import scripts not being created properly before they were put onto the clipboard for pasting into the FileMaker database.
  • [build: LC9.0.1RC1]

New in FmPro Migrator 8.01 (Feb 13, 2017)

  • Improved Unicode compatibility of text labels and button objects.
  • Fixed an issue reading FileMaker 2 - 6 files on Windows when using Drag & Drop of the files to read metadata.
  • Fixed an issue with Table Consolidation scripts showing "OBSOLETE" errors for FmPro Migrator generated import scripts within FileMaker 14+ versions.
  • Fixed an issue with Copy Layout to Clipboard not working on Windows 10.
  • Fixed the URL when selecting the Check for Updates... menu within the demo version.
  • Fixed an issue validating license keys which resulted in "License Server not Found" errors.
  • Fixed an issue with AppleScript GUI automation on macOS in which 2 copies of FileMaker Pro Advanced would be mis-reported as running due to the com.filemaker.PSConversionHelper.
  • Improved the SQL Server table creation process to always use the DBO schema, eliminating the requirement to create a new schema within the SQL Server database. Tested with SQL Server 2016.
  • Added support for FileMaker 15 script steps (Truncate Table), and changes to existing (Convert File, Import Records, Insert from URL, Send Mail) script steps.
  • Added a warning dialog explaining that the HTML conversion feature for FileMaker 12+ layouts has been replaced with the PHP Conversion feature. This deprecated HTML files feature should still work however with older FileMaker 7 - 11 versions, Visual FoxPro and Access forms/reports. But the PHP Conversion feature is the better option.
  • Updated the storing of binary thumbnail images for layouts in the MigrationProcess.db3 file to be readable with other apps like Navicat (Navicat.com) or SQLite Manager (sqlabs.net). This change only affects the storage of the BLOB column which stores the small thumbnail of the layout image.
  • Fixed an issue reading & storing layout image pathnames on macOS in which directories might contain special characters. This was preventing the sips command from converting the FileMaker supplied PDF image into a PNG thumbnail image within the MigrationProcess.db3 file.
  • VFP Conversion Changes:
  • Fixed an issue with Visual FoxPro importing and removed duplicated VCX code from the project.
  • Improved Unicode compatibility during VFP Importing process.
  • Improved display of VFP TextBox, labels, and commandButton objects when the width property hasn't been specified.
  • Substituted the name of the CommandButton if the Caption property was not readable.
  • LiveCode Conversion Changes:
  • Improved reliability of building Tab Control/Segmented controls thru the addition of Try/Catch statements.
  • Sorted the list of cards menu alphabetically.
  • Fixed an issue with VB6 to LiveCode conversions causing an error creating the templateField object for text labels.
  • Developed and added a new Button Bar widget to the LiveCode template stack used for LiveCode 8 conversions. The latest Button Bar widget version is: com.fmpromigrator.widget.buttonbar.1.0.1
  • Table Consolidation Changes:
  • Improved Table Consolidation conversion compatibility with FileMaker 14, when creating Relationships and TOs with AppleScript on MacOSX.
  • Tested and updated Table Consolidation compatibility with FileMaker 15 on macOS and Windows. Note: On Windows, it is still not possible for WinAutomation to select and select the TO name ComboBox objects - so this task needs done on macOS.
  • Fixed a display issue with the Right Table name not displaying Unicode characters properly on the Relationships tab.
  • Fixed issues with Unicode characters not being put onto clipboard during the creation of relationships.
  • Fixed an issue with Unicode characters no being put onto the clipboard properly during the creation of Table Consolidation data import scripts.
  • Access to FileMaker Conversion Changes:
  • Added a check for situations in which Office 365 is being used, with detailed error message for workaround since ACEODBC.dll cannot be installed. This problem affects reading and writing .accdb database files via ODBC.
  • Added a check for MSysRelationships containing 0 results, with informational dialog stating that "No relationships were found."
  • Improved the conversion of Access VBA scripts by prefixing the form name onto the names of each script. The module name listing the script has the format of Form Name : Module Name to reference its original source for documentation purposes.
  • Fixed an issue with the incorrect relationship field being assigned to the Left Table in a relationship.
  • Updated the AccessDDRExport Access database to display both 32bit and 64bit paths when installing the iij15.dll.

New in FmPro Migrator 7.81 (Mar 1, 2016)

  • Fixed an issue with parsing of license keys on Windows for features on the GUI tab.
  • Improved license key validation with BasicToLiveCode and PHPToLiveCode features by displaying that script conversion quantity is always "Unlimited".
  • Improved the cosmetic display of Tab controls within FmPro Migrator thru the use of the LiveCode 8 Segmented widget, displaying a consistent color scheme across platforms.
  • Added a new LiveChat button to the main window, making it easier to request technical assistance.
  • Fixed a problem with Table Consolidation projects during Step #5 processing, where external file references were not removed from the Perform Script and Go To Related Record steps.
  • Fixed a cosmetic issue with Destination Database field text labels showing the wrong info.
  • Fixed an issue with Oracle database fields not being displayed properly on the main screen.
  • Removed the Import Layouts from DDR XML file feature, to reduce confusion. It has always been more reliable to import layouts via the clipboard.
  • Improved Oracle database table creation code to use the DBA defined default tablespaces for tables and indexes, instead of specifying a specific tablespace name within the table creation SQL code.
  • Removed some unused Oracle related fields from the Table Details window.
  • Improved the usability of clipboard functionality thru the use of the new LiveCode 8 rawClipboardData feature. This means that the FmPro Migrator application can now run from a locked volume, in case it was not fully extracted from the ZIP or DMG file.
  • Fixed an issue with Repeating fields conversions for FileMaker 12+ versions in which the repeating fields values were not being written into separate records.
  • Fixed an issue with PHP projects having unusual errors launching the web application, due to Unicode encoding within the saved PHP files.
  • Fixed an issue with PHP projects in which a layout name containing a single quote was not escaped properly, and would not display the index.ctp file.
  • -- LiveCode Conversion Changes
  • Added a new LiveCode version menu to the LiveCode Conversion feature. Choosing the version (6,7,8) saves the new stack in the requested version and adds features appropriate to the version.
  • Added a new preference item to LiveCode conversions to disable the card-level scripting in the generated stack file. This option enables developers to get a quick look at the objects created on each card from the original layout/form/report of the source project. No errors will be displayed navigating between cards due to there not being a database available for instance.
  • Added support for creating new LiveCode 8 widgets when performing a conversion project where the LiveCode version has been selected as 8. Widgets supported include: Segmented (replacing the tab control), Push Button (replacing the legacy button object), Line Graph (in place of FileMaker Charts).
  • Fixed an issue with LiveCode Conversions in which the text label borderWidth could be set too wide - making the contents of text labels unreadable.
  • Improved LiveCode Conversions for Tab Controls (and Segmented controls for LiveCode 8) by including the menuPick/selectionChanged code directly within the object. Previously, this code was added to objects during a post-processing script run in the IDE.
  • Fixed an issue which would cause DataGrids to fail if the generated stack was moved into a different folder.

New in FmPro Migrator 7.36 (Nov 18, 2014)

  • Improved display of Licensed quantity to show "Unlimited" in PHP to LiveCode script conversion window.
  • Set field no-wrap property for ExtJS grid source folder pathname, to improve the display of long paths for PHP Conversion projects.
  • Fixed issues with contents of custom properties on MacOSX and Windows.
  • Fixed an issue reading DDR XML files containing Unicode characters.
  • Fixed an issue with the Copying VFP Code... dialog not being closed after the completion of PRG script processing.
  • Updated PHP to LiveCode and BASIC to LiveCode conversion features to create .lc files instead of .irev files. License key validation now displays Unlimited processing for the quantity.
  • Updated VB6 to LiveCode conversion logo in conversion stack.
  • Updated VB6 to LiveCode conversion stack with LiveCode 7 compatibility.
  • Fixed an issue with DebugKit not getting adde to AppController.php during PHP conversion projects if the source database didn't contain any global fields.

New in FmPro Migrator 7.34 (Sep 2, 2014)

  • Added support for Retina/Hi-DPI displays on MacOSX and Windows. As a result, icons and text will display with higher quality within the windows of the application.
  • Improved Unicode support throughout the application.
  • Improved writing of BLOB columns in SQLite database files. BLOB columns containing JPEG preview images converted from FileMaker 10 database files will be viewable in commonly used SQLite tools.
  • Added support for reading FileMaker 13 script steps via the clipboard into FmPro Migrator, and displaying the text of the script.
  • Removed script style info from the plain text versions of FileMaker scripts copied via the clipboard in order to improve the automated script conversion process.
  • Added a menu to the Table Occurrence details to allow selecting a base table for a TO. This feature can be helpful when performing Access to FileMaker conversions.
  • Added a check for TOs having non-existent table names, before automating the creation of TOs in FileMaker. If this error occurs, a report file will be created in the output directory.
  • LiveCode Conversion Changes:
  • Added support for converting FileMaker Pro Advanced 12 and FileMaker Pro Advanced 13 files into a LiveCode application stack file.
  • Added support for converting FileMaker 12 and FileMaker 13 script steps into LiveCode scripts. Also improved the conversion of previous script steps.
  • FileMaker Tab Controls are now supported 2 levels deep during FileMaker 12+ layout processing.
  • The latest DataGrid object from LiveCode 6.5.2 has been added to the LiveCode template stack embedded within FmPro Migrator.
  • Diagonal line objects are now created by using a polygon object, in order to more accurately draw the object compared to the rectangle object previously used.
  • Added new resizeStack handler to automatically resize the Layout_Objects_Group group to provide automatic display of scrollbars. This handler is also called each time the Layout_Browse_Mode_menu is used to switch between cards.
  • Improved support for FileMaker scrip steps having script parameters assigned to buttons on layouts. These script steps include: Go to Layout, Perform Script, Open URL, Show Custom Dialog and Go to Record/Request/Page.
  • Added Save Records as PDF script step implementation, supporting CurrentRecord, RecordsBeingBrowsed and BlankRecord parameters. The RecordsBeingBrowsed option uses the current Foundset of records to create multi-page PDF files. Setting the printScale parameter before calling the saveRecordsAsPDF stack handler enables LiveCode developers to customize the amount of info placed onto a single PDF page.
  • Added Save Records as Excel script step implementation, supporting CurrentRecord and BrowsedRecords options. This code is generated for the specific fields located on each card of the stack. Spreadsheet column titles and column ordering are easily customizable within the saveRecordsAsExcel card handler.
  • Added cursor changing code to each layout object which has an attached script step.
  • Improved merge field processing to display the field name within chevrons within the text label object.
  • Visual FoxPro Conversion Changes:
  • Fixed an issue with non-integer object coordinates, which prevented additional conversions from being performed.

New in FmPro Migrator 7.12 (Feb 12, 2014)

  • Table Consolidation Conversion Changes:
  • Replaced the use of QuicKeys with AppleScript code on MacOSX. This change improves performance, reduces cost and no longer requires localization for non-English languages.
  • Added compatibility with FileMaker Pro Advanced 12, and FileMaker Pro Advanced 13 for Table Consolidation and database rebuild projects, while also retaining support for FileMaker Pro Advanced 11. Earlier versions are not supported with this feature.
  • FmPro Migrator now verifies that the version of FileMaker selected on the FileMaker tab is the actual version running when the AppleScript automation code is running. An error message is displayed if this situation occurs.
  • Added a test for missing relationship fields before creating relationships in FileMaker databases. If this problem occurs, the Relationship_Error_Report.txt is written to the output directory and an error dialog is displayed. This problem can be corrected by deleting or editing the relationships in FmPro Migrator.
  • Added a test for missing base table name before creating Table Occurrences in FileMaker databases. If this problem occurs, the Table_Occurrence_Error_Report.txt is written to the output directory and an error dialog is displayed. This problem can be corrected by deleting TOs having errors in FmPro Migrator, or fixing the problem in FileMaker and re-exporting the DDR XML file. The new DDR XML file would need to be reimported into FmPro Migrator, after deleting previously imported data in the MigrationProcess.db3 file.
  • Updated the database report feature on the Tables tab to write a folder of report files for every table, TO and Relationship imported into FmPro Migrator.
  • Added a new batch creation processing button for creating scripts in FileMaker.
  • This feature can provide a workaround for situations in which all of the scripts cannot be successfully pasted via the clipboard.
  • Updated the functionality of the Copy All Tables to Clipboard button to automatically open the FileMaker Manage Database window and select the Tables tab.
  • DBToLiveCode Conversion Changes:
  • Fixed an issue with checkbox group button scripting in DBToLiveCode conversion.
  • Updated DBToLiveCode template stack to no longer require SQL Yoga registration key as of SQL Yoga 1.10 build 4 released on 1/11/2014.
  • Fixed missing data issues with fields and DataGrids for fields containing spaces in the original FileMaker database.
  • Removed RevLet and Mobile application types, as a regular stack file is always generated - which can be used on desktop or mobile devices.
  • General:
  • Fixed an issue with the Table Details and Field Details windows not displaying info for the table or field which was double-clicked to open the window.

New in FmPro Migrator 7.01 (Sep 25, 2013)

  • PHP Conversion Changes:
  • Added new Find Request feature with Recent Finds menu to query.ctp forms of PHP Conversion projects.
  • Added saving of of selected TabPanel tab using SESSION variables.
  • Fixed an issue creating CakePHP Model file afterSave() code in which the incorrect model name was written into the PHP code.
  • Added an "** Admin **" option to the navigation toolbar list of converted forms to allow users to navigate back to the Admin page. /admin is now recognized in the routes.php file along with /default to redirect back to the admin page of the application.
  • Changed the core.php file to write SESSION info into the /tmp directory for the application instead of using the default PHP sessions in the web server /tmp directory. This change improves SESSION handling by making certain that each CakePHP application manages its own SESSION variables to avoid naming conflicts between multiple applications running on the same web server.
  • Corrected the display of the Duplicate Record button on the navigation toolbar to insure that it is disabled for Read-Only projects.
  • Other changes:
  • Fixed an issue creating relationships in SQL database servers. Note: Unless the column types are identical, most relationships won't be able to be created, and this is commonly true of FileMaker relationships.
  • Fixed an issue creating FileMaker TOs using WinAutomation jobs on Windows.
  • Fixed an issue reading FileMaker scripts from the clipboard which added HTML tags within the plain text version of the scripts stored in the MigrationProcess.db3 file. This caused table/fieldnames to get missed when doing script conversions to PHP and other development environments.
  • Fixed typo within descriptive text on Fix Duplicate Columns... window.
  • Fixed the displayed total field count number for Pass #2 of the field deletion process when deleting fields from FileMaker database files. The Pass #2 text now reflects only the count of fields which are processed during Pass #2.
  • Updated LiveCode icons on the GUI tab to use the new LiveCode Community Edition icon and logo. Projects can be converted for both LiveCode Community Edition and LiveCode Commercial Editions with FmPro Migrator Platinum Edition.
  • Updated AccessDDRExport to v2.7 with Access to FileMaker form/report image handling improvements generously provided by Jop van der Werff. The supplied AccessDDRExport27.accde/AccessDDRExport27.mde files are unlocked in order to enable localization and other changes as needed by customers. These Access database files can be edited by simply changing the filename from accde => accdb or .mde => .mdb.
  • Fixed an issue with an older version of QuicKeys scripts being included with FmPro Migrator, which prevented the creation of TOs with FileMaker 12.

New in FmPro Migrator 6.97 (Mar 21, 2013)

  • Added new feature which provides automated deletion of Unstored Calc, Summary and Global fields from FileMaker database files. This feature is accessed from the Manage Deleted Fields button on the Table Details window. This feature quickly drops columns from the source database in order to prevent the ODBC connection from failing due to long query times. These fields can then be added back into the destination SQL database for use with a generated PHP web application.
  • Changed batch creation of relationships to work in increments of 100 relationships instead of 200 relationships to prevent out of memory errors with FileMaker Pro Advanced.
  • Fixed issues with creation of TOs, Relationships and Layouts in FileMaker databases by using UTF8 encoding of info put onto clipboard during automated batch processing.
  • Fixed display of unicode characters on the TOs tab of the MigrationProcess window.
  • Updated xferData.exe to prevent missing DBD::PgPP error.
  • Fixed an issue during Table Consolidation projects with the QuicKeys Open FMP9 RelationshipGraph not working with FMP12. This was due to substitution of 3 separate period symbols in the menu, compared to a single character used in previous FileMaker versions.
  • Added support for UNIQUE constraints for Access, Oracle, MySQL, SQL Server, SQLite and PostgreSQL database table creation code.
  • Changed execution order of Visual FoxPro conversion processing, moving script processing to the end.
  • -- PHP Conversion Changes
  • Added support for conversion to CakePHP version 2, providing improved performance.
  • Added support for conversion of FileMaker Auto-Enter field options into PHP code within the CakePHP model files.
  • Added Duplicate Record feature on navigation toolbar. The isAuthorized AppController function insures that users with the ReadOnly and EditOnly roles cannot use this feature.
  • Added Export to CSV feature to navigation toolbar for foundsets of records.
  • Added FileMaker query operators to the query toolbar, including support for the omit records option.
  • Improved Add action functionality by redirecting the user to the Edit form instead of the index list after the creation of the new record. This workflow more closely matches the original FileMaker functionality and allows the user to immediately edit the new record.
  • Added escaping of single quote characters in layout names listed in the app/views/pages/default.ctp file.
  • Improved the index.ctp and querylist.ctp files by pinning the column titles to the top of the page when scrolling.
  • Fixed an issue which unnecessarily truncated converted PHP script names to the database maximum column length.
  • Fixed an issue with the link to Delete record action within the index.ctp, querylist.ctp files when using the navigation toolbar.
  • Layouts which contain duplicate contents will now be generated into the project but logged into the Duplicate Objects Report.xls file.
  • Fixed an issue which caused value list names to be shortened to the maximum length of a database table column name.
  • Added shortening of TO names converted into CakePHP model names to prevent model names from exceeding the maximum column name length. The model name is used as an alias within generated SQL statements created by CakePHP. This feature is enabled by selecting the Fix Duplicate Columns ... feature from the File menu.

New in FmPro Migrator 6.85 (Sep 24, 2012)

  • Added setting a default NLS_LANG environment variable of 'AMERICAN_AMERICA.AL32UTF8' to the xferData.pl files generated for Oracle database data transfers.
  • Fixed an issue with the Script_Text (plain text) version of scripts not getting written properly into the MigrationProcess.db3 file when copied via the clipboard. This issue prevented the conversion of scripts into other programming languages.
  • Fixed an issue with xferData.pl generated scripts used for Repeating Fields processing to include use of source database password.
  • Changed Step 5 of Table Consolidation processing to skip Perform Script file reference changes for FM11+ script versions. This change is due to there not being line endings within FM11+ scripts copied via the clipboard, which is a feature used by this processing code.
  • Moved database close cursors command after writing of fieldsize data within the GetInfo (Step 2) processing.
  • Improved Migration Tables report by sorting output by source table name.
  • Fixed an issue with Oracle data conversions by transferring Time fields as VARCHAR instead of DATE fields. Conversion of Timestamp fields now uses SQL_TIMESTAMP binding type within xferDataPerl.pl code in order to transfer both date and time info.
  • Fixed an issue with the Image Export dialog only showing JPEG as an export data type with FileMaker 12 selected as the source database type.
  • PHP Conversion Changes:
  • Added support for Global fields. Global fields data is written into the $_SESSION['GlobalFields'] session memory. Global fields data is used within the Model just as it is with all the rest of the data coming from the database server. Global fields may be initialized to specified values using the beforeFilter() function within the AppController.
  • Added conversion of FileMaker Stored and Unstored Calculation fields into PHP code. The Unstored Calculation fields are implemented within the view and edit actions of any form controller for which the field is displayed on the form. Since Unstored Calculation values are written into the model when calculated, the values are effectively stored as well. Stored Calculations are calculated within the model whenever a record is saved.
  • Added conversion of WebViewer layout objects, including support for parsing WebViewer URLs with field name substitution within the generated PHP code. This feature also directly supports WebViewer objects being used with the 360Works SuperContainer product.
  • Changed Save Records as PDF function for BlankRecord to use the query form to enable usage for ReadOnly access generated applications.
  • Fixed an issue with Goto Layout button code to insure that a placeholder record ID of 0 gets passed to the toolbars_controller. The actual record ID# is determined by the toolbars_controller code. This fix prevents failure of the form loading process if the form has not been visited previously during the session.
  • Fixed an issue with Save Records as PDF code not being executed on edit.ctp view files.
  • Fixed an issue with unescaped single quote characters in buttons and text labels.
  • Fixed an issue with merge fields defined without a TO name.
  • Fixed an issue with some Rect, Rrect, Oval objects not being displayed when converting FileMaker 12 layouts.
  • Fixed an issue with incorrect field border colors with FileMaker 7-11 database versions.

New in FmPro Migrator 6.79 (Jun 15, 2012)

  • Added support for Table Consolidation/Database Rebuild of FileMaker 12 database files.
  • Added support for converting FileMaker 12 databases to PHP web applications.
  • Added a new Fix Duplicate Columns feature, available under the File menu. This feature shortens long field names in a manner which prevents duplicates.

New in FmPro Migrator 6.68 (Apr 20, 2012)

  • Added new VB6 to LiveCode conversion feature supporting the conversion of forms and scripts into LiveCode stacks.
  • Fixed an issue during batch importing of layouts within groups from FileMaker Pro Advanced DDR XML files.
  • Updated LiveCode conversion terminology and file extension.
  • Added a small delay to the Export Detailed Report button on the Tables tab of the Migration Process window in order to allow the busy cursor to be visible.
  • Added setting of rolloverCursor property for Servoy button, line and graphic image objects if they are assigned to a script on the FileMaker layout.
  • Improved the compatibility of pasting scripts into FileMaker 11 database files.
  • Added a button to copy selected scripts onto the clipboard.
  • -- Access to FileMaker Pro Conversion Changes
  • Improved error handling for Access database tables containing high ASCII characters along with writing a report file of the offending table names into the Missing_Table_Columns_List.txt file.
  • Fixed an issue with incorrect text label background colors.
  • Removed the ampersand shortcut key character from text labels.
  • Added linking of acCommandButton objects to converted FileMaker Pro scripts. This feature uses AccessDDRExport 2.6 (included with FmPro Migrator).
  • Holding down the shift key during the Drag & Drop of the Access database file will convert all Access Date/Time fields into Date fields in the new FileMaker database. Sometimes the timestamp into is not even required and a date field is the most appropriate data type.
  • Fixed an issue which prevented processing Access database tablen ames containing a single quote character.
  • -- PHP Conversion Changes
  • Added support for converting FileMaker portals into ExtJS 4 grid objects.
  • Fixed an issue which could cause portal fields to be skipped during conversion.
  • Replaced Adobe Spry Tooltips with CSS tooltips to provide compatibility with situations in which JavaScript is disabled in the web browser. This change also reduces the page size, loading and execution time.
  • Fixed an issue with container fields being converted as TextArea fields in some situations.
  • Fixed an error with menus after submitting an updated edit form when using the navigation toolbar.
  • Improved the URL parsing of the primary key within jqGrid PHP files.

New in FmPro Migrator 6.57 (Feb 9, 2012)

  • Added new navigation toolbar feature, including form navigation menu, record navigation buttons with display mode changing buttons.
  • Fixed issues reading metadata for FileMaker tables using ODBC on Windows and AppleScript on MacOS X.
  • Fixed an issue with transfer of non-BYTEA data columns into PostgreSQL database servers.
  • Increased the maximum length of PostgreSQL table/column names from 31 to 63 to support higher NAMEDATALEN values used for PostgreSQL 7+ versions.

New in FmPro Migrator 6.46 (Jan 3, 2012)

  • PHP Conversion Changes:
  • Added conversion of 10 additional single step script steps, including: enter find mode, enter browse mode, new record, delete record, show all records, beep, open URL, goto layout, perform script and print.
  • Added a new Data Access preference item which generates a web application with "All", "Read Only" or "Edit Only" data access features. This feature removes unnecessary controller and button code, preventing data modification if it is not required in the application.
  • Fixed an issue with converted Tab Controls not displaying properly on query.ctp and add.ctp view files.
  • Enhanced invalid record processing for edit and view actions to go to the first record in the database table instead of displaying the "Invalid Record" dialog. This feature improves the usability of Goto Layout scripting for layout objects.
  • Added "_basetable" to names of base table controllers to reduce the possibility of name conflicts with regular layout controller filenames.
  • Added display of BLOB column contents on edit.ctp view files.
  • Fixed an issue with image navigation buttons redirecting to view.ctp form instead of edit.ctp file when clicked.
  • Fixed object clipping of Vector Graphic Oval/Circle and Rounded Rectange objects if borderwidth > 1.
  • Servoy Conversion Changes:
  • Added support for generating Servoy 5/6 formatted project files.
  • Added a new preference item which enables the automated removal of object style info for all field/text objects. This feature makes it easier to assign stylesheets to form objects within the Servoy Eclipse IDE.
  • Fixed Servoy Migration issues for most missing portal fields within Tab Panels and truncation of portal relationship names.
  • Fixed a pathname issue with the FmigScriptConversion.db3 file which affected Servoy and FileMaker to Access conversions on MacOS X.
  • Added support for setting the field editable property based upon the original FileMaker Pro field behavior setting.
  • .NET Conversion Changes:
  • Fixed issues with DataContext errors for field and grid objects in situations in which data binding was not used for the fields in the original VisualFoxPro or Access database.
  • Fixed an issue which could cause the MigrationProcess.dat file to get overwritten with a 0 byte file while loading a project.

New in FmPro Migrator 6.35 (Oct 3, 2011)

  • Added creation of Script to Layout Object Report.txt and Script to Layout Usage Report.txt files for PHP Conversion projects.

New in FmPro Migrator 6.24 (Sep 24, 2011)

  • Improved overall application stability on MacOS X and Windows by rebuilding FmPro Migrator with LiveCode 4.6.4.
  • The improved stability will be noticed most easily when clicking on lists of (tables, fields, scripts etc) within the Migration Process window.
  • Fixed an issue with empty results displayed in the Table Details and Field Details windows which occurred as soon as the Table/Field lists were double-clicked.
  • -- PHP Conversion Changes
  • Improved the structure of the generated app by replacing app_model.php with a token.php model file used for the login and role based security feature.
  • Removed some stray HTML tags from views/elements/email/text/verify.ctp file.
  • Improved foundset processing to prevent record navigation outside of the foundset group of records.
  • Added support for converting FileMaker merge fields on layouts.
  • Added support for converting layout symbol objects (record number, username, page number, date, time).
  • Added conversion of static tooltip text into Spry Tooltips for all layout object types.
  • -- Visual FoxPro Conversion Changes
  • Fixed an issue parsing VFP table creation SQL code containing INDEX ON statements.

New in FmPro Migrator 6.13 (Sep 1, 2011)

  • PHP Conversion Changes:
  • Added Basic Authentication implementation for generated PHP web applications. This feature includes both login and role-based authentication throughout the application.
  • The built in roles are intended to provide the same functionality as the original FileMaker database Privilege Sets, including: [Full Access], [Read-Only Access], [Data Entry Only], [Edit Only]. Additional roles can be added to any converted layout controller file as needed.
  • Fixed an issue which would prevent single value checkboxes (1/0 value) to not get unset in the database if unchecked.

New in FmPro Migrator 6.02 (Aug 13, 2011)

  • Conversion changes:
  • Fixed an issue with add.ctp/edit.ctp files in which controller names containing numbers and underscores would confuse CakePHP.
  • Disabled Security component temporarily due to issues with image uploading and checkbox/radio button groups.
  • Fixed an issue with missing XSeries primary key column defined in Multi-Series pCharts. Changed $_SESSION['foundset'] and $_SESSION['current_record'] arrays to incorporate the current layout Model name, allowing foundsets and currentrecord values to be associated with the model used for the form.
  • Removed Model and Fieldname reference in value list definition code within the display form section of the add action controller code to prevent missing index errors. The value list definition remains, in order to populate menus, radio buttons and checkboxes.

New in FmPro Migrator 6.01 (Jul 26, 2011)

  • Added htmlentities() processing for button text labels.
  • Added escaping of "\" characters in text labels.
  • Corrected line #1 of add.ctp file with proper form creation helper code.
  • Added use of CakePHP Security component for form submissions, to prevent cross site scripting attacks.
  • Added use of $fields_blacklist array to prevent users from accidentally modifying PK columns (and any other columns added by the developer).
  • Added $page['record_count'] array element, based upon the current number of records found by the model.
  • Fixed an issue with some Tab Control objects being placed too far vertically down the page, with nested Tab Controls.
  • Improved the gathering of object style info for button objects within Tab Controls.
  • Added a check for TO names matching 56 CakePHP reserved words in the preflight test.
  • The reserved words list is: view,controller,page,global,__,a,aa,am,config,convertSlash,countdim,debug,e,env,fileExistsInPath,h,ife,low,paths,pr,r,stripslashes_deep,up,uses,app,appcontroller,appmodel,behaviorcollection,cache,cacheengine,cakelog,cakesession,classregistry,component,configure,connectionmanager,controller,datasource,debugger,dispatcher,file,fileengine,folder,helper,inflector,model,modelbehavior,object,overloadable,overloadable2,router,security,sessioncomponent,set,string,validation
  • Added $primaryKey column into to Model files, and removed requirement to have each table PK column named as "ID".
  • Fixed an issue which caused jqGrid objects to display an error message in foundset mode.

New in FmPro Migrator 6.00 (Jul 12, 2011)

  • Added conversion of FileMaker Pro, Access and Visual FoxPro databases into PHP web applications using the CakePHP framework.
  • Added a workaround for an issue with MySQL database connections when using the localhost hostname which prevented the MySQL port number from being used to make the database connection. This is actually a MySQL driver issue, which FmPro Migrator works around by using 127.0.0.1 in place of the localhost hostname.
  • Fixed an issue when creating Access database forms/reports in which ctlLabel.Caption proprty code might contain quotes or contain more than 1002 characters.
  • Fixed an issue with Servoy relationship names being limited to 64 characters, depending upon SQL database server being used.
  • Fixed an issue which could cause incorrect fields to be displayed on portals in Servoy applications.
  • Added importing of Dynamic (Field based) value list XML code. This code is being used to create field based value lists in generated PHP web applications.
  • Fixed an issue which could cause field calculations to be missed from the first field of a table pasted via the clipboard.
  • Fixed an issue which caused a 0 byte VFPExport.exe file to be written to the output directory when opening the Visual FoxPro Conversion Service window. This utility is now saved via selecting the Export VFPExport Utility from the File menu in the main application window.
  • Fixed an issue in which some Visual FoxPro forms could be missed during the import process due to use of the objtype versus baseobjecttyp columns of the VFPExport.DBF file. Also upgraded the VFPExport utility to version 2.08.
  • Fixed an issue with Access to FileMaker Pro conversions which could allow non-SQL compliant characters within Base Table names of TOs created from Access database queries.

New in FmPro Migrator 5.99 (Feb 25, 2011)

  • Updated Visual FoxPro Conversion processing to handle form objects within Formsets and Container objects within pageFrame objects.
  • Updated Servoy Conversion processing with enhancemts to: scrollbars, TEXTAREA fields and transparency.

New in FmPro Migrator 5.98 (Jan 27, 2011)

  • Updated VFPExport Utility to version 2.07 to improve the exporting of metadata from .vcx forms for Visual FoxPro migration projects.
  • For Visual FoxPro Conversions, removed _base form processing, fixed an issue which prevented importing VCX form object code as scripts.
  • Fixed error message text when creating relationships in SQL databases on the Relationship tab.
  • Changed MySQL table creation code to use ENGINE = MyISAM instead of TYPE = MyISAM, providing compatibility with MySQL 5.5. The MyISAM engine is used instead of INNODB for improved performance during bulk data inserts.
  • Updated the FileMaker Pro layout creation Quickeys shortcuts and WinAutomation jobs to add an extra button click for a second "Increase Layout Size" dialog. This 2nd dialog occurs whenever a Tab Control is pasted onto the layout if it is larger than the size of the existing layout.

New in FmPro Migrator 5.97 (Jan 3, 2011)

  • Added support for converting Visual FoxPro reports, in addition to the existing forms conversion feature.
  • Improved the Visual FoxPro conversion feature with the following changes: Added text label background color, removed \< accelerator key symbols from text labels, added use of UTF8 character processing for tooltip and caption text.
  • The VFPExport.exe utility used for Visual FoxPro Conversion projects has been enhanced with a runtime ExportHook capture process, which captures info from Forms/Reports while the application is running. This new processing feature enables the accurate capturing of VCX based controls as well as any runtime set properties configured by the application logic.

New in FmPro Migrator 5.86 (Dec 15, 2010)

  • Added Visual Studio 2010 .Net 4 conversion feature. This feature converts Microsoft Access, Visual FoxPro and FileMaker Pro into Visual Studio C# and Visual Basic projects. Forms/Reports and Layouts are converted into .Net WPF XAML forms which include a record and window navigation toolbar as well as an application menu bar and window scrollbars (displayed if needed). C# and Visual Basic Entity Framework database code is created for each converted window XAML file, providing insert, update and delete of records in the SQL database.
  • Updated Microsoft Access to FileMaker Pro migration process to handle situations in which acLine objects have a Width/Height of 0 pixels.
  • Updated code in Access and LiveCode Conversions to workaround an issue processing objects within Tab Controls in which the number of enclosed objects was not found within the Layout XML. This problem caused processing to stop due to this error condition.

New in FmPro Migrator 5.75 (Nov 30, 2010)

  • Added Visual FoxPro project import feature. Visual FoxPro projects can be converted into LiveCode, Microsoft Access, FileMaker Pro and Servoy projects. Direct data transfers from .DBF files are supported for 11 database servers.
  • Fixed issues with Servoy, Access to FileMaker conversions.

New in FmPro Migrator 5.70 (Aug 23, 2010)

  • Changed the name of the exported QuicKeys shortcuts file extension from .qkexport to .qkmx to match the new file extension used by QuicKeys 4.0.7.
  • [This is a MacOS X only release, the windows version of FmPro Migrator remains unchanged.]

New in FmPro Migrator 5.69 (Aug 15, 2010)

  • Added PRAGMA UTF-8 command prior to creating SQLite database files, to insure that data is written in UTF-8 format.

New in FmPro Migrator (Jul 7, 2010)

  • Added support for performing table consolidation projects with FileMaker Pro Advanced 11.
  • Added supoort for creating more than 399 relationships during FileMaker table consolidation projects by saving the results and re-opening the Manage Database dialog. This step occurs every 200 relationships in order to prevent out of memory errors with FileMaker Pro Advanced.
  • Fixed an issue involving the creation of SQL database relationships on Windows.
  • Added Autoincrement table creation column type for PK columns created in Access databases.
  • Removed obsolete Bento to FmPro conversion feature. This feature is now incorporated into FileMaker Pro.
  • Fixed an issue with prevented the creation of Microsoft Access reports during Access database conversions.
  • Updated Servoy migration process to set Radio Button and Checkbox fields to an empty border, set Portal Multi-Line parameter to true for all portals, set column type for "time" in addition to "timestamp" columns, added escaping of "\" characters in text labels and added replacing the "." character in image object names with "_".
  • Added Missing Table Report.xls for DBToRev conversions and enabled the conversion of Forms/Layouts which don't have an assigned table.
  • Updated xferData.app for compatibility with MacOSX 10.6 when using MySQL as the destination database. This feature only gets used when holding down the shift key while transferring data. This change to the compiled exectuable also lay the foundation for supporting additional source database types.
  • Enhanced the process of creating Value Lists and Custom Functions within FileMaker databases by eliminating duplicated Value Lists and Custom Functions from the list of items which will be created. All of the original Value Lists and Custom Functions will remain in the FmPro Migrator MigrationProcess.db3 project file. If you have Value Lists and Custom Functions having the same name, but which contain different contents - you must resolve this issue manually.
  • Fixed an issue which could prevent TOs from being created if the color of the TO was not originally captured from the DDR XML file.
  • Added Missing Relationships Report.xls file for DBToRev database migrations. This report lists the names of inferred relationships within FileMaker%2

New in FmPro Migrator 5.68 (Jul 7, 2010)

  • Added support for performing table consolidation projects with FileMaker Pro Advanced 11.
  • Added supoort for creating more than 399 relationships during FileMaker table consolidation projects by saving the results and re-opening the Manage Database dialog. This step occurs every 200 relationships in order to prevent out of memory errors with FileMaker Pro Advanced.
  • Fixed an issue involving the creation of SQL database relationships on Windows.
  • Added Autoincrement table creation column type for PK columns created in Access databases.
  • Removed obsolete Bento to FmPro conversion feature. This feature is now incorporated into FileMaker Pro.
  • Fixed an issue with prevented the creation of Microsoft Access reports during Access database conversions.
  • Updated Servoy migration process to set Radio Button and Checkbox fields to an empty border, set Portal Multi-Line parameter to true for all portals, set column type for "time" in addition to "timestamp" columns, added escaping of "\" characters in text labels and added replacing the "." character in image object names with "_".
  • Added Missing Table Report.xls for DBToRev conversions and enabled the conversion of Forms/Layouts which don't have an assigned table.
  • Updated xferData.app for compatibility with MacOSX 10.6 when using MySQL as the destination database. This feature only gets used when holding down the shift key while transferring data. This change to the compiled exectuable also lay the foundation for supporting additional source database types.
  • Enhanced the process of creating Value Lists and Custom Functions within FileMaker databases by eliminating duplicated Value Lists and Custom Functions from the list of items which will be created. All of the original Value Lists and Custom Functions will remain in the FmPro Migrator MigrationProcess.db3 project file. If you have Value Lists and Custom Functions having the same name, but which contain different contents - you must resolve this issue manually.
  • Fixed an issue which could prevent TOs from being created if the color of the TO was not originally captured from the DDR XML file.
  • Added Missing Relationships Report.xls file for DBToRev database migrations. This report lists the names of inferred relationships within FileMaker database files, which will need to be manually coded as SQL Yoga relationships.
  • Fixed an issue with the showAllRecords handler in the DBToRev generated stack regarding initialzation of the tCurrentCardName local variable. Added code to the generated setProp handler for checkBox buttons to set line endings properly for any platform where the code is run.
  • Fixed an object naming issue which could prevent some radio buttons from being created in the DBToRev generated stack.
  • Improved the quality of layout thumbnail images captured on Windows.
  • [This release includes updated WinAutomation jobs and QuicKeys shortcuts. Select Export QuicKeys or WinAutoation Scripts from the File menu to save the updated scripts to the output directory.]

New in FmPro Migrator 5.57 (Mar 26, 2010)

  • Added new Database to Rev conversion feature, which builds a functional database application from a FileMaker or Access database file. The SQL Yoga database framework is used for all database access. This feature also converts FileMaker Portals and Access subforms into Rev Data Grid objects.

New in FmPro Migrator 5.46 (Jan 27, 2010)

  • Added new PHP to revTalk conversion feature.
  • Added new BASIC to revTalk conversion feature.
  • Fixed the Value Lists generated for Servoy migration projects to add
  • instead of only as value list item separators.
  • Updated Fmig_Preferences.db3 (v6) and MigrationProcess.db3 (v4) files to include new preference items for new features.
  • Renamed Convert Database to Revolution feature with new icon and changed name to Convert Layouts to Rev.
  • Removed obsolete Perl CGI code generating feature.

New in FmPro Migrator 5.35 (Dec 14, 2009)

  • The following changes were implemented for Access and FileMaker to Servoy migration progjects:
  • Added support for creating Servoy TabPanel controls from FileMaker Tab Control objects. These objects are created as separate Servoy forms for each tab which appears within the Tab Control object, along with the enclosed objects and tab panel background color.
  • Added support for creating Servoy tooltips from Access or FileMaker tooltips for fields, buttons and image objects.
  • Added support for creating Servoy fields matching the field border thickness and color of the original field.
  • Rect/Rrect object are now created with the same border thickness and color as the source database.
  • Rect/Rrect objects no longer get filled with the fillcolor if the fillpattern < 2.
  • Added new Drop Unstored Columns.sql output file, to drop unstored calculation and Summary field columns from the destination SQL database.
  • Fixed issues with text label background color and text alignment.
  • Added support for setting formIndex value for each object in order to set the z-order stacking of the objects. This change insures that objects such as rectangles and images will sit underneath field and text label objects for instance.
  • Enhanced FmPro Migrator preferences to store Servoy project configuration parameters (project name, database connection, workspace directory) within the MigrationProcess.db3 project file instead of the main preferences file.
  • Fixed the location for writing of Stored/Unstored Calculation files so that they are now read automatically by the Servoy Eclipse IDE.
  • Servoy aggregations now match the name of the original field.
  • Improved the randomness of generated UUID values.
  • Fixed an issue in which layout objects with duplicated names were not created.
  • Added new Duplicate Objects Report.xls output file. This report file contains a list of duplicate Layouts, Value Lists, Scripts and Custom Functions which were either skipped or renamed during processing.
  • Added new feature which converts FileMaker Custom Functions into commented JavaScript functions with parameter names.
  • The following issues changes were implemented for FileMaker to Access migrations:
  • Fixed issues with incorrect field and portal data source names.
  • Fixed an issue with some Line objects having incorrect border values.

New in FmPro Migrator 5.31 (Nov 23, 2009)

  • Enhanced the conversion of Access to FileMaker conversions with improvements to the exporting of VBA Form Code, VBA Module Code, Access Reports. Improvements were also made to the exporting of embedded images, including situations in which a button contains an image and a text label.
  • Enhanced FileMaker to Servoy migrations with improvements to Value Lists, addition of Form body part, relationship creation, portal relationships usage, image fields, support for merge fields, merge field text within buttons and object naming.

New in FmPro Migrator 5.28 (Nov 2, 2009)

  • Enhanced loading and display of preferences info. If a MigrationProcess.db3 file is found in the output directory specified within the FmigPreferences.db3 file, then the preferneces will be loaded from the MigrationProcess.db3 file. This means that preferences for all parameters except the output directory are effectively stored with the migration project itself. The existing project is also opened automatically in the Migration Process window. Fixes were also made to insure that the database connection info is displayed correctly based upon the info in the project file.
  • Enhanced the output directory Browse button functionality to automatically open MigrationProcess.db3 project files found in the selected output directory. Databsae connection preferences are also loaded and displayed from the project file.
  • MySQL database connections now are set to use the UTF8 character set, and the destination MySQL database should be configured similarly.
  • Added FileMaker 10 to the Source Database menu, as a cosmetic enhancment.
  • Streamlined the GUI to hide the AppleScript fields/buttons if AppleScript is not selected as the metadata gathering method.
  • The list of Scripts on the Scripts tab is now sorted by the script name.
  • Added feature to extract images from Access database cmdButton objects within the AccessDDRExport2.1 utility. Also added extraction of a wideer range of image types.
  • Fixed duplicated images issue with AccessDDRExport utility, by clearing memory buffer.
  • Improved QuicKeys/WinAutomation scripts to correctly position FileMaker layout objects when pasting layouts.

New in FmPro Migrator 5.25 (Sep 21, 2009)

  • Added new feature to directly copy data from Access to SQL database servers.
  • Fixed an issue involving batch capturing of FileMaker layouts via clipboard.
  • Fixed an issue with the conversion of Microsoft Access Forms/Reports to HTML and Revolution.
  • Fixed an issue with the QuicKeys Create TO shortcuts which caused the existence of the FileMaker colors window to not be detected on some versions of MacOS X and QuicKeys X3/X4. The QuicKeys shortcut now looks for any type of window instead of a Document Window or Palette Window.
  • [This change requires reinstalling the QuicKeys shortcuts for existing installations.]
  • Fixed an issue with FmPro to Servoy migrations which prevented portal fields from being displayed within the Servoy Eclipse IDE.
  • Fixed an issue reading Microsoft Access relationships from the MSysRelationships table for Access to FileMaker migrations. Previously, relationships having the grbit = 2 were skipped because these types of relationships are not used to enforce referential integrity within Microsoft Access. These relationships are still required within FileMaker Pro databases in order to enable the display of related data within portals and related layout fields.
  • Fixed an issue with the WinAutomation jobs not correctly switching to the first layout with FileMaker 10.

New in FmPro Migrator 5.23 (Aug 13, 2009)

  • Added new Microsoft Access to FileMaker migration feature - including the conversion of Forms/Reports, Relationships, Value Lists, Queries and Visual Basic code.
  • Added limited support for reading Bento 2.0v4 backup files.
  • Improved process for reading Access database table/field info on Windows to allow reading info from table names containing spaces.
  • Improved alternate data transfer processing for Access to FileMaker Pro database tables.

New in FmPro Migrator 5.01 (Jun 15, 2009)

  • Added support for migrating Firebird database Tables/Fields, Relationships and data into FileMaker Pro database files.
  • Fixed issue with external file references not being removed from scripts in some situations, during Step #5 of the Table Consolidation process
  • Fixed an issue with displaying Destination DB Username upon first launch.
  • Converted FileMaker comment characters to Visual Basic comment characters during FmPro to Access script conversions.
  • Fixed cosmetic issue with TOs list field title.
  • Fixed issue with processing of scripts to demo limit during FmPro to Access script conversions.
  • Fixed issue when clicking Step #2 button during Table Consolidation projects, the Layouts screen now opens instead of Value Lists screen. Updated dialog text to refer to batch importing of Layouts from DDR XML files.
  • Fixed issue when clicking Step #3 button during Table Consolidation projects, the Scripts screen now opens instead of the CFs screen.
  • Updated Instructions text Layouts screen to to refer to batch importing of Layouts from DDR XML files.
  • Corrected TO remapping during Table Consolidation projects to use same case characters in XML replacement text within scripts and layout XML. This doesn't affect FileMaker, but external XML processing tools/programming languages will be happier with this change.
  • Fixed issue updating TO File Reference fields on TOs tab.
  • Updated WinAutomation Jobs and QuicKeys shortcuts to click OK button when deleting/pasting layouts containing TAB panel objects during layout processing Pass#2.
  • Updated layout DDR XML importing code with special processing for XML attributes/tags: ,,tableViewVisibility in order to reconcile differences between layout XML code in DDR file with Clipboard.
  • Known Issue: [Database rebuild and Table Consolidation Projects Only] Some TAB Panels may not paste correctly if they were imported from a DDR XML file. These layouts should be copied and pasted manually if there are only a small number of layouts having TAB panels, otherwise the layouts should be copied into FmPro Migrter Developer Edition using the automated clipboard importing method.

New in FmPro Migrator 4.97 (May 26, 2009)

  • Added new feature which imports layouts from FileMaker DDR XML files.
  • Added new FileMaker Pro Layout to Access Forms/Reports conversion feature.
  • Added new FileMaker ScriptMaker to Access Visual Basic conversion feature.
  • Added FileMaker ScriptMaker to Servoy JavaScript conversion feature.
  • Reduced memory consumption when converting layouts to HTML, Revolution stacks, and Servoy projects.

New in FmPro Migrator 4.86 (Apr 20, 2009)

  • Added new FmPro to Servoy Service feature which converts FileMaker Pro layouts, relationships, value lists and scripts into Servoy Eclipse projects.
  • Fixed cosmetic problem with field and label alignment within HTML files generated from FileMaker Pro layouts.

New in FmPro Migrator 4.74 (Mar 23, 2009)

  • Added new feature which converts FileMaker Pro layouts into HTML web pages.
  • Added support for converting FileMaker Pro relationships to Valentina ObjectPtr Links.
  • Fixed an issue transferring large blocks of text data to SQL Server databases.
  • Fixed an issue transferring data to Oracle databases.
  • Added the reserved words "private" and "role" for creation of FileMaker Pro database tables and fields, fixing a parse error during data transfer.
  • Improved the error checking of FileMaker Pro table names when gathering table metadata via ODBC on Windows.
  • Made cosmetic improvements to the display of restored preferences info.

New in FmPro Migrator 4.63 (Feb 11, 2009)

  • Added support for migrating Custom Functions and Value Lists between FileMaker Pro Advanced databases during Table Consolidation projects. Both static and dynamic value lists are created within the destination database, with the dynamic value list objects created as placeholder objects for further customization.
  • Made cosmetic improvements to FileMaker Pro layouts generated by the Bento 2.x to FileMaker Pro migration process. These improvements include: URL portals & fields, Media fields, IM portals & fields, Files list portals.
  • Improved the performance of the QuicKeys scripts used to create migrated Bento layouts within the destination FileMaker Pro database.
  • Added export of File Name column data for Bento 2.x files when exporting file info to match the native functionality of Bento 1.x file exports.
  • Fixed an issue involving the creation of relationships in all SQL databases, with specific corrections to the code which generates Oracle relationships.
  • [Existing users should install the updated QuicKeys/WinAutomation scripts in order to use these new features.]

New in FmPro Migrator 4.56 (Jan 6, 2009)

  • Added support for FileMaker Pro 10 database scripts and Table Consolidation projects.
  • Added support for migrating Bento 2 databases to FileMaker Pro, including relationships between Bento Libraries.
  • Bento 2 forms having field labels at the top and side postions are converted into FileMaker Pro layouts having field labels in the same positions. Bento 2 forms using any of the 10 new Bento 2 built-in Themes are converted to FileMaker Pro layouts having the same style of graphics, backgrounds, fonts and layout objects.
  • Added support for migrating from FileMaker Pro to Valentina databases.
  • Fixed an issue which caused FileMakerDB.fp7 file to not get created in some situations during Step 5 of Table Consolidation projects.

New in FmPro Migrator 4.45 (Nov 17, 2008)

  • Added support for migrating from FileMaker to SQLite databases.
  • Added new FmPro Migrator preferences file within user documents directory. The preferences file stores user entered info for the FileMaker tab migration fields.
  • Simplified migrations involving Access database files by automatically making a File DSN ODBC connection to the source or destination Access .mdb file. This feature is used when gathering info from Access databases, creating tables or transferring data to/from Access databases.
  • Resolved a cosmetic problem involving the display of column IDs for Bento database columns.

New in FmPro Migrator 4.39 (Sep 1, 2008)

  • Fixed an issue with gathering database info from FileMaker 7+ databases on MacOSX (using AppleScript) and Windows (using ODBC).
  • Fixed an issue connecting to MySQL databases configured to a TCP/IP port different from the default port# 3306.
  • Updated QuicKeys/WinAutomation shortcuts to add an extra click to close the Edit Relationship dialog after creating the creation of relationships. To reinstall the updated shortcuts, click the Download QuicKeys/WinAutomation button when prompted within FmPro Migrator, then install the new shortcuts.
  • Improved checking for the existence of MigrationProcess.db3 file before attempting to write data into the SQLite database, reducing the chance of getting a "file not found" error during the migration process.
  • Improved error message displayed when attempting to create the same table twice within a FileMaker 7+ database file via ODBC.

New in FmPro Migrator 4.38 (Aug 26, 2008)

  • Fixed a crash which could occur when gathering table info from some complex Bento files.
  • Fixed issue with extra overlapping fields getting created on Bento converted Layouts.
  • Improved performance while gathering Bento table and relationship info.
  • Added CSV/TAB delimited export of Bento fields containing Unicode characters. This feature enables the export of non-ASCII characters to FileMaker Pro and other applications from localized versions of Bento.
  • Added "Check for updates..." menu option.
  • Added Help menu link to the FmPro Migrator support web page.

New in FmPro Migrator 4.25 (Jun 11, 2008)

  • Developer Edition Feature -- Added conversion of FileMaker Layouts and ScriptMaker scripts to Revolution stack files. Each Layout is converted to a card in the stack and the converted ScriptMaker scripts are written to text files in the output directory along with being copied into a button script within the stack.
  • Fixed an issue with the Transfer Data step for several database conversions.
  • General performance improvements when writing to the SQLite embedded database.
  • Developer Edition Feature -- Updated internal documentation and dialogs with processing order during Table Consolidation projects.
  • Improved code which creates tables in SQL databases to handle situations in which the first character of the original tablename is a number.

New in FmPro Migrator 4.03 (Apr 15, 2008)

  • Re-wrote the entire migration process, providing a new graphical interface for all aspects of the migration. It is no longer necessary to have Perl installed on your computer or to run migration scripts or SQL scripts on the command line to perform database migrations. Results from the Get Fieldsize migration step are automatically used to generate the Table Creation SQL code, which no longer requires manually editing the SQL code with column size info.
  • Developer Edition Feature - Implemented an entirely new graphical migration process for FileMaker Table Consolidation projects, which now includes copying Tables/Fields, Table Occurrences, Relationships, Layouts and ScriptMaker scripts. A remapping feature remaps Table Occurrences within Layouts and ScriptMaker scripts when they are re-created in the consolidated database file. Layout text can also be changed as well when the layouts are re-created.
  • Added support for migrating repeating fields within FileMaker 7, 8, 9 databases using auto-generated ScriptMaker data transformation scripts. This feature overcomes the lack of repeating fields support within the new versions of the FileMaker ODBC driver. Repeating fields data can now be transferred to SQL databases and used with the new External SQL Sources feature incorporated within FileMaker 9.
  • Added a new graphical container field export feature, supporting the 22 container field data types available within FileMaker 7, 8, 9 database files. These 22 container field data types include: EMBO, EMF , EPS, FILE, FPix, FORK, GIFf, JPEG, JP2, META, METO, moov, PDF, PICT, PNGf, PNTG, qtif.SGI, snd, TIFF, TPIC, XMLO, 8BPS.
  • Added support for writing FileMaker container field data into PostgreSQL BYTEA columns.
  • Added support for migrating to OpenBase databases, including the transfer of FileMaker container field data into OpenBase OBJECT columns.