DiversityCollection

From Diversity Workbench
Jump to: navigation, search
DiversityCollection © SNSB IT Center
DiversityCollection Import Wizard © SNSB IT Center


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

DiversityCollection is focused on the management of specimens in scientific collections and the handling of observation data. In this context it is designed to document any action concerning the collection, storage, exchange and treatment of specimens in a collection and is also appropriate to store observation data with analyses added. The Diversity GIS Editor is integrated. DiversityCollection is distinguished from other collection management systems by its focus on biological relations between organisms linked together as one or more specimens or observations (e. g., host, parasite, hyperparasite, symbionts, etc.). DiversityCollection keeps only data connected with the handling of collection specimens, parts of specimens and observations. Data of other realms like, e. g., taxonomy and references as well as scientific term systems and sampling plots are handled in separate modules. For an overview of the available DWB components see the Diversity Workbench Main Page.

Software

Online manual

The manual is provided as pdf file (for current version check DWB user manuals). The compiled help file in CHM (= MS online help format) is included in the zip archive with the download of the client application.

Client application

Current version

The current client application is built for Microsoft .Net Framework 3.5 or higher. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft .Net Framework).


Download the Client software 3.0.8.8 (zip archive), October 26th, 2016

New features and fixes:

  • Message for missing source of country list included
  • Stable identifiers - Administration of basic URL and type
  • Deleting specimen with optional removal of collection events
  • Copy datasets with optional inclusion of tables
  • Labelprint - warning if LabelTemplates.xslt is missing
  • Bugfix setting control sizes for superior data (event, unit)
  • Inclusion of end date in display text of hierarchy tree
  • TK25 - updated form for getting the coordinates
  • Bugfix in query of gazetteer data
  • Bugfix for display of collection date in tree
  • Display first method and parameter for empty analysis in tree
  • Remote source taxon names extended with typification and list information like analysis, distrbution etc.,
  • Shift of coordinates in GIS editor due to changes in GoogleMaps API: Bugfix
  • Customize display text of subcollection content
  • Statistics
    • Changed message and disabled controls if access to cache database is not available
    • Taxon analysis added
  • Adaptions to read only projects
    • Allow annotations for read only data
    • Separate list for read only projects
    • Managing controls according to read only
  • Collections
    • Display of subcollection content in tree
    • Label printing for collections
  • Transaction
    • Forwarding bugfix
    • Reminder bugfix
    • Bugfix query
    • Bugfix adapting the interface when changing the type
    • Taxonomic names in letters without year
    • Bugfix for list in sending letter with type informations
    • New column MaterialSource
    • New type removal
    • Document with types
    • Date supplement inculded
    • Printing documents for return: Bugfix (Wrong inclusion of display order of units)
    • Inventory: additional fields and data ranges included
  • Table editors:
    • CollectionSpecimenReference
    • Bugfix for optimized query getting values from system table #ID (sorting)
    • Bugfix for optimized query: reset system table #ID after changing database
    • Editor for IdentificationUnitGeoAnalysis
    • Geography shown in table (read only)
    • Table editors for event method and event method parameters
    • Export to SQLite
    • Lookup tables with display values for optimized version
    • Display row numbers
    • Removing values: Bugfix
  • Import wizard
    • Bugfixes for attachment etc.
    • Separate window to inspect schema
    • Tables CollectionSpecimenReference and ExternalIdentifier included
    • Start screen showing the current step
    • Description with display texts for values selected in interface settings
    • Suppressing import of dependent tables if parent tables contain no data
    • Bugfix updating tables with preset column values
    • Annotations and external identifier for event, part and unit
    • Updating tables with prefixed key values (e.g. LocalisationSystem): Bugfix
    • Part description included in specimen import
  • Export wizard
    • Wizard for transaction
    • Part description included in specimen and part export
    • Tables CollectionSpecimenReference and ExternalIdentifier included
    • Webservice CatalogueOfLife 2 - bugfix adding values
  • Permission
    • Disabling outdated client
    • Restriction of data from projects with read only access to addition of annotations
  • Query
    • Bugfix in optimized query for missing entries
    • Additional display columns Last update, Localisation system
    • Saving queries - beta version for optimized queries
    • Including data from ReadOnly Projects
    • Bugfix for SamplingPlots
  • Label
    • Printing of QR-Codes
  • Archive
    • Tables CollectionSpecimenReference and ExternalIdentifier included
    • Export of tables Annotation and ExternalIdentifier: Bugfix
    • Export as background process: Bugfix
  • Collection event
    • Query column CollectorsEventNumber added
  • Replication
    • Tables CollectionSpecimenReference and ExternalIdentifier included
    • Tool for synchronizing RowGUIDs added
  • ExternalIdentifier
    • new form for type administration
  • Regulations
    • new form for type administration
  • Methods
    • ParameterID displayed
  • Parts
    • Descriptions linked to DiversityScientificTerms
    • New material category DNA lyophilised
  • Maintenance
    • Retrieval for TK25 coordinates for linked server included
    • Synchronization of Taxa via text: Datasource ist kept in case of error, fuzzy search + Bugfix
    • Synchronization of Sampling plots: Using temporary table for better performance
    • Synchronization of higher taxa: optimized performance
    • Check geography - synchronize values and cached values
    • Entering regulation hints e.g according the Nagoya protocol
    • Saving result of synchronisation with taxon sources
    • Synchronisation with linked taxa: Bugfix (tax. group has not been used for linked and local sources)
    • Synchronisation with linked taxa: Restriction to same genus and species
  • Cache database
    • Inclusion of DiversityAgents as datasource
    • Checking transfer filter before transfer
    • Feedback button in transfer filter form
    • Tutorial for basic steps
    • Transfer to Postgres in temporary table first and afterwards in primary table (avoiding empty tables)
    • Transfer of sources to Postgres restricted to source views
    • Transfer includes optional test for updates in source resp. cached data
