Diversity Agents

Download

Upcoming version

4.2.5

SQL Server 2016

For this version you need SQL Server 2016 or higher

  • New table JsonCache containing the data related to an agent as JSON. In the menu accessible via Administration → Json cache … or in the header click on the Show JsonCache button to see the json cache for the current agent.

Database updates

DiversityAgentsUpdate_020125_to_020126
  • JsonCache
    • New table JsonCache
    • New views JsonCache_FullAccess and JsonCache_Public
    • New procedure procFillJsonCache
    • trgUpdAgent - including update for JsonCache

Current version

4.2.4 (2024-07-30)

Download

  • Deleting selected agents
  • Removing selected agents from project

Updates in DWB Libraries

  • Import wizard with optional translation of \r\n in data into line break

Database updates

DiversityAgentsUpdate_020124_to_020125
  • New titles in AgentTitle_Enum
  • New gender diverse in AgentGender_Enum

Previous versions

4.2.3 (2024-06-25)

Download

  • Query: Inclusion of datawithholding and agent gender in query
  • Export wizard included
  • In data menu option to delete selected agents
  • In data menu option to remove selected agents from selected project

4.2.2 (2023-01-08)

Download

  • Editing of enumerations included
  • Bugfix saving data
  • Update of linked data in DiversityCollection and DiversityProjects Video starten
  • Showing first image in header
  • Bugfix client format
  • Images for descriptor types Video starten

 

4.2.1 (2023-07-12)

  • Button to show resp. get URL for Identifier

  • Help provided by online manual

  • Bugfix removing links to external data

  • Visibility of button for removal of synonymy depending on presence of synonymy

  • Showing synonym in interface for linked modules

  • Bugfix missing WebView-Runtimes

  • Database updates

    • 02.01.24: ProjectUser: Adding ReadOnly for locking a project;

4.2

Download (2023-05-08)

  • Bugfixes in Workbench.dll

 

4.1.41 (2023-05-03)

  • Adding query columns ValidFrom and ValidUntil

Datebase updates

  • 02.01.23: AgentContactInformation_Public - avoiding loops; Missing relation between [SynonymToAgentID] and [AgentID] in [dbo].[Agent]; Agent_Core: Adding column ValidFrom and ValidUntil; Missing descriptions;

 

4.1.40 (2023-04-05)

  • Bugfix query for partial available dates

 

4.1.39 (2023-04-03)

  • Hierarchy: ensure visibilty of selected agent
  • Additional query display column Identifier
  • Additional query restrictions for Identifier
  • Setting default for optimizing and remembering of query with context menu
  • New form for setting defaults and loading of linked server connections with start
  • Documentation of database improved
  • Several bugfixes for many order columns

4.1.34

  • Hierarchy: ensure visibilty of selected agent

4.1.35

  • Login administration: Enable setting read only for projects

4.1.36

  • Hierarchy: Ensure result despite loop, prevent building of new loops
  • Enable locking of projects
  • Ensure read only for locked and read only datasets
  • Images display reorganized and bugfix access
  • Login administration: Filter for names
  • Projects
    • Read only
    • Locked
  • Menu:
    • Reconnect to database
    • Client update

4.1.37

  • Contacts: Hiding display order for cumulative address
  • Hierarchies: Explizit message for loops and removal of loops
  • Table editors: Other hierarchies, References, Identifier, Descriptor and Relation added
  • Startup window added
  • Restriction of agent refill when needed
  • Button for removal of synonymy relation in case of loops
  • Button for setting of content language including images for main languages
  • Display of loop in hierarchy
  • Display of loop in synonymy
  • Bugfix adding contact information
  • Bugfix enabling controls according to ReadOnly status

4.1.38

  • Bugfix query for missing dates
  • Query:
    • Multicolumns in result list enabled
    • Query for dates for birth and death included
    • Remember query settings enabled
    • Optimizing enabled
    • Display columns added (Type, City, Country)

 

