Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4796 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi again,

I have an Excel file that I import data from into my DB. One of the fields, called "SIID" has been set up in the data-base as a unique value field, with a custom message appearing if a value is entered that is not unique. It works fine if the SIID is entered right into FMP, the warning pops up "You have already entered....".

An import from Excel however does not catch this. I was able to import the same SIID 3-4 times. Any way around this?

Thanks

Posted

You could try using the 'Update matching records in found set' and the 'Add remaining data as new records' options during import. I don't think that you'll get duplicate SIID's but you will over-write the current data for any matching records.

If that's not what you want, then I think you'll need to import it all and then do something else to find and the duplicates. This could be a Find using "!" in the SIID field, or using a self join relationship based on SIID.

Posted

One of the fields, called "SIID" has been set up in the data-base as a unique value field

In the validation settings, select 'Always' instead of 'Only during data entry'.

Posted

What do you want to happen when there are duplicates?

As comment notes, you can prevent the records from importing...but you won't know which ones failed. To do that you'd have to import them into a temporary table first to see which SIIDs exist.

This topic is 4796 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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