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

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

• 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

• 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

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

• 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

• Documentation:
  • Generation of markdown files from html files
  • 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
  • In HTML docu:
    • Optional exclusion of:
      • standard triggers
      • enumeration tables
      • deprecated columns
      • logging columns
      • obsolete
      • any column
    • Optional inclusion of table dependency
  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

• 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: Missing descriptions for tables, triggers, views, ... (Part 2);

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

• 19: New table AgentIdentifier;

• 25: New table CacheProjectDescriptor;

Package ABCD updates

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