Difference between revisions of "DWB clients for beta testing"

New features and fixes:

• Bugfix setting agent display types
• Bugfix setting default projects
• Bugfix setting hierarchy OK (V. Sanz)

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

Updated content: Lims2Fims, Collection, Part, Transaction, Regulations, Customize, Table editor, Maintenance regulations, Modules, Part description, Cache database, Spreadsheet, Image description, ...

New features and fixes:

• User can not change password
• Call back if application should be closed
• Non biological taxonomic group (e.g. rock, mineral) connect to DiversityScientificTerms for a name thesaurus Manual: Identification, Organism
• Show or hide relation details
• Display of subcollection content: Bugfix
• Display of query fields: Bugfix
• Adding external identifiers to references
• Administration of Datawitholding for the collection date: Bugfixes
• Labelprint: TransactionTitle added
• Labelprint Bugfix: rank subsp. was not detected, infos from DiversityTaxonNames included, transactions did not appear in multilabelprint OK (C. Monje)
• Extension of remote sources with projects OK Manual: Customize - Settings (D. Triebel)
• Identification: bugfix when inserting default identifier URI without identifier OK
• Setting the resources directory (Administration - Resources directory) OK (P. Grobe); Manual: Customize
• TK25 - updated form for getting the coordinates, bugfix
• Distribution maps: Bugfix
• Display of analysis in overview including date and number OK
• Create stable identifier for whole database OK (T. Weibulat); Manual: Stable identifier
• Links to module entries for local databases - bugfix
• Choosing entry from linked modules via keybord and space key OK (A. Rosenbauer), Manual: Module related entry
• Analysis administration: several columns for query added OK
• Stock - removing enabled OK (D. Neumann)
• Setting timeout for database updates for Postgres only OKManual: Cache database packages [?]
• Showing processing ID in interface OK
• Adding analysis with more than 10 parallels: Bugfix OK (V. Sanz)
• Database tools: clearing the log tables OK; Manual: Database tools
• Database tools - creation of triggers: Bugfixes and improvements
• Adding analysis - automatic generation of numbers - Bugfix OK (V. Sanz)
• Restoring deleted dataset for a whole specimen including depending data OK (G. Rambold), Manual: History
• Deleting datasets: Bugfix (inclusion of method parameters) OK (V. Sanz)
• Overview for users within a project including roles and editing roles getestet, email V. Sanz, 06.10.2017 17:51 (T. Weibulat, 2017-06-12 14:30); Manual: Login administration
• Feedback for login administration changed to new version OK (T. Weibulat)
• Export for parts extended with methods and parameter OK (V. Sanz)
• Bugfix removing identification responsible OK (Reiner-Drehwald)
• Bugfix accessing read only projects OK (F. Raub)
• New material categories (mineral and earth science specimen, material sample) OK (T. Weibulat)
• Preselection of collection event OK (T. Weibulat, 14.7.2017)
• Collection with hierarchical query OK (V. Sanz, 18.7.2017)
• Bugfix creating log entries in table CollectionEventLocalisation noch testen (T. Weibulat, 14.7.2017) [?]
• Inclusion of webservice of MycoBank OK
• Inclusion of views and functions in database description OK (T. Weibulat, 08.07.2017)
• Inclusion of descriptions of colums of views in database tools getestet, email V. Sanz 09.10.2017 16:18 (T. Weibulat, 08.07.2017)
• Using timeout for filling tables - bugfix noch testen [?]
• Table editor: Wait cursor while saving data OK (A. Jandl, 7.8.2017)
• Display date in Feedback form OK (A. Jandl, 23.8.2017)
• Form for updating database with current version of feedback OK (9.10.2017)
• Setting of sources for identification: Bugfix Ok (V. Sanz, Email 9.10.2017 14:34)
• Inserting new collection in table CollectionManager to ensure access by creator noch testen (P. Grobe, Feedback 14.9.2017 13:14) [?]
• Adding missing parameters for a collection event method: Bugfix OK (V. Sanz, Email 11.10.2017 15:07)

