DiversityDescriptions

From Diversity Workbench
Jump to: navigation, search
Diversity Descriptions - Matrix2Triple © SNSB IT Center
DiversityDescriptions © SNSB IT Center

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.

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. It 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.

Software for .Net Framework 4.8

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 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.

Download the Installer for client software 4.3.0 (zip archive containing installer), October 22nd, 2020 (Database 3.2.1)

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 3.2.1:

  • 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 3.2.0:

  • New scope type "Sampling plot"
  • Links to scope proxy tables removed from DescriptionScope
  • Unused scope proxy tables removed

Cache database 1.0.2:

  • New table CacheMetadata
  • Extended access rights for role CacheAdmin
  • New tables and procedures for bcp transfer
  • Updated transfer procedures

Postgres database 1.0.0:

  • 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.


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.

Download the Installer for client software 4.2.0 (zip archive containing installer), April 21st, 2020 (Database 3.1.6)

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 3.1.6:

  • Correction of possibly empty scope data fields
  • Remove links to scope proxy tables

Database 3.1.5:

  • 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 1.0.1:

  • 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.)

Download the Installer for client software 4.1.0 (zip archive containing installer), October 14th, 2019 (Database 3.1.4)

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.)

Download the Installer for client software 4.0.0 (zip archive containing installer), September 18th, 2019 (Database 3.1.3)

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).

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





Software for .Net Framework 3.5

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

Current version

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).

Download the Client software 3.0.2.8 (zip archive), 2019/08/08 (Database 3.1.3)

New features and fixes:

  • Database - upgrade to version 3.1.3:
    • 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.



Previous versions

These client applications are built for Microsoft .Net Framework 3.5 or higher. Please make sure you have the correct version of this software.

Features of the Client software 3.0.2.6, March, 28th, 2019 (Database 3.1.2)

New features and fixes:

  • Manual:
    • Menu
    • Summarize data
    • Summarize descriptions
    • Import DELTA
    • Export data
    • Export questionnaire
    • Convert DELTA
    • Convert SDD
    • Editing the descriptor - Modifier/Frequency tab
    • Editing the project - Modifier/Frequency tab
    • Maintenance - Broken links
    • Summarize sample data
  • Database - upgrade to version 3.1.2:
    • New optional fields "wording" in tables "Description" and "Descriptor"
    • New optional fields "alternate_id" in table "Description"
    • User controls "Edit descriptor" and "Edit description" update for new data fields
    • New form "Alternate ID"
  • Maintenance:
    • Include selected web services in synchronize database tabs
    • Improved fault tolerance of web service module "RLL" against invalid characters in XML response
    • New filter string option in synchronize database tabs
    • New control for number of processed entries in "Broken links" tab
    • Corrections in database access
    • Accelerated processing in "Synchronize database" functions
  • Modifier/Frequency values:
    • Hide empty "use" column
    • New function for ordering of Modifier and Frequency values
    • New predefined Modifier and Frequency values
    • Accelerated start of form for predefined Modifier and Frequency values
  • Extended query:
    • Native language support for search strings
    • New option for search in notes of description data
    • New option for search of disjunctive categorical states (OR)
  • Import wizard:
    • Improved display of import progress
    • Accelerated loading of large import files (Import Wizard and Matrix Import Wizard)
    • Selection list for categorical state in description import corrected
  • Export questionnaire:
    • New option to hide descriptor status data in HTML-forms
  • Export list:
    • Include new database fields in "Descriptor list" and "Description list"
    • New output options "Notes" and "Value" for quantitative data in description list export
    • New output option "Notes" for categorical states in description list export
    • New output field "Resource No." in resource list export
  • Descriptor Tree edit:
    • Restore last tree expansion state after reloading
  • Form "Summarize descriptions":
    • New option for exclusive descriptors
    • Summarize sampling data
  • Import wizard:
    • Corrections in merge handling of resource and resource variant
  • Sample data editing:
    • Correction in handling of notes
    • Correction in display of sampling events
  • Miscellaneous error corrections
    • Error in handling of "Maintenance"/"Broken links" corrected
    • Invalid display of descriptor tree nodes in control "Select tree node" corrected
