Posts

Install OpenRose on Network Computer(s)

Image
Multi-user Corporate Network / Team installation of OpenRose - Requirements Management - An Open Source and FREE Requirements Management Application / Tool. This guide helps users to install all required software and components to run OpenRose on a network computer(s). It guides users to install  OpenRose WebUI front-end  OpenRose API back-end  SQL Server Database  on single / multiple network connected computer(s) and configure it.  Direct Link to YouTube Video :  https://www.youtube.com/watch?v=oL6jQQvn1oQ Video Transcript : Hello, Today we are going to talk about installing OpenRose in a network environment. The first scenario we will discuss is installing all the required components on a single computer, which could be a server or a desktop computer. We will start by making sure that the required components for OpenRose to run are present in the target environment. The reason for discussing this today is to provide an overview of how this installati...

SQL ‐ Script to add IIS APP Pool user in SQL Server Database

Image
IIS is Internet Information Services in which one could host OpenRose API and OpenRose WebUI projects. OpenRose API connect to the SQL Server database mainly for CRUD (Create, Read, Update and Delete) operations. For this purpose, IIS user has to be authenticated in SQL Server. To be able to do that, Microsoft provides support for adding IIS App Pool user into SQL Server Database as Windows Identity. Following script is designed to help users to create IIS App Pool account to be added first into SQL Server and then as database owner for OpenRose database. This way, It's possible to use this user to establish communication between OpenRose API and SQL Server OpenRose Database. NOTE : We have tested below scripts in our test environment and it's provided on an "As Is" basis. OpenRose team does not guarantee it's workings and outcomes. Person running script script in SQL Server has to have sysadmin and dbowner role for SQL Server and the Database respectively ...

Install OpenRose on Standalone Computer

Image
  Personal Installation of  OpenRose - Requirements Management - An Open Source and FREE Requirements Management Application / Tool. This guide helps users to install all required software and components to run OpenRose on a single computer. It guides users to install  OpenRose WebUI front-end  OpenRose API back-end  SQL Server Database  on single computer and configure it. Direct Link to YouTube Video :  https://www.youtube.com/watch?v=yuGIZtxsXIA Video Transcript : Hi, today we are going to talk about the `Standalone Installation of OpenRose`. By "Standalone", I mean it will be installed on a single Windows computer and will be accessible locally on that specific machine.  To run any .NET application, you will need to install the .NET runtime. OpenRose currently runs on .NET Version 9.x, so you will need the .NET runtime version 9.x. Here is the download link: Download .NET 9.0 . For a standalone installation, you will require the x64 runtim...

Agile Loves Clear Requirements

Image
  Agile Loves Clear Requirements OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video :  Agile Loves Clear Requirements Video Transcript : Today, I would like to talk about the importance of requirements in project delivery or product delivery, especially when using Agile methodologies like Scrum or Kanban. In the Scrum ways of working, we have user stories that are put into the Sprint backlog. From the Sprint backlog, the team pulls out certain user stories for a given Sprint, which could be a two to four-week Sprint. During this Sprint, the team has daily standups to discuss progress and blockers. At the end of the Sprint, it is expected that the team will deliver a product increment, which could be a service delivery or a product delivery. Let's consider a project where we have team members, represented by circles. The size of the circle indicates their knowledge, seniority, experience, and sk...

Breadcrumbs - Requirements Management

Image
  Breadcrumbs - Requirements Management  OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video : Breadcrumbs - Requirements Management Video Transcript : Welcome to OpenRose, an open-source and free requirements management application. Find more information at GitHub - OpenRose . Today, we are going to talk about breadcrumbs. The question that comes to mind is how requirements management and breadcrumbs are related in anyways. Let me start by explaining that breadcrumbs are a concept in software applications whereby we can show how far deep in the hierarchy we have gone when working with structured data. OpenRose has two different possibilities for using breadcrumbs: as a technical enabler or as a visualization of data to indicate where you are in the Project or Baseline hierarchy. Let me start by going into our projects. Here we have the "Barclays terrif for Personal Customers" project, which I ...

Requirement Baseline Details View

Image
  Requirement Baseline Details View OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video :  Baseline Details View - Requirements Management - YouTube Video Transcript : Hi and welcome to OpenRose, a FREE and Open-Source requirements management application. You can find more information about the same at OpenRose - FREE Requirements Management Application .  Today, we are going to talk about Baseline requirements in Detail View.  Let's dive into the project titled Barclays tariff for personal customers and take a look at the tree view. First, it has well-organized requirements, and at the project level, we can see existing baselines or create new ones by project or Item Type. We have already created January and February Baselines, which are based on the entire project, as well as Loans January and Loans February Baselines, which are based on specific Item Types. Let's explore January 202...

Clone Baseline - Requirements Management

Image
  Clone Baseline - Requirements Management OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video : https://www.youtube.com/watch?v=mBbspg6X5hk Video Transcript : Hi, welcome to OpenRose, a free and open-source requirements management application. Find more information at https://github.com/openrose . Today we are going to talk about cloning baselines. Let's first go to the project "Bay St" for the personal customer project and expand the project to see all its data. Currently, we have the first requirement "What's covered by the Tariff," traced down to "Eligibility for Premier Banking," which is also traced further down to "Premier Current Account," which is inside "Borrowing from Us." The Premier Current Account also has a parent link to a Parking Lot item, which is "Bas Mortgage Arrangement Fees." This is something Bas is looking into, b...

Baseline Requirements Include and Exclude

Image
  Baseline Requirements Include and Exclude OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video : https://www.youtube.com/watch?v=UWvSL5pjYS4 Video Transcript : Hi, welcome to OpenRose, a free and open-source requirements management application. Get more information at https://github.com/openrose . Today we are going to talk about including and excluding requirements within the baseline. To learn more about baselining, please look at the Baseline Introduction video. Let's go to Projects, and there we will connect to our sample project, "Bay St for Personal Customers." This project has a well-structured set of requirements. A baseline is nothing but a snapshot of our data. Before we take the snapshot of this project, let's have a quick look at the first requirement here, "What's covered by the Tariff," which has a traceability to "Eligibility for Premier Banking."...

Concept of Baseline Requirements

Image
  Concept of Baseline Requirements OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video : https://www.youtube.com/watch?v=AYkIypRys6E Video Transcript : Hi, welcome to OpenRose, a free and open-source requirements management application. Get it from https://github.com/openrose . Today, we are going to talk about baselines and the concepts of baselining. Instead of doing a detailed product demo, we will discuss the theoretical aspects of baselining. I'm going to switch over to Paintbrush—not the best tool for designing, but I like using it for discussion and presentation purposes. Let's consider that a user has a project, represented by this box. In this project, they have defined several requirements, drawn as lines. These requirements can be nested in a hierarchy or have a flat structure with detailed information defined hierarchically. These requirements are captured as part of the breakdown s...

Move Itemz Type - Requirements Management

Image
  Move Itemz Type - Requirements Management OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video : https://www.youtube.com/watch?v=3R8CX9Vj6HM Video Transcript : Hello, this is OpenRose, a free requirements management application. You can find it at https://github.com/openrose . Today we are going to talk about moving item types. Let me go into the project list and open the first project. This is a sample project that I have created based on a document published by Barclays Bank regarding tariffs for personal customers. Here is the link to that document. I have tried converting part of that document into the structure in this project where we have around five item types. Let me talk about the "About Our Tariff" item type. When I expand that, we can see requirements or items sitting under that item type. Looking at the first requirement, we can see it has the name, status, priority, severity, a...