DiversityProjects

From Diversity Workbench
Jump to: navigation, search
DiversityProjects © SNSB IT Center

DiversityProjects 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 projects, subprojects as well as data collections and data packages/ datasets processed by the other modules of the Diversity Workbench. It is designed to document basic information, labels, descriptions and metadata on the projects and data packages, including data package-specific settings for the data exchange standard compliant publication of data packages. DiversityProjects is managing core information on data package-related publications as well as the (internal) storage of (legal and administrative) documents, e. g., ABS documents, and multimedia resources. Its functionality includes the documentation of the roles of persons and institutions involved in collection and research projects. DiversityProjects addresses the management of 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 institutions) and of details on references are handled in separate modules. For an overview of the available modules see the Diversity Workbench Main Page.

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

Download the Client software 3.0.3.2 (zip archive), 2018/05/03

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



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


Download the Client software 3.0.3.0 (zip archive), 2018/04/24

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


Download the Client software 3.0.2.8 (zip archive), 2018/01/22

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


Download the Client software 3.0.2.7 g (zip archive), 2018/01/17

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


Features of the Client software 3.0.2.4, October 26th, 2016

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
Features of the Client software 3.0.2.2, May 30th, 2016

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
Features of the Client software 3.0.2.1, October 2nd, 2015

New features and fixes:

  • Several bugfixes
Features of the Client software 3.0.2.0, June 23nd, 2015

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
Features of the Client software 3.0.1.0, October 17th, 2014

New features and fixes:

  • Database update to version 2.0.7: Adding grants for ProjectReference
Features of the Client software 3.0.0.9, September 12th, 2014

New features and fixes: Start of application: Bugfix

Features of the Client software 3.0.0.8, September 9th, 2014

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
Features of the Client software 3.0.0.7, August 26th, 2014

New features and fixes:

  • Adding agents: Bugfix
  • Update to Database version 2.0.5
Features of the Client software 3.0.0.6, January 16th, 2014

New features and fixes:

  • Query: Bugfix
  • Deleting projects: Bugfix (Database version 2.0.4)
Features of the Client software 3.0.0.5, August 1st, 2013

New features and fixes:

  • Administration of the database: Renaming of the current database; setting of the published address (BaseURL)

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

Database server



(See also DiversityProjects Information Models and General Download Notes.)