View source for DWB clients for beta testing

The software versions below are for beta testing only, for regular releases appropriate for production environments see under [http://diversityworkbench.net/Portal/Software#Diversity_Workbench_core_applications_and_rich_clients 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 <span style="background-color: LightCoral">tests pending</span>, and support the developer during the process of implementation of the user feedback. Other color codes like the blue background color for <span style="background-color: #87CEFA;"> features planned</span> 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 --> <span style="background-color: #F08080;">test pending</span>
**background color: grey, color red --> <span style="color: red; background-color: lightgrey">manual unchecked by tester</span> 
**color: green --> <span style="color: green">tested</span>

* information for software developer
**color: green --> <span style="color: green">tested</span>
**background color: lightcyan --> <span style="background-color: lightcyan">function has to be improved partially </span> 
**background color: blue --> <span style="background-color: #87CEFA;">function planned, under progress</span> 
**color: violet --> <span style="color:#6959CD>function blocked (e.g. because of missing test), replaced or postponed</span> 
**color: orange --> <span style="color: #CD950C">function deferred</span> 
**background color: grey, color yellow --> <span style="color: yellow; background-color: grey">manual missing, unchecked or outdated</span>
**background color: grey, color: lightblue --> <span style="color: lightblue; background-color: grey">video missing or outdated</span>


----

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

===DiversityAgents===
DA version for <span style="background-color: #F08080;">testing</span>


The current client application is built for Microsoft [https://dotnet.microsoft.com/download/dotnet-framework/net48 .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 .Net framework (see [[General Download Notes]])
====Current version====
{{Hidden
|toggle position=left
|not collapsed=yes
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityAgents/DiversityAgentsSetup_4_2_1.zip Installer for client software 4.2.1 (zip archive)], 2023/07/13<!---->
|content=New features and fixes:

* See chapter [https://www.diversityworkbench.de/manual/dwb/diversityagents/news/index.html New features and fixes] in the manual
}}

====Previous versions====
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityAgents/DiversityAgentsSetup_4_1_41.zip Installer for client software 4.1.41 (zip archive)], 2023/05/04<!---->
|content=New features and fixes:

* See chapter [http://www.diversityworkbench.de/manual/DiversityAgents4/NewFeaturesAndFixes.htm New features and fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityAgents/DiversityAgentsSetup_4_1_40.zip Installer for client software 4.1.40 (zip archive)], 2023/04/05<!---->
|content=New features and fixes:

* See chapter [http://www.diversityworkbench.de/manual/DiversityAgents4/NewFeaturesAndFixes.htm New features and fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityAgents/DiversityAgentsSetup_4_1_39.zip Installer for client software 4.1.39 (zip archive)], 2023/04/03<!---->
|content=New features and fixes:

* See chapter [http://www.diversityworkbench.de/manual/DiversityAgents4/NewFeaturesAndFixes.htm New features and fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityAgents/DiversityAgentsSetup_4_1_38.zip Installer for client software 4.1.38 (zip archive)], 2022/09/13<!---->
|content=New features and fixes:

* See chapter [http://www.diversityworkbench.de/manual/DiversityAgents4/NewFeaturesAndFixes.htm New features and fixes] in the manual
}}

==== Tests pending ====
Features already in regular DA release, but <span style="background-color: #F08080;">tests pending</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=To be checked by tester
|content=Tests pending:
<!--* Indentation for synonyms [Es wäre schön wenn Synonyme in der Anzeige eingerückt wären (wie bei Taxon) und, wenn man die Namen von Collections aus aufruft, sie nicht mehr in der Auswahl erscheinen würden.]  <span style="color: green">OK. A. Rosenbauer, 21.03.2018</span>
* New field Ignore synonym to take a name from any list  <span style="background-color: LightCoral">noch testen. A. Rosenbauer, 21.03.2018</span>-->
}}

====Planned features====
Functions <span style="background-color: #87CEFA;">planned</span>, to be implemented in one of the next DA versions
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=Planned features<!---->
|content=Planned features:
}}

----
<!---->

===DiversityCollection=== 
DC version for <span style="background-color: #F08080;">testing</span>

The current client application is built for Microsoft [https://dotnet.microsoft.com/download/dotnet-framework/net48 .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 .Net framework (see [[General Download Notes]])

====Current version====
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_4_7.zip Installer for client software 4.4.7 (zip archive)] 2023/09/05
|content=New features and fixes:
* Change of password repaired
}}