• Images
  • Details for collection event images redesigned noch testen (T. Weibulat, 14.7.2017) [?]
  • Bugfix editing details of several event and series images noch testen (T. Weibulat, 14.7.2017) [?]
  • Bugfix setting type of event images OK (T. Weibulat, 14.7.2017)
  • Exif data for CollectionEventImages in interface included OK (T. Weibulat)
  • Warning if display order is not unique OK (V. Sanz, 4.8.2017)
  • Automatic increase of display order OK (V. Sanz, 4.8.2017)
  • Disable image data controls if no images are present noch testen(V. Sanz, 10.10.2017)

• Export wizard
  • Extended to 999 columns OK (V. Sanz, 12.7.2017)
  • Direct position setting enabled OK (V. Sanz, 13.7.2017)
  • Text boxes for columns with editor on dobble click OK (V. Sanz, 13.7.2017)

• Methods
  • Additional query field for Methods etc. OK (V. Sanz)
  • Message about replacement of tools OK
  • Removing method parameters OK (G. Rambold)
  • Form for Methods adapted (flexible width for parameter and sorting) OK (V. Sanz)
  • Blocking change of processing after adding of methods OK (V. Sanz, 2017-06-12 10:01)
  • Form for Methods - bugfix for adding processings OK (V. Sanz)
  • Resetting lookup tables when changing database (e.g. Methods) OK (V. Sanz)
  • Table editors or CollectionSpecimenProcessingMethod and CollectionSpecimenProcessingMethodParameter OK (V. Sanz)
  • Table editors or Analysis, Collection, Method and Processing OK (V. Sanz)
  • Export wizard for events: Bugfix and inclusion of database timeout getestet, email V. Sanz 12-10-2017 10:36 (C. Monje)
  • Table editors with copy & paste OK (V. Sanz)

• Creating copies
  • Copy part: optional inclusion of linked informations and generation of several copies OK (C. Monje)
  • Copy specimen: bugfix and inclusion of relations OK
  • Copy specimen: form keep settings for inclusion OK (A. Rosenbauer)
  • Copy datasets - bugfix in accession number creation OK (F. Raub)
  • Copy parts - Bugfix OK (A. Rosenbauer)

• Query
  • New option ∉: Exclude a list of values OK (M. Pallmann), Manual: Query
  • Fields for part description OK
  • External identifier - search for missing entries OK
  • Remember query condition values for main form and administration forms (analysis - transaction) getestet, email V. Sanz 12.10.2017 16:23 u.w. (G. Rambold), Manual: Query
  • Locality verbatim included OK (Feedback A.Jandl)
  • Fields for processing method parameter OK (V. Sanz)
  • Remember query condition values - Bugfix noch testen (G. Rambold) [?]
  • Bugfix in optimized query for presence getestet, V. Sanz email 13.10.2017 13:10 (T. Weibulat, 14.7.2017) [?]
  • Remember query condition values - Saving via context menu enabled noch testen
  • Field StockUnit added getestet, email V. Sanz 12.10.2017 17:21 (T. Schweizer, 21.7.2017)
  • New option ∈: Only values of a list OK (C. Monje, 26.7.2017), Manual: Query
  • Maximal length of list entries extended from 32767 to 2147483647 characters OK (C. Monje, 31.7.2017)
  • Setting query options: Bugfix OK (D. Triebel, 18.8.2017)
  • Additional fields for reference and identifier for reference OK (B. Klasen, 04.10.2017)

• Import wizard
  • Bugfix for unicode signs OK (C. Monje)
  • Bugfix for updates comparing geography values getestet, email V. Sanz 13.10.2017 14:45
  • Apply calculation on data in database (restricted to update and single transformation) OK (D. Neumann)
  • Transformation title - bugfix OK
  • Import PK with default - bugfix OK
  • Inclusion of CollectorsSequence in table CollectionAgent to ensure correct sequence OK (V. Sanz)
  • Collection import extended with CollectionID as attachment column OK (V. Sanz)
  • Import of date generated by transformations - bugfix noch testen (W. Reichert, 27.7.2017)

