Craig

For Taxon_Occurrence the key should be directly releted to the MapMate key and there should  never be any duplicates.  Is it definitely taxon occurrence keys you are seeing as duplicated ?

Mike

I think I've found a pattern with the duplicates - if the second import has a different Taxon Version Key allocated it seems to duplicate - i.e. if the taxon was chosen off a different checklist

Craig

This is serious problem which undermines the whole idea behind the MapMate import, so I have spent some time looking at it over the weekend and consulted  John Van Breda.  John  says the keys are generated by referring to the temporary import  tables not the existing data so whatever it is doing it is something in the actual import file and not because you importing the data for a second time. Both John  and I have tried to duplicate the problem but with no success. I have imported 83.000 records  with as many permutations I can think of, then changed this in various ways and reimported it, but without managing to generate any duplicates. I have also run a number of specific tests  containing different fields. The only way which I can find of getting near  to creating this problem is to have duplicate  MapMate keys in the import file.  We do need to get to the bottom of this and are hoping that you can supply a  file which is actually generating duplicates so we can investigate. It probably makes no difference, but do you import from Excel or though a link with an Access table ?  If you use a link to Access  is it possible that you are using a query which is duplicating the MapMate keys in some circumstances.   

Mike

.