Difference between revisions of "DWB clients for beta testing"

New features and fixes:

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

• Contacts
  • Button for display of public contacts (For details see manual - kexword Contact) (For DiversityAgents_Test on server development.diversityworkbench.de only) OK (T. Weibulat);;

• Identifier for agents included (For DiversityAgents_Test on server development.diversityworkbench.de only) OK, (T. Weibulat);
  • Administration of identifier types OK (T. Weibulat);

• Search for back links from modules DC and DP included (For DiversityAgents_Test on server development.diversityworkbench.de only) OK (T. Weibulat);

• Hierarchy
  • Additional hierarchies included (For DiversityAgents_Test on server development.diversityworkbench.de only) getestet - klickt man auf "set the superior agent", öffnet sich das Fenster, um diesen hinzuzufügen; trägt man hier nun etwas in das Feld Agent ein und drückt dann "Enter" (wie sonst üblich), schließt sich das Fenster wieder, anstatt dass die Suche gestartet wird. Das Anlegen mehrerer Hierarchien funktioniert, aber: Ich habe die SNSB mit BSM, BSPG, ZSM,.. etc darunter angelegt. Dann habe ich mich (ID: 41736) als Mitarbeiterin von BSM und BSPG angelegt. Klicke ich dann in der Hierarchie auf z.B. BSPG, sehe ich mich gelb markiert als Mitarbeiterin eben dieser, nicht jedoch als Mitarbeiterin von BSM. Will ich mir über den Fernglas-Button nun die komplette Hierarchie von den SNSB (ID: 37674) aus ansehen, funktioniert dies gar nicht (Feld bleibt leer) (und umgekehrt)(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) noch testen (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
• Archive
  • Administrate Archives Postponed (T. Weibulat);
  • Create Archive Postponed (T. Weibulat);
  • Clean database (Restoring default project DiversityWorkbench, ID = 0) Postponed (T. Weibulat);
  • Restore archive Postponed (T. Weibulat);
  • Create schema Postponed (T. Weibulat);
• Documentation
  • Trigger and their definition included
  • Definition of functions and procedures included
• Connection menu
  • Current server activity noch testen (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 Testability not given in test environment (T. Weibulat);

• Update database to version 02.01.15: AgentImageType_Enum; Add content: Logo, Portrait; AgentImage: Add Type, Sequence; trgDelAgentImage; trgUpdAgentImage Testability not given in test environment (T. Weibulat);

• 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 Testability not given in test environment (T. Weibulat);

Tests pending:

Planned features:

• Import wizard (C. Dalitz, E-mail 20.10.2017 11:38)

Datebase updates

• Update database to version 02.01.11: ...;

Manual

• Inclusion of database tools, update withholding

New features and fixes:

• 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 noch testen (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 noch testen (K.H. Rexer)
  • Changing images noch testen (A. Beck)

• Tab sequence in login window noch testen (SMNS, I. Wendt, E-mail 2020-02-28 16:04)

• 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 noch testen (M. Ruff)
  • Bugfix for Synchronization agents via text noch testen (M. Ruff)

• Query
  • Scan mode for collection query with optional inclusion of hierarchy noch testen (F. Raub)
  • Queryresults including collection hierarchy noch testen (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)

• Cache database
  • Transfer of taxonomic groups in dependence of link to taxonomic thesaurus noch testen (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 noch testen (M. Ruff)
  • 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

• Spreadsheet
  • Exclusion of symbol values from evaluation in map noch testen (M. Ruff)
  • Bugfix setting fixed source in case of CacheDB noch testen (M. Ruff)

• Collection
  • Query for abbreviation noch testen (T. Weibulat)
  • Abbreviation in form with separate label

• Taxonlist
  • with optional count of number of units
  • Bugfix for dataretrieval from databases on linked server

• 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 noch testen (M. Ruff)
  • Isolation level for counts set to read uncommitted noch testen (M. Ruff)
  • Exclusion of RowGUID from column test OK (F. Raub, E-mail 2020-03-27 09:54)

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

• Export wizard
  • Module link for Part description included OK (F. Raub)

• 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
  • Bufix transaction in country list OK (I. Sebek)

• Table editor
  • Bugfix inserting date values noch testen (M. Ruff)
  • Part description added OK (F. Raub)

• Archive
  • Schema including name of module and version, columns including description
  • Creation of table schemata independent of content

Datebase updates

• Version 02.06.22: Identification: new column DependsOnIdentificationSequence + trgDelIdentification, trgUpdIdentification - Add DependsOnIdentificationSequence; 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: trgIdentificationInsert: Do not include depending identifications; trgUpdIdentification - Do not include depending identifications noch testen

Cache Datebase updates

• CacheDB updates
  • Version 1.0.28: TaxonAnalysisCategory - Add SortingID
  • Version 1.0.29: New table AgentImage; AgentSource - Add Version; GazetteerSource - Add Version; ReferenceTitleSource - Add Version; SamplingPlotSource - Add Version; ScientificTermSource - Add Version; TaxonSynonymySource - Add Version;

• 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

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: Add Table AgentImage

• Schema updates
  • Version 23: CacheMetadata - DatasetDetails to text
• Package updates
  • ABCD
    • Version 5: abcd__unit() - SourceInstitutionID: set to if NULL; ABCD_TechnicalContact and ABCD_ContentContact from DA; 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 in public: add column MeasurementOrFactReference.
    • AddOn BayernFlora
      • Version 4: abcd__unit: adding new columns and restriction to present NameID. abcd__measurementorfact: adding new column noch testen (M. Ruff)

New features and fixes:

• Installer creates shortcut on desktop and in program menu
• Main form
  • Complete redesign
  • Header showing labels and images reduced to one option
  • Header with spotlight indicating presence of images
  • Display for exsiccata separated and marked with icon
  • References included in event, specimen, identfication removed - available via separate controls
  • Description of unit in part moved to part description

• Resources for user placed outside program directory
  • 3 Options to places resources: Home, Documents, User defined

Datebase updates

• Version 02.06.20: CollectionSpecimenReference - Add column IdentificationSequence + Trigger; Transfer data from Identification to CollectionSpecimenReference; ExternalIdentifier - GRANT VIEW DEFINITION; CollectionAgent_Core: CollectionSpecimenID_Available instead of CollectionSpecimenID_UserAvailable; CollIdentificationCategory_Enum: changed descriptions for negative and dubious; UserID() - if SUSER_SNAME is not found, try USER_NAME, overwise -1; CollectionSpecimenPartDescription: add IdentificationUnitID for optional link to unit + Trigger; Transfer of description from table IdentificationUnitInPart into CollectionSpecimenPartDescription; Adaption of description of column Description in table IdentificationUnitInPart; Transfer of reference from table CollectionSpecimen into CollectionSpecimenReference ; Adaption of description of reference columns in table CollectionSpecimen

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
  • Calculation of chunks via SQL OK, M. Ruff, E-mail 11.03.2019 um 10:032
• 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
  • Query columns extended OK SMNS (A. Jandl)

• • TK25
    • New number for analysis generation depending on first character up to Z OK, M. Ruff
    • Restriction of analysis values to list OK, M. Ruff, E-mail 12.03.2019 um 13:57
    • Bugfix creating analysis numbers beyond A OK, M. Ruff, E-mail 12.03.2019 um 13:57
    • Bugfix including symbol for missing values in map OK, M. Ruff, E-mail 13.03.2019 um 08:52
    • New symbol: Circle with point OK, M. Ruff, E-mail 13.03.2019 um 08:52
    • Calculation of average year from end year when start date is missing OK, M. Ruff, E-mail 13.03.2019 um 08:59

• 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)
• Table editor: indication for active update OK, A. Jandl (Feedback 29.10.2018 17:43)
• Table editor: Dataadapter set to ConflictOption = OverwriteChanges OK, A. Jandl (Feedback 29.10.2018 17:43)
• Text editing: Message for text with length higher than allowed in window for text editing OK SMNS, A. Jandl (E-mail, 05.11.2018 um 14:43)
  • 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
  • Bugfix for retrieval of table name noch testen, M. Ruff

• Query
  • Disabling and enabling buttons (e.g. Optimizing, Clear, Save, ... ) according to query state (Predefined or not) noch testen
  • Bugfix for partly filled dates for query with < and > OK, A. Rosenbauer E-mail, 24.07.2018 um 14:02
  • 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)
  • Synchronizing with Gazetteer: Ignoring geographical names not linked to a place OK, A. Jandl Feedback, 07.05.2018 11:46
  • Setting missing collection dates: Restriction to first datasets included OK, A. Rosenbauer E-mail, 24.07.2018 um 14:02
  • 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)
  • Synchronizing agents - Bugfixes OK SMNS, A. Jandl (Feedback 29.08.2018 14:27

• Spreadsheet
  • Bugfix filtering for a list of values Noch testen, I. Sebek
  • Removing sorting together with filter using context menu OK, M. Ruff

• 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

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

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)
  • TK25
    • including Maps OK, M. Ruff Feedback 07.12.2017 08:55
    • including Filter OK, M. Ruff Feedback 07.12.2017 08:55
    • Filter for links to taxa including Hierarchy, Synonymy and the combiniation OK, M. Ruff Feedback
    • Filter for links to taxa including Hierarchy, Synonymy and the combiniation for several taxa TODO, M. Ruff Feedback 11.01.2018 10:40

• 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

• Version 02.06.14: Changing tables according to DSGVO noch testen

Cache database updates

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).