• Transaction
  • Printing documents for return: Bugfix (Wrong inclusion of display order of units)
  • Restriction of taxonomic groups in sending letters noch testen (V. Sanz)
  • Display of transactions in part tree: Bugfix
  • Counting loan months: Bugfix
  • Accessing optimized procedure sp_TransactionHierarchyAll instead of function TransactionHierarchyAll()
  • Hide or show hierarchy OK (C. Monje)
  • Hierarchy in query results noch testen
  • Bugfixes in transaction form noch testen
  • Hide or show specimen lists OK (C. Monje)
  • Bugfix when creating copy within hierarchy OK (V. Sanz)
  • Bugfix when creating a transaction including ' OK (I. Sebek, 30.8.2017)

• Maintenance
  • Synchronisation
    • Check geography - synchronize values and cached values Manual
    • Synchronisation with linked taxa: Bugfix (tax. group has not been used for linked and local sources)
    • Synchronisation with linked taxa: Restriction to same genus and species
    • Synchronizing places missing a connection with Gazetteer: Restriction to country nachgebessert, noch testen (V. Sanz)
    • Synchronizing with linked taxa: Bugfix nachgebessert, noch testen (V. Sanz)
    • Synchronizing coordinates with Gazetteer: Bugfix noch testen
  • Removal
    • Removal of unrelated events - redesign noch testen
    • Removal of unrelated annotations noch testen
    • Removal of unrelated identifier noch testen
  • Insert missing TK25 for WGS84 coordinates noch testen
  • Extending search for taxa in text search for whole name without authors from sp. to sp., agg., aggr. noch testen
  • Entering regulation hints e.g according the Nagoya protocol noch testen, Manual: Maintenance regulations
  • Inserting regulations, bugfix noch testen
  • Regulations with end date in query noch testen
  • Getting places from geonames: bugfix noch testen
  • Adding analysis on the basis of existing analysis OK (M. Ruff)
  • Comparing coordinates with geography optimized noch testen (T. Weibulat, 17.7.2017)
  • Unrelated series - bugfix and improvement noch testen (W. Reichert, 27.7.2017)
  • Check missing retrieval type for observations noch testen (T. Weibulat, 8.8.2017, Manual: Maintenance retrieval type)
  • Finding coordinates outside an area noch testen (Manual: Maintenance event coordinates)
  • Hiding pages for removal of events and series when permissions are missing noch testen
  • Call back for selection and deselection of names noch testen (M. Ruff, 29.8.2017)

• Cache database
  • Filter for content viewer noch testen
  • Inclusion of old version of cache database noch testen
  • Inclusion of new columns for Gazetteer and TaxonAnalysisCagegory noch testen
  • Direct access to datawithholding reasons for a project noch testen
  • Bugfix creating sources from DiversityGazetteer noch testen
  • Restriction of last date of changes in source data to not withheld datasets noch testen (T. Weibulat, 24.7.2017)
  • Transfer
    • Transfer of sources to Postgres restricted to source views noch testen
    • Transfer includes optional test for updates in source resp. cached data noch testen
    • Transfer of TaxonNameExternalDatabase and TaxonNameExternalID noch testen
    • Optimizing transfer to postgres noch testen
    • Transfer of packages with single step control noch testen
    • Transfer - view content: Bugfix noch testen
    • Transfer avoids intrusion in activ transfer noch testen
    • Scheduled data transfer reduced to one option. All settings done in the client noch testen
    • Setting of timeout and chunk parameters for the transfer noch testen
    • Transfer in chunks for SQL-Server transfer in temporary table noch testen
    • Transfer for Postgres in chunks redesigned noch testen
    • Bugfix transfering reference relators noch testen
    • Settings for scheduled transfer (day of week, time, filter, inclusion, protocol, errors) noch testen
    • Recursive transfer in chunks for Postgres transfer in temporary table noch testen
    • Transfer of chunk for Postgres enclosed in transaction noch testen
    • Check differences between source and cache DB (context menu for filter button) noch testen (T. Weibulat, 24.7.2016)
    • Transfer of data from temporary table to final table within Postgres in chunks noch testen (T. Weibulat, 8.8.2017)
  • Packages
    • Package Observation noch testen
    • Package GUC removed noch testen
    • Packages - avoiding collision of usage or schema public (ABCD) noch testen
    • Packages with date of last transfer noch testen
    • Views for packages placed in schema public in separate area for content control noch testen
    • Add-ons for packages (ABCD - BayernFlora) noch testen
  • Postgres
    • User administration in Postgres: Selection of Logins and Roles deselect entry in other list noch testen (9.10.2017)
    • Login Administration including Inherit in Properties, including properties for groups and permissions for logins noch testen
    • Bugfix connecting to Postgres database noch testen (T. Weibulat)
    • Activity in postgres database noch testen
    • Postgres datebase updates running with timeout for database (necessary for larger indices) noch testen
    • Bugfix setting reference sources after change of postgres database noch testen

