1/25/2010
.com Solutions Inc.(TM) FmPro Migrator 5.46 Read Me file

Mac OS X Installation Notes
1) Download the FmProMigratorxxxMacOSX.dmg disk image file from the web site (where xxx is replaced with the version number). 
2) The disk image file should be opened automatically by your browser. Otherwise, just double-click on the file to open it.
3) Copy the application to your Applications folder (or anywhere else you choose). Launch FmPro Migrator by double-clicking on its icon.

Windows Installation Notes
1) Download the FmProMigratorxxxWindows.zip file from the web site to the location where you want it to reside on your hard drive. The application file may be installed anywhere on your hard drive, it does not have to go into the C:\Program Files directory.
2) Use WinZip to decompress the file containing FmPro Migrator.
3) Launch the application by double-clicking on it. You may make a shortcut to the application on your desktop or in the Start/Programs menu. Note: FmPro Migrator on Windows is provided as a zip archive which decompresses to a folder. The folder named "externals" needs to remain with the FmPro Migrator application in order to allow direct access to databases accessed by FmPro Migrator.


VERSION HISTORY:

Version 5.46: 1/25/2010
1) Added new PHP to revTalk conversion feature.
2) Added new BASIC to revTalk conversion feature.
3) Fixed the Value Lists generated for Servoy migration projects to add \r\n instead of only \r as value list item separators.
4) Updated Fmig_Preferences.db3 (v6) and MigrationProcess.db3 (v4) files to include new preference items for new features.
5) Renamed Convert Database to Revolution feature with new icon and changed name to Convert Layouts to Rev.
6) Removed obsolete Perl CGI code generating feature.

Version 5.35: 12/14/2009
The following changes were implemented for Access and FileMaker to Servoy migration progjects:
1) 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.
2) Added support for creating Servoy tooltips from Access or FileMaker tooltips for fields, buttons and image objects.
3) Added support for creating Servoy fields matching the field border thickness and color of the original field.
4) Rect/Rrect object are now created with the same border thickness and color as the source database.
5) Rect/Rrect objects no longer get filled with the fillcolor if the fillpattern < 2.
6) Added new Drop Unstored Columns.sql output file, to drop unstored calculation and Summary field columns from the destination SQL database. 
7) Fixed issues with text label background color and text alignment.
8) 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.
9) 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.
10) Fixed the location for writing of Stored/Unstored Calculation files so that they are now read automatically by the Servoy Eclipse IDE.
11) Servoy aggregations now match the name of the original field.
12) Improved the randomness of generated UUID values.
13) Fixed an issue in which layout objects with duplicated names were not created.
14) 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.
15) 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:
16) Fixed issues with incorrect field and portal data source names.
17) Fixed an issue with some Line objects having incorrect border values.

Version 5.31: 11/23/2009
1) 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.
2) 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.

Version 5.28: 11/2/2009
1) 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 preferences 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.
2) Enhanced the output directory Browse button functionality to automatically open MigrationProcess.db3 project files found in the selected output directory. Database connection preferences are also loaded and displayed from the project file.
3) MySQL database connections now are set to use the UTF8 character set, and the destination MySQL database should be configured similarly.
4) Added FileMaker 10 to the Source Database menu, as a cosmetic enhancement.
5) Streamlined the GUI to hide the AppleScript fields/buttons if AppleScript is not selected as the metadata gathering method.
6) The list of Scripts on the Scripts tab is now sorted by the script name.
7) Added feature to extract images from Access database cmdButton objects within the AccessDDRExport2.1 utility. Also added extraction of a wider range of image types.
8) Fixed duplicated images issue with AccessDDRExport utility, by clearing memory buffer.
9) Improved QuicKeys/WinAutomation scripts to correctly position FileMaker layout objects when pasting layouts.

Version 5.25: 9/21/2009
1) Added new feature to directly copy data from Access to SQL database servers.
2) Fixed an issue involving batch capturing of FileMaker layouts via clipboard.
3) Fixed an issue with the conversion of Microsoft Access Forms/Reports to HTML and Revolution.
4) 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.]
5) Fixed an issue with FmPro to Servoy migrations which prevented portal fields from being displayed within the Servoy Eclipse IDE.
6) 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.
7) Fixed an issue with the WinAutomation jobs not correctly switching to the first layout with FileMaker 10.
[This change requires reinstalling the WinAutomation jobs for existing installations on Windows.]