Please create a backup of your database if you did use annotations for references and identifiers as these will be transferred into new tables. References for collection events can not be transferred and should be entered in the table CollectionEvent directly
  • Database updates
    • Version 02.05.86: ProjectDataLastChanges, ExternalIdentifierType, Transfer into ExternalIdentifierType, ExternalIdentifier, Transfer of Annotation into ExternalIdentifier, Clear AnnotationType_Enum if possible
    • Version 02.05.87: CollectionSpecimenReference + log + Trigger
    • Version 02.05.88: Transfer of Annotation into CollectionSpecimenReference, Clear AnnotationType_Enum if possible
    • Version 02.05.89: Views for ExternalIdentifier (Transaction, Event, Specimen, Unit, Part)
    • Version 02.05.90: Columns StableIdentifierBase and StableIdentifierTypeID in Table ProjectProxy, function StableIdentifier
    • Version 02.05.91: Type removal for transaction, trgDelCollectionSpecimenReference - Bugfix, column MaterialSource in table Transaction ( + log and triggers) MaterialSource in view TransactionList and in functions TransactionChildNodes, TransactionChildNodesAccess, TransactionHierarchy, TransactionHierarchyAccess, TransactionHierarchyAll
    • Version 02.05.92: New views to allow access to read only datasets: CollectionSpecimenID_AvailableReadOnly, CollectionSpecimenID_Available CollectionSpecimen_Core2
    • Version 02.05.93: New view ProjectListNotReadOnly, CollectionEventID_AvailableNotReadOnly, CollectionEvent_Core2
    • Version 02.05.94: ProjectList including ReadOnly, new table CollectionSpecimenPartDescription + log + trigger, new column DocumentType in table TransactionDocument
    • Version 02.05.95: CollectionSpecimenID_ReadOnly - Bugfix, Descriptions for Recordbasis (as available), StableIdentifier - Bugfix
    • Version 02.05.96: Views Identification_Core2 & IdentificationUnit_Core2,GRANTs for ExternalIdentifier, CollectionSpecimenProcessingMethodParameter - RowGUID, procCopyCollectionSpecimen2
    • Version 02.05.97: TransactionList, TransactionChildNodes, TransactionHierarchy: inclusion of DateSupplement; MaterialCategory DNA, lyophilised; ExternalIdentifierType: 2 master types - ID & Regulation; Function CollectionHierarchySuperior
    • Version 02.05.98: CollectionSpecimenProcessing - remove default for ProcessingDate, Grants for CollectionSpecimenPartDescription
  • CacheDatebase updates:
    • Database
      • Version 01.00.17: Tables Agent and AgentContactInformation, procTransferAgent, procTransferAgentContactInformation
      • Version 01.00.18: IncludeInTransfer in tables AgentSource, GazetteerSource, ScientificTermSource and TaxonSynonymySource
      • Version 01.00.19: procProjectName, procUnitIDforABCD, Grant dbo to CacheAdmin
      • Version 00.00.20: adding missing views and extending with column LogCreatedWhen to enable filter for updates: ViewAnalysis, ViewAnnotation, ViewCollection, ViewCollectionAgent, ViewCollectionEvent, ViewCollectionEventLocalisation, ViewCollectionEventProperty, ViewCollectionProject, ViewCollectionSpecimen, ViewCollectionExternalDatasource, ViewCollectionSpecimenImage, ViewCollectionSpecimenPart, ViewCollectionSpecimenProcessing, ViewCollectionSpecimenReference, ViewCollectionSpecimenRelation, ViewExternalIdentifier, ViewIdentification, ViewIdentificationUnit, ViewIdentificationUnitAnalysis, ViewIdentificationUnitGeoAnalysis, ViewIdentificationUnitInPart, ViewMetadata, ViewProcessing
    • Schema updates
      • Version 00.00.15: CacheCollectionSpecimenReference, procPublishCollectionSpecimenReference
      • Version 00.00.16: CacheIdentificationUnitGeoAnalysis, procPublishIdentificationUnitGeoAnalysis
      • Version 00.00.17: CacheExternalIdentifier, procPublishExternalIdentifier
      • Version 00.00.18: StableIdentifier in CacheIdentificationUnitInPart, procPublishIdentificationUnitInPart, CacheIdentificationUnit and procPublishIdentificationUnit
      • Version 00.00.19: procPublishCollectionSpecimen inclusion of ExternalDatasourceID, CacheCollectionExternalDatasource, procPublishCollectionExternalDatasource
      • Version 00.00.20: procPublishCollectionEvent: DataWithholdingReasonDate + Bugfix
  • Cache database for Postgres:
    • Database:
      • Version 00.00.08: Tables Agent and AgentContactInformation
    • Schema updates:
      • Version 00.00.09: CacheCollectionSpecimenProcessing_pkey
      • Version 00.00.10: CacheExternalIdentifier, CacheIdentificationUnitGeoAnalysis, CacheCollectionSpecimenReference
      • Version 00.00.11: StableIdentifier in CacheIdentificationUnitInPart and CacheIdentificationUnit
      • Version 00.00.12: CacheCollectionSpecimenReference - bugfix, new table CacheCollectionExternalDatasource, CacheCollectionSpecimen adding ExternalDatasourceID
      • Version 00.00.13: new table CacheProjectReference
    • Packages
      • ABCD
        • Bugfix in skript ABCD_000007_to_000008
      • FloraRaster
        • Version 4: Extendig views for analysis: ..._EndemismusFuerBayern, ..._RoteListeBayern2003, ..._RoteListeDeutschland1996, ..._SchutzsstatusInBayern, ..._Schutzverordnung, ..._VerantwortungBayerns, ..._VerantwortungDeutschlands
      • GUC
        • Version 5: Updated views

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 already installed on your computer! (Check under control panel -> Software for Microsoft .Net Framework).

Download the Client software 3.0.8.6 (zip archive), May 30th, 2016

