4/28/2008 .com Solutions Inc.(TM) FmPro Migrator 4.14 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 4.14: 4/28/2008 1) -- Developer Edition Feature -- Added an automated 2 pass process for resolving dependencies between ScriptMaker scripts and Layout objects during Table Consolidation projects. 2) -- Developer Edition Feature -- Added a new Layout XML export feature to the GUI tab. The XML code defining each layout can now be exported as a raw XML file, containing all of the embedded images, and layout object definitions. This file can be post-processed separately and used for projects in which FileMaker Layouts need to be re-purposed for other development projects. Examining the raw XML code for a layout could also provide troubleshooting help for layouts causing a problem in a database file. 3) -- Developer Edition Feature -- Fixed an issue with the Step 5 Remap Objects processing when performing a Table Consolidation project having 0 ScriptMaker scripts. 4) Fixed an issue with Access tablenames containing spaces when performing Access to FileMaker conversions. 5) Fixed an issue with Relationship Predicate Details fields not being displayed when clicking on a Relationship Predicate in the Predicates List. 6) Removed the UNIQUE constraint on Layout names, allowing developers to manually rename Layouts after importing multiple batches of layouts from different files. 7) -- Developer Edition Feature -- Layouts which are created via the batch mode processing are now created with only a Body layout part, to simplify the manual addition of more layout parts. This change was made within the QuicKeys and WinAutomation shortcuts. 8) -- Developer Edition Feature -- Relationship creation has been improved by checking for the display of the Edit Relationship dialog in situations requiring the FileMaker database to create a new renamed TO on the relationship graph. This change was made within the QuicKeys and WinAutomation shortcuts. Note: Clicking the "Download" button on the batch processing dialogs causes FmPro Migrator to save an updated copy of the QuicKeys/WinAutomation shortcuts to the output directory. Version 4.03: 4/13/2008 Major Product Update: 1) 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. 2) 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. 3) 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. 4) 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. 5) Added support for writing FileMaker container field data into PostgreSQL BYTEA columns. 6) Added support for migrating to OpenBase databases, including the transfer of FileMaker container field data into OpenBase OBJECT columns. Version 3.75: 2/18/2006 1) Corrected fieldsize code to output list of fieldnames on both platforms. 2) Updated Access to FileMaker process to use a DSN-less ODBC connection to Access databases to improve accuracy of getting metadata. On MacOS X, FmPro Migrator now utilizes the Actual ODBC for Access ODBC driver from Actual Technologies (www.actualtechnologies.com). 3) Added support for converting Access Date/Time fields to FileMaker 7/8 TIMESTAMP fields. 4) Enhanced FileMaker to Access migration instructions with info about using the max_fieldsize report.