1 Reply Latest reply on Sep 22, 2013 9:28 AM by philmodjunk

    Easy way to import NON-EXISTING records ONLY into FileMaker



      Easy way to import NON-EXISTING records ONLY into FileMaker


      Tried to find this various ways, from internal/external FMPro help files, to the KnowledgeBase and the forums here, but it's either not present, or I didn't use the right terms.

           Current setup is that I am taking records from a huge (nearly half a million records) database from work, with the equivalent of a dozen "tables."

           At the moment I have just over 10,000 records at home in FileMaker, but I need to only update my home database, not replace all the records.  Several of the fields have been modified to deal with my personal needs (the reason why I cannot do this at work... I am not allowed to change anything there... even if the information is erroneous),  Since there is no easy way for me to tell which records in the work database do not match my home version, I cannot pre-filter the results.

           Any attempt to use the 3 basic import functions will result in destroying a large amount of corrections I have made to fields and dates, or possibly ending up with hundreds of semi-duplicated records.

           What I wish to do is have all the records from work in a text file (which is easy), but only import records that do not have a matching serial number already present in the relevant FileMaker table.

           s there a simple way to do this?  (I'd prefer something that doesn't have me modifying the structure of tables, or running long scripts, as my home file is already horrendously complex and must be duplicated at every change, just because of the hazard of messing something up unintentionally, that might not be noticed for months.

           I can actually do this using a few methods, but I am looking for a quick and simple method that will avoid errors, accidentally deleting records that are important, or leaving a mess of additional records that do not belong.  The "quick" bit is important as I may end up having to do this every week from now on.



        • 1. Re: Easy way to import NON-EXISTING records ONLY into FileMaker

               Since we don't know the structure of your "horribly complex" database, nearly anything we suggest is likely to require a change in that structure.

               Best approach that I can think of is to import all the data from your text file into a separate FileMaker table linked to your main table by the serial number field. You can then perform a find on this table of all your data to find all records in this separate table that do not have a related record in your main table. Then you can import this found set into your main table.