Features of the Client software 3.0.2.4, November 30th, 2018 (Database 3.1.1)

New features and fixes:

  • Manual, modified contents:
    • Convert SDD file
    • Convert DELTA file
    • Import SDD file
    • Import DELTA file
    • Editing translation
    • Editing the project
    • Export resource data list
  • Manual, new contents:
    • Edit language codes
  • Database: Upgrade to version 3.1.1:
    • Correction in data logging
  • Import DELTA:
    • New option for editing additional language codes
  • Edit translation:
    • New option for editing additional language codes
  • Edit project:
    • New option for editing additional language codes
    • New option to view link to DiversityProjects
  • Encrypted connection to database
  • Export list:
    • Possible endless loops in description and resource list export fixed
    • New filter options in resource list export
    • New option to include descriptor titles in resource list export
  • Descriptor Tree edit:
    • New buttons "Move to top" and "Move to bottom" for shifting of descriptor tree nodes
    • New button for "Shift selected entry" for shifting of descriptor tree nodes
  • New document generation function: XSD and XML project documents
  • New form "Summarize descriptions":
    • Write info for updated summary data
  • Data export:
    • New option to omit descriptor data entry notes in form "Export data"
    • Include data from DiversityProjects in EML
    • Include data from DiversityProjects in SDD
    • Show progress bar in EML, SDD and Delta export data writing
    • Corrections in EML, SDD and Delta export
  • Allow multiple scope inserts in description edit
  • Show connection details in all import and export forms as bubble help
  • Miscellaneous error corrections
Features of the Client software 3.0.2.2, July 30th, 2018 (Database 3.1.0)

New features and fixes:

  • Manual, modified contents:
    • Menu
    • Matrix import wizard
    • Convert SDD file
    • Convert DELTA file
    • Export data as structured file
    • Export descriptors list
    • Export descriptions list
    • Export sample data list
    • Export resource data list
    • Export questionnaires
    • Statistics
    • Export SDD/DELTA
    • Description grid view
    • Sample data grid view
    • Editing the project – Descriptor tree tab
    • Maintenance
  • Manual, new contents:
    • Check EML file
    • Maintenance – Clean descriptive data
    • Matrix Export Wizard
  • New matrix export wizard for tab-separated descriptions list
  • Abort buttons introduced in questionnaire generator and list export forms
  • Export questionnaires now generates documents with mouse-over zoom for pictures
  • New EML generator:
    • New form "Check EML file"
    • EML generator included in "Convert SDD file" and "Convert DELTA file"
    • EML export inserted in "Export data"
    • Analyse step now abortable in all SDD and DELTA import or convert forms
  • Data editing:
    • Allow restriction to descriptor tree nodes in descriptor view tab and sample data tab
    • New insert/append/replace function in translation edit
  • Generate document:
    • Omit applicability data for Semantic Media Wiki document
    • Exclude references to descriptor trees outside the selected project in Semantic Media Wiki document
  • Statistics extended with descriptor tree information
  • Edit projects:
    • New function to edit project descriptor assignments for descriptor trees and descriptor tree nodes.
  • Grid views:
    • Allow restriction to descriptor tree nodes in description and sample data grid view
    • New column edit function in description grid view
    • Title alignment improved in description and sample data grid view
    • Abort button introduced in description and sample data grid view
    • Error for "data reader" role corrected
  • Document generator:
    • Omit descriptor's "data_entry_notes" in output
  • Maintenance:
    • New function "Clean description data"
    • Limit number of results in "Clean empty resources" and "Clean descriptor trees"
    • Distinguish entity type in "Clean descriptor trees"
  • Error corrections:
    • Restriction to descriptor tree did not work in Media Wiki document generator
    • Invalid calculation of write protection in translation editor
    • Miscellaneous error corrections
Features of the Client software 3.0.2.0, June 27th, 2018 (Database 3.1.0)