Datebase updates

  • 02.01.20: ProjectUser: new column [ReadOnly]; New view PublicIdentifier showing public content of AgentIdentifier; Table AgentDescriptor - FK for DescriptorType if missing;
  • 02.01.21: ProjectList: Add ReadOnly; Ensure result despite of loops for functions AgentChildNodes, AgentTopID, AgentHierarchyAllSuperior, AgentAddress and AgentHierarchy; ProjectProxy: new columns [RowGUID], [LastChanges], [IsLocked]; New views AgentID_FullAccess, AgentID_Locked, AgentID_ReadOnly and AgentID_AvailableReadOnly;
  • 02.01.22: new table LanguageCode_Enum; Table Agent - new column Language including Agent_log, trgDelAgent and trgUpdAgent; procInsertAgentCopy - new column ContentLanguage; AgentChildNodes - new column ContentLanguage; AgentHierarchy - new column ContentLanguage; AgentSynonymTopID - ensure result despite of loops; AgentSynonymyChildNodes - Optimized, ensure result despite of loops and new column ContentLanguage; AgentSynonymy - ensure result despite of loops and new column ContentLanguage; AgentSuperiorList - new column ContentLanguage; AgentTopID: ensure result despite of loops; AgentSuperiorList: ensure result despite of loops and not IgnoreButKeepForReference; AgentHierarchyAllSuperior: ensure result despite of loops;
  • 02.01.23 Missing descriptions for tables, trigger, views;

 

Libraries - DiversityWorkbench

The chapters below describe features that are available in several modules of the Diversity Workbench resp. provided via a shared library like DiversityWorkbench.dll

DiversityWorkbench

Upcoming version

4.2.13

  • Export wizard
    • Bugfix searching for parent of start table
  • Query
    • Bugfix when QueryMainTableLocal is null

Current version

4.2.12

  • Import wizard
    • Bugfixes for duplicate check if no data are available
  • Export wizard
    • Bugfixes if no data are available in parent table
    • Showing generated SQL commands

Previous versions

4.2.11

  • Import wizard
    • Bugfixes for duplicate check for data containing ’ in values of checked column
    • Bugfixes for column pre- and postfix containing ’ in values
    • Option to prevent insert into column
    • Description for columns expanded and redesigned
  • Bugfixes setting linked servers
  • JsonCache: New interface for the modules containing a json summary for datasets

4.2.10

  • Webservice Catalogue of Life available
  • Several bugfixes

4.2.9

  • UserControlQueryList: Dropdownwidth for column selection set to 200 to ensure readablility

4.2.8 (2023-08-30)

  • UserControlQueryList - bugfix if for readonly no valid boolean expression is returned
  • Documentation
    • Bugfix - Listing objects
    • Bugfix - Setting title
    • Bugfix - Selecting schema
    • Bugfix init HUGO replacements

4.2.7 (2023-08-17)

  • Formfunctions
    • Bugfix missing command in function public bool initSqlAdapter(ref System.Data.SqlClient.SqlDataAdapter Adapter, string SQL, System.Data.DataTable Table)
    • Bugfix WorkbenchUnit in function public static string getDatabaseNameFromURI(string URI)
    • Bugfix Project.cs - using ViewBaseURL instead of function or linked server
  • Archive
    • Optional inclusion of log tables
    • Bugfixes resetting database
    • Several bugfixes getting data
    • Several bugfixes restoring archive
    • Progress bars included
    • Extension for setting specific query to get IDs for temp table

4.2.6 (2023-08-01)

  • Documentation
    • Bugfix listing objects
    • HUGO
      • Export of enumeration table content
  • Updating depending datasets Video starten.
    • Context menu:
      • Adding current dataset.
      • Adding all datasets from the list.
      • Showing content of the list.
      • Clearing the list.
  • Bugfix setting backlinks for DiversityCollection linked to DiversityAgents
  • Bugfix setting SQL for backlink updates
  • Bugfix setting backlinks for DiversityProjects linked to DiversityAgents
  • Bugfix setting images in tree of FormEnumAdministration
  • FormFunctions: public static string IsoDate(string Text, bool SpaceAsSeparator = true, bool RestrictToDate = false) expanded with optional restriction to date

