narrowizard opened a new issue, #8446:
URL: https://github.com/apache/incubator-devlake/issues/8446

   ### Search before asking
   
   - [x] I had searched in the 
[issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and 
found no similar feature requirement.
   
   
   ### Use case
   
   Many organizations use diverse or custom-built issue tracking systems that 
are not natively supported by dedicated DevLake plugins. The "Customize" plugin 
currently allows importing issues and issue_repo_commits via CSV, which is a 
valuable first step. However, to gain comprehensive insights into the issue 
tracking domain (similar to what's possible with natively supported tools like 
Jira), users need to import related data such as issue history, worklogs, and 
sprint information.
   
   By expanding the Customize plugin's CSV import capabilities, users could:  
   1. Ingest data from any unsupported third-party or in-house issue tracking 
system.
   2. Perform a complete analysis of their issue lifecycle, including status 
transitions, resolution times, and bottlenecks (using issue_changelogs).
   3. Track and analyze effort spent on tasks and projects (using 
issue_worklogs).
   4. Monitor sprint progress, team velocity, and scope changes (using sprints 
and linking them to issues).
   5. Fully leverage DevLake's dashboards and analytical features for the issue 
tracking domain, regardless of the source system.
   
   ### Description
   
   The "Customize" plugin is a powerful tool for ingesting data into DevLake's 
domain layer. Currently, for the issue tracking domain, it supports CSV import 
for the `issues` and `issue_repo_commits` entities.
   
   This feature request proposes to extend the capabilities of the Customize 
plugin to allow CSV import for the following additional issue tracking domain 
entities:
   
   1.  **`issue_changelogs`**: To capture the historical changes of issues 
(e.g., status updates, assignee changes, priority modifications). This would 
require defining a CSV schema for `issue_changelogs`.
   2.  **`issue_worklogs`**: To import time tracking data associated with 
issues (e.g., who logged time, how much time, and when). This would require 
defining a CSV schema for `issue_worklogs`.
   3.  **`sprints`**: To import sprint information (e.g., sprint name, start 
date, end date, status). This would require defining a CSV schema for `sprints`.
   
   Additionally, to effectively link issues to their respective sprints, we 
propose adding a new field to the existing `issues.csv` schema:
   
   *   **`sprints` field in `issues.csv`**: This field (e.g., storing a list of 
sprint IDs or names) would allow an issue to be associated with one or more 
sprints during the CSV import process.
   
   **Expected Outcome:**
   With these enhancements, users will be able to:
   *   Prepare CSV files for `issues`, `issue_changelogs`, `issue_worklogs`, 
and `sprints` extracted from their unsupported issue tracking systems.
   *   Use the Customize plugin's API to import this data into the 
corresponding DevLake domain layer entities.
   *   Utilize DevLake's full suite of issue tracking dashboards and analytical 
capabilities (e.g., lead time, cycle time, sprint velocity, bug trends) for 
data sourced via CSV.
   
   This will significantly increase the flexibility of DevLake and allow a 
broader range of users to consolidate and analyze their development data for 
engineering excellence.
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [x] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [x] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to