Diversity Collection
Download
Upcoming version
4.4.12 (2024-??-??)
Statistics
- Design bugfix showing images of project taxa
Database updates
DiversityCollectionUpdate_020645_to_020646
Collection - new type rack
Current version
4.4.11 (2024-04-22)
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
Previous versions
4.4.10 (2024-04-18)
Redesign of IPM- Several bugfixes in Statistics and additional tab for taxon hierarchy
4.4.9 (2024-01-18)
-
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)
- 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)
- Bugfix setting password
4.4.6 (2023-09-01)
- Statistics with progressbar and state information for project and error report.
- Bugfix in enumeration administration
-
Setting the datawithholding reasons for the current project 
- 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)
EventSeries
Descriptors for the event series 
Date supplement included
Agents (collector, responsible for identification, …): Showing valid name retrieved from DiversityAgents
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 -
bavarikon export: Date with 10 places and Permlink added
-
Maintenance:
Synchronisation with DiversityReferences - obsolete tables removed- Correcting sequence of collectors
-
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
- http://media.snsb.info/Tutorials/DiversityCollection/Maintenance/TerminologieAbgleich.webm
- 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)
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
- http://media.snsb.info/Tutorials/DiversityCollection/Maintenance/SammlerZuordnen.webm
- 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 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
-
CacheDB
- Bugfix transferring project descriptors
4.3.244 (2023-02-27)
4.3.243 (2023-02-20)
4.3.242 (2023-02-14)
4.3.241 (2023-02-07)
4.3.240 (2023-01-31)
4.3.239 (2023-01-26)
4.3.238 (2023-01-12)
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:
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:
- 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:
,
- 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
-
- 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
- Optional exclusion of:
-
- 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 running parallel clients with same database connection
- Documentation:
4.3.244
- Several bugfixes getting connections
- New implementation for webservice IndexFungorum
4.3.245
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 .
- Context menu:
Adding current dataset.
Adding all datasets from the list.
Showing content of the list.
Clearing the list.
- Context menu:
- 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
- Hiding RowGUID by default
- Optional inclusion of RowGUID for tables where PK should be edited
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