New features and fixes:

• Error in language code editor fixed
• Login administration
  • Improved error messages for insufficient edit rights
• Form for server activities integrated
• Form for linked servers integrated
• Maintenance
  • New option to fix descriptor column in descriptor tree maintenance for measures, modifiers and frequencies
• Structured export (SDD, DELTA, EML)
  • Generator for project metadata switched to new interface
• New form for cache database (under construction!!!)
  • Adjustment of transfer depending on "withhold" descriptor data status
  • Adjustment of key mapping for descriptions, descriptors and states
  • Transfer restrictions for descriptions, descriptors and scopes
• Summarize descriptions/sampling data
  • New option to include additional information (summarized datasets) in notes
• Questionnaires
  • New option to control output of order numbers for descriptors and categorical states
  • New option to include scope data in questionnaires
  • New option to adjust zoom factors for mouse hover on resources
  • New import of scope data
• Query
  • New option to keep selected entries of the query result list and remove the rest
  • New menu item to select a preferred project for description and descriptor queries
• Import wizard
  • New search option in the import session mapping view
• Generate document
  • New option to include scope data from foreign databases for HTML and Pensoft
  • Options for translations and wording inserted for Pensoft
  • New option for suppressing notes for Pensoft
  • Error in handling of "Data title" option for HTML corrected
