DWB clients for beta testing

From Diversity Workbench
Revision as of 12:06, 19 February 2023 by Dagmar Triebel (Talk | contribs) (→‎DiversityDescriptions)

Jump to: navigation, search

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

The DWB open testing approach relies on direct and open communication between software developer and software tester. For reaching this goal it is recommended to use the feedback options directly implemented in the DWB software.

Ideally, the regular DWB user is motivated to check each new implementation set up as result of her/his own request. The color codes will guide the tester for checking newly implemented functions assigned with his/her name, e.g., red background color for tests pending, and support the developer during the process of implementation of the user feedback. Other color codes like the blue background color for features planned give an overview on the status of ongoing implementation tasks and are most relevant for the developer.


Color codes and legends

  • information for software tester
    • background color: red --> test pending
    • background color: grey, color red --> manual unchecked by tester
    • color: green --> tested
  • information for software developer
    • color: green --> tested
    • background color: lightcyan --> function has to be improved partially
    • background color: blue --> function planned, under progress
    • color: violet --> function blocked (e.g. because of missing test), replaced or postponed
    • color: orange --> function deferred
    • background color: grey, color yellow --> manual missing, unchecked or outdated
    • background color: grey, color: lightblue --> video missing or outdated


see http://de.aoc.wikia.com/wiki/AoC_Wiki:Farbtabelle

DiversityAgents

DA version for testing


The current client application is built for Microsoft .Net Framework 4.8. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft .Net Framework).


Download the Client software installer 4.1.34 (zip archive), 2022/04/13

New features and fixes:


Download the Client software installer 4.1.33 (zip archive), 2021/07/05

New features and fixes:

  • Main form
    • New startmode updatedatabase OK;
  • Images (see Manual, keyword Images)
    • Type included OK (T. Weibulat);
    • Sequence included OK (T. Weibulat);
    • Enable/disable control in dependence of images OK (T. Weibulat);
    • Data withholding reason included OK (T. Weibulat);
    • Reorganized to ensure visibilty for differing resolutions OK (T. Weibulat);
    • Blocking of withheld images;
  • Synonymy
    • Prevention of entry of undefined synonyms OK (A. Jandl, Feedback - 19.11.2020);
  • Contacts
    • Button for display of public contacts (For details see manual - kexword Contact) OK (T. Weibulat);;
  • Identifier for agents included OK, (T. Weibulat);
    • Administration of identifier types OK (T. Weibulat);
  • Descriptor OK, Grobe Peter, E-mail 29.04.2021 um 10:27 ;
    • Administration of descriptor types with link to DWB modules
    • Adding and editing descriptors
    • Inclusion in import wizard OK : Grobe Peter, E-mail 14.05.2021 um 19:10 ;


  • Search for back links from modules DC and DP included OK (T. Weibulat);
  • Hierarchy
    • Additional hierarchies included (For details see manual, keyword Hierarchy) OK (T. Weibulat);
    • Asking for transfer in other hierarchies if main hierarchy is removed OK (T. Weibulat);
    • All hierarchies show summary for the main hierarchy and other hierarchies (see manual for details - keyword Hierarchy) OK (T. Weibulat);
    • Button to exchange entry in other hierarchies with main hierarchy (see manual, keyword hierarchy) OK (T. Weibulat);
  • Resources for user placed outside program directory
  • Import wizard OK SMNS, A. Jandl, C. Dalitz, E-mail 20.10.2017 11:38)
    • Bugfix for insert in empty table with identity and insert trigger
    • AgentName as duplicate check
    • References and identifier included OK (28.10.2020 um 21:49, A. Jandl);
  • Archive
    • Administrate Archives noch testen;
    • Create Archive OK (T. Weibulat);
    • Clean database (Restoring default project DiversityWorkbench, ID = 0) noch testen;
    • Restore archive noch testen;
    • Create schema noch testen;
  • Documentation
    • Trigger and their definition included
    • Definition of functions and procedures included
  • Connection menu
    • Current server activity OK (M. Ruff);

Datebase updates

  • Update database to version 02.01.14: AgentExternalDatabase - Logging columns; AgentExternalDatabase_log; trgDelAgentExternalDatabase; trgUpdAgentExternalDatabase; AgentExternalID_log; trgDelAgentExternalID; trgUpdAgentExternalID; ProjectProxy - Add archive columns; AgentHierarchyOther AgentHierarchyOther_log, trgDelAgentHierarchyOther, trgUpdAgentHierarchyOther; AgentIdentifierType_Enum; AgentIdentifierType_Enum - adding types if missing; AgentIdentifier; ProjectProxy - add ProjectURI, CreateArchive and ArchiveProtocol if missing ;
  • Update database to version 02.01.15: AgentImageType_Enum; Add content: Logo, Portrait; AgentImage: Add Type, Sequence; trgDelAgentImage; trgUpdAgentImage;
  • Update database to version 02.01.16: Function AgentHierarchyAllSuperior; AgentHierarchyOther - add FOREIGN KEY for AgentParentID; AgentImage - add DataWithholdingReason; trgDelAgentImage - add DataWithholdingReason; trgUpdAgentImage - add DataWithholdingReason; PublicAgent; PublicImage; PublicReference; PublicRelation; PublicContactInformation4, PublicContactInformation3, PublicContactInformation2, PublicContactInformation1, PublicContactInformation0, PublicContactInformation;
  • Update database to version 02.01.17: AgentContactInformation_Public; PublicContactInformation - Change source to new function AgentContactInformation_Public; trgUpdUserProxy - remove PrivacyConsentDate if no consent is given;
  • Update database to version 02.01.18: procInsertAgentCopy - Bugfix and extension to new tables; New stored procedure SetUserProjects to set the project access for a user; AgentContactInformation_Public - bugfix Telefax; ViewAgentNames - create view if missing;
  • Update database to version 02.01.19: New table AgentDescriptor + Log + Trigger; new table AgentDescriptorType_Enum;
  • Update database to version 02.01.20: AgentDescriptor - FK for DescriptorType if missing;


Tests pending

Features already in regular DA release, but tests pending

To be checked by tester

Tests pending:


Planned features

Functions planned, to be implemented in one of the next DA versions

Planned features

Planned features:


DiversityCollection

DC version for testing

The current client application is built for Microsoft .Net Framework 4.8. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft .Net Framework).


Download the Setup for client software 4.3.239 (zip archive containing installer) 2023/01/26

New features and fixes:


Download the Setup for client software 4.3.203 (zip archive containing installer) 2021/12/02

