DiversityDescriptions
DiversityDescriptions 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, but DWB-DD is much more generic and designed following the Entity attribute value model (EAV), called also "open schema".
DiversityDescriptions is organising any kind of descriptions, descriptions of organisms, taxa and any item, element or entity, which is object of diversity or descriptive research.
- The descriptions are characterized by a triple structure, namely ’item-descriptor-state’ or ’item-descriptor-value’ or ’item-character-character state’ or ’entity-attribute-value’ or ’element-property-value’.
- The descriptors (= characters, attributes, properties) are not limited to morphological characters and functional traits, but could be physiological, ecological, behavioral and survey parameters, molecular descriptors and descriptors of data content schemes. Beside summary data, sample data as gained by ecological field sampling are addressed with own functions.
- The descriptor states or values, which build the item/description, can be generalized to one of the presently supported data types (categorical states, quantitative values and statistical measures, molecular sequence data and free-form text as a fall-back option).
DWB-DD can be used to describe traits of individual organisms, any research items/ elements/ entities/ objects (e.g. specimens, observation and measurement events, plots) as well as taxa, syntaxonomic entities (e.g. species, plant-sociological entities, ecosystems) and to organise measurement series over the time. An Introduction to DiversityDescriptions presented in 2020 is explaining some of these aspects. DWB-DD is used, e.g., for research data management in DEEMY and LIAS light. Furthermore, DiversityDescriptions is a suitable tool for conceptual schema development and schema publication in a Linked Open Data (LOD) resp. Semantic Media Wiki context as done for MOD-CO.
DiversityDescriptions is ready to manage and exchange research data organised as DELTA files, SDD XML schema files and as EML XML schema files (for schemas and standards see here). Most research data in environmental sciences are, however, organized according proprietary schemas. In these cases DWB-DD is able to generate XSD document files together with the XML data files. There are also functions on schema mapping and an ubiquitous import wizard on board.
An implementation project to connect DiversityDescriptions data pipelines to a future software application DiversityNaviKey is on the way.
Database version 3.0.10 is used as underlying data base for Quiz applications.
For download of test versions check DiversityDescriptions clients for beta testing.
Contents
Software for .Net Framework 4.8
Online manual
The manual is provided in html format with Content and Keywords, see also DWB user manuals. Earlier versions were regularly published as pdf files. They are stored under Previous versions of pdf files from 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.
Use the installer if you have administrator rights, otherwise use the DiversityDescriptionsUnpack batchfile. For more information see General Download Notes.
- Catalogue of Life webservice is offline. As soon as a replacement is available, it will be included
- Google Maps display for links to Gazzetteers and Sampling Plots fixed
- New option for editing description data in HTML form
- Export questionnaire:
- Improved encoding of modifier and frequency data (only changes)
- New option for item detail editing
- New option for sans serif font
- New option and formatting of state data
- Error corrections in central Diversity Workbench parts
- Miscellaneous error corrections
Manual
Updated contents:
- Edit description - HTML form
- Export questionnaires
New contents: -
Alternative download A small download of the main program files as zipped program folder.
Beta test versions
For download of test versions check DiversityDescriptions clients for beta testing.
Previous versions
These client applications are built for Microsoft .Net Framework 4.8.
Use the installer if you have administrator rights, otherwise use the DiversityDescriptionsUnpack batchfile. For more information see General Download Notes.
- Catalogue of Life and other webservices are offline. As soon as a replacement is available, it will be included
New features and fixes:
- Extend database statistics with columns that include additional projects
- Switch to new embedded browser control based on edge (chromium)
- Error corrections in
- Maintenance - Import scopes
- Query for additional projects
- Import wizard: Transformation
- Export SDD: Restrict to system languages for compatible export
- Import DELTA: Error in Import of headings corrected
- New option to modify the display sequence of statistical measures
- New options for conversion in import wizard
- Include images in HTML item view
- Edit description:
- Option to assign one or more additional projects to allow access to the descriptions
- Extended query: New option for additional projects
- Import wizard extended with DescriptionProject
- Maintenance:
- New tab *Description Project": Handling of additional projects
- New tab "Find violation of rules": Ambiguous descriptions
- New tab "Update description scopes": Link entries
- Cache database:
- New option for additional projects
- New option to transfer descriptors of a certain descriptor tree
- Miscellaneous error corrections
Database updates
Database 03.03.07:
- Correction for additional projects in procCreateCacheMappingDescription
Database 03.03.06:
- Correction for additional projects in procCreateCacheMappingDescription
- Insert of triggers for table DescriptionProject
- Update of triggers for description specific data concerning additional projects
Database 03.03.05:
- New fields for logging in table StatisticalMeasure_Enum
- New table StatisticalMeasure_Enum_log
- New update trigger for logging in table StatisticalMeasure_Enum
- Update rights for TerminologyEditor on table StatisticalMeasure_Enum
Database 03.03.04:
- Missing access rights for views fixed
- Stored procedure to insert new projects fixed - failed if no projects or users were present
Database 03.03.03:
- New view Description_ParentProject for parent project filter
- New view Description_AdditionalProject for additional project filter
Database 03.03.02:
- Copy project procedure corrected
- New table DescriptionProject
- New logging table and triggers for DescriptionProject
- New view Description_QueryExt for project filter
- New view Description_ProjectID for project filter
Database 03.03.01:
- Column help texts corrected
- Grant execute permission for procUpdateProjectProxy to Administrator
- New stored procedure procSetUserAdminProxy for sysadmin
- Include call of procSetUserAdminProxy in SetUserProjects
Cache database 01.00.09 / 10
- Correction for additional projects in
- ViewCacheItem
- ViewCacheScope
- ViewCacheStatusData
- ViewCacheCategorical
- ViewCacheQuantitative
- ViewCacheText
- ViewCacheSequence
- procPublishItem
Manual
Updated contents:
- Import wizard - Transformation
- Edit description
- Cache database - Restrictions
- Database Statistics
New contents:
- Summarize data - Statistical measures
- Maintenance - Description project
- Maintenance - Ambiguous description titles
- Maintenance - Link entries
Alternative download A small download of the main program files as zipped program folder.
Use the installer if you have administrator rights, otherwise use the DiversityDescriptionsUnpack batchfile. For more information see General Download Notes.
- Catalogue of Life and other webservices are offline. As soon as a replacement is available, it will be included
- Project handling has been modified in DiversityDescriptions 4.5.0. Please refer to user manual "Data editing - Editing the project" for details!
New features and fixes:
- Provide example files by application
- New handling of projects:
- Omit "Workbench project" in user interface
- New functions to rename project
- New function to link project to DiversityProjects
- New function to unlink project from DiversityProjects
- Adaption od DELTA and SDD import
- Webservice RLL
- Handling of special characters improved
- Handling of formatted texts corrected
- Extended query:
- Option for query of notes in all categorical states or statistical measures inserted
- Maintenance:
- New tab "Find violation of rules": Mandatory descriptors
- New tab "Find violation of rules": Exclusive descriptors
- New tab "Find violation of rules": Applicability rules
- Get resource data: New option to correct resource links
- Synchronize database: Problems with linked server fixed
- Cache database:
- Webservice RLL: Handling of special characters improved
- Handling of roles in Postgres improved
- New options for resource transfer to cache database
- New option to omit descriptors that are not transferred to cache database
- New option to show descriptor number in cache restriction
- New option to transfer data from webservices for Taxa and References
- Include resource infos for images and color in tables of package "NaviKey"
- Transfer data of sources databases for package "NaviKey"
- Shift information of legacy data in measures to notes for package "NaviKey"
- Handling of multiple scope inserts corrected for long scope texts
- Export description list: Handling of suppressed withheld descriptions corrected
- Miscellaneous error corrections
Database updates
Database 03.03.00:
- Access rights for CacheProject modified
- New project handling - updated views:
- ProjectList
- Project_Query
- New project handling: Login and user "AdminProxy" introduced
- New project handling: New update trigger for ProjectProxy
- New project handling - new stored procedures:
- procInsertProjectProxy
- procDeleteProjectProxy
- procRenameProjectProxy
- procUnlinkProjectProxy
- procLinkProjectProxy
- procUpdateProjectProxy
Database 03.02.06:
- ViewAnySummaryData extenden with notes, modifier and frequency
- Field for project name increased to 255 characters in ProjectProxy
Database 03.02.05:
- New view ViewAnySummaryData for database maintenance
Database 03.02.04:
- Corrections in log tables:
- Missing native language support for various text fields
- Missing fields wording and alternate_id for Description
- Missing field wording for Descriptor
- Updated triggers for Description, Descriptor and Project
- New field wording for Project - preparation of modified project handling in upcoming version
- New field Wording in view ProjectList - preparation of modified project handling in upcoming version
Database 03.02.03:
- Updated view View_DescriptorMeasure to include the display order
- Increase length of URI in DescriptionScope and SamplingUnit
- Set default behaviour of cache database key mapping to keep keys
Cache database 01.00.08 / 9
- Field for project name increased to 255 characters in ProjectPublished
Cache database 01.00.07 / 9
- Field for reference author cache set for native language support
- procPublishMetadata: Access to agents corrected
Cache database 01.00.06 / 8
- Fields for resource transfer settings included in ProjectPublished
- New views for resources:
- ViewCacheResourceState
- ViewCacheResourceCharacter
- ViewCacheResourceTreeNode
- ViewCacheResourceItem
- New table CacheResource
- New procedure procPublishResource
- Size of field CS increased to nvarchar(18) in CacheState and CacheDescription
- Size of field DwbURI increased to nvarchar(500) in CacheScope
Cache database 01.00.05 / 7
- Option to omit locked descriptors in CacheMetadata
- Display order included in views:
- ViewCacheState
- ViewCacheMeasure
- ViewCacheCharacter
- ViewCacheCharacterTreeNode
- Descriptor ID inserted in views:
- ViewCacheCharacterTreeNode
- ViewCacheTranslationState
- ProjectID set nullable in source tables
- New field AuthorsCache in table ReferenceTitle
- Display order included in tables:
- CacheState
- CacheCharacter
- CacheCharacterTreeNode
- Transfer procedures updated to handle order fields and omitted descriptors:
- procPublishCharacterTreeNode
- procPublishCharacter
- procPublishState
- procPublishTranslation
Postgres database 01.00.02 / 5
- New table CacheResource
- Size of field CS increased to nvarchar(18) in CacheState and CacheDescription
- Size of field DwbURI increased to nvarchar(500) in CacheScope
Postgres database 01.00.02 / 4
- ProjectID set nullable in source tables
- New field AuthorsCache in table ReferenceTitle
- Display order included in tables:
- CacheState
- CacheCharacter
- CacheCharacterTreeNode
Manual
Updated contents:
- Menu
- Tutorial
- Import SDD file
- Import DELTA file
- Data editing - Editing the project
- Data access - Projects
- Data access - Login administration
- Extended query - Extended query parameter
- Maintenance - Get resource data
- Cache database - Sources
- Cache database - Restrictions
New contents:
- Maintenance - Find violations of rules
- Maintenance - Mandatory descriptors
- Maintenance - Exclusive descriptors
- Maintenance - Applicability rules
- Cache database - Webservices
Alternative download A small download of the main program files as zipped program folder.
Use the installer if you have administrator rights, otherwise use the DiversityDescriptionsUnpack batchfile. For more information see General Download Notes.
- Catalogue of Life webservice is offline. As soon as a replacement is available, it will be included
New features and fixes:
- New option to create am empty database from the client for database system administrators
- EML export updated to EML schema 2.2.0
- EML file check: Option to chose EML schema 2.2.0 or 2.1.1
- Cache database:
- Switch to new PostgreSQL libraries for access to current database versions
- First release of source databases
- New "Protocol" tab in cache database form
- Recommended statistical measures included in table CacheState
- New tables for translations
- New tables for descriptor trees and tree nodes
- Translations and descriptor trees included in transfer filter form
- New infrastucture for packages and Add-Ons
- New parametriezed package Add-Ons
- New package "NaviKey" and Add-Ons "NaviKey_Wording", "NaviKey_Language", "NaviKey_Translations
- Mass update of a database server with command line option
- Generate state statistics: Description query window instead of Extended query window for inclusion and exclusion lists
- Maintenance for descriptive data:
- Description query window instead of Extended query window for restriction and exclusion lists
- Descriptor status data: Search for single state, state presence and state absence for categorical descriptors
- Descriptor status data: Search for value presence and value absence for quantitative, text and molecular sequence descriptors
- Query: New module related query for descriptions
- Extended query:
- Text queries for special characters improved
- New query options for modifier and frequency
- New module related query for description scopes
- Show resulting SQL query on demand
- New option to search for absent descriptor data
- Correction in search for absent categorical states
- Correction in search for absent statistical measures
- New option to copy description resources to accessible descriptors
- New option to accumulate resources in Summarize descriptions
- Miscellaneous error corrections
Database updates
Database 03.02.02:
- New stored procedure SetUserProjects to set the project access for a user
- New view View_DescriptorMeasure to read recommended measures and descriptor IDs of a project
- Updated view View_DescriptorProject for access of project descriptors
- Missing access rights to stored procedure procCreateKeyMapping inserted
Cache database 01.00.04 / 6
- Updated publishing procedure for CacheMetadata
Cache database 01.00.04 / 5
- New tables for source databases:
- TaxonSynonymySource
- TaxonSynonymySourceTarget
- TaxonSynonymySourceView
- TaxonSynonymy
- TaxonNameExternalDatabase
- TaxonNameExternalID
- TaxonList
- TaxonCommonName
- TaxonAnalysis
- TaxonAnalysisCategory
- TaxonAnalysisCategoryValue
- CollectionSpecimenSource
- CollectionSpecimenSourceTraget
- CollectionSpecimenSourceView
- CollectionSpecimen
- CollectionEvent
- Collection
- CollectionSpecimenPart
- CollectionIdentificationUnit
- ReferenceTitleSource
- ReferenceTitleSourceTarget
- ReferenceTitleSourceView
- ReferenceTitle
- ReferenceRelator
- SamplingPlotSource
- SamplingPlotSourceTarget
- SamplingPlotSourceView
- SamplingPlot
- SamplingPlotLocalisation
- SamplingPlotProperty
- GazetteerSource
- GazetteerSourceTarget
- GazetteerSourceView
- Gazetteer
- Updated publishing procedures for States and Descriptions
- Remove of project specific CacheUser role
- Access rights for project specific CacheAdmin completed
Cache database 01.00.03 / 4:
- Schema specific roles for CacheUser and CacheAdmin removed
- New tables:
- ProjectPublishedTranslation
- ProjectPublishedDesriptorTree
- CacheTranslation
- CacheCharacterTree
- CacheCharacterTreeNode
- Updated tables:
- ProjectPublished
- CacheCharacter
- CacheMetadata
- New views:
- ViewCacheMeasure
- ViewCacheTranslationItem
- ViewCacheTranslationCharacter
- ViewCacheTranslationState
- ViewCacheCharacterTree
- ViewCacheCharacterTreeNode
- Updated views:
- ViewCacheCharacter
Postgres database 01.00.01 / 3
- New tables:
- PackagePublicTable
- PackageSchema
- New views:
- ProjectLanguage
- TranslationLanguages
Postgres database 01.00.01 / 2
- New tables for source databases:
- TaxonSynonymy
- TaxonNameExternalDatabase
- TaxonNameExternalID
- TaxonList
- TaxonCommonName
- TaxonAnalysis
- TaxonAnalysisCategory
- TaxonAnalysisCategoryValue
- CollectionSpecimen
- CollectionEvent
- Collection
- CollectionSpecimenPart
- CollectionIdentificationUnit
- ReferenceTitle
- ReferenceRelator
- SamplingPlot
- SamplingPlotLocalisation
- SamplingPlotProperty
- Gazetteer
Postgres database 01.00.00 / 2:
- New tables for translations and descriptor trees:
- CacheTranslation
- CacheCharacterTree
- CacheCharacterTreeNode
- New tables pro package administration:
- Package
- PackageAddOn
Manual
Updated contents:
- Check EML file
- Cache database - Sources
- Cache database - Restrictions
- Cache database - Projects
- Cache database - Database infrastructure
- Update
- Query overview
- Query conditions
- Query result list
- Description query window
- Maintenance - Maintain descriptive data
- Maintenace - Descriptor status data
- Maintenance - Categorical summary data
- Maintenance - Quantitative summary data
- Extended query parameter - Scope conditions
- Extended query parameter - Desriptor conditions
- Extended query parameter - Statistical measures
- Generate state statistics
- Editing the description - Resource links tab
- Summarize description data
New contents:
- Cache database - Postgres infrastructure
- Cache database - Transfer protocol
- Cache database - Packages
- Cache database - Package Add-Ons
- Description query window
Alternative download A small download of the main program files as zipped program folder.
Use the installer if you have administrator rights, otherwise use the DiversityDescriptionsUnpack batchfile. For more information see General Download Notes.
New features and fixes:
- First release of the cache database
- Bug fixes in Matrix import wizard, Generate state statistics, Maintenance
- Export/Import questionnaires:
- Option to enter new resource links in questionnaires
- New form Generate state statistics
- Description query form now with option to call extended query
- Extended query
- New query criteria for description data and scope data
- New option to search for several data status values (OR for data status)
- New option to order categorical states according to the sequence number, alphabetically or reverse alphabetically
- New option to expand categorical and quantitative query parameter controls with long item lists
- Error correction: Queries with mutiple conditions combined with disjunction and conjunction
- Error correction: Ignored notes filter in quantitative query parameter control fixed
- Error correction: Loading of notes filter parameter fixed
- Handling of mismatching query parameter file fixed
- Query restricted to accessible projects
- Correction in description query
- Import wizard
- New import of translations for Descriptors, Categorical states and Descriptions
- Problem with key columns copy option fixed
- Export of tab-separated lists
- New export of translations list
- Improved progress notifications
- Offer text preview for output with a high number of columns
- New option to omit preview during export
- New option to export descriptor values as "Binary columns" in Export descriptions list
- New option to export UTF-8 with/without byte order mark BOM in Export list (Descriptors, Descriptions, Sample data, Resource data) and Matrix Export Wizard
- New batch file in installation .zip file to extract program folder
- Export of EML metadata corrected
- New form Generate diagram
- Generate diagram of categorical state usage
- Generate diagram of categorical state cross-match
- Generate diagram of descriptor usage
- Option to save data rows
- New form Description query
- Maintenance
- Maintenance form now available for role "ProjectManager"
- New tab "Sampling plots" for "Synchronize database"
- Progress bar inserted in several tabs of "Synchronize database"
- New tab "Import scopes" for "Update description scopes"
- New option to generate scopes from categorical descriptors in "Generate scopes"
- Corrections in DiversityWorkbench
- Error in remote query for references in webservice RLL corrected
- Error in CSV export with SQL login fixed
- Miscellaneous error corrections
Database updates
Database 03.02.01:
- Correction in stored procedure to copy description
- Correction in stored procedure to generate description ID mapping for cache database
- New stored procedures to retrieve descriptor and item list for a DWB project
Database 03.02.00:
- New scope type "Sampling plot"
- Links to scope proxy tables removed from DescriptionScope
- Unused scope proxy tables removed
Cache database 01.00.02:
- New table CacheMetadata
- Extended access rights for role CacheAdmin
- New tables and procedures for bcp transfer
- Updated transfer procedures
Postgres database 01.00.00:
- New tables for project specific data:
- CacheMetadata
- CacheCharacter
- CacheState
- CacheItem
- CacheScope
- CacheCategorical
- CacheQuantitative
- CacheText
- CacheSequence
Manual
Updated contents:
- Database
- Installation
- Menu
- Query overview
- Generate document
- Extended query
- Extended query parameter
- Extended query parameter - Categorical states
- Extended query parameter - Statistical measures
- Export CSV
- Export
- Matrix export wizard
- Export descriptors list
- Export descriptions list
- Export sample data list
- Export resource data list
- Export questionnaires
- Import questionnaires
- Maintenance
- Update description scopes
- Generate scopes
- Synchronize databases
New contents:
- Generate state statistics
- Generate state statistics - Three descriptor cross-match
- Extended query parameter - Description conditions
- Extended query parameter - Scope conditions
- Extended query parameter - Descriptor conditions
- Export translations list
- High-resolution displays
- Generate diagram
- Generate diagram - categorical state usage
- Generate diagram - categorical state cross-match
- Generate diagram - descriptor usage
- Maintenance - Sampling plots
- Maintenance - Import scopes
- Administration of the Prostgres database
Alternative download A small download of the main program files as zipped program folder.
New features and fixes:
- Edit description:
- Show project scopes in a separate tree view
- Access error for import DELTA and SDD corrected
- Error in language code editor fixed
- Login administration
- Improved error messages for insufficient edit rights
- Form for server activities integrated
- Form for linked servers integrated
- Maintenance
- New option to fix descriptor column in descriptor tree maintenance for measures, modifiers and frequencies
- Structured export (SDD, DELTA, EML)
- Generator for project metadata switched to new interface
- New form for cache database (under construction!!!)
- Adjustment of transfer depending on "withhold" descriptor data status
- Adjustment of key mapping for descriptions, descriptors and states
- Transfer restrictions for descriptions, descriptors and scopes
- Summarize descriptions/sampling data
- New option to include additional information (summarized datasets) in notes
- Questionnaires
- New option to control output of order numbers for descriptors and categorical states
- New option to include scope data in questionnaires
- New option to adjust zoom factors for mouse hover on resources
- New import of scope data
- Query
- New option to keep selected entries of the query result list and remove the rest
- New menu item to select a preferred project for description and descriptor queries
- Import wizard
- New search option in the import session mapping view
- Generate document
- New option to include scope data from foreign databases for HTML and Pensoft
- Options for translations and wording inserted for Pensoft
- New option for suppressing notes for Pensoft
- Error in handling of "Data title" option for HTML corrected
- New option to create a new description with a scope reference from the command line
- Additional error message for invalid URI
- Error correction for SQL-login
- Installer: Remove old versions in APP list
- Miscellaneous error corrections
Database updates
Database 03.01.06:
- Correction of possibly empty scope data fields
- Remove links to scope proxy tables
Database 03.01.05:
- New views:
- ProjectList
- WithheldData
- New procedures:
- procCreateCacheMappingDescriptor
- procCreateCacheMappingState
- procCreateCacheMappingDescription
- Altered triggers for descriptive data and terminology to actualize time stamp in CacheProject for changes
- Remove references to taxon set and descriptor tree from project and project_log to avoid cyclic referencing
- Update of copy procedures and triggers for removed columns
Cache database 01.00.01:
- New tables:
- CacheDatabase
- CacheProject
- CacheMappingDescription
- CacheMappingDescriptor
- CacheMappingCategoricalState
- New views:
- ViewCacheCharacter
- ViewCacheState
- ViewCacheItem
- ViewCacheScope
- ViewCacheCategorical
- ViewCacheQuantitative
- ViewCacheText
- ViewCacheSequence
Manual
Updated contents:
- Menu
- Queries
- Query
- Result list
- Export Questionnaires
- Import wizard
- Import sessions
- Generate documents
- Generate description document
- Generate descriptor document
- Generate project document
- Data access
- Security
- Login administration
- Edit descriptions
New contents:
- Data availability
- Cache database
- Basic steps
- Create cache database
- Projects
- ID mapping
- Restrictions
- Import / Export
- Import
- Export
- File operations
Alternative download (If you do not have administrator rights on your computer or want to use different application versions in parallel.)
New features and fixes:
- Show parent data in translation form
- New link field in remote query result
- Modified output of summary data in remote query result.
Datebase updates
- Correction in log user handling
- Insufficient view access rights for log handling fixed
- New views for linked server support
Alternative download (If you do not have administrator rights on your computer or want to use different application versions in parallel.)
New features and fixes:
- Installer creates shortcut on desktop and in program menu
- Installer requires Windows administrator rights!
- Option to install application for all computer users
- Resources for user placed outside program directory
- 3 Options to places resources: Home, Documents, User defined
- Handling of error log file modified
- 2 Options: Keep error log file, Clear error log file at program start
- Open error log file with editor
- Manual clearance of error log file if "Keep" option is selected
Datebase updates
- none
Alternative download (If you do not have administrator rights on your computer or want to use different application versions in parallel.)
Database
The database is built for Microsoft SQL Server 2014. Please make sure that you have Microsoft SQL Server 2014 onwards installed on your computer! (Check under control panel -> Software for Microsoft SQL Server).
- Download the Database 3.1.3, September 18th, 2019
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
In this section selected client versions for the .Net framework 3.5 are listed. If you need a specific version, please contact the SNSB IT center.
Online manual
The manual is provided as pdf file (for current version check DWB user manuals) and compiled help file in CHM (= MS online help format). The compiled help file is available for separate download but is included in the zip archive of the client application as well.
Client application
Final version for .Net Framework 3.5
The client application is built for Microsoft .Net Framework 3.5. 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:
- Database - upgrade to version 03.01.03:
- New view definitions for enhanced query options
- History:
- Display and restore function of history data for DescriptorInapplicability in "Edit projects"
- Restore deleted DescriptorInapplicability data
- Display of Summary data in "Remote query" on demand
- Query:
- Query for create/change date and user in "Edit descriptions", "Edit descriptors" and "Edit projects"
- Query for descriptor value presence now selectable by project hierarchy in "Edit descriptions"
- Modified query for scope values in "Edit descriptions"
- Enhanced query options in "Summarize description data" and "Summarize sample data"
- Command line interface to open a single dataset for editing
- Connection administration:
- Error in display of project and agent databases corrected
- Adding of previously added connections on demand
- Module connections corrected to show all database connections
- Extended query:
- Selection of disjunctive combination of statistical measurement criteria ("OR" for single measures)
- Disjunctive combination of descriptor criteria ("OR" for descriptor conditions)
- List export:
- New option "Separate line" for multi-valued parameters in descriptor, description and sample data list export
- New output preview in data grid
- Matrix export wizard:
- New option to export (and re-import) sequence numbers of categorical states instead of names
- Description grid view:
- Option to edit quantitative measures in separate columns
- Import wizard:
- Error in merging of float values fixed
- Import wizard for sample data:
- Allow import of multiple sampling events and sampling units
- Extended query: Allow export of query result list as tab-separated text file
- Maintenance:
- Descriptor status data: New function to set descriptor status data for specific categorical summary data
- Categorical summary data: Allow search for descriptions without categorical states for a descriptor
- Summary data: Restriction and exclusion lists, seleted with "Extended query", for descriptive data maintenance
- Synchronize database: Make connection admin available for all synchronize options
- History data:
- Allow recovery of history data for administrator
- Allow restore of deleted data for administrator
- Miscellaneous error corrections
- Display ID of sampling events
- Output of messages in case of save errors
- Defined behaviour for extended descriptor names in case of unambiguous descriptor trees
- Final regular version for DWB .NET 3.5.
- Download the Client software 3.0.2.8 without manual
- Download the .Net framework (see General Download Notes)
DiversityDescriptions for quiz database
New features and fixes:
- Enhanced form "Set taxon links"
- Prevent changes in scope table for proxy links to avoid interference with quiz application
- New form "Set taxon links" to supply quiz related data
- SDD import restores original resource/resource variant structure
Database
The database is built for Microsoft SQL Server 2008 R2. 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 03.00.10
Database server
- Download the SQL Server (see General Download Notes)
Previous MS Access versions
Earlier implementations of DiversityDescriptions pre-date the Diversity Workbench concept. Very early versions were named DeltaAccess, later one DiversityDescriptions 1.0-2.0. They are still actively used and have far more features and options than the present re-implementation in dot-net. The information about the version 1.9 can be found outside the wiki on a static page under: http://www.diversityworkbench.net/OldModels/Descriptions/index.html. The version 2.0 of DiversityDescriptions (= DeltaAccess 2.0) can be safely used with Access XP, 2000 or 2003, and to a large extent with Access 2007. However, a very difficult-to-track bug exists in Access 2007 in the item editor and resources were insufficient to fix this bug. The "DD 2.0 beta 12" version has been used for several months by at least two testers and is publicly available and recommended for use: File:DiversityDescriptions 20b12.mdb.zip. Diversity Descriptions 2.0 supports importing DELTA datasets and exporting them to SDD 1.1. However, it has no SDD import yet. See also "How to use DiversityDescriptions on Japanese Computers".
See also DiversityDescriptions Information Models and General Download Notes.
