Diversity Collection

Download

Current version

4.4.17 (2025-04-17)

Download

  • Transaction hierarchy: Fixed missing display of the transaction hierarchy.

4.4.16 (2025-04-14)

svn revision 6500 (DC), 6475 (DWB)

Version 4.4.16 no longer available - Please download the new current version

  • New material category core sample

  • Labelprinting: Fixed a problem when creating labels with author names starting with ‘de’.

  • GridView: Fix of an incorrect validation error when SpecimenID is contained in the display fields

  • Identification: Fix for the Issue “DC hangs after entering an identification and then switching to another field”

  • Deleting datasets: Fix for Issue “Menu entries/buttons are partially disabled after new data record is deleted”

  • CacheDB

    • ExecuteSqlSkalarInCacheDB - extention with optional check if data are present to avoid exception
      • several calls of ExecuteSqlSkalarInCacheDB including check
    • UserControlLookupSource
      • SubsetTable.TaxonCommonName
        • including columuns ReferenceTitle, LogUpdatedWhen
        • Version set to 3
      • SubsetTable.ScientificTerm: ExternalID added
        • Version set to 3
      • CompareLogDatePostgres - Check if any data exist
    • FormCacheDatabase
      • CreateSourceView: Check if source exists excluding procedures
      • UserControlLookupSource.SubsetTable.procTaxonNameHierarchy: SQL corrected
      • initDiagnostics: Test if anything is present
      • ScientificTerms: Fixed message
      • initTarget: Check existence

  • Datasets:

    • DatasetCollectionSpecimen: Column Problems in table CollectionSpecimen changed to nvarchar Max

Database updates

DiversityCollectionUpdate_020649_to_020650
  • ISSUE #14
    • CollectionSpecimen: Change Problems to nvarchar(MAX)
    • FirstLines_4: Change Problems to nvarchar(MAX)
    • FirstLinesPart_2: Change Problems to nvarchar(MAX)
    • FirstLinesUnit_4: Change Problems to nvarchar(MAX)
DiversityCollectionUpdate_020648_to_020649
  • New material category core sample
  • Function CollectionChildNodes optimized
  • 2 new indices for table Collection solving timeout problems in FormCollection when retrieving the collection hierarchy
DiversityCollectionCacheUpdate_010031_to_010032
  • TaxonCommonName
    • Removing PK of Table TaxonCommonName
    • Add columns ReferenceTitle and LogUpdatedWhen with default ‘1900-01-01 00:00:00’ to table TaxonCommonName
    • Changing size of column CommonName to 220 and column BaseURL to 255
    • Adding new PK to table TaxonCommonName including LogUpdatedWhen
  • ScientificTerm: Add column ExternalID
DiversityCollectionCacheUpdatePG_000019_to_000020
  • TaxonCommonName
    • Removing PK of Table TaxonCommonName
    • Add columns ReferenceTitle and LogUpdatedWhen to table TaxonCommonName
    • Changing size of column CommonName to 220 and column BaseURL to 255
    • Adding new PK to table TaxonCommonName including LogUpdatedWhen
  • ScientificTerm: Add column ExternalID

Cachedatabase updates

Postgres packages
  • ABCD 11:
    • abcd__unit_gathering: Formatting of the “DateTime_ISODateTimeBegin” field, in ABCD - DateTimeISO format.
    • encode_uri(text) - for encoding uris from https://stackoverflow.com/a/60260190
    • Adaption of ABCD_Unit with encoded RecordURI and strict ISODAteTimeFormat
    • abcd__measurementorfact: MeasurementDateTime format to ISO8601
    • ABCD_RecordBasis_MaterialCategories new mapping

Upcoming version

8.0

Database updates

DiversityCollectionUpdate_020649_to_020650
  • New material category core sample
  • Function CollectionChildNodes optimized
  • 2 new indices for table Collection solving timeout problems in FormCollection when retrieving the collection hierarchy

Previous versions

4.4.15 (2024-10-11)

svn revision 6274 (DC), 6271(DWB)

Download

  • Bugfix for adding a regulation to a list of specimens via menu Data-Transfer-ToTransaction
  • CacheDatabase: Bugfixes - Database updates (Postgres packages)
    • ABCD 10: Bugfix: set publisher of main project in citation field (in function abcd___projectcitation - restrict publisher to main project)
    • ABCD_BayernFlora 5: ABCD__BayernFlora_: Bugfix for problems with unique index “ABCD_Unit_Associations_UnitAssociation_pkey”

4.4.14 (2024-09-04)

  • internal interim release. Please download and use version 4.4.15!

4.4.13 (2024-08-09)

svn revision 6203, 6204

