DiversityTaxonNames
DiversityTaxonNames (DTN) is an application component of the database framework Diversity Workbench. It might be installed as part of a DWB environment, but also be used as a stand-alone application, e. g., in a local installation. Each DWB module is devoted to a specific data domain.
DiversityTaxonNames is focused on the management of taxon names. Next to nomenclatural information on zoological, botanical, mycological, palaeontological, bacteriological taxon names like typification with type specimens, homotypic synonyms, basionyms, protologues and references according to the rules of the respective International Codes, it is designed to document taxonomic information. This includes accepted names (current names), heterotypic synonyms, name concepts and classifications as well as the history of changing taxonomic relations. Type specimens might be linked from the module DiversityCollection. DTN is also used to organise common names in various languages and national as well as regional taxon checklists with information on red list status and other taxon-based (ecological and nature conservation) parameters. The data managed in DiversityTaxonNames are directly connected to taxon names. Data of other realms like, e. g., specimens and observations, references, media data are handled in separate modules. For an overview of the available modules see the Diversity Workbench Main Page.
DiversityTaxonNames installations build the database backbone for the DTN REST Web service for Regionalised and Domain-specific Taxon Lists.
Software for .Net Framework 4.8
Online manual
The manual is provided as pdf file (for current version check DWB user manuals). The compiled help file in CHM (= MS online help format) is included in the zip archive with the download of the client application.
Client application
Current version
The client application is built for Microsoft .Net Framework 4.8.
New features and fixes:
- Resources for user placed outside program directory
- 3 Options to places resources: Home, Documents, User defined
Alternative download (If you do not have administrator rights on your computer or want to use different application versions in parallel.)
Previous versions
The client applications are built for Microsoft .Net Framework 4.8.
Database
The database is built for Microsoft SQL Server 2014. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft SQL Server).
- Download the Database 2.5.29 (zip archive)
Each client version will check internally for the actual compatible database version und update the version formerly installed to this version (rights as dbo needed!).
Database server
- Download the SQL Server (see General Download Notes)
Software for .Net Framework 3.5
Online manual
The manual is provided as pdf file (for current version check DWB user manuals). The compiled help file in CHM (= MS online help format) is included in the zip archive with the download of the client application.
Client application
Current version
The client application is built for Microsoft .Net Framework 3.5 or higher. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft .Net Framework).
New features and fixes:
- Enabling access to external datasources for users with read only access
- Query for names in same modul according to list, hierarchy and/or synonymy included
- Creation type available in query
- Search for linked specimen redesigned with optional start of application DiversityCollection
- Search for linked descriptions with optional start of application DiversityDescriptions
- Setting timeout
- Update of hierarchy cache
- Maintenance
- Removal of self-referred synomyms
- Ignoring of self-referred synomyms
- Inspection of self-referred synomyms in main form
- Access to reference list of MelNames and Goeverts removed
- Final regular version for DWB .NET 3.5.
- Download the .Net framework (see General Download Notes)
Previous versions
The client applications are built for Microsoft .Net Framework 3.5 or higher. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft .Net Framework).
New features and fixes:
- Adaption to monitor resolution
- Button for refreshing hierarchy cache
- Menu settings according to connection
- Spreadsheet: several bugfixes
- Opening URL for external data sources in default browser
- Import wizard: Ignore but keep for reference included
- Bugfix Maintenance
- Optional encryption of SQL server connection (activated by default)
New features and fixes:
- Privacy consent - bugfix and button for setting the consent in login administration
- Bugfix Maintenance - Open duplicates in main form
- Correct version
- Marking withholding reason with colored background
New features and fixes:
- Adding analysis - Bugfix
- Display of analysis value description - Bugfix
- Marking of duplicates in main form
- Detection of duplicates in maintenace
- Deleting entries in analysis - Bugfix
- Setting parent of analysis - Bugfix
- Showing description of analysis - Bugfix
- Editing notes of analysis category - Bugfix
- Display of analysis entries sorted
- Table editor for analysis
- Export wizard for analysis
- Table editor - bugfix including screenshot in feedback
- Login according to EU-DSGVO
Database updates
- Version 02.05.29: UserProxy - Add ID, PrivacyConsent and PrivacyConsentDate, Trigger for setting PrivacyConsentDate - according to EU-DSGVO; Function providing the ID of the user from UserProxy; Function providing the name of the user from UserProxy; Function PrivacyConsentInfo providing common information within the DiversityWorkbench
New features and fixes:
- Display of analysis value description - Bugfix
Database updates
- Update to database version 02.05.28: Functions TaxonNameCache and TaxonNameCacheSinAut
New features and fixes:
- References
- Import wizard: References included, bugfix for update
- Replication of analysis: Bugfix
- Changing IsRecombination - bugfix for zoological names
- Display of infrageneric epithet - bugfix for zoological names
- Display of analysis values description
- Resources directory
- Setting timeout for database
- Copy of analysis includes values
- Import of tax. names: Insert year in BasionymAuthorsYear for recombinations in Zoology
- Disable list user to edit names included in inaccessible lists
- Archive: Create and restore archives for projects and reset of the database
- Inspection of DiversityCollection for linked Taxa
Database updates
- Update to database version 02.05.25: TaxonNameReference, TaxonomicRank agg.
- Update to database version 02.05.26: TaxonNameListReference: TaxonNameListRefText -> 800, AnalysisCategoryHierarchyAll: Ensure that there are any entries that are parents, TaxonNameExternalDatabase: ExternalDatabaseName -> 800; TaxonNameReference: TaxonNameRefText -> 800; NonClusteredIndexTaxonNameListProjectID for TaxonNameList; NonClusteredIndexTaxonHierarchyHierarchyListCache for TaxonHierarchy; New columns ReferenceTitle, ReferenceURI in TaxonNameListAnalysisCategory, TaxonNameListAnalysisCategoryChildNodes and TaxonNameListAnalysisCategoryHierarchy
- Update to database version 02.05.27: Removing dependency of TaxonNameListProjectProxy from ProjectProxy; trgUpdTaxonName: for Zoology do not rely on empty Comb.aut. for Recombination; trgInsTaxonName: TaxonNameCache from function TaxonNameCache and replenish BasionymAuthorsYear; AnalysisValue -> nvarchar(MAX)
New features and fixes:
- Import wizard: Bugfix importing analysis
- Insert of hierarchy after setting of genus
- Selection of Genus restricted to selected project
- Dropdownlist for selection of hierarchy expanded by rank and project
- BasionymAuthorsYear and CombiningAuthors available for zoological names
- References for synonyms and accepted names linked to DiversityReferences
- Changed display for synonyms and accepted names esp. for ignored data
- Query for reference for synonyms - bugfix
- Form and menu accessibility for read only access - Bugfix
- Database Updates
- Update to database version 02.05.23: Adding BasionymAuthorsYear to table TaxonName (+ log, Trigger), Transfer of YearOfPubl into BasionymAuthorsYear for recombinations of zoological names
- Update to database version 02.05.24: HierarchyCache - Bugfix
New features and fixes:
- Bugfix creating new entries
- Row filter for export wizard
- Bugfix in Query for display of IDs
- Bugfix for display of ignored accepted names and synonyms
- Bugfix for hierarchy tree
- Bugfix for history
- Analysis - Button for setting and removing superior analysis
- Analysis - Bugtolerant functions for building hierarchies
- New entries - ensure selection of list for users with restriction to lists
- Show external URI in separate window (if valid)
- Database Updates
- Update to database version 02.05.19: Adding views for linked server
- Update to database version 02.05.20: Synonymy overview - bugfix for isonyms
- Update to database version 02.05.21: Synonymy overview - bugfix for isonyms
- Update to database version 02.05.22: TaxonNameList - Grant delete to editor, update for bugtolerance for functions TaxonNameListAnalysisCategoryChildNodes and TaxonNameListAnalysisCategoryHierarchy
New features and fixes:
- View taxa in table: Extension with external data, IDs etc.
- Hierarchy cache: Maintenance providing update for whole database
- Export wizard: Exporting data with user defined configuration
- Query: Hierarchy added
- Download of TaxonLists from DiversityProjects: Bugfix
- History: Tables for external data and resources added
- User administration: Overview of role permissions added
- Hierarchy: Showing direct inferior taxa in tree
- Feedback: Extended by priority, date and topic
- Import wizard: Bugfix for calulation transformations stored in schema
- Concept names: Concept suffix does not remove authors any more
- Import: Bugfix
- Update to database version 02.05.16: procedure for update of hierarchy cache, function TaxonListLastUpdate, procTaxonNameInsertNew_2 (including NomenclaturalCode), removing dispensable Reference columns from 2 tables
- Update to database version 02.05.17: changing ssp. to subsp., Optimizing function HierarchyCache, Updating trgUpdTaxonName in table TaxonName, new function AnalysisCategoryHierarchyAll()
- Update to database version 02.05.18: changing key of table TaxonNameListDistribution to enable not Gazetteer related entries
New features and fixes:
- List view: Extension with external data, IDs etc.
- Hierarchy cache: Maintenance providing update for whole database
- Export wizard: Exporting data with user defined configuration
- Query: Hierarchy added
- Download of TaxonLists from DiversityProjects: Bugfix
- History: Tables for external data and resources added
- User administration: Overview of role permissions added
- Hierarchy: Showing direct inferior taxa in tree
- Feedback: Extended by priority, date and topic
- Import wizard: Bugfix for calulation transformations stored in schema
- Update to database version 02.05.16: procedure for update of hierarchy cache, function TaxonListLastUpdate, procTaxonNameInsertNew_2 (including NomenclaturalCode), removing dispensable Reference columns from 2 tables
New features and fixes:
- Import: Bugfixes for zoological names
- Import wizard: Import for names, hierarchy, synonyms and analysis (Beta version)
- Adding list: Bugfix
- Deleting taxonomic names
- Removing taxonomic names from a project
- Removing lists: Bugfix
- Editing display texts and taxonomic groups for lists for publication for DiversityMobile
- Administration of list users: Bugfix
- Administration of analysis categories: Bugfix
- Administration of lists: Editing the geography, Taxonomic groups
- Update to database version 02.05.15: TaxonGeography changed, Index for TaxonName, procTaxonNameInsertCopy, TaxonomicGroup in TaxonNameListProjectProxy, TaxonListsLastUpdate, TaxonListsForUser, Nomenclatural stati
New features and fixes:
- Statistics for taxon lists
- Hierarchy notes added
- Predefined queries: Bugfix
- Replication: Several bugfixes
- Database: Update to version 02.05.14 (procTaxonNameInsertCopy)
- Creation of new taxa: Bugfix
New features and fixes:
- Taxon list: Bugfix
- Maintenance: Synchronise names of projects and lists with DiversityProjects
New features and fixes:
- Hierachy: Drag & Drop with confirmation
- Predefined queries: Bugfix
- Import: Specification of the nomenclatural code (e.g. Botany, Zoology) and separation of the year of publication for zoological names
New features and fixes:
- Administration of the database: Renaming of the current database; setting of the published address (BaseURL)
The client applications are built for Microsoft .Net Framework 2.0 or higher. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft .Net Framework).
New features and fixes:
- Search for ranks including inferior ranks
- Search with unicode signs
- Drag & Drop in taxonomic hierarchy
New features and fixes:
- References in taxon lists in alphabetic order
- Ordering of query results descending and ascending
- Client software 3.0.2.6, May 27th, 2013
- Client software 3.0.1.6, April 16th, 2012
- Client software 3.0.1.2, November 08th, 2011
- Client software 3.0.0.3, January 05th, 2011
- Client software 2.2.0.9, July 22nd, 2010
- Client software 2.2.0.2, June 10th, 2010
- Client software 2.1.8.3, Juli 7th, 2009
Database
The database is built for Microsoft SQL Server 2014. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft SQL Server).
- Download the Database 02.05.14
Previous versions (SQL-Server 2008 R2)
- Download the Database 02.05.11
Database server
- Download the SQL Server (see General Download Notes)
See also DiversityTaxonNames Information Models and General Download Notes.