• Spreadsheet
  • Betaversion for organisms, parts noch testen, Manual: Spreadsheets
  • Resources folder moved to home directory of user noch testen
  • Editing options prepend and overwrite instead of insert noch testen
  • Inclusion of ExternalDatasource, Collection, last analysis in Organisms sheet noch testen
  • Insert of CollectionEvent - Bugfix noch testen
  • Export removes tab and return signs noch testen
  • Language and context noch testen
  • Editing for columns with lookup sources enabled noch testen (T. Weibulat, 2017-06-21)
  • Copy and paste via clipboard OK (B. Klasen, 2017-07-21), Manual: Spreadsheet
  • Export removes tab and return signs noch testen
  • Clearing values - bugfix checking nullability noch testen
  • Removing returns and tabs from data when transferring data via copy & paste and clipboard noch testen (B. Klasen, 2017-06-24)
  • Bugfix for column filter noch testen (T. Weibulat, 27.7.2017)
  • Bugfix for column filter: disappeared for enum tables after editing in table form noch testen (V. Sanz, E-mail 9.10.2017 11:19)
  • Bugfix inserting result value for analysis in Organism sheet noch testen (P. Grobe, Feedback 20.9.2017 16:41)
  • Marking not null columns in table noch testen (P. Grobe, Feedback 20.9.2017 15:46)
  • SQL query retrieval noch testen (S. Seifert, 10.10.2017)
  • Requery after successful editing noch testen (P. Grobe, Feedback 20.9.2017 16:03)
  • Marking necessary columns noch testen (P. Grobe, Feedback 20.9.2017)

Database updates

• Version 02.05.99: Table Transaction: Column NumberOfUnits -> int; adding role CacheAdmin to CacheUser; New column TermURI in table Identification + trgDelIdentification, trgUpdIdentification; New taxonomic groups rock and mineral, procCopyCollectionSpecimen2 bugfix noch testen
• Version 02.06.00: StableIdentifier, Table CacheDatabase2 and transfer from CacheDatabase, procCopyCollectionSpecimen2 bugfix noch testen
• Version 02.06.01: sp_TransactionHierarchyAll, Grants for CollectionSpecimenPartDescription, updates for functions TransactionHierarchy, TransactionChildNodes, TransactionHierarchyAccess, TransactionChildNodesAccess, CacheAdmin inherits grants of CacheUser, trgUpdCollectionEventLocalisation bugfix noch testen
• Version 02.06.02: StableIdentifier: Enforce user to enter a value; NextFreeAccNr: Bugfix; tables, log tables and trigger for RegulationType_Enum, Regulation, CollectionEventRegulation, CollectionSpecimenPartRegulation and data transfer from ExternalIdentifier to these new regulation tables noch testen
• Version 02.06.03: procCopyCollectionSpecimen2: CollectionEventLocalisation including geography; New indices in Transaction: NonClusteredIndexTransactionTitle, NonClusteredIndexParentTransactionID, NonClusteredIndex_ParentTransactionID_AllColumns; NonClusteredIndexIdentificationUnitDataWithholdingReason in IdentificationUnit; adding CacheUser to User; procCopyCollectionSpecimenPart noch testen
• Version 02.06.04: StableIdentifier: Use StableIdentifierBase if present; CollectionSpecimenPartRegulation: Add Responsible; TransactionChildNodes - missing children included (in @IDs); Rename EUNIS noch testen

Please create a backup of your database if you did use regulations as the related tables will undergo a redesign. The data will be kept but external interfaces may need an adaption

