Jump to content

Script to import new records


Recommended Posts

  • Newbies

Using FMP 18 on iMac. I'm wanting to create a script to import only new records from one file to another. When I go through the import steps in my script it doesn't give me the option to add new or update, it just goes to the part for import order and wants to import all the records. If someone could tell me what I'm doing wrong here. . . .

Link to post
Share on other sites

What determines if a record is "new"?

On a broader scale, why do you need to do this at all? it seems very cumbersome to keep two files and constantly update  one to match the other.

 

 

Edited by comment
Link to post
Share on other sites
  • Newbies

So very sorry.

I have a database with two layouts that have the same fields but are set up differently. When I add to one, I thought it would be easier to do a script to update the other layout rather than put it in both manually every time. So I want to add new records or update or whatever so I don't have duplicate records in one of the layouts.

Wordy but hopefully it explains what I'm trying to do.

Link to post
Share on other sites
1 minute ago, smrat said:

hopefully it explains what I'm trying to do.

I am afraid not. You speak of duplicate records, but you're not saying what constitutes a duplicate. Do these records have some sort of unique ID?

 

Link to post
Share on other sites
  • Newbies

They have a unique ID. Probably (or maybe) I'm using the wrong word here. They are two databases with the same fields only arranged differently with different formats. So I want to import only the new records created in one database to the other database.

Link to post
Share on other sites

If the records have a unique ID, you can validate the unique iD field in the target table as 'Unique, Validate always'. This will prevent records with existing ID values from being imported.

 

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
  • 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.