4.2.5 (2023-07-25)

  • TableEditor:
    • Bugfix in initForm
  • Enumeration administration:
    • Table editor included
  • Agent - Bugfix getting synonyms in unit values
  • Formfunctions - Autocompletion - Bugfix missing Alias for table
  • Documentation
    • HUGO
      • Export as markdown for HUGO included
      • Replacements and adaptions for HUGO included
  • Spreadsheet:
    • Optional inclusion of RowGUID for tables where PK should be edited Video starten
    • Hiding RowGUID by default

4.2.4 (2023-07-12)

  • FormFunctions:
    • public static string IsoDate(string Text, bool SpaceAsSeparator = true)
  • Documentation:
    • Default output set to HUGO
    • HUGO output
      • Index removed
      • Application objects removed
      • ER-diagram located underneath table header
      • Bugfix ER-diagram path
      • Bugfix Enum output
      • Include menu icon

WpfControls

Current version

1.0.1

  • Bugfix rescanning image if values for height and width are missing
  • Showing message for button ShowDetail if no detail is defined

Subsections of Download

Diversity Agents

Installation

Resources

To run a module of the Diversity Workbench framework, you need access to a database and an installation of the respective client. The following instructions explain how to install the DiversityCollection client. All other modules are installed in the same way.

If you do not yet have an account for your institutional DWB platform, please contact your institution’s DWB administrator. If you wish to set up and use your own personal, institutional, domain-specific, or research-group-internal database environment, see Installation of a database for more information.

A German-language video demonstrates the installation using the DC client as an example. Please note that the initial steps in the video are outdated, as the downloads are now available via this manual, as described below. .

Download

All DiversityWorkbench modules can be downloaded free of charge. Within each module in the manual, you will find a Download menu item. There, you can download the latest version in the Current version section.

Installation of the client

The client is currently based on the .Net framework version 4.8 from Microsoft. If not already present, the software will prompt you to install it.

After downloading the client, unzip the .zip folder. The extracted setup folder contains two files: an .msi and a .bat file.

If you want to install the client on your computer, start the installation by double-clicking the .msi file.

If necessary, you can adjust the installation location in the next step.

Once the installation is complete, the software will be added to the program menu (see below) and a shortcut will be created on the desktop.

In the next chapter Database Login the login process is explained.

Troubleshooting

If you don’t have sufficient permissions on your computer to install anything, you can use the client by following the instructions Run the program without an installer. If you receive a warning from Windows that this computer is protected, follow the instructions Windows protection warning.

Run program without installer

There are several reasons why you might prefer to run DiversityCollection without installation. E.g. if you lack administrative permissions on your computer or if you want to use several different versions of DiversityCollection in parallel.

Therefore, the downloaded .zip file contains a .bat file. With this .bat file, a folder DiversityCollection_x_x_x is created on your desktop containing all relevant files to run the client DiversityCollection.

You have to unzip the downloaded .zip file to a local folder. The unzipped folder contains the .msi file and the .bat file. Within this unzipped! folder start the .bat file with a double-click. You might get a security warning, as shown in the section Windows protection warning.

The batch file unpacks the program files to a folder on your desktop named DiversityCollection_x_x_x, where "x_x_x" stands for the program version.

To start the DiversityCollection program, go to the folder and double-click on the file DiversityCollection.exe.

The login process is explained in the next chapter Database Login.

Technical notes and additional information

The software will be placed in the programs directory, as shown below.

Additionally, a folder is created in the user directory. This folder contains files and templates, for example, for label printing. It also contains hidden folders, such as Query. User input is saved there so that it can be loaded again the next time the program is started.

Windows protection warning

If you receive the following warning from Windows

please click on Weitere Informationen. A button Trotzdem ausführen will appear.

Please click on Trotzdem ausführen to install the software.