• Version 02.06.05: Regulation - redesign, change of key etc.; Regulation: Add Status, ParentRegulation; CollectionSpecimenPartRegulation: Add Regulation, CollectionEventID; CollectionEventRegulation: fill column Regulation; Remove all relevant keys that have to be adapted and add the new keys for table Regulation, CollectionEventRegulation, CollectionSpecimenPartRegulation and apapt triggers of these tables noch testen (D. Neumann)
• Version 02.06.06: Deleting data via cascading relations: Bugfixes for delete triggers for tables with version documentation noch testen (G. Rambold)
• Version 02.06.07: TransactionChildNodes - more missing children included (in @IDs) OK (V. Sanz); NextFreeAccNumber: Bugfix getting the prefix OK (A. Rosenbauer)
• Version 02.06.08: Descriptions for Recordbasis; Inserting missing material categories OK (A. Rosenbauer)
• Version 02.06.09: procCopyCollectionSpecimen2: bugfix for part processing, methods and parameter OK (V. Sanz), NextFreeAccNumber: Bugfix generating leeding 0 for numeric part OK (F. Raub, 24.7.2017)
• Version 02.06.10: NextFreeAccNumber: New design including postfix for number; StableIdentifier: Bugfix using StableIdentifierBase if present; CollectionEventParameterValue: adding missing defaults for logging columns; Cleaning table CollectionEventLocalisation_log from copies of active data (These surplus data had been generated by a bug in the software); Cleaning geometry in table CollectionSpecimenImageProperty (These data can not be kept as the way of storing the geometry will be updated to an advanced mode. If you used this feature, please turn to us for a solution of converting the data); Grants for CollectionEventRegulation OK .
• Version 02.06.11: Description of database roles, procedures DeleteXmlAttribute, DeleteXmlNode, change links to DiversityExsiccatae to new location noch testen.

CacheDatebase updates

• Database
  • Version 01.00.21: adding tables TaxonNameExternalDatabase, TaxonNameExternalID
  • Version 01.00.22: adding tables ReferenceSource, ReferenceTitle, procTransferReferenceTitle, ReferenceRelator
  • Version 01.00.23: adding AgentURI in Agent, trgInsAgent, NameURI in Gazetteer, trgInsGazetteer, ReferenceURI in ReferenceTitle, trgInsReferenceTitle, ScientificTerm_PK, NameURI in TaxonSynonymy, trgInsTaxonSynonymy; ViewAnalysis: No restriction to project; Table ProjectTarget; ProjectPublished - Adding columns for scheduled transfer; AgentSource, GazetteerSource, ReferenceSource, ScientificTermSource, TaxonSynonymySource - Adding columns for scheduled transfer; AgentSourceTarget, GazetteerSourceTarget, ReferenceSourceTarget, ScientificTermSource SourceView -> 200, ScientificTermSourceTarget, TaxonSynonymySourceTarget, TaxonNameExternalDatabase: ExternalDatabaseName -> nvarchar(800), Removing constraints for LastUpdatedBy and LastUpdatedWhen in ProjectPublished noch testen
  • Version 01.00.24: TaxonAnalysis: Adding Notes, AnalysisValue -> nvarchar(max) noch testen
  • Version 01.00.25: rename ReferenceSource into ReferenceTitleSource, rename ReferenceSourceTarget into ReferenceTitleSourceTarget; TaxonAnalysisCategory: Adding AnalysisURI, ReferenceTitle, ReferenceURI; Target; Idx_Target; ProjectTarget: Change PK; ProjectTargetPackage; Gazetteer, ADD ExternalNameID, ExternalDatabaseID; GazetteerExternalDatabase noch testen
• Schema updates
  • Version 21: adding CacheProjectReference and procPublishProjectReference
  • Version 22: adding TermURI to table CacheIdentification, Grants for CacheCollectionExternalDatasource noch testen
  • Version 23: CacheMetadata - StableIdentifier; procPublishMetadata - inclusion of StableIdentifier noch testen
  • Version 24: procPublishMetadata - StableIdentifier optional, procPublishCollectionSpecimen - bugfix LogCreatedWhen noch testen
  • Version 25: CacheMetadata - CopyrightText -> 500; CacheMetadata - add ProjectTitle; procPublishMetadata - add ProjectTitle; CacheProjectAgent; procPublishProjectAgent; CacheProjectReference - add URI; procPublishProjectReference - add URI noch testen
  • Version 26: procPublishIdentificationUnit - optimzied noch testen

