Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Exporting/Importing data from all tables

Featured Replies

I have 10 different database files. They all have the same structure (tables, fields, etc), same scripts, same layouts.

But each has a different set of data.

When I update one of them (layouts, scripts, new fields, etc), I'd like to apply the updates to the other 9. What is the best way to do this? Right now I export all of the data by table and import this into a clone of the updated one. If export/import is the best way to do this, is there a faster way? Can I somehow import all of the fields from all of the tables at once from a filemaker file to another filemaker file?

Why not simply keep one file with all the data?

And even one with the UI, so that far fewer design changes are required.

You don't need to export, just import. And no, there's no master command. An import requires building a script that imports each table one at a time (and also sets the next serial_ID correctly).

Lots of posts on the forums, seach for "update."

  • Author

Why not simply keep one file with all the data?

Because they each serve a different company and I'm keeping all data totally separated.

I also don't want to wake up to one massive corrupted database and having 11ty people calling me at once.

You don't need to export, just import. And no, there's no master command. An import requires building a script that imports each table one at a time (and also sets the next serial_ID correctly).

Lots of posts on the forums, seach for "update."

Ah, so an update script. That sounds like a plan. Thanks!

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.