Alan,

Whenever data is imported into Recorder the system creates a temporary database, copies all the data to be imported into it and validates it. It then produces the analysis details where it reports on the duplicate or invalid items. If you cancel the import at this stage no data will have been added to your system unless you are importing data via the wizard and have made new entries.

To investigate invalid items you can query the temporary database which will contain tables in the same format as in the Recorder database. Where it is stored will depend on the configuration of Windows on your system but on my laptop it is in C:\Documents and Settings\Sally Rankin\Local Settings\Temp\NBN Import. One temporary database is created for each import but they are all deleted next time you open Recorder. You could use the temporary database to produce a list of the offending taxon occurrence keys to send to Nick Hodgetts, although you say the taxon occurrence keys are partially obscured in your system, which is not the case in my system. 

My guess is that the problem has arisen due to the Recorder 3 to Recorder 2002 data transfer because in Recorder 3 a determination has just a Year of determination for the date even when the record has a more specific date.

I said:

However, I've now tried every possible setting and still cannot see the invalid taxon occurrence keys. It is frustrating because you can widen the left-hand pane in the Import Wizard for "duplicatate items" but not for "Invalid Items". It would be nice if this could be fixed sometime.

Sally - I canot find a folder with the temporary import database on my system. Do teh databases have a consistent naming pattern?

Alan

If you can find your Windows templ folder, the temporary database will be in a subfolder called NBN Import beneath there. For example, mine is in C:\Documents and Settings\johnvanbreda\Local Settings\Temp\NBN Import. They are cleaned out each time you start Recorder though.

You might notice that when you try to find this folder using Windows Explorer, that the Local Settings folder is missing. This is because its treated by the operating system as a hidden folder. In Explorer, go to Tools\Options, then select the View tab and check the option "Show hidden files and folders" to ensure it is displayed.