7/6/2010 .com Solutions Inc.(TM) FmPro Migrator 5.68 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.68: 7/6/2010 1) Added support for performing table consolidation projects with FileMaker Pro Advanced 11. 2) 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. 3) Fixed an issue involving the creation of SQL database relationships on Windows. 4) Added Autoincrement table creation column type for PK columns created in Access databases. 5) Removed obsolete Bento to FmPro conversion feature. This feature is now incorporated into FileMaker Pro. 6) Fixed an issue with prevented the creation of Microsoft Access reports during Access database conversions. 7) 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 "_". 8) Added Missing Table Report.xls for DBToRev conversions and enabled the conversion of Forms/Layouts which don't have an assigned table. 9) 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. 10) 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. 11) 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. 12) 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. 13) 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. 14) Fixed an object naming issue which could prevent some radio buttons from being created in the DBToRev generated stack. 15) 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.] Version 5.57: 3/22/2010 1) 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 to simulate the original database functionality. 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.]