Import one into the other, which now contains all the data. Duplicate that file in the Finder if you need two files.
Geoff From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Roger Adams Sent: Wednesday, July 06, 2016 12:36 AM To: [email protected] Subject: Re: Merging two FM databases Hi Jonathan, Many thanks for the prompt response. I am the designer of the database although not a professional FM designer, merely a hobbyist. Actually, both databases are the same on two different Macs with exactly the same fields but one contains data that the other does not and v.v. What I am trying to do is to get them to be exactly the same. A pity that there is not an app to merge the two. Is there an easier way to achieve this than going through the database record-by-record? Again, I do appreciate your help. Cheers Roger > On 6Jul, 2016 AD, at 11:11 AM, Jonathan Fletcher > <[email protected]<mailto:[email protected]>> wrote: > > Copy and paste? > > You can copy the tables from one file into another and have both of them in > one file. You then import the data from the external file. > > That said, if you simply want to merge the data into one table and there > aren’t any duplicates, you can simply import from one to the other. > > If however there are data points that conflict or records with duplicate data > or IDs then all bets are off, and you will need two people to complete the > task: > > 1. Someone who knows the data intimately and how exactly you want it to end up > 2. Someone who knows FileMaker pretty well > > From the wording of your question, I am assuming that you MAY be the former > and are likely not the latter. > > There will not be an “app” that will make the same decisions that your brain > would, if there is anything that actually requires a decision. (Believe me > there will be more decisions than you have already thought of. Happens every > time.) > > Jonathan > > > > >> On Jul 5, 2016, at 11:12 PM, Roger Adams >> <[email protected]<mailto:[email protected]>> wrote: >> >> Hi Folks, >> >> I am looking for am app that will merge two FM databases. Is there such an >> app and if so, I would appreciate if you could advise where and how I can >> get it. >> >> Many thanks >> >> Roger > > -- > Jonathan Fletcher > [email protected]<mailto:[email protected]> > > Kentuckiana FileMaker Developers Group > Next Meeting: 7/26/16
