# Idea OP-4231 - Designation Database

Project: OpenProject
Status: new
URL: https://community.openproject.org/work_packages/OP-4231

## RICE

| Attribute | Value |
| --- | --- |
| Reach |  |
| RICE Score |  |
| Votes |  |

## Requires

_No work packages_

## People

| Attribute | Value |
| --- | --- |
| Assignee | Niels Lindenthal |
| Accountable |  |
| Product manager |  |

## Details

| Attribute | Value |
| --- | --- |
| Roadmap |  |
| Date |  |
| Target versions | Wish List |
| Module |  |
| Priority | Medium |
| List |  |
| Interest by |  |
| Labels |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| PD (min) |  |
| PD (max) |  |

## Description

OpenProject allows the user to set particular characteristics for a worktype - priority, person it’s assigned to, due date, etc.. However in this structure, there isn’t a way to attach the item (feature, bug, task, etc.) to a larger database of items. Examples of a larger database of items could be an asset management database or a database of standards which a new piece of functionality must address.

An example of a Designation Database in OpenProject is an asset management database. Let’s say my asset management database has 10 servers in it. When I implement a new piece of functionality, my project needs to make sure there is a task for each of those servers.

The user experience would look like this: The user goes to the asset management system and exports a CSV. The user goes to OpenProject and imports the CSV into the Designation Database. OpenProject would ask the user how to deal with duplicates and data which is currently in the Designation Database but not in the upload file. OpenProject completes the upload of the new data to the Designation Database.

The user goes to their project and creates a new task. One of the characteristics assigned to the task (in addition to priority, date due, etc) is the Designation Database. The user selects the first server and saves. The user creates a new task following the same process as before. This time the user selects the second server. At the end of the process, the user has 10 tasks in the project, each one associated to one of the 10 servers in the Designation Database.

The user would be able to export data from OpenProject and from their asset management system to analyze if there were assets which were not addressed in the project and should have been, or need to be addressed in future projects.

This functionality is particularly important in my line of work, though it would connect with a standards database rather than an asset management database.

I am a teacher evaluating OpenProject for use in tracking student work at a school which uses Project Based Learning (PBL). I have a database of standards (the Common Core) and every project a student does needs to address at least some of the standards. At the end of the school year, I need to run a report which shows 1) the standards addressed by each project and 2) which standards were not addressed by any of the projects done during the year. This reporting is the same as showing which assets were modified in each project and which assets were not involved in any of the project.

The Designation Database could be used in a number of different ways. I have described an asset management database and a database of educational standards. It could also be used for things like a sales database of products, a client database, etc.. (This documentation replaces and further describes the info found in Feature <mention class="mention" data-id="26409" data-type="work_package" data-text="#26409">#26409</mention>, which was rejected due to a lack of information.)

Thanks,  
— Markus