New features and fixes:

  • Webservices
    • PESI switched to productive version
    • Geonames included
    • Catalogue of life 2: bugfix
  • Specimen grid: Setting link for determiners - bugfix
  • Specimen images: Removing faulty XML from column Description during insert
  • Query:
    • Sets for project and taxonomic groups (AND for standard and OR and AND for optimized query)
    • Warning for changes in geography restriction after changing query options
    • Use optimizing by default + bugfixes
  • Archive:
    • Creating an XML archive of a project
    • Restoring an XML archive into an empty database
    • Resetting database to factory settings
    • Adminstration of schedule based archiving
    • Starting creation of archives as background process
  • Remote queries:
    • Setting of sources in main window with direct access to module databases
    • Setting of sources in main window with direct access to webservices
    • Gazetteers values - Bugfix
    • TK25 adapted to linked server
    • Description for web service options
  • Replication
    • with filter option for tables
    • ParameterValue_Enum included in replication
  • Analysis: Buttons to insert all used taxonomic groups and projects
  • Statistics:
    • Separated queries for project data
    • Queries for datawithholding reasons
  • Default text for storage location added
  • Table editor:
    • Bugfix in export
    • Analysis methods and parameter added
    • Optimized for optimized query
    • Bugfix for filter
    • Annotation added
  • Login administration: Managing permissions and group membership (for dbo)
  • Organism:
    • Modifier for number of units added
    • Bugfix in autocreation of identification
    • Taxonomic group spider added
  • Part: Bugfix for adding new parts
  • Displaying history: Bugfix
  • Labelprint:
    • Hierarchy derived from Gazetteers included
    • Coordinates with DegMinSec
    • Analysis including MeasurementUnit
  • Customize display: Overview for settings
  • Import wizard:
    • Redesign of schema description
    • Transaction: Tables TransactionAgent, TransactionPayment and Annotation added
    • IdentificationUnitID for attachment added
  • Export wizard:
    • Export NULL for empty values to SQLite
    • Interface with adaptable division
  • Localisation: Bugfix entering seconds for coordinates
  • Transaction:
    • Payment added
    • Agents added
    • IDs added
  • Maintenance
    • Synchonisation with DiversityTaxonNames: Several bugfixes and interface updates
    • Setting timeout: Bugfix
    • Searching and fixing missing and invalid collection dates
    • Synchronization with Gazetteers: Bugfix
    • Synchronization with Catalogue of Life 2: Bugfix
  • Methods:
    • Method marker added for analysis-, processing- and event method
    • Adding missing parameters for methods in analysis, processing and event
  • Cache database:
    • Transfer of data - Bugfix
    • Removal of source for taxa etc. - Deleting of data included
    • Single selection of steps for transfer
    • For transfer to Postgres: Comparing numbers in source and target
    • Cutting dataload into smaller chunks for high amounts of data
    • Allow to start application as backgroud process to transfer data
    • Export for packages as XML or SQLite database
    • Package GUC version 3
  • Database updates
    • Version 02.05.75: IdentificationUnitAnalysisMethod and -MethodParameter: Adding column MethodMarker
    • Version 02.05.76: CollectionSpecimenProcessingMethod and -MethodParameter: Adding column MethodMarker
    • Version 02.05.77: CollectionEventMethod and -ParameterValue: Adding column MethodMarker
    • Version 02.05.78: IdentificationUnit - Adding NumberOfUnitsModifier
    • Version 02.05.79: Procedure SetXmlValue for setting values in XML columns
    • Version 02.05.80: Procedure SetXmlValue - Bugfix, adding taxonomic group spider, adding missing columns to IdentificationUnit_Core
    • Version 02.05.81: Procedure SetXmlValue - Bugfix, procedure SetXmlAttribute
    • Version 02.05.82: TransactionCurrency, DateSupplement in table Transaction, TransactionPayment, TransactionAgent
    • Version 02.05.83: TransactionAgent_log + Triggers, TransactionPayment_log + Triggers
    • Version 02.05.84: ParameterValue_Enum - Preparation for Replication (add missing columns, log table and triggers), ProjectProxy - add CreateArchive, ArchiveProtocol
    • Version 02.05.85: TransactionPayment - missing columns, hide observation from material category
  • CacheDatebase updates:
    • Database
      • Version 01.00.14: TaxonAnalysisCategoryValue
      • Version 01.00.15: AcceptedNameSinAuthor in table TaxonSynonymy
      • Version 01.00.16: Adding Geography to ViewCollectionEventLocalisation, CollectorsAgentURI to ViewCollectionAgent, TransferProtocol and IncludeInTransfer to table ProjectPublished
    • Schema updates
      • Version 11: Optimizing procedures procPublishCollectionAgent procPublishIdentification to procPublishIdentificationUnitInPart, Adding columns NameID and BaseURL to table CacheIdentification
      • Version 12: Bugfix for procedures procPublishCollectionEvent and procPublishIdentificationUnit
      • Version 13: Geography in CacheCollectionEventLocalisation and procPublishCollectionEventLocalisation, CollectorsAgentURI in CacheCollectionAgent and procPublishCollectionAgent, CacheAnnotation, procPublishAnnotation, CacheCollection, procPublishCollection
      • Version 14: Bugfix procPublishCollectionEventLocalisation and procPublishIdentification
  • Cache database for Postgres:
    • Database:
      • Version 00.00.06: TaxonAnalysisCategoryValue
    • Schema updates:
      • Version 00.00.08: Geography in CacheCollectionEventLocalisation, CollectorsAgentURI in CacheCollectionAgent, CacheAnnotation, CacheCollection
    • Packages
      • ABCD
        • Version 9: Bugfix


Features of the Client software 3.0.8.4 (zip archive), February 29th, 2016

