12/14/2009 .com Solutions Inc.(TM) FmPro Migrator 5.35 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.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.] Version 5.23: 8/13/2009 1) Added new Microsoft Access to FileMaker migration feature - including the conversion of Forms/Reports, Relationships, Value Lists, Queries and Visual Basic code. 2) Added limited support for reading Bento 2.0v4 backup files. 3) Improved process for reading Access database table/field info on Windows to allow reading info from table names containing spaces. 4) Improved alternate data transfer processing for Access to FileMaker Pro database tables. Version 5.01: 6/15/2009 1) Added support for migrating Firebird database Tables/Fields, Relationships and data into FileMaker Pro database files. 2) Fixed issue with external file references not being removed from scripts in some situations, during Step #5 of the Table Consolidation process 3) Fixed an issue with displaying Destination DB Username upon first launch. 4) Converted FileMaker comment characters to Visual Basic comment characters during FmPro to Access script conversions. 5) Fixed cosmetic issue with TOs list field title. 6) Fixed issue with processing of scripts to demo limit during FmPro to Access script conversions. 7) 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. 8) Fixed issue when clicking Step #3 button during Table Consolidation projects, the Scripts screen now opens instead of the CFs screen. 9) Updated Instructions text Layouts screen to to refer to batch importing of Layouts from DDR XML files. 10) 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. 11) Fixed issue updating TO File Reference fields on TOs tab. 12) Updated WinAutomation Jobs and QuicKeys shortcuts to click OK button when deleting/pasting layouts containing TAB panel objects during layout processing Pass#2. 13) 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.