New features and fixes:

  • Manual, modified contents:
    • Matrix import wizard
    • Export descriptors list
    • Export descriptions list
    • Export sample data list
    • Export resource data list
    • Export questionnaires
    • Statistics
    • Export SDD/DELTA
    • Editing the description
    • Editing the descriptor
    • Editing the project
    • Description grid view
    • Sample data grid view
    • Editing the project - Descriptor tree tab
    • Maintenance
    • Database - access
  • Manual, new contents:
    • Maintenance - Maintain descriptors
    • Maintenance - Categorical states
    • Maintenance - Maintain descriptive data
    • Maintenance - Categorical summary data
    • Maintenance - Quantitative summary data
    • Maintenance - Clean descriptive data
    • Matrix Export Wizard
    • History
    • Logging
  • Database: Upgrade to version 3.1.0:
    • Introduction of data logging
  • Abort buttons introduced in questionnaire generator and list export forms
  • Export questionnaires now generates documents with mouse-over zoom for pictures
  • Data editing:
    • Allow restriction to descriptor tree nodes in descriptor view tab and sample data tab
    • New insert/append/replace function in translation edit
  • Generate document:
    • Omit applicability data for Semantic Media Wiki document
    • Exclude references to descriptor trees outside the selected project in Semantic Media Wiki document
  • Statistics extended with descriptor tree information
  • Edit projects:
    • New function to edit project descriptor assignments for descriptor trees and descriptor tree nodes.
  • Grid views:
    • Allow restriction to descriptor tree nodes in description and sample data grid view
    • New column edit function in description grid view
    • Title alignment improved in description and sample data grid view
    • Abort button introduced in description and sample data grid view
  • Document generator:
    • All text documents now generated in UTF-8 coding without BOM
  • Data export:
    • Option to omit applicability data during "Analyze data" step
    • Abort button introduced in "Analyze data" step
    • All text documents now generated in UTF-8 coding without BOM
    • All XML documents now generated in UTF-8 coding without BOM
  • Maintenance:
    • New function "Maintaint descriptors / Categorical states"
    • New function "Maintain descriptive data / Categorical summary data"
    • New function "Maintain descriptive data / Quantitatitive summary data"
    • New function "Maintain descriptive data / Clean descriptive data"
    • Limit number of results in "Clean empty resources" and "Clean descriptor trees"
    • Distinguish entity type in "Clean descriptor trees"
  • Error corrections:
    • Restriction to descriptor tree did not work in Media Wiki document generator
    • Invalid calculation of write protection in translation editor
    • Miscellaneous error corrections
Features of the Client software 3.0.1.30, February 8th, 2018 (Database 3.0.20)

New features and fixes:

  • Database: Upgrade to version 3.0.20:
    • New database views "ResourceCategoricalState_Query" and "ResourceProject_Query" for support of additional query parameter
  • Other scope editing:
    • Allow editing of scope details
    • Show additional scope data in bubble help
  • Resource control:
    • Show hint if additional resource data are available
    • Show resource details, rights and ID in bubble help
  • Grid views:
    • New button to adjust table colors in description grid view and sample data grid view
    • Show descriptor ID in bubble help of descriptor column headers
  • Queries:
    • New query parameter "Details" for descriptions, descriptors and projects
    • New query parameter "Notes" for descriptors
    • New query parameter "Tree nodes" for descriptors
    • New query parameter group "Categorical state" for descriptors
    • New query parameter group "Descriptor resource" for descriptors
    • New query parameter group "State resource" for descriptors
    • New query parameter group "Node resource" for projects
    • No translation to date/time format in query result list
  • Document generator:
    • New option to show duplicate resource links in "Generate resource list"
  • Error corrections:
    • Incomplete display of "Value should be integer" warning fixed
    • Handling of "From descriptor" and "To descriptor" fields in descriptor grip view, sample data grid view and sampling event control fixed
    • Handling of new entries in table forms (Categorical state, Resource, Modifier and Frequency) fixed
    • Missing field "Details" in Descriptor list export inserted
  • Table editors:
    • Export data rows in displayed sequence
  • Descriptor applicabilities:
    • Full mode for dependent descriptor editing
    • Save settings when application is terminated
  • Translation support:
    • Support of translations in document generators (HTML, MediaWiki, Semantic MediaWiki)
    • Support of translations in SDD/DELTA export
    • Support of translations in questionnaire export
      • Page names for categorical states now includes descriptor names
  • Maintenance:
    • New function "Clear empty scopes"
  • Miscellaneous error corrections