New features and fixes:

  • Export
    • Export wizard:
      • Scientific terms prepared for linked server
      • Information of DiversityProjects accessible
      • Annotations included, Bugfixes
      • SQLite export (for 64 bit only!)
    • List export with optional inner join
  • Import
    • Import wizard:
      • Description for schemata
  • Processing:
    • Methods included
  • Enum Administration
    • Material categories
      • Administration (adding, removing, hierarchy)
    • Taxonomic groups
      • Administration (adding, removing, hierarchy)
      • Menu for adding new organisms organized according to hierarchy
    • Retrieval types for data about organisms and their administration
    • Bugfix in enum administration form - error message when deleting linked entries fails
  • Setting of timeout for web resources and added or linked database connections
  • Login administration:
    • Removal of projects
    • Administration of database ownership
    • Removing projects from list - Bugfix
  • External identifier:
    • Adding and removing
    • Administration of identifier types
  • Link to gazetteer
    • User can choose between Hierarchy from Place to country and country to place
    • User can set separator for hierarchy
    • Maintenance adapted to new resources from DiversityGazetteers
  • Tables editors
    • Bugfix
    • Table editor for transaction
  • Maintenance: Adding accepted names where synonyms are used
  • Icon of depth in hierarchy: Bugfix
  • Selection of source for country list
  • Transactions - loans, sending - updated specimen list
  • Query: Selecting data in the main window in dependence of the restrictions in the query (Optimized query only)
  • Statistics: Summary for projects within query added
  • New version for webservice Catalogue of Life
  • Cache database: Processing included
  • Datebase updates:
    • Update database to version 02.05.69: CollectionSpecimenProcessing: Changing key to SpecimenProcessingID, adding tables MethodForProcessing, CollectionSpecimenProcessingMethod (+ ..._log) and CollectionSpecimenProcessingMethodParameter (+ ..._log) with triggers
    • Update database to version 02.05.70: New Annotationtypes (Identifier), Views for Annotations, Annotation_log + Trigger
    • Update database to version 02.05.71: Foreign key for relation to CollectionID, RowGUID for CollectionEventMethod, Default for RowGUID in CollectionEventParameterValue
    • Update database to version 02.05.72: Withholding images where data in Specimen, Agent, Unit or Part are withheld. Needed due to change in publishing policy in CacheDB, Icon Column for tables CollTaxonomicGroup_Enum and CollMaterialCategory_Enum, Fixing rounding problem for geography in CollectionEventLocalisation
    • Update database to version 02.05.73: public database as new relation type, new Table CollSpecimenRelationType_Enum, New Column RetrievalType in Table IdentificationUnit, Entries for retrieval types, Bugfix in update trigger of table CollectionEvent, adapting view IdentificationUnit_Core
    • Update database to version 02.05.74: Grant for CollRetrievalType_Enum, preparation for linked server: ViewBaseURL, ViewDiversityWorkbenchModule
  • CacheDatebase updates:
    • Update database to version 01.00.09: Views for published data: ViewCollectionSpecimenProcessing, ViewCollectionSpecimenImage (Datawithholding restricted to images)
    • Update database to version 01.00.10: Gazetteer, GazetteerSource, procTransferGazetteer
    • Update database to version 01.00.11: ViewIdentificationUnit - adding RetrievalType
    • Update database to version 01.00.12: ViewCollectionSpecimenProcessing
    • Update database to version 01.00.13: ViewProcessing
    • Schemata
      • Update database to version 8: CacheIdentificationUnit and procPublishIdentificationUnit - Adding RetrievalType
      • Update database to version 9: Table CacheCollectionSpecimenProcessing + procPublishCollectionSpecimenProcessing
      • Update database to version 10: Table CacheProcessing + procPublishProcessing
  • Cache database for PostgreSQL:
    • Update database to version 00.00.05: Table Gazetteer
    • Schemata
      • Version 4: CacheIdentificationUnit - Adding RetrievalType
      • Version 5: Table CacheCollectionSpecimenProcessing
      • Version 6: Table CacheProcessing
    • Packages
      • ABCD
        • Version 9: View ABCD__RecordBasis_NoPart, Adapting View ABCD_Unit
Features of the Client software 3.0.8.2, December 18th, 2015

