1 Reply Latest reply on May 17, 2010 10:07 AM by philmodjunk

    Import/Update Records



      Import/Update Records


      I have three tables, Table 1, 2 and 3.  Each table has a field in it called name.  What I want to do is:  If the name in table 1 is not in Table 3, add it.  If the name is in both Table 3 and Table 2, import the value of points into table 3, if it is not in table 3, add it. 


      I hope this makes sense.  Table 1 and 2 have people's names and the points they got.  Table 3 has their name and a column for points from Table 1 and a column for points for Table 2.


      Any suggestions on making this work?

        • 1. Re: Import/Update Records

          Careful, it's very easy to get two different people with the same first and last names.


          You can do what you describe with import records, you can select two options for the same import: "update existing records in found set" and "add remaining data as new records'.


          You'd want to show all records before importing. If you use a script for this, be careful to update the import script each time you change table definitions by adding/removing fields unless you are able to import using the "matching names" option for your field mapping. (And you still may need to update to add a new pair of fields to the order.)


          Finally, make a back up copy before doing this for the first time so you can toss your files and try again if you don't like the results.


          Another option is to set up a looping script that does this one field at a time.