1/2/2012
.com Solutions Inc.(TM) FmPro Migrator 6.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 6.46: 1/2/2012
-- PHP Conversion Changes
1) Added conversion of 10 additional single step script steps, including: enter find mode, enter browse mode, new record, delete record, show all records, beep, open URL, goto layout, perform script and print.
2) Added a new Data Access preference item which generates a web application with "All", "Read Only" or "Edit Only" data access features. This feature removes unnecessary controller and button code, preventing data modification if it is not required in the application.
3) Fixed an issue with converted Tab Controls not displaying properly on query.ctp and add.ctp view files.
4) Enhanced invalid record processing for edit and view actions to go to the first record in the database table instead of displaying the "Invalid Record" dialog. This feature improves the usability of Goto Layout scripting for layout objects.
5) Added "_basetable" to names of base table controllers to reduce the possibility of name conflicts with regular layout controller filenames.
6) Added display of BLOB column contents on edit.ctp view files.
7) Fixed an issue with image navigation buttons redirecting to view.ctp form instead of edit.ctp file when clicked.
8) Fixed object clipping of Vector Graphic Oval/Circle and Rounded Rectange objects if borderwidth > 1.
-- Servoy Conversion Changes
9) Added support for generating Servoy 5/6 formatted project files.
10) Added a new preference item which enables the automated removal of object style info for all field/text objects. This feature makes it easier to assign stylesheets to form objects within the Servoy Eclipse IDE.
11) Fixed Servoy Migration issues for most missing portal fields within Tab Panels and truncation of portal relationship names.
12) Fixed a pathname issue with the FmigScriptConversion.db3 file which affected Servoy and FileMaker to Access conversions on MacOS X.
13) Added support for setting the field editable property based upon the original FileMaker Pro field behavior setting.
-- .NET Conversion Changes
14) Fixed issues with DataContext errors for field and grid objects in situations in which data binding was not used for the fields in the original VisualFoxPro or Access database.
15) Fixed an issue which could cause the MigrationProcess.dat file to get overwritten with a 0 byte file while loading a project.

Version 6.35: 9/30/2011
1) Added creation of Script to Layout Object Report.txt and Script to Layout Usage Report.txt files for PHP Conversion projects.

Version 6.24: 9/23/2011
1) Improved overall application stability on MacOS X and Windows by rebuilding FmPro Migrator with LiveCode 4.6.4. 
The improved stability will be noticed most easily when clicking on lists of (tables, fields, scripts etc) within the Migration Process window.
2) Fixed an issue with empty results displayed in the Table Details and Field Details windows which occurred as soon as the Table/Field lists were double-clicked.
-- PHP Conversion Changes
3) Improved the structure of the generated app by replacing app_model.php with a token.php model file used for the login and role based security feature.
4) Removed some stray HTML tags from views/elements/email/text/verify.ctp file.
5) Improved foundset processing to prevent record navigation outside of the foundset group of records.
6) Added support for converting FileMaker merge fields on layouts.
7) Added support for converting layout symbol objects (record number, username, page number, date, time).
8) Added conversion of static tooltip text into Spry Tooltips for all layout object types.
-- Visual FoxPro Conversion Changes
9) Fixed an issue parsing VFP table creation SQL code containing INDEX ON statements. 

Version 6.13: 9/1/2011
-- PHP Conversion Changes
1) Added Basic Authentication implementation for generated PHP web applications. This feature includes both login and role-based authentication throughout the application.
The built in roles are intended to provide the same functionality as the original FileMaker database Privilege Sets, including: [Full Access], [Read-Only Access], [Data Entry Only], [Edit Only]. Additional roles can be added to any converted layout controller file as needed.
2) Fixed an issue which would prevent single value checkboxes (1/0 value) to not get unset in the database if unchecked.


Version 6.02: 8/12/2011
-- PHP Conversion Changes
1) Fixed an issue with add.ctp/edit.ctp files in which controller names containing numbers and underscores would confuse CakePHP.
2) Disabled Security component temporarily due to issues with image uploading and checkbox/radio button groups.
3) Fixed an issue with missing XSeries primary key column defined in Multi-Series pCharts.
4) Changed $_SESSION['foundset'] and $_SESSION['current_record'] arrays to incorporate the current layout Model name, allowing foundsets and currentrecord values to be associated with the model used for the form.
5) Removed Model and Fieldname reference in value list definition code within the display form section of the add action controller code to prevent missing index errors. The value list definition remains, in order to populate menus, radio buttons and checkboxes.
6) Removed reference to BLOB column Model and Fieldname reference in add action of controller, for initial view of form.
7) Corrected the form submit URL in the query.ctp file to work more reliably in all situations.
8) Fixed an issue with generated model files in which PK column validation code was being generated.
-- Visual FoxPro Conversion Changes
9) Fixed an issue with unconverted fieldnames not being put onto clipboard for FoxPro to FileMaker Pro conversions.
10) Swapped NULL/NOT NULL status determination for FoxPro column attributes to match usage in the FoxPro IDE.
-- General Changes
11) Fixed an issue in which multiple fields could have been marked as PK columns in the Fields List.
12) Fixed an issue in which Tables with 0 fields could get put onto the clipboard, causing an error pasting the tables into FileMaker.
13) Fixed a cosmetic issue which caused the Table Details and Field Details windows to be displayed behind the Migration Process window when tables list or fields list was double-clicked.
14) Fixed a problem which caused a crash on Windows systems when opening new project files.