New features and fixes:

  • Catalogue of Life webservice is offline. As soon as a replacement is available, it will be included
  • Mycobank webservice is offline. As soon as a replacement is available, it will be included
  • Main form
    • Creating descriptions in DD directly OK (I. Wendt)
    • Bugfix removing specimen from project
    • Bugfix creating methods for collection events OK (F. Raub)
    • Bugfix enabling image manipulation controls, image properties deactivated OK (D. Falkenberg)
    • Open separat window on double click in textboxes and check for length of text OK SMNS (A. Jandl)
    • Bugfix setting scanning option for DiversityDescriptions
    • Keeping size of locality fields OK (A. Beck)
    • Bugfix setting date for localisation (i.e. the date when the localisation of the event took place) OK (K.H. Rexer, R. Wissing)
    • Changing images noch testen (A. Beck)
    • Restriction of properties of collection events in dropdown button to selected property OK (F. Raub)
    • Predefined queries - test before execution and saving OK (A. Jandl, Feedback 28.04.2020 10:06)
    • Deleting parts - generate errorlog on failure OK
    • Checking sequence of collection dates OK
    • Dates for preparation and processing formatted as ISO-dates OK (B. Klasen, E-mail 2020-05-08 17:46)
    • Dates for event series formatted as ISO-dates OK (B. Klasen, E-mail 2020-05-12 09:41)
    • Several labels adapted OK (A. Jandl, E-mail 2020-05-19 17:06)
    • Open text on double click for image details added OK (A. Jandl, E-mail 2020-05-19 17:06)
    • Bugfix setting icons for datawithholding reason for event noch testen (T. Weibulat, E-mail 2020-06-11 17:19)
    • Sorting data sources OK (M. Ruff)
    • Bugfix setting event series OK (I. Wendt, Feedback 31.08.2020 16:21)
    • Additional option to display maps noch testen (W. Reichert, Feedback 25.11.2019)
    • Restart retrieval of coordinates in case of interfering clipboard action noch testen (A. Beck)
    • Bugfix creating collection events noch testen
    • Bugfix in retrieval of dependent terms noch testen
    • Bugfixes in Update scripts OK (R. Wissing)
    • Bugfix Administration External Identifier OK (B. Klasen, E-mail 2020-06-10 12:33)
    • Tab sequence in login window OK (SMNS, I. Wendt, E-mail 2020-02-28 16:04)
    • Analysis - usercontrol redesigned OK
    • Charts for query in DiversityTaxonNames and DiversityScientific Terms included noch testen
    • Remote query form for DiversityScientificTerms with hierarchy for selection of lists noch testen
    • New start mode singleunit OK
    • New start mode updatedatabase OK;
    • Several bugfixes for remote query to DST OK, F. Hentschel
    • Bugfixes adding external identifier OK, A. Jandl, Email 13.04.2021 um 18:19
    • Bugfixes setting links for part descriptions OK
    • Bugfix retrieving images OK
    • Bugfix retrieving terms from linked server noch testen
    • Creation of new database with current collation and recovery model simple noch testen
    • RichEditControl for editing DNA sequences noch testen
    • Copy datasets - limit set to 1000 OK, 28.07.2021 um 09:52 - Haas, Michael
    • Warning as new transaction type noch testen, C. Dalitz 20.10.2021, 07:38
  • Tasks and Collection Tasks
    • Tasks and collection tasks for handling any task within a collection e.g. IPM (integrated pest management) noch testen
    • Collection tasks including SpecimenPartID for direct access to specimen parts noch testen
    • Bugfix retrieving NULL image noch testen
    • ImportWizard for CollectionTask and Task noch testen
    • Spreadsheet for CollectionTask noch testen
    • Table editor for CollectionTask noch testen
    • Collection with floorplan and geometry noch testen
    • Connection to Prometheus noch testen
    • Floorplans included in CollectionTasks noch testen
    • Setting the scale for floorplans of collections noch testen
    • Multible dashboards for Grafana noch testen
    • Table CollectionTaskMetric for storing metrics (e.g. from Prometheus) noch testen
  • Label
    • LabelTemplates contain new template CollectionEndDate
  • Remote Query
    • Bugfix for added source databases
  • Maintenance
    • Merging equal events - Button for inspection and transfer of event data added OK (I. Wendt)
    • Synochronizing taxa - include taxonomic group only when visible
    • Bugfix setting timeout for Synchronization agents via text OK (M. Ruff)
    • Bugfix for Synchronization agents via text noch testen (M. Ruff)
    • Bugfix for Synchronization coordinate cache values noch testen (T. Weibulat)
    • Synchronizing cached corrdinates of sampling plots OK (F. Raub)
    • Synchronizing of cached corrdinates of sampling plots including missing values OK (F. Raub)
    • Removing non printable signs from text fields OK (J. Wellsow)
    • Removing non printable signs from text fields for all tables OK (J. Wellsow)</span>
    • Orphaned data reorganized, Bugfixes for C0 code removal noch testen (T. Weibulat)
    • Bugfix design TK25 OK (J. Wellsow)
    • Synchronization of text values with DiversityScientificTerms OK (F. Hentschel)
    • Synchronization of linked values with DiversityScientificTerms expanded to identification and part description OK (F. Hentschel)
    • Synchronizing Agents via text including LIKE search noch testen (J. Wellsow)
  • Webservices
    • WoMRS - Genus added OK (E-mail 11.06.2021 um 11:57, F. Raub)
  • Query
    • Scan mode for collection query with optional inclusion of hierarchy OK (F. Raub)
    • Queryresults including collection hierarchy OK (F. Raub)
    • Queryoptions including restriction for hierarchy noch testen
    • Bugfix for transaction query OK (C. Dalitz, E-mail 2020-03-05 07:40)
    • Setting remote query source to last selected source noch testen (M. Schwager, E-mail 2020-03-05 13:31)
    • Several columns added/removed and text adapted noch testen (A. Jandl, E-mail 2020-05-19 17:06)
    • Bugfix optimized query OK (I. Wendt, E-mail 2020-07-17 09:07)
    • Keeping drop down style of comboboxes when resetting query OK (Email 28.10.2020 09:52, Hasslberger A.)
    • Query for geography with DiversityGazetteer as optional source noch testen
    • Query for terms including option for list + synonyms OK (Email 10.06.2021 um 16:59, F.Hentschel)
  • Cache database
    • Transfer of taxonomic groups in dependence of link to taxonomic thesaurus OK (M. Ruff)
    • Content view sorted
    • Transfer steps show description and definition of procedure if available
    • Taxa without rank in names without authors for zoological names OK (F. Raub)
    • Embargo date shown for blocked projects including warning when data are transferred noch testen (T. Weibulat)
    • Datawithholding of analysis included in creation of views for DiversityTaxonNames OK
    • Datasources with version check noch testen (T. Weibulat)
    • Sources for agents with check of data withholding noch testen (T. Weibulat)
    • Bugfix for transfer with empty PK-values noch testen
    • Batch transfer via bcp noch testen (T. Weibulat, M. Ruff)
    • Batch transfer via bcp can be stopped on error noch testen (T. Weibulat, M. Ruff)
    • Batch transfer settings included in settings form noch testen (T. Weibulat, M. Ruff)
    • Batch transfer including confirmation of transfer noch testen (T. Weibulat, M. Ruff)
    • Webservices as sources included OK (F. Raub)
    • Bugfix adding reference sources
    • Transfer window including indicator for batch transfer
    • All Postgres commands will be repeated in case of an error containing unable to write data to the transport connection noch testen (T. Weibulat)
    • Content window - after change of object: Hiding column description and wait curser
    • Bugfix transferring sampling plots noch testen (F. Raub)
    • Batch transfer excluding columns with empty default values noch testen (T. Weibulat, M. Ruff)
    • Including defaults in creation of unlogged temp tables for transfer noch testen (T. Weibulat, M. Ruff)
    • Transfer in chunks removed, not supported any longer OK (M. Ruff)
    • Protocol (error log) with optional restriction to errors included noch testen (T. Weibulat, M. Ruff)
    • Bugfix transferring lookup sources if data from other views interfere with already present dependent data OK (F. Raub, Email 2020-06-25 13:52)
    • Counting content of transferred data during batch transfer to ensure correct import OK (J. Wellsow)
    • Bulktransfer tests existence of file on server noch testen (T. Weibulat)
    • Progressbar for transfer of sources to postgres noch testen (T. Weibulat)
    • Inclusion of specimen project data noch testen (F. Raub)
    • Project related roles removed from code OK
    • Controls for orphaned sources noch testen
    • Several bugfixes OK
    • Several bugfixes and updates replacing postgres database noch testen
    • Replacement of Postgres databases redesigend noch testen
    • Bugfix setting taxonomic groups noch testen
    • WoMRS - Genus included in transfer OK (E-mail 11.06.2021 um 11:57, F. Raub)
    • Getting settings for batch transfer from existing entries noch testen
    • Creation of cache database with current collation and recovery model simple noch testen
    • Automatic setting of bash transfer option for projects after editing of parametersOK (E-mail J. Wellsow)
    • Version of views for sampling plots set to 2 OK, F. Raub 28.06.2021, 14:28
    • Check existence of stable identifier in related DP database OK, F. Raub 28.06.2021, 14:28
    • Inclusion of LIDO package noch testen (W. Walbaum)
    • Error messages for transfer to postgres improved noch testen
    • Bugfix export XML for packages noch testen
    • XML export for packages with direct access to exported files noch testen
    • Owner of databases in replacement changed to CacheAdmin noch testen, J. Wellsow
    • Checking owner of databases during replacement noch testen, J. Wellsow
    • Bugfix transfer to postgres including not null columns noch testen
    • AgentIdentifier removed from Agent transfer steps noch testen
    • Testing existence of tables during replacement of sources noch testen
    • Replacement of database includes change of ownership if different from CacheAdminnoch testen, J. Wellsow
    • Bugfix in transfer for taxon hierarchy
    • Bugfix in setting subsets for transfer
    • Diagnostics
      • Diagnostics for ABCD data included noch testen (T. Weibulat)
      • Diagnostics for ABCD include test for Country ISO-Codes noch testen (T. Weibulat)
      • Diagnostics for ABCD include test collection acronyms noch testen (T. Weibulat)
      • Diagnostics for ABCD include authors noch testen (T. Weibulat)
      • Bugfix diagnostics for ABCD - testing agent contact infos noch testen
      • Extension of diagnostics for ABCD for not established projects noch testen
      • Extension of diagnostics for ABCD for missing update noch testen
      • Extension of diagnostics for ABCD for missing package noch testen
    • Package FloraRaster
      • Transferstep FloraRaster_CacheCollectionEventLocalisationAVGPos removed
    • New schema tables for Analysis, Description and Processing including skripts
    • New table AgentIdentifier including skripts
    • New Filter option for transfer
    • Package for LIDO
  • Spreadsheet
    • Exclusion of symbol values from evaluation in map OK (M. Ruff)
    • Bugfix setting fixed source in case of CacheDB OK (M. Ruff)
  • Table editor
    • Bugfix creating table #ID OK (T. Schweizer, E-mail 2020-06-16 11:40)
    • Bugfix inserting date values OK (M. Ruff)
    • Part description added OK (F. Raub)
    • Transaction specimen included OK (C. Monje)
  • Collection
    • Query for abbreviation noch testen (T. Weibulat)
    • Abbreviation in form with separate label
    • Printing duplicates of labels OK (F. Raub, Email 2020-05-06 11:02)
    • Images for floor plans including geometry of image noch testen
    • WPF control for handling of geometry of collection noch testen
    • Avoiding loops in the hierarchy noch testen, F. Raub Email 13.10.2021, 09:00
  • Taxonlist
    • with optional count of number of units
    • Bugfix for dataretrieval from databases on linked server
    • Including gender OK (I. Wendt, Email 21.08.2020 um 13:51)
  • Import wizard
    • Isolation level for transactions set to Serializable and retrieval of Identity via OUTPUT clause OK (F. Raub)
    • Bugfix getting PK of tables with insert trigger OK (M. Ruff)
    • Isolation level for counts set to read uncommitted OK (M. Ruff)
    • Exclusion of RowGUID from column test OK (F. Raub, E-mail 2020-03-27 09:54)
    • Output of duplicates in protocol OK; B. Klasen, E-mail 29.04.2021 um 10:29
    • Bugfix for duplicates in protocol OK; B. Klasen, E-mail 26.05.2021 um 12:05
    • Bugfix inserting RegEx transformation noch testen
  • Transaction
    • Forwarding - bugfix creating letter noch testen (I. Sebek)
    • Return- bugfix creating letter noch testen (I. Sebek)
    • Sending - bugfix creating letter noch testen (I. Sebek)
    • Documents with option for local files OK (C. Monje)
    • Show single transaction if access to base entry is missing OK (C. Monje)
    • Open pdf files on demand OK (C. Monje)
    • Administrating collections for Regulations restricted to type regulation noch testen
    • Investigator included in query noch testen
    • Bugfix Display text for TransactionPayment in Query noch testen
    • Bugfix schema forwarding noch testen, I. Sebek (01.07.2021, 15:23)
  • Export wizard
    • Module link for Part description included OK (F. Raub)
    • Bugfix external identifier OK, A. Jandl, E-mail 13.04.2021 um 10:21
  • Identification
    • Webservice WoRMS included OK (F. Raub)
    • Webservice Tropicos included OK (SMNS C. Monje)
    • Depending identifications for terms noch testen (T. Burri)
    • Fixed sources for webservices including hierarchy noch testen (K.H. Rexer)
  • Statistics
    • Bugfix transaction in country list OK (I. Sebek)
    • Bugfix for large queries. Source changed to temp table OK (D. Neumann)
  • Archive
    • Schema including name of module and version, columns including description
    • Creation of table schemata independent of content
  • Database tools
    • Tabs for replication and dataprotection activated (beta version) noch testen
  • Info showing installed .Net version
  • NPGSQL updated to version 5.0.3.0

