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.

Merging multiple FM databases

gblake
in Importing & Exporting

Featured Replies

  • Newbies

Background: I am developing a Filemaker 12 database to be deployed as a runtime solution to 10 different sites:

  • On a regular basis the information from these 10 databases needs to be merged into one database
  • Some of the information (e.g. names) need to be anonymised/removed, so returning the entire database file isn't an option (I think - is it possible to save a copy of a database with the names replaced with "xxx"?).
  • The database has 12 tables
  • Each site will be running different operating systems: Mac, Windows 7, Windows XP

What is the best way to ensure that the merge is as painless as possible?

 

My preliminary thoughts are:

  • Each site does an export (spreadsheet? xml? csv?) to 12 separate files (one for each table), with names (etc) stripped out. The files get emailed to the central location
  • A program (Java or Python) processes a folder of these files and combines them into 12 master files
  • The master files get imported into the database

but I'd be happy if anyone could suggest a better way.

Have you considered hosting this on the web and using IWP to distribute the service?

 

It really would simplify life for everyone.

Don't go the runtime/merge route! Consider hosting this and either providing an FM client, IWP or using FMGo.

Create an account or sign in to comment

https://fmforums.com/topic/87777-merging-multiple-fm-databases/
Go to topic listing

Important Information

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

I accept

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.