Features of the Client software 3.0.1.28, October 25th, 2017 (Database 3.0.19)

New features and fixes:

  • Translations:
    • New form for tranlation editing
    • New extended editor for translation editing
    • New table editor for translations
  • New form for description browsing
  • Document generator:
    • Semantic media wiki:
      • Optional string replacement for descriptors and categorical states
      • Page names for categorical states now includes descriptor names
    • Media wiki:
      • Optional string replacement for descriptors and categorical states
      • Optional prefix for linking to semantic media wiki
      • Optional base URI for linking to semantic media wiki
      • Modified representation for linking to semantic media wiki
  • Descriptor tree editing in project mode:
    • Allow alphabetic sorting of descriptor nodes in trees and tree nodes
  • SDD export:
    • Missing export of descriptor tree node abbreviation and detail inserted
  • DELTA import:
    • Store import mapping information during import
    • New update import for descriptors, categorical states and descriptions (label, abbreviation and details)
    • New update import for translated descriptors, categorical states and descriptions
  • Form for database maintenance included
  • Miscellaneous error corrections
Features of the Client software 3.0.1.26, August 25th, 2017 (Database 3.0.19)

New features and fixes:

  • Database: Upgrade to version 3.0.19:
    • Include import session mappings for DescriptorTreeNode table and associated resources in stored procedure "procCreateKeyMapping"
  • Database: Upgrade to version 3.0.18:
    • Include field "detail" in DescriptorTreeNode table
    • Include field "node_id" in Resource table
  • Remember last executed query
  • Allow additional data (abbreviation, detail and resources) for descriptor tree nodes:
    • Include descriptor tree node resources in export of resource data list
    • Import wizard for descriptor tree node resources
    • Import sessions: Clear and import mapping data for descriptor tree node resources
    • Include new data in HTML and MediaWiki document generators
    • Include descriptor tree node resources in maintenance form tab "Update resource data"
    • Error correction in descriptor tree data saving
    • Copy new data with the copied descriptor tree node
    • New form to edit descriptor tree node text fields and resource data
    • Adaption of "Descriptor tree view" tabs to show and edit new data
    • Adaption of "Descriptor view" tab to include descriptor tree node resources
    • Adaption of "Continuous view" tab to display structured descriptor view
    • Adaption of "Sample data" tab to include descriptor tree node resources
    • Adaption of "Description grid view" form to include descriptor tree node resources
    • Adaption of "Sample data grid view" form to include descriptor tree node resources
  • SDD import and export:
    • Include additional descriptor tree node data
    • Include descriptor tree node resource data
    • Adaption to new schema file for SDD extensions
    • Minor corrections
  • DELTA export:
    • New options to control output of description, descriptor and categorical state details
    • New options to control output of modifier and frequency values
    • New options to control output of summary and sample data notes
    • Correction in output of categorical summary data
  • New delete buttons in edit tables for categorical states, resources and modifier/frequency values
  • New form to check SDD data files
  • Include additional application adjustments in settings
  • Miscellaneous error corrections
Features of the Client software 3.0.1.24, April 28th, 2017 (Database 3.0.17)

New features and fixes:

  • User Manual:
    • Tutorial updated to match actual version
    • Import wizard tutorial adapted to new "Agricultural Survey" example
    • Advanced import wizard tutorial actualized
    • Links to GitHub examples inserted
  • SDD import and export:
    • Handling for non-standard role values of resources inserted
    • Handling for sampling unit specimen ("incompatible" mode) inserted
    • Handling of modifier references during import corrected
    • Handling of recommended modifiers improved
  • Modifications due to workshop feedback:
    • Additional edit mode selector in top area of the window header
    • Additional optional query fields for ID and sequence number (descriptors)
    • Additional sort options for ID (descriptor, project) and output of titles with the ID
    • Start descriptor tree views with visible edit areas
    • Automatically open file selection window in SDD import form
    • New background images for empty workspace
  • Fixes due to zoomed view in high resolution displays (Windows 10):
    • Selection of top entry for categorical states, statistical measures and data status values not possible
    • Automatic adaption of table column width for descriptiors, categorical states, statistical measures, data status values and resources
    • Replacement of checked list boxes by tree views in extended query due to trunkated characters
  • Miscellaneous error corrections
