Topic: Taxa lost in dictionary update
The latest update to the lichen and fungi dictionaries seems to have resolved a lot of issues, and we are grateful to everyone who has put the effort in to do this.
Unfortunately it has given us a new problem as well. Until now the lichen dictionary has always included two bucket taxa, Lichen Unidentified and Lichenicolous Fungus Unidentified, which we used for records of new species that were not yet in the dictionary. After each update we could quickly go through the records for these and redetermine as many as possible to the taxa that had been added. Some stay in the bucket for a long time, pending description and publication of a new species. These two taxa seem to have disappeared from the dictionary now and I can't find any way to get at them or their records.
We seem to have two options:
a) restore the database using the backup taken before the dictionary update, and manually redetermine all the records for the bucket taxa to some other taxon that is in the new dictionary before reapplying the update.
or b) does anyone have a nifty bit of SQL that would find the hidden records are redetermine them automatically, using the updated dictionary so we don't have to roll back?
We will have to decide quickly as we are in the midst of a big data upload.
British Lichen Society