David Simpson

11-25-2024 - Fremont, California - .com Solutions Inc. announces the release of FmPro Migrator 11.17 introducing compatibility with Claris FileMaker Pro 2024 and macOS Sequoia 15.x. AppleScript GUI automation reduces the time required to perform FileMaker Pro table consolidation and database rebuild projects on macOS. It is common to have FileMaker databases containing hundreds of layouts, TOs and Relationships. Rebuilding a complex file of this size or combining older solutions together is very time consuming to perform manually. The AppleScript GUI automation feature built into FmPro Migrator automates the creation of these objects within a new empty database file. FmPro Migrator 11.17 has been released, featuring a variety of maintenance fixes: * FileMaker Pro 21 Compatibility [also known as Claris FileMaker 2024 as it's marketing name] - On macOS, FmPro Migrator uses AppleScript to automate the creation of TOs, Relationships, CFs, Value Lists and Layouts during conversion projects. These scripts have been updated to support the Claris FileMaker Pro 21 release. The updated AppleScript code now uses the English names of menus and windows in an effort to "future proof" these automation tasks in preparation for future FileMaker Pro releases. In the past, these AppleScript tasks referenced objects by their position in an effort to enable the scripts to work across multiple languages. However in actual practice it was still often necessary for customers to switch to English. From a development standpoint, this meant that it was usually necessary to update with new blocks of code to handle new FileMaker Pro releases due to new menus being added or objects being moved around. By the way, this AppleScript code consists of over 2600 lines of code and is downloadable for FREE from within FmPro Migrator in case you want to perform your own FileMaker automation tasks. * Compatibility with macOS Sequoia 15.x - As part of the FileMaker Pro 21 testing, FmPro Migrator automation tasks were also fully tested for compatibility with macOS Sequoia. The one consideration regarding macOS compatibility isn't really a compatibility issue, just a configuration note. Sometimes when upgrading either macOS or FmPro Migrator, it may be necessary to to disable then re-enable the Settings -> Privacy & Security -> Accessibility and Settings -> Privacy & Security -> Automation settings for FmPro Migrator. Even if FmPro Migrator was previously enabled, it may be necessary to disable these settings, close, reopen the Settings panel and then re-enable these settings. VFP to FileMaker Conversion Improvements - This update fixes an issue in which Visual FoxPro fields weren't getting re-named properly when copied via the clipboard into FileMaker Pro. * VFP Conversion Field Constraints Improvements - In Visual FoxPro, the SET NULL ON/OFF command can override field constraints in tables. Therefore the assigned NULL/NOT NULL constraints configured in the DBF files may not reflect how the constraints are actually used. For this reason all fields except PK columns are now imported as NULLable columns. This change will improve all database conversions including FileMaker Pro and SQL databases. * FileMaker Pro to Access Improvement - This release fixes an issue in which Access database forms/reports didn't have the MyForm.RecordSource or MyReport.RecordSource value assigned with the table name after the 1st form. Documentation Improvements - The quick reference instructions text at the left side of the Migration Process window has been improved to match the actual conversion process for Table Consolidation and all other conversion projects. Availability: The AI Accelerated Edition of FmPro Migrator is available immediately, and includes up to 500K daily AI processing tokens and the conversion of up to 500 forms/reports/layouts into GUI conversion projects. [Token counts are unlimited when using Ollama hosted models with FmPro Migrator Custom DEV Edition.] Founded in 1999 by David Simpson in Sunny California, .com Solutions Inc. develops multi-platform graphical applications supporting FileMaker Pro, Visual FoxPro, SQLite, Oracle, MySQL, Access, SQL Server, Sybase, DB2, PostgreSQL, VB6 and LiveCode developers. VFP Code Converter, converts FoxPro scripts into 50+ modern programming languages. FmPro Script Diff, compares FileMaker Pro scripts. SQLite Diff compares SQLite database schema and data. Copyright (C) 1999-2024 .com Solutions Inc. All Rights Reserved. FileMaker is a registered trademark of FileMaker, Inc. - An Apple Subsidiary. Apple, the Apple logo and macOS platforms are trademarks of Apple Inc. in the U.S. and/or other countries.

Readers of this post may be interested to know that the AI Accelerated version of FmPro Migrator Platinum Edition 10.01 now converts Microsoft Access VBA code into FileMaker scripts. These converted scripts are close to being runnable code but will still require further development since they are intended to be used as a template for the finished script. This is a significant improvement over the previous functionality in which FmPro Migrator would only copy the original commented VBA scripts into the new FileMaker database file. The text returned by the AI model is rendered as commented text copied via the clipboard into the Script Workspace from the Code Conversion Workbench window. This means that each script step will need to be created in the Script Workspace in the usual manner. Text from the AI generated script can easily be copied and pasted into calculation dialogs instead requiring manual typing. AI produced hallucinations are kept to a minium thru the use of system messages and the configuration of various parameters sent to the models. But it can still occur. For instance, I notice that the AI models sometimes make up FileMaker Get() functions which they wish existed, but don't really exist! On the other hand, I have also seen the AI models create custom function code, and then run that code directly afterward. In this example, it didn't document that a custom function was being defined as in-line code, but as experienced developers we would recognize it as such. More info is available on the FmPro Migrator website: https://www.fmpromigrator.com/services/access_to_fmpro_service.html

2-16-2022 - Fremont, California - .com Solutions Inc. announces the availability of FmPro Migrator Server App Builder. This next generation of the FmPro Migrator product line builds single-user and multi-user runtimes from FileMaker Pro 19 databases. With this new SaaS option, we will move your FileMaker Pro database to standard SQL database servers [including MySQL, Oracle, SQL Server, PostgreSQL], but keep your editable file within FileMaker Pro. Benefit from the ease of use of FileMaker, with the robustness and scalability of a SQL database back-end. Your database will be migrated to SQL in a 90% automated process, saving you vast sums of money in redevelopment costs. After migration, any customization you need will be made by our highly experienced team. You will receive a working end user client app that connects seamlessly to the new back-end, plus the technology to rebuild the app whenever you need to apply edits from your FileMaker UI. Features: * New SaaS offering * On premise and custom options also available. * Fully customizable. * Online and offline mobile application sync features. * Fully automated rebuilds from your FileMaker solution after the initial build. * Scale to thousands of users easily. * Transfer data from FileMaker Pro files into SQL databases. * Automated application updater included with each standalone. * Apps available for multiple platforms and devices. * Use FileMaker Pro to create and edit the UI, scripts, relationship graph and tables. * Saves thousands of dollars and years of manual application development work. Description FmPro Migrator Server App Builder enables FileMaker Pro developers to build cross-platform, highly scalable SQL database applications from complex solution files. Each app incorporates the GUI and business logic copied over from the original FileMaker database file. Data from the original FileMaker solution is transferred over to the SQL database for immediate use within the new app. How it Works Drag & Drop your FileMaker database onto FmPro Migrator Server App Builder, the metadata from within the file will be automatically read and built into a new application for the platform of your choice. Within minutes, you will have a new application running on your desktop ready for testing. 4 Key Reasons It's Hard to Manually Re-Develop FileMaker Solutions 1.) FileMaker Pro databases are feature-rich closed source binary files. 2.) The DDR XML and Save as XML exports are incomplete. 3.) Obtaining metadata outside of the XML files is the only way to obtain enough info about the database. 4.) The Claris engineering team uses Agile software development principles, providing frequent feature enhancements. 3-Tier Application Deployment Each application built by FmPro Migrator Server App Builder uses a secure REST API connection thru a web/application server to connect to the SQL database server. Users only connect with the server when needed, reducing server load and increasing the number of concurrent users which can be processed by the server. Another benefit to this implementation method is that both desktop and mobile applications also include an online/offline sync feature. Data is cached locally during offline usage and is then synced with the server once the connection is restored. Scale-up FileMaker Solutions to Cloud Hosted Database Servers If you’re reaching the limits with FileMaker Pro but don’t want to redevelop your solution completely, this is the service you need. Reduce the risk of redevelopment and achieve the scalability you are looking for. Significantly reduce your ongoing licensing costs for multi-user databases, with a fixed-price unlimited distribution runtime option available. Multi-tenant solutions can be easily implemented by using separate databases on the SQL database server for each customer. Pricing There are different pricing models used for this SaaS service, tailored to your business needs. Standalone runtimes can be distributed to an unlimited number of users for a fixed price. Single-user runtime apps run on desktop or mobile platforms, and store their data locally on the computer or device. Multi-user SQL database apps run on desktop or mobile devices and connect to open-source or commercial SQL database servers. Multi-user apps include online/offline sync capability, and are licensed on a per-user basis at a significant discount compared with Claris licensing or manually rewriting the solution. Price protection is available so you can grow your business over time. Pricing There are different pricing models used for this SaaS service, tailored to your business needs. Standalone runtimes can be distributed to an unlimited number of users for a fixed price. Single-user runtime apps run on desktop or mobile platforms, and store their data locally on the computer or device. Multi-user SQL database apps run on desktop or mobile devices and connect to open-source or commercial SQL database servers. Multi-user apps include online/offline sync capability, and are licensed on a per-user basis at a significant discount compared with traditional licensing or manually rewriting the solution. Price protection is available so you can grow your business over time. Screenshots of Converted Solutions The converted FileMaker solutions on the website were converted with a 96% - 98% conversion rate as fully functional applications. One solution was converted from Microsoft Access to FileMaker, and was redeveloped within FileMaker. The FM Starting Point database is the latest release of the popular CRM solution developed by Richard Carlton Consulting (with over 700K downloads). Each project is customized to the needs of the FileMaker developer. Open a chat session via the web page or send an email via the Contact form if you have questions. Founded in 1999 by David Simpson in Sunny California, .com Solutions Inc. develops multi-platform graphical applications supporting FileMaker Pro, SQLite, Oracle, MySQL, Access, SQL Server, Sybase, DB2, PostgreSQL, VB6, LiveCode and Visual FoxPro developers. FmPro Script Diff, compares and edits FileMaker Pro scripts. SQLite Diff compares SQLite database schema and data. Copyright (C) 1999-2022 .com Solutions Inc. All Rights Reserved. FileMaker is a registered trademark of Claris International, Inc. - an Apple company. Apple, the Apple logo and macOS platforms are trademarks of Apple Inc. in the U.S. and/or other countries.

10-13-2021 - Fremont, California - .com Solutions Inc. announces the $0 4th quarter promo for FmPro Migrator Platinum Edition. Normally available for $600 (annually), there are no financial hassles or approvals in order to get started. Now is a good time to restart previously stalled conversion projects, in order to save money going into the 2022 calendar year. How does it make business sense to offer a $0 fully functional version of FmPro Migrator? Good question. It simply makes good business sense, for the following reasons: * New Subscriptions - FmPro Migrator is provided as a service (monthly or annual), just like Adobe or Microsoft Office 365 software. Many customers have multiple projects requiring conversion. Giving customers a way to get started for $0 simply makes good business sense for everyone. There are no financial hassles or approvals in order to get started, and customers may continue using the software as long as they require. * Save Money - Customers who have a small project, can convert their project at $0 cost, and then cancel, and this is fine too. Larger projects may take more time, so your first month is free. * Consulting - A small percentage of customers who get started using FmPro Migrator will request consulting assistance. These consulting projects can take many forms. Sometimes it is a small "Getting Started" type of project. Or maybe the customer need new features added to FmPro Migrator for their project. And occasionally a customer might have a huge project and need assistance building a full turn-key application. * Process Confidential Files Locally - Unlike the demo version, the full featured version of FmPro Migrator processes all fields, forms/layouts and scripts of your project on your local desktop. Converting Large Projects Amazing as it may seem, there is no limit to the number of layouts/forms/reports which can be converted by the $0 fully functional version of FmPro Migrator. By default, a Qty = 1 license will convert 250 layouts/forms/reports in any project. But what if you need to convert 1500 VFP forms/reports or FileMaker layouts? In that case, just enter in Qty = 6 on the order form for an initial order cost of $0, and the license keys will be generated automatically for this quantity. Remember, there is no limit to the number of projects or the number of times you can run a conversion for each project with FmPro Migrator while the license is valid. Open a chat session via the order page link if you have questions. Pricing and Availability: FmPro Migrator Platinum Edition is normally available for $99 (monthly), $600 (annually), $1200 (annual - 500 forms/layouts), or $10,000 (perpetual license - unlimited users). For a limited time, as part of this limited time promotion FmPro Migrator is available for $0 (1 month) and is available immediately. Founded in 1999 by David Simpson in Sunny California, .com Solutions Inc. develops multi-platform graphical applications supporting FileMaker Pro, SQLite, Oracle, MySQL, Access, SQL Server, Sybase, DB2, PostgreSQL, VB6, LiveCode and Visual FoxPro developers. FmPro Script Diff, compares and edits FileMaker Pro scripts. SQLite Diff compares SQLite database schema and data. Copyright (C) 1999-2021 .com Solutions Inc. All Rights Reserved. FileMaker is a registered trademark of Claris International, Inc. - an Apple company. Apple, the Apple logo and macOS platforms are trademarks of Apple Inc. in the U.S. and/or other countries.

.com Solutions Inc. announces the addition of a new MySQL to FileMaker Pro conversion feature within FmPro Migrator. MySQL is one of the most popular database platforms in use today. FileMaker Pro is widely recognized for being the leading low-code database development platform. FmPro Migrator brings these two database platforms together by offering bi-directional schema and data transfers between them. FileMaker Pro developers can help companies skip IT scheduling bottlenecks by moving SQL database apps into FileMaker Pro solutions. FmPro Migrator uses an automated 3-step process to migrate MySQL tables and data into a local copy of FileMaker Pro running on your desktop. Once completed, the FileMaker Pro database is ready to serve as the starting point for building or enhancing FileMaker Pro solutions. Using the FileMaker Pro development platform, previously online only MySQL databases can now be used in offline desktop and mobile apps. FileMaker Pro solutions running on desktop and mobile platforms enable users to edit data locally and sync to the server once the internet connection has been restored. FileMaker Pro solutions deployed to macOS, Windows, IOS or Android devices using LiveCode for FM include built-in support for offline sync to FileMaker Server using the data API. FmPro Migrator connects to MySQL and FileMaker databases using UTF-8 encoding in order to insure that all characters are transferred accurately between databases. Alternate data transfer methods might not retain all character encoding. FmPro Migrator saves money and reduces errors by avoiding manual data entry of large data sets. Pricing and Availability: For a limited time, as part of the MySQL to FmPro feature introduction, FmPro Migrator (including Developer Edition and Platinum Edition features) is available for a 50% discount ($49.50) and is available immediately. Order Link For More Info: https://www.fmpromigrator.com/services/sql_to_fmpro.html

I sent a press release recently, showing how one of my customers solved a FileMaker file corruption problem using FmPro Migrator. Quote from Gordon Cox, Enrich: "With a corruption in the main file we were faced with rebuilding 40 tables, 306 TOs, 159 layouts and 463 scripts. FmPro Migrator to the rescue and a few hours later we have a new, not corrupt, file saving us at least a weeks work. FmPro Migrator has saved the day." FmPro Migrator has the ability to rebuild FileMaker files as part of the Table Consolidation feature. On macOS, FmPro Migrator uses AppleScript GUI automation to automate the processing of hundreds or even thousands of FileMaker objects per hour. Using macOS is the preferred platform to use for database rebuild and Table Consolidation projects. FmPro Migrator is fully functional on macOS Big Sur running on Apple Silicon hardware. Performance testing of FmPro Migrator AppleScript GUI automation includes the following results: 5100 per hour - TOs Creation 616 per hour - Relationship Creation thousands in minutes - - Custom Function Creation [Clipboard copy & paste] thousands in minutes - Value List Creation [Clipboard copy & paste] 401 per hour - Layout Importing 401 per hour - Layout Creation - Pass #1 thousands in minutes - - Script Creation [Clipboard copy & paste] 870 per hour - Layout Creation - Pass #2 (Replacing contents of existing layouts, to resolve dependencies between layouts and scripts) Of course there are limitations with this process, and some file corruption situations might not be fixable. But if you would like to know more, you can view the FmPro Migrator website, and contact me via my website (email or online chat). FmPro Migrator - Database Rebuild - Table Consolidation Feature FmPro Migrator - Purchase Link

Fremont, California - .com Solutions Inc. today is pleased to announce the release of FmPro Migrator Platinum Edition 9.13 with support for automated Microsoft Access to FileMaker Pro 19 migrations. FmPro Migrator Platinum Edition 9.13 enhances the Access to FileMaker 19 conversion feature in the following ways: * Relationships are created more accurately during the conversion process because all table/fields are now converted to be SQL compliant. * Table occurrences are also standardized to use SQL compliant table/field names so that they get created correctly. The menu allowing manual selection of a TO base table now displays the converted base table names. * The list of TOs displayed on the Layouts tab now uses the converted TO names when updating layout TO names manually. * When performing an Access to FileMaker data transfer, the completion status now displays correctly after it has completed. * On macOS and Windows support has been added for creating layouts with FileMaker Pro 19.1.2 by changing the process which deletes layout parts before pasting the layout contents via the clipboard. Converting legacy Microsoft Access databases to FileMaker 16 offers many advantages including: * Cross platform compatibility: FileMaker solutions run directly on macOS, Windows and IOS devices. WebDirect serves FileMaker custom apps to all mobile and desktop platforms running a supported web browser. Access can only run on the Microsoft Windows operating system. * Easier database sharing: FileMaker database files can be shared using FileMaker Server or FileMaker Cloud with macOS, Windows and IOS devices. WebDirect serves FileMaker database files to any device or platform using any supported web browser. * Improved reliability: Access database files require frequent maintenance to "compact and repair" the database. Sharing Access files on a network file share typically results in file corruption. FileMaker solutions don't have any of these problems and file sharing is reliably supported from within the FileMaker application for peer to peer sharing or via FileMaker Server or FileMaker Cloud on AWS. * Greatly enhanced file capacity: FileMaker supports a 7TB filesize compared with the anemic 2GB Access filesize limit. If the Access database file ever exceeds the 2GB file size limit, it will immediately become corrupted. * Easier Development: Upgrading to FileMaker Pro 19 also offers developers the opportunity to take advantage of the latest design, development and security features included with FileMaker Pro 19 and FileMaker Server 19 and FileMaker Cloud including WebDirect capacity enhancements. Links: FmPro Migrator Platinum Edition 9.13 https://www.fmpromigrator.com/products/fmpro_migrator/index.html Access to FileMaker Migration Feature https://www.fmpromigrator.com/services/access_to_fmpro_service.html Download FmPro Migrator https://www.fmpromigrator.com/downloads/demo_software/index.html#fmpro_migrator_demo Purchase https://sites.fastspring.com/fmpromigrator/instant/fmpromigratorplat_year_sub_fs1

2-11-2009 - Fremont, CA - .com Solutions Inc. Enhances FmPro Migrator Developer Edition 4.63 With Support for Migrating Value Lists and Custom Functions. FmPro Migrator Developer Edition 4.63 from .com Solutions Inc. has been enhanced with support for copying Custom Functions and Value Lists between FileMaker Pro Advanced database files when performing Table Consolidation projects. FmPro Migrator Developer Edition makes it possible for developers to save many hours of manual labor by automating the copying of Tables, Fields, Relationships, TOs, Value Lists, Custom Functions, Layouts and Scripts between FileMaker Pro Advanced database files. FmPro Migrator Developer Edition utilizes QuicKeys(MacOSX)/WinAutomation(Windows) shortcuts to drive the FileMaker Pro Advanced graphical interface to build the objects in the consolidated destination database file. Automated re-mapping of TOs is performed within each script and layout object. Script and layout dependencies are resolved during the automated two-pass processing of scripts and layouts. FmPro Migrator Developer Edition creates both static and dynamic Value Lists, with the custom values automatically filled in for static Value Lists. Dynamic Value Lists are created as placeholders for further manual customization by the developer. Static value list items and Custom Function code can also be edited within FmPro Migrator Developer Edition after being imported from the FileMaker DDR XML file. FmPro Migrator Developer Edition 4.63 also includes cosmetic improvements to the FileMaker Pro layouts generated from Bento 2.x files, including the display of media fields, file list, IM list and URL list portal fields. This release also fixes an issue involving the conversion of FileMaker Pro relationships to SQL databases, with specific corrections within the Oracle relationships SQL code. FmPro Migrator Developer Edition is priced at ($200) per developer and includes a copy of FmPro Migrator Developer Edition for both MacOS X (Universal Binary) and Windows platforms. Existing FmPro Migrator Developer Edition customers may upgrade to FmPro Migrator Developer Edition 4.63 at no charge. A functional demo version of FmPro Migrator Developer Edition may be downloaded from http://www.fmpromigrator.com/downloads/demo_software/index.html#fmpro_migrator_demo For more info please see: http://www.fmpromigator.com/products/fmpro_migrator About .com Solutions Inc. .com Solutions Inc. develops multi-platform graphical applications supporting FileMaker Pro, Bento, SQLite, Oracle, MySQL, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, Valentina and Revolution developers. FmPro Script Diff, compares and edits FileMaker Pro scripts. FmPro Migrator ( www.fmpromigrator.com ) converts FileMaker Pro databases to and from FileMaker Pro, SQLite Diff ( www.sqlitediff.com) compares SQLite database schema and data.

FmPro Migrator 4.0 Developer Edition will be demonstrated and available immediately as a Preview version at the .com Solutions Inc. FileMaker Pavilion (Booth S-1235) during MacWorld Expo 2008. FmPro Migrator Developer Edition's new graphical interface includes an automated table consolidation feature. This table consolidation feature implements the automated batch capture and creation of Tables/Fields, Table Occurrences, Relationships, Layouts and ScriptMaker™ Scripts using FileMaker Pro Advanced 8, 8.5 and 9 databases. The global Search & Replace of layout text objects is also included. Existing customers of FmPro Migrator EE, can upgrade for $100. Videos of the table consolidation process are available on the .com Solutions website: http://www.fmpromigrator.com/news/fmpro_migrator/01142008fmpro_migrator_developer40preview.html

FmPro Worksheet 1.01 from .com Solutions Inc. is a free graphical utility for sending SQL commands to FileMaker 7 databases. FmPro Worksheet enables FileMaker 7 database developers to use libraries of SQL commands to speed development of FileMaker 7 solutions. FileMaker 7 developers can utilize all SQL commands supported by the FileMaker 7 database including CREATE TABLE, DROP TABLE, SELECT, INSERT, UPDATE and DELETE. FmPro Worksheet can be downloaded from: http://www.fmpromigrator.com/downloads/demo_software/index.html#download_fmpro_worksheet

FmPro Migrator also offers a table consolidation feature for FileMaker 7: www.fmpromigrator.com

.com Solutions Inc. has updated its FileMaker 7 AppleScript Reference with a new FileMaker 7 version of the file (16K download file), in addition to the PDF version. The guide provides a side by side quick reference for commonly used FileMaker 6 and FileMaker 7 AppleScript code examples. Each code example is stored within a FileMaker 7 database field for easy copying to the MacOS X Script Editor. These updated files may be downloaded from: FileMaker 7 AppleScript Reference - download (16K)

.com Solutions Inc. has released FmPro Migrator 1.97 Enterprise Edition with a new FileMaker to PostgreSQL migration feature. Images within FileMaker container fields are automatically migrated to PostgreSQL 'lo' (large object type) columns. Improvements have also been made to the existing FileMaker 7 table consolidation feature. The latest demo version of FmPro Migrator is now fully functional for a limited number of database fields, enabling potential customers to fully test FmPro Migrator features. For more info and a free demo, please visit: www.fmpromigrator.com FileMaker Version: 7 Platform: Mac OS X Panther

FmPro Migrator will also perform this table consolidation task: www.fmpromigrator.com/downloads/demo_software/index.html#fmpro_migrator_demo

The .com Solutions Inc. AppleScript scripting language guide provides a side by side quick reference for commonly used FileMaker 6 and FileMaker 7 AppleScript code examples. This FileMaker 7 AppleScript Reference is intended to aid developers who need to migrate existing FileMaker AppleScript code to work with the new relational model incorporated within FileMaker 7. This reference highlights differences in commands and returned values between differing versions of FileMaker, including returned values for field types and calculation formulas. I have attached the current version of the .com Solutions Inc. FileMaker 7 AppleScript Reference, for updated versions please visit: www.fmpromigrator.com - downloads FileMaker Version: 7 Platform: Mac OS X Jaguar filemaker7_applescript_reference01.pdf

A new version of FmPro Migrator has been relased for MacOS X, which also offers a table consolidation feature for FileMaker Pro 7 and FileMaker Developer 7 databases. (Last week, a Windows version of FmPro Migrator was released with this table consolidation feature and an Access to FileMaker 7 migration feature.) David Simpson www.fmpromigrator.com

FmPro Migrator quickly and accurately migrates FileMaker Pro database structure and data to Oracle and MySQL. -- Migrates CSV files to Oracle and MySQL -- Migrates TAB delimited files to Oracle and MySQL -- Host FileMaker Pro databases at any ISP supporting MySQL -- Documents FileMaker Pro database structure -- Migration of large text fields and image data to Oracle -- Processing of up to 50 open FileMaker Pro databases -- Supports FileMaker Pro stand-alone solutions files FmPro Migrator can utilize CSV or TAB delimited export files to migrate relatively small datasets from FileMaker Pro. FileMaker Pro database fields containing more than 4000 characters of text are migrated to Oracle CLOB columns - supporting up to 4 billion characters per field (or MySQL TEXT columns supporting 65000 characters). JPEG Image data within FileMaker Pro container fields is migrated directly to Oracle BLOB columns or MySQL LongBLOB columns through a network connection. No manual data entry is required for processing either of these specialized datatypes. Migration scripts and database structure reports may also be generated for stand-alone FileMaker Pro solution applications compiled for the MacOS platform. Migration scripts and documentation files are generated for all open FileMaker Pro database files. This feature can be utilized to quickly produce documentation of database structure for large numbers of existing FileMaker Pro solutions. FmPro Migrator utilizes specialized features of MacOS X, therefore it is available only for MacOS X. For more info please see: http://www.dotcomsolutionsinc.net/products/fmpro_migrator/index.html A free demo version of FmPro Migrator may be downloaded from http://www.dotcomsolutionsinc.net/downloads/index.html

FmPro Migrator quickly and accurately migrates FileMaker Pro database structure and data to Oracle. FmPro Migrator Lite Edition: -- Migrates CSV files to Oracle -- Migrates TAB delimited files to Oracle -- Documents FileMaker Pro database structure FmPro Migrator STD Edition adds the following features: -- Migration of large text fields and image data to Oracle -- Processing of up to 50 open FileMaker Pro databases -- Supports FileMaker Pro stand-alone solutions files FmPro Migrator Lite Edition utilizes CSV or TAB delimited export files to migrate relatively small datasets from FileMaker Pro. The Lite edition is perfect for FileMaker developers who may just want to generate database structure reports for a few existing FileMaker Pro databases. FmPro Migrator STD Edition features: Migration of large text fields and image data to Oracle - FileMaker Pro database fields containing more than 4000 characters of text are migrated to Oracle CLOB columns - supporting up to 4 billion characters per field. Image data within FileMaker Pro container fields is migrated directly to Oracle BLOB columns through a network connection. No manual data entry is required for processing either of these specialized datatypes. Support for specifying stand-alone FileMaker Pro solutions files - Migration scripts and database structure reports may also be generated for stand-alone FileMaker Pro solution applications compiled for the MacOS platform. Processing of up to 50 open FileMaker Pro databases - Migration scripts and documentation files are generated for all open FileMaker Pro database files. This feature can be utilized to quickly produce documentation of database structure for large numbers of existing FileMaker Pro solutions. FmPro Migrator utilizes specialized features of MacOS X, therefore it is available only for MacOS X. A free demo version of FmPro Migrator may be downloaded from http://www.dotcomsolutionsinc.net/downloads/index.html. For more info, please see: http://www.dotcomsolutionsinc.net/products/fmpro_migrator/index.html David Simpson .com Solutions Inc. www.dotcomsolutionsinc.net

Is there a way to retreive the auto-enter and validation settings for a field via Applescript? I have been able to retreive field names, IDs and most other field parameters like access, protection, repeating status - but I don't see how to get this additional info. David Simpson