Version 6.01: 7/25/2011
These changes were all added for the PHP Conversion feature.
1) Added htmlentities() processing for button text labels.
2) Added escaping of "\" characters in text labels.
3) Corrected line #1 of add.ctp file with proper form creation helper code.
4) Added use of CakePHP Security component for form submissions, to prevent cross site scripting attacks.
5) Added use of $fields_blacklist array to prevent users from accidentally modifying PK columns (and any other columns added by the developer).
6) Added $page['record_count'] array element, based upon the current number of records found by the model.
7) Fixed an issue with some Tab Control objects being placed too far vertically down the page, with nested Tab Controls.
8) Improved the gathering of object style info for button objects within Tab Controls.
9) Added a check for TO names matching 56 CakePHP reserved words in the preflight test.
The reserved words list is: view,controller,page,global,__,a,aa,am,config,convertSlash,countdim,debug,e,env,fileExistsInPath,h,ife,low,paths,pr,r,stripslashes_deep,up,uses,app,appcontroller,appmodel,behaviorcollection,cache,cacheengine,cakelog,cakesession,classregistry,component,configure,connectionmanager,controller,datasource,debugger,dispatcher,file,fileengine,folder,helper,inflector,model,modelbehavior,object,overloadable,overloadable2,router,security,sessioncomponent,set,string,validation
10) Added $primaryKey column into to Model files, and removed requirement to have each table PK column named as "ID".
11) Fixed an issue which caused jqGrid objects to display an error message in foundset mode.
  

Version 6.00: 7/11/2011
1) Added conversion of FileMaker Pro, Access and Visual FoxPro databases into PHP web applications using the CakePHP framework.
2) Added a workaround for an issue with MySQL database connections when using the localhost hostname which prevented the MySQL port number from being used to make the database connection. This is actually a MySQL driver issue, which FmPro Migrator works around by using 127.0.0.1 in place of the localhost hostname.
3) Fixed an issue when creating Access database forms/reports in which ctlLabel.Caption proprty code might contain quotes or contain more than 1002 characters.
4) Fixed an issue with Servoy relationship names being limited to 64 characters, depending upon SQL database server being used.
5) Fixed an issue which could cause incorrect fields to be displayed on portals in Servoy applications.
6) Added importing of Dynamic (Field based) value list XML code. This code is being used to create field based value lists in generated PHP web applications.
7) Fixed an issue which could cause field calculations to be missed from the first field of a table pasted via the clipboard.
8) Fixed an issue which caused a 0 byte VFPExport.exe file to be written to the output directory when opening the Visual FoxPro Conversion Service window. This utility is now saved via selecting the Export VFPExport Utility from the File menu in the main application window.
9) Fixed an issue in which some Visual FoxPro forms could be missed during the import process due to use of the objtype versus baseobjecttyp columns of the VFPExport.DBF file. Also upgraded the VFPExport utility to version 2.08.
10) Fixed an issue with Access to FileMaker Pro conversions which could allow non-SQL compliant characters within Base Table names of TOs created from Access database queries.

Version 5.99: 2/24/2011
1) Updated Visual FoxPro Conversion processing to handle form objects within Formsets and Container objects within pageFrame objects.
2) Updated Servoy Conversion processing to disable horizontal scrollbars for field objects by default, and to create large text fields taller than 50 pixels as TEXTAREA fields. Disabled writing form dataProvider info in situations where a table has not been assigned to a form. Radio Buttons and CheckBoxes now use the transparency setting within the original layout XML. 
3) Added use of Visual FoxPro Caption property as titleText for fields created on Servoy forms.
4) Added prioritized use of Visual FoxPro Caption property, Object Name or Tablename, Fieldname within generated object fieldname for Servoy form fields.
5) Fixed an issue which could cause 1 Visual FoxPro form to have an empty name with no objects upon importing.
6) Updated QuicKeys Copy Layout2FMP FMP11 shortcut to add two extra mouse clicks to close the "Increase Layout Size" dialogs when creating FileMaker Pro 11 layouts.