Download

  • Default for timeout for loading resources from web (e.g. images) set to 1 sec: TimeoutWeb in DiversityWorkbench.WorkbenchSettings.settings - TimeoutWeb.
  • Transaction:
    • Several bugfixes copying transaction within hierarchy: HierarchicalEntity.toolStripButtonCopyHierarchy_Click Line 364
    • Inclusion of request.
  • Bugfix setting analysis control.
  • Bugfix grid view - timeout for database included.
  • Query
    • Adding missing analysis and descriptor icon in query.
    • Adding filter options for collection task
  • Bugfix creating new collectors - restricted to specimen.
  • Bugfix editing internal relations.
  • Bugfix inserting geography for unit - restricted to unit.
  • Bugfix selecting parts for an exhibition
  • Event property
    • Bugfix in setUserControlModuleRelatedEntrySourceProperty
  • Maintenance
    • Synchronizing - Agents - Missing connection - Similar names
      • Bugfix: Removal of surplus % signs in update query.
    • Bugfix: Searching for referenced data: DiversityCollection.Forms.ReferencedDataFind Line 22693
  • Inclusion of table editor in form for collection event.
  • Exhibition including option for printing
  • Cache database
    • Optimizing upload of sources: DiversityCollection.CacheDatabase.UserControlLookupSource.TransferToCache(ref string Report, InterfaceCacheDatabase InterfaceCacheDB) Line 1512, 1850, 1953
    • Optimized messages for transfer of sources to Postgres
  • Collection
    • Query including logcolumns
    • Collection: Transfer to parent location based on location hierarchy

Updates in DWB Libraries

  • Import wizard with optional translation of \r\n in data into line break
  • Optional copy behaviour at program start

Database updates

DiversityCollectionUpdate_020646_to_020647
  • FirstLines_4: Optimized Query for IdentificationUnit
  • Enabling requests in transaction
  • New function CollectionEventSeriesHierarchySuperior
  • trgInsCollectionEvent - Bugfix
DiversityCollectionUpdate_020647_to_020648
  • Granting delete and update for Annotation to editor
  • Disable triggers for update of related tables Annotation and ExternalIdentifier
  • UserCollectionList - Inclusion of missing columns

4.4.12 (2024-06-17)

Download

svn revision 6136

  • Statistics
    • Design bugfix showing images of project taxa
  • Bugfix in specimen grid
  • Inclusion of optional setting for charts for queries linked to modules
  • Bugfix for 4 dll’s taken from wrong source
  • Query for missing regulations
  • CacheDatabase
    • Bugfix in CacheDB.SetTransferActive: Check existence of data in SourceTable to avoid exception
    • Bugfix in UserControlLookupSource.ReportFile: Path for file corrected
  • IPM: Redesign of collection hierarchy
  • Setting of user defined service for QR-Code generation.
  • Bugfix in FormCollectionSpecimen.PreSelectTreeNodeTableSequence: Checking for missing columns
  • Label print
    • QR-Code
      • Bugfix - missing QR-codes implemented
      • Bugfix generating QR-code for stable identifier
      • Bugfix generating QR-code for external identifier
      • Restriction to part labels
      • Inclusion of size in context menu to enable changing the default size (= 500)

Updates in DWB Libraries

  • A bufix in the import wizard changes the behaviour related to the import of the table Organism in part. Please use insert instead of merge to perform the previous results

Database updates

DiversityCollectionUpdate_020645_to_020646
  • Collection
    • new type rack
    • Redesign of collection location
      • CollectionLocation depending on column LocationParentID
      • CollectionLocationAll depending on column LocationParentID
      • CollectionLocationChildNodes depending on column LocationParentID
      • CollectionLocationMulti depending on column LocationParentID
      • CollectionLocationSuperior depending on column LocationParentID
  • Grants for StableIdentifier and StableIdentifierBase in case they are missing
  • procInsertCollectionEventCopy - include tables for Method
  • Trigger handling deletion of data tables Annotation and ExternalIdentifier
    • CollectionEvent
    • CollectionSpecimen
    • IdentificationUnit
    • CollectionSpecimenPart
    • CollectionSpecimenReference
    • Transaction
  • FirstLines_4: Adaption of length of LableTitle in Table CollectionSpecimen

Updates in DWB Libraries

4.4.11 (2024-04-22)

Download

  • Transaction
    • Several bugfixes when creating transactions.
  • Label print
    • QR-Codes: Changing from deprecated google api to SNSB service.
  • Statistics
    • Additional table for taxon images
  • Datawithholding reason for specimen shown in label and tooltip

4.4.10 (2024-04-18)

Download

  • Redesign of IPM
  • Several bugfixes in Statistics and additional tab for taxon hierarchy

Updates in DWB Libraries

4.4.9 (2024-01-18)

Download

  • Bugfix Transaction showing administrative collections

  • Bugfixes in Im- & Export (see DiversityWorkbench 4.2.12)

  • Bugfix in prepareToolStripDropDownButtonsEventLocalisation in main form and lookup table DtLocalisationSystem to ensure correct init of drop down list

  • Bugfix maintenance when removing orphaned identifier and annotiations

4.4.8 (2023-12-18)

Download

  • Several bugfixes for AccessionNumbers containing ' sign
  • Bugfix in FormCollectionSpecimen.fillSpecimen: testing dataset existence
  • Export
    • Bavarikon:
      • Including qualifier
      • bav18 removed
      • bav20 adapted
  • Maintenance
    • Events - Coordinates - Check geography: Bugfix setting cache values
    • Synchronizing Taxa - Families, Orders: Adding options to restrict to empty colums and taxa
  • Transaction
    • Balance: Bugfix in case of missing value for administrative collection
    • Redesign of handling regulations:
      • Display of title in interface
      • Display of documents in interface depending on permissions
      • Testing type of transaction before insert
  • ImportWizard
    • Analysis selection showing hierarchy and AnalysisID
  • Form for handling collection events

