2 Replies Latest reply on Mar 10, 2010 1:21 AM by selfcreator

    Import to multiple tables



      Import to multiple tables


      I have a csv file that includes name, address, city, state, zip, phone, contribution amount, contribution date.


      The file fields match up with filemaker fields in tables:


      Table "Contact Info"

      name, address, city, state, zip, phone


      Related Table "Contributions"

      contribution amount, contribution date


      How do I easily upload this single csv file so that the information is imported into the appropriate filemaker fields in each table?


      Relatively new to FM, using FM10ADV/IWP/MACOSX

        • 1. Re: Import to multiple tables

          How do you link the records in your filemaker file? Hopefully, you have a serial number field that functions as your primary key.


          Is this a one time import of unique data (one line for each donor) or something that you will do over and over again with the same doners possibly being imported multiple times?


          Donors with the same name who may or may not be the same person represent you biggest challenge here.


          If this is a one time import and the same donor isn't listed more than once, you could import the data twice--once to each table and then use replace field contents to assign matching serial numbers to the newly imported records. (This works only because there is just one line per donor and the record order in both tables immediately after import will match the order in your csv file.


          If this is something you need to do repeatedly and/or a donor may be listed more than once, you'll have to design a system that matches by names in order to assign matching ID numbers and this can get messy if two of your donors happen to have the same name.



          • 2. Re: Import to multiple tables

            Import twice, once on the layout based on the first table, once on the layout based on the second table.