Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Importing non-duplicate records only

Featured Replies

I have tried to follow the example Fenton Jones gave (http://www.fentonjones.com/Articles/10_Import_Dupes.html) for importing new records and avoiding duplicates, but the intermediate script does not make sense nor does it act as desired.

I am trying to filter out duplicates in one set of temporary records in a .fp7 database for import into another .fp7 database.

Fenton's instructions were as follows:

Find All

i.e. Show All Records in FMP 9

Go To Layout ["Concat Only"]

layout with single concatenated field of First and Last Name only

Copy All Records

Go To Layout ["Concat g"]

layout with global concatenated field

Paste [select, No style, "Concat g"]

Exit Record/Request

i.e. Commit Records in FMP 9

Go To Related Record [show, "Concat g to Concat"

GTRR in temporary database

Perform Script [External: "Transit"]

a two-step script:

Delete All Records

Find All

"The first part of the script copies the Concat field from all records, then pastes them all into one global field, Concat g, separated by returns. The last 3 steps will go to only the records in Transit that are duplicates of ones in Import, using the many-to-many relationship, then delete them all. The last step will find the remaining records, which could be imported into Import."

My trouble is at the GTRR step. Working in FMP 9, the script steps became:

Go To Related Record [show only related records; From table: "Transit"; External; Using layout: "Transit" (Transit); New window]

My script/relationship ends up finding all records in the external file instead of just the ones already in the working (Import) table (i.e. those matching any of the global field Concat g entries). As a result, even the new unique records are deleted in the last step, leaving nothing to import.

I appreciate any and all assistance. Thank you!

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.