Newbies smrat 0 Posted February 17 Newbies Share Posted February 17 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
comment 1,796 Posted February 17 Share Posted February 17 (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 by comment Link to post Share on other sites
Newbies smrat 0 Posted February 17 Author Newbies Share Posted February 17 I download info from the web. It downloads everything and I want to just import the new stuff to my database. Link to post Share on other sites
comment 1,796 Posted February 17 Share Posted February 17 Why do you make me repeat my question? 1 hour ago, comment said: What determines if a record is "new"? Link to post Share on other sites
Newbies smrat 0 Posted February 17 Author Newbies Share Posted February 17 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
comment 1,796 Posted February 17 Share Posted February 17 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 smrat 0 Posted February 17 Author Newbies Share Posted February 17 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
comment 1,796 Posted February 17 Share Posted February 17 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
Newbies smrat 0 Posted February 17 Author Newbies Share Posted February 17 That did it. Thank you for your help and your patience. Link to post Share on other sites
Recommended Posts
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