Features of the Client software 3.0.1.22, March 13th, 2017 (Database 3.0.17)

New features and fixes:

  • Document generator for Semantic Media Wiki:
    • New controls for tree node generator
    • New control for cardinality in descriptors
  • Database:
    • Upgrade to database version 3.0.17
  • Sampling data:
    • Include collection specimen with link to DiversityCollection in sampling units
  • Import Wizard:
    • Read drop down lists from value constraints in database
    • New role values for resources now available in import wizard
  • List export:
    • New "browse" buttons for existing target document
    • New option to export empty entities in resource list
    • Include line numbers in resource list export
    • Endless loop for unambigious description items fixed
  • Maintenance:
    • New function: Clean empty resources
    • Include sampling units in database synchronization for collection specimen
  • Extended query:
    • Background loading of resources
    • Don't show state resources during XML schema loading
    • Correction of XML schema loading
  • Resource viewer control:
    • Background loading of remote resources to avoid GUI freeze
  • Resources:
    • Default value of parameter role changed to "unknown"
    • New role value for skos mapping in descriptor and categorical state resources
  • Adaptions for high DPI displays
  • Miscellaneous error corrections
Features of the Client software 3.0.1.20, December 23rd, 2016 (Database 3.0.16) ***Merry Christmas***

New features and fixes:

  • New form "Extended query" to search for description items with specific summary data
    • Categorical summary data:
      • Search for presence of categorical states and data status values
      • Search for specific categorical states and data status values
      • Search for absence of specific categorical states
    • Quantitative summary data:
      • Search for presence of statistical measures and data status values
      • Search for specific statistical measure values rsp. value ranges and data status values
      • Exclude specific statistical measure values rsp. value ranges
    • Text descriptor data:
      • Search for present text descriptor data and data status values
      • Search for specific text descriptor data (substring/start text/end text/match) and data status values
      • Search for specific text descriptor data
    • Molecular sequence data:
      • Search for present molecular sequence data and data status values
      • Search for specific molecular sequence data (substring/start text/end text/match) and data status values
      • Search for specific molecular sequence data
  • Form "Maintenance" extended with "Maintain descriptor trees"
    • Find and fix missing entities for description data
    • Administer recommended statistical measures
    • Administer recommended modifier values
    • Administer recommended frequency values
    • Clean descriptor trees from superfluous recommended values
    • Delete all recommended values from incomplete descriptor trees
  • Document generator
    • Semantic MediaWiki generator modified
  • Database documentation:
    • Semantic MediaWiki generator modified
  • Miscellaneous error corrections
Features of the Client software 3.0.1.19, November 4th, 2016 (Database 3.0.16)

New features and fixes:

  • Form "Review data" moved to "Export resource data list" in menu Data->Export->Export lists
  • New form "Export questionaires" for generation of description data as HTML form
    • Include notes and modifier/frequency values in questionaires
    • Generate questionaires for selected descriptions and index page
    • Generate empty questionaire for new items
    • Individual adjustment of colors for HTML pages
    • Layout improved
    • Bubble help for descriptor notes, descriptor status data and statistical measures
    • Download of entered data as text file to overcome length problem with mail transfer
  • New form "Import questionaire data" for import of HTLM form responses
    • Import of single files or text inserted by copy-paste
    • Batch import of multiple selected files
  • Document generator
    • Individual adjustment of colors for HTML pages
  • Import wizard:
    • Import of resource data improved to support re-import of reviewed resource data
  • Database documentation:
    • Semantic MediaWiki generator corrected
  • Miscellaneous error corrections
Features of the Client software 3.0.1.18, September 9th, 2016 (Database 3.0.16)