====Previous versions====
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_4_6.zip Installer for client software 4.4.6 (zip archive)] 2023/09/01
|content=New features and fixes:
* See chapters [https://www.diversityworkbench.de/manual/dwb/diversitycollection/news/index.html New Features And Fixes] 
and [https://www.diversityworkbench.de/manual/dwb/separator/index.html New Features And Fixes in DWB 4.2.7]
in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_4_5.zip Installer for client software 4.4.5 (zip archive)] 2023/08/17
|content=New features and fixes:
* See chapters [https://www.diversityworkbench.de/manual/dwb/diversitycollection/news/index.html New Features And Fixes] 
and [https://www.diversityworkbench.de/manual/dwb/separator/index.html New Features And Fixes in DWB 4.2.7]
in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_4_4.zip Installer for client software 4.4.4 (zip archive)] 2023/07/25
|content=New features and fixes:
* See chapters [http://www.diversityworkbench.de/manual/DiversityCollection4/NewFeaturesAndFixes.htm New Features And Fixes] 
and [https://www.diversityworkbench.de/manual/dwb/separator/index.html#425-2023-07-25 New Features And Fixes in DWB 4.2.5]
in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_4_3.zip Installer for client software 4.4.3 (zip archive)] 2023/06/21
|content=New features and fixes:
* See chapter [http://www.diversityworkbench.de/manual/DiversityCollection4/NewFeaturesAndFixes.htm New Features And Fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_4_2.zip Installer for client software 4.4.2 (zip archive)] 2023/05/31
|content=New features and fixes:
* See chapter [http://www.diversityworkbench.de/manual/DiversityCollection4/NewFeaturesAndFixes.htm New Features And Fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_4_1.zip Installer for client software 4.4.1 (zip archive)] 2023/05/22
|content=New features and fixes:
* See chapter [http://www.diversityworkbench.de/manual/DiversityCollection4/NewFeaturesAndFixes.htm New Features And Fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_3_249.zip Installer for client software 4.3.249 (zip archive)] 2023/05/04
|content=New features and fixes:
* See chapter [http://www.diversityworkbench.de/manual/DiversityCollection4/NewFeaturesAndFixes.htm New Features And Fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_3_248.zip Installer for client software 4.3.248 (zip archive)] 2023/04/20
|content=New features and fixes:
* See chapter [http://www.diversityworkbench.de/manual/DiversityCollection4/NewFeaturesAndFixes.htm New Features And Fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_3_247.zip Installer for client software 4.3.247 (zip archive)] 2023/04/06
|content=New features and fixes:
* See chapter [http://www.diversityworkbench.de/manual/DiversityCollection4/NewFeaturesAndFixes.htm New Features And Fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityCollection/DiversityCollectionSetup_4_3_246.zip Installer for client software 4.3.246 (zip archive)] 2023/01/26
|content=New features and fixes:
* See chapter [http://www.diversityworkbench.de/manual/DiversityCollection4/NewFeaturesAndFixes.htm New Features And Fixes] in the manual
}}

====Tests pending====
Features already in regular DC release, but <span style="background-color: #F08080;">tests pending</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=Tests pending<!---->
|content=Tests pending:

* Query: 
** Bugfix remembering query conditions for module related restrictions <span style="background-color: #F08080;"> noch testen</span>
** CacheDB as source for taxa included <span style="background-color: #F08080;"> noch testen</span>
** Bugfix including query restrictions <span style="background-color: #F08080;"> noch testen, W. Diewald, Feedback - 20.02.2019</span>
** Ignoring return charater as only entry in list query <span style="background-color: #F08080;"> noch testen, D. Neumann, E-mail 08.03.2019 um 12:06</span>
* Import Wizard: 
** Removing content using the NULL value <span style="background-color: #F08080;"> noch testen, B. Klasen, e-mail 06.12.2018, 12:07</span>
** Inclusion of SpecimenPartID of table CollectionSpecimenPart as Attachment column <span style="background-color: #F08080;"> noch testen, D. Neumann</span>
** Disposing controls when setting startstep <span style="background-color: #F08080;"> noch testen, B. Klasen, e-mail 26. Februar 2019 12:20</span>
** Increasing numbers for referencing tables <span style="background-color: #F08080;"> noch testen, B. Klasen, e-mail 26. Februar 2019 12:20</span>
** Disposing components of usercontrols when disposing removed <span style="background-color: #F08080;"> noch testen, B. Klasen, e-mail 26. Februar 2019 12:20</span>
* Cache database: 
** Enabling creation for older versions of database engine <span style="background-color: #F08080;"> noch testen</span>
** Creation of message box for process only removed <span style="background-color: #F08080;"> noch testen</span>
** Inclusion of all postgres databases for automatic transfer <span style="background-color: #F08080;"> noch testen</span>
** Bugfix editing several entries <span style="background-color: #F08080;"> noch testen</span>
** CacheDB as source for taxa <span style="background-color: #F08080;"> noch testen</span>
** Timeout for connection set to 1000 for command timeout = 0 <span style="background-color: #F08080;"> noch testen</span>
** Other targets on postgres database marked if on same server<span style="background-color: #F08080;"> noch testen</span>
** Bugfix showing other targets on postgres database<span style="background-color: #F08080;"> noch testen</span>
** Bugfix creating postgres database<span style="background-color: #F08080;"> noch testen, T. Weibulat, E-mail 19.02.2019 um 13:52</span>
** Transfer to postgres via SQL-Commands<span style="background-color: #F08080;"> noch testen, T. Weibulat, E-mail 19.02.2019 um 13:52</span>
* Transaction: 
** Retrieval of part list optimized <span style="background-color: #F08080;"> noch testen, I. Sebek</span>
** Marking selected node when selecting node in tree: Bugfix <span style="background-color: #F08080;"> noch testen, I. Sebek</span>
** Setting specimen lists when selecting node in tree: Bugfix <span style="background-color: #F08080;"> noch testen, I. Sebek</span>
** Ensure presence of xslt files <span style="background-color: #F08080;"> noch testen, I. Sebek</span>
** Button for retrieval of URL via default browser <span style="background-color: #F08080;"> noch testen, P. Grobe</span>
** Setting collection hierarchy selectors on demand for better performance <span style="background-color: #F08080;"> noch testen</span>
** New type regulation with validation of transaction title <span style="background-color: #F08080;"> noch testen</span>
** Showing details of transaction in main form for type permit <span style="background-color: #F08080;"> noch testen</span>
** Adding permit for editor included <span style="background-color: #F08080;"> noch testen</span>
** Inclusion of country and year in specimen list <span style="background-color: #F08080;"> noch testen</span>
** Inclusion of permit in specimen list and display of details <span style="background-color: #F08080;"> noch testen</span>
** Hiding regulation title for user with missing permission <span style="background-color: #F08080;"> noch testen</span>

* Showing accepted names for taxa linked with DiversityTaxonNames - Design adapted according to user feedback <span style="background-color: #F08080;"> noch testen, B. Klasen</span>
* Optional encryption of connection (activated by default) <span style="background-color: #F08080;"> noch testen</span>

* Cache database
** Inclusion of AgentRoles from DiversityProjects in Transfer into cache database <span style="background-color: #F08080;"> noch testen, T. Weibulat</span>

* Collection: 
** Sorting in hierarchy according to name <span style="background-color: #F08080;"> noch testen, J. Spelda (Feedback 25.10.2018 18:13)</span>
** Hierarchy as displayed column <span style="background-color: #F08080;"> noch testen, J. Spelda (Feedback 25.10.2018 18:13)</span>
** New column Type included <span style="background-color: #F08080;"> noch testen</span>
** Administration of collection types <span style="background-color: #F08080;"> noch testen</span>
** Icons for collection types in hierarchies <span style="background-color: #F08080;"> noch testen</span>

* Images
** Details for collection event images redesigned <span style="background-color: #F08080;">(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</span>
** Disable image data controls if no images are present <span style="color: yellow; background-color: grey">noch testen(V. Sanz, 10.10.2017)</span>

* Import wizard
** Bugfix for attachment tables containing default duplicate check column <span style="background-color: #F08080;"> noch testen, D. Neumann, J. Spelda, E-mail 21.10.2018 um 19:06</span>
* Spreadsheet
** Bugfix for retrieval of table name http://biocase.snsb.info/wrapper/index.cgi

* Query 
** Disabling and enabling buttons (e.g. Optimizing, Clear, Save, ... ) according to query state (Predefined or not) <span style="color: yellow; background-color: grey">noch testen</span>
** Abbreviation of fields improved <span style="background-color: #F08080;"> noch testen</span>
** Setting query options: bugfix - checking subnodes when expanding node <span style="background-color: #F08080;"> noch testen</span>
** Query for hierarchy and synonyms for names linked to DiversityTaxonNames <span style="background-color: #F08080;"> P. Grobe</span>

* Maintenance
** Synchronisation
*** Synchronizing coordinates with Gazetteer: Bugfix  <span style="color: yellow; background-color: grey">noch testen</span>
** Finding coordinates outside an area <span style="color: yellow; background-color: grey">Noch testen, email V. Sanz, 26.10.2017 12:26 (Manual: Maintenance event coordinates)</span>
** Synchronisation - Taxa - missing connection: Bugfix finding correct sequence <span style="background-color: #F08080;"> noch testen, I. Leininger (Feedback 27.09.2018 11:17)</span>
** Synchronisation - References: Inclusion of table CollectionSpecimenReference <span style="background-color: #F08080;"> noch testen, I. Leininger (Feedback 18.09.2018 15:39)</span>

* Spreadsheet
** Bugfix filtering for a list of values  <span style="background-color: #F08080;">Noch testen, I. Sebek</span>

* Transaction
** Balance based on value set in the form for the administrating agent, print out adapted according  <span style="background-color: #F08080;"> noch testen; I. Sebek Besprechung 3.5.2018</span>
** Balance confirmation address based on value set in the form for the administrating agent  <span style="background-color: #F08080;"> noch testen; I. Sebek Besprechung 3.5.2018</span>
** Exclusion of non accessbile transactions from table editor  <span style="background-color: #F08080;"> noch testen</span>
** Exclusion of non accessbile transactions from history  <span style="background-color: #F08080;"> noch testen</span>
** Retrieval of specimen lists optimized <span style="background-color: #F08080;"> noch testen</span>

* History
** Restore of deleted data with optional end date and filter  <span style="background-color: #F08080;"> noch testen; I. Sebek</span>

'''CacheDatebase updates'''
* Version 01.00.26: Tables for documentation of transfers ProjectTransfer, SourceTransfer <span style="background-color: #F08080;">noch testen, T. Weibulat - getestet, noch nicht in Ordnung, siehe E-Mail 17.08.2018</span>
* Schema updates:
** Version 27: CacheProjectAgentRole - new table for agent roles; procPublishProjectAgentRole - transfer in new table for agent roles <span style="background-color: #F08080;"> noch testen, T. Weibulat</span>
** 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 <span style="background-color: #F08080;"> noch testen, T. Weibulat</span>
** 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 <span style="background-color: #F08080;"> noch testen, T. Weibulat</span>
** Version 30: procPublishProjectAgentRole - transfer in new table for agent roles, bugfix; procPublishIdentificationUnit - optional restriction to linked identifications - bugfix  <span style="background-color: #F08080;"> noch testen, T. Weibulat</span>

'''Cache database for Postgres updates'''
* Schema updates:
** Version 21: CacheProjectAgentRole - new table for agent roles; procPublishProjectAgentRole - transfer in new table for agent roles <span style="background-color: #F08080;"> noch testen, T. Weibulat</span>

* 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 <span style="background-color: #F08080;"> noch testen, T. Weibulat, Email 9.5.2018 16:31</span>
}}

====Planned features====
Functions <span style="background-color: #87CEFA;">planned</span>, to be implemented in one of the next DC versions
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Version 4.x.x'' 
|content=Updated content: Videos for several chapters
* Typo in video tutorial title of Abspeichern von Suchkriterien: "Suchkritieren". Should be fixed. <span style="background-color: #87CEFA;">(D. Triebel)</span> 
* Several sampling plots for one event <span style="background-color: #87CEFA;">(M. Ruff)</span> 
* Extension of PK of table CollectionEventProperty to enable entry of several items from the same terminology <span style="background-color: #87CEFA;">(M. Ruff)</span> 
* Extension of PK of table IdentificationUnitAnalysis to enable bulk insert <span style="background-color: #87CEFA;">(D. Neumann)</span> 
* Marking image areas <span style="background-color: #87CEFA;">getestet, email V. Sanz 11.10.2017 16:36 (V. Sanz, 26.7.2017)</span>
* Transfer of software settings in Diversity Workbench settings <span style="background-color: #87CEFA;">A. Rosenbauer, E-mail 19.10.2017 16:22</span>
* Transaction: Inserting local files as documents <span style="background-color: #87CEFA;">ToDo, V. Sanz 6.11.2017</span>
* Removing of database users without a valid login <span style="color: violet">Noch testen, Manual - Login administration</span> <span style="color: violet">Nach DSGVO</span>
* Spreadsheet
** Language and context    <span style="color: violet">noch testen</span>
** Remove columns that are filled via trigger, e.g. CollectionDate    <span style="background-color: #87CEFA;">V. Sanz, Email 24.10.2017 18:02</span>
** Button to switch of the automatic rescan of the data after a change in a single field    <span style="background-color: #87CEFA;">M. Ruff Feedback 2/1/2018 10:36 AM</span>
** Distribution map:
*** Selection of objects via a predefined geometry <span style="background-color: #87CEFA;">(M. Ruff)</span> 
*** Enable deselection within the selection frame <span style="background-color: #87CEFA;">(M. Ruff)</span> 

* Import wizard
** Selection of imported data in main form <span style="background-color: #87CEFA;">C. Dalitz 26.10.2017</span>
** 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 <span style="color: violet">herausgenommen - warten auf Test</span>
*** Regulations with end date in query    <span style="color: violet">email V. Sanz, 26.10.2017 15:59</span>
*** Entering regulation hints e.g according the Nagoya protocol  <span style="color: violet">noch testen, Manual: Maintenance regulations</span> <!--E-Mail 22.09. 10:25, 24.10 11:09; E-Mail 27.10.2017 13:10; Warten auf Rückmeldung; Wird noch umgebaut um auch Series einzuschliessen-->
*** Inserting regulations, bugfix  <span style="color: violet">email V. Sanz, 26.10.2017 15:59</span>
*** Inserting regulations, bugfix  <span style="color: violet">email V. Sanz, 27.10.2017 13:20</span>
*** Source for Nagoya protocol countries changed from Gazetteer to local available countries  <span style="color: violet">noch testen (D. Neumann, 25.1.2018)</span>
** General function combining all tasks, generating reports, allowing selective inclusion etc. <span style="background-color: #87CEFA;">ToDo</span>
** 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  <span style="background-color: #87CEFA;">ToDo M. Ruff, 14.2.2018 10:11</span>
** 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.   <span style="background-color: #87CEFA;">ToDo M. Ruff, 14.2.2018 9:55</span>

* Enable Copy & Paste for coordinates of units <span style="background-color: #87CEFA;">W. Diewald, Feedback 30.10.2017 8:38</span>
* Template for locality and habitat <span style="background-color: #87CEFA;">W. Diewald, Feedback 30.10.2017 8:28</span>

* CacheDB
** Inclusion of new table ProjectAgentRole in transfer (replaces column AgentRole in table ProjectAgent) <span style="background-color: #87CEFA;">D. Triebel, T. Weibulat</span>
** Transfer of packages - button should not start directly. Either open selection for transfersteps (1 package) or warning that all packages will be transferred <span style="background-color: #87CEFA;">T. Weibulat, 19.2.2018</span><span style="background-color: #87CEFA;">E-mail W. Reichert 02.03.2018 14:35</span>
** Documentation of transfer and settings in separate table <span style="background-color: #87CEFA;">T. Weibulat, Besprechung 23.5.2018</span>
** 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  <span style="background-color: #87CEFA;"> (Request from SMNK, F.Raub / T.Stierhof)</span>

<span style="color: blue">''' Wünsche Stuttgart: (A. Jandl, Feedback 1/22/2018 17:51)'''</span>
* 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:  <span style="background-color: #87CEFA;"> A. Jandl, Feedback 1/31/2018 10:56 AM</span>
** 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?  <span style="background-color: #87CEFA;">ToDo, Email A. Jandl 19.04.2018 13:22</span> eingebaut in initForm(): this.FormFunctions.addRestrictLengthToTextboxes();

<span style="color: blue">''' Wünsche Karlsruhe: ( T. Stierhof, E-mail 21. November 2017 14:31)'''</span>
* 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. <span style="background-color: #87CEFA;"> In DB eingebaut. Einbau in Client steht noch aus</span>
** 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.

<span style="color: blue">''' DSGVO '''</span>
* Database login linked to commitment
* Change from UserName to ID
* Inclusion of script generation in database tools <span style="color: violet"> noch testen </span>

'''Database updates'''

* Changing tables according to DSGVO

'''Cache database updates'''
}}

----

===DiversityDatabaseInspector===
DDI version for <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversityDatabaseInspector_1_0_0_0.zip|Client software 1.0.0.0 (zip archive)]], 2019/01/08
|content=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 <span style="background-color: #F08080;">testing</span>

The current client application is built for Microsoft .Net Framework 4.8.
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityDescriptions/DiversityDescriptionsSetup_4_7_2.zip Installer for DiversityDescriptions client software 4.7.2 (zip archive)], 2023/09/05 (Database 03.03.08)
|content=Use the installer if you have administrator rights, otherwise use the '''DiversityDescriptionsUnpack''' batchfile. For more information see [https://diversityworkbench.net/Portal/General_Download_Notes General Download Notes].

* <span style="background-color: red; color: white">Catalogue of Life webservice is offline. As soon as a replacement is available, it will be included</span>

New features and fixes:
* Change password repaired
* Description Grid: Improved handling of statistical measures
* Cache database:
** New option to lock character based on package
** New package LiasGtm
* Questionnaire editor: Handling of read only data improved
* Miscellaneous error corrections 

'''Database updates'''

Database 03.03.08:
* Handling of ID reinitialization for cache database corrected

Cache database 1.0.10 / 10
* Synthetic keys from views removed that disturbed duplicate check

Postgres database 1.0.2 / 6
* New table for package specific character locking introduced
}}

'''Alternative download''' A small download of the main program files as zipped program folder.
* ''Download'' the [https://www.diversityworkbench.de/clients/DiversityDescriptions/DiversityDescriptions_4_7_2.zip Client software 4.7.2 (zipped program folder) '''without''' manual]


'''Manual'''

Updated contents:
* Cache database - Packages
* Cache database - AddOns
* Cache database - Postgres infrastructure

New contents:
-


====DiversityDescriptions for quiz database====
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the special version for access to the taxon quiz database [https://www.diversityworkbench.de/clients/DiversityDescriptions/DiversityDescriptions_3_0_1_4_e.zip client software 3.0.1.4 e (zip archive)], 2015/11/20 (Database 03.00.10 '''"Quiz"''')
|content=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 <span style="background-color: #F08080;">testing</span>

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

{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityExsiccatae/DiversityExsiccataeSetup_4_0_4.zip Installer for client software 4.0.4 (zip archive)], 2023/03/08<!---->
|content=
[[http://www.diversityworkbench.de/manual/DiversityExsiccatae4/NewFeaturesAndFixes.htm New features and fixes]]
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityExsiccatae/DiversityExsiccataeSetup_4_0_2.zip Installer for client software 4.0.2 (zip archive)], 2021/04/23<!---->
|content=New features and fixes:
* Table editor adapted to changes for DSGVO (Logging columns) <span style="background-color: #F08080;">noch testen</span>
* Bacteria in included in query <span style="background-color: #F08080;">noch testen, D. Triebel - Email 22.08.2018 09:53</span>
<!--
* Sending feedback: Bugfix  <span style="color: green">OK (D. Triebel, 20.8.2017)</span>
* Display of images from foreign sources <span style="color: green">OK (D. Triebel, 20.8.2017)</span>
* Image without automatic adaption <span style="color: green">OK (D. Triebel, 20.8.2017)</span>
* Image folder removed <span style="color: violet">noch testen (D. Triebel, 22.8.2017)</span>
* Tools for database included <span style="color: violet">noch testen</span>
* Description for database included <span style="color: violet">noch testen</span>
* Login according to EU-DSGVO  <span style="color: violet">noch testen</span>
'''Database updates'''
* Database update to version 2.0.4:Remove ExsiccataExamplesAccess;  New table UserProxy - Add PrivacyConsent and PrivacyConsentDate - according to EU-DSGVO; Function providing the ID of the user from UserProxy; Function providing the name of the user from UserProxy; UserProxy - Trigger for setting PrivacyConsentDate; Function PrivacyConsentInfo providing common information with the DiversityWorkbench; Grants for table ProjectLabel <span style="color: violet">Noch testen</span>
-->
}}

==== Tests pending ====
Features already in regular DE release, but <span style="background-color: #F08080;">tests pending</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=Tests pending
|content=Tests pending:
* Image folder removed <span style="background-color: #F08080;">noch testen (D. Triebel, 22.8.2017)</span>
* Tools for database included <span style="background-color: #F08080;">noch testen</span>
* Description for database included <span style="background-color: #F08080;">noch testen</span>
}}