New features and fixes:

  • New group TransactionUser - Can see transactions
  • Data template - bug fix for numeric values
  • Linked server, creation and administration
    • Depends on update of linked databases, e.g. DiversityTaxonNames needs update to version 2.5.19
  • Methods: several bugfixes in administration form
  • Parameters: bugfix in main form
  • Analysis:
    • several bugfixes in administration form
    • Analysis of parts removed from unit tree
    • Deleting including dependent methods and parameter
  • Import wizard:
    • Bug fixes (Methods and parameters, update)
    • Hiding column headers
  • Export wizard:
    • Annotations included
    • Positioning of file colums
  • Query:
    • Inclusion of 4 additional gazetteer entries
    • Collapsing and expanding the tree in the option window
    • Query fields for event and series images
  • Maintenance: Exsiccata synchronization - bugfix and linked servers included
  • Datebase updates:
    • Update database to version 02.05.65 (i.a. adding table AnonymCollector for transfer in cache database)
    • Update database to version 02.05.66 (i.a. adding group TransactionUser, Withholding for collection date)
    • Update database to version 02.05.67 (i.a. ssp. -> subsp., Cnidaria -> evertebrata, Trigger for trgUpdCollectionEventLocalisation)
    • Update database to version 02.05.68 (remaining Update Trigger suser_sname() instead of current_user )
    • Update database to version 02.05.69 (CollectionSpecimenProcessing: Changing key to SpecimenProcessingID, adding tables MethodForProcessing, CollectionSpecimenProcessingMethod (+ ..._log) and CollectionSpecimenProcessingMethodParameter (+ ..._log) with triggers)
  • Cache database (Betaversion for local cache database):
    • Source for scientific terms included
    • Datebase updates from version 00.00.00 to version 01.00.05 for installation of basic functions
      • version 01.00.00: Roles, DiversityWorkbenchModule(), ProjectPublished
      • version 01.00.01: Basic functions: BaseURLofSource, ServerURL, SourceDatabaseTrunk, SourceDatabase, HighResolutionImagePath, ProjectsDatabase
      • version 01.00.02: Testing the basic functions
      • version 01.00.03: TaxonSynonymy, TaxonSynonymySource, procTransferTaxonSynonymy
      • version 01.00.04: Views for published data: ViewCollectionSpecimen, -Agent, -Event, -EventLocalisation, -EventProperty, -Project, -Part, -Relation, -Unit, -Identification, -Taxononmy, -Analysis, -UnitAnalysis, -UnitInPart, -WithholdAgent, -WithholdPart, -WithholdUnit, -SpecimenImage
      • version 01.00.05: ViewCollectionEvent - inclusion of DataWithholdingReasonDate
      • version 01.00.06: ScientificTerm, ScientificTermSource, procTransferScientificTerm
      • version 01.00.07: new versions of TaxonSynonymy and TaxonSynonymySource, TaxonCommonName, TaxonList, TaxonAnalysis, TaxonAnalysisCategory
      • version 01.00.08: Subsets for TaxonSynonymySource and ScientificTermSource
    • Schema updates from version 0 to 5 for installation of basic functions
      • Version 1: Roles, ProjectLocalisationSystem, ProjectTaxonomicGroup, ProjectMaterialCategory
      • Version 2: Grants to views and tables of schema dbo
      • Version 3: Cache tables: CacheCollectionSpecimen, -Agent, -Event, -EventLocalisation, -EventProperty, -SpecimenImage, -Part, -Relation, -Unit, -Identification, -UnitAnalysis, -UnitInPart, -Metadata
      • Version 4: Procedures to publish the data: procPublishAnalysis, -Agent, -Specimen, -SpecimenImage, -Part, -Relation, -Event, -EventLocalisation, -EventProperty, -Identification, -Unit, -UnitAnalysis, -UnitInPart, -Metadata
      • Version 5: Bugfixes: CacheAnalysis, procPublishAnalysis, procPublishCollectionSpecimenPart, ProjectLocalisationSystem - adding Parsing method, procPublishCollectionEventLocalisation, procPublishIdentification, procPublishIdentificationUnit, procPublishIdentificationUnitAnalysis, procPublishIdentificationUnitInPart, procPublishCollectionAgent
      • Version 6: Adding BaseURL to Metadata, CacheLocalisationSystem
      • Version 7: Bugfix procPublishCollectionEventLocalisation, removal of ProjectLocalisationSystem
  • Cache database for PostgreSQL (Betaversion forPostgreSQL cache databases):
    • Datebase updates from version 00.00.00 to version 00.00.02 for installation of basic functions
      • Version 00.00.01: Roles, Grants
      • Version 00.00.02: TaxonSynonymy
      • Version 00.00.03: ScientificTerm, highresolutionimagepath(character varying)
      • Version 00.00.04: TaxonSynonymySource, TaxonCommonName, TaxonList, TaxonAnalysis, TaxonAnalysisCategory, new version of TaxonSynonymy
    • Schema updates from version 0 to 2 for installation of basic functions
      • Version 1: Roles, Cache tables: CacheMetadata, -SpecimenPart, -Specimen, -Agent, -Event, -EventLocalisation, -UnitAnalysis, -SpecimenImage, -Unit, -Analysis, -UnitInPart, -EventProperty, -Relation, -Identification
      • Version 2: Package
      • Version 3: BaseURL and LogLastTransfer in Metadata, CacheLocalisationSystem
    • Package FloraRaster
      • Version 2 for installation of basic views
      • Version 3 Views for TaxRef
    • Package ABCD
      • Version 2: Contact and Metadata
      • Version 3: Kingdom, RecordBasis, Unit_Type_1, Unit_Type, Unit_SpecimenUnit
      • Version 4: MultimediaObject
      • Version 5: UnitAssociation, GatheringAgent
      • Version 6: Gathering
      • Version 7: Unit, Measurement
      • Version 8: Mapping of project schema views in schema public
Features of the Client software 3.0.8.0, October 16th, 2015

New features and fixes:

  • JSTOR-Export: Bugfix
  • Replication: Bugfix
  • Display of the hierarchy for events: Bugfix
  • Copy specimen: Bugfix
  • Import wizard: Bugfix for calculation transformations and update
  • Selecting storage location: For option TAXA changed from organisms to identifications
  • Geoanalysis - Setting the date of geo analysis: Bugfix
  • Login administration: Overview for database
  • Feedback: Fields for topic, priority and date added, bugfixes
  • Collection event: New fields for verbatim locality descriptions and end date or collection event
  • Specimen images: New fields for license notes and URI
  • Creating new organisms include creation of an identification
  • Unit with datawithholding reason
  • Display order for specimen and part according to name, identifier or ID
  • Annotations
    • Adding annotations - Bugfix
    • Annotations displayed in overview trees
  • Transaction
    • Visibility restricted to roles StorageManager, CollectionManager, Admin
    • Bugfix in printing taxon list for inventary
  • Maintenance
    • Removing unrelated collection events: Bugfix
    • Compare contents of duplicates
    • Synchronize taxonomic names: Bugfix
  • Export wizard
    • Invers relations added
    • Filter for columns included
    • Extension of cutting transformation: Position or startpoint
  • Grid views
    • Loading time reduced
    • Grid for organisms of a specimen
    • Specimen grid: Bugfixes (e.g. setting unchanged data to updated)
    • Table editors for direct access to the data, including read only access to log tables
  • Statistics
    • Images added
    • Units in parts added
  • Cache database
    • The functionallity for the cache database (including PostgreSQL) has been removed from this version due to a basic redesign and will be available in an upcoming version
  • Database updates
    • Update database to version 02.05.59 (i.a. procCopyCollectionSpecimen - Bugfix, Specimen images extended by LicenseNotes and LicenseURI)
    • Update database to version 02.05.60 (CollectionEvent extended by LocalityVerbatim and CollectionEndDate, view for invers relation for export)
    • Update database to version 02.05.61 (Function for multi column query, optimizing function FirstLinesPart)
    • Update database to version 02.05.62 (Withholding specimen by default, withholding for units)
    • Update database to version 02.05.63 (Change default for logging columns from user to SYSTEM_USER)
    • Update database to version 02.05.64 (enable sorting by accession number of part)
