1

Re: Incorrect verfication status after import

I've just used the import wizard to import around 300 records which I wanted to flag as 'failed/pending verification' since I don't want to report on them.

I thought I could do this by setting the determination type to 'requires confirmation' in the import file. On the face of it, that worked fine - all the records have come into Recorder with the correct 'requires confirmation' determination type, but the verification flag is set to '0 - not verified' which means that they will be reported on.

According to the Recorder help file, a determination type of 'requires confirmation' should cause Recorder to flag the record as '1 - failed/pending verification', so what has gone wrong?

Any ideas on how I can get Recorder to update the verification flag to the correct value for this determination type? (I could try to import the records with determination type as 'invalid' - don't know if that would work, but I don't really want to mark the records as 'invalid' - the fact is that they require further work/confirmation.)

Rich

Richard Burkmar
Biodiversity Project Officer
Field Studies Council

2

Re: Incorrect verfication status after import

I have put a Batch Update at http://forums.nbn.org.uk/uploads.php?file=JNCCDATACorrection1.zip which will bring the verified indicators into line with the determination types. This also correct two other common errors in databases;  spaces in spatial references (OSGB and OSNI only ) and Null in data accuracy.

Once unzipped and copied to the User Files\Batch Updates folder you will find the update in Tools\Run Batch Updates\ Updates menu. Please make sure you back up the database before running the update and check the results.

Mike

Mike Weideli

3

Re: Incorrect verfication status after import

I hve run some tests on this and have found  that the Import Wizard is not bringing the Taxon_Occurrence verified indicator  into line with the chosen Determination type. This is a bug which will need to be fixed. In the meantime the Batch Update should be run after each import

Mike

Mike Weideli

4

Re: Incorrect verfication status after import

Thanks for your amazingly quick response and workaround advice Mike - very much appreciated.

Richard Burkmar
Biodiversity Project Officer
Field Studies Council