Version 5.98: 1/26/2011
1) Updated VFPExport Utility to version 2.07 to improve the exporting of metadata from .vcx forms for Visual FoxPro migration projects.
2) For Visual FoxPro Conversions, removed _base form processing, fixed an issue which prevented importing VCX form object code as scripts.
3) Fixed error message text when creating relationships in SQL databases on the Relationship tab.
4) Changed MySQL table creation code to use ENGINE = MyISAM instead of TYPE = MyISAM, providing compatibility with MySQL 5.5. The MyISAM engine is used instead of INNODB for improved performance during bulk data inserts.
5) Updated the FileMaker Pro layout creation Quickeys shortcuts and WinAutomation jobs to add an extra button click for a second "Increase Layout Size" dialog. This 2nd dialog occurs whenever a Tab Control is pasted onto the layout if it is larger than the size of the existing layout.

Version 5.97: 1/3/2011
1) Added support for converting Visual FoxPro reports and labels, in addition to the existing forms conversion feature.
2) Improved the Visual FoxPro conversion feature with the following changes: Added text label background color, removed \< accelerator key symbols from text labels, added use of UTF8 character processing for tooltip and caption text.
3) The VFPExport.exe 2.05 utility used for Visual FoxPro Conversion projects has been enhanced with a runtime ExportHook capture process, which captures info from Forms/Reports while the application is running. This new processing feature enables the accurate capturing of VCX based controls as well as any runtime set properties configured by the application logic.


Version 5.86: 12/15/2010
1) Added Visual Studio 2010 .Net 4 conversion feature. This feature converts Microsoft Access, Visual FoxPro and FileMaker Pro into Visual Studio C# and Visual Basic projects. Forms/Reports and Layouts are converted into .Net WPF XAML forms which include a record and window navigation toolbar as well as an application menu bar and window scrollbars (displayed if needed). C# and Visual Basic Entity Framework database code is created for each converted window XAML file, providing insert, update and delete of records in the SQL database.
2) Updated Microsoft Access to FileMaker Pro migration process to handle situations in which acLine objects have a Width/Height of 0 pixels.
3) Updated code in Access and LiveCode Conversions to workaround an issue processing objects within Tab Controls in which the number of enclosed objects was not found within the Layout XML. This problem caused processing to stop due to this error condition.

Version 5.75: 11/29/2010
1) Added Visual FoxPro project import feature. Visual FoxPro projects can be converted into LiveCode, Microsoft Access, FileMaker Pro and Servoy projects. Most Visual FoxPro Form objects are supported, relationships are imported, and Visual FoxPro code is converted into commented code in the converted database project. Direct data transfers from .DBF files are supported for Access, DB2, FileMaker Pro, FrontBase, MySQL, OpenBase, Oracle, PostgreSQL, SQLite, SQL Server and SyBase databases.
2) Fixed conversion issues with Servoy conversions in which some objects did not get drawn with the proper borders.
3) Changed Servoy portal formIndex from 16 to 2 so fields get placed over the portal instead of underneath the portal.
4) Updated QuicKeys scripts to handle situations in which multiple tables containing spaces and using the same identical first word for the table name could result in the wrong base table being selected when creating TOs. Now, the "= Placeholder" table is selected first before the TO base table name is typed into the dialog. This insures that FileMaker starts looking for the first occurrence of a similarly named table, instead of the 2nd or 3rd occurrence.
5) Fixed an issue with Access to FileMaker migrations which would report 1 extra portal in the list of layout info on the layouts tab.
6) Fixed an issue when creating Servoy portal fields, in which some fields were associated with the wrong portal if there were multiple portals on the form.
7) Added setting the Servoy portal rowHeight property to 20 pixels.
8) Fixed an issue with the size of Servoy Tab Controls not being set to the correct size, and thus causing warnings to be displayed in the Servoy Eclipse IDE (v5+ versions only).
9) Fixed an issue with some colors being rendered incorrectly in generated HTML files.
10) Fixed an issue reading .bmp images during Access to FileMaker conversions, which could prevent the conversion process from completing.

Known VFPExport.exe Utility Limitations:
1) Reports are not currently converted.
2) VCX Object Properties which are set at runtime are incomplete because the object is not instantiated at the time the properties are retreived.
3) DBF file paths will be incorrect if the DBF file is not located within the same directory as the DBC file.
4) Pathnames to image objects for VCX objects are incomplete.
5) Localized versions of ToolTip and Comment property text are not retrieved at the present time.

Version 5.70: 8/22/2010
1) Changed the name of the exported QuicKeys shortcuts file extension from .qkexport to .qkmx to match the new file extension used by QuicKeys 4.0.7.
[This is a MacOS X only release, the windows version of FmPro Migrator remains unchanged.]