Home Scripts Fixing FileMaker File Corruption Issues with FmPro Migrator – A Case Study with Gordon Cox of Enrich Computer Systems

Fixing FileMaker File Corruption Issues with FmPro Migrator – A Case Study with Gordon Cox of Enrich Computer Systems

9 min read

FmPro Migrator Desk Consolidation – Rebuild Screenshot

FmPro Migrator - The Migration Tool for FileMaker Pro, Access, Visual FoxPro

FmPro Migrator Icon

.com Options Inc. at the moment pronounces a case research concerning using FmPro Migrator to repair file corruption issues in FileMaker Professional 19 database information.

Confronted with rebuilding 40 tables, 306 TOs, 159 layouts and 463 scripts. FmPro Migrator to the rescue and some hours later we have now a brand new, not corrupt, file saving us not less than a weeks work.”

— Gordon Cox of Enrich Pc Techniques

FREMONT, CA, UNITED STATES, January 14, 2021 /EINPresswire.com/ — .com Options Inc. pronounces a profitable FileMaker database rebuild venture with Gordon Cox of Enrich Pc Techniques utilizing FmPro Migrator. In accordance with Gordon, this database file was inflicting quite a few points for the shopper, together with intermittent pauses and lockouts and was verified as requiring restoration by FileMaker’s restoration possibility. The one answer was rebuilding the file: for a system that has had lots of of hours of growth this was a very daunting job.

The automated desk consolidation function inside FmPro Migrator was used to import the metadata from the corrupted FileMaker database file and rebuild dozens of tables, lots of of TOs, scripts and over 100 layouts.

Quote from Gordon Cox, Enrich:
“With a corruption in the principle file we have been confronted with rebuilding 40 tables, 306 TOs, 159 layouts and 463 scripts. FmProMigrator to the rescue and some hours later we have now a brand new, not corrupt, file saving us not less than a weeks work. FmPro Migrator has saved the day.”

On macOS, FmPro Migrator makes use of AppleScript GUI automation to automate the processing of lots of and even hundreds of FileMaker objects per hour. Utilizing macOS is the popular platform to make use of for database rebuild and Desk Consolidation tasks. FmPro Migrator is absolutely practical on macOS Huge Sur operating on Apple Silicon {hardware}.

The usage of AppleScript GUI automation inside FmPro Migrator improves the reliability and efficiency of the automation duties,reduces price and setup necessities.

Along with database rebuild tasks, FileMaker builders also can use the Desk Consolidation course of to improve older multi-file options into simpler to keep up FileMaker Professional single file options.

Efficiency testing of FmPro Migrator AppleScript GUI automation contains the next outcomes:
5100 per hour – TOs Creation
616 per hour – Relationship Creation
hundreds in minutes – – Customized Perform Creation [Clipboard copy & paste]hundreds in minutes – Worth Record Creation [Clipboard copy & paste]401 per hour – Format Importing
401 per hour – Format Creation – Go #1
hundreds in minutes – – Script Creation [Clipboard copy & paste]870 per hour – Format Creation – Go #2 (Changing contents of current layouts, to resolve dependencies between layouts and scripts)

As a service to the FileMaker group, .com Options Inc. has launched the FileMaker automation AppleScript code as open supply software program. Along with the AppleScript supply file, a LiveCode take a look at harness stack can be offered. The take a look at harness stack contains AppleScript handler supply code embedded inside LiveCode handlers. The code is executed utilizing the LiveCode “do as AppleScript” command. The dynamic compilation of AppleScript code at runtime prevents dependencies related to a particular model of FileMaker software program, which might happen if an AppleScript app or applet had been used.
The AppleScript code and LiveCode testing stack can be found for obtain from the File menu in FmPro Migrator, and can be found within the industrial and demo variations of FmPro Migrator for gratis.

Pricing and Availability:
FmPro Migrator (together with Developer Version and Platinum Version options) is priced at ($99) per developer, and is obtainable instantly.

Based in 1999 by David Simpson in Sunny California, .com Options Inc. develops multi-platform graphical functions supporting FileMaker Professional, SQLite, Oracle, MySQL, Entry, SQL Server, Sybase, DB2, PostgreSQL, VB6, LiveCode and Visible FoxPro builders. FmPro Script Diff, compares and edits FileMaker Professional scripts. SQLite Diff compares SQLite database schema and information. Copyright (C) 1999-2021 .com Options Inc. All Rights Reserved. FileMaker is a registered trademark of FileMaker, Inc. – An Apple Subsidiary. Apple, the Apple emblem and macOS platforms are emblems of Apple Inc. within the U.S. and/or different nations.

David Simpson
.com Options Inc.
510-555-1212
e-mail us right here
Go to us on social media:
Fb
Twitter
LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Join Huawei’s #DoAnything Campaign for a chance to win PHP 50,000

MANILA, Philippines, March 3, 2021 /PRNewswire/ — Huawei Cell Providers (HMS) introd…