Cache database for Postgres

• Database:
  • Version 00.00.09: Tables TaxonNameExternalDatabase, TaxonNameExternalID
  • Version 00.00.10: Tables ReferenceTitle, ReferenceRelator
  • Version 00.00.11: AgentRole -> character varying(255), Agent adding AgentURI, Gazetteer adding NameURI, ReferenceTitle adding ReferenceURI, TaxonSynonymy adding NameURI, highresolutionimagepath -> case insensitive; TaxonNameExternalDatabase - ExternalDatabaseName -> 800
  • Version 00.00.12: TaxonAnalysis: adding Notes, AnalysisValue -> Text; TaxonAnalysisCategory: Adding AnalysisURI, ReferenceTitle, ReferenceURI; Gazetteer: ADD ExternalNameID, ExternalDatabaseID; GazetteerExternalDatabase noch testen
  • Version 00.00.13: highresolutionimagepath - case insensitive and inclusion of ZSM pictures noch testen
• Schema updates:
  • Version 14: CacheCollectionSpecimenProcessing: SpecimenPartID can be null noch testen
  • Version 15: CacheMetadata: new columun StableIdentifier noch testen
  • Version 16: Metadata - RecordURI if missing; PackageAddOn;
  • Version 17: Package - adding LogLastTransfer; noch testen
  • Version 18: CacheProjectAgent; Metadata - ProjectTitle if missing; CacheProjectReference - add URI noch testen
• Packages
  • ABCD
    • Update to version 10:
    • Update to version 11: ABCD__ReferenceRelators etc.
    • Update to version 12: ABCD_Unit: using lateral join for better performance, ABCD__RecordBasis: Adding preserved specimen etc. as MaterialCategory, ABCD_Unit_Gathering: Removing synecology, ABCD__...MultiMediaObject_Part: Changing Copyright to IPR, ABCD__ProjectReference: Limit 1
    • Update to version 13: ABCD_Unit_Gathering: date without - if missing day etc., ABCD_Unit_Associations_UnitAssociation: AssociatedUnitID 3 teilig analog UnitID, ABCD__Kingdom - inclusion of alga, ABCD__2_MultiMediaObject_NonPart: ID including restriction of image to unit, ABCD__3_MultiMediaObject_Part: ID including restriction of image to unit or part
    • Update to version 14: Indices for optimizing response time noch testen
    • Update to version 15: ABCD_DatasetGUID noch testen

ABCD: Redesign of the package. Please remove and insert the package again

• • • Update to version 2: Recreation of all objects, in parts as materialized view (M): abcd__latitude; abcd__longitude; ABCD__ReferenceRelators (1, 2, 3); ABCD__ProjectReference; ABCD_Metadata, ABCD_TechnicalContact; ABCD_ContentContact; ABCD_DatasetGUID; ABCD__RecordBasis_NoPart; ABCD__RecordBasis; ABCD__Kingdom; ABCD__1_Unit_Type_1; ABCD__2_Unit_Type; ABCD__1_MultiMediaObject_DisplayOrder; ABCD__2_MultiMediaObject_NonPart (M); ABCD__3_MultiMediaObject_Part (M); ABCD_MultiMediaObject; ABCD_MeasurementOrFact (M); ABCD_Unit (M); ABCD_Unit_Associations_UnitAssociation (M); ABCD__Country_ISO3166Code; ABCD_Unit_Gathering (M); ABCD_Unit_Gathering_Agents (M); ABCD_Unit_Gathering_Stratigraphy_ChronostratigraphicTerm (M); ABCD_Unit_Gathering_Stratigraphy_LithostratigraphicTerm (M); ABCD_Unit_SpecimenUnit (M); 10 functions for data transfer (for M) noch testen
  • GUC
    • Update to version 6
    • removed from packages
  • Observation: Update to version 2
  • FloraRaster
    • Update to version 5: FloraRaster__status updated and FloraRaster__status_flor_aktuell, FloraRaster__status_flor_korrigiert, FloraRaster__status_flor_orig removed noch testen
    • Update to version 6: FloraRaster_Fotos, FloraRaster_Kopfdaten: Completion of missing years, FloraRaster_Sippendaten: Analysis optional and NameID from Identification noch testen
    • Update to version 7: FloraRaster_Kopfdaten: including unschaerfe, FloraRaster_KartenRasterPunkte noch testen

