FMP Advanced has more complete importation tools.
But they are far from perfect.
Once a table has been imported, each Layout needs to be copied, pasted and field instances re-established.
Unless there is something I am missing.
Isn't that like trying to reverse engineer a product. When its a relatively simple import of a contact database or something more complex it would be quicker, easier and better ( because you would understand it in full) to just write your own. If one has to respec the field and the scripts ( if any) and copy and link the layouts, where is the advantage of importing a database?
There is a product FM Migrator which addresses this.
It is not cheap, but the demo can do some limited migration.
This Google illustrates that many users are puzzled by this feature not being included.
(I assume it is a data protection function, layouts can be corrupted)
You can also import the scripts though. In the Manage Scripts window, click on the little icon at the bottom towards the right that is to import scripts, and then you can select the file and select the scripts you want to import.
You can import scripts and tables.
You can copy and paste layouts.
You can copy and paste the lists of custom values in your value lists (and the value list names)
You have to recreate relationships by hand.
You have to recreate non custom value valuelists by hand.
The sequence in which you perform each step is critical to avoid extra work "reconnecting" layout elements and fixing imperfectly imported scripts.
1) import the table
2) recreate the relationships (each Table Occurrence name must exactly match what's found in the original file).
3) copy/paste and/or recreate value lists
4) copy/paste layouts (name them exactly the same as the original layouts and point them at exactly the same table occurrence name)
5) import scripts (many scripts refer to layouts and layout elements so set up the layouts first)
6) for any layouts with scripted buttons and/or script triggers, delete them and recopy/paste all over again now that you scripts are imported so that you don't have to re-connect each such button/trigger one item at a time.
7) recreate any layout based script triggers by hand.
Throughout, use FMP Adv's database design report to check for the key words "missing" and "unknown" to check for broken/missing references
Thanks for this idiots guide - just the ticket!