Before importing, select Show All Records from the records menu. The import matching action matches records to those found in the current found set--not to every record in your table.
thanks for getting back to me, I had already selected show all records.
is there anything else i could have missed?
If you have all records selected and are still getting duplicate records created, they aren't being correctly matched via field mapping or the values in that match field in the imported data does not, for some reason, match the data already present in your database table.
I have matched them with email addresses, and I looked at a few samples in the data base the email addresses were exactly the same yet a new record was duplicated. I checked spaces, cases ect, would it help for me to send a screan shot of the excel spread sheet?
instead i matched them with first name and last name, although not ideal it did a better job. why is that?
What data type is specified for your email address field. Might it be specified as Number instead of text when you check it in Manage | Database | fields?
I've just checked and it's specified as text?
Either the index for your email field is damaged or there is some difference in the matching fields that you haven't spotted by inspection.
To rebuild the index of a single field:
- Open Manage | Database | Fields and double click the field
- Use either the storage tab or the storage options button to turn off indexing.
- Exit Manage | Database, then return and turn indexing back on.
You can also rebuild all your file's indexes by importing all the data into an empty copy (clone) of your file.
If you have FileMaker 11, you can use Advanced Recovery options to rebuild your file's indexes:
- With the file closed, select Recover from the File Menu.
- Select "Use advanced Options"
- Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".
cool, i've done that. I've got to update another list later so I'll try it.
Thanks for your help.