Newbies smrat Posted February 17, 2021 Newbies Share Posted February 17, 2021 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 comment Share on other sites More sharing options...
comment Posted February 17, 2021 Share Posted February 17, 2021 (edited) 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 February 17, 2021 by comment Link to comment Share on other sites More sharing options...
Newbies smrat Posted February 17, 2021 Author Newbies Share Posted February 17, 2021 I download info from the web. It downloads everything and I want to just import the new stuff to my database. Link to comment Share on other sites More sharing options...
comment Posted February 17, 2021 Share Posted February 17, 2021 Why do you make me repeat my question? 1 hour ago, comment said: What determines if a record is "new"? Link to comment Share on other sites More sharing options...
Newbies smrat Posted February 17, 2021 Author Newbies Share Posted February 17, 2021 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 comment Share on other sites More sharing options...
comment Posted February 17, 2021 Share Posted February 17, 2021 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 comment Share on other sites More sharing options...
Newbies smrat Posted February 17, 2021 Author Newbies Share Posted February 17, 2021 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 comment Share on other sites More sharing options...
comment Posted February 17, 2021 Share Posted February 17, 2021 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 comment Share on other sites More sharing options...
Newbies smrat Posted February 17, 2021 Author Newbies Share Posted February 17, 2021 That did it. Thank you for your help and your patience. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1161 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 accountSign in
Already have an account? Sign in here.
Sign In Now