New features and fixes:

  • Resource maintenane:
    • Call table editor with symbolic names for referred objects
  • Import sessions:
    • New option "Generate mappings ..." to provide standard mapping with internal keys (re-import of "Review data" tables)
    • New clear options for DescriptorNode, SamplingEvent and Resource data
    • New import options for DescriptorNode, SamplingEvent and Resource data
    • Actualize time stamp when mappings are deleted
  • New form "Review data" for generation of tab separated resource overview documents
  • List generator:
    • Generate unicode documents
  • Document generator:
    • New Semantic MediaWiki generator for project data
  • Database documentation:
    • New Semantic MediaWiki generator for data model
  • Miscellaneous error corrections
Features of the Client software 3.0.1.17, July 11th, 2016 (Database 3.0.15)

New features and fixes:

  • Table editors:
    • Optional export of related table entries to tab separated file
    • Show names of related table entries, e.g. descriptor_name instead of descriptor_id
    • Show restricted values as combo box entries
  • Document generator:
    • Enhancement of MediaWiki generator: resource links and details for categorical states
    • New HTML generator for project data:
      • Descriptor trees
      • Descriptor data
      • Descriptor applicabilities
  • Resource editing:
    • New resource roles 'normative' and 'unknown' (new default value)
    • New functions for sorting and renumbering of resource entries
    • New menu tool bars for resources and resource variants
  • Description editing:
    • New sequence import and export functions for FASTQ data format
    • New sequence import and export for sample data
  • Correction of abbreviations: Nr. -> No.
  • Miscellaneous error corrections
Features of the Client software 3.0.1.16, May 19th, 2016 (Database 3.0.14)

New features and fixes:

  • New document generator for MediaWiki format
    • Description tables
    • Descriptor tables
    • Project data (descriptor trees, descriptor data and applicability data)
  • Edit descriptions:
    • Improved selection control for description project
  • Edit projects:
    • Document generator for applicability tree
      • Correction in rule conversion
      • Suppress relations to foreign projects
      • Additional edges of project to related descriptors
    • Optional display of applicability tree inserted in "Descriptor applicability" tab
    • Suppress editing of relations to foreign projects in "Descriptor applicability" tab
    • Delete all applicablities for a selected project
    • Improved selection controls for parent project and workbench project
    • Improved selection control for scope values
  • Table editor:
    • New table editor for description scopes
    • New table editor for projects
  • Maintenance:
    • Maintenance panel restricted to role "Administrator"
    • Evaluation of project write permissions inserted in "Update resource data"
    • Link to table editor inserted in "Update resource data"
  • Miscellaneous error corrections
Features of the Client software 3.0.1.15, March 23rd, 2016 (Database 3.0.14)

New features and fixes:

  • Maintenance:
    • New function "Update resource data"
    • Fixes for linked server
  • Extended text editor:
    • New funktion for inserting and browsing internet and workbench links
    • Improved manual pages, now directly linked with editor window
  • Miscellaneous error corrections
Features of the Client software 3.0.1.14, February 23rd, 2016 (Database 3.0.14)

New features and fixes:

  • Maintenance adapted to linked database servers
  • List export:
    • New "quotes" option for output formatting
    • New target fields for descriptor list export
    • New option to select culture for formatting of floating number and date fields
    • New sample data list export
  • Sample data:
    • New data grid view for sample data
    • Formatting of sequence values in grids after edit
    • Viewing of descriptor and state resources in sample grids possible
  • Import wizard:
    • Lost time during import of date/time values after midnight fixed
  • Miscellaneous error corrections
Features of the Client software 3.0.1.13, December 18th, 2015 (Database 3.0.14)

