DWB clients for beta testing

The software versions below are for beta testing only, for regular releases appropriate for production environments see under the respective core applications and rich clients.

DiversityAgents

Download the Client software 3.0.0.19 a (zip archive), 2016/06/17

New features and fixes:

• Datawithholding reason for contact information

• Datebase updates:
  • Update database to version 02.01.09 Datawithholding reason for contact information

DiversityCollection - Manual

Download the Manual 3.0.8.7 (zip archive), 2016/07/15

Updated content

DiversityCollection

Download the Client software 3.0.8.7 zze (zip archive), 2016/09/16

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
• Allow annotations for read only data
• Separate list for read only projects Manual: Projects
• Managing controls according to read only noch testen, Manual: Tree specimen, Tree part
• Copy datasets with optonal inclusion of tables Manual: Copy dataset
• Labelprint - warning if LabelTemplates.xslt is missing Manual: Label
• 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 noch testen
• Bugfix in query of gazetteer data noch testen
• Bugfix for display of collection date in tree
• Display of subcollection content in tree Manual: Part
• Display first method and parameter for empty analysis in tree noch testen
• Label printing for collections Manual: Collection

• 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 Manual: Transaction
  • Date supplement inculded noch testen
  • Printing documents for return: Bugfix (Wrong inclusion of display order of units) noch testen

• 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 Manual: Table editor
  • Lookup tables with display values for optimized version
  • Display row numbers noch testen Manual: Table editor
  • 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 noch testen
  • Annotations and external identifier for event, part and unit noch testen
  • Updating tables with prefixed key values (e.g. LocalisationSystem): Bugfix
  • Part description included in specimen import noch testen

• Export wizard
  • Wizard for transaction
  • Part description included in specimen and part export noch testen
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Webservice CatalogueOfLife 2 - bugfix adding values

• Permission
  • Disabling outdated client

• Query
  • Bugfix in optimized query for missing entries
  • Additional display column Last update
  • Saving queries - beta version for optimized queries Manual: Queries saved
  • Including data from ReadOnly Projects Manual: Query result

• Label
  • Printing of QR-Codes Manual: Label

• Archive
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Export of tables Annotation and ExternalIdentifier: Bugfix noch testen

• Collection event
  • Query column CollectorsEventNumber added

• Replication
  • Tables CollectionSpecimenReference and ExternalIdentifier included
  • Tool for synchronizing RowGUIDs added Manual: Replication

• ExternalIdentifier
  • new form for type administration

• Regulations
  • new form for type administration Manual: Regulations

• Methods
  • ParameterID displayed

• Parts
  • Descriptions linked to DiversityScientificTerms noch testen, Manual: Modules, Part description
  • 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 + Bugfix
  • Synchronization of Sampling plots: Using temporary table for better performance
  • Synchronization of higher taxa: optimized performance
  • Check geography - synchronize values and cached values Manual
  • Entering regulation hints e.g according the Nagoya protocol noch testen, Manual: Maintenance regulations
  • Saving result of synchronisation with taxon sources noch testen
  • Synchronisation with linked taxa: Bugfix (tax. group has not been used for linked and local sources) noch testen
  • Synchronisation with linked taxa: Restriction to same genus and species noch testen, Manual: Maintenance

• Cache database
  • Inclusion of DiversityAgents as datasource
  • Checking transfer filter before transfer
  • Feedback button in transfer filter form
  • Tutorial for basic steps Manual: Cache database 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 noch testen

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 noch testen
    • Version 02.05.94: ProjectList including ReadOnly, new table CollectionSpecimenPartDescription + log + trigger, new column DocumentType in table TransactionDocument noch testen
    • Version 02.05.95: CollectionSpecimenID_ReadOnly - Bugfix, Descriptions for Recordbasis (as available), StableIdentifier - Bugfix noch testen
    • Version 02.05.96: Views Identification_Core2 & IdentificationUnit_Core2,GRANTs for ExternalIdentifier, CollectionSpecimenProcessingMethodParameter - RowGUID, procCopyCollectionSpecimen2 noch testen
    • Version 02.05.97: TransactionList, TransactionChildNodes, TransactionHierarchy: inclusion of DateSupplement; MaterialCategory DNA, lyophilised; ExternalIdentifierType: 2 master types - ID & Regulation; Function CollectionHierarchySuperiornoch testen

• 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

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

• • Packages
    • GUC
      • Version 5: Updated views
    • ABCD
      • Bugfix in skript ABCD_000007_to_000008

DiversityDescriptions

Download the Client software 3.0.1.17 c (zip archive), 2016/09/05 (Database 3.0.15)

New features and fixes:

• 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
• 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
• Miscellaneous error corrections

Download the special version for access to the taxon quiz database client software 3.0.1.4 e (zip archive), 2015/11/20 (Database 3.0.10 "Quiz")

New features and fixes:

• Enhanced form "Set taxon links"
• Prevent changes in scope table for proxy links to avoid interference with quiz application
• New form "Set taxon links" to supply quiz related data
• SDD import restores original resource/resource variant structure

DiversityProjects

Download the Client software 3.0.2.3 e (zip archive), 2016/07/25

New features and fixes:

• Table ProjectIdentifier
• Table ProjectReference - new Column ReferenceType
• Table editors for ProjectLicense, ProjectReference and ProjectIdentifier

• Database update to version 2.1.5: ProjectIdentifierType, -log and triggers, ProjectIdentifier, -log and triggers
• Database update to version 2.1.6: Change Citation in table ProjectReference into ReferenceType

DiversityReferences

Download the Client software 3.0.1.5 a (zip archive), 2016/07/28

New features and fixes:

• Import wizard noch testen, Manual
• Periodicals - bugfix

DiversityTaxonNames

Download the Client software 3.0.2.19 h (zip archive), 2016/08/04

New features and fixes:

• Import wizard: Bugfix importing analysis
• Insert of hierarchy after setting of genus Manual
• Selection of Genus restricted to selected project Manual
• Dropdownlist for selection of hierarchy expanded by rank and project Manual
• BasionymAuthorsYear and CombiningAuthors available for zoological names Manual
• References for synonyms and accepted names linked to DiversityReferences Manual
• Changed display for synonyms and accepted names esp. for ignored data Manual
• Query for reference for synonyms - bugfix

• Database Updates
  • Update to database version 02.05.23: Adding BasionymAuthorsYear to table TaxonName (+ log, Trigger), Transfer of YearOfPubl into BasionymAuthorsYear for recombinations of zoological names noch testen
  • Update to database version 02.05.24: HierarchyCache - Bugfix noch testen