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.2.6 (zip archive), 2017/10/27

New features and fixes:

  • Insert of projects: Bugfix
  • Export wizard
  • Setting stable identifier
  • LicenseID made visible
  • Menu - bugfix showing menu Administration
  • New columns for table Project
  • New columns for table ProjectReference
  • Separated list for citations and references
  • New column Citation for references
  • New column Type for project description
  • Menu for database tools restricted
  • Database tools - bugfix for descriptions of procedures and functions
  • Database documentation - including views, procedures and functions
  • Automatic setting of agentsequence if missing


Database updates

  • Database update to version 2.1.7: Adding roles curator and author, grants for ProjectIdentifier and ProjectIdentifierType, Project -> nvarchar(255)
  • Database update to version 2.1.8: Grants for ProjectIdentifier; StableIdentifier; Adding views for linked server: ViewBaseURL, ViewDiversityWorkbenchModule, ViewProject; Project_Core: cast(P.ProjectSettings as nvarchar(max)) for use in linked server
  • Database update to version 2.1.9: Project: adding ProjectType; ProjectType_Enum; Adding types and update of present data; Adaption of trigger of table Project; ViewProject: adding StableIdentifier
  • Database update to version 2.1.10: Project: adding InternalDescription, PublicDescription, adaption of triggers and ViewProject; ProjectReference: adding IsCitation and URI, adaption of triggers; ProjectChildNodes - adding new columns; ProjectHierarchy - adding new columns
  • Database update to version 2.1.11: ProjectLabel including log table and trigger; New roles for Agent; Project - new description; new column ProjectDescriptionType in table Project; add column ProjectType in table Project_log im missing; add column ProjectDescriptionType in table Project_log if missing; adaption of triggers ProjectChildNodes and ProjectHierarchy, ViewProject; ProjectReference: adding ReferenceCitation, adaption of triggers; ProjectReference: new description for IsCitation
  • Database update to version 2.1.12: ProjectReference - new descriptions; ViewDataCitation; ViewLiteratureReference; Description of database roles; Description of stored procedures; Description of functions: BaseURL, DiversityWorkbenchModule, ProjectList, SettingHierarchyAll, etc.; Description of views;



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

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