Features of the Client software 3.0.7.8, March 20th, 2015

New features and fixes:

  • Relations: Buttons for adding relations for units and parts
  • Import wizard: Bugfixes
  • Adding up to 5 localisation classes/ terms from DiversityGazetteers: Bugfix
  • Accessing the module DiversityScientificTerms for properties
  • Cache database version 1: Export and administration of project list
  • Specimen grid: new columns for source, relation etc.
  • Transaction
    • Forwarding of specimens of a loan
    • Documents linked to websource
  • Maintenance
    • Adding identifications - Bugfix
    • Listing broken links for identifications
    • Synchronization of references with remote databases and search for matching titles
  • Images
    • Filtering for properties
    • Description restricted to EXIF, non EXIF content moved to image properties
    • Grid view for images
    • Inserting images - Bugfix
  • Update to database version 02.05.53 (i.a. changing trigger writing geography into CollectionEventLocalisation)
  • Update to database version 02.05.54 (i.a. Property - link to DiversityScientificTerms)
  • Update to database version 02.05.55 (i.a. List for cache databases)
  • Update to database version 02.05.56 (i.a. URL for Transaction documents, new hierarchy function for transactions)
  • Update to database version 02.05.57 (Transfer of non-EXIF data of specimen images to image properties)
  • Update to database version 02.05.58 (New source for specimen grid)
  • Update cache database version 01.00.00 (i.a. Table for published projects)
Features of the Client software 3.0.7.7, January 29th, 2015

New features and fixes:

  • History
    • Tables CollectionEventMethod, CollectionEventParameterValue, IdentificationUnitAnalysisMethod and IdentificationUnitAnalysisMethodParameter added
  • Grid
    • Source for country list: Getting list from database on remote server and bugfixes
    • Copy & Paste via Contr. + C and Contr. + V
    • Filtering of rows
    • Removing rows from grid
  • Login administration
    • Overview for activity on server
    • Overview for settings of login
    • Copy login including all settings and permission
    • Transfer settings and permissions between logins
    • Overview of Server processes
    • Overview of permissions of a user
  • Export
    • Wizard - first version of generic export
  • Maintenance
    • several Bugfixes
    • Optional inclusion of all informations of an identifiction during insert of a new name
    • Finding links or named areas to DiversityGazetteer
    • Synchronization of higher taxonomy with DiversityTaxonNames: Bugfix
    • Update of links to DiversityAgents in Transaction: Bugfix
    • Search for broken links of identifications
  • Geography
    • Display of all coordinates related to a specimen
    • TK25: Quadrant down to 1/512
    • Editing country: Getting list from database on remote server
    • Setting coordinates for organisms: Bugfix
    • Fixing maps during edition of a specimen
  • Other
    • Transaction: Bugfix
    • Replication: Bugfix
    • Statistics for Transaction
    • Connection administration: Enter missing password for added remote connections
    • Templates for specimen, part, organism, identification and collector
    • Copy specimen including additional projects, relations and multi copy
    • Properties for images: Bugfix
Features of the Client software 3.0.7.6, October 10th, 2014