Datebase updates

  • Version 00.00.00 to 02.06.22

missing Function AnalysisHierarchy included

  • Version 02.06.22: ProjectList - include ProjectURI to enable Backlink search; CollectionSpecimenPart_Core2 - including hierarchy of collection; Identification: new column DependsOnIdentificationSequence + trgDelIdentification, trgUpdIdentification - Add DependsOnIdentificationSequence; trgIdentificationInsert: Do not include depending identifications; soil horizon as taxonomic group; CollectionHierarchyAll - avoid blockage by loops; ViewIdentificationUnitGeoAnalysis, ViewCollectionEventImage, ViewCollectionEventSeriesImage, ViewCollectionImage and ViewCollectionSpecimenImage for linked server; CollectionSpecimenID_UserAvailable, CollectionSpecimenID_ReadOnly, CollectionSpecimenID_Available and CollectionSpecimenID_AvailableReadOnly - include sUser_sName(); FirstLines_4: Remove Reference from Specimen and Identification; FirstLinesPart_2 - Remove Reference from Identification; FirstLinesUnit_4: Remove Reference from Identification; setting the Client Version to 4.3
  • Version 02.06.23: Table CollectionSpecimenPartDescription: new column DescriptionHierarchyCache incl. log and trigger; CollectionSpecimenPartDescription: Transfer Notes to DescriptionHierarchyCache; procCopyCollectionSpecimen2: Inclusion of dependent identification; New ROLE AdminNonProject; New stored procedure SetUserProjects to set the project access for a user ("SetUserProjects"); New table PropertyType_Enum; Content of table PropertyType_Enum; New column PropertyType in Property; Update of the column descriptions in table Property; Set PropertyType in table Property; Grant DELETE to CollectionManager for table CollectionSpecimen OK
  • Version 02.06.24: New table CacheDescription; procFillCacheDescription; New collection types collection, subdivided container and sensor; New taxonomic group artefact; New transaction type for warnings; New type sensor for CollectionType; New columns LocationFloorPlan, LocationGeometry and LocationHeight for Collection including Log table and Trigger; Grants and description for role DataManager; New tables for Task management (e.g. IPM): Tables TaskType_Enum, TaskDateType_Enum, TaskModuleType_Enum, Task, TaskResult, TaskModule, functions TaskHierarchySeparator, TaskCollectionHierarchySeparator TaskChildNodes, TaskHierarchy and TaskHierarchyAll, tables CollectionTask, CollectionTaskMetric, CollectionTaskImage including trigger and log tables; functions CollectionChildNodes, CollectionHierarchy, CollectionHierarchyAll, CollectionHierarchyMulti and CollectionHierarchySuperior including columns LocationPlan, LocationPlanWidth, LocationHeight; Inclusion of Transaction;


Cache Datebase updates

  • CacheDB updates
    • Version 1.0.28: TaxonAnalysisCategory - Add SortingID
    • Version 1.0.29: FUNCTION dbo.AgentsDatabase + Test of this function; set Grants for CacheAdmin; Create auxilliary user for command shell; Create auxilliary table for file transfer to postgres; Create procedures for file transfer to postgres; Target: Add TransferDirectory; ProjectTarget: Add TransferDirectory; New table AgentImage; AgentSource - Add Version; GazetteerSource - Add Version; ReferenceTitleSource - Add Version; SamplingPlotSource - Add Version; ScientificTermSource - Add Version; TaxonSynonymySource - Add Version;
    • Version 1.0.30: procTaxonNameHierarchy for setting of NameParentID; Redesign of the source tables: Redesign of Agent source tables: AgentContactInformation, AgentImage; New table AgentSourceView; Redesign of Gazetteer source tables: GazetteerExternalDatabase; New table GazetteerSourceView; Redesign of Reference source tables: ReferenceRelator, New table ReferenceTitleSourceView; Redesign of SamplingPlot source tables: SamplingPlotLocalisation, SamplingPlotProperty, New table SamplingPlotSourceView; Redesign of ScientificTerm; ScientificTerm, New table ScientificTermSourceView; Redesign of Taxon source tables: trgInsTaxonSynonymy - no inclusion of NameID for webservices, TaxonAnalysis, TaxonAnalysisCategory, TaxonAnalysisCategoryValue, TaxonCommonName, TaxonList, TaxonNameBlocked, TaxonNameExternalDatabase, TaxonNameExternalID; New table TaxonSynonymySourceView; set Default for LogInsertedWhen in table ReferenceTitle; set Grants; set subsets for sources;
    • Version 1.0.31: ReferenceTitle Add AuthorsCache for authors from RLL; New table AgentIdentifier if missing; procTaxonNameHierarchy for setting of NameParentID - Bugfix; New column MountPoint in table Target; Trigger trgUpdTarget for setting UseBulkTransfer; New column Restriction in table ProjectPublished;
  • Schema updates
    • Version 29: procPublishCollection - Getting the CollectionAcronym; procPublishCollectionEventLocalisation - reducing quadrant precision according to settings; CacheMetadata - DatasetDetails changed to nvarchar(MAX); procPublishMetadata - DatasetDetails from PublicDescription, Agents from DA etc.; ProjectTaxonomicGroup - Add RestrictToLinkedIdentifications; procPublishIdentificationUnit - optional restriction to linked identifications
    • Version 30: procPublishProjectAgentRole - transfer in new table for agent roles, bugfix; procPublishIdentificationUnit - optional restriction to linked identifications - bugfix; procPublishMetadata - DatasetDetails from PublicDescription, Agents from DA etc. via ProjectAgentID
    • Version 31: New table CacheCollectionProject; procPublishCollectionProject; procPublishMetadata - DatasetDetails from PublicDescription, Agents from DA etc. via ProjectAgentID and join with CacheCollectionProject and OwnerContactRole only for valid entry; ProjectAgent - add ProjectAgentID; ProjectAgent - change PK to ProjectAgentID; procPublishProjectAgentRole - include ProjectAgentID; ProjectAgentRole - add ProjectAgentID; ProjectAgentRole - change PK to ProjectAgentID; procPublishProjectAgentRole - include ProjectAgentID; procPublishCount - include CacheCollectionProject;
    • Version 32: procPublishCollectionProject redesigned; procPublishCollectionSpecimen - inclusion of restriction in table ProjectPublished; New table CacheCollectionSpecimenPartDescription; PROCEDURE procPublishCollectionSpecimenPartDescription; New table CacheCollectionSpecimenProcessingMethod; PROCEDURE procPublishCollectionSpecimenProcessingMethod; New table CacheCollectionSpecimenProcessingMethodParameter; PROCEDURE procPublishCollectionSpecimenProcessingMethodParameter; New table CacheIdentificationUnitAnalysisMethod; PROCEDURE procPublishIdentificationUnitAnalysisMethod; New table CacheIdentificationUnitAnalysisMethodParameter; PROCEDURE procPublishIdentificationUnitAnalysisMethodParameter

