How to avoid importing the same file more than once?

[RasMS]

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?

[bcooney]

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

[RasMS]

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

[Vaughan]

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

[bcooney]

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.

[comment]

Every file has a unique number.

Every file - or every record?

[RasMS]

Every record - sorry

[comment]

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

[bcooney]

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

[RasMS]

Okay, it works. Thanks a lot