Database updates

DiversityCollectionUpdate_020644_to_020645
  • CollectionEventSeriesHierarchy: Add DateSupplement
  • CollectionEventRegulation: Add column TransactionID
  • Setting the relation for column TransactionID
  • Setting the values for the new column TransactionID
  • trgDelCollectionEventRegulation
  • trgUpdCollectionEventRegulation
  • Regulations: Deprecated objects in database
  • Relation between CollectionTask and Transaction
  • CollectionID in table CollectionSpecimen deprecated
  • CollectionChildNodes - optimized
  • Setting the select permission on sql_expression_dependencies for the Editor to enable imports
  • EventSeriesChildNodes - Description and Notes to nvarchar(max)
  • EventSeriesHierarchy - Description and Notes to nvarchar(max)

4.4.7 (2023-09-05)

Download

  • Bugfix setting password

4.4.6 (2023-09-01)

Download

  • Statistics with progressbar and state information for project and error report.
  • Bugfix in enumeration administration
  • Setting the datawithholding reasons for the current project Video starten
  • Bugfix transaction showing dates

Database updates

DiversityCollectionUpdate_020643_to_020644
  • CollectionAgent - removing IX_CollectionAgentSequence to ensure database backup
  • CollectionChildNodes - Adding missing columns
Cache database - Schema
DiversityCollectionCacheUpdateSchema_000035_to_000036
  • procPublishCount - inclusion of new tables
  • CacheProjectReference - Add column IsCitation
  • procPublishProjectReference - JOIN with CacheMetadata
Postgres - Schema
DiversityCollectionCacheUpdatePGSchema_000025_to_000026
  • New table CacheProjectDescriptor - Bugfix

4.4.5 (2023-08-17)

Download

  • EventSeries
    • Descriptors for the event series Video starten
    • Date supplement included
  • Agents (collector, responsible for identification, …): Showing valid name retrieved from DiversityAgents Video starten
    • Customize: Option for display of valid agent name included
  • Bugfix setting database
  • Bugfix setting series title in tree
  • Bugfix setting menu permission

Database updates

02.06.43

  • CollectionEventSeries
    • CollEventSeriesDescriptorType_Enum - Enumeration for series descriptor types including triggers and logtable
    • CollectionEventSeriesDescriptor - Descriptors for event series, triggers and log table adapted
    • New column DateSupplement including adaption of log table and trigger
    • Adaptions for functions - add DateSupplement:
      • EventSeriesSuperiorList
      • EventSeriesHierarchy
      • EventSeriesChildNodes
  • CollectionAgent
    • trgInsCollectionAgent adapted to synchron insert
    • disable IX_CollectionAgentSequence if present to ensure insert

4.4.4 (2023-07-25)

  • Cache database

    • Package Floraraster: Bugfix in script for functions floraraster__KartenRasterPunkte_tbl and floraraster__sippen_basis

  • Copy of dataset: Copy of event only included Video starten

  • bavarikon export: Date with 10 places and Permlink added

  • Maintenance:

    • Synchronisation with DiversityReferences - obsolete tables removed
    • Correcting sequence of collectors Video starten

  • Mainform - hierarchy nodes

    • Date changed to IsoDate and time removed if 0
    • Bugfix - adding missing color for table Analysis

  • Exhibition: Change to positive list for valid collection types

  • Spreadsheet:

    • TK-sheet includes hidden RowGUID for collectors by default
    • Bugfix for collector sheet

  • 4.2.5

  • Database updates

    • 02.06.42:

      • CollectionAgent - trgInsCollectionAgent adapted to synchron insert;
      • CollectionSpecimen.LabelTranscriptionNotes changed to nvarchar (MAX);
      • Grants for DataManager;
      • procCopyCollectionSpecimen2: Copy event only included;

    • Postgres packages

      • FloraRaster: Bugfixes in script

       

4.4.3 (2023-06-21)

  • Maintenance
    • Synchronization with DiversityScientificTerms included
    • Bugfix searching for vernacular terms missing a connection
    • References: Transfer data from deprecated for reference in tables CollectionSpecimen and Identification into new table CollectionSpecimenReferences
  • Documentation - Conversion of html to md and vice versa included
  • Main form - Entity adaptions of titles included
  • Enabling "-" sign in login name when creating logins
  • Bugfix removing logins
  • ImportWizard: Deprecated columns for reference in tables CollectionSpecimen and Identification removed

4.4.2 (2023-05-31)

  • Data.Table Bugfix for missing content
  • TableEditor: several bugfixes
  • Query: Bugfix for count conditions
  • Bugfix opening spreadsheet
  • Spreadsheet startup optimized
  • Switching between combobox and textbox for the lable title
  • Bugfix maintenance searching for agents missing a connection

 