New features and fixes:

  • Project editing:
    • Descriptor tree restricted to selected project
    • Full descriptor tree displayed on request
  • Import wizard:
    • New matrix wizard for sample data
    • New wizard for sample data
    • Selection lists restricted to elements from import session project
    • Selection lists for descriptors and states restricted to import session
  • New table editors:
    • Sampling events
    • Descriptions
    • Descriptors
    • Categorical states
    • Resources
    • Resource variants
    • Improvements of table editor in data saving and corrections for read-only access
  • New sample data:
    • Support appending of sampling events and sampling units to descriptions
    • Export and import of sample data with SDD
    • Export sample data as descriptions in DELTA
    • Delete project now works correctly if sample data are present
    • Data saving problems after unit editing fixed
  • Maintenance form:
    • Problems with native language characters fixed
    • Sampling events inserted in "Synchronize - Gazetteers"
    • Sampling events inserted in "Synchronize - Broken links"
    • Synchronize - Broken links extended to handle deviant display strings
  • Matrix wizard: Disable form during import
  • Resource edit: Easy insert of local files as resource link
  • Module connection: Reload added links after database connect
  • HTML generator: Handling of modifier and frequency values changed
  • Modifier edit: Check for recommended values
  • Accept file extension .fa and .fas for FASTA files
  • Sporadic failure during categorical summary data edit fixed
  • Miscellaneous error corrections
Features of the Client software 3.0.1.12, October 1st, 2015 (Database 3.0.14)

New features and fixes:

  • New "Matrix wizard":
    • Select import rows and columns for descriptor and description data
    • Select descriptor column properties
    • Save load matrix schema files
    • Generate descriptor and description tables and schema files for table oriented import wizard
    • Import test of descriptors and description data
    • Import of descriptors and description data in Wizard
  • Import wizard:
    • Failed import of sequence data in "Import description" fixed
    • Remove superfluous quotation marks in file columns
    • Handle float values in file according to language setting
  • DELTA import and converter:
    • New extended analysis options to control handling of comments in description/descriptor/state
  • SDD import and export:
    • Include descriptor notes (data_entry_note field of database) to SDD details role="InternalNotes"
    • Preserve the original resource/resource variant structure if "compatible" option is deactivated during export
    • Handling of taxon names corrected
  • Description editing:
    • New "Description grid view"
    • Descriptor list may be restricted to tree in "Descriptor view tab"
    • Distinguish between summary data and status data in field "use" of "Descriptor view tab"
    • Mark withheld data and used inapplicable descriptors in "Descriptor view tab"
  • New statistics form
  • Remove line breaks and tabs in label fields after external editing
  • Miscellaneous error corrections
Features of the Client software 3.0.1.11, July 15th, 2015 (Database 3.0.14)

New features and fixes:

  • Document generator:
    • New option to generate HTML output of description data according descriptor tree structure
    • New generator for description data in "Pensoft" format
  • Scope editing: Linked scopes marked by different table colour
  • Description editing:
    • New options to include descriptor tree hierarchy in "Descriptor view" and "Continuous view"
    • Hide gap symbol in sequence if not defined
    • Mixed up resources and help texts after descriptor sorting fixed
    • Hanging notes in data status fixed
  • Maintenance:
    • New function to delete unlinked entries in "Broken links"
    • New function "Generate scopes"
  • DELTA import:
    • Missing notes in imported data fixed
    • Invalid sequence of statistical measures fixed
    • Optional insert of categorical state "variable" for DELTA state "V"
    • Mapping of DELTA state "V" to data status "Not interpretable"
  • Export to csv now works with Windows 8.1
  • Miscellaneous error corrections
Features of the Client software 3.0.1.10, May 22nd, 2015 (Database 3.0.14)

New features and fixes:

  • New document generator for descriptors and descriptions (including resources)
  • New editing options for descriptor trees:
    • Generate flat complete tree from existing data
    • Move/Copy descriptor trees to descriptor nodes
  • New rich text editor for text fields:
    • Support of selected HTML format mark-ups
    • Conversion of RTF-like format mark-ups to HTML mark-ups
  • Export to SDD and DELTA:
    • Export of selected descriptions instead of whole project
    • Consistent HTML-tags ensured
  • Export of descriptor and description lists:
    • Output lines adjustable
    • Line break replaced by HTML-tag to prevent disturbed table structure
  • Import wizard:
    • Update of resource row in resource variant wizard
    • Import of resource detail, language and embedded flag
  • Missing export/import of resource rights to/from SDD fixed
  • Miscellaneous error corrections
Features of the Client software 3.0.1.9, March 26th, 2015 (Database 3.0.13)

