DiversityProjects
DiversityProjects (DP-DWB) is an application component of the database framework Diversity Workbench. It might be installed as part of a DWB environment, but also be used as a stand-alone application, e. g., in a local installation. Each DWB module is devoted to a specific data domain.
DiversityProjects is focused on the management of (research) projects as well as data collections, data packages/ datasets processed by the other DWB modules. It is designed to manage metadata, labels, descriptors, titles and descriptions of the projects and data packages, including data package-specific settings for the data exchange standard compliant publication of data packages. DP is managing core information on data package-related publications as well as the (internal) storage of (legal) documents, e. g., ABS documents, and multimedia resources. Its functions include the handling of roles of persons and organisations/ institutions involved in collection and research projects. DP is organising project classification and data package hierarchy in relation to sister and umbrella projects as well as the storage of each type of stable identifier related to the data packages. Furthermore, it is managing issues on permits, licenses and web presentation of projects. Data of other realms like, e. g., the management of details on single data units, on agents/ users (persons or organisations/ institutions) and of details on references are handled in separate modules. For an overview of the available modules see the Diversity Workbench Main Page.
Contents
Software
Online manual
The manual is provided as pdf file (for current version check DWB user manuals). The compiled help file in CHM (= MS online help format) is included in the zip archive with the download of the client application.
Client application
Current version
The client application is built for Microsoft .Net Framework 3.5 or higher. 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).
New features and fixes:
- Improvements and bugfixes in DiveristyWorkbench core functionalities
- Download the .Net framework (see General Download Notes)
Previous versions
These client applications are built for Microsoft .Net Framework 3.5 or higher. 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).
New features and fixes:
- Optional encryption of SQL server connection (activated by default)
- Inclusion of webservices of GFBio and GBIF
- Inclusion of descriptors in export wizard
- Blocking change of descriptor type for module-linked entries
- Several bugfixes
Database updates
- Database update to version 2.1.20: New types for Descriptor; Missing descriptions
New features and fixes:
- Bugfix showing descriptors when changing position in tree
Database updates
- Database update to version 2.1.18: Language_Enum including content; New Tables ProjectDescriptor and ProjectDescriptorElement + log tables and trigger; Insert elements Keyword and Label into ProjectDescriptorElement; Transfer data from tables ProjectLabel and ProjectKeyword to new table ProjectDescriptor
- Database update to version 2.1.19: Bugfix in delete trigger for table ProjectDescriptor
New features and fixes:
- Integration of table editors for keywords, label and resources
- Button for opening resources
- Button for adding web resources
- GFBio Metadata Ingestion Tool indicating import behaviour
- Project - Interface for other modules testing existence of stable identifier base
- Bugfix starting application
- Bugfix opening resource files (missing dll)
- Setting the notes for Identifier
- Saving data when inserting agent to ensure consistency
- Bugfix showing author roles
- Login according to EU-DSGVO
- Bugfix synchronizing keywords with selection of project in hierarchy
- Bugfixes creating documentation for functions and roles
- GFBio import:
- New implementation using JavaScriptSerialize instead of handmade JSON parsing.
- ProjectLabels are now extracted from the single comma-separated JIRA text line.
- ProjectKeywords are now filled from JIRA categories (extracted from the single comma-separated JIRA text line).
- ProjectLicense - LicenseURI is now preliminarily set fix to CC BY 3.0 LicenseURI.
- ProjectSettings: Multiple values for MetadataDescription or LegalRestrictions will be numbered now (added index).
- ProjectLicense - Holder and IPR as User defined values.
- Identifier - Checking for availibility of type and inclusion of type
- Check if name of the project already exists
- Import agent role in separate table
- Block import after import for the current data is finished
- Ignoring settings with missing values
- Check for missing settings
- Inclusion of URL for GFBioIssueID
Database updates
- Database update to version 2.1.13: ProjectReference - ReferenceTitle -> nvarchar(500); ProjectKeyword (+ log, trigger); ProjectReference: new description for IsCitation
- Database update to version 2.1.14: ProjectAgentRole (+ log, trigger); Transfer of data into new table
- Database update to version 2.1.15: ProjectDefinition and ViewProject: removing missing columns
- Database update to version 2.1.16: Submitter as new role for agents
- Database update to version 2.1.17: UserProxy - Add ID, PrivacyConsent and PrivacyConsentDate - according to EU-DSGVO; Function providing the ID of the user from UserProxy; UserProxy - Trigger for setting PrivacyConsentDate; Function PrivacyConsentInfo providing common information with the DiversityWorkbench; Grants for table ProjectLabel; Missing grants for log tables
New features and fixes:
- Project reference: Title extended to 500
- Project reference - Citation: Bugfix
- Single agents with multiple roles
- Labels for project
- Keywords for project
- Integration of the GFBio Metadata Ingestion Tool in the DP client
- Inclusion of empty type for description in drop down
Database updates
- Database update to version 2.1.13: ProjectReference - ReferenceTitle -> nvarchar(500); ProjectKeyword (+ log, trigger); ProjectReference: new description for IsCitation
- Database update to version 2.1.14: ProjectAgentRole (+ log, trigger); Transfer of data into new table
New features and fixes:
- Project reference: Title extended to 500
- Project reference - Citation: Bugfix
- Single agents with multiple roles
- Labels for project
- Keywords for project
- Integration of the GFBio Metadata Ingestion Tool in the DP client
- Inclusion of empty type for description in drop down
Database updates
- Database update to version 2.1.13: ProjectReference - ReferenceTitle -> nvarchar(500); ProjectKeyword (+ log, trigger); ProjectReference: new description for IsCitation
- Database update to version 2.1.14: ProjectAgentRole (+ log, trigger); Transfer of data into new table
New features and fixes:
- Table ProjectIdentifier
- Table ProjectReference - new Column ReferenceType
- Table editors for ProjectLicense, ProjectReference and ProjectIdentifier
- Deleting empty data: Bugfixes
- Adapting form to read only access
- Database update to version 2.1.5: ProjectIdentifierType, -log and triggers, ProjectIdentifier, -log and triggers
- Database update to version 2.1.6: Change Citation in table ProjectReference into ReferenceType
New features and fixes:
- Table editors for tables Project and ProjectAgent
- Tabel editors - bugfix
- Sequence for agents
- Database update to version 2.1.4: Adding AgentSequence to table ProjectAgent, -log and triggers, changing the default for the log columns
New features and fixes:
- Several bugfixes
New features and fixes:
- Transfer of settings into new table structure
- Transfer of license into new table
- Several bugfixes
- Database update to version 2.1.0: New table for license and transfer of the license data from the main table
- Database update to version 2.1.1: New tables for settings and complementary functions as well as transfer of the setting data from the main table
- Database update to version 2.1.2: Filling agent roles, new table for agent types, function for hierarchy retrieval
- Database update to version 2.1.3: Adding missing grants, fixing reference trigger and copyfunction
New features and fixes:
- Database update to version 2.0.7: Adding grants for ProjectReference
New features and fixes: Start of application: Bugfix
New features and fixes:
- Inclusion of tools for the database
- Inclusion of references for the project
- Database update to version 2.0.6: Adding table ProjectReference
New features and fixes:
- Adding agents: Bugfix
- Update to Database version 2.0.5
New features and fixes:
- Query: Bugfix
- Deleting projects: Bugfix (Database version 2.0.4)
New features and fixes:
- Administration of the database: Renaming of the current database; setting of the published address (BaseURL)
- Client software 3.0.0.4, July 24th, 2013
- Client software 3.0.0.1, April 8th, 2013
Database
The database is built for Microsoft SQL Server 2008 R2. Please make sure you have the correct version of this software already installed on your computer! (Check under control panel -> Software for Microsoft SQL Server).
- Download the Database 02.00.02
Database server
- Download the SQL Server (see General Download Notes)
(See also DiversityProjects Information Models and General Download Notes.)
