Re: Reporting on Common Names
We would like to trial a new approach to allocating Common Names to table Index_Taxon_Name. If you would like to help the necessary files can be downloaded from
http://forums.nbn.org.uk/uploads.php?file=RevisedCommonNameFiles.zip
SQL Mangagement Studio will be needed to implement the change. A method of reverting back to the existing approach is included.
Please unzip the files and read the text file for details on how to proceed. The changes will only affect reporting and are designed to give more consistent results for common names as well as adding common names to many more taxa. The changes are based on processing the existing data in a different way and will not correct Dictionary errors.
Once implemented the changes will reflect in normal reporting or specific reports can be run to investigate the effect on particular taxa. What we need to know is whether or not you think overall the new approach gives better results. If there are anomalies in the results please post them on the forum. If they are the result of the new approach rather than Dictionary issues then it may be possible to fine tune the queries.
Mike Weideli
Recorder 6 Consortium