====Planned features====
Functions <span style="background-color: #87CEFA;">planned</span>, to be implemented in one of the next DE versions
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=Planned features
|content=Planned features:
* Remove of function to ignore leading space signs of wrong entered image paths, because web portal needs exact path <span style="background-color: #F08080;">noch testen (D. Triebel, 22.1.2018)</span>
<span style="background-color: #87CEFA;">'''Database updates'''</span>
* 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 <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversityGazetteersSetup_4_3_1.zip|Installer for client software 4.3.1 (zip archive)]], 2021/02/19
|content=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. 
}}

<!-- 
DG version for <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversityGazetteersSetup_4_2_1.zip|Installer for client software 4.2.1 (zip archive)]], 2020/06/26
|content=New features and fixes:
* Help file adapted to .NET 4.8.
* No blanks in the name of the installed application in program menu and desktop icon.
}}
-->
----

===DiversityGisEditor===

DGE version for <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversityGisEditorSetup_4_3_1.zip|Installer for DiversityGisEditor software 4.3.1 (zip archive)]], 2021/02/18
|content=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===

<!-- 
II version for <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversityImageInspectorSetup_4_1_1.zip|Installer for DiversityImageInspector software 4.1.1 (zip archive)]], 2020/06/26
|content=New features and fixes:
* No blanks in the name of the installed application in program menu and desktop icon.
}}
-->
----

