Jump to content

Import Multiple Record Matches


This topic is 7708 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need to import multiple records into a sales database. I use the import while matching on a inique field option.

The problem is that there are multiple matches per record & I require all of this information. What happens is that Filemaker overrides the data already present with the last match - even if the fields are empty.

Link to comment
Share on other sites

quote:

Originally posted by mattc:

I need to import multiple records into a sales database. I use the import while matching on a inique field option.

The problem is that there are multiple matches per record & I require all of this information. What happens is that Filemaker overrides the data already present with the last match - even if the fields are empty.

So are you trying to ADD new records or UPDATE existing records? I do not believe that it is possible do both in the same import.

You may need to find all the matching records, use the import to update them, then import all new records.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.inthescene.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

Thanks for your reply, but I probably wasn't clear enough.

I have import mulitiple record matches (database 1) importing to just one record (database 2) & I am updating existing records matched by customer id, i.e

database 1 (3 records)

Custid

1000 sale1

Link to comment
Share on other sites

Assuming that both files are FileMaker files it can be done. The key is that you are going to have to update only one sales field at a time. You do this by performing a find in the source file. For the Sales1 field do a find for records "equal to or greater than 1". Then swith to your destination file and do your import/update, only importing/updating the field Sales1. Then repeat this procedure for each sales field. If you are going to do this on a regular basis it could be accomplished with a somewhat complex script. You might contemplate your Database Design if this is the case. Otherwise if this is a one time update do it manually and it will be done.

Adios

Link to comment
Share on other sites

This topic is 7708 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    kurucay2000 
×
×
  • Create New...

Important Information

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