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.

How to avoid importing the same file more than once?

RasMS
in Importing & Exporting

Featured Replies

  • Newbies

I am exporting files from a website in Drupal to Filemaker. Every file has a unique number. Is there a way to avoid files being imported into Filemaker more than once, if I don’t want to delete the files from the website that I’ve already imported?

I usually have a table that keeps track of the files imported. Check against that before import.

  • Author
  • Newbies

But I am not sure where and how to create a table like that?

Make the field that hold the unique number validate to be unique.

What I imagined is that after you have the filename, you'd FIND in your log table. If you don't find that file, it's OK to import. After you import, you log the import by creating a record in the log table, and of course, one field would be the filename.

Every file has a unique number.

Every file - or every record?

  • Author
  • Newbies

Every record - sorry

As Vaughan said, if you validate the ID field as 'Unique, Validate always', duplicate records will not be imported.

Again, I took him literally. Good catch, guys. File names vs record IDs...big difference.

  • Author
  • Newbies

Okay, it works. Thanks a lot

Create an account or sign in to comment

https://fmforums.com/topic/78692-how-to-avoid-importing-the-same-file-more-than-once/
Go to topic listing

Important Information

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

I accept

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.