New features and fixes:

  • Import mapping information may now be imported or deleted
  • Import of resource data inserted in import wizard
  • Import wizard: Descriptor tree nodes, projects and enumerated values now specified by name, not by id
  • Insert recommended statistical measures to quantitative descriptors during DELTA import
  • Problems in DELTA import and export for quentitative data fixed
  • Missing descriptors of subordinated projects for item editing fixed
  • Sporadic loss of inserted descriptor tree nodes fixed
  • Miscellaneous error corrections
Features of the Client software 3.0.1.8, February 16th, 2015 (Database 3.0.12)

New features and fixes:

  • Local FASTA import and export of molecular sequence data
  • New maintenance form for handling of external database connections
  • Miscellaneous error corrections
Features of the Client software 3.0.1.7, December 15th, 2014 (Database 3.0.12)

New features and fixes:

  • New descriptor type "Molecular sequence descriptor"
  • New editor for molecular sequences in descriptions
  • Import wizard adapted for molecular sequence descriptor
  • SDD and DELTA import adapted for molecular sequence descriptor
  • Data export adapted for molecular sequence descriptor
  • Move of descriptor and tree nodes now working correctly (descriptor tree in edit projects)
  • Comments in text character data of DELTA import not detected
  • DELTA export for default descriptor tree corrected
  • Miscellaneous error corrections
Features of the Client software 3.0.1.6, November 13th, 2014 (Database 3.0.11)

New features and fixes:

  • Import wizard for descriptors supports recommended values
  • Import wizard supports merge and update
  • Mapping data of import sessions can be displayed
  • Notes for descriptor status data inserted
  • Tutorial for DiversityDescriptions in manual inserted
  • Tutorial for import wizard in manual extended
  • Miscellaneous error corrections
Features of the Client software 3.0.1.5, October 2nd, 2014 (Database 3.0.11)

New features and fixes:

  • Import wizard for import of tabulator separated descriptors and descriptions lists
  • Miscellaneous error corrections
Features of the Client software 3.0.1.4, August 29th, 2014 (Database 3.0.10)

New features and fixes:

  • Export of tabulator separated descriptors list
  • View and edit of copyright information for resources inserted
  • SDD import and export for resource copyright information inserted
  • Miscellaneous error corrections
Features of the Client software 3.0.1.3, July 25th, 2014 (Database 3.0.10)

New features and fixes:

  • Export of tabulator separated descriptions list
  • Additional display functions in description tree view
  • Miscellaneous error corrections
Features of the Client software 3.0.1.2, June 12th, 2014 (Database 3.0.9)

New features and fixes:

  • Improved editing functions for descriptor trees
  • Miscellaneous error corrections
Features of the Client software 3.0.1.1, May 9th, 2014 (Database 3.0.9)

New features and fixes:

  • Extended compatibility in SDD and DELTA file generation
  • Correction in DELTA import and export for quantitative summary data
  • Corrected calculation of descriptor dependencies
  • Miscellaneous error corrections
Features of the Client software 3.0.1.0, March 17th, 2014 (Database 3.0.9)

New features and fixes:

  • Administration of user specific access rights introduced
  • (New) database roles introduced
  • Connection to DiversityProjects introduced
  • Accelerated data loading
  • Read-only access depending on user and project
  • Improved handling in case of database version mismatch
  • Corrected linkage to other DiversityWorkbench modules
  • Miscellaneous error corrections
Features of the Client software 3.0.0.10, February 26th, 2014 (Database 3.0.8)

New features and fixes:

  • Corrections in DELTA import and export
  • Corrections in SDD import and export
Features of the Client software 3.0.0.9, February 12th, 2014 (Database 3.0.8)

New features and fixes:

  • Endless loop in DELTA import fixed
  • No state insert for new descriptors fixed
Features of the Client software 3.0.0.8, January 13th, 2014 (Database 3.0.8)

New features and fixes:

  • Import and Export of SDD/DELTA completed
  • Conversion of SDD/DELTA inserted
  • Copy functions inserted
  • Miscellaneous error corrections
Features of the Client software 3.0.0.7, September 10th, 2013 (Database 3.0.7)

New features and fixes:

  • First published version of DiversityDescriptions 3

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).

Previous versions

Database server




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.