4.4.1 (2023-05-22)

  • CacheDB
    • Bugfix getting column list of table
  • Maintenance
    • Bugfix retrieving names from DA including selection of valid names in case of not unique or ambigous names
    • Display of details in agent selection
  • Bugfix ModuleRelatedEntry
  • Testing server connection
  • Import wizard
    • Specimen with many identifiers
    • Restriction to datasource values enabled
  • Query: New options for selection of reverse relations
  • Main form:
    • Bugfix in tree for inverse relations
    • Bugfix getting ID of inverse relation

Database updates

  • 02.06.41: IdentifierSpecimen: Extension with column ReferencedTable to enable insert; CollectionEventLocalisation_Core: Excluding log columns and geography as String; CollectionSpecimenRelationInversList: Listing all internal relations in reverse perspective; CollectionSpecimenRelationInvers: Content of function CollectionSpecimenRelationInversList for improved performance; CollectionSpecimenRelationInternal: All internal relations irrespective of the direction;

 

4.4 (2023-05-05)

  • Maintenance
    • Bugfix splitting collectors including buttons for selection and deselection of items

4.3.249 (2023-05-03)

  • Maintenance
    • Bugfix splitting collectors including buttons for selection and deselection of items
    • Bugfixes synchronizing agents names missing a connection
      • Listing collisions in the like query and inspection of colliding datasets
  • Bugfix showing names for last updates
  • Bugfix creating logins
  • Bugfix for display text for part list
  • Bugfix in usercontrolModuleRelatedEntry: Setting the cursor to the original position after getting the autocomplete source
  • Bugfix wiriting reports for cacheDB transfer
  • CacheDB: Showing server processes

    • Database updates

      • 02.06.40: CollectionSpecimen_Core2: converting logging user from ID to Text

      • Postgres packages

        • ABCD 9: Bugfix abcd___projectcitation - restriction to main project
        • ABCD_BayernFlora: ABCD__BayernFlora_EndangeredSpeciesBase taxnr 3808 added
        • FloraRaster: Bugfix script, FloraRaster_EndangeredSpeciesBase taxnr 3808 added

4.3.248 (2023-04-20)

  • Ensure correct login and password entry
  • Bugfixes with webservices Index Fungorum and Tropicos
  • Bugfix remote query control
  • Bugfixes maintenance
  • Bugfix connecting to linked servers
  • Bugfix reading REST-services for DTN
  • Bugfix maintenance getting agents in text comparision
  • Export for bavarikon with optional separation of files and translation of countries

 

4.3.247 (2023-04-06)

  • Bugfix checking existence of ID in userControlModuleRelatedEntry

  • Index Fungorum - removing trailing year from name returned by xml result

  • Bugfix transfer previous settings

  • Bugfix setting TK25 map

  • Documentation:    

    • Bugfix showing context controls
    • Option for logo and metadata included
    • chm - including metadata

  • Database updates

    • 02.06.39: Missing grants for definition; Missing descriptions in enums; Missing descriptions for tables, triggers, views, ... (Part 4);

4.3.246 (2023-03-24)

  • Data - Export - XML:
  • Transaction:
    • Bugfix setting admin. collection
    • Chart for history
  • Bugfix getting information from DTN database located on linked server
  • Bugfix getting project data from DP
  • Bugfix in basic update script
  • Several bugfixes in restore for archive
  • Checking loops in unit hierarchy including selection for top unit

4.3.245 (2023-03-14)

  • Module related query:

    • Setting height of query form to current window
    • Several bugfixes connecting to CacheDB

  • Import wizard

    • Bugfix checking duplicates

  • Maintenance

    • Bugfix coordinate conversion

  • Documentaton

    • Several bugfixes creating index files from chm infos

  • Statistics

    • History of activity

  • CacheDB

    • Bugfix transferring project descriptors

4.3.244 (2023-02-27)

Download

4.3.243 (2023-02-20)

Download

4.3.242 (2023-02-14)

Download

4.3.241 (2023-02-07)

Download

4.3.240 (2023-01-31)

Download

4.3.239 (2023-01-26)

Download

4.3.238 (2023-01-12)

Download

4.3.216

  • Startup Window
  • New taxonomic groups for insects
  • Exhibition handling
  • Collection plans: Editing geometrie of locations

4.3.219

  • Locking of projects
  • Timeout for connections and startup
  • IPM: Automatic generation of tasks
  • Collection plans: bugfix
  • Administration of enumerations
  • Bugfix external identifier administration