New features and fixes:

  • Import Wizard
    • Inclusion of CollectionSpecimenID and CollectionEventID as attachment columns
    • Import of predefined translation tables
    • Check for lines missing in the database and save missing lines in a new file
    • Renaming of Errorfile during import
    • Display of position in file: Bugfix
    • Display of progess bar: Bugfix
    • Importing several collectors: Bugfix
    • New transformation type filter
    • Import of annotations
  • Maintenance
    • Synchronization with DiversityTaxonNames: Bugfix
    • Synchronization of higher taxa with DiversityTaxonNames: Checking changes in hierarchy included
    • Duplicates: Whole list or selected rows can be checked in database
    • Images: Sorting of images for a whole project according to URI or creation date
    • Synchronization with DiversitySamplingPlots: Inclusion of geography of parent plots
    • Explicit setting of timeout for queries
    • TK25 - change to new source DiversityGazetteer
    • Synchronize displayed text of organisms with last identification
    • Synchronize term and hierarchy with ScientificTerms
  • Transaction
    • Diverse bugfixes
    • Permit includes permitting institution
    • Collection managers - corretion of deviating windows logins
    • Deleting documents: bugfix
    • New type transaction group for grouping transactions
    • Customize sequence and display type of transactions for the specimen
    • Printing of images of scanned documents
    • New column recipient
    • Optional inclusion of date in displayed text
    • Return of loans will allways be recorded in the database. To avoid confusion, the temporary return lists have been removed.
    • The property "Actual date" for a loan is used for prolongations of a loan. The actual date of the return are documented in the explizit returns.
    • The property "Is on loan" for a record is not used any longer. It is replaced by the transfer of the record in an explizit return. To document the current state of the present parts, missing return transactions will be created and linked to the parts. The InternalNotes of all returns created hereby will contain the following content: Return inserted by program to replace the obsolete IsOnLoan by a explicit return transaction
  • Images
    • Zoom view (http://krpano.com/) for images included
    • Marking of an area for properties of specimen images
    • Sorting of images for a whole project via maintenance
  • Collection event
    • WGS84 coordinates from GoogleMaps: Adaption to new API
    • TK25: Data retrieval from DiversityGazetteer on remote server
    • Inclusion of biostratigraphy in collection site properties
    • Up to 5 named areas (DiversityGazetteer)
    • Form for searching collection events: Bugfix
  • Other changes
    • Removal of specimen: Bugfix
    • Volume history: Bugfix
    • History of Specimen part table: Bugfix
    • Start of program: Bugfix
    • Source for storage location can be defined by user
    • Relations can refer to parts and/or organisms
    • Search for geography: Bugfix
    • Statistics include summarized number of types
    • Setting of timer intervall for scan mode
    • Adding projects: separate button for inaccessible projects
    • History contains any deleted datasets
    • New taxonomic group: Amphibian
    • Database tools included (description of database objects, creation of logtables, triggers etc. - for expert staff!)
    • Login administration: Correction of deviating windows logins
    • Warning for duplicate accession numbers: Bugfix
    • Query: Methods for collection event and analysis added
    • Methods: Several bugfixes in administation of methods
    • Login administration: Improvements for login transfer between servers
    • Collection managers: Improvements for login transfer between servers
    • Adding methods for analysis: Bugfix
    • Transaction document: Display text for the documents added
    • Gazetteer: Up to 5 gazetteer related entries possible
    • Replication: Tables Method and Parameter added
    • Methods - deleting Parameter: Bugfix
    • Methods and parameter of analysis of organisms - Bugfix in display
    • Grid view for parts - filtering data: Bugfix
    • Grid view for organisms: Bugfix


  • Update to database version 02.05.49()
    • LabelTitle -> nvarchar(MAX)
    • Specimen image properties with geometry to mark areas
    • CollectionSpecimenRelation: Adding IDs for unit and part
    • Creating explicit returns for specimen in a loan transaction that are not on loan
For databases located not on the servers of the SNSB-IT-center: 
As this update includes changes of the data please ensure to make a backup of your database before running this script
The column IsOnLoan in table CollectionSpecimenTransaction for a record is obsolet. 
It is replaced by the transfer of the record in a explizit return. 
To document the current state of the present parts, missing return transactions will be created and linked to the parts. 
The InternalNotes of all returns created hereby will contain the following content: 
Return inserted by program to replace the obsolete IsOnLoan by a explicit return transaction
  • Update to database version 02.05.50
    • Adding transaction types permit and transaction group
    • Adding table for transaction comments
    • Update of function for transaction hierarchy and trigger of CollectionSpecimenTransaction
    • CollectionEventLocalisation -> 4 additional entries for gazetteer related datasets
  • Update to database version 02.05.51
    • Adding column Recipient to table Transaction
    • Adding column DisplayText to table TransactionDocument
    • Adding taxonomic group amphibian
  • Update to database version 02.05.52
    • Adding 4 additional entries for Named Areas (DiversityGazetteer)
    • Filling empty DisplayText in table TransactionDocument
    • Adding Biostratigraphy as new Property
Features of the Client software 3.0.7.4, May 22nd, 2014

New features and fixes:

  • Update button not shown to all users
  • "Catalogue of Life" is reachable again
Features of the Client software 3.0.7.3, April 29th, 2014

New features and fixes:

  • Update to database version 02.05.48
  • Transaction: Sending form optional with detailed specimen list
  • Wizard: Reading schema files: Bugfix
Features of the Client software 3.0.7.2, April 25th, 2014

New features and fixes:

  • Query:
    • Images - Search for creation responsible and date
    • Sampling plots - Inclusion depending on display mode
    • Inventary numbers in and out (Transaction)
  • Transaction:
    • Marking of transaction type in tree
    • Investigator - size of field changed from 50 to 200 characters
    • Changing of parent transaction
    • Permit, return and forwarding as additional types of transaction (Beta version)
  • Import Wizard:
    • Annotations for specimen
    • Translations in Schema - Bugfix
    • Progress bar included
  • Maintenance:
    • Synchronisation with DiversityAgents - Bugfix
    • Removing unrelated collection events - Bugfix
    • Synchronisation with DiversityGazetteer - Bugfix
    • Event methods: Addition of missing parameters
  • Scan mode extended for:
    • Accession number of specimen (= CollectionSpecimen.AccessionNumber)
    • ID of specimen (=CollectionSpecimen.CollectionSpecimenID)
    • Accession number of specimen part (= CollectionSpecimenPart.AccessionNumber)
    • Identfier of organism (= IdentificationUnit.UnitIdentifier)
  • Grid mode
    • Link of determiner to DiversityAgents - Bugfix
  • Specimen images (needs update to database version 02.05.48, otherwise images will not be visible):
    • Images can be ordered
    • Properties for images
  • Replication
    • Optional ignoring of conflicts for download and upload
    • Bugfix
  • Other Bugfixes
    • Adding Projects
    • Analysis result from list
Features of the Client software 3.0.7.0, March 31st, 2014

New features and fixes:

  • Images for event series, event, specimen and collection: Additional fields for Title, IPR, Creator, Copyright, License (for DB-Version 02.05.43)
  • Processing:
    • Adding methods and their parameters
    • Drag & Drop in part tree
  • Analysis:
    • Adding methods and their parameters
    • Listing by name
  • Maintenance:
    • Removal of unrelated event series with optional selection of single datasets
    • Synchronisation of geography with sampling plots including new high performance search and update
    • Synchronisation with DiversityTaxonNames on different server: Bugfix
  • Grid for specimen: Bugfix
  • Images: Upload of images - bugfix and restriction to valid accession numbers and projects
  • Statistics: Taxon data for query
  • Login administration: Several bugfixes
  • Adding of parts: Bugfix
  • Import wizard (new version): Beta version for event series, events, specimens, observations, analysis, collections, methods, processings, transactions
  • Administration of data withholding: Inclusion of parts and transfer of single datasets
  • Storage location: Current entry included in drop down list
  • Search for collection event: Bugfix
  • Remote query: Connection with different server - bugfix
  • Replication: Bugfix for differing logins
  • Collection administration: Bugfix when deleting collections
  • Transaction: Collection hierarchy in comboboxes displayed
  • Query: Restriction of autocomplete list according to restriction of query field
  • Geoanalysis: Entry of date changed to yyyy.mm.dd
Features of the Client software 3.0.6.21, January 9th, 2014

New features and fixes:

  • Import wizard: Bugfix
  • Query list:
    • Ordering by date - bugfix
    • Adapted to variable display size settings
  • Collection specimen: Reference details available (e.g. pages in a publication)
  • Collection event: Reference details available (e.g. pages in a publication)
  • Getting coordinates via GoogleMaps: Bugfix
  • Maintenance:
    • Adding links to the DiversityGazetteer
    • Synchronization with DiversityTaxonNames - restriction to 1 part and rank added
    • Synchronization with DiversityTaxonNames - restriction to names starting with given text
    • Synchronization with DiversityTaxonNames - optional inclusion of higher taxa of IndexFungorum
    • Synchronization with DiversityAgents - bugfix
  • Gridview for organisms - bugfix
  • Collection specimen: URI of dataset available
  • Update: Direct download of latest client version
  • Statistics: Bugfix
  • Transaction management: Bugfix
  • Images: Bugfix for older database versions missing Copyright informations for images
  • GIS-Editor: Bugfix for Windows 7 and Windows 8
Features of the Client software 3.0.6.20, November 18th, 2013

New features and fixes:

  • Login administration:
    • Setting of password for logins, Bugfix
    • Statistics for the activity of a login in all databases on the server
  • Palaeo database: Changing to another server was necessary as the previously used server of this webservice vanished.
  • Import wizard:
    • Insert of collection event data during an update that contains previously missing data for the colletion event
    • Preparation date - bugfix
    • Relation of organisms - bugfix
    • Update of agents - bugfix
    • Import of methods of collection events
  • Methods:
    • Administration of methods used for collection events, analysis and processing
    • Inserting methods and their parameters for collection events
  • Images: Transfer of EXIF informations of new inserted images into the description (needs exiftool.exe in application directory)
  • Removal of specimen from projects: Bugfix
  • Grid for collection events:
    • Accuracy for MTB added (for database version 02.05.40 or higher)
    • Deleting empty collection events
  • Maps: Migration to GoogleMaps Api Version 3
  • Catalogue of Life: Bugfix
  • Maintenance:
    • Synchronization with gazetteer - Bugfix
    • Synchronization with sampling plots - Bugfix
  • Data withholding: Central form listing all reasons for data withholding and enabling central changes
  • Database: Update to version 02.05.40
Features of the Client software 3.0.6.19, September 23th, 2013

New features and fixes:

  • Remote query: Keeping last selected database or webservice
  • Remote query: Bugfix for info window for names linked to IndexFungorum
  • Documentation for MediaWiki: Bugfixes
  • Transaction inventary: Printing specimen grouped by taxa, numbers or single
  • Transaction: Printing taxonomic names including qualifier
  • Maintenance: Storage with optional selection of datasets - bugfix
  • Maintenance: Synchronisation with DiversityReferences - bugfix
  • Maintenance: Synchronisation with DiversityAgents - bugfix
  • Grid for specimen: Removal of links for several lines
  • Copy of specimen: Search for next accession numbers with optional inclusion of parts
  • Removal from additional project for all selected specimen
Features of the Client software 3.0.6.18, September 13th, 2013

New features and fixes:

  • Administration of the database: Bugfix for setting of the published address (BaseURL)
  • Maintenance: Setting of family and order for taxa linked with IndexFungorum
  • Taxonomic names: Bugfix for the setting of the project for the query in the remote source
  • Import wizard: New columns for organims - Related unit, Relation type, Colonized part
  • Replication: Several publishers for replication with the local database are possible (for database version 02.05.38 or higher)
  • Resources: Display of non image resources
  • Transaction: Printing of inventary list enabled
  • Accession numbers: Combined search for the next free accession number in specimen and parts (for database version 02.05.38 or higher)
  • Maintenance: Bugfix in synchronization with DiversityAgents
  • Query: Bugfix in search for hierarchical entries
  • Query: Presence of sampling plots
Features of the Client software 3.0.6.15, August 9th, 2013

New features and fixes:

  • Maintenance: Bugfix for retrieval of taxonomic names from Index fungorum
  • Maintenance: Bugfix for retrieval via parts of taxonomic names
  • Maintanance: Bugfix for retrieval of coordinates for TK25 entries
  • Connection administration: Bugfix for removal of added connections
  • Removal of specimen: Bugfix
Features of the Client software 3.0.6.13, July 31th, 2013

New features and fixes:

  • Administration of the database: Renaming of the current database; setting of the published address (BaseURL)
  • GIS-editor: Bugfix for Windows 7
  • Maintenance: Retrieval of coordinates for TK25 entries
Features of the Client software 3.0.6.12, July 26th, 2013

New features and fixes:

  • Query: Ranges of dates, data withholding reason for parts, for analysis result search and compare as numeric values
  • Import wizard: Bug fixes
  • Grid specimen: Latitude and longitude of named area
Features of the Client software 3.0.6.10, July 17th, 2013

New features and fixes:

New features and fixes:
  • Import wizard: Forced import of empty data, import of Chronostratigraphy and Lithostratigraphy, bug fixes
Features of the Client software 3.0.6.9, July 16th, 2013

New features and fixes:

  • Links to sampling plots: Bug fix in remote query
  • Import wizard: Bug fixes
Features of the Client software 3.0.6.8, July 11th, 2013

New features and fixes:

  • Login administration - access to projects: Next to projects with full access, a second list now contains projects with READ ONLY access (for database version 02.05.35 or higher)
  • Collection administration: Transfer of parts of selected specimen into another collection
  • Import wizard: Reset, Bug fixes
Features of the Client software 3.0.6.7, July 5th, 2013

New features and fixes:

  • Ordering of query results descending and ascending
  • Unicode signs in query enabled
  • Kiosk mode
  • Bug fixes in the import wizard
  • Statistics for the query results
  • Copy collections including their hierarchy
  • Automatic adding of selected project for new analysis and processing
  • Transfer the parts of the selected specimen to a transaction includes the optional selection of a collection and a material category
  • Adding remote connections to the same database on different servers
  • Maintenance: Search for taxonomic names in remote database and with partial names

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


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

Previous versions (SQL-Server 2008 R2)

Database server



(See also DiversityCollection Information Models and General Download Notes.)