Planned features:

• Distribution map:
  • Editing via distribution map (M. Ruff)
  • Setting symbols for a distribution map (M. Ruff)
  • Preset background map for a distribution map (M. Ruff)
• Several sampling plots for one event (M. Ruff)
• Extension of PK of table CollectionEventProperty to enable entry of several items from the same terminology (M. Ruff)
• Extension of PK of table IdentificationUnitAnalysis to enable bulk insert (D. Neumann)
• Marking image areas getestet, email V. Sanz 11.10.2017 16:36 (V. Sanz, 26.7.2017)

Updated contents: "Descriptor tree editing", "Description editing"

Modified contents:

• Menu
• Editing the project - Descriptor tree tab
• Import DELTA file
• Import SDD file
• Convert DELTA file
• Concert SDD file
• Module relaten entry
• Webservice - foreign sources
• Catalogue of Life - webservice
• Index Fungorum - webservice
• The Paleontology Database - webservice

New contents:

• MycoBank Database - webservice
• Pan-European Species directories Infrastructure - webservice

New features and fixes:

• Document generator:
  • Semantic media wiki:
    • Optional string replacement for descriptors and categorical states
    • Page names for categorical states now includes descriptor names
  • Media wiki:
    • Optional string replacement for descriptors and categorical states
• Descriptor tree editing in project mode:
  • Allow alphabetic sorting of descriptor nodes in trees and tree nodes
• DELTA import:
  • Store import mapping information during import
  • New update import for descriptors, categorical states and descriptions (label, abbreviation and details)
  • New update import for translated descriptors, categorical states and descriptions
• Form for database maintenance included
• Miscellaneous error corrections

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

New features and fixes:

• Sending feedback: Bugfix OK (D. Triebel, 20.8.2017)
• Display of images from foreign sources OK (D. Triebel, 20.8.2017)
• Image without automatic adaption OK (D. Triebel, 20.8.2017)
• Image folder removed noch testen (D. Triebel, 22.8.2017)
• Tools for database included noch testen
• Description for database included noch testen

New features and fixes:

• Insert of projects: Bugfix
• Export wizard noch testen; Manual: Export
• Setting resources directory noch testen; Manual: Directory for resources
• Setting stable identifier noch testen; Manual: Stable identifier
• LicenseID made visible noch testen
• Menu - bugfix showing menu Administration noch testen (I. Leininger, Feedback 2016-11-14 11:00)
• Saving changes in data - bugfix noch testen (T. Weibulat, Feedback 2016-18-05 11:19)
• New columns for table Project noch testen (T. Weibulat, 2017-07-24)
• New columns for table ProjectReference noch testen (T. Weibulat, 2017-07-24)
• Separated list for citations and references noch testen (T. Weibulat, 2017-07-24)
• New column Citation for references noch testen (T. Weibulat, 2017-07-24)
• New column Type for project description noch testen (T. Weibulat, 2017-07-24)
• Menu for database tools restricted noch testen
• Database tools - bugfix for descriptions of procedures and functions noch testen
• Database documentation - including views, procedures and functions noch testen (T. Weibulat, 2017-07-24)
• Automatic setting of agentsequence if missing noch testen (T. Weibulat, 2017-08-25)
• Labels for project noch testen (T. Weibulat, 2017-08-25)

Database updates

