1 Topic by FNRCinfoassist

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 75

Topic: How do I find the missing taxon I know are in the database?

Hello, in 2012 I posted this topic:-

"I have a recurring problem when importing some records. The application crashes giving me the option to close application or restart application etc. Once it has restarted I now find that the event and the observations have been added but that there is no taxon occurrence details. If I re-import the records it works fine and I am then able to delete the phantom records. My worry is that there are some rogue records (missing taxon occurrence details) that I have previously added and thought were ok. Is there any way I can search for all the records that are missing taxon details so that I can remedy the problem?"

This probem no longer seems to happen, however, Fife now has a new Information Officer who would like to check the whole database for any samples with missing taxonomic details. Is there a tool that would allow me to list these phantom records so that measures can be taken to remedy?
Many thanks in anticipation.
Mhairi

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: How do I find the missing taxon I know are in the database?

The attached report will identify samples with no occurrences. Clicking on the sample_key will take you to the sample.

Copy the file into the reports folder of R6. The report will appear under system_supplied reports/Tools/ It is report Tools1.

If you find you have lots of samples with no occurrences  then ask for a batch update to remove them.

Post's attachments

JNCC_Tools1_Samples_No_Occs.xml 842 b, 2 downloads since 2015-08-20 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website