FmPro Migrator full changelog

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.

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.

Rewrote all WinAutomation jobs to use WinAutomation v5. This change enables the job actions to click and select objects by their underlying object ID instead of X,Y coordinates.
The WinAutomation job file is now compiled and distributed at no cost to customers as an executable file not requiring the installation of WinAutomation, along with the source code for the job file. This one job file contains WinAutomation functions for each automation task.
FmPro Migrator now installs and runs the WinAutomation compiled job file automatically, verifies the current FileMaker Pro Advanced version number, and verifies that only 1 copy of FileMaker Pro Advanced is running before stating automation tasks.
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 FileMaker versions are not supported with this feature.

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 quot;** Admin **quot; 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.

· 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.

· 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.

· Added support for Table Consolidation/Database Rebuild of FileMaker 12 database files.
· Fixed an issue creating Servoy aggregation fields.
· Reduced the length of Oracle database trigger names by removing quot;_GET_IDquot; from the name to prevent ORA-00972: quot;identifier is too longquot; errors.
· Added a new Fix Duplicate Columns feature, available under the File menu. This feature shortens long field names in a manner which prevents duplicates. This feature is most useful for database servers such as Oracle, DB2 and Sybase which impose 30 character limit upon column names. But it can be used for any database server having a shorter column name limit compared to FileMaker Pro.
· PHP Conversion Changes
· Added support for converting FileMaker 12 databases to PHP web applications.
· Fixed an issue creating the model name for base table controllers during the PHP Conversion process.

· Added support for Table Consolidation/Database Rebuild of FileMaker 12 database files.
· Fixed an issue creating Servoy aggregation fields.
· Reduced the length of Oracle database trigger names by removing quot;_GET_IDquot; from the name to prevent ORA-00972: quot;identifier is too longquot; errors.
· Added a new Fix Duplicate Columns feature, available under the File menu. This feature shortens long field names in a manner which prevents duplicates. This feature is most useful for database servers such as Oracle, DB2 and Sybase which impose 30 character limit upon column names. But it can be used for any database server having a shorter column name limit compared to FileMaker Pro.
· PHP Conversion Changes
· Added support for converting FileMaker 12 databases to PHP web applications.
· Fixed an issue creating the model name for base table controllers during the PHP Conversion process.
· Fixed an issue with quote characters not being displayed properly on converted layouts during the PHP Conversion p

· 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.

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