Jump to content

David Simpson

Members
  • Posts

    14
  • Joined

  • Last visited

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    19

Platform Environment

  • OS Platform
    X-Platform
  • OS Version
    10.15

David Simpson's Achievements

Apprentice

Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. 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
  2. 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
  3. 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.
  4. 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
  5. 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
  6. FmPro Migrator also offers a table consolidation feature for FileMaker 7: www.fmpromigrator.com
  7. .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)
  8. .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
  9. FmPro Migrator will also perform this table consolidation task: www.fmpromigrator.com/downloads/demo_software/index.html#fmpro_migrator_demo
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
Ă—
Ă—
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.