4.3.2[20]

  • Query: Unit in part included
  • Bugfix editing enumerations (' handling included)
  • Timeouts optimized and bugfix for start timeout
  • Bugfix IPM chart
  • Button for setting IPM pests included
  • Collection editing - return to selected tree node after saving

4.3.2[21]

  • Bugfix IPM chart
  • IPM - Plan set to read only
  • Opt. orientation of images according to EXIF infos .
  • Bugfix showing EXIF infos
  • EXIF infos included in image selection

4.3.222

  • Import of Projects: optional restriction to matching type .
  • Maintenance: Bugfix synchronizing taxonimic names via text
  • Project hierarchy including icons corresponding to project type

4.3.223

  • Display of subcollection content redesigned .
  • Bugfix subcollections - exclusion of current specimen
  • Enable search for subcollection content
  • Transfer to collection with optional expansion to whole result list
  • Display plan in main form
  • Query for collection including plan and type

4.3.224

  • New columns RecordingDate und LocationGeometry for CollectionImage
  • New table CollCollectionImageType_Enum and type of image related to this table
  • Optional saving old plans as image including geometry
  • Bugfix collection manager
  • For Collection - Button to transfer all selected collections in a parent collection
  • Bugfix: Showing subcollection content for top level collections
  • Including EXIF information for CollectionImage
  • ImportWizard: Translation of values based upon a table in the database

4.3.225

  • Table editor for collection images added
  • Bugfix showing collection plan in main form
  • Detail images for IPM including position in main image
  • Several bugfixes

4.3.226

  • Connection to database - setting accept button to enable login without mouse actions
  • Query for DataWithholdingReasonDate included
  • Manual editing for Geography in tables CollectionEventLocalisation, CollectionEventSeries and IdentificationUnitGeoAnalysis
  • Spreadsheet with autosuggest
  • TableEditor with autosuggest
  • Starting form traks time for single steps
  • Import wizard: Optional translation of value for attachment
  • Connection menu with Reconnection option

4.3.227

  • CacheDB: Inclusion of AgentIdentifier in sources from DiversityAgents
  • Autosuggest for textboxes in main form
  • Several bugfixes in Event series grid
  • Bugfix query for external identifier: Obsolet query for type removed
  • Autosuggest for textboxes in Grids (Specimen, Images, Organisms, Parts, Collection events, Event series)
  • Progress info window while conneting to database
  • Connection to database: Databases restricted to list, selection within list enabled
  • Bugfix creating archives
  • Autosuggest: Optional exclusion of columns
  • Import wizard: Several bugfixes for translation table, reload of previous selected table, clearing content and reload after change of translation table

4.3.228

  • CacheDB: Bugfix package add ons
  • Startup: Bugfix optimizing messages

4.3.229

  • Query:
    • Removal of obsolet specimen identifier
    • No autocomplete for Count queries
    • Bugfix for Count queries for not optimized query
    • Bugfix preselection for optimized query in combination with count queries
    • Relation:
      • Type included
      • Internal included
    • UTM added
    • Bugfix preselection of nodes for fields checking presence of content
  • Cache database:
    • Diagnostics including search for corrupted NameURIs
    • Diagnostics including search for missing NameURIs
  • Maintenance
    • Bugfix converting coodinates
    • Conversion of UTM coordinates to WGS84 including rounding of values and grid zone
  • Spreadsheet
    • Bugfix starting event grid
    • Bugfix setting autocomplete
  • Bugfix Recording method for localisation

4.3.230

  • Bugfix editing coordinates
  • Submenue for collection and task complemented with superior entry
  • autosuggest in Specimengird changed to suggest

4.3.231

  • Processing duration changed to ISO format
  • Maintenance
    • Bugfix synchronizing agents via text
    • Bugfix synchronizing taxa via text
  • Multicolumns for main form
  • Startposition for event form corrected
  • Query
    • Bugfix for Count
    • Count with < and > operator
    • Collection event: Datawithholding included

4.3.232

  • Selection of material category and taxonomic groups can be restricted via project
  • Bugfix LookupTable: TaxonomicGroups including ParentCode
  • New form for project dependent enumerations
  • Form table editor with optional setting of column width
  • Menu:
    • new entries for editing project dependent enumerations
    • new entries for label type, taxonomic groups and material category within enumeration menu
    • new entries for editing tables LocalisationSystem and Property
      Customization - Projekte fuer TaxonomicGroups und MaterialCategories
  • Maintenance:
    • Bugfix synchronization text for taxa
  • Query:
    • Bugfix resetting booleans\

4.3.233, 4.3.234

  • Query: Bugfix for Labeltitle
  • Images: New button for display in WebView for Specimen, Event and Series
  • Grid: Bugfix copy
  • Bugfix setting printing restriction
  • Multicolumn sorting with position change
  • Bugfix setting display text for multicolumn query
  • Bugfix adding missing parameter to collection event method
  • Bugfix preselection of nodes
  • Data - getting PK for views via basic table
  • Bugfix deleting items in querylist
  • Bugifx setting display text for multicolumn selection
  • Bugfix adding items using multicolumn selection
  • Bugfix in generation of QR-Code for stable identifier
  • Bugfix setting tree node selection

4.3.235

  • Bugfixes in query for transactions with inaccessible documents
  • Bugfix getting PK for view
  • Setting of changes in main form due to permissions if restricted to changes in projectlist
  • Bugfix showing last editor of dataset
  • Autocomplete depending on source
  • Fixing of source : 4 Options
    • No fixing (local values for autocomplete)
    • Webservice (selection via combobox)
    • Database (values from local or remote database)
    • Cache database (values from data imported into cache database)
  • Loading of linked server datasources optional for faster start
  • Loading of translations optional for faster start
  • Fixing source from cache database as source for DiversityAgents, DiversityGazetteer, DiversityReferences, DiversitySamplingPlots and DiversityScientificTerms
  • Taxonlist: Restriction for timerange, Bugfix Export, Export including time restriction and analysis description
  • Transfer selected data to collection event series
  • Bugfix setting query results to restricted
  • Bugfix event series hierarchy
  • New button for removing event series
  • Harmonization of icon for event series
  • Clearing dataset in case of empty result list
  • Creation of index and keyword file from chm content
  • Optional restriction of displayed subcollection content for large collections
  • Bugfix connection administration
  • Redesign of module related entry using table layout panel
  • Administration of connections: Requery of database list
  • UsercontrolModuleRelatedEntry: Requery of local source
  • Bugfix FormLoginAdminGetProjects getting project databases
  • Bugfix Query list
  • Setting default for optimizing and remembering of query with context menu
  • Collection with many order query and type and description as new order columns
  • Bugfix showing dates in many order columns query
  • CacheDB: Inhibit loading of source views or sources when loading of conncetions is set to no.
  • Documentation: Final message and Button for opening folder containing html file
  • Form remote query: Bugfix for query in context of many order columns
  • Bugfix setting toolbar permissions
  • Bugfix showing and revoking of display of accepted names

4.3.236

  • Cache database:
    • New table for project descriptor
  • Bugfix Multicolumns in Query
  • Creating markdown for index and keywords in manual
  • Bugfix creating index files for manual
  • Index and keyword files with css instead of font
  • Bugfix export wizard

4.3.237

  • Bugfix not optimized query in combination with many order columns
  • Query including Depth
  • ExportWizard including Depth
  • Bugfix setting Identification
  • Bugfix getting next and previous items in query for many order columns
  • Bugfix inserting missing identity column in query for many order columns
  • Bugfix Taxonlist: Several identifications produced wrong sums - restricted to last identification
  • Bugfix maps: Browser control replaced by WebView2 due to trouble with Google API
  • Old browser removed from map control
  • Bugfix usercontrolModuleRelatedEntry - Control had not been set properly in all events
  • Collection:
    • Hiding hierarchy and restiction of hierarchy to parent datasets resp. parents including children
    • Bugfix building hierarchy
    • Bugfix closing form

4.3.238

  • Redesign for prometheus API
  • Bugfix collection hierarchy
  • Bugfix Archive creation
  • Bugfix getting coordinates from GoogleMaps
  • Bugfix system tools: setting description for views
  • Bugfix predefined queries
  • Maintenance:
    • Removal of orphaned relations
    • Bugfix retrieval from Geonames
    • Bugfix comparing Coordinates for TK25 using source from linked server
  • Documentation - listing objects and HTML:
    • New button for selection of default choise of database object
    • Bugfix for function
    • Bugfix for showing definitions for views
  • Cache database
    • System tools included
    • Adaption of SystemTools for handling CacheDB

4.3.239

  • Redesign of xaml control for plans
  • Tableeditor with trimming of content
  • Bugfix sorting collectors
  • Bugfix showing GoogleMaps
  • Query:
    • Bugfix for predefined queries
    • Bugfix for ManyOrderColumns
  • Maintenance
    • Bugfix synchronizing agents with similar names
  • Database tools:
    • Description including trigger
  • Collection 
    • Several bugfixes showing hierarchy
    • Button to enable location
    • Button for display of part nodes in Collection tree
    • Setting minimal height for collection plan

4.3.240

  • Documentation:
    • Bugfix by reducing open connections
    • Bugfix getting description of parameter of function
    • In HTML docu:
      • Bugfix getting parameter description of functions derived from basic objects
      • Bugfix listing depending objects
  • Collection: ,
    • Button for switching between administrative and location hierarchy in main form
    • Bugfixes setting image
    • Setting default type for new collections depending on parent type
  • Bugfix searching localities in GoogleMaps
  • Query:
    • Bugfix setting text for multicolumn query
    • Bugfix setting table for query column
    • Bugfix setting text for core-views as main query table
  • Formfunctions:
    • Bugfix filling table
    • Bugfix setting connection
  • Data.Routine - getting type of dependent objects

 

4.3.241

  • Collection:
    • Bugfixes showing Plans
    • Bugfix opening form with empty list
    • Bugfixes getting value for scale
    • Bugfixes setting scale
    • Bugfixes moving scale
  • IPM
    • Bugfix reading Prometheus sensors
    • Several bugfixes saving Prometheus apis
    • Sorting prometheus sensors
  • CacheDB
    • Bugfix opening project filter
    • Systemtools - separation of objects by schema
  • Bugfixes setting password
  • Enumeration administration
    • Bugfix setting images
    • Bugfix setting images in tree
    • Bugfix setting parent
    • Bugfix setting transparency of user defined images
    • Bugfix retrieving images from database
    • Bugfix removing entries
    • Bugfix setting forcolor
    • Bugfix setting transparency for images from database
    • Bugfix building menu hierarchy

 

4.3.242

  • Documentation:

    • Redesign for html controls
    • Html including css
    • Default selection of database objects
    • Notes containing information about excluded objects
      • Checkbox for optional inclusion of these notes
    • Bugfix setting exclusions
    • In HTML docu:
      • Optional exclusion of:
        • standard triggers
        • enumeration tables
        • deprecated columns
        • logging columns
        • obsolete
        • any column
      • Optional inclusion of table dependency
      • Generation of css files if missing

  • Database tools:

    • Button for filling table CacheDescription
    • Button for showing content of table CacheDescription

  • Old webbrowser replaced with new WebView in:

    • CacheDB Diagnostics and BioCASE
    • Database tools at EU DSGVO
    • Documentation: Chm conversion, markdown generation, content
    • FormAnalysis
    • UsercontrolGIS and Usercontrol_GIS
    • FormMaintenance
    • FormStatistics

  • Specimen grid:

    • Bugfix saving new dataset
    • Bugfix passing invisible columns
    • Bugfix adding parts
    • Selection of collection from form if missing

  • Customize display: Bugfix setting default collection

 

4.3.243

  • Query:
    • Bugfix remote query for lists in database, e.g. DST
    • New button to check ProcessID
  • Bugfix running parallel clients with same database connection
  • Documentation:
    • Home button linking to index.html
    • Favicon for sites
    • Bugfix retrieving column description for views
    • chm conversion to html including standard css files
    • Documentation of enum tables

 

4.3.244

  • Several bugfixes getting connections
  • New implementation for webservice IndexFungorum

 

4.3.245

  • Documentation:
    • Generation of markdown files from html files
    • Bugfix generating semantic media wiki

 

 

Database updates

  • 02.06.24: new table CacheDescription; procFillCacheDescription; New collection types subdivided container and sensor; New taxonomic group artefact; New transaction type for warnings; New columns for geometry in table Collection and all depending objects; Grants for DataManager; New tables TaskType_Enum, TaskDateType_Enum, TaskModuleType_Enum, Task, Task_log including trigger; Functions TaskHierarchySeparator, TaskCollectionHierarchySeparator, TaskChildNodes, TaskHierarchy, TaskHierarchyAll; New tables TaskResult, TaskResult_log including trigger; new tables TaskModule, TaskModule_log and trigger; New tables CollectionTask, CollectionTask_log including trigger; Functions CollectionTaskChildNodes, CollectionTaskCollectionHierarchyAll, CollectionTaskHierarchy, CollectionTaskHierarchyAll, CollectionTaskParentNodes; New tables CollectionTaskImage, CollectionTaskImage_log, CollectionTaskMetric, CollectionTaskMetric_log including trigger;
  • 02.06.25: Update content in TaskType_Enum; CollectionTaskHierarchyAll including new column TaskDisplayText; CollectionHierarchySuperior including column Type; CollectionHierarchyAll using Acronym if present; New collection type trap; New task Types IPM and Pest; Disabling not used Task Types; Recreate CacheDescription; procFillCacheDescription - include entity;
  • 02.06.26: Task and all dependent objects: Adding column MetricUnit; Collection types for handling locations; Task types for treatment; ManagerCollectionList: optimizing and bugfix for child nodes; trgInsCollectionTask - use CollectionID if provided;
  • 02.06.27: New table CollTaskMetricAggregation_Enum; Table CollectionTaskMetric - Add column Aggregation; TaskType_Enum - adding type Battery (Charge of a battery) and Bycatch;
  • 02.06.28: trgInsCollectionTask - use CollectionID if provided; CollTaxonomicGroup_Enum: new taxonomic groups for insects; TaskType_Enum: new task exhibition;
  • 02.06.29: ProjectProxy: new column IsLocked; New view CollectionSpecimenID_Locked, CollectionSpecimenID_AvailableReadOnly - include CollectionSpecimenID_Locked; CollectionSpecimenID_ReadOnly - include CollectionSpecimenID_Locked
  • 02.06.30: New collection type area; New columns RecordingDate and LocationGeometry for CollectionImage; New table CollCollectionImageType_Enum;
  • 02.06.31: CollectionTaskImage: new column ObjectGeometry; CollUnitRelationType_Enum: new entry gall inducing; CollMaterialCategory_Enum: new entry pinned specimen; Collection: new column LocationParentID and LocationPlanDate - including all triggers and depending functions; New functions for secondary collection hierarchy: CollectionLocationChildNodes, CollectionLocationMulti, CollectionLocation, CollectionLocationAll, CollectionLocationSuperior.
  • 02.06.32: New LocalisationSystem UTM including description in Entity; New views CollectionSpecimenID_CanEdit and CollectionEventID_CanEdit;
  • 02.06.33: New tables ProjectMaterialCategory and ProjectTaxonomicGroup including trigger; procCopyCollectionSpecimen2: Bugfix for getting correct Specimen ID;
  • 02.06.34: CollectionSpecimen_Core2: Removal of LocalityDescription from Date; CollectionEvent_Core2 - new column for date; trgUpdCollectionSpecimen - Removal of obsolet part and adaption to DSGVO; Check new tables ProjectMaterialCategory and ProjectTaxonomicGroup including trigger; Check procCopyCollectionSpecimen2;
  • 02.06.35: EventSeriesChildNodes - Bugfix and optimizing; trgUpdCollectionSpecimen - Bugfix including trailing commands;
  • 02.06.36:: Missing descriptions for tables, views, ... (Part 1); Adding defaults in table TaskModule if missing; New entry Prometheus in TaskModuleType_Enum for IPM; New column PropertyURI in table CollectionSpecimenImageProperty including trigger;
  • 02.06.37: Removing user defined types to ensure compatiblity to SIARD; Missing descriptions for tables, triggers, views, ... (Part 2);
  • 02.06.38: CollectionLocation in case it is missing; TransactionList_H7 in case it is missing; New Collection Type hardware for e.g. network components; CacheDescription - add Columns Type and Schema; procFillCacheDescription - include System, Views, Procedures, Functions; Removing user defined objects to ensure compatiblity to SIARD; Missing descriptions for tables, triggers, views, ... (Part 3);
  • 02.06.39: Missing descriptions in enums; Missing descriptions for tables, triggers, views, ... (Part 4);

 

Cache Datebase Schema updates

  • 33: Table ProjectEventProperty for blocking Property; Transfer existing data into ProjectEventProperty; procPublishCollectionEventProperty - blocking EventProperty;
  • 34: procPublishCollectionEventLocalisation - fill Accuracy according to precision;
  • 35: procPublishProjectAgent - JOIN with CacheMetadata; procPublishProjectAgentRole - JOIN with CacheMetadata; New table CacheProjectDescriptor; procPublishProjectDescriptor; procPublishCount - include CacheProjectDescriptor;

 

Postgres datebase updates[]

  • 19: New table AgentIdentifier;

 

Postgres datebase schema updates[]

  • 25: New table CacheProjectDescriptor;

 

Package ABCD updates[]

  • 8: ABCD_ContentContact: Restriction to main project; ABCD_TechnicalContact: Restriction to main project;

 

Libraries - DiversityWorkbench

The chapters below describe features that are available in several modules of the Diversity Workbench resp. provided via a shared library like DiversityWorkbench.dll

DiversityWorkbench

Upcoming version

4.2.13

  • Export wizard
    • Bugfix searching for parent of start table
  • Query
    • Bugfix when QueryMainTableLocal is null

Current version

4.2.12

  • Import wizard
    • Bugfixes for duplicate check if no data are available
  • Export wizard
    • Bugfixes if no data are available in parent table
    • Showing generated SQL commands

Previous versions

4.2.11

  • Import wizard
    • Bugfixes for duplicate check for data containing ’ in values of checked column
    • Bugfixes for column pre- and postfix containing ’ in values
    • Option to prevent insert into column
    • Description for columns expanded and redesigned
  • Bugfixes setting linked servers
  • JsonCache: New interface for the modules containing a json summary for datasets

4.2.10

  • Webservice Catalogue of Life available
  • Several bugfixes

4.2.9

  • UserControlQueryList: Dropdownwidth for column selection set to 200 to ensure readablility

4.2.8 (2023-08-30)

  • UserControlQueryList - bugfix if for readonly no valid boolean expression is returned
  • Documentation
    • Bugfix - Listing objects
    • Bugfix - Setting title
    • Bugfix - Selecting schema
    • Bugfix init HUGO replacements

4.2.7 (2023-08-17)

  • Formfunctions
    • Bugfix missing command in function public bool initSqlAdapter(ref System.Data.SqlClient.SqlDataAdapter Adapter, string SQL, System.Data.DataTable Table)
    • Bugfix WorkbenchUnit in function public static string getDatabaseNameFromURI(string URI)
    • Bugfix Project.cs - using ViewBaseURL instead of function or linked server
  • Archive
    • Optional inclusion of log tables
    • Bugfixes resetting database
    • Several bugfixes getting data
    • Several bugfixes restoring archive
    • Progress bars included
    • Extension for setting specific query to get IDs for temp table

4.2.6 (2023-08-01)

  • Documentation
    • Bugfix listing objects
    • HUGO
      • Export of enumeration table content
  • Updating depending datasets Video starten.
    • Context menu:
      • Adding current dataset.
      • Adding all datasets from the list.
      • Showing content of the list.
      • Clearing the list.
  • Bugfix setting backlinks for DiversityCollection linked to DiversityAgents
  • Bugfix setting SQL for backlink updates
  • Bugfix setting backlinks for DiversityProjects linked to DiversityAgents
  • Bugfix setting images in tree of FormEnumAdministration
  • FormFunctions: public static string IsoDate(string Text, bool SpaceAsSeparator = true, bool RestrictToDate = false) expanded with optional restriction to date

4.2.5 (2023-07-25)

  • TableEditor:
    • Bugfix in initForm
  • Enumeration administration:
    • Table editor included
  • Agent - Bugfix getting synonyms in unit values
  • Formfunctions - Autocompletion - Bugfix missing Alias for table
  • Documentation
    • HUGO
      • Export as markdown for HUGO included
      • Replacements and adaptions for HUGO included
  • Spreadsheet:
    • Optional inclusion of RowGUID for tables where PK should be edited Video starten
    • Hiding RowGUID by default

4.2.4 (2023-07-12)

  • FormFunctions:
    • public static string IsoDate(string Text, bool SpaceAsSeparator = true)
  • Documentation:
    • Default output set to HUGO
    • HUGO output
      • Index removed
      • Application objects removed
      • ER-diagram located underneath table header
      • Bugfix ER-diagram path
      • Bugfix Enum output
      • Include menu icon

WpfControls

Current version

1.0.1

  • Bugfix rescanning image if values for height and width are missing
  • Showing message for button ShowDetail if no detail is defined