• Database update to version 2.1.7: Adding roles curator and author, grants for ProjectIdentifier and ProjectIdentifierType, Project -> nvarchar(255) noch testen
• Database update to version 2.1.8: Grants for ProjectIdentifier; StableIdentifier; Adding views for linked server: ViewBaseURL, ViewDiversityWorkbenchModule, ViewProject; Project_Core: cast(P.ProjectSettings as nvarchar(max)) for use in linked server noch testen
• Database update to version 2.1.9: Project: adding ProjectType; ProjectType_Enum; Adding types and update of present data; Adaption of trigger of table Project; ViewProject: adding StableIdentifier noch testen (T. Weibulat, 2017-07-24)
• Database update to version 2.1.10: Project: adding InternalDescription, PublicDescription, adaption of triggers and ViewProject; ProjectReference: adding IsCitation and URI, adaption of triggers; ProjectChildNodes - adding new columns; ProjectHierarchy - adding new columns noch testen (T. Weibulat, 2017-07-24)
• Database update to version 2.1.11: ProjectLabel including log table and trigger; New roles for Agent; Project - new description; new column ProjectDescriptionType in table Project, adaption of triggers ProjectChildNodes and ProjectHierarchy, ViewProject; ProjectReference: adding ReferenceCitation, adaption of triggers; ProjectReference: new description for IsCitation noch testen (T. Weibulat, 2017-07-24)
• Database update to version 2.1.12: Description of database roles; Description of storded procedures; Description of functions: BaseURL, DiversityWorkbenchModule, ProjectList, SettingHierarchyAll, etc.; Description of views; ViewDataCitation; ViewLiteratureCitation noch testen (T. Weibulat, 2017-07-24)

Planned features:

• Agents with several roles (D. Triebel)
• Enable opening resources (W. Reichert)

New features and fixes:

• Linking reference relators to DiversityAgents - Bugfix for display type of agent
• Import expanded with project noch testen (A. Jandl, 4.10.2017)
• RIS-Export: Bugfix noch testen (A. Jandl, 10.10.2017)

• Hierarchy for references

Database updates

• Version 02.00.09: ReferenceTitle - add ParentRefID; ReferenceChildNodes; ReferenceHierarchy

New features and fixes:

• Client adapted to read only access
• Creating terminologies: bugfix
• Query with hierarchy
• Linking terminologies to DiversityProjects
• Access to database tools restricted
• Type list for property values: Dedicated list of values for a property of a term in a terminology noch testen, Manual: Properties

Database updates

• Version 1.0.8: LanguageCode_Enum: adding Latin, Term: adding TermIdentifier
• Version 1.0.9: procRefreshHierarchyCache - optimized; trgUpdTerminologyProperty; trgDelTerminologyProperty; trgDelTerminology noch testen
• Version 1.0.10: corrections for column descriptions; TerminologyPropertyValue + log + trigger noch testen

New features and fixes:

• References
• Import wizard: References included, bugfix for update
• Archive: Create and restore archives for projects and reset of the database noch testen
• Replication of analysis: Bugfix
• Changing IsRecombination - bugfix for zoological names noch testen
• Display of infrageneric epithet - bugfix for zoological names noch testen
• Display of analysis values description
• History showing deleted data noch testen
• Resources directory noch testen
• Setting timeout for database noch testen
• Copy of analysis includes values
• Import of tax. names: Insert year in BasionymAuthorsYear for recombinations in Zoology noch testen
• Disable list user to edit names included in inaccessible lists noch testen
• Spreadsheet for TaxonName noch testen
• Inspection of DiversityCollection for linked Taxa OK (F. Raub)

Database updates

• Update to database version 02.05.25: TaxonNameReference, TaxonomicRank agg.
• Update to database version 02.05.26: TaxonNameListReference: TaxonNameListRefText -> 800, AnalysisCategoryHierarchyAll: Ensure that there are any entries that are parents, TaxonNameExternalDatabase: ExternalDatabaseName -> 800; TaxonNameReference: TaxonNameRefText -> 800; NonClusteredIndexTaxonNameListProjectID for TaxonNameList; NonClusteredIndexTaxonHierarchyHierarchyListCache for TaxonHierarchy; New columns ReferenceTitle, ReferenceURI in TaxonNameListAnalysisCategory, TaxonNameListAnalysisCategoryChildNodes and TaxonNameListAnalysisCategoryHierarchy
• Update to database version 02.05.27: trgUpdTaxonName: for Zoology do not rely on empty Comb.aut. for Recombination; AnalysisValue -> nvarchar(MAX) noch testen