Postgres updates

  • WITH OIDS removed from all tables to ensure compatibilty to PostgreSQL 12
  • Database updates
    • Version 16: Removing OIDs from tables; TaxonAnalysisCategory - Add SortingID
    • Version 17: Function public.version TO CacheAdmin; Add Table AgentImage; Add ROLE CachePublicUser if missing;
    • Version 18: ScientificTerm - add columns RepresentationID and BaseURL;
  • Schema updates
    • Version 23: New table CacheCollectionProject; Remove any ownership of project related roles; CacheProjectAgent and CacheProjectAgentRole- add ProjectAgentID and change PK; Removing OIDs from tables; CacheMetadata - DatasetDetails to text;
    • Version 24: CacheMetadata - default for LogLastTransfer, change RecordUri to character varying(500); CacheProjectAgent - add ProjectAgentID and change PK in case previous update failed; New table CacheCollectionSpecimenPartDescription; New table CacheCollectionSpecimenProcessingMethod; New table CacheCollectionSpecimenProcessingMethodParameter; New table CacheIdentificationUnitAnalysisMethod; New table CacheIdentificationUnitAnalysisMethodParameter;
  • Package updates
    • ABCD
      • Due to changes in several source tables the ABCD package needs recreation
      • Version 5: abcd__unit() - SourceInstitutionID: set to if NULL; ABCD_TechnicalContact and ABCD_ContentContact from DA and without restriction to one contact; updating source descriptions; abcd___projectcitation: AgentRole from CacheProjectAgentRole; abcd__idxcacheidentificationunit_collectionspecimenid: Description included and check for existence; abcd__idxcacheidentificationunit_identificationunitid: Include description and check for existence; abcd__idxcacheidentificationunitinpart_specimenpartid: Include description and check for existence; abcd__measurementorfact: Adding MeasurementOrFactReference, AnalysisNumber to Parameter; abcd__unit_gathering: Removing objects if existing; ABCD__UnitNoPart: Inclusion of Exssicata number; abcd__unitnopart_removeindices: Check for existence and description included; abcd__unitnopartkingdom: Removing temp table if existent + description; abcd__unitnopartmetadata: Removing temp table if existent + description; abcd__unitnopartqualifier: Removing temp table if existent + description; abcd__unitpart: SourceInstitutionID from CollectionAcronym resp. CollectionName + description; ABCD_Unit: add columns Identification_Reference_URI, Identification_Reference_CitationDetail, Identification_Reference_ReferenceGUID, Identification_Reference_TitleCitation. ABCD_Unit in public: add new columns. ABCD_MeasurementOrFact: add column MeasurementOrFactReference. ABCD_MeasurementOrFact: change column Parameter to character varying(110); ABCD_MeasurementOrFact in public: add column MeasurementOrFactReference.
      • Version 6: ABCD_TechnicalContact and ABCD_ContentContact from DA, without restriction to one contact and join via ProjectAgentID; abcd___projectcitation: AgentRole from CacheProjectAgentRole and join via ProjectAgentID; ABCD_EFG_UnitStratigraphicDetermination_Chronostratigraphy; ABCD_EFG_UnitStratigraphicDetermination_Lithostratigraphy; ABCD_Unit_Identification_Extension_EFG; ABCD_Metadata - restriction to ProjectID;
      • AddOn BayernFlora
        • Version 2: ABCD__BayernFlora_EndangeredSpeciesBase; ABCD__BayernFlora_EndangeredSpeciesNameID; ABCD__BayernFlora_EndangeredSpeciesEventID; ABCD__BayernFlora_WrongStatusUnitID; function abcd__UnitPart: Without those with wrong status; function abcd__UnitNoPart: Without those with wrong status; function abcd__Unit_Associations_UnitAssociation: Without those with wrong status; function abcd__Unit_Gathering: Endangered species without locality text;
        • Version 3: ABCD__BayernFlora_WrongStatusUnitID - adding 99
        • Version 4: abcd__unit - Difference to ABCD: adding new columns for reference - Identification_Reference_ReferenceGUID,Identification_Reference_TitleCitation, Identification_Reference_CitationDetail,Identification_Reference_URI, restriction to qualifier missing or not like cf, restriction to linked identifications; abcd__unitpart - Difference to ABCD: SourceInstitutionID from CollectionAcronym resp. CollectionName, Exclusion of IdentificationUnits with wrong status; abcd__Unit_Gathering - Difference to ABCD: optimized, Exclusion of endangered species; Comments on ABCD views in public adapted
    • FloraRaster
      • FloraRaster package needs recreation
      • Version 2: Table FloraRaster_CacheCollectionEventLocalisationAVGPos and function floraraster__CacheCollectionEventLocalisationAVGPos() removed noch testen J. Wellsow, 24.06.2021, 15:20
    • LIDO
      • Version 2: eventSet/event/eventPlace/place/gml, objectDescriptionSet/descriptiveNoteValue noch testen W. Walbaum


Tests pending

Features already in regular DC release, but tests pending

Tests pending