===DiversityMobile===


----

===DiversityProjects===
DP version for <span style="background-color: #F08080;">testing</span>

{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityProjects/DiversityProjectsSetup_4_1_59.zip Installer for client software 4.1.59 (zip archive)], 2023/03/29<!---->
|content=New features and fixes:

* See chapter [http://www.diversityworkbench.de/manual/DiversityProjects4/NewFeaturesAndFixes.htm New features and fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityProjects/DiversityProjectsSetup_4_1_56.zip Installer for client software 4.1.56 (zip archive)], 2021/07/01<!---->
|content=New features and fixes:

* Main form
** New start mode updatedatabase <span style="background-color: #F08080;">noch testen</span>;

* OAIP - enabled
** Administration of formats <span style="color: violet">Postponed (T. Weibulat)</span>;
** Administration of mime types <span style="color: violet">Postponed (T. Weibulat)</span>;
** Administration of OAIP archives for project <span style="color: violet">Postponed (T. Weibulat)</span>;

* Identifier for Project <span style="color: green">OK,  (T. Weibulat)</span>;
* Bugfix update <span style="background-color: #F08080;">T. Weibulat, E-mail 15.09.2020 um 12:52</span>


* Menu
** Help - Metadata included
** Connection - Timeout for query and connection included

* Import GFBio
** Archive -> Archive, Agents -> DiversityAgents <span style="color: violet">Postponed (T. Weibulat)</span>;
** Import wizard <span style="color: violet">Postponed (T. Weibulat)</span>;
** Import showing errors concerning agents <span style="color: violet">Postponed (T. Weibulat)</span>;
** Import asking for submitter and publisher <span style="background-color: #F08080;">noch testen (B. Klasen)</span>;
** Import checks existence of table ProjectArchive <span style="background-color: #F08080;">noch testen (B. Klasen)</span>;
** Insert selected default role if missing <span style="background-color: #F08080;">noch testen (B. Klasen)</span>;
** Refresh project list if access is denied <span style="background-color: #F08080;">noch testen (B. Klasen)</span>;
** Exchange of label and keywords <span style="background-color: #F08080;">noch testen (T. Weibulat E-mail 24.09.2020 um 11:18, B. Klasen)</span>;
** Options for name of new project: Manual editing of project name, Key as project name or autogeneration <span style="background-color: #F08080;">noch testen (E-mail 28.05.2021 um 13:23, B. Klasen)</span>;

* Archive - Disabled
** Administrate Archives <span style="color: violet">Postponed (T. Weibulat)</span>;
** Create Archive <span style="color: violet">Postponed (T. Weibulat)</span>;
** Clean database <span style="color: violet">Postponed (T. Weibulat)</span>;
** Restore archive <span style="color: violet">Postponed (T. Weibulat)</span>;
** Create schema <span style="color: violet">Postponed (T. Weibulat)</span>;
** Type of relation to parent archive included <span style="color: violet">Postponed (T. Weibulat)</span>;

* Identifier
** Locking of identifier in case of existing OAIP entries <span style="color: violet">Postponed (T. Weibulat)</span>;

* Agents
** Showing display text and code for selection of role <span style="background-color: #F08080;">noch testen, C. Monje, Email 2020-06-08 10:22</span> 
** Bugfix inserting several agents <span style="color: green">OK,  T. Weibulat</span> 
 

* Descriptors
** Sorted by alphabet <span style="background-color: #F08080;">noch testen, T. Weibulat</span>  

* Modules
** Scanning for entries in modules (For details see manual, keyword Module connections) <span style="color: green">OK,  (T. Weibulat)</span>;
** Connection timeout set to 3 seconds by default <span style="background-color: #F08080;">noch testen, T. Weibulat</span> 


'''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 <span style="color: green">OK,  (T. Weibulat)</span>;

* 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.  <span style="color: green">OK,  (T. Weibulat)</span>; 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 <span style="background-color: #F08080;">tests pending</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=Tests pending
|content=Tests pending:
* Project - Interface for other modules testing existence of stable identifier base  <span style="color: green">OK (T. Weibulat)</span>
* Bugfix starting application  <span style="color: green">OK (B. Klasen, E-mail 26.1.2018 11:04)</span>
* Setting the notes for Identifier  <span style="color: green">OK (B. Klasen, E-mail 21.2.2018 11:50)</span>
* Creation of security objects for REST access <span style="background-color: #F08080;">noch testen, S. Seifert</span> 
* GFBio import:
** Ignoring settings with missing values <span style="color: green">OK (B. Klasen)</span>
** Inclusion of URL for GFBioIssueID  <span style="color: green">OK (B. Klasen, E-mail 21.2.2018 12:02)</span>
* Inclusion of webservices of GFBio and GBIF  <span style="background-color: #F08080;">noch testen, T. Weibulat, B. Klasen, P. Grobe. E-mail 11.10.2018 11:07</span>
* Blocking change of descriptor type for module-linked entries <span style="background-color: #F08080;">noch testen, T. Weibulat</span>
* Several bugfixes  <span style="background-color: #F08080;">noch testen, T. Weibulat. E-mail 11.12.2018, 12:28</span>

'''Database updates'''
* Database update to version 2.1.20: New types for Descriptor; Missing descriptions <span style="color: green">OK T. Weibulat</span>
}}

====Planned features====
Functions <span style="background-color: #87CEFA;">planned</span>, to be implemented in one of the next DP versions
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=Planned features
|content=Planned features:
* Saving changes in data - bugfix  <span style="background-color: #87CEFA;"> (T. Weibulat, Feedback 18.07.2016)</span>
* Setting resources directory   <span style="color: violet">getestet, email V. Sanz 24.10.2017 17:07; Manual: Directory for resources</span>
* Publication of database scheme and ER model of DP, see under [[Information models]], attention DOI compliance!
* Label + Keyword -> Descriptor

<span style="background-color: #87CEFA;">'''Database updates'''</span>
* 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;   <span style="color: violet">Noch testen</span>
<span style="background-color: #87CEFA;">'''Manual'''</span>
* Database tools
* Database description
}}

----

===DiversityReferences===
DR version for <span style="background-color: #F08080;">testing</span>

The current client application is built for Microsoft [https://dotnet.microsoft.com/download/dotnet-framework/net48 .Net Framework 4.8.]
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityReferences/DiversityReferencesSetup_4_3_1.zip Installer for client software 4.3.1 (zip archive)],  2023/09/05 (Database 02.01.06)<!---->
|content=New features and fixes:
* Change password repaired
* Show links in HTML

'''Datebase updates'''

-

'''Manual'''

Updated contents: 
-

New contents:
-
}}
'''Alternative download''' (If you do not have administrator rights on your computer or want to use different application versions in parallel.)
* ''Download'' the [https://www.diversityworkbench.de/clients/DiversityReferences/DiversityReferences_4_2_1.zip Client software 4.2.1 (zipped program folder) '''without''' manual]


----

===DiversityResources===


----
===DiversitySamplingPlots===
der Link zur aktuellen Betaversion von DiversitySamplingPlots

DSP version for <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversitySamplingPlots/DiversitySamplingPlotsSetup_4_5_1.zip Installer for client software 4.5.1 (zip archive)], 2023/08/25
|content=New features and fixes
*see chapter [https://www.diversityworkbench.de/manual/dwb/diversitysamplingplots/newfeaturesandfixes/index.html New features and fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversitySamplingPlots/DiversitySamplingPlotsSetup_4_4_11.zip Installer for client software 4.4.11 (zip archive)], 2023/04/21
|content=new features and fixes
*see chapter [https://www.diversityworkbench.de/manual/DiversitySamplingPlots/NewFeaturesAndFixes.htm New features and fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversitySamplingPlots/DiversitySamplingPlotsSetup_4_4_10.zip Installer for client software 4.4.10 (zip archive)], 2022/11/02
|content=
[http://www.diversityworkbench.de/manual/DiversitySamplingPlots/NewFeaturesAndFixes.htm New features and fixes]
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversitySamplingPlots/DiversitySamplingPlotsSetup_4_4_7.zip Installer for client software 4.4.7 (zip archive)], 2021/12/02
|content=New features and fixes:

* Creation of database included.
* New start mode for udpate <span style="background-color: #F08080;">noch testen</span>

* Bugfix maps <span style="background-color: #F08080;">noch testen, Email 19.11.2021 um 08:48, Ingo Wendt</span>

}}


<!--

'''Datebase updates'''
* Update database to version 01.00.35: New stored procedure SetUserProjects to set the project access for a user ("Tonis SetUserProjects"); 

-->

<!-- 
DSP version for <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversitySamplingPlotsSetup_4_3_1.zip|Installer for client software 4.3.1 (zip archive)]], 2020/06/26
|content=New features and fixes:
* Help file adapted to .NET 4.8.
* No blanks in the name of the installed application in program menu and desktop icon.
}}
DSP version for <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversitySamplingPlotsSetup_4_1_2.zip|Installer for client software 4.1.2 (zip archive)]], 2020/04/17
|content=New features and fixes:
* DWB Bugfix in Property selection drop down menu (ScientificTerms) <span style="color: green">tested</span> (Florian Raub, EMail 16.04.2020)</span>
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversitySamplingPlotsSetup_4_1_1.zip|Installer for DSP software 4.1.1 (zip archive)]], 2020/03/30
|content=New features and fixes:
* DWB Bugfix in Properties (ScientificTerms) <span style="background-color: #F08080;">Noch testen (Florian Raub, EMail 30.03.2020)</span>
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversitySamplingPlots_3_0_11_5.zip|Client software 3.0.11.5 (zip archive)]], 2019/07/01
|content=New features and fixes:
* New query conditions "Plot localisation hierarchy" added to get the entries matching certain localisations and the inherited entries <span style="background-color: #F08080;">Noch testen (Thomas Stierhof, EMail 17.04.2019)</span>
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversitySamplingPlots_3_0_11_4.zip|Client software 3.0.11.4 (zip archive)]], 2019/05/14
|content=New features and fixes:
* New Property query option implemented: Property - Terms <span style="background-color: #F08080;">Noch testen (Florian Raub, Feedback 01.04.2019)</span>
* Hierarchy query option enabled again in Scientific Terms module connection  <span style="background-color: #F08080;">Noch testen (Florian Raub, EMail 13.05.2019)</span>
}}
DSP version for <span style="background-color: #F08080;">testing</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversitySamplingPlots_3_0_11_1.zip|Client software 3.0.11.1 (zip archive)]], 2019/01/28
|content=New features and fixes:
* Feedback call has been changed to current Workbench version. <span style="color: green">tested</span>
* Typo fixed in Help file Installation page. <span style="color: green">tested</span>
}}-->

----

===DiversityScientificTerms===
DST version for <span style="background-color: #F08080;">testing</span>

The current client application is built for Microsoft [https://dotnet.microsoft.com/download/dotnet-framework/net48 .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 .Net framework (see [[General Download Notes]])

{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityScientificTerms/DiversityScientificTermsSetup_4_1_21.zip Installer for client software 4.1.21 (zip archive)], 2023/02/22<!---->
|content=
[[http://www.diversityworkbench.de/manual/DiversityScientificTerms4/NewFeaturesAndFixes.htm New features and fixes]]
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityScientificTerms/DiversityScientificTermsSetup_4_1_19.zip Installer for client software 4.1.19 (zip archive)], 2021/08/03<!---->
|content=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 <span style="background-color: #F08080;">noch testen</span>;

* 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 <span style="background-color: LightCoral">noch testen (T. Weibulat)</span>;
** Change to DisplayText when switching from Terms to Types in case of Display column is Ranking <span style="background-color: LightCoral">noch testen (T. Weibulat)</span>;
** Return to previous Display column when switching between Terms and Types <span style="background-color: LightCoral">noch testen (T. Weibulat)</span>;
** Query showing hierarchy of ranking terms;
** Enabling query for several properties <span style="background-color: LightCoral">noch testen (Email 23.07.2021 um 11:37 Felix Hentschel)</span>;
** 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 <span style="background-color: LightCoral">noch testen (F. Hentschel)</span>;

* Archive
** Administrate Archives <span style="background-color: LightCoral">noch testen (T. Weibulat)</span>;
** Create Archive <span style="background-color: LightCoral">noch testen (T. Weibulat)</span>;
** Clean database <span style="background-color: LightCoral">noch testen (T. Weibulat)</span>;
** Restore archive <span style="background-color: LightCoral">noch testen (T. Weibulat)</span>;
** Create schema <span style="background-color: LightCoral">noch testen (T. Weibulat)</span>;

* 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  <span style="background-color: LightCoral">noch testen</span>
* 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;   <span style="background-color: LightCoral">noch testen</span>
* Version 1.0.14: View for TermResource excluding XML column; Description for several objects; Generic SetUserProjects  <span style="background-color: LightCoral">noch testen</span>

* 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 <span style="background-color: LightCoral">noch testen</span>

* Version 1.0.14: New stored procedure SetUserProjects to set the project access for a user ("Tonis SetUserProjects") <span style="background-color: LightCoral">noch testen</span>

}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityScientificTerms/DiversityScientificTerms_3_0_1_9_c.zip Client software 3.0.1.9 c (zip archive)], 2019/05/24
|content=New features and fixes:

* Query: Search for a list, synonyms or hierarchy included  <span style="background-color: #F08080;">noch testen</span>
* Language: 
** Enabling included  <span style="background-color: #F08080;">noch testen</span>
** Selection restricted to enabled languages  <span style="background-color: #F08080;">noch testen</span>

<!--
* Buttons for setting and removing the broader term  <span style="background-color: #F08080;">noch testen</span>

* Button for setting the synonymy  <span style="background-color: #F08080;">noch testen</span>


'''Database updates'''
* Version 1.0.10: corrections for column descriptions; TerminologyPropertyValue + log + trigger, New type list for type of property    <span style="color: violet">noch testen</span>
* Version 1.0.11: UserProxy - Add ID, PrivacyConsent and PrivacyConsentDate, Trigger for setting PrivacyConsentDate - according to EU-DSGVO; Function providing the ID of the user from UserProxy; Function providing the name of the user from UserProxy; Function PrivacyConsentInfo providing common information within the DiversityWorkbench   <span style="color: violet">noch testen</span>
-->
}}

====Test pending====
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=DiversityScientificTerms - Test pending
|content=Test pending:
* Buttons for setting and removing the broader term  <span style="background-color: #F08080;">noch testen</span>
* Button for setting the synonymy  <span style="background-color: #F08080;">noch testen</span>
}}

====Planned features====
Functions <span style="background-color: #87CEFA;">planned</span>, to be implemented in one of the next DST versions
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=DiversityScientificTerms - Planned features
|content=Planned features:
* Implement hierarchy search in ScientificTerms module like in SamplingPlots, e.g. search "woodland" only in properties of current hierarchy level or below  <span style="background-color: #87CEFA;"> (Request from SMNK, F. Raub / T. Stierhof)</span>
}}

----

===DiversityTaxonNames===
DTN version for <span style="background-color: #F08080;">testing</span>

{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityTaxonNames/DiversityTaxonNamesSetup_4_2_1.zip Installer for client software 4.2.1 (zip archive)], 2023/08/21<!---->
|content=New features and fixes:
*See chapter [https://www.diversityworkbench.de/manual/dwb/diversitytaxonnames/news/index.html New features and fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityTaxonNames/DiversityTaxonNamesSetup_4_1_28.zip Installer for client software 4.1.28 (zip archive)], 2023/03/28<!---->
|content=New features and fixes:
*See chapter [http://www.diversityworkbench.de/manual/DiversityTaxonNames4/NewFeaturesAndFixes.htm New features and fixes] in the manual
}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [https://www.diversityworkbench.de/clients/DiversityTaxonNames/DiversityTaxonNamesSetup_4_1_24.zip Installer for client software 4.1.24 (zip archive)], 2021/07/09
|content=New features and fixes:
* .Net Framework 4.8
* Backlinks from DiversityCollection and DiversityDescriptions redesigned 
* Test for charts included
* New start mode updatedatabase <span style="background-color: #F08080;">noch testen</span>;

* Archive
** Creation of schema included

* Exclusion of default project from optional projects when creating a new taxon <span style="background-color: #F08080;">noch testen, B. Klasen E-mail 2020-04-23 11:15</span>
* Export of checklists <span style="background-color: #F08080;">noch testen, M. Ruff</span>
* Export of hierarchy <span style="background-color: #F08080;">noch testen, M. Ruff</span>
* Connection menu - Server activity included <span style="background-color: #F08080;">noch testen, M. Ruff</span>

* Export of table view set to DWB Export directory <span style="background-color: #F08080;">noch testen, G. Rambold</span>

* Hierachy
** Checking for loops in hierarchy <span style="background-color: #F08080;">noch testen, M. Ebert, T. Weibulat</span>

* Export wizard
** Synonyms in relation to selected name <span style="background-color: #F08080;">noch testen, M. Ruff</span>
** BaseURL included <span style="background-color: #F08080;">noch testen, M. Schwager, E-mail 2020-06-18 08:45</span>

* Analysis
** Sorting and datawithholding added <span style="background-color: #F08080;">noch testen, M. Ruff</span>

* Export of synonyms <span style="background-color: #F08080;">noch testen, G. Rambold</span>

* Resources with new columns Title, IPR, Creator, CreatorAgentURI, CopyrightStatement, LicenseType, LicenseHolder, LicenseHolderAgentURI, LicenseYear, DisplayOrder, DataWithholdingReason

* Import wizard
** Import of synonymy <span style="color: green">OK, B. Klasen</span>
** Import of accepted names and synonyms <span style="background-color: #F08080;">noch testen, B. Klasen</span>

====Database updates====
* Version 02.05.30: trgUpdTaxonName: Bugfix in where clause <span style="color: green;">Detected by B. Quast</span>; TaxonFamily: Include family as name to enable hierarchy entry for identifications as family <span style="background-color: #F08080;">noch testen, F. Raub</span>; 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");

}}
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=''Download'' the [[Media:DiversityTaxonNames_3_0_3_5_h.zip|Client software 3.0.3.5 h (zip archive)]], 2019/06/21<!---->
|content=New features and fixes:
* Enabling access to external datasources for users with read only access <span style="background-color: #F08080;">noch testen, F. Raub, Feedback 07.01.2019 12:05</span>
* Query for names in same modul according to list, hierarchy and/or synonymy included <span style="background-color: #F08080;">noch testen, F. Raub, E-mail 13.02.2019 um 11:54</span>
* Creation type suchfähig machen  <span style="color: green;">C. Dalitz, Email 04.07.2018 10:13</span>
* Search for linked specimen redesigned with optional start of application DC <span style="background-color: #F08080;">noch testen</span>
* Search for linked descriptions with optional start of application DD <span style="background-color: #F08080;">noch testen</span>
* Setting timeout <span style="background-color: #F08080;">noch testen, M. Ruff, Feedback 15.05.2019 11:53</span>
* Update of hierarchy cache <span style="background-color: #F08080;">noch testen, D. Triebel, Feedback 16.04.2019 13:33</span>
* Maintenance
** Removal of self-referred synomyms <span style="background-color: #F08080;">noch testen</span>
** Ignoring of self-referred synomyms <span style="background-color: #F08080;">noch testen</span>
** Inspection of self-referred synomyms in main form <span style="background-color: #F08080;">noch testen</span>
*Access to reference list of MelNames and Goeverts removed
<!--

* Adaption to monitor resolution
* Button for refreshing hierarchy cache <span style="background-color: #F08080;">noch testen: D. Triebel (Feedback 12.10.2018 11:15)</span>
* Menu settings according to connection <span style="background-color: #F08080;">noch testen</span>
* Spreadsheet: several bugfixes <span style="background-color: #F08080;">noch testen</span>
* Opening URL for external data sources in default browser <span style="background-color: #F08080;">noch testen: F. Raub, Feedback 31.07.2018 13:10</span>
* Import wizard: Ignore but keep for reference included <span style="background-color: #F08080;">noch testen: M.Ruff, E-mail 28.11.2018, 10:51</span>
-->
<!--
* Privacy consent - bugfix and button for setting the consent in login administration  <span style="color: green">OK: C. Monje E-mail (08.06.2018 15:12)</span>
* Bugfix Maintenance - Open duplicates in main form <span style="color: green">OK, P. Grobe E-mail 21.06.2018 10:30</span>
* Correct version <span style="color: green">OK, P. Grobe E-mail 21.06.2018 10:30</span>
* Marking withholding reason with colored background <span style="color: green">OK</span>

* Display of analysis value description - Bugfix  <span style="color: green">OK: T. Stierhof (3.11.2017)</span>
* Marking of duplicates in main form  <span style="color: violet">noch testen: B. Quast (E-mail 19.10.2017 15:28)</span>
* Detection of duplicates in maintenace  <span style="color: violet">noch testen: B. Quast (E-mail 19.10.2017 15:28)</span>
* Deleting entries in analysis - Bugfix  <span style="color: green">OK: T. Stierhof (E-mail 9.11.2017 14:35)</span>
* Setting parent of analysis - Bugfix  <span style="color: green">OK: T. Stierhof (E-mail 29.11.2017 13:41)</span>
* Showing description of analysis - Bugfix  <span style="color: green">OK: T. Stierhof</span>
* Editing notes of analysis category - Bugfix  <span style="color: green">OK: T. Stierhof</span>
* Display of analysis entries sorted  <span style="color: green">OK: T. Stierhof</span>
* Table editor for analysis  <span style="color: green">OK: T. Stierhof</span>
* Export wizard for analysis  <span style="color: violet">Noch testen: T. Stierhof</span>
* Table editor - bugfix including screenshot in feedback  <span style="color: green">OK: T. Stierhof, Feedback 29.03.2018 15:26</span>
* Login according to EU-DSGVO  <span style="color: violet">noch testen</span>
====Database updates====
* Version 02.05.29: UserProxy - Add ID, PrivacyConsent and PrivacyConsentDate, Trigger for setting PrivacyConsentDate - according to EU-DSGVO; Function providing the ID of the user from UserProxy; Function providing the name of the user from UserProxy; Function PrivacyConsentInfo providing common information within the DiversityWorkbench   <span style="color: violet">noch testen</span>
-->

}}

==== Test pending ====
Features already in regular DTN release, but <span style="background-color: #F08080;">tests pending</span>
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=Tests pending
|content=Tests pending:
* Button for refreshing hierarchy cache <span style="background-color: #F08080;">noch testen: D. Triebel (Feedback 12.10.2018 11:15)</span>
* Menu settings according to connection <span style="background-color: #F08080;">noch testen</span>
* Spreadsheet: several bugfixes <span style="background-color: #F08080;">noch testen</span>
* Opening URL for external data sources in default browser <span style="background-color: #F08080;">noch testen: F. Raub, Feedback 31.07.2018 13:10</span>
* Import wizard: Ignore but keep for reference included <span style="background-color: #F08080;">noch testen: M.Ruff, E-mail 28.11.2018, 10:51</span>

}}

====Planned features====
Functions <span style="background-color: #87CEFA;">planned</span>, to be implemented in one of the next DTN versions
{{Hidden
|toggle position=left
|contentstyle=border-left:1px solid #cccccc;padding-left:1ex;
|header=Planned features
* Test for duplicates for Taxa in import wizard  <span style="background-color: #87CEFA;">B. Quast, Email 19.10.2017 16:22</span>
* Spreadsheet for TaxonName  <span style="color: violet">noch testen</span>
* Die Suchfunktion nach "Hierarchy missing" klappt nicht so richtig - es kommen lauter Ergebnisse von Taxa, bei denen eine Hierarchie doch vorhanden is  <span style="background-color: #87CEFA;">E-mail H. Boyle, 07.02.2018 00:24</span>
<!--
E-mail 16.10.20117 11:39
Beziehung geloescht
ALTER TABLE [dbo].[TaxonNameListProjectProxy]  DROP  CONSTRAINT [FK_TaxonNameListProjectProxy_ProjectProxy]
GO
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TaxonNameListReference_TaxonNameListReferenceType_Enum". The conflict occurred in database "DiversityTaxonNames_ArchiveTest", table "dbo.TaxonNameListReferenceType_Enum", column 'Code'.
The statement has been terminated.
SQL-Statement:
SET IDENTITY_INSERT [TaxonNameListReference] ON; INSERT INTO [TaxonNameListReference] ([NameID], [ProjectID], [TaxonNameListRefID], [TaxonNameListRefText], [TaxonNameListRefURI], [TaxonNameListRefDetail], [ReferenceType], [TaxonUsageContext], [Notes], [LogInsertedBy], [LogInsertedWhen], [LogUpdatedBy], [LogUpdatedWhen], [RowGUID]) VALUES (2028217, 54, 72, 'Reference List - Test', 'http://development.diversityworkbench.de/References_Test/1740132258', NULL, 'Publication', NULL, 'Notes from Ref', 'dbo', CONVERT(datetime, '2015-3-3 12:37:0', 121), 'dbo', CONVERT(datetime, '2015-3-3 12:37:0', 121), '7e12f292-99c1-e411-80f1-f3c8b39e8207')
-->
* History restoring deleted data including restriction of timerange  <span style="color: violet">noch testen</span>
<!--
E-mail 16.10.2017 13:10
es wird noch alles genommen - evtl. Abfrage bis zu welchem Datum die Daten geholt werden sollen
-->
}}