• New option to create a new description with a scope reference from the command line
  • Additional error message for invalid URI
  • Error correction for SQL-login
• Installer: Remove old versions in APP list
• Miscellaneous error corrections

Database updates

• New tables for cache database:
  • CacheDatabase
  • CacheProject
  • CacheMappingDescription
  • CacheMappingDescriptor
  • CacheMappingCategoricalState
• New views:
  • ProjectList
  • WithheldData
• New procedures:
  • procCreateCacheMappingDescriptor
  • procCreateCacheMappingState
  • procCreateCacheMappingDescription
• Altered triggers for descriptive data and terminology to actualize time stamp in CacheProject for changes
• Remove references to taxon set and descriptor tree from project and project_log to avoid cyclic referencing
  • Update of copy procedures and triggers for removed columns

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

• Download the Client software 4.1.8 (zipped program folder) without manual

Updated contents:

• Menu
• Queries
  • Query
  • Result list
• Export Questionnaires
• Import wizard
  • Import sessions
• Generate documents
  • Generate description document
  • Generate descriptor document
  • Generate project document
• Data access
  • Security
  • Login administration

New contents:

• Data availability
• Cache database
  • Basic steps
  • Create cache database
  • Projects
  • ID mapping
  • Restrictions
• Import / Export
  • Import
  • Export
  • File operations

New features and fixes:

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

New features and fixes:

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

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

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

New features and fixes:

• Bugfix: Query failed: "DataReader.GetFieldType(1) returned null". The Windows Installer includes an actual Microsoft.SqlServer.Types.dll which causes this error. Changed to older version of this Dll which works properly.
• Official version had wrong version number in header. Has been adapted to actual Version.

New features and fixes:

• OAIP - Disabled
  • 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);

• Import GFBio
  • Archive -> Archive, Agents -> DiversityAgents Postponed (T. Weibulat);
  • Import wizard Postponed (T. Weibulat);

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

• Modules
  • Scanning for entries in modules 'Modules' is empty (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 Testability not given in test environment (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. Testability not given in test environment (T. Weibulat); Correction of descriptions

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:

• 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

New features and fixes:

• Missing tool tips added
• New forms for linked server and server activity added
• Problem with module connections solved
• Modified layout of main form
• Find links of other Diversity Workbench applications to selected reference entry
• Remember previously performed query after program start
• Import of tagged text (RIS):
  • Improved handling of error cases
  • Desensitized interpretation of dates
  • Show imported datasets in main window

Datebase updates

• none

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

• Download the Client software 4.0.4 (zipped program folder) without manual

Updated contents:

• Data editing
• Query
• Import tagged text

New contents:

• Back links

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

New features and fixes:

• DWB Bugfix in Properties (ScientificTerms) Noch testen (Florian Raub, EMail 30.03.2020)

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

• Resources for user placed outside program directory
  • 3 Options to places resources: Home, Documents, User defined

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

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:

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

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)

New features and fixes:

• .Net Framework 4.8
• Backlinks from DiversityCollection and DiversityDescriptions redesigned
• Archive
  • Creation of schema included
• Exclusion of default project from optional projects when creating a new taxon noch testen, B. Klasen
• Export of checklists noch testen, M. Ruff
• Export of hierarchy noch testen, M. Ruff
• Connection menu - Server activity included noch testen, M. Ruff
• Export wizard - Synonyms in relation to selected name noch testen, M. Ruff
• Analysis
  • Sorting and datawithholding addes noch testen, M. Ruff

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: ProjectList - include ProjectURI to enable Backlink search;

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

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