DiversityDescriptions

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

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

The domain of DiversityDescriptions covers the knowledge about descriptions of organisms and descriptions of any other item/ element/ entity, which is object of diversity 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 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).
  • 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.

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

Database version 3.0.10 is used as underlying data base for Quiz applications.


Software

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.1.28 (zip archive), 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



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