Jump to content
Sign in to follow this  
Sanguitch

importing/updating related records

Recommended Posts

How do you import records from Excel or from another FMPRo database and rather than have the transfer initiate new records, it would populate empty fields within records. So if I have a database of teams and need to update scores from last weeks games, how do I ensure the scores go to the right teams? I realize this is relational, but how is the relationship established during an import? Do you have to import into a related table BEFORE importing into the target table? Someone mentioned a "join table" which I am unfamiliar with (maybe that's my missing link).

Thank you!

Share this post


Link to post
Share on other sites

What tables do you have?

Let's say you have Teams and Scores. You're keeping Scores in Excel. You'll need one of your columns in Excel to contain the TeamID.

Then, you'd import the Excel worksheet into the Score table.

Share this post


Link to post
Share on other sites

There's an option during import to updating matching records, which would do the trick. Keep in mind that if you are importing data into a relational database and the information being updated exists in more than one table you would have to do multiple imports, one for each table. If you don't have sufficient information in the file being imported to match your FileMaker records then you have to do a bit of scrubbing first.

To better aid you in this, you likely will need to provide a clone of your database and a sample import file.

Share this post


Link to post
Share on other sites

Thank you for your reply. That sounds simple. Now how do you get the team ID to match the team ID's in the team table? (probably through my relationship based upon record ID). I am little weak on my relationships...but I am trying. Thanks again.

Share this post


Link to post
Share on other sites

Truly grateful for your reply. The updating of matched records makes a lot of sense to me. I will give it a try. Of course you can only match from another FMPro database to another or from table to table, at least that's what I think...

Thanks again!

Share this post


Link to post
Share on other sites

Can you confirm that you have two tables, Teams and Scores, and that they are related by TeamID.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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