Tests pending:

  • Query:
    • Bugfix remembering query conditions for module related restrictions noch testen
    • CacheDB as source for taxa included noch testen
    • Bugfix including query restrictions noch testen, W. Diewald, Feedback - 20.02.2019
    • Ignoring return charater as only entry in list query noch testen, D. Neumann, E-mail 08.03.2019 um 12:06
  • Import Wizard:
    • Removing content using the NULL value noch testen, B. Klasen, e-mail 06.12.2018, 12:07
    • Inclusion of SpecimenPartID of table CollectionSpecimenPart as Attachment column noch testen, D. Neumann
    • Disposing controls when setting startstep noch testen, B. Klasen, e-mail 26. Februar 2019 12:20
    • Increasing numbers for referencing tables noch testen, B. Klasen, e-mail 26. Februar 2019 12:20
    • Disposing components of usercontrols when disposing removed noch testen, B. Klasen, e-mail 26. Februar 2019 12:20
  • Cache database:
    • Enabling creation for older versions of database engine noch testen
    • Creation of message box for process only removed noch testen
    • Inclusion of all postgres databases for automatic transfer noch testen
    • Bugfix editing several entries noch testen
    • CacheDB as source for taxa noch testen
    • Timeout for connection set to 1000 for command timeout = 0 noch testen
    • Other targets on postgres database marked if on same server noch testen
    • Bugfix showing other targets on postgres database noch testen
    • Bugfix creating postgres database noch testen, T. Weibulat, E-mail 19.02.2019 um 13:52
    • Transfer to postgres via SQL-Commands noch testen, T. Weibulat, E-mail 19.02.2019 um 13:52
  • Transaction:
    • Retrieval of part list optimized noch testen, I. Sebek
    • Marking selected node when selecting node in tree: Bugfix noch testen, I. Sebek
    • Setting specimen lists when selecting node in tree: Bugfix noch testen, I. Sebek
    • Ensure presence of xslt files noch testen, I. Sebek
    • Button for retrieval of URL via default browser noch testen, P. Grobe
    • Setting collection hierarchy selectors on demand for better performance noch testen
    • New type regulation with validation of transaction title noch testen
    • Showing details of transaction in main form for type permit noch testen
    • Adding permit for editor included noch testen
    • Inclusion of country and year in specimen list noch testen
    • Inclusion of permit in specimen list and display of details noch testen
    • Hiding regulation title for user with missing permission noch testen
  • Showing accepted names for taxa linked with DiversityTaxonNames - Design adapted according to user feedback noch testen, B. Klasen
  • Optional encryption of connection (activated by default) noch testen
  • Cache database
    • Inclusion of AgentRoles from DiversityProjects in Transfer into cache database noch testen, T. Weibulat
  • Collection:
    • Sorting in hierarchy according to name noch testen, J. Spelda (Feedback 25.10.2018 18:13)
    • Hierarchy as displayed column noch testen, J. Spelda (Feedback 25.10.2018 18:13)
    • New column Type included noch testen
    • Administration of collection types noch testen
    • Icons for collection types in hierarchies noch testen
  • Images
    • Details for collection event images redesigned (T. Weibulat, 14.7.2017 16:00) - getestet, immer noch viel uneinheitlich, siehe E-Mails vom 17.und 18.07.2018, 15:51 bzw. 15:58 Uhr
    • Disable image data controls if no images are present noch testen(V. Sanz, 10.10.2017)
  • Import wizard
    • Bugfix for attachment tables containing default duplicate check column noch testen, D. Neumann, J. Spelda, E-mail 21.10.2018 um 19:06
  • Spreadsheet
  • Query
    • Disabling and enabling buttons (e.g. Optimizing, Clear, Save, ... ) according to query state (Predefined or not) noch testen
    • Abbreviation of fields improved noch testen
    • Setting query options: bugfix - checking subnodes when expanding node noch testen
    • Query for hierarchy and synonyms for names linked to DiversityTaxonNames P. Grobe
  • Maintenance
    • Synchronisation
      • Synchronizing coordinates with Gazetteer: Bugfix noch testen
    • Finding coordinates outside an area Noch testen, email V. Sanz, 26.10.2017 12:26 (Manual: Maintenance event coordinates)
    • Synchronisation - Taxa - missing connection: Bugfix finding correct sequence noch testen, I. Leininger (Feedback 27.09.2018 11:17)
    • Synchronisation - References: Inclusion of table CollectionSpecimenReference noch testen, I. Leininger (Feedback 18.09.2018 15:39)
  • Spreadsheet
    • Bugfix filtering for a list of values Noch testen, I. Sebek
  • Transaction
    • Balance based on value set in the form for the administrating agent, print out adapted according noch testen; I. Sebek Besprechung 3.5.2018
    • Balance confirmation address based on value set in the form for the administrating agent noch testen; I. Sebek Besprechung 3.5.2018
    • Exclusion of non accessbile transactions from table editor noch testen
    • Exclusion of non accessbile transactions from history noch testen
    • Retrieval of specimen lists optimized noch testen
  • History
    • Restore of deleted data with optional end date and filter noch testen; I. Sebek

CacheDatebase updates

  • Version 01.00.26: Tables for documentation of transfers ProjectTransfer, SourceTransfer noch testen, T. Weibulat - getestet, noch nicht in Ordnung, siehe E-Mail 17.08.2018
  • Schema updates:
    • Version 27: CacheProjectAgentRole - new table for agent roles; procPublishProjectAgentRole - transfer in new table for agent roles noch testen, T. Weibulat
    • Version 28: CacheMethod; procPublishMethod - transfer in new table for Method; CacheCollectionEventMethod; procPublishCollectionEventMethod - transfer in new table for CollectionEventMethod; CollectionEventParameterValue; procPublishCollectionEventParameterValue - transfer in new table for CollectionEventParameterValue; CacheCount - table for holding the total counts for all tables; procPublishCount - fill table CacheCount with values according to the total numbers noch testen, T. Weibulat
    • Version 29: procPublishCollection - Getting the CollectionAcronym; procPublishCollectionEventLocalisation - reducing quadrant precision according to settings; CacheMetadata - DatasetDetails changed to nvarchar(MAX); procPublishMetadata - DatasetDetails from PublicDescription, Agents from DA etc.; ProjectTaxonomicGroup - Add RestrictToLinkedIdentifications; procPublishIdentificationUnit - optional restriction to linked identifications noch testen, T. Weibulat
    • Version 30: procPublishProjectAgentRole - transfer in new table for agent roles, bugfix; procPublishIdentificationUnit - optional restriction to linked identifications - bugfix noch testen, T. Weibulat

Cache database for Postgres updates

  • Schema updates:
    • Version 21: CacheProjectAgentRole - new table for agent roles; procPublishProjectAgentRole - transfer in new table for agent roles noch testen, T. Weibulat
  • Packages
    • ABCD
      • Update to version 4 (upcoming): ABCD_Unit: The original view including a UNION was to slow for BioCASE; functions abcd__Unit_RemoveIndices, abcd__Unit_AddingIndices, abcd__Unit, ABCD_Unit - adaption to new table; function abcd___ProjectCitation - inclusion of date as version noch testen, T. Weibulat, Email 9.5.2018 16:31


Planned features

Functions planned, to be implemented in one of the next DC versions

Version 4.x.x

Updated content: Videos for several chapters

  • Typo in video tutorial title of Abspeichern von Suchkriterien: "Suchkritieren". Should be fixed. (D. Triebel)
  • 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)
  • Transfer of software settings in Diversity Workbench settings A. Rosenbauer, E-mail 19.10.2017 16:22
  • Transaction: Inserting local files as documents ToDo, V. Sanz 6.11.2017
  • Removing of database users without a valid login Noch testen, Manual - Login administration Nach DSGVO
  • Spreadsheet
    • Language and context noch testen
    • Remove columns that are filled via trigger, e.g. CollectionDate V. Sanz, Email 24.10.2017 18:02
    • Button to switch of the automatic rescan of the data after a change in a single field M. Ruff Feedback 2/1/2018 10:36 AM
    • Distribution map:
      • Selection of objects via a predefined geometry (M. Ruff)
      • Enable deselection within the selection frame (M. Ruff)
  • Import wizard
    • Selection of imported data in main form C. Dalitz 26.10.2017
    • CopyPrevious - beim Merging wird e.g. Event von leeren Zeilen zusammengefasst, nicht aber Originalzeile integriert (s. Tutorial 2). Test funktioniert nur wenn vorher Originalzeile getestet wurde - Hinweis ins Manual einbauen.
    • Transformation: Filter transformation übernimmt Werte mit CopyPrevious nicht (s. Tutorial - Habitat Spalte 2 von 3 in Original)
    • Checking if imported accession numbers do exist in the database (for no attachment or merging). By default these data will be pushed into the failed data file
  • Maintenance
    • Regulations herausgenommen - warten auf Test
      • Regulations with end date in query email V. Sanz, 26.10.2017 15:59
      • Entering regulation hints e.g according the Nagoya protocol noch testen, Manual: Maintenance regulations
      • Inserting regulations, bugfix email V. Sanz, 26.10.2017 15:59
      • Inserting regulations, bugfix email V. Sanz, 27.10.2017 13:20
      • Source for Nagoya protocol countries changed from Gazetteer to local available countries noch testen (D. Neumann, 25.1.2018)
    • General function combining all tasks, generating reports, allowing selective inclusion etc. ToDo
    • Es wäre auch gut eine Möglichkeit zu haben, alles "übrig gebliebene" zu finden, also alle Agents die keine URI haben. Das wäre auch sehr hilfreich für andere Bereiche, wie beim Abgleich mit Gazetteers. sonst weiss man nie so genau, was noch fehlt ToDo M. Ruff, 14.2.2018 10:11
    • Agents: Könnte man hier noch erweitern, dass man auch nach nur Nachname abgleichen kann. Mann müsste dann ggf. auswählen können, bei mehreren identischen Nachnamen. ToDo M. Ruff, 14.2.2018 9:55
  • Enable Copy & Paste for coordinates of units W. Diewald, Feedback 30.10.2017 8:38
  • Template for locality and habitat W. Diewald, Feedback 30.10.2017 8:28
  • CacheDB
    • Inclusion of new table ProjectAgentRole in transfer (replaces column AgentRole in table ProjectAgent) D. Triebel, T. Weibulat
    • Transfer of packages - button should not start directly. Either open selection for transfersteps (1 package) or warning that all packages will be transferred T. Weibulat, 19.2.2018E-mail W. Reichert 02.03.2018 14:35
    • Documentation of transfer and settings in separate table T. Weibulat, Besprechung 23.5.2018
    • Reduktion der Dokumentation auf die History - verknüpft mit
  • Sprache der Länderliste für CountryCache auswaehlbar machen
  • Beim Datenexport nach einem Portal Übersetzungsmechanismus des Ländernamens
  • Gesetzte Länderliste löschen
  • Cross database query for properties, e.g. list all spiders in Collection with Biotoptyp "Buchenwald" assigned in Sampling Plots (Request from SMNK, F.Raub / T.Stierhof)

Wünsche Stuttgart: (A. Jandl, Feedback 1/22/2018 17:51)

  • Die Zuordnung zu den MaterialCategories ist wenig nutzerfreundlich. Aus einer Liste, die aufklappt, muss ich jede einzelne MatCat anklicken.
  • Schöner wäre es wie bei Analysis, wo eine Auswahlliste erscheint, in der ich für die Auswahl Häkchen setzen kann.
  • Was ebenfalls nicht nutzerfreundlich ist, ist die Größe der Fenster für die Anzeigen MatCat und Project. Sie umfassen 3 Zeilen, können nicht vergrößert werden. Bei der Vielzahl unserer Projekte wäre das Vergrößern der Felder hilfreich.Gilt auch für Analysis.
  • Weiteres Manko: Die Werte werden nicht alphabetisch dargestellt. (Evtl. nach ID?). Das ist für die Verwaltung sehr schwierig. Gilt auch für Analysis.
  • Desweiteren können nicht alle Projekte oder MatCategories auf einen Schlag ausgewählt werden, so wie es bei Analysis möglich ist (projects, TaxaGroup).
  • Verbesserungsvorschlag: Beim Processing in DivColl ist das Datum bei der Auswahl schwer erkennbar - zumindest auf meinem Rechner. Hellblaues Datum auf dunkelblauem Grund ist ein, für mich, sehr schlechter Kontrast. (Januar 2018 ist für mich nicht lesbar, erst durch Screenshot mit Vergrößerung). Den dunkelblauen Hintergrund durch eine hellere Farbe ersetzen?
  • Query Felder fuer Transaction: A. Jandl, Feedback 1/31/2018 10:56 AM
    • Admin.Coll (mehrfache Felder)
    • IDIdentifyer (Art der Nummer, Feldinhalt)
    • Agents (Rolle der Person, Name)
    • Payments (Art der Zahlung, Wert, Einheit)
  • Wird in das Feld Problems (Bereich Organism) ein Text kopiert, der länger als 255 ? Zeichen ist und wird dann gespeichert, dann wird
    • 1) nach dem Speichern der entsprechende rechte Inhalt nicht mehr angezeigt (er muss erst durch Klick auf Accession Nr wieder eingeblendet werden, wobei ab und zu auch der Inhalt gleich wieder dargestellt wird. Es ist für mich nicht nachvollziehbar wann der Inhalt dargestellt wird und wann nicht)
    • 2) Der zu lange Text ohne Warnung nicht übernommen.
    • Sehr problematisch wird es, wenn Texte ergänzt werden und dann über die Feldlänge hinaus geschrieben wird.
    • Wenn ohne Warnung der Text abgeschnitten wird und der User hier nicht genau kontrolliert, gehen Daten verloren. Datenverluste kann ich niemandem vermitteln.
    • Bitte Hinweis auf zu langen Feldinhalt bei allen begrentzten Feldern einbauenein beliebig langer Text kann in das Feld Problems eingegeben werden. Beim Speichern kommt einen Fehlermeldung, dass der Text zu lang ist. Aber nun wird der komplette Text gelöscht! Alles weg was der User gerade mühsam eintippte.

Ist es nicht möglich beim erreichen der max. Textlänge ein Stopp der Texterfassung zu erzwingen und direkt eine Meldung auszugeben, dass Textlänge erreicht ist? ToDo, Email A. Jandl 19.04.2018 13:22 eingebaut in initForm(): this.FormFunctions.addRestrictLengthToTextboxes();

Wünsche Karlsruhe: ( T. Stierhof, E-mail 21. November 2017 14:31)

  • Event methods
    • Statt Methods sollte es Methods and circumstances heißen.
    • Unter value brauchen wir ein Notes-Feld, in dem der Bearbeiter eine Begründung für seine Einstufung abgeben soll. In DB eingebaut. Einbau in Client steht noch aus
    • Der ganze Bereich von Methods ist derzeit zu schmal resp. niedrig und durch Ziehen verändert man nur die Notes darüber bzw. den Bereich Sammelort/Verbatim/Habitat darunter. Die beiden benötigen aber eigentlich nur wenig Höhe, ganz im Gegensatz zum Bereich Methods. Da sollte man nicht nach zwei Zeilen schon scrollen müssen.
    • Es gibt beim Anlegen von Method, Parameter und Value jeweils eine Description, die aber nur mit Admin-Rechten einsehbar ist. Die müsste für alle Nutzer sichtbar sein, entweder als je ein Feld (mit der Description zum gerade blau unterlegten Listeneintrag) oder als Popup beim Darüberziehen des Cursors.

DSGVO

  • Database login linked to commitment
  • Change from UserName to ID
  • Inclusion of script generation in database tools noch testen

Database updates

  • Changing tables according to DSGVO

Cache database updates


DiversityDatabaseInspector

DDI version for testing

Download the Client software 1.0.0.0 (zip archive), 2019/01/08

New features and fixes:

  • New DWB client DiversityDatabaseInspector for scanning a number of databases on various SQL servers to extract values from certain tables (e.g. current users).


DiversityDescriptions

DD version for testing

The current client application is built for Microsoft .Net Framework 4.8.

Download the Installer for DiversityDescriptions client software 4.6.1 (zip archive containing installer), February 17th, 2023 (Database 03.03.07)

Use the installer if you have administrator rights, otherwise use the DiversityDescriptionsUnpack batchfile. For more information see General Download Notes.

  • Catalogue of Life webservice is offline. As soon as a replacement is available, it will be included

New features and fixes:

  • Export questionnaire: New options for font and formatting
  • Error corrections in central Diversity Workbench parts
  • Miscellaneous error corrections


Alternative download A small download of the main program files as zipped program folder.


Manual

Download the Manual 4.6.0 (zip archive), 2023/01/17

Updated contents: -


New contents: -


DiversityDescriptions for quiz database

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

New features and fixes:

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


DiversityExsiccatae

DE version for testing

The current client application is built for Microsoft .Net Framework 4.8.

Download the DiversityExsiccataeSetup 4.0.2.zip (zip archive containing installer), 2021/04/23

New features and fixes:

  • Table editor adapted to changes for DSGVO (Logging columns) noch testen
  • Bacteria in included in query noch testen, D. Triebel - Email 22.08.2018 09:53


Tests pending

Features already in regular DE release, but tests pending

Tests pending

Tests pending:

  • Image folder removed noch testen (D. Triebel, 22.8.2017)
  • Tools for database included noch testen
  • Description for database included noch testen


Planned features

Functions planned, to be implemented in one of the next DE versions

Planned features

Planned features:

  • Remove of function to ignore leading space signs of wrong entered image paths, because web portal needs exact path noch testen (D. Triebel, 22.1.2018)

Database updates

  • Version 02.00.05: For all tables: - UserProxy - filling with login data from table, Changing constraints for logging columns, Setting the ID as new value for LogUpdatedBy etc. according to EU-DSGVO, Setting the descriptions for LogUpdatedBy etc. according to EU-DSGVO
  • Version 02.00.06: ApplicationSearchSelectionStrings and procSetVersionExsiccatae according to EU-DSGVO; For all triggers - adaption to DSGVO


DiversityGazetteers

DG version for testing

Download the Installer for client software 4.3.1 (zip archive), 2021/02/19

New features and fixes:

New GIS-Editor Version 4.3.1:

  • Fix for changes in OSM web interface: Overlay was shifted and no longer visible, shapes were shifted on OSM map. Webbrowser width for OSM window now has been adapted to current version.


DiversityGisEditor

DGE version for testing

Download the Installer for DiversityGisEditor software 4.3.1 (zip archive), 2021/02/18

New features and fixes:

  • Commandline arguments added to select language (de, en, es). Default: en
  • Fix for changes in OSM web interface: Overlay was shifted and no longer visible, shapes were shifted on OSM map. Webbrowser width for OSM window now has been adapted to current version.


DiversityImageInspector

DiversityMobile

DiversityProjects

DP version for testing

Download the Client software installer 4.1.57 (zip archive), 2022/04/19

New features and fixes:


Download the Client software installer 4.1.56 (zip archive), 2021/07/01

New features and fixes:

  • Main form
    • New start mode updatedatabase noch testen;
  • OAIP - enabled
    • Administration of formats Postponed (T. Weibulat);
    • Administration of mime types Postponed (T. Weibulat);
    • Administration of OAIP archives for project Postponed (T. Weibulat);
  • Identifier for Project OK, (T. Weibulat);
  • Bugfix update T. Weibulat, E-mail 15.09.2020 um 12:52


  • Menu
    • Help - Metadata included
    • Connection - Timeout for query and connection included
  • Import GFBio
    • Archive -> Archive, Agents -> DiversityAgents Postponed (T. Weibulat);
    • Import wizard Postponed (T. Weibulat);
    • Import showing errors concerning agents Postponed (T. Weibulat);
    • Import asking for submitter and publisher noch testen (B. Klasen);
    • Import checks existence of table ProjectArchive noch testen (B. Klasen);
    • Insert selected default role if missing noch testen (B. Klasen);
    • Refresh project list if access is denied noch testen (B. Klasen);
    • Exchange of label and keywords noch testen (T. Weibulat E-mail 24.09.2020 um 11:18, B. Klasen);
    • Options for name of new project: Manual editing of project name, Key as project name or autogeneration noch testen (E-mail 28.05.2021 um 13:23, B. Klasen);
  • Archive - Disabled
    • Administrate Archives Postponed (T. Weibulat);
    • Create Archive Postponed (T. Weibulat);
    • Clean database Postponed (T. Weibulat);
    • Restore archive Postponed (T. Weibulat);
    • Create schema Postponed (T. Weibulat);
    • Type of relation to parent archive included Postponed (T. Weibulat);
  • Identifier
    • Locking of identifier in case of existing OAIP entries Postponed (T. Weibulat);
  • Agents
    • Showing display text and code for selection of role noch testen, C. Monje, Email 2020-06-08 10:22
    • Bugfix inserting several agents OK, T. Weibulat


  • Descriptors
    • Sorted by alphabet noch testen, T. Weibulat
  • Modules
    • Scanning for entries in modules (For details see manual, keyword Module connections) OK, (T. Weibulat);
    • Connection timeout set to 3 seconds by default noch testen, T. Weibulat


Database updates

  • Database update to version 2.1.21: ProjectArchiveMimeType_Enum; ProjectArchiveFormat_Enum; ProjectArchive; ProjectArchive_log; trgDelProjectArchive; trgUpdProjectArchive; ProjectArchiveIdentifier; ProjectArchiveIdentifier_log; trgDelProjectArchiveIdentifier; trgUpdProjectArchiveIdentifier; New columns for Project (Archive); New roles for Agent OK, (T. Weibulat);
  • Database update to version 2.1.22: ProjectAgentType_Enum - Removing Submitter; ProjectAgentRole_Enum - new roles and update of existing roles; ProjectAgent and ProjectAgentRole - Changing PK to ProjectAgentID including trigger etc. OK, (T. Weibulat); Correction of descriptions
  • Database update to version 2.1.23: New stored procedure SetUserProjects to set the project access for a user ("Tonis SetUserProjects"); ProjectArchive - new column ParentRelationType; new table ProjectArchiveRelationType_Enum; ProjectArchive - setting relation for ParentRelationType; Content of ProjectArchiveRelationType_Enum; trgDelProjectArchive; trgUpdProjectArchive; ProjectArchiveFormat_Enum - setting content; ProjectArchiveMimeType_Enum - setting content; new view ProjectArchiveFormats; Grants for ProjectArchive tables; ProjectAgentRole_Enum: Add Data Owner and Source Institution;


Tests pending

Features already in regular DP release, but tests pending

Tests pending

Tests pending:

  • Project - Interface for other modules testing existence of stable identifier base OK (T. Weibulat)
  • Bugfix starting application OK (B. Klasen, E-mail 26.1.2018 11:04)
  • Setting the notes for Identifier OK (B. Klasen, E-mail 21.2.2018 11:50)
  • Creation of security objects for REST access noch testen, S. Seifert
  • GFBio import:
    • Ignoring settings with missing values OK (B. Klasen)
    • Inclusion of URL for GFBioIssueID OK (B. Klasen, E-mail 21.2.2018 12:02)
  • Inclusion of webservices of GFBio and GBIF noch testen, T. Weibulat, B. Klasen, P. Grobe. E-mail 11.10.2018 11:07
  • Blocking change of descriptor type for module-linked entries noch testen, T. Weibulat
  • Several bugfixes noch testen, T. Weibulat. E-mail 11.12.2018, 12:28

Database updates

  • Database update to version 2.1.20: New types for Descriptor; Missing descriptions OK T. Weibulat


Planned features

Functions planned, to be implemented in one of the next DP versions

Planned features

Planned features:

  • Saving changes in data - bugfix (T. Weibulat, Feedback 18.07.2016)
  • Setting resources directory getestet, email V. Sanz 24.10.2017 17:07; Manual: Directory for resources
  • Publication of database scheme and ER model of DP, see under Information models, attention DOI compliance!
  • Label + Keyword -> Descriptor

Database updates

  • Database update to version 2.1.xx: Remove column AgentRole from triggers in ProjectAgent; Remove column AgentRole from ProjectAgent; Remove obsolet columns from table Project and triggers; Project_Core: remove obsolet columns; ProjectHierarchy - removing obsolet columns; ProjectChildNodes - removing obsolet columns; Remove obsolete columns function dbo.ProjectParents; Noch testen

Manual

  • Database tools
  • Database description


DiversityReferences

DR version for testing

The current client application is built for Microsoft .Net Framework 4.8.

Download the [for client software 4.1.4 (zip archive containing installer)], July 12th, 2022 (Database 2.1.5)

New features and fixes:

  • Error corrections in import wizard transformation
  • Restore of history data released
  • Periodicals form
    • New query function
    • New query for referencing titles
    • Improved error handling
  • Keyword types
    • New query function
    • New query for referencing titles
    • Improved error handling
  • Hide disabled keyword types to normal users
  • Adjustment of database timeout added to main menu
  • Error in handling of private markers fixed
  • Error in saving data of reference relators fixed

Datebase updates Database 2.1.5:

  • Initial descriptor element "ANY" inserted if required
  • New views for descriptor elements and periodicals query
  • Foreign key properties corrected
  • Unused tables and procedures dropped
  • Outdated field removed from reference title table
  • Missing access rights added for reference private note log

Database 2.1.4:

  • Trigger for delete of reference relator extended to update reference title description


Alternative download (If you do not have administrator rights on your computer or want to use different application versions in parallel.)


Manual

Download the [4.1.4 (zip archive)], 2022/07/12

Updated contents:

  • import wizard -transformation
  • Menu
  • Data editing
  • Administration
    • Keyword types (descriptors)
    • Periodicals
  • Database
    • History

New contents: -


Tests pending

Features already in regular DR release, but tests pending

Tests pending

Tests pending

  • Exception handling for updates improved noch testen. M. Ruff: E-mail 30.05.2018 07:02
  • Keywords - empty language removed Noch testen (T. Schweizer, Feedback 10.04.2018 14:16)
  • Images - Usercontrol replaced by browser and additional button for opening image in separat window Noch testen
  • Login according to EU-DSGVO noch testen


DiversityResources

DiversitySamplingPlots

DSP version for testing

Download the Installer for client software 4.4.7 (zip archive), 2021/12/02

New features and fixes:

  • Creation of database included.
  • New start mode for udpate noch testen
  • Bugfix maps noch testen, Email 19.11.2021 um 08:48, Ingo Wendt



DiversityScientificTerms

DST version for testing

The current client application is built for Microsoft .Net Framework 4.8. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft .Net Framework).

Download the Installer for client software 4.1.19 (zip archive containing installer), 2021/08/03

New features and fixes:

  • Installer creates shortcut on desktop and in program menu
  • Inclusion of references and properties in table editors
  • Back links from DiversityCollection
  • Dependency between terms included
  • Separate menu for types / ranking types
  • New role DiversityWorkbenchTypist with resticted permissions
  • Adding of query results to section
  • Optional display of terms in hierarchy of ranking terms
  • New start mode updatedatabase noch testen;
  • Resources for user placed outside program directory
    • 3 Options to places resources: Home, Documents, User defined
  • Query
    • New column Ranking to display Ranking/Type of terms noch testen (T. Weibulat);
    • Change to DisplayText when switching from Terms to Types in case of Display column is Ranking noch testen (T. Weibulat);
    • Return to previous Display column when switching between Terms and Types noch testen (T. Weibulat);
    • Query showing hierarchy of ranking terms;
    • Enabling query for several properties noch testen (Email 23.07.2021 um 11:37 Felix Hentschel);
    • Chart
      • Selection of terms via Chart
      • Adption to width of calling form
      • Setting of color for term including inheritance
      • Setting of display order
      • Setting of images, tooltip showing title of image and synonyms
      • Selection of whole terminology or section
  • Sections to define subgroups within terminologies
  • Import wizard for term included noch testen (F. Hentschel);
  • Archive
    • Administrate Archives noch testen (T. Weibulat);
    • Create Archive noch testen (T. Weibulat);
    • Clean database noch testen (T. Weibulat);
    • Restore archive noch testen (T. Weibulat);
    • Create schema noch testen (T. Weibulat);
  • Database tools
    • Creation of logtables, trigger and logcolumns including apation to DSGVO
  • Minor bugfixes

Database updates

  • Version 1.0.12: New type image for properties; New type color for properties; New view View_TermRanking as source for query; New role DiversityWorkbenchTypist with restricted permissions; TermDependency + TermDependency_log + Trigger noch testen
  • Version 1.0.13: New tables Section and SectionTerm incl. log and trigger; New columns DisplayOrder, DisplayARGB, DisplayInheritARGB in table TermRepresentation incl. log and trigger; New columns DisplayOrder and DataWithholdingReason TermResource incl. log and trigger; noch testen
  • Version 1.0.14: View for TermResource excluding XML column; Description for several objects; Generic SetUserProjects noch testen
  • Version 1.0.13: New tables Section and SectionTerm including Logtables and Trigger; New columns DisplayOrder, DisplayARGB and DisplayInheritARGB in table TermRepresentation + Logtable + Trigger; Table TermRepresentation, TermRepresentation_Log and Trigger: new Columns DisplayOrder, DisplayARGB and DisplayInheritARGB; Table TermResource, TermResource_Log and Trigger: new Columns DisplayOrder and DataWithholdingReason noch testen
  • Version 1.0.14: New stored procedure SetUserProjects to set the project access for a user ("Tonis SetUserProjects") noch testen


Download the Client software 3.0.1.9 c (zip archive), 2019/05/24

New features and fixes:

  • Query: Search for a list, synonyms or hierarchy included noch testen
  • Language:
    • Enabling included noch testen
    • Selection restricted to enabled languages noch testen


Test pending

DiversityScientificTerms - Test pending

Test pending:

  • Buttons for setting and removing the broader term noch testen
  • Button for setting the synonymy noch testen


Planned features

Functions planned, to be implemented in one of the next DST versions

DiversityScientificTerms - Planned features

Planned features:

  • Implement hierarchy search in ScientificTerms module like in SamplingPlots, e.g. search "woodland" only in properties of current hierarchy level or below (Request from SMNK, F. Raub / T. Stierhof)


DiversityTaxonNames

DTN version for testing


Download the Client software 4.1.26 (zip archive)], 2022/03/26

New features and fixes:

  • see chapter New features and fixes in the manual


Download the Setup for client software 4.1.24 (zip archive), 2021/07/09

Download the Client software 4.1.2 (zip archive), 2020/01/07

New features and fixes:

  • .Net Framework 4.8
  • Backlinks from DiversityCollection and DiversityDescriptions redesigned
  • Test for charts included
  • New start mode updatedatabase noch testen;
  • Archive
    • Creation of schema included
  • Exclusion of default project from optional projects when creating a new taxon noch testen, B. Klasen E-mail 2020-04-23 11:15
  • Export of checklists noch testen, M. Ruff
  • Export of hierarchy noch testen, M. Ruff
  • Connection menu - Server activity included noch testen, M. Ruff
  • Export of table view set to DWB Export directory noch testen, G. Rambold
  • Hierachy
    • Checking for loops in hierarchy noch testen, M. Ebert, T. Weibulat
  • Export wizard
    • Synonyms in relation to selected name noch testen, M. Ruff
    • BaseURL included noch testen, M. Schwager, E-mail 2020-06-18 08:45
  • Analysis
    • Sorting and datawithholding added noch testen, M. Ruff
  • Export of synonyms noch testen, G. Rambold
  • Resources with new columns Title, IPR, Creator, CreatorAgentURI, CopyrightStatement, LicenseType, LicenseHolder, LicenseHolderAgentURI, LicenseYear, DisplayOrder, DataWithholdingReason
  • Import wizard
    • Import of synonymy OK, B. Klasen
    • Import of accepted names and synonyms noch testen, B. Klasen

Database updates

  • Version 02.05.30: trgUpdTaxonName: Bugfix in where clause Detected by B. Quast; TaxonFamily: Include family as name to enable hierarchy entry for identifications as family noch testen, F. Raub; new function AcceptedNameID; Missing Descriptions; UserProxy - missing grant; Selfreferencing hierarchy: Remove existing wrong entries, Change trigger to remove wrong entries
  • Version 02.05.31: TaxonNameListAnalysisCategory add Columns DataWithholdingReason and SortingID; trgDelTaxonNameListAnalysisCategory add Columns DataWithholdingReason and SortingID; trgDelTaxonNameListAnalysisCategory add Columns DataWithholdingReason and SortingID; AnalysisCategoryHierarchyAll: add Columns DataWithholdingReason and SortingID; TaxonNameListAnalysisCategoryChildNodes add Columns DataWithholdingReason and SortingID; TaxonNameListAnalysisCategoryHierarchy add Columns DataWithholdingReason and SortingID
  • Version 02.05.32: procTaxonNameInsertNew_3: No reuse of deleted NameIDs, no insert of DefaultProjectID; ProjectList - include ProjectURI to enable Backlink search;
  • Version 02.05.33: procTaxonNameInsertNew_3: Start with 1 in case of empty database; TaxonCommonName.Transliteration - adding in case of missing; TaxonNameResource + log + Trigger: new columns Title, IPR, Creator, CreatorAgentURI, CopyrightStatement, LicenseType, LicenseHolder, LicenseHolderAgentURI, LicenseYear, DisplayOrder, DataWithholdingReason
  • Version 02.05.34: New stored procedure SetUserProjects to set the project access for a user ("Tonis SetUserProjects");


Download the Client software 3.0.3.5 h (zip archive), 2019/06/21

New features and fixes:

  • Enabling access to external datasources for users with read only access noch testen, F. Raub, Feedback 07.01.2019 12:05
  • Query for names in same modul according to list, hierarchy and/or synonymy included noch testen, F. Raub, E-mail 13.02.2019 um 11:54
  • Creation type suchfähig machen C. Dalitz, Email 04.07.2018 10:13
  • Search for linked specimen redesigned with optional start of application DC noch testen
  • Search for linked descriptions with optional start of application DD noch testen
  • Setting timeout noch testen, M. Ruff, Feedback 15.05.2019 11:53
  • Update of hierarchy cache noch testen, D. Triebel, Feedback 16.04.2019 13:33
  • Maintenance
    • Removal of self-referred synomyms noch testen
    • Ignoring of self-referred synomyms noch testen
    • Inspection of self-referred synomyms in main form noch testen
  • Access to reference list of MelNames and Goeverts removed


Test pending

Features already in regular DTN release, but tests pending

Tests pending

Tests pending:

  • Button for refreshing hierarchy cache noch testen: D. Triebel (Feedback 12.10.2018 11:15)
  • Menu settings according to connection noch testen
  • Spreadsheet: several bugfixes noch testen
  • Opening URL for external data sources in default browser noch testen: F. Raub, Feedback 31.07.2018 13:10
  • Import wizard: Ignore but keep for reference included noch testen: M.Ruff, E-mail 28.11.2018, 10:51


Planned features

Functions planned, to be implemented in one of the next DTN versions

Planned features

  • Test for duplicates for Taxa in import wizard B. Quast, Email 19.10.2017 16:22
  • Spreadsheet for TaxonName noch testen
  • Die Suchfunktion nach "Hierarchy missing" klappt nicht so richtig - es kommen lauter Ergebnisse von Taxa, bei denen eine Hierarchie doch vorhanden is E-mail H. Boyle, 07.02.2018 00:24
  • History restoring deleted data including restriction of timerange noch testen

{{{2}}}

Retrieved from "https://diversityworkbench.net/w/index.php?title